LinHES Forums
http://forum.linhes.org/

MySQL server has gone away
http://forum.linhes.org/viewtopic.php?f=11&t=649		 Page 1 of 1
Author:  freddyman [ Wed Feb 04, 2004 12:33 am ]
Post subject:  MySQL server has gone away
Don't know exactly how this happened until after the system crashed. After I rebooted, it brought me into the purple x window. No front end. I looked into the logs, and this is what the mythbackend.log said:

2004-02-03 20:02:33 Changing from None to RecordingOnly
2004-02-03 20:02:33 MainServer::HandleAnnounce Playback
2004-02-03 20:02:33 adding: mythtv as a player 0
2004-02-03 20:02:34 MainServer::HandleAnnounce Playback
2004-02-03 20:02:34 adding: mythtv as a player 0
DB Error (KickDatabase):
Query was:
SELECT NULL;
Driver error was [2/-1]:
QMYSQL3: Unable to execute query
Database error was:


DB Error (KickDatabase):
Query was:
SELECT NULL;
Driver error was [2/-1]:
QMYSQL3: Unable to execute query
Database error was:
MySQL server has gone away

DB Error (position map clear):
Query was:
DELETE FROM recordedmarkup WHERE chanid = '1008' AND starttime = '20040203200300' AND type = 6 AND mark >= 1050 AND mark <= 1079;
Driver error was [2/-1]:
QMYSQL3: Unable to execute query
Database error was:


DB Error (position map insert):
Query was:
INSERT INTO recordedmarkup (chanid, starttime, mark, type, offset) values ( '1008', '20040203200300', 1050, 6, "340981798");
Driver error was [2/-1]:
QMYSQL3: Unable to execute query
Database error was:
MySQL server has gone away

DB Error (position map insert):
Query was:
INSERT INTO recordedmarkup (chanid, starttime, mark, type, offset) values ( '1008', '20040203200300', 1051, 6, "341358630");
Driver error was [2/-1]:
QMYSQL3: Unable to execute query
Database error was:
MySQL server has gone away

... snip .... several of the above paragraph ...

2004-02-03 19:34:18 Enabled verbose msgs : important general
2004-02-03 19:34:22 Found changes in the todo list.
2004-02-03 19:35:26 MainServer::HandleAnnounce Playback
2004-02-03 19:35:26 adding: mythtv as a player 0
2004-02-03 19:35:27 MainServer::HandleAnnounce Playback
2004-02-03 19:35:27 adding: mythtv as a player 1
2004-02-03 19:35:27 MainServer::HandleAnnounce Playback
2004-02-03 19:35:27 adding: mythtv as a player 0
2004-02-03 19:35:27 MainServer::HandleAnnounce Playback
2004-02-03 19:35:27 adding: mythtv as a player 0
2004-02-03 19:35:27 adding: mythtv as a remote ringbuffer
2004-02-03 19:35:27 Changing from None to WatchingLiveTV
2004-02-03 19:35:40 Found changes in the todo list.
2004-02-03 20:02:32 Found changes in the todo list.
2004-02-03 20:02:33 Changing from WatchingLiveTV to None
2004-02-03 20:02:33 Started recording "Survivor: All-Stars" on channel: 1008 on cardid: 1, sourceid 1
2004-02-03 20:02:33 Changing from None to RecordingOnly
2004-02-03 20:02:33 MainServer::HandleAnnounce Playback
2004-02-03 20:02:33 adding: mythtv as a player 0
2004-02-03 20:02:34 MainServer::HandleAnnounce Playback
2004-02-03 20:02:34 adding: mythtv as a player 0
DB Error (KickDatabase):
Query was:
SELECT NULL;
Driver error was [2/-1]:
QMYSQL3: Unable to execute query
Database error was:


DB Error (KickDatabase):
Query was:
SELECT NULL;
Driver error was [2/-1]:
QMYSQL3: Unable to execute query
Database error was:
MySQL server has gone away

DB Error (position map clear):
Query was:
DELETE FROM recordedmarkup WHERE chanid = '1008' AND starttime = '20040203200300' AND type = 6 AND mark >= 1050 AND mark <= 1079;
Driver error was [2/-1]:
QMYSQL3: Unable to execute query
Database error was:


DB Error (position map insert):
Query was:
INSERT INTO recordedmarkup (chanid, starttime, mark, type, offset) values ( '1008', '20040203200300', 1050, 6, "340981798");
Driver error was [2/-1]:
QMYSQL3: Unable to execute query
Database error was:
MySQL server has gone away

DB Error (position map insert):
Query was:
INSERT INTO recordedmarkup (chanid, starttime, mark, type, offset) values ( '1008', '20040203200300', 1051, 6, "341358630");
Driver error was [2/-1]:
QMYSQL3: Unable to execute query
Database error was:
MySQL server has gone away

DB Error (position map insert):
Query was:
INSERT INTO recordedmarkup (chanid, starttime, mark, type, offset) values ( '1008', '20040203200300', 1052, 6, "341712934");
Driver error was [2/-1]:
QMYSQL3: Unable to execute query
Database error was:
MySQL server has gone away

I checked /var/log/messages and it didn't have anthing enlightening...

Obviously there is some problem with MySQL, but any ideas what?
Author:  cesman [ Wed Feb 04, 2004 2:07 am ]
Post subject: 
DB crashed and table got corrupted. Search the forum or the MySQL site on how to repair.
Page 1 of 1 All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/