[mythtv-users] slave backend doesn't see commercial flag jobs in the queue

Daniel Walton dwalton at cisco.com
Mon Aug 7 06:05:04 UTC 2006


PS

Both the master and the slave are running the latest release-0-19-fixes.

On Mon, 7 Aug 2006, Daniel Walton wrote:

> 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
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>



More information about the mythtv-users mailing list