[mythtv-users] Backend seems to be crashing frontend

[Allen Edwards]

I don't know what to title this.  Yesterday, my frontend started
locking up when I tried to watch a show.  I restart the frontend and
can watch most of the shows.  But if I ESC the show, sometimes when I
go back to the same show, it locks up. Sometimes they don't lock up,
just show a black screen.  Once one show won't play, nothing will and
I either have to restart X or the reboot the computer.

I have a combined system mythbuntu 8.04 and a frontend only 8.04.1.
Both frontends experience the same problem, which to me points to the
backend.  I have had to restart the backend a couple time to get the
system going again.

I see lots of errors that just started in the backend log about the
same time this problem started. Older logs show no errors.  The only
thing I have done is get this frontend only system running but have
not touched the combined system at all.

The most interesting errors from mythbackend.log look like this:

2008-08-15 14:18:23.501 DB Error (Error in JobQueue::GetJobCmd()):
Query was:
SELECT cmds FROM jobqueue WHERE id = 340;
Driver error was [2/2006]:
QMYSQL3: Unable to execute query
Database error was:
MySQL server has gone away


I looked in the archives and googled for the last few hours (it's
3am).  I seem to remember someone saying there was something you can
run periodically to keep the DB clean, but I can't find it.

My wife is about to kill me as I discontinued Dish and its DVR and
went with ATSC and MythTV.  Your help could save me here.  Thanks.

Allen