Opened 6 years ago

Closed 6 years ago

#11320 closed Bug Report - Hang/Deadlock (Invalid)

Too Many DB Connections

Reported by: jlatz@… Owned by: Rob Smith
Priority: minor Milestone: unknown
Component: Plugin - MythWeb Version: 0.26-fixes
Severity: medium Keywords:
Cc: Ticket locked: no

Description

I was simply surfing using Mythweb. I have to sit patiently for a minute or two to wait until whatever kicked off all the DB queries dies...

Please attach all output as a file in bug reports. MythTV Version : v0.26.0-70-gff4edc7 MythTV Branch : fixes/0.26 Network Protocol : 75 Library API : 0.26.20120822-1 QT Version : 4.8.1 Options compiled in:

linux profile use_hidesyms using_alsa using_oss using_pulse using_pulseoutput using_backend using_bindings_perl using_bindings_python using_bindings_php using_crystalhd using_dvb using_firewire using_frontend using_hdhomerun using_ceton using_hdpvr using_iptv using_ivtv using_joystick_menu using_libcec using_libcrypto using_libdns_sd using_libxml2 using_lirc using_mheg using_opengl_video using_qtwebkit using_qtscript using_qtdbus using_v4l2 using_x11 using_xrandr using_xv using_bindings_perl using_bindings_python using_bindings_php using_mythtranscode using_opengl using_vaapi using_vdpau using_ffmpeg_threads using_live using_mheg using_libass using_libxml2

datetime: 2013-01-02 12:24:37 (PST) errornum: 256

error type: User Error

error string: !NoTrans: Too many connections #1040

Backtrace Array (

[0] => Array

(

[file] => /usr/share/mythtv/mythweb/classes/Database/Query/mysql.php [line] => 63 [function] => error [class] => Database [object] => Database_mysql Object

(

[dbh] => [error] => Too many connections #1040 [err] => Too many connections [errno] => 1040 [last_sh] => Database_Query_mysql Object

(

[dbh] => [query] => Array

(

[0] => SET NAMES utf8;

)

[last_query] => SET NAMES utf8; [warnings] => Array ( ) [num_args_needed] => 0 [num_rows] => [affected_rows] => [insert_id] => [db] => Database_mysql Object

*RECURSION*

)

[fatal_errors] => 1 [query_count] => 0 [query_time] => 0 [global_name] => [destruct_handlers] => Array ( )

)

[type] => -> [args] => Array ( )

)

[1] => Array

(

[file] => /usr/share/mythtv/mythweb/classes/Database.php [line] => 261 [function] => execute [class] => Database_Query_mysql [object] => Database_Query_mysql Object

(

[dbh] => [query] => Array

(

[0] => SET NAMES utf8;

)

[last_query] => SET NAMES utf8; [warnings] => Array ( ) [num_args_needed] => 0 [num_rows] => [affected_rows] => [insert_id] => [db] => Database_mysql Object

(

[dbh] => [error] => Too many connections #1040 [err] => Too many connections [errno] => 1040 [last_sh] => Database_Query_mysql Object

*RECURSION*

[fatal_errors] => 1 [query_count] => 0 [query_time] => 0 [global_name] => [destruct_handlers] => Array ( )

)

)

[type] => -> [args] => Array

(

[0] => Array ( )

)

)

[2] => Array

(

[file] => /usr/share/mythtv/mythweb/classes/Database.php [line] => 124 [function] => query [class] => Database [object] => Database_mysql Object

(

[dbh] => [error] => Too many connections #1040 [err] => Too many connections [errno] => 1040 [last_sh] => Database_Query_mysql Object

(

[dbh] => [query] => Array

(

[0] => SET NAMES utf8;

)

[last_query] => SET NAMES utf8; [warnings] => Array ( ) [num_args_needed] => 0 [num_rows] => [affected_rows] => [insert_id] => [db] => Database_mysql Object

*RECURSION*

)

[fatal_errors] => 1 [query_count] => 0 [query_time] => 0 [global_name] => [destruct_handlers] => Array ( )

)

[type] => -> [args] => Array

(

[0] => SET NAMES utf8;

)

)

[3] => Array

(

[file] => /usr/share/mythtv/mythweb/includes/database.php [line] => 49 [function] => connect [class] => Database

[type] =>
[args] => Array ( [0] => mythconverg [1] => mythtv [2] => 0Zgr9qkB [3] => Mythbox [4] => [5] => mysql )

)

[4] => Array

(

[file] => /usr/share/mythtv/mythweb/includes/init.php [line] => 40 [args] => Array

(

[0] => /usr/share/mythtv/mythweb/includes/database.php

)

[function] => require_once

)

[5] => Array

(

[file] => /usr/share/mythtv/mythweb/mythweb.php [line] => 20 [args] => Array

(

[0] => /usr/share/mythtv/mythweb/includes/init.php

)

[function] => require_once

)

) !!

filename: /usr/share/mythtv/mythweb/classes/Database/Query/mysql.php

error line: 64

==========================================================================

Backtrace:

file: /usr/share/mythtv/mythweb/classes/Database/Query/mysql.php line: 64

class:

function: trigger_error

type: args: Array

(

[0] => Too many connections #1040

Backtrace Array (

[0] => Array

(

[file] => /usr/share/mythtv/mythweb/classes/Database/Query/mysql.php [line] => 63 [function] => error [class] => Database [object] => Database_mysql Object

(

[dbh] => [error] => Too many connections #1040 [err] => Too many connections [errno] => 1040 [last_sh] => Database_Query_mysql Object

(

[dbh] => [query] => Array

(

[0] => SET NAMES utf8;

)

[last_query] => SET NAMES utf8; [warnings] => Array ( ) [num_args_needed] => 0 [num_rows] => [affected_rows] => [insert_id] => [db] => Database_mysql Object

*RECURSION*

)

[fatal_errors] => 1 [query_count] => 0 [query_time] => 0 [global_name] => [destruct_handlers] => Array ( )

)

[type] => -> [args] => Array ( )

)

[1] => Array

(

[file] => /usr/share/mythtv/mythweb/classes/Database.php [line] => 261 [function] => execute [class] => Database_Query_mysql [object] => Database_Query_mysql Object

(

[dbh] => [query] => Array

(

[0] => SET NAMES utf8;

)

[last_query] => SET NAMES utf8; [warnings] => Array ( ) [num_args_needed] => 0 [num_rows] => [affected_rows] => [insert_id] => [db] => Database_mysql Object

(

[dbh] => [error] => Too many connections #1040 [err] => Too many connections [errno] => 1040 [last_sh] => Database_Query_mysql Object

*RECURSION*

[fatal_errors] => 1 [query_count] => 0 [query_time] => 0 [global_name] => [destruct_handlers] => Array ( )

)

)

[type] => -> [args] => Array

(

[0] => Array ( )

)

)

[2] => Array

(

[file] => /usr/share/mythtv/mythweb/classes/Database.php [line] => 124 [function] => query [class] => Database [object] => Database_mysql Object

(

[dbh] => [error] => Too many connections #1040 [err] => Too many connections [errno] => 1040 [last_sh] => Database_Query_mysql Object

(

[dbh] => [query] => Array

(

[0] => SET NAMES utf8;

)

[last_query] => SET NAMES utf8; [warnings] => Array ( ) [num_args_needed] => 0 [num_rows] => [affected_rows] => [insert_id] => [db] => Database_mysql Object

*RECURSION*

)

[fatal_errors] => 1 [query_count] => 0 [query_time] => 0 [global_name] => [destruct_handlers] => Array ( )

)

[type] => -> [args] => Array

(

[0] => SET NAMES utf8;

)

)

[3] => Array

(

[file] => /usr/share/mythtv/mythweb/includes/database.php [line] => 49 [function] => connect [class] => Database

[type] =>
[args] => Array ( [0] => mythconverg [1] => mythtv [2] => 0Zgr9qkB [3] => Mythbox [4] => [5] => mysql )

)

[4] => Array

(

[file] => /usr/share/mythtv/mythweb/includes/init.php [line] => 40 [args] => Array

(

[0] => /usr/share/mythtv/mythweb/includes/database.php

)

[function] => require_once

)

[5] => Array

(

[file] => /usr/share/mythtv/mythweb/mythweb.php [line] => 20 [args] => Array

(

[0] => /usr/share/mythtv/mythweb/includes/init.php

)

[function] => require_once

)

)

[1] => 256

)

file: /usr/share/mythtv/mythweb/classes/Database.php line: 261

class: Database_Query_mysql

function: execute

type: -> args: Array

(

[0] => Array ( )

)

file: /usr/share/mythtv/mythweb/classes/Database.php line: 124

class: Database

function: query

type: -> args: Array

(

[0] => SET NAMES utf8;

)

file: /usr/share/mythtv/mythweb/includes/database.php line: 49

class: Database

function: connect

type:
args: Array

(

[0] => mythconverg [1] => mythtv [2] => 0Zgr9qkB [3] => Mythbox [4] => [5] => mysql

)

file: /usr/share/mythtv/mythweb/includes/init.php line: 40

class:

function: require_once

type: args: Array

(

[0] => /usr/share/mythtv/mythweb/includes/database.php

)

file: /usr/share/mythtv/mythweb/mythweb.php line: 20

class:

function: require_once

type: args: Array

(

[0] => /usr/share/mythtv/mythweb/includes/init.php

)

==========================================================================

$_SESSION: Array (

[language] => English

)

==========================================================================

$_SERVER: Array (

[REDIRECT_HTTPS] => on [REDIRECT_SSL_TLS_SNI] => latz-torres.hobby-site.org [REDIRECT_STATUS] => 200 [db_server] => Mythbox [db_name] => mythconverg [db_login] => mythtv [db_password] => 0Zgr9qkB [HTTPS] => on [SSL_TLS_SNI] => latz-torres.hobby-site.org [SSL_SERVER_S_DN_C] => US [SSL_SERVER_S_DN_ST] => CA [SSL_SERVER_S_DN_L] => Valencia [SSL_SERVER_S_DN_O] => Latz-Torres Family [SSL_SERVER_S_DN_CN] => latz-torres.hobby-site.org [SSL_SERVER_I_DN_C] => US [SSL_SERVER_I_DN_ST] => CA [SSL_SERVER_I_DN_L] => Valencia [SSL_SERVER_I_DN_O] => Latz-Torres Family [SSL_SERVER_I_DN_CN] => latz-torres.hobby-site.org [SSL_VERSION_INTERFACE] => mod_ssl/2.2.22 [SSL_VERSION_LIBRARY] => OpenSSL/1.0.1 [SSL_PROTOCOL] => TLSv1.1 [SSL_SECURE_RENEG] => true [SSL_COMPRESS_METHOD] => NULL [SSL_CIPHER] => DHE-RSA-CAMELLIA256-SHA [SSL_CIPHER_EXPORT] => false [SSL_CIPHER_USEKEYSIZE] => 256 [SSL_CIPHER_ALGKEYSIZE] => 256 [SSL_CLIENT_VERIFY] => NONE [SSL_SERVER_M_VERSION] => 1 [SSL_SERVER_M_SERIAL] => B57D057A6919D2AE [SSL_SERVER_V_START] => Oct 9 05:00:22 2011 GMT [SSL_SERVER_V_END] => Oct 9 05:00:22 2021 GMT [SSL_SERVER_S_DN] => /C=US/ST=CA/L=Valencia/O=Latz-Torres Family/CN=latz-torres.hobby-site.org [SSL_SERVER_I_DN] => /C=US/ST=CA/L=Valencia/O=Latz-Torres Family/CN=latz-torres.hobby-site.org [SSL_SERVER_A_KEY] => rsaEncryption [SSL_SERVER_A_SIG] => sha1WithRSAEncryption [SSL_SESSION_ID] => 7C8FCFD24342931F08E58FD8B9C345243E25EB49144E7592F7C48C12602CCF1C [HTTP_HOST] => latz-torres.hobby-site.org [HTTP_CONNECTION] => keep-alive [HTTP_CACHE_CONTROL] => max-age=0 [HTTP_USER_AGENT] => Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_2) AppleWebKit?/537.11 (KHTML, like Gecko) Chrome/23.0.1271.101 Safari/537.11 [HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 [HTTP_DNT] => 1 [HTTP_ACCEPT_ENCODING] => gzip,deflate,sdch [HTTP_ACCEPT_LANGUAGE] => en-US,en;q=0.8 [HTTP_ACCEPT_CHARSET] => ISO-8859-1,utf-8;q=0.7,*;q=0.3 [HTTP_COOKIE] => mythweb_id=7qokkektbh9hstn0kvb9a3gdp7 [PATH] => /usr/local/bin:/usr/bin:/bin [SERVER_SIGNATURE] => <address>Apache/2.2.22 (Ubuntu) Server at latz-torres.hobby-site.org Port 443</address>

[SERVER_SOFTWARE] => Apache/2.2.22 (Ubuntu) [SERVER_NAME] => latz-torres.hobby-site.org [SERVER_ADDR] => 192.168.0.51 [SERVER_PORT] => 443 [REMOTE_ADDR] => 76.95.77.158 [DOCUMENT_ROOT] => /var/www [SERVER_ADMIN] => webmaster@localhost [SCRIPT_FILENAME] => /var/www/mythweb/mythweb.php [REMOTE_PORT] => 55909 [REMOTE_USER] => johnlatz [AUTH_TYPE] => Digest [REDIRECT_URL] => /mythweb/remote/keys [GATEWAY_INTERFACE] => CGI/1.1 [SERVER_PROTOCOL] => HTTP/1.1 [REQUEST_METHOD] => GET [QUERY_STRING] => [REQUEST_URI] => /mythweb/remote/keys [SCRIPT_NAME] => /mythweb/mythweb.php [PATH_INFO] => /remote/keys [PATH_TRANSLATED] => /var/www/remote/keys [PHP_SELF] => /mythweb/mythweb.php/remote/keys [PHP_AUTH_USER] => johnlatz [PHP_AUTH_DIGEST] => username="johnlatz", realm="MythTV", nonce="e5la+FPSBAA=bfaa59ccc848d7ef9ac4c7365a99cbf455ad7137", uri="/mythweb/remote/keys", algorithm=MD5, response="a545616bc2669325dc0b8680e1bc2f3c", qop=auth, nc=00000079, cnonce="28b16bd69bc9a69f" [REQUEST_TIME] => 1357158277 [STATUS] => 200 [URL] => /mythweb/remote/keys

)

==========================================================================

$constant_listuser?: Array (

[ERROR] => 512 [E_ASSERT_ERROR] => 4096 [FATAL] => 256 [PHP_MIN_VERSION] => 5.3 [WARNING] => 1024

)

Change History (2)

comment:1 Changed 6 years ago by jlatz@…

Please delete - appears to have been a permissions error: during housekeeping, myth could not delete recordings. (rebuilt myth on a new disk, recovered the existing database, copied the recordings to the new disk - apparently with wrong permissions).

comment:2 Changed 6 years ago by Kenni Lund [kenni a kelu dot dk]

Resolution: Invalid
Status: newclosed

Configuration error. The maximum number of database connections are configured in your MySQL configuration. You need to increase the number of connections for your MySQL server to avoid the issue.

Note: See TracTickets for help on using tickets.