[mythtv-users] mysql error

Larry Finger Larry.Finger at lwfinger.net
Sat Apr 16 20:44:26 UTC 2011


On 04/16/2011 03:20 PM, Tom Dexter wrote:
> On Sat, Apr 16, 2011 at 4:14 PM, Larry Finger<Larry.Finger at lwfinger.net>  wrote:
>> 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
>
> Any chance you've run out of disk on that partition?...the "Error
> writing to file" makes me ask.

I had checked that, but failed to report it. There is only 15% usage on that 103 
GB partition.

Larry


More information about the mythtv-users mailing list