[mythtv-users] 0.28.x: while browsing recorded programs...

Udo van den Heuvel udovdh at xs4all.nl
Sat Feb 3 11:02:31 UTC 2018


Hello,

While browsing recorded programs I clicked on a title and got the
message below.
What went wrong and how did that happen? (the machine is very lightly
visited yet recording 24/7)


Udo


Fatal Error

!!NoTrans: Too many connections [#1040]

Backtrace
Array
(
[0] => Array
(
[file] => /usr/share/mythweb/classes/Database/Query/mysqlicompat.php
[line] => 65
[function] => error
[class] => Database
[object] => Database_mysqlicompat Object
(
[dbh] =>
[error] => Too many connections [#1040]
[err] => Too many connections
[errno] => 1040
[last_sh] => Database_Query_mysqlicompat Object
(
[dbh] =>
[query] => Array
(
[0] => SET SESSION sql_mode = "";
)

[last_query] => SET SESSION sql_mode = "";
[warnings] => Array
(
)

[num_args_needed] => 0
[num_rows] =>
[affected_rows] =>
[insert_id] =>
[db] => Database_mysqlicompat Object
*RECURSION*
)

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

)

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

)

[1] => Array
(
[file] => /usr/share/mythweb/classes/Database.php
[line] => 263
[function] => execute
[class] => Database_Query_mysqlicompat
[object] => Database_Query_mysqlicompat Object
(
[dbh] =>
[query] => Array
(
[0] => SET SESSION sql_mode = "";
)

[last_query] => SET SESSION sql_mode = "";
[warnings] => Array
(
)

[num_args_needed] => 0
[num_rows] =>
[affected_rows] =>
[insert_id] =>
[db] => Database_mysqlicompat Object
(
[dbh] =>
[error] => Too many connections [#1040]
[err] => Too many connections
[errno] => 1040
[last_sh] => Database_Query_mysqlicompat 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/mythweb/classes/Database.php
[line] => 124
[function] => query
[class] => Database
[object] => Database_mysqlicompat Object
(
[dbh] =>
[error] => Too many connections [#1040]
[err] => Too many connections
[errno] => 1040
[last_sh] => Database_Query_mysqlicompat Object
(
[dbh] =>
[query] => Array
(
[0] => SET SESSION sql_mode = "";
)

[last_query] => SET SESSION sql_mode = "";
[warnings] => Array
(
)

[num_args_needed] => 0
[num_rows] =>
[affected_rows] =>
[insert_id] =>
[db] => Database_mysqlicompat Object
*RECURSION*
)

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

)

[type] => ->
[args] => Array
(
[0] => SET SESSION sql_mode = "";
)

)

[3] => Array
(
[file] => /usr/share/mythweb/includes/database.php
[line] => 44
[function] => connect
[class] => Database
[type] => ::
[args] => Array
(
[0] => mythconverg
[1] => mythtv
[2] => mythtv
[3] => localhost
[4] =>
[5] => mysqlicompat
)

)

[4] => Array
(
[file] => /usr/share/mythweb/includes/init.php
[line] => 43
[args] => Array
(
[0] => /usr/share/mythweb/includes/database.php
)

[function] => require_once
)

[5] => Array
(
[file] => /usr/share/mythweb/mythweb.php
[line] => 20
[args] => Array
(
[0] => /usr/share/mythweb/includes/init.php
)

[function] => require_once
)

)
!!

If you choose to submit a bug report please make sure to include a brief
description of what you were doing, along with the following backtrace
as an attachment (please don\'t just paste the whole thing into the ticket)
    datetime:  2018-02-03 11:56:33 (CET)
    errornum:  256
  error type:  User Error
error string:  !!NoTrans: Too many connections [#1040]

Backtrace
Array
(
    [0] => Array
        (
            [file] =>
/usr/share/mythweb/classes/Database/Query/mysqlicompat.php
            [line] => 65
            [function] => error
            [class] => Database
            [object] => Database_mysqlicompat Object
                (
                    [dbh] =>
                    [error] => Too many connections [#1040]
                    [err] => Too many connections
                    [errno] => 1040
                    [last_sh] => Database_Query_mysqlicompat Object
                        (
                            [dbh] =>
                            [query] => Array
                                (
                                    [0] => SET SESSION sql_mode = "";
                                )

                            [last_query] => SET SESSION sql_mode = "";
                            [warnings] => Array ( )
                            [num_args_needed] => 0
                            [num_rows] =>
                            [affected_rows] =>
                            [insert_id] =>
                            [db] => Database_mysqlicompat Object
 *RECURSION*
                        )

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

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

    [1] => Array
        (
            [file] => /usr/share/mythweb/classes/Database.php
            [line] => 263
            [function] => execute
            [class] => Database_Query_mysqlicompat
            [object] => Database_Query_mysqlicompat Object
                (
                    [dbh] =>
                    [query] => Array
                        (
                            [0] => SET SESSION sql_mode = "";
                        )

                    [last_query] => SET SESSION sql_mode = "";
                    [warnings] => Array ( )
                    [num_args_needed] => 0
                    [num_rows] =>
                    [affected_rows] =>
                    [insert_id] =>
                    [db] => Database_mysqlicompat Object
                        (
                            [dbh] =>
                            [error] => Too many connections [#1040]
                            [err] => Too many connections
                            [errno] => 1040
                            [last_sh] => Database_Query_mysqlicompat 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/mythweb/classes/Database.php
            [line] => 124
            [function] => query
            [class] => Database
            [object] => Database_mysqlicompat Object
                (
                    [dbh] =>
                    [error] => Too many connections [#1040]
                    [err] => Too many connections
                    [errno] => 1040
                    [last_sh] => Database_Query_mysqlicompat Object
                        (
                            [dbh] =>
                            [query] => Array
                                (
                                    [0] => SET SESSION sql_mode = "";
                                )

                            [last_query] => SET SESSION sql_mode = "";
                            [warnings] => Array ( )
                            [num_args_needed] => 0
                            [num_rows] =>
                            [affected_rows] =>
                            [insert_id] =>
                            [db] => Database_mysqlicompat Object
 *RECURSION*
                        )

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

            [type] => ->
            [args] => Array
                (
                    [0] => SET SESSION sql_mode = "";
                )

        )

    [3] => Array
        (
            [file] => /usr/share/mythweb/includes/database.php
            [line] => 44
            [function] => connect
            [class] => Database
            [type] => ::
            [args] => Array
                (
                    [0] => mythconverg
                    [1] => mythtv
                    [2] => mythtv
                    [3] => localhost
                    [4] =>
                    [5] => mysqlicompat
                )

        )

    [4] => Array
        (
            [file] => /usr/share/mythweb/includes/init.php
            [line] => 43
            [args] => Array
                (
                    [0] => /usr/share/mythweb/includes/database.php
                )

            [function] => require_once
        )

    [5] => Array
        (
            [file] => /usr/share/mythweb/mythweb.php
            [line] => 20
            [args] => Array
                (
                    [0] => /usr/share/mythweb/includes/init.php
                )

            [function] => require_once
        )

)
!!
    filename:  /usr/share/mythweb/classes/Database/Query/mysqlicompat.php
  error line:  66

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

Backtrace:

    file:  /usr/share/mythweb/classes/Database/Query/mysqlicompat.php
    line:  66
   class:
function:  trigger_error
    type:
    args:  Array
(
    [0] => Too many connections [#1040]

Backtrace
Array
(
    [0] => Array
        (
            [file] =>
/usr/share/mythweb/classes/Database/Query/mysqlicompat.php
            [line] => 65
            [function] => error
            [class] => Database
            [object] => Database_mysqlicompat Object
                (
                    [dbh] =>
                    [error] => Too many connections [#1040]
                    [err] => Too many connections
                    [errno] => 1040
                    [last_sh] => Database_Query_mysqlicompat Object
                        (
                            [dbh] =>
                            [query] => Array
                                (
                                    [0] => SET SESSION sql_mode = "";
                                )

                            [last_query] => SET SESSION sql_mode = "";
                            [warnings] => Array ( )
                            [num_args_needed] => 0
                            [num_rows] =>
                            [affected_rows] =>
                            [insert_id] =>
                            [db] => Database_mysqlicompat Object
 *RECURSION*
                        )

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

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

    [1] => Array
        (
            [file] => /usr/share/mythweb/classes/Database.php
            [line] => 263
            [function] => execute
            [class] => Database_Query_mysqlicompat
            [object] => Database_Query_mysqlicompat Object
                (
                    [dbh] =>
                    [query] => Array
                        (
                            [0] => SET SESSION sql_mode = "";
                        )

                    [last_query] => SET SESSION sql_mode = "";
                    [warnings] => Array ( )
                    [num_args_needed] => 0
                    [num_rows] =>
                    [affected_rows] =>
                    [insert_id] =>
                    [db] => Database_mysqlicompat Object
                        (
                            [dbh] =>
                            [error] => Too many connections [#1040]
                            [err] => Too many connections
                            [errno] => 1040
                            [last_sh] => Database_Query_mysqlicompat 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/mythweb/classes/Database.php
            [line] => 124
            [function] => query
            [class] => Database
            [object] => Database_mysqlicompat Object
                (
                    [dbh] =>
                    [error] => Too many connections [#1040]
                    [err] => Too many connections
                    [errno] => 1040
                    [last_sh] => Database_Query_mysqlicompat Object
                        (
                            [dbh] =>
                            [query] => Array
                                (
                                    [0] => SET SESSION sql_mode = "";
                                )

                            [last_query] => SET SESSION sql_mode = "";
                            [warnings] => Array ( )
                            [num_args_needed] => 0
                            [num_rows] =>
                            [affected_rows] =>
                            [insert_id] =>
                            [db] => Database_mysqlicompat Object
 *RECURSION*
                        )

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

            [type] => ->
            [args] => Array
                (
                    [0] => SET SESSION sql_mode = "";
                )

        )

    [3] => Array
        (
            [file] => /usr/share/mythweb/includes/database.php
            [line] => 44
            [function] => connect
            [class] => Database
            [type] => ::
            [args] => Array
                (
                    [0] => mythconverg
                    [1] => mythtv
                    [2] => mythtv
                    [3] => localhost
                    [4] =>
                    [5] => mysqlicompat
                )

        )

    [4] => Array
        (
            [file] => /usr/share/mythweb/includes/init.php
            [line] => 43
            [args] => Array
                (
                    [0] => /usr/share/mythweb/includes/database.php
                )

            [function] => require_once
        )

    [5] => Array
        (
            [file] => /usr/share/mythweb/mythweb.php
            [line] => 20
            [args] => Array
                (
                    [0] => /usr/share/mythweb/includes/init.php
                )

            [function] => require_once
        )

)

    [1] => 256
)

    file:  /usr/share/mythweb/classes/Database.php
    line:  263
   class:  Database_Query_mysqlicompat
function:  execute
    type:  ->
    args:  Array
(
    [0] => Array ( )
)

    file:  /usr/share/mythweb/classes/Database.php
    line:  124
   class:  Database
function:  query
    type:  ->
    args:  Array
(
    [0] => SET SESSION sql_mode = "";
)

    file:  /usr/share/mythweb/includes/database.php
    line:  44
   class:  Database
function:  connect
    type:  ::
    args:  Array
(
    [0] => mythconverg
    [1] => mythtv
    [2] => mythtv
    [3] => localhost
    [4] =>
    [5] => mysqlicompat
)

    file:  /usr/share/mythweb/includes/init.php
    line:  43
   class:
function:  require_once
    type:
    args:  Array
(
    [0] => /usr/share/mythweb/includes/database.php
)

    file:  /usr/share/mythweb/mythweb.php
    line:  20
   class:
function:  require_once
    type:
    args:  Array
(
    [0] => /usr/share/mythweb/includes/init.php
)


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

$_GET: Array
(
    [title] => Verborgen verleden
)

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

$_SESSION: Array
(
    [language] => English
    [date_statusbar] => %a %b %e, %Y, %I:%M %p
    [date_scheduled] => %a %b %e, %Y (%I:%M %p)
    [date_scheduled_popup] => %a %b %e, %Y
    [date_recorded] => %a %b %e, %Y (%I:%M %p)
    [date_search] => %a %b %e, %Y, %I:%M %p
    [date_listing_key] => %a %b %e, %Y, %I:%M %p
    [date_listing_jump] => %a %b %e, %Y
    [date_channel_jump] => %a %b %e, %Y
    [date_job_status] => %a %b %e, %Y, %I:%M %p
    [time_format] => %I:%M %p
)

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

$_SERVER: Array
(
    [REDIRECT_UNIQUE_ID] => WnWVYVREdfi3wRbOPhaoKQAAAAs
    [REDIRECT_STATUS] => 200
    [UNIQUE_ID] => WnWVYVREdfi3wRbOPhaoKQAAAAs
    [db_server] => localhost
    [db_name] => mythconverg
    [db_login] => mythtv
    [db_password] => mythtv
    [HTTP_HOST] => recorder
    [HTTP_USER_AGENT] => Mozilla/5.0 (X11; Fedora; Linux x86_64;
rv:56.0) Gecko/20100101 Firefox/56.0
    [HTTP_ACCEPT] =>
text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
    [HTTP_ACCEPT_LANGUAGE] => en-US,en;q=0.5
    [HTTP_ACCEPT_ENCODING] => gzip, deflate
    [HTTP_REFERER] => http://recorder/mythweb/tv/recorded
    [HTTP_COOKIE] => mythweb_id=25664caf11195ea15ced52d850604b8c
    [HTTP_DNT] => 1
    [HTTP_CONNECTION] => keep-alive
    [HTTP_UPGRADE_INSECURE_REQUESTS] => 1
    [PATH] => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
    [SERVER_SIGNATURE] =>
    [SERVER_SOFTWARE] => Apache/2.4.29 (Fedora) OpenSSL/1.1.0g-fips
mod_nss/1.0.14 NSS/3.29.1 PHP/7.1.13 mod_perl/2.0.10 Perl/v5.24.3
    [SERVER_NAME] => recorder
    [SERVER_ADDR] => 192.168.10.99
    [SERVER_PORT] => 80
    [REMOTE_ADDR] => 192.168.10.70
    [DOCUMENT_ROOT] => /var/www/html
    [REQUEST_SCHEME] => http
    [CONTEXT_PREFIX] => /mythweb/
    [CONTEXT_DOCUMENT_ROOT] => /usr/share/mythweb/
    [SERVER_ADMIN] => root at localhost
    [SCRIPT_FILENAME] => /usr/share/mythweb/mythweb.php
    [REMOTE_PORT] => 56396
    [REDIRECT_URL] => /mythweb/tv/recorded
    [REDIRECT_QUERY_STRING] => title=Verborgen+verleden
    [GATEWAY_INTERFACE] => CGI/1.1
    [SERVER_PROTOCOL] => HTTP/1.1
    [REQUEST_METHOD] => GET
    [QUERY_STRING] => title=Verborgen+verleden
    [REQUEST_URI] => /tv/recorded?title=Verborgen+verleden
    [SCRIPT_NAME] => /mythweb/mythweb.php
    [PATH_INFO] => /tv/recorded
    [PATH_TRANSLATED] => /var/www/html/tv/recorded
    [PHP_SELF] => /mythweb/mythweb.php/tv/recorded
    [REQUEST_TIME_FLOAT] => 1517655393.963
    [REQUEST_TIME] => 1517655393
    [STATUS] => 200
    [URL] => /mythweb/tv/recorded
    [HTTP_X_FORWARDED_PROTO] =>
    [HTTPS] =>
    [HTTP_PORT] => 80
)

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

$constant_list["user"]: Array
(
    [ERROR] => 512
    [E_ASSERT_ERROR] => 4096
    [FATAL] => 256
    [PHP_MIN_VERSION] => 5.3
    [WARNING] => 1024
    [error_email] =>
    [gb] => 1073741824
    [hostname] => recorder.hierzo
    [http_host] => recorder
    [kb] => 1024
    [mb] => 1048576
    [module] => tv
    [modules_path] => /usr/share/mythweb/modules
    [root] => /mythweb/
    [root_auth_url] => http://recorder/mythweb/
    [root_url] => http://recorder/mythweb/
    [stream_url] => http://recorder:80//mythweb/
    [tb] => 1099511627776
)




More information about the mythtv-users mailing list