[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