[mythtv-users] mysql error

[Tom Dexter]

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.

Tom