[mythtv-users] jobs queuing, not running
jack snodgrass
mrlinuxgroups at gmail.com
Mon Oct 23 19:33:59 UTC 2006
On 10/23/06, jack snodgrass <mrlinuxgroups at gmail.com> wrote:
> On 10/23/06, jack snodgrass <mrlinuxgroups at gmail.com> wrote:
> > On 10/23/06, Jens Baumeister <jens.baumeister at gmail.com> wrote:
> > > Hi!
> > >
> > > On 10/23/06, jack snodgrass <mrlinuxgroups at gmail.com> wrote:
> > > > My jobs, mythcomflag, transcode, user job#1, user job#2, etc
> > > > all just queue.
> > > [...]
> > > > what am I missing?
> > >
> > > You have to allow the backend to run the jobs in mythtv-setup. (It's
> > > best to stop mythbackend before running mythtv-setup.)
> > >
> > > Jens
> >
> > on my server where I'm running
> > I have it setup so that it points to my 'master backend' and it has
> > all of the allow X jobs checked. I've told it do allow for 3 simultaenous
> > jobs from 00:00 - 23:59. I re-started mythbackend on the master
> > backend and started my mythjobqueue on the new box after I ran
> > mythtv-setup on that server and enabled the jobs.
> >
> > ... could it be that in my backend logs... I see entries like
> > fw.private.net (fully
> > quallified names and in my database for the 4 user jobs and the mythcommflag
> > and mythtranscode... for the backend, all I have is amd ( not a fully quallified
> > namd ) is myth looking for amd.private.net and not just amd?
> >
> > jack
> >
>
> I ran
> mythjobqueue -v all
> and it is just looking for 'amd' ...
> MSqlQuery: SELECT data FROM settings WHERE value = 'JobQueueCPU' AND
> hostname = 'amd' ;
>
> I changed the JobQueueCPU for amd.private.net to amd so that the
> requery ruturns data,
> but when I ran mythjobqueue -v all it still doesn't seem to run any
> jobs from the queue...
>
> mythbackend -v all
> starts and looks for 'amd' too... it runs a 'expire' loop, but never
> starts any of the
> mythcommflag or transcode things....
>
> jack
>
I shutdown both backend processess...
I changed my hostname on both the backend and the '2nd' server to use
fully qualified names.
I changed the 2nd back end to use it's public IP instead of 127.0.0.1
I purged the job queue of old jobs
I restated the master back end
I restarted the 2nd back end
I recorded 2 shows and told myth to do commercial flagging.
It's been over an hour since they shows stopped recording.
I still have 2 items in the queue... commerical flagging for each show.
My backend has:
2006-10-23 14:28:29.746 AutoExpire: SendDeleteMessages. Nothing to expire.
2006-10-23 14:29:14.777 MSqlQuery: SELECT lastrun FROM housekeeping
WHERE tag = 'JobQueueRecover-amd.private.net' ;
2006-10-23 14:29:29.797 MSqlQuery: SELECT chanid, starttime,
lastupdatetime, recusage, hostname FROM inuseprograms;
2006-10-23 14:30:29.842 MSqlQuery: SELECT chanid, starttime,
lastupdatetime, recusage, hostname FROM inuseprograms;
2006-10-23 14:30:29.843 AutoExpire: ExpireLiveTV(10000)
2006-10-23 14:30:29.844 MSqlQuery: SELECT recorded.chanid, starttime,
endtime, title, subtitle, description,
hostname, channum, name, callsign,
seriesid, programid, recorded.recpriority,
progstart, progend, filesize, recgroup FROM recorded
LEFT JOIN channel ON recorded.chanid = channel.chanid WHERE recgroup =
'LiveTV' AND endtime < DATE_ADD(starttime, INTERVAL '2' MINUTE) AND
endtime <= DATE_ADD(NOW(), INTERVAL '-1' MINUTE) AND hostname =
'amd.private.net' AND deletepending = 0 ORDER BY autoexpire DESC,
starttime ASC
2006-10-23 14:30:29.844 AutoExpire: SendDeleteMessages. Nothing to expire.
2006-10-23 14:30:29.844 AutoExpire: ExpireLiveTV(10001)
2006-10-23 14:30:29.846 MSqlQuery: SELECT recorded.chanid, starttime,
endtime, title, subtitle, description,
hostname, channum, name, callsign,
seriesid, programid, recorded.recpriority,
progstart, progend, filesize, recgroup FROM recorded
LEFT JOIN channel ON recorded.chanid = channel.chanid WHERE recgroup =
'LiveTV' AND endtime <= DATE_ADD(NOW(), INTERVAL '-7' DAY) AND
hostname = 'amd.private.net' AND deletepending = 0 ORDER BY
autoexpire DESC, starttime ASC
2006-10-23 14:30:29.846 AutoExpire: SendDeleteMessages. Nothing to expire.
2006-10-23 14:31:29.895 MSqlQuery: SELECT chanid, starttime,
lastupdatetime, recusage, hostname FROM inuseprograms;
my 2nd backend has:
2006-10-23 14:29:48.451 MSqlQuery: SELECT
recorded.chanid,starttime,endtime,title,
subtitle,description,channel.channum,
channel.callsign,channel.name,channel.commfree,
channel.outputfilters,seriesid,programid,filesize,
lastmodified,stars,previouslyshown,originalairdate,
hostname,recordid,transcoder,playgroup,
recorded.recpriority,progstart,progend,basename,recgroup FROM recorded
LEFT JOIN channel ON recorded.chanid = channel.chanid WHERE
recorded.chanid = '1018' AND starttime = '2006-10-23T12:50:00' ;
2006-10-23 14:29:48.452 MSqlQuery: SELECT commflagged, cutlist,
autoexpire, editing, bookmark, stereo, closecaptioned, hdtv, watched,
preserve FROM recorded LEFT JOIN recordedprogram ON (recorded.chanid =
recordedprogram.chanid AND recorded.starttime =
recordedprogram.starttime) WHERE recorded.chanid = '1018' AND
recorded.starttime = '2006-10-23T12:50:00' ;
2006-10-23 14:29:48.454 MSqlQuery: SELECT chanid FROM record WHERE
recordid = 220;
2006-10-23 14:29:48.454 MSqlQuery: SELECT station FROM record WHERE
recordid = 220;
2006-10-23 14:29:48.455 MSqlQuery: SELECT title FROM record WHERE
recordid = 220;
2006-10-23 14:29:48.455 MSqlQuery: SELECT subtitle FROM record WHERE
recordid = 220;
2006-10-23 14:29:48.455 MSqlQuery: SELECT description FROM record
WHERE recordid = 220;
2006-10-23 14:29:48.456 MSqlQuery: SELECT starttime FROM record WHERE
recordid = 220;
2006-10-23 14:29:48.456 MSqlQuery: SELECT endtime FROM record WHERE
recordid = 220;
2006-10-23 14:29:48.457 MSqlQuery: SELECT startdate FROM record WHERE
recordid = 220;
2006-10-23 14:29:48.457 MSqlQuery: SELECT enddate FROM record WHERE
recordid = 220;
2006-10-23 14:29:48.457 MSqlQuery: SELECT category FROM record WHERE
recordid = 220;
2006-10-23 14:29:48.458 MSqlQuery: SELECT seriesid FROM record WHERE
recordid = 220;
2006-10-23 14:29:48.458 MSqlQuery: SELECT programid FROM record WHERE
recordid = 220;
2006-10-23 14:29:48.458 MSqlQuery: SELECT findday FROM record WHERE
recordid = 220;
2006-10-23 14:29:48.459 MSqlQuery: SELECT findtime FROM record WHERE
recordid = 220;
2006-10-23 14:29:48.459 MSqlQuery: SELECT findid FROM record WHERE
recordid = 220;
2006-10-23 14:29:48.459 MSqlQuery: SELECT parentid FROM record WHERE
recordid = 220;
2006-10-23 14:29:48.460 MSqlQuery: SELECT search FROM record WHERE
recordid = 220;
2006-10-23 14:29:48.460 MSqlQuery: SELECT type FROM record WHERE recordid = 220;
2006-10-23 14:29:48.460 MSqlQuery: SELECT recpriority FROM record
WHERE recordid = 220;
2006-10-23 14:29:48.461 MSqlQuery: SELECT startoffset FROM record
WHERE recordid = 220;
2006-10-23 14:29:48.461 MSqlQuery: SELECT endoffset FROM record WHERE
recordid = 220;
2006-10-23 14:29:48.461 MSqlQuery: SELECT dupmethod FROM record WHERE
recordid = 220;
2006-10-23 14:29:48.462 MSqlQuery: SELECT dupin FROM record WHERE
recordid = 220;
2006-10-23 14:29:48.462 MSqlQuery: SELECT
cardinputid,cardid,inputname,displayname FROM cardinput ORDER BY
cardinputid
2006-10-23 14:29:48.463 MSqlQuery: SELECT prefinput FROM record WHERE
recordid = 220;
2006-10-23 14:29:48.463 MSqlQuery: SELECT inactive FROM record WHERE
recordid = 220;
2006-10-23 14:29:48.463 MSqlQuery: SELECT profile FROM record WHERE
recordid = 220;
2006-10-23 14:29:48.464 MSqlQuery: SELECT DISTINCT recgroup FROM recorded
2006-10-23 14:29:48.464 MSqlQuery: SELECT DISTINCT recgroup FROM record
2006-10-23 14:29:48.465 MSqlQuery: SELECT recgroup FROM record WHERE
recordid = 220;
2006-10-23 14:29:48.465 MSqlQuery: SELECT name FROM playgroup WHERE
name <> 'Default' ORDER BY name;
2006-10-23 14:29:48.466 MSqlQuery: SELECT playgroup FROM record WHERE
recordid = 220;
2006-10-23 14:29:48.466 MSqlQuery: SELECT autoexpire FROM record WHERE
recordid = 220;
2006-10-23 14:29:48.467 MSqlQuery: SELECT maxepisodes FROM record
WHERE recordid = 220;
2006-10-23 14:29:48.467 MSqlQuery: SELECT maxnewest FROM record WHERE
recordid = 220;
2006-10-23 14:29:48.467 MSqlQuery: SELECT autocommflag FROM record
WHERE recordid = 220;
2006-10-23 14:29:48.468 MSqlQuery: SELECT autotranscode FROM record
WHERE recordid = 220;
2006-10-23 14:29:48.468 MSqlQuery: SELECT name, id FROM
recordingprofiles WHERE profilegroup = 6 ORDER BY id
2006-10-23 14:29:48.469 MSqlQuery: SELECT transcoder FROM record WHERE
recordid = 220;
2006-10-23 14:29:48.469 MSqlQuery: SELECT autouserjob1 FROM record
WHERE recordid = 220;
2006-10-23 14:29:48.470 MSqlQuery: SELECT autouserjob2 FROM record
WHERE recordid = 220;
2006-10-23 14:29:48.470 MSqlQuery: SELECT autouserjob3 FROM record
WHERE recordid = 220;
2006-10-23 14:29:48.470 MSqlQuery: SELECT autouserjob4 FROM record
WHERE recordid = 220;
2006-10-23 14:29:48.471 MSqlQuery: SELECT channum, callsign, name FROM
channel WHERE chanid = '1018';
2006-10-23 14:29:48.471 MSqlQuery: SELECT channum, callsign, name FROM
channel WHERE chanid = '1018';
2006-10-23 14:29:48.480 MSqlQuery: SELECT MAX(endtime) FROM program
WHERE manualid = 0;
2006-10-23 14:29:48.482 HttpWorkerThread::ProcessWork:End( 1157658944 )
2006-10-23 14:29:48.693 MythSocket(2aaab061d8b0:17): socket is readable
2006-10-23 14:29:48.693 MythSocket(2aaab061d8b0:17): socket closed
2006-10-23 14:29:48.693 MythSocket(2aaab061d8b0:17): state change
Connected -> Idle
2006-10-23 14:29:48.693 MythSocket(2aaab061d8b0:-1): cb->connectionClosed()
2006-10-23 14:29:57.471 MSqlQuery: SELECT chanid, starttime,
lastupdatetime, recusage, hostname FROM inuseprograms;
2006-10-23 14:30:31.632 MythSocket(2aaab0640210:-1): DownRef: 0
2006-10-23 14:30:31.634 MythSocket(2aaab061d8b0:-1): DownRef: 0
2006-10-23 14:30:31.634 MythSocket(2aaab061d8b0:-1): DownRef: -1
2006-10-23 14:30:31.634 MythSocket(2aaab061d8b0:-1): delete socket
2006-10-23 14:30:31.634 MythSocket(2aaab0640210:-1): DownRef: -1
2006-10-23 14:30:31.634 MythSocket(2aaab0640210:-1): delete socket
2006-10-23 14:30:57.524 MSqlQuery: SELECT chanid, starttime,
lastupdatetime, recusage, hostname FROM inuseprograms;
2006-10-23 14:30:57.525 AutoExpire: ExpireLiveTV(10000)
2006-10-23 14:30:57.526 MSqlQuery: SELECT recorded.chanid, starttime,
endtime, title, subtitle, description,
hostname, channum, name, callsign,
seriesid, programid, recorded.recpriority,
progstart, progend, filesize, recgroup FROM recorded
LEFT JOIN channel ON recorded.chanid = channel.chanid WHERE recgroup =
'LiveTV' AND endtime < DATE_ADD(starttime, INTERVAL '2' MINUTE) AND
endtime <= DATE_ADD(NOW(), INTERVAL '-1' MINUTE) AND hostname =
'fw.private.net' AND deletepending = 0 ORDER BY autoexpire DESC,
starttime ASC
2006-10-23 14:30:57.526 AutoExpire: SendDeleteMessages. Nothing to expire.
2006-10-23 14:31:41.686 MSqlQuery: SELECT COUNT(*) FROM videosource
WHERE xmltvgrabber IN ( 'datadirect', 'technovera' );
2006-10-23 14:31:41.687 MSqlQuery: SELECT lastrun FROM housekeeping
WHERE tag = 'MythFillDB' ;
2006-10-23 14:31:41.688 MSqlQuery: SELECT lastrun FROM housekeeping
WHERE tag = 'DailyCleanup' ;
2006-10-23 14:31:41.689 MSqlQuery: SELECT lastrun FROM housekeeping
WHERE tag = 'JobQueueRecover-fw.private.net' ;
2006-10-23 14:31:57.577 MSqlQuery: SELECT chanid, starttime,
lastupdatetime, recusage, hostname FROM inuseprograms;
2006-10-23 14:32:57.628 MSqlQuery: SELECT chanid, starttime,
lastupdatetime, recusage, hostname FROM inuseprograms;
2006-10-23 14:32:57.628 AutoExpire: ExpireLiveTV(10000)
2006-10-23 14:32:57.629 MSqlQuery: SELECT recorded.chanid, starttime,
endtime, title, subtitle, description,
hostname, channum, name, callsign,
seriesid, programid, recorded.recpriority,
progstart, progend, filesize, recgroup FROM recorded
LEFT JOIN channel ON recorded.chanid = channel.chanid WHERE recgroup =
'LiveTV' AND endtime < DATE_ADD(starttime, INTERVAL '2' MINUTE) AND
endtime <= DATE_ADD(NOW(), INTERVAL '-1' MINUTE) AND hostname =
'fw.private.net' AND deletepending = 0 ORDER BY autoexpire DESC,
starttime ASC
2006-10-23 14:32:57.630 AutoExpire: SendDeleteMessages. Nothing to expire.
2006-10-23 14:32:57.630 AutoExpire: ExpireLiveTV(10001)
2006-10-23 14:32:57.631 MSqlQuery: SELECT recorded.chanid, starttime,
endtime, title, subtitle, description,
hostname, channum, name, callsign,
seriesid, programid, recorded.recpriority,
progstart, progend, filesize, recgroup FROM recorded
LEFT JOIN channel ON recorded.chanid = channel.chanid WHERE recgroup =
'LiveTV' AND endtime <= DATE_ADD(NOW(), INTERVAL '-7' DAY) AND
hostname = 'fw.private.net' AND deletepending = 0 ORDER BY autoexpire
DESC, starttime ASC
2006-10-23 14:32:57.631 AutoExpire: SendDeleteMessages. Nothing to expire.
2006-10-23 14:32:57.632 MSqlQuery: SELECT recordid, maxepisodes, title
FROM record WHERE maxepisodes > 0 ORDER BY recordid ASC, maxepisodes
DESC
2006-10-23 14:32:57.632 AutoExpire: Checking episode count for each
recording profile using max episodes
neither one is doing the commerical flagging...
any ideas?
jack
More information about the mythtv-users
mailing list