[mythtv] mysql keeps crashing

usleepless at gmail.com usleepless at gmail.com
Fri Jun 16 21:02:49 UTC 2006


Hi Michael,

> My mysql server keeps crashing and myth does not
> reconnect, only why to fix is to restart the backend.
>
> Any thoughs on how to figure out what is going on?
>
> mysql version:
> Server version          5.0.21-log
>
> Error messages:
> 060604 05:18:20  mysqld started
> 060604  5:18:21  InnoDB: Started; log sequence number
> 0 43912
> 060604  5:18:21 [Note] Recovering after a crash using
> mysql-bin
> 060604  5:18:22 [Note] Starting crash recovery...
> 060604  5:18:22 [Note] Crash recovery finished.
>
>
> Backend Error Messages
> 2006-06-08 23:34:01.242 DB Error (UpdateMatches):
> Query was:
> DELETE FROM recordmatch WHERE recordid = 219 OR 219 =
> -1;
> Driver error was [2/2006]:
> QMYSQL3: Unable to execute query
> Database error was:
> MySQL server has gone away

this is because mysql is a shitty database in the first place.
unfortunatly, mythtv out of the box supports only mysql. good luck.

you could try to reindex the recordmatch table, or dump the database
and reload it again. i don't know the details of these procedures,
sorry.

regards,

usleep


More information about the mythtv-dev mailing list