<html>
<head>
<style>
P
{
margin:0px;
padding:0px
}
body
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body>
after some more digging it seems as my database is corrupted :( <br><br>I am getting a 145 error. I tried executing...<br><br><pre>mysqlcheck -u root -p --repair mythconverg <br></pre>and it comes back with everything is ok but when i check mythbackend.log again i get this...<br><br>2007-02-08 21:42:59.875 DB Error (delta position map insert):<br>Query was:<br>INSERT INTO recordedseek (chanid, starttime, mark, type, offset) VALUES ( '3111' , '2007-02-08T21:35:19' , '13724' , 9 , '826913676' );<br>Driver error was [2/145]:<br>QMYSQL3: Unable to execute query<br>Database error was:<br>Table './mythconverg/recordedseek' is marked as crashed and should be repaired<br><br>The mysqlcheck istnt checking that table when it goes through! Why? I can backup my db either it gives me the same error...<br><br>[root@mythtv mythtv]# mysqldump -u mythtv -pmythtv mythconverg -c > mythtv_backup.sql<br>mysqldump: Got error: 145: Table './mythconverg/recordedseek' is marked as crashed and should be repaired when using LOCK TABLES<br>[root@mythtv mythtv]# <br><br>What should i do?<br><br>Thanks<br><br><blockquote style="border-left: #008080 2px solid; padding-left: 5px; margin-left: 5px; margin-right: 0px;"><hr>From: mitchell2345@msn.com<br>To: mythtv-users@mythtv.org<br>Date: Thu, 8 Feb 2007 20:58:39 -0600<br>Subject: [mythtv-users] Backend crashing<br><br>
Hi,<br><br>For some reason mythbackend started to crash. Now I am missing my recordings! I looked at the log in /var/log/mythtv/mythbackend.log <br><br>When scrolling to the section of the crash this is what i see...<br><br>2007-02-08 12:23:31.741 AutoExpire: Required Free Space: 3.7 GB w/freq: 5 min<br>2007-02-08 12:23:33.674 Reschedule requested for id -1.<br>2007-02-08 12:23:34.820 Scheduled 204 items in 1.1 = 0.36 match + 0.78 place<br>2007-02-08 12:23:34.828 Recording starts soon, AUTO-Startup assumed<br>2007-02-08 12:23:34.955 TVRec(2): Changing from None to RecordingOnly<br>2007-02-08 12:23:34.963 TVRec(2): HW Tuner: 2->2<br>2007-02-08 12:23:34.988 Started recording: Cops "Grand Theft Auto Special Edition": channel 3231 on cardid 2, sourceid 3<br>2007-02-08 12:23:37.222 HTTPRequest::ParseRequest - Timeout waiting for request header.<br>2007-02-08 12:23:38.618 MainServer::HandleAnnounce Monitor<br>2007-02-08 12:23:38.623 adding: mythtv as a client (events: 0)<br>2007-02-08 12:23:41.153 MainServer::HandleAnnounce Monitor<br>2007-02-08 12:23:41.157 adding: mythtv as a client (events: 0)<br>2007-02-08 12:23:41.554 New DB connection, total: 4<br>2007-02-08 12:23:41.560 Connected to database 'mythconverg' at host: localhost<br>2007-02-08 12:30:00.691 TVRec(2): Changing from RecordingOnly to None<br>2007-02-08 12:30:00.733 Finished recording Cops "Grand Theft Auto Special Edition": channel 3231<br>2007-02-08 12:30:00.972 Finished recording Cops "Grand Theft Auto Special Edition": channel 3231<br>2007-02-08 12:30:02.780 TVRec(2): Changing from None to RecordingOnly<br>2007-02-08 12:30:02.789 TVRec(2): HW Tuner: 2->2<br>2007-02-08 12:30:02.790 HDHRChan(ffffffff/0): device found at address 192.168.1.134<br>2007-02-08 12:30:02.803 Started recording: Cops "Extreme Cops": channel 3231 on cardid 2, sourceid 3<br>2007-02-08 12:30:03.565 AFD: Opened codec 0x924b460, id(MPEG2VIDEO) type(Video)<br>2007-02-08 12:30:03.568 AFD: Opened codec 0x9249600, id(AC3) type(Audio)<br>2007-02-08 12:30:03.809 Reschedule requested for id 0.<br>2007-02-08 12:30:04.860 Scheduled 202 items in 1.0 = 0.03 match + 1.02 place<br>2007-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 2<br>007<br>2007-02-08 12:30:41.871 Using runtime prefix = /usr<br>2007-02-08 12:30:41.903 New DB connection, total: 1<br>2007-02-08 12:30:41.920 Connected to database 'mythconverg' at host: localhost<br>2007-02-08 12:30:41.929 New DB connection, total: 2<br>2007-02-08 12:30:41.935 Connected to database 'mythconverg' at host: localhost<br>2007-02-08 12:30:41.951 Connecting to backend server: 127.0.0.1:6543 (try 1 of 5)<br>2007-02-08 12:30:41.954 Using protocol version 31<br>2007-02-08 12:30:41.955 MainServer::HandleAnnounce Monitor<br>2007-02-08 12:30:41.958 adding: mythtv as a client (events: 0)<br>2007-02-08 12:30:41.960 MainServer::HandleAnnounce Monitor<br>2007-02-08 12:30:41.961 adding: mythtv as a client (events: 1)<br>2007-02-08 12:30:43.125 RingBuf(/video/recorded_tv/3231_20070208122400.mpg): Waited 1.0 seconds for data to become available...<br>2007-02-08 12:30:44.138 RingBuf(/video/recorded_tv/3231_20070208122400.mpg): Waited 2.0 seconds for data to become available...<br>2007-02-08 12:30:44.520 AFD: Opened codec 0x94e20f0, id(MPEG2VIDEO) type(Video)<br>2007-02-08 12:30:44.522 AFD: Opened codec 0x94e2660, id(AC3) type(Audio)<br>2007-02-08 12:31:52.270 RingBuf(/video/recorded_tv/3231_20070208122400.mpg): Waited 1.0 seconds for data to become available...<br>2007-02-08 12:31:53.279 RingBuf(/video/recorded_tv/3231_20070208122400.mpg): Waited 2.0 seconds for data to become available...<br>2007-02-08 12:31:58.121 JobQueue: Commercial Flagging Finished, 0 break(s) found.<br>2007-02-08 12:32:00.692 AFD: Opened codec 0x932d660, id(MPEG2VIDEO) type(Video)<br>2007-02-08 12:32:00.695 AFD: Opened codec 0x92d1730, id(AC3) type(Audio)<br>2007-02-08 12:43:38.264 HTTPRequest::ParseRequest - Timeout waiting for request header.<br><br><br>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 <br><br>Using FC6 with HDHomeRun and PVR-150.<br>Athlon XP 1800+ 512mb RAM<br>500GB Western Digital HD<br>MSI KT6 Delta MB<br><br>Thanks,<br>Mitchell<br> <br><hr>Get connected - Use your Hotmail address to sign into Windows Live Messenger now. <a href="http://get.live.com/messenger/overview" target="_blank">Connect now!</a>
</blockquote><br /><hr />Live Search: Better results, fast <a href='http://get.live.com/search/overview' target='_new'>Try it now!</a></body>
</html>