[mythtv-users] mysql error
digitalaudiorock at gmail.com
Sat Apr 16 20:20:52 UTC 2011
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:
> 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?
Any chance you've run out of disk on that partition?...the "Error
writing to file" makes me ask.
More information about the mythtv-users