Ticket #9160: commflag_log_2.txt

File commflag_log_2.txt, 2.9 KB (added by Ken Emerson <kenneth.emerson@…>, 10 years ago)

backend logfile with job stuck in jobqueue with status=4

Line 
12010-11-04 22:40:08.387 MSqlQuery::exec(DBManager1) SELECT MIN(id),dirname FROM storagegroup WHERE hostname = 'mythtv' AND groupname NOT IN ( 'DB Backups', 'Videos', 'Trailers', 'Coverart', 'Fanart', 'Screenshots', 'Banners' ) GROUP BY dirname; <<<< Returns 1 row(s)
22010-11-04 22:40:08.418 MSqlQuery::next(DBManager1) Result: "MIN(id) = 3, dirname = /mythtv/data"
32010-11-04 22:40:23.442 MSqlQuery::exec(DBManager5) SELECT MIN(id),dirname FROM storagegroup WHERE hostname = 'mythtv' AND groupname NOT IN ( 'DB Backups', 'Videos', 'Trailers', 'Coverart', 'Fanart', 'Screenshots', 'Banners' ) GROUP BY dirname; <<<< Returns 1 row(s)
42010-11-04 22:40:23.588 MSqlQuery::next(DBManager5) Result: "MIN(id) = 3, dirname = /mythtv/data"
52010-11-04 22:40:38.603 MSqlQuery::exec(DBManager0) SELECT MIN(id),dirname FROM storagegroup WHERE hostname = 'mythtv' AND groupname NOT IN ( 'DB Backups', 'Videos', 'Trailers', 'Coverart', 'Fanart', 'Screenshots', 'Banners' ) GROUP BY dirname; <<<< Returns 1 row(s)
62010-11-04 22:40:38.710 MSqlQuery::next(DBManager0) Result: "MIN(id) = 3, dirname = /mythtv/data"
72010-11-04 22:40:53.726 MSqlQuery::exec(DBManager4) SELECT MIN(id),dirname FROM storagegroup WHERE hostname = 'mythtv' AND groupname NOT IN ( 'DB Backups', 'Videos', 'Trailers', 'Coverart', 'Fanart', 'Screenshots', 'Banners' ) GROUP BY dirname; <<<< Returns 1 row(s)
82010-11-04 22:40:53.845 MSqlQuery::next(DBManager4) Result: "MIN(id) = 3, dirname = /mythtv/data"
92010-11-04 22:40:55.343 JobQueue: Currently set to run up to 2 job(s) max.
102010-11-04 22:40:55.355 MSqlQuery::exec(DBManager2) SELECT j.id, j.chanid, j.starttime, j.inserttime, j.type, j.cmds, j.flags, j.status, j.statustime, j.hostname, j.args, j.comment, r.endtime, j.schedruntime FROM jobqueue j LEFT JOIN recorded r   ON j.chanid = r.chanid AND j.starttime = r.starttime ORDER BY j.schedruntime, j.id; <<<< Returns 23 row(s)
112010-11-04 22:40:55.370 JobQueue: GetJobsInQueue: findJobs search bitmask 4, found 23 total jobs
122010-11-04 22:40:55.373 MSqlQuery::next(DBManager2) Result: "id = 7926, chanid = 1061, starttime = 2010-11-02T18:30:00, inserttime = 2010-11-02T19:00:16, type = 2, cmds = 0, flags = 0, status = 272, statustime = 2010-11-04T17:56:31, hostname = mythtv, args = , comment = 5 commercial break(s), endtime = 2010-11-02T19:00:00, schedruntime = 2010-11-02T19:00:16"
132010-11-04 22:40:55.373 JobQueue: GetJobsInQueue: Ignore 'Flag Commercials' Job for chanid 1061 @ 20101102183000 in Finished state.
142010-11-04 22:40:55.374 MSqlQuery::next(DBManager2) Result: "id = 7927, chanid = 3742, starttime = 2010-11-02T20:00:00, inserttime = 2010-11-02T21:00:17, type = 2, cmds = 0, flags = 0, status = 272, statustime = 2010-11-02T21:39:00, hostname = mythtv, args = , comment = 3 commercial break(s), endtime = 2010-11-02T21:00:00, schedruntime = 2010-11-02T21:00:17"
152010-11-04 22:40:55.384 JobQueue: GetJobsInQueue: Ignore 'Flag Commercials' Job for chanid 3742 @ 20101102200000 in Finished state.