Opened 14 years ago
Closed 14 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
)
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).