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] => <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_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