[mythtv-users] recordedseek table crashing regularly, still

Hamish Moffatt hamish at cloud.net.au
Wed Feb 20 09:59:09 UTC 2008


I have MythTV 0.20.2 and MySQL 5.0.51. The recordedseek table is getting
corrupted regularly, at least twice a week.

I used to have a combined backend/frontend/MySQL server running 32-bit
linux single core. This worked fine. Then I moved the frontend to a
separate 64-bit dual core machine and all was fine.

Then I moved the backend/SQL server to a different machine, 64-bit dual 
core, and the problems started.

Clearly it's a MySQL bug rather than a MythTV bug, but I'd welcome any
advice. The system is otherwise stable.

This happens fairly randomly. Here's an example from the log.

2008-02-19 19:30:03.607 Started recording: The 7.30 Report: channel 1001 on cardid 2, sourceid 1
[mpeg2video @ 0x2b5ebb7c1f90]ac-tex damaged at 9 35
2008-02-19 19:30:04.728 Reschedule requested for id 0.
2008-02-19 19:30:05.577 Scheduled 39 items in 0.8 = 0.02 match + 0.83 place
2008-02-19 19:55:28.308 DB Error (delta position map insert):
Query was:
INSERT INTO recordedseek (chanid, starttime, mark, type, offset) VALUES ( '1001' , '2008-02-19T19:30:00' , '37908' , 9 , '1217627872' );
Driver error was [2/126]:
QMYSQL3: Unable to execute query
Database error was:
Incorrect key file for table './mythconverg/recordedseek.MYI'; try to repair it

2008-02-19 20:03:12.802 MainServer::HandleAnnounce Monitor
2008-02-19 20:03:12.880 adding: noddy as a client (events: 0)

Sometimes the 'trying to repair' doesn't work and the errors continue 
indefinitely until I run mysqlcheck. And then mythcommflag --rebuild all
the affected recordings.

Hamish
-- 
Hamish Moffatt VK3SB <hamish at debian.org> <hamish at cloud.net.au>


More information about the mythtv-users mailing list