Opened 13 years ago
Closed 13 years ago
#10628 closed Bug Report - Crash (Works for me)
MySQL Error 111
| Reported by: | 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 )
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 13 years ago by
comment:2 Changed 13 years ago by
| Component: | MythTV - General → Plugin - MythWeb |
|---|---|
| Description: | modified (diff) |
| Owner: | set to Rob Smith |
| Priority: | critical → minor |
| Severity: | high → medium |
comment:3 Changed 13 years ago by
| Resolution: | → Works for me |
|---|---|
| Status: | new → closed |
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.
Check your ip address it sounds like you have updated and your ip address has changed.