[mythtv] Backend oddness

[Robert LeBlanc]

Ok, so I've been swamped with school the last several months and finally
getting out from under it all so please excuse me if this has been
covered. I upgraded to .19 when it was released and I am running Debian
Etch. I get the following when I run the backend for a long time:

 

2006-05-09 06:21:07.805 Running HouseKeeping

2006-05-09 06:26:07.808 Running HouseKeeping

2006-05-09 06:30:17.126 MainServer::HandleAnnounce Monitor

2006-05-09 06:30:17.126 adding: picard as a client (events: 0)

2006-05-09 06:30:17.143 Reschedule requested for id -1.

2006-05-09 06:30:17.143 DB Error (UpdateMatches):

Query was:

DELETE FROM recordmatch WHERE recordid 
Driver error was [2/2006]:

QMYSQL3: Unable to execute query

Database error was:

MySQL server has gone away

 

2006-05-09 06:30:17.145 DB Error (CheckTooMany):

Query was:

SELECT recordid,title,maxepisodes,maxnewest FROM record;

Driver error was [2/2006]:

QMYSQL3: Unable to execute query

Database error was:

MySQL server has gone away

 

2006-05-09 06:30:17.146 DB Error (AddNotListed):

Query was:

SELECT record.recordid, record.type, record.chanid, record.starttime,
record.startdate, record.endtime, record.enddate, record.startoffset,
record.endoffset, record.title, record.subtitle, record.description,
channel.channum, channel.callsign, channel.name FROM record  INNER JOIN
channel ON (channel.chanid record.recordid recordmatch.chanid IS NULL

Driver error was [2/2006]:

QMYSQL3: Unable to execute query

Database error was:

MySQL server has gone away

 

2006-05-09 06:30:17.146 Scheduled 0 items in 0.0 place

2006-05-09 06:30:17.160 Unknown socket closing

2006-05-09 06:31:07.811 Running HouseKeeping

2006-05-09 06:36:07.817 Running HouseKeeping

 

The backend stops recording new programs and does not show any upcoming
recordings. The odd thing is that I can still watch old recordings
without a problem. Has this something to do with MySQL 5 that was
automatically upgraded by Debian?

 

leblanc at picard:~$ mysql -V

mysql  Ver 14.12 Distrib 5.0.20, for pc-linux-gnu (i486) using readline
5.1

leblanc at picard:~$

 

Thanks for the advice,

Robert LeBlanc

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-dev/attachments/20060509/dbae05a9/attachment.htm