Opened 6 years ago
Closed 6 years ago
#11320 closed Bug Report - Hang/Deadlock (Invalid)
Too Many DB Connections
| Reported by: | 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
(
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
comment:2 Changed 6 years ago by
| Resolution: | → Invalid |
|---|---|
| Status: | new → closed |
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.
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).