[mythtv-users] Backend crashing

Fri Feb 9 03:50:53 UTC 2007

after some more digging it seems as my database is corrupted :(  I am getting a 145 error.  I tried executing...mysqlcheck -u root -p  --repair mythconverg and it comes back with everything is ok but when i check mythbackend.log again i get this...2007-02-08 21:42:59.875 DB Error (delta position map insert):Query was:INSERT INTO recordedseek (chanid, starttime, mark, type, offset) VALUES ( '3111' , '2007-02-08T21:35:19' , '13724' , 9 , '826913676' );Driver error was [2/145]:QMYSQL3: Unable to execute queryDatabase error was:Table './mythconverg/recordedseek' is marked as crashed and should be repairedThe mysqlcheck istnt checking that table when it goes through! Why?  I can backup my db either it gives me the same error...[root at mythtv mythtv]# mysqldump -u mythtv -pmythtv mythconverg -c > mythtv_backup.sqlmysqldump: Got error: 145: Table './mythconverg/recordedseek' is marked as crashed and should be repaired when using LOCK TABLES[root at mythtv mythtv]# What should i do?ThanksFrom: mitchell2345 at msn.comTo: mythtv-users at mythtv.orgDate: Thu, 8 Feb 2007 20:58:39 -0600Subject: [mythtv-users] Backend crashing

Hi,For some reason mythbackend started to crash.  Now I am missing my recordings!  I looked at the log in /var/log/mythtv/mythbackend.log When scrolling to the section of the crash this  is what i see...2007-02-08 12:23:31.741 AutoExpire: Required Free Space: 3.7 GB w/freq: 5 min2007-02-08 12:23:33.674 Reschedule requested for id -1.2007-02-08 12:23:34.820 Scheduled 204 items in 1.1 = 0.36 match + 0.78 place2007-02-08 12:23:34.828 Recording starts soon, AUTO-Startup assumed2007-02-08 12:23:34.955 TVRec(2): Changing from None to RecordingOnly2007-02-08 12:23:34.963 TVRec(2): HW Tuner: 2->22007-02-08 12:23:34.988 Started recording: Cops "Grand Theft Auto Special Edition": channel 3231 on cardid 2, sourceid 32007-02-08 12:23:37.222 HTTPRequest::ParseRequest - Timeout waiting for request header.2007-02-08 12:23:38.618 MainServer::HandleAnnounce Monitor2007-02-08 12:23:38.623 adding: mythtv as a client (events: 0)2007-02-08 12:23:41.153 MainServer::HandleAnnounce Monitor2007-02-08 12:23:41.157 adding: mythtv as a client (events: 0)2007-02-08 12:23:41.554 New DB connection, total: 42007-02-08 12:23:41.560 Connected to database 'mythconverg' at host: localhost2007-02-08 12:30:00.691 TVRec(2): Changing from RecordingOnly to None2007-02-08 12:30:00.733 Finished recording Cops "Grand Theft Auto Special Edition": channel 32312007-02-08 12:30:00.972 Finished recording Cops "Grand Theft Auto Special Edition": channel 32312007-02-08 12:30:02.780 TVRec(2): Changing from None to RecordingOnly2007-02-08 12:30:02.789 TVRec(2): HW Tuner: 2->22007-02-08 12:30:02.790 HDHRChan(ffffffff/0): device found at address 192.168.1.1342007-02-08 12:30:02.803 Started recording: Cops "Extreme Cops": channel 3231 on cardid 2, sourceid 32007-02-08 12:30:03.565 AFD: Opened codec 0x924b460, id(MPEG2VIDEO) type(Video)2007-02-08 12:30:03.568 AFD: Opened codec 0x9249600, id(AC3) type(Audio)2007-02-08 12:30:03.809 Reschedule requested for id 0.2007-02-08 12:30:04.860 Scheduled 202 items in 1.0 = 0.03 match + 1.02 place2007-02-08 12:30:41.675 JobQueue: Commercial Flagging Starting for Cops "Grand Theft Auto Special Edition" recorded from channel 3231 at Thu Feb 8 12:24:00 20072007-02-08 12:30:41.871 Using runtime prefix = /usr2007-02-08 12:30:41.903 New DB connection, total: 12007-02-08 12:30:41.920 Connected to database 'mythconverg' at host: localhost2007-02-08 12:30:41.929 New DB connection, total: 22007-02-08 12:30:41.935 Connected to database 'mythconverg' at host: localhost2007-02-08 12:30:41.951 Connecting to backend server: 127.0.0.1:6543 (try 1 of 5)2007-02-08 12:30:41.954 Using protocol version 312007-02-08 12:30:41.955 MainServer::HandleAnnounce Monitor2007-02-08 12:30:41.958 adding: mythtv as a client (events: 0)2007-02-08 12:30:41.960 MainServer::HandleAnnounce Monitor2007-02-08 12:30:41.961 adding: mythtv as a client (events: 1)2007-02-08 12:30:43.125 RingBuf(/video/recorded_tv/3231_20070208122400.mpg): Waited 1.0 seconds for data to become available...2007-02-08 12:30:44.138 RingBuf(/video/recorded_tv/3231_20070208122400.mpg): Waited 2.0 seconds for data to become available...2007-02-08 12:30:44.520 AFD: Opened codec 0x94e20f0, id(MPEG2VIDEO) type(Video)2007-02-08 12:30:44.522 AFD: Opened codec 0x94e2660, id(AC3) type(Audio)2007-02-08 12:31:52.270 RingBuf(/video/recorded_tv/3231_20070208122400.mpg): Waited 1.0 seconds for data to become available...2007-02-08 12:31:53.279 RingBuf(/video/recorded_tv/3231_20070208122400.mpg): Waited 2.0 seconds for data to become available...2007-02-08 12:31:58.121 JobQueue: Commercial Flagging Finished, 0 break(s) found.2007-02-08 12:32:00.692 AFD: Opened codec 0x932d660, id(MPEG2VIDEO) type(Video)2007-02-08 12:32:00.695 AFD: Opened codec 0x92d1730, id(AC3) type(Audio)2007-02-08 12:43:38.264 HTTPRequest::ParseRequest - Timeout waiting for request header.The comm. flagger for "Cops "Grand Theft Auto Special Edition"" never finished as when i restart the backend it says it doesnt have comm. flagging.  What could be causing this?  Also resently the comm. flagger stopped catching many of the breaks.  I have set to use all methods and and disabled strict Using FC6 with HDHomeRun and PVR-150.Athlon XP 1800+ 512mb RAM500GB Western Digital HDMSI KT6 Delta MBThanks,Mitchell  Get connected - Use your Hotmail address to sign into Windows Live Messenger now.  Connect now!

_________________________________________________________________
Live Search: Better results, fast
http://get.live.com/search/overview
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20070208/7d230630/attachment-0001.htm 