[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:28:37 UTC 2006


Actually, I take that back, it didn't fix anything. It's still broken.
So my myth setup right now is basically read-only. 

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

> -----Original Message-----
> From: Neulinger, Nathan 
> Sent: Wednesday, October 11, 2006 6:28 PM
> To: 'mythtv-users at mythtv.org'
> Subject: Problem with certain db queries failing in 
> mythbackend causing loss of all requested recordings
> 
> 
> 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