[mythtv-users] slave backend doesn't see commercial flag jobs in the queue
Daniel Walton
dwalton at cisco.com
Mon Aug 7 04:47:06 UTC 2006
I have a slave backend (Knoppmyth R5C7 install in vwmare on a windows box) that
I'm trying to use for commercial flagging but I cannot for the life of me get
the SBE to see the jobs in the job queue. I've read several emails in the
archives on how to set this up, here is what I have done:
Master backend, hostname 'mythtv', 192.168.1.15
-----------------------------------------------
- ran mythtv-setup and unchecked the checkbox that allows this backend to run
commercial detection jobs
- job check frequency is 60 seconds
Slave backend, hostname 'mythtv2', 192.168.1.10
-----------------------------------------------
- ran mythtv-setup and verified that the box was still checked that allows this
backend to run commercial detection jobs
- job check frequency is 10 seconds
I then restarted mythbacked on the master and the slave but the slave doesn't
see any jobs in the queue. I've tried this with running the fullbackend on the
slave and with just mythjobqueue but neither sees any jobs in the queue. Here
is the log from the slave backend:
root at mythtv2:/var/log/mythtv# cat mythbackend.log
2006-08-07 00:14:38.446 Using runtime prefix = /usr/local
2006-08-07 00:14:38.567 New DB connection, total: 1
2006-08-07 00:14:38.607 Connected to database 'mythconverg' at host: localhost
2006-08-07 00:14:38.630 Enabling Settings Cache.
2006-08-07 00:14:38.641 Clearing Settings Cache.
2006-08-07 00:14:38.648 Disabling Settings Cache.
2006-08-07 00:14:38.658 Clearing Settings Cache.
2006-08-07 00:14:38.678 MSqlQuery: SELECT data FROM settings WHERE value = 'DBSchemaVer' AND hostname = 'mythtv2' ;
2006-08-07 00:14:38.695 MSqlQuery: SELECT data FROM settings WHERE value = 'DBSchemaVer' AND hostname IS NULL;
2006-08-07 00:14:38.704 Current Schema Version: 1123
2006-08-07 00:14:38.713 Enabling Settings Cache.
2006-08-07 00:14:38.722 Clearing Settings Cache.
2006-08-07 00:14:38.735 MSqlQuery: SELECT data FROM settings WHERE value = 'BackendServerPort' AND hostname = 'mythtv2' ;
2006-08-07 00:14:38.747 MSqlQuery: SELECT data FROM settings WHERE value = 'BackendStatusPort' AND hostname = 'mythtv2' ;
2006-08-07 00:14:38.762 MSqlQuery: SELECT data FROM settings WHERE value = 'BackendServerIP' AND hostname = 'mythtv2' ;
2006-08-07 00:14:38.774 MSqlQuery: SELECT data FROM settings WHERE value = 'MasterServerIP' AND hostname = 'mythtv2' ;
2006-08-07 00:14:38.788 MSqlQuery: SELECT data FROM settings WHERE value = 'MasterServerIP' AND hostname IS NULL;
Running as a slave backend.
2006-08-07 00:14:39.011 MSqlQuery: SELECT data FROM settings WHERE value = 'LogEnabled' AND hostname = 'mythtv2' ;
2006-08-07 00:14:39.024 MSqlQuery: SELECT data FROM settings WHERE value = 'LogEnabled' AND hostname IS NULL;
2006-08-07 00:14:39.039 MSqlQuery: SELECT data FROM settings WHERE value = 'LogMaxCount' AND hostname = 'mythtv2' ;
2006-08-07 00:14:39.052 MSqlQuery: SELECT data FROM settings WHERE value = 'LogPrintLevel' AND hostname = 'mythtv2' ;
2006-08-07 00:14:39.067 MSqlQuery: DELETE FROM inuseprograms WHERE hostname = 'mythtv2' AND ( recusage = 'recorder' OR recusage LIKE 'Unknown %' );
2006-08-07 00:14:39.082 MSqlQuery: SELECT cardid,hostname FROM capturecard ORDER BY cardid;
ERROR: no capture cards are defined in the database.
Perhaps you should read the installation instructions?
2006-08-07 00:14:39.870 MSqlQuery: SELECT data FROM settings WHERE value = 'JobQueueCPU' AND hostname = 'mythtv2' ;
2006-08-07 00:14:39.884 JobQueue::RecoverQueue: Checking for unfinished jobs to recover.
2006-08-07 00:14:39.886 mythbackend version: 0.19.20060121-2 www.mythtv.org
2006-08-07 00:14:39.902 Enabled verbose msgs: all
2006-08-07 00:14:39.914 New DB connection, total: 2
2006-08-07 00:14:39.924 New DB connection, total: 3
2006-08-07 00:14:39.953 Connected to database 'mythconverg' at host: localhost
2006-08-07 00:14:39.970 MSqlQuery: SELECT data FROM settings WHERE value = 'RecordFilePrefix' AND hostname = 'mythtv2' ;
2006-08-07 00:14:39.979 AutoExpire: Found 0 recorders w/max rate of 0 MiB/min
2006-08-07 00:14:39.990 MSqlQuery: SELECT data FROM settings WHERE value = 'AutoExpireExtraSpace' AND hostname = 'mythtv2' ;
2006-08-07 00:14:40.002 MSqlQuery: SELECT data FROM settings WHERE value = 'AutoExpireExtraSpace' AND hostname IS NULL;
2006-08-07 00:14:39.937 Connected to database 'mythconverg' at host: localhost
2006-08-07 00:14:40.024 MSqlQuery: SELECT data FROM settings WHERE value = 'AutoCommflagWhileRecording' AND hostname = 'mythtv2' ;
2006-08-07 00:14:40.039 MSqlQuery: SELECT data FROM settings WHERE value = 'AutoCommflagWhileRecording' AND hostname IS NULL;
2006-08-07 00:14:40.052 MSqlQuery: 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 FROM jobqueue j, recorded r WHERE j.chanid = r.chanid AND j.starttime = r.starttime ORDER BY j.inserttime, j.chanid, j.id;
2006-08-07 00:14:40.062 JobQueue::GetJobsInQueue: findJobs search bitmask 4, found 0 total jobs
2006-08-07 00:14:40.012 AutoExpire: Required Free Space: 1.0 GB w/freq: 10 min
2006-08-07 00:14:40.090 MSqlQuery: SELECT data FROM settings WHERE value = 'MasterBackendOverride' AND hostname = 'mythtv2' ;
2006-08-07 00:14:40.103 MSqlQuery: SELECT data FROM settings WHERE value = 'MasterBackendOverride' AND hostname IS NULL;
2006-08-07 00:14:41.123 MSqlQuery: SELECT data FROM settings WHERE value = 'MasterServerPort' AND hostname = 'mythtv2' ;
2006-08-07 00:14:41.137 MSqlQuery: SELECT data FROM settings WHERE value = 'MasterServerPort' AND hostname IS NULL;
2006-08-07 00:14:41.149 Connecting to master server: 192.168.1.15:6543
2006-08-07 00:14:41.183 Connected successfully
2006-08-07 00:14:41.192 write -> 12 37 ANN SlaveBackend mythtv2 192.168.1.10
2006-08-07 00:14:41.207 read <- 12 2 OK
2006-08-07 00:14:46.221 AutoExpire: Found 0 recorders w/max rate of 0 MiB/min
2006-08-07 00:14:46.231 AutoExpire: Required Free Space: 1.0 GB w/freq: 10 min
2006-08-07 00:14:49.093 MSqlQuery: SELECT lastrun FROM housekeeping WHERE tag = 'JobQueueRecover-mythtv2' ;
2006-08-07 00:14:50.073 JobQueue::ProcessQueue() started
2006-08-07 00:14:50.089 MSqlQuery: SELECT data FROM settings WHERE value = 'JobQueueCheckFrequency' AND hostname = 'mythtv2' ;
2006-08-07 00:14:50.101 MSqlQuery: SELECT data FROM settings WHERE value = 'JobQueueWindowStart' AND hostname = 'mythtv2' ;
2006-08-07 00:14:50.114 MSqlQuery: SELECT data FROM settings WHERE value = 'JobQueueWindowEnd' AND hostname = 'mythtv2' ;
2006-08-07 00:14:50.128 MSqlQuery: SELECT data FROM settings WHERE value = 'JobQueueMaxSimultaneousJobs' AND hostname = 'mythtv2' ;
2006-08-07 00:14:50.139 JobQueue currently set at 1 job(s) max and to run new jobs from 00:00 to 23:59
2006-08-07 00:14:50.151 MSqlQuery: 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 FROM jobqueue j, recorded r WHERE j.chanid = r.chanid AND j.starttime = r.starttime ORDER BY j.inserttime, j.chanid, j.id;
2006-08-07 00:14:50.158 JobQueue::GetJobsInQueue: findJobs search bitmask 4, found 0 total jobs
2006-08-07 00:14:59.880 MSqlQuery: SELECT chanid, starttime, lastupdatetime, recusage, hostname FROM inuseprograms;
2006-08-07 00:14:59.892 AutoExpire: ExpireLiveTV(10000)
2006-08-07 00:14:59.907 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 = 'mythtv2' ORDER BY autoexpire DESC, starttime ASC
2006-08-07 00:14:59.918 AutoExpire: SendDeleteMessages. Nothing to expire.
2006-08-07 00:15:00.170 JobQueue currently set at 1 job(s) max and to run new jobs from 00:00 to 23:59
2006-08-07 00:15:00.182 MSqlQuery: 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 FROM jobqueue j, recorded r WHERE j.chanid = r.chanid AND j.starttime = r.starttime ORDER BY j.inserttime, j.chanid, j.id;
2006-08-07 00:15:00.191 JobQueue::GetJobsInQueue: findJobs search bitmask 4, found 0 total jobs
The master backend does see the jobs in the queue but recognizes that he
shouldn't work on them:
2006-08-07 00:31:04.487 JobQueue currently set at 1 job(s) max and to run new jobs from 00:00 to 23:59
2006-08-07 00:31:04.488 MSqlQuery: 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 FROM jobqueue j, recorded r WHERE j.chanid = r.chanid AND j.starttime = r.starttime ORDER BY j.inserttime, j.chanid, j.id;
2006-08-07 00:31:04.488 JobQueue::GetJobsInQueue: findJobs search bitmask 4, found 5 total jobs
2006-08-07 00:31:04.489 JobQueue::GetJobsInQueue: Ignore 'Flag Commercials' Job for 2066 @ 20060805080000 in Finished state.
2006-08-07 00:31:04.489 JobQueue::GetJobsInQueue: Ignore 'Flag Commercials' Job for 1510 @ 20060805120000 in Finished state.
2006-08-07 00:31:04.489 JobQueue::GetJobsInQueue: Found 'Flag Commercials' Job for 2030 @ 20060806190000 in Queued state.
2006-08-07 00:31:04.489 JobQueue::GetJobsInQueue: Found 'Flag Commercials' Job for 2030 @ 20060806220000 in Queued state.
2006-08-07 00:31:04.489 JobQueue::GetJobsInQueue: Found 'Flag Commercials' Job for 1520 @ 20060806211500 in Queued state.
2006-08-07 00:31:04.490 JobQueue: Currently Running 0 jobs.
2006-08-07 00:31:04.490 JobQueue: Skipping 'Flag Commercials' job for chanid 2030 @ 20060806190000, not allowed to run on this backend.
2006-08-07 00:31:04.490 JobQueue: Skipping 'Flag Commercials' job for chanid 2030 @ 20060806220000, not allowed to run on this backend.
2006-08-07 00:31:04.490 JobQueue: Skipping 'Flag Commercials' job for chanid 1520 @ 20060806211500, not allowed to run on this backend.
Why is the slave backend not seeing any of the jobs?
Thanks
Daniel
More information about the mythtv-users
mailing list