Opened 8 years ago

Closed 8 years ago

#10628 closed Bug Report - Crash (Works for me)

MySQL Error 111

Reported by: daveyboyc <davidcrawford83@…> Owned by: Rob Smith
Priority: minor Milestone: unknown
Component: Plugin - MythWeb Version: 0.25
Severity: medium Keywords:
Cc: Ticket locked: no

Description (last modified by Raymond Wagner)

Hi since upgrading to .25 everything worked at first - then it stopped working i can no longer connect to mythconverg via mythweb, or run myhtbackend or the setup. Mythweb gives me the following log: (please help - what can i do to fix this?)

    datetime:  2012-04-19 12:35:39 (BST)
    errornum:  256
  error type:  User Error
error string:  !!NoTrans: Lost connection to MySQL server at 'reading initial communication packet', system error: 111 [#2013]

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] => Lost connection to MySQL server at 'reading initial communication packet', system error: 111 [#2013]
                    [err] => Lost connection to MySQL server at 'reading initial communication packet', system error: 111
                    [errno] => 2013
                    [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] => 259
            [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] => Lost connection to MySQL server at 'reading initial communication packet', system error: 111 [#2013]
                            [err] => Lost connection to MySQL server at 'reading initial communication packet', system error: 111
                            [errno] => 2013
                            [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] => Lost connection to MySQL server at 'reading initial communication packet', system error: 111 [#2013]
                    [err] => Lost connection to MySQL server at 'reading initial communication packet', system error: 111
                    [errno] => 2013
                    [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] => My49MkBV
                    [3] => 192.168.0.5
                    [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] => Lost connection to MySQL server at 'reading initial communication packet', system error: 111 [#2013]

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] => Lost connection to MySQL server at 'reading initial communication packet', system error: 111 [#2013]
                    [err] => Lost connection to MySQL server at 'reading initial communication packet', system error: 111
                    [errno] => 2013
                    [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] => 259
            [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] => Lost connection to MySQL server at 'reading initial communication packet', system error: 111 [#2013]
                            [err] => Lost connection to MySQL server at 'reading initial communication packet', system error: 111
                            [errno] => 2013
                            [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] => Lost connection to MySQL server at 'reading initial communication packet', system error: 111 [#2013]
                    [err] => Lost connection to MySQL server at 'reading initial communication packet', system error: 111
                    [errno] => 2013
                    [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] => My49MkBV
                    [3] => 192.168.0.5
                    [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:  259
   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] => My49MkBV
    [3] => 192.168.0.5
    [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_STATUS] => 200
    [db_server] => 192.168.0.5
    [db_name] => mythconverg
    [db_login] => mythtv
    [db_password] => My49MkBV
    [HTTP_HOST] => 86.15.42.56
    [HTTP_CONNECTION] => keep-alive
    [HTTP_USER_AGENT] => Mozilla/5.0 (Windows NT 6.1) AppleWebKit/535.19 (KHTML, like Gecko) Chrome/18.0.1025.162 Safari/535.19
    [HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
    [HTTP_ACCEPT_ENCODING] => gzip,deflate,sdch
    [HTTP_ACCEPT_LANGUAGE] => en-GB,en-US;q=0.8,en;q=0.6
    [HTTP_ACCEPT_CHARSET] => ISO-8859-1,utf-8;q=0.7,*;q=0.3
    [HTTP_COOKIE] => lastchannel=NaN; tlchgrp=Main; tlzoomx=360; tltfont=14; tlctips=true; mythweb_id=8382dm08d5756f1lcmd36dlvi1; lastpage=tasks.html%3Faktion%3Dtasks
    [PATH] => /usr/local/bin:/usr/bin:/bin
    [SERVER_SIGNATURE] => <address>Apache/2.2.20 (Ubuntu) Server at 86.15.42.56 Port 80</address>

    [SERVER_SOFTWARE] => Apache/2.2.20 (Ubuntu)
    [SERVER_NAME] => 86.15.42.56
    [SERVER_ADDR] => 192.168.0.5
    [SERVER_PORT] => 80
    [REMOTE_ADDR] => 190.2.109.14
    [DOCUMENT_ROOT] => /var/www
    [SERVER_ADMIN] => webmaster@localhost
    [SCRIPT_FILENAME] => /var/www/mythweb/mythweb.php
    [REMOTE_PORT] => 49234
    [REDIRECT_URL] => /mythweb/tv/detail/56603/1329332400
    [GATEWAY_INTERFACE] => CGI/1.1
    [SERVER_PROTOCOL] => HTTP/1.1
    [REQUEST_METHOD] => GET
    [QUERY_STRING] => 
    [REQUEST_URI] => /mythweb/tv/detail/56603/1329332400
    [SCRIPT_NAME] => /mythweb/mythweb.php
    [PATH_INFO] => /tv/detail/56603/1329332400
    [PATH_TRANSLATED] => /var/www/tv/detail/56603/1329332400
    [PHP_SELF] => /mythweb/mythweb.php/tv/detail/56603/1329332400
    [REQUEST_TIME] => 1334835318
    [STATUS] => 200
    [URL] => /mythweb/tv/detail/56603/1329332400
)

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

$constant_list["user"]: Array
(
    [ERROR] => 512
    [E_ASSERT_ERROR] => 4096
    [FATAL] => 256
    [PHP_MIN_VERSION] => 5.3
    [WARNING] => 1024
)

Change History (3)

comment:1 Changed 8 years ago by cocksy@…

Check your ip address it sounds like you have updated and your ip address has changed.

comment:2 Changed 8 years ago by Raymond Wagner

Component: MythTV - GeneralPlugin - MythWeb
Description: modified (diff)
Owner: set to Rob Smith
Priority: criticalminor
Severity: highmedium

comment:3 Changed 8 years ago by sphery

Resolution: Works for me
Status: newclosed

This seems to be a misconfiguration of the network (such as a firewall or /etc/hosts (tcp-wrappers) or ... misconfiguration) or network issues. Please ask for help on the mythtv-users mailing list ( http://www.mythtv.org/mailman/listinfo/mythtv-users ), and we can probably help find the issue.

Note: See TracTickets for help on using tickets.