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?

DB crashed and table got corrupted. Search the forum or the MySQL site on how to repair.

_________________
cesman

When the source is open, the possibilities are endless!