[mythtv-users] recordedseek table crashing regularly, still
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):
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 Moffatt VK3SB <hamish at debian.org> <hamish at cloud.net.au>
More information about the mythtv-users