[mythtv-users] Problem with certain db queries failing in mythbackend causing loss of all requested recordings

Neulinger, Nathan nneul at umr.edu
Wed Oct 11 23:27:30 UTC 2006


Everything else works fine, but I get a few errors immediately on
startup that fail, and nothing in the future recordings or scheduled
recordings screen.

This goes away if I run with -v database.  This did NOT occur in
0.19.20060631-1 - the last version I could run on my backend before this
problem started. Needed to upgrade recently for other reasons. The DB
backend has been 5.0.2x for a while. There is most definately not a DB
"timeout" occurring here as this is a metter of a couple seconds after
startup... 

As adding -v database resolves the issue temporarily as a hack, it's not
an emergency anymore, but it's a kindof sucky way to deal with the
problem... Is myth not retrying failed queries, and even so, why is it
losing the db connection in the first place?

-- Nathan


Oct 11 18:05:24 skyhawk mythbackend: 2006-10-11 18:05:24.613 Database
Schema upgrade complete, unlocking.
Oct 11 18:05:24 skyhawk mythbackend: 2006-10-11 18:05:24.622 DB Error
(Updating record basename):
Oct 11 18:05:24 skyhawk mythbackend: Query was:
Oct 11 18:05:24 skyhawk mythbackend: 
Oct 11 18:05:24 skyhawk mythbackend: No error type from QSqlError?
Strange...
Oct 11 18:05:24 skyhawk mythbackend: 2006-10-11 18:05:24.622 DB Error
(Updating channel callsign):
Oct 11 18:05:24 skyhawk mythbackend: Query was:
Oct 11 18:05:24 skyhawk mythbackend: 
Oct 11 18:05:24 skyhawk mythbackend: No error type from QSqlError?
Strange...
Oct 11 18:05:24 skyhawk mythbackend: 2006-10-11 18:05:24.622 DB Error
(Querying minimum chanid):
Oct 11 18:05:24 skyhawk mythbackend: Query was:
Oct 11 18:05:24 skyhawk mythbackend: 
Oct 11 18:05:24 skyhawk mythbackend: No error type from QSqlError?
Strange...
Oct 11 18:05:24 skyhawk mythbackend: 2006-10-11 18:05:24.624
Main::Starting HttpServer
Oct 11 18:05:24 skyhawk mythbackend: 2006-10-11 18:05:24.650
Main::Registering HttpStatus Extension
Oct 11 18:05:24 skyhawk mythbackend: 2006-10-11 18:05:24.654 DB Error
(Error in JobQueue::GetJobs(), Unable to query list of Jobs in Queue.):
Oct 11 18:05:24 skyhawk mythbackend: Query was:
Oct 11 18:05:24 skyhawk mythbackend: SELECT j.id, j.chanid, j.starttime,
j.inserttime, j.type, j.cmds, j.flags, j.status, j.statustime, j.host
name, j.args, j.comment, r.endtime FROM jobqueue j, recorded r WHERE
j.chanid = r.chanid AND j.starttime = r.starttime ORDER BY j.inserttime,

j.chanid, j.id;
Oct 11 18:05:24 skyhawk mythbackend: Driver error was [2/2006]:
Oct 11 18:05:24 skyhawk mythbackend: QMYSQL3: Unable to execute query
Oct 11 18:05:24 skyhawk mythbackend: Database error was:
Oct 11 18:05:24 skyhawk mythbackend: MySQL server has gone away
Oct 11 18:05:24 skyhawk mythbackend: 
Oct 11 18:05:24 skyhawk mythbackend: 2006-10-11 18:05:24.722 mythbackend
version: 0.20.20061004-2 www.mythtv.org



 
------------------------------------------------------------
Nathan Neulinger                       EMail:  nneul at umr.edu
University of Missouri - Rolla         Phone: (573) 341-6679
UMR Information Technology             Fax: (573) 341-4216



More information about the mythtv-users mailing list