[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