[mythtv-users] mysql error
Larry Finger
Larry.Finger at lwfinger.net
Sat Apr 16 20:14:14 UTC 2011
I was checking my mythtv logs and discovered many of the following:
QMYSQL3: Unable to execute query
Database error was:
Table './mythconverg/recordedseek' is marked as crashed and should be repaired
2011-04-16 13:00:00.182 DB Error (delta position map insert):
Query was:
INSERT INTO recordedseek (chanid, starttime, mark, type, offset) VALUES ( '1011'
, '2011-04-16T12:30:00' , 3588 , 6 , 1164660736 );
Driver error was [2/145]:
Using info from the Mythtv web pages, I used the following command to try to fix it:
mysqlcheck -r -umythtv -p<password> mythconverg
It produces the following output for redordedseek:
mythconverg.recordedseek
error : 5 when fixing table
error : 5 when trying to write bufferts
Error : Error writing file '/var/lib/mysql/mythconverg/recordedseek.MYI'
(Errcode: 5)
status : Operation failed
The file mentioned above is owned by mythtv, which has rw privileges.
I'm running Mythtv version 0.21. I subscribe to "if it isn't broken, ...".
What other steps can I take?
Thanks,
Larry
More information about the mythtv-users
mailing list