id,summary,reporter,owner,description,type,status,priority,milestone,component,version,severity,resolution,keywords,cc,mlocked 11320,Too Many DB Connections,jlatz@…,Rob Smith,"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] =>
Apache/2.2.22 (Ubuntu) Server at latz-torres.hobby-site.org Port 443
[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_list[""user""]: Array ( [ERROR] => 512 [E_ASSERT_ERROR] => 4096 [FATAL] => 256 [PHP_MIN_VERSION] => 5.3 [WARNING] => 1024 ) ",Bug Report - Hang/Deadlock,closed,minor,unknown,Plugin - MythWeb,0.26-fixes,medium,Invalid,,,0