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

[David L]

On Wed, Jan 27, 2016 at 5:56 PM, Nick Morrott <knowledgejunkie at gmail.com>
wrote:

> On 25 January 2016 at 05:37, David L <idht4n at gmail.com> wrote:
> > 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.
>
> David,
>
> An alternative strategy is to use myisamchk from the command line with
> mysqld stopped (which may or may not help).
>
> i) Shutdown mysqld (and any programs using MySQL)
>
> ii) Change to the mythconverg DB directory
> (/var/lib/mysql/mythconverg). It's always a good idea to take a backup
> of the files if you haven't already.
>
An interesting thing happened when I tried to backup the mythconverg
directory.

cp: error reading ‘program.MYD’: Input/output error
cp: failed to extend ‘/home/david/tmp/mythconverg/program.MYD’:
Input/output error

I think my hard drive might be bad.

I forced a file system check on the next reboot and rebooted several hours
ago.  It's not back up yet.  :(
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20160128/b2172434/attachment.html>