[mythtv-users] mythconverg/program is marked as crashed

[David L]

mythfilldatabase stopped working for me about a month ago.  I get errors
like this:
016-01-24 21:18:01.068920 E  Error preparing query: DELETE FROM program
WHERE starttime >= :FROM AND starttime < :TO AND chanid = :CHANID ;
2016-01-24 21:18:01.068931 E  Driver error was [2/144]:
QMYSQL3: Unable to prepare statement
Database error was:
Table './mythconverg/program' is marked as crashed and last (automatic?)
repair failed

2016-01-24 21:18:01.069814 E  Error preparing query: DELETE FROM program
WHERE starttime >= :FROM AND starttime < :TO AND chanid = :CHANID ;

I googled a bit and found some people that had similar problems.  I tried
this recommended solution:

mysqlcheck -r -umythtv -pxxxxxxxx mythconverg

But that also gave me an error:

mythconverg.program
error    : Can't create new tempfile: './mythconverg/program.TMD'
status   : Operation failed

I have enough disk space, so that's not the problem.  I also found people
with similar problems but didn't quite follow the solutions.  Any help
would be appreciated.

Thanks,

           David

PS - I don't think I did anything to cause it to break AFAIK.  It's
possible the disk was temporarily full or the system was rebooted, but I
did nothing to mythtv around the time it broke.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20160124/16a7dad3/attachment.html>