[mythtv-users] No Upcoming Recordings
James Pifer
jep at obrien-pifer.com
Mon Oct 9 19:51:24 UTC 2006
> Can you try looking at the backend logs using 'mythbackend -v database'
> when you enter Manage Recordings? I wonder if there is something going
> on there.
>
> Kevin
I get nothing:
2006-10-09 15:48:32.316 MainServer::HandleAnnounce Monitor
2006-10-09 15:48:32.317 adding: mythtv-be as a client (events: 0)
2006-10-09 15:48:32.317 MainServer::HandleAnnounce Monitor
2006-10-09 15:48:32.318 adding: mythtv-be as a client (events: 1)
There are a couple erros in there, and I don't really understand the
slave server stuff, since I have only one backend.
Here's the whole thing from the start:
[root at mythtv-be X11]# mythbackend -v database
2006-10-09 15:47:44.203 Using runtime prefix = /usr
2006-10-09 15:47:44.245 New DB connection, total: 1
2006-10-09 15:47:44.254 Connected to database 'mythconverg' at host: localhost
2006-10-09 15:47:44.257 Enabling Settings Cache.
2006-10-09 15:47:44.258 Clearing Settings Cache.
2006-10-09 15:47:44.258 Disabling Settings Cache.
2006-10-09 15:47:44.258 Clearing Settings Cache.
2006-10-09 15:47:44.261 MSqlQuery: SELECT data FROM settings WHERE value = 'DBSchemaVer' AND hostname = 'mythtv-be' ;
2006-10-09 15:47:44.263 MSqlQuery: SELECT data FROM settings WHERE value = 'DBSchemaVer' AND hostname IS NULL;
2006-10-09 15:47:44.263 Current Schema Version: 1160
2006-10-09 15:47:44.264 Enabling Settings Cache.
2006-10-09 15:47:44.264 Clearing Settings Cache.
2006-10-09 15:47:44.265 MSqlQuery: SELECT data FROM settings WHERE value = 'BackendServerPort' AND hostname = 'mythtv-be' ;
2006-10-09 15:47:44.267 MSqlQuery: SELECT data FROM settings WHERE value = 'BackendStatusPort' AND hostname = 'mythtv-be' ;
2006-10-09 15:47:44.268 MSqlQuery: SELECT data FROM settings WHERE value = 'BackendServerIP' AND hostname = 'mythtv-be' ;
2006-10-09 15:47:44.270 MSqlQuery: SELECT data FROM settings WHERE value = 'MasterServerIP' AND hostname = 'mythtv-be' ;
2006-10-09 15:47:44.271 MSqlQuery: SELECT data FROM settings WHERE value = 'MasterServerIP' AND hostname IS NULL;
Running as a slave backend.
2006-10-09 15:47:44.273 MSqlQuery: SELECT data FROM settings WHERE value = 'LogEnabled' AND hostname = 'mythtv-be' ;
2006-10-09 15:47:44.274 MSqlQuery: SELECT data FROM settings WHERE value = 'LogEnabled' AND hostname IS NULL;
2006-10-09 15:47:44.276 MSqlQuery: SELECT data FROM settings WHERE value = 'LogMaxCount' AND hostname = 'mythtv-be' ;
2006-10-09 15:47:44.277 MSqlQuery: SELECT data FROM settings WHERE value = 'LogPrintLevel' AND hostname = 'mythtv-be' ;
2006-10-09 15:47:44.278 MSqlQuery: DELETE FROM inuseprograms WHERE hostname = 'mythtv-be' AND ( recusage = 'recorder' OR recusage LIKE 'Unknown %' );
2006-10-09 15:47:44.280 MSqlQuery: SELECT cardid, hostname FROM capturecard WHERE parentid = '0' ORDER BY cardid
2006-10-09 15:47:44.282 New DB connection, total: 2
2006-10-09 15:47:44.283 Connected to database 'mythconverg' at host: localhost
2006-10-09 15:47:44.285 MSqlQuery: SELECT data FROM settings WHERE value = 'EITTimeOffset' AND hostname = 'mythtv-be' ;
2006-10-09 15:47:44.286 MSqlQuery: SELECT data FROM settings WHERE value = 'EITTimeOffset' AND hostname IS NULL;
2006-10-09 15:47:44.286 EITHelper: localtime offset -4:00:00
2006-10-09 15:47:44.288 MSqlQuery: SELECT data FROM settings WHERE value = 'ISO639Language0' AND hostname = 'mythtv-be' ;
2006-10-09 15:47:44.290 MSqlQuery: SELECT data FROM settings WHERE value = 'ISO639Language1' AND hostname = 'mythtv-be' ;
2006-10-09 15:47:44.291 MSqlQuery: SELECT data FROM settings WHERE value = 'ISO639Language2' AND hostname = 'mythtv-be' ;
2006-10-09 15:47:44.292 MSqlQuery: SELECT data FROM settings WHERE value = 'ISO639Language2' AND hostname IS NULL;
2006-10-09 15:47:44.294 MSqlQuery: SELECT videodevice, vbidevice, audiodevice, audioratelimit, defaultinput, cardtype, skipbtaudio, signal_timeout, channel_timeout, dvb_wait_for_seqstart, dvb_on_demand, dvb_tuning_delay, firewire_port, firewire_node, firewire_speed, firewire_model, firewire_connection, dbox2_port, dbox2_host, dbox2_httpport FROM capturecard WHERE cardid = 1
2006-10-09 15:47:44.296 MSqlQuery: SELECT startchan FROM capturecard, cardinput WHERE capturecard.cardid = cardinput.cardid AND capturecard.cardid = 1 AND inputname = 'Tuner 1'
2006-10-09 15:47:44.298 MSqlQuery: SELECT cardinputid, inputname, startchan, tunechan, externalcommand, sourceid, childcardid FROM cardinput WHERE cardid = 1
2006-10-09 15:47:44.299 New DB connection, total: 3
2006-10-09 15:47:44.300 Connected to database 'mythconverg' at host: localhost
2006-10-09 15:47:44.302 MSqlQuery: SELECT data FROM settings WHERE value = 'ChannelOrdering' AND hostname = 'mythtv-be' ;
2006-10-09 15:47:44.303 MSqlQuery: SELECT chanid, favid FROM favorites
2006-10-09 15:47:44.309 MSqlQuery: SELECT channum, callsign, chanid, atsc_major_chan, atsc_minor_chan, name, icon, visible FROM channel WHERE sourceid='1'
2006-10-09 15:47:44.329 MSqlQuery: SELECT data FROM settings WHERE value = 'TVFormat' AND hostname = 'mythtv-be' ;
2006-10-09 15:47:44.331 MSqlQuery: SELECT data FROM settings WHERE value = 'TVFormat' AND hostname IS NULL;
2006-10-09 15:47:44.332 MSqlQuery: SELECT data FROM settings WHERE value = 'FreqTable' AND hostname = 'mythtv-be' ;
2006-10-09 15:47:44.333 MSqlQuery: SELECT data FROM settings WHERE value = 'FreqTable' AND hostname IS NULL;
2006-10-09 15:47:44.335 MSqlQuery: SELECT channel.chanid FROM channel, capturecard, cardinput WHERE channel.channum = '2' AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = 'Tuner 1' AND cardinput.cardid = capturecard.cardid AND capturecard.cardid = 1 AND capturecard.hostname = 'mythtv-be'
2006-10-09 15:47:44.337 MSqlQuery: SELECT finetune, freqid, tvformat, freqtable, commfree, mplexid, atsc_major_chan, atsc_minor_chan, serviceid FROM channel, videosource WHERE videosource.sourceid = channel.sourceid AND channum = '2' AND channel.sourceid = 1
2006-10-09 15:47:44.338 MSqlQuery: SELECT channel.brightness FROM channel WHERE channum = '' AND sourceid = 1
2006-10-09 15:47:44.340 MSqlQuery: SELECT brightness FROM capturecard, cardinput WHERE sourceid = 1 AND cardinput.cardid = 1 AND ( ( cardinput.childcardid != '0' AND cardinput.childcardid = capturecard.cardid ) OR ( cardinput.childcardid = '0' AND cardinput.cardid = capturecard.cardid ) )
2006-10-09 15:47:44.370 MSqlQuery: SELECT data FROM settings WHERE value = 'EITIgnoresSource' AND hostname = 'mythtv-be' ;
2006-10-09 15:47:44.371 MSqlQuery: SELECT data FROM settings WHERE value = 'EITIgnoresSource' AND hostname IS NULL;
2006-10-09 15:47:44.373 MSqlQuery: SELECT data FROM settings WHERE value = 'AutoTranscodeBeforeAutoCommflag' AND hostname = 'mythtv-be' ;
2006-10-09 15:47:44.374 MSqlQuery: SELECT data FROM settings WHERE value = 'AutoTranscodeBeforeAutoCommflag' AND hostname IS NULL;
2006-10-09 15:47:44.376 MSqlQuery: SELECT data FROM settings WHERE value = 'AutoCommflagWhileRecording' AND hostname = 'mythtv-be' ;
2006-10-09 15:47:44.377 MSqlQuery: SELECT data FROM settings WHERE value = 'AutoCommflagWhileRecording' AND hostname IS NULL;
2006-10-09 15:47:44.378 MSqlQuery: SELECT data FROM settings WHERE value = 'JobsRunOnRecordHost' AND hostname = 'mythtv-be' ;
2006-10-09 15:47:44.380 MSqlQuery: SELECT data FROM settings WHERE value = 'JobsRunOnRecordHost' AND hostname IS NULL;
2006-10-09 15:47:44.381 MSqlQuery: SELECT data FROM settings WHERE value = 'EITTransportTimeout' AND hostname = 'mythtv-be' ;
2006-10-09 15:47:44.382 MSqlQuery: SELECT data FROM settings WHERE value = 'EITTransportTimeout' AND hostname IS NULL;
2006-10-09 15:47:44.384 MSqlQuery: SELECT data FROM settings WHERE value = 'EITCrawIdleStart' AND hostname = 'mythtv-be' ;
2006-10-09 15:47:44.385 MSqlQuery: SELECT data FROM settings WHERE value = 'EITCrawIdleStart' AND hostname IS NULL;
2006-10-09 15:47:44.386 MSqlQuery: SELECT data FROM settings WHERE value = 'AudioSampleRate' AND hostname = 'mythtv-be' ;
2006-10-09 15:47:44.387 MSqlQuery: SELECT data FROM settings WHERE value = 'AudioSampleRate' AND hostname IS NULL;
2006-10-09 15:47:44.389 MSqlQuery: SELECT data FROM settings WHERE value = 'RecordOverTime' AND hostname = 'mythtv-be' ;
2006-10-09 15:47:44.390 MSqlQuery: SELECT data FROM settings WHERE value = 'RecordOverTime' AND hostname IS NULL;
2006-10-09 15:47:44.392 MSqlQuery: SELECT data FROM settings WHERE value = 'CategoryOverTime' AND hostname = 'mythtv-be' ;
2006-10-09 15:47:44.393 MSqlQuery: SELECT data FROM settings WHERE value = 'CategoryOverTime' AND hostname IS NULL;
2006-10-09 15:47:44.394 MSqlQuery: SELECT data FROM settings WHERE value = 'OverTimeCategory' AND hostname = 'mythtv-be' ;
2006-10-09 15:47:44.395 MSqlQuery: SELECT data FROM settings WHERE value = 'OverTimeCategory' AND hostname IS NULL;
2006-10-09 15:47:44.397 MSqlQuery: SELECT data FROM settings WHERE value = 'RecordFilePrefix' AND hostname = 'mythtv-be' ;
2006-10-09 15:47:44.398 EITHelper: localtime offset -4:00:00
2006-10-09 15:47:44.400 MSqlQuery: SELECT videodevice, vbidevice, audiodevice, audioratelimit, defaultinput, cardtype, skipbtaudio, signal_timeout, channel_timeout, dvb_wait_for_seqstart, dvb_on_demand, dvb_tuning_delay, firewire_port, firewire_node, firewire_speed, firewire_model, firewire_connection, dbox2_port, dbox2_host, dbox2_httpport FROM capturecard WHERE cardid = 2
2006-10-09 15:47:44.401 MSqlQuery: SELECT startchan FROM capturecard, cardinput WHERE capturecard.cardid = cardinput.cardid AND capturecard.cardid = 2 AND inputname = 'Tuner 1'
2006-10-09 15:47:44.402 MSqlQuery: SELECT cardinputid, inputname, startchan, tunechan, externalcommand, sourceid, childcardid FROM cardinput WHERE cardid = 2
2006-10-09 15:47:44.403 MSqlQuery: SELECT chanid, favid FROM favorites
2006-10-09 15:47:44.404 MSqlQuery: SELECT channum, callsign, chanid, atsc_major_chan, atsc_minor_chan, name, icon, visible FROM channel WHERE sourceid='1'
2006-10-09 15:47:44.425 MSqlQuery: SELECT channel.chanid FROM channel, capturecard, cardinput WHERE channel.channum = '2' AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = 'Tuner 1' AND cardinput.cardid = capturecard.cardid AND capturecard.cardid = 2 AND capturecard.hostname = 'mythtv-be'
2006-10-09 15:47:44.426 MSqlQuery: SELECT finetune, freqid, tvformat, freqtable, commfree, mplexid, atsc_major_chan, atsc_minor_chan, serviceid FROM channel, videosource WHERE videosource.sourceid = channel.sourceid AND channum = '2' AND channel.sourceid = 1
2006-10-09 15:47:44.428 MSqlQuery: SELECT channel.brightness FROM channel WHERE channum = '' AND sourceid = 1
2006-10-09 15:47:44.429 MSqlQuery: SELECT brightness FROM capturecard, cardinput WHERE sourceid = 1 AND cardinput.cardid = 2 AND ( ( cardinput.childcardid != '0' AND cardinput.childcardid = capturecard.cardid ) OR ( cardinput.childcardid = '0' AND cardinput.cardid = capturecard.cardid ) )
2006-10-09 15:47:44.459 EITHelper: localtime offset -4:00:00
2006-10-09 15:47:44.461 MSqlQuery: SELECT videodevice, vbidevice, audiodevice, audioratelimit, defaultinput, cardtype, skipbtaudio, signal_timeout, channel_timeout, dvb_wait_for_seqstart, dvb_on_demand, dvb_tuning_delay, firewire_port, firewire_node, firewire_speed, firewire_model, firewire_connection, dbox2_port, dbox2_host, dbox2_httpport FROM capturecard WHERE cardid = 3
2006-10-09 15:47:44.462 MSqlQuery: SELECT startchan FROM capturecard, cardinput WHERE capturecard.cardid = cardinput.cardid AND capturecard.cardid = 3 AND inputname = 'Tuner 1'
2006-10-09 15:47:44.463 MSqlQuery: SELECT cardinputid, inputname, startchan, tunechan, externalcommand, sourceid, childcardid FROM cardinput WHERE cardid = 3
2006-10-09 15:47:44.464 MSqlQuery: SELECT chanid, favid FROM favorites
2006-10-09 15:47:44.465 MSqlQuery: SELECT channum, callsign, chanid, atsc_major_chan, atsc_minor_chan, name, icon, visible FROM channel WHERE sourceid='1'
2006-10-09 15:47:44.486 MSqlQuery: SELECT channel.chanid FROM channel, capturecard, cardinput WHERE channel.channum = '2' AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = 'Tuner 1' AND cardinput.cardid = capturecard.cardid AND capturecard.cardid = 3 AND capturecard.hostname = 'mythtv-be'
2006-10-09 15:47:44.488 MSqlQuery: SELECT finetune, freqid, tvformat, freqtable, commfree, mplexid, atsc_major_chan, atsc_minor_chan, serviceid FROM channel, videosource WHERE videosource.sourceid = channel.sourceid AND channum = '2' AND channel.sourceid = 1
2006-10-09 15:47:44.489 MSqlQuery: SELECT channel.brightness FROM channel WHERE channum = '' AND sourceid = 1
2006-10-09 15:47:44.491 MSqlQuery: SELECT brightness FROM capturecard, cardinput WHERE sourceid = 1 AND cardinput.cardid = 3 AND ( ( cardinput.childcardid != '0' AND cardinput.childcardid = capturecard.cardid ) OR ( cardinput.childcardid = '0' AND cardinput.cardid = capturecard.cardid ) )
2006-10-09 15:47:44.510 MSqlQuery: SELECT data FROM settings WHERE value = 'JobQueueCPU' AND hostname = 'mythtv-be' ;
2006-10-09 15:47:44.511 Main::Starting HttpServer
2006-10-09 15:47:44.514 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-10-09 15:47:44.516 MSqlQuery: SELECT data FROM settings WHERE value = 'ThreadCountInitial_HTTP' AND hostname = 'mythtv-be' ;
2006-10-09 15:47:44.517 MSqlQuery: SELECT data FROM settings WHERE value = 'ThreadCountInitial_HTTP' AND hostname IS NULL;
2006-10-09 15:47:44.519 MSqlQuery: SELECT data FROM settings WHERE value = 'ThreadCountMax_HTTP' AND hostname = 'mythtv-be' ;
2006-10-09 15:47:44.520 MSqlQuery: SELECT data FROM settings WHERE value = 'ThreadCountMax_HTTP' AND hostname IS NULL;
2006-10-09 15:47:44.522 MSqlQuery: SELECT data FROM settings WHERE value = 'HTTPKeepAliveTimeoutSecs' AND hostname = 'mythtv-be' ;
2006-10-09 15:47:44.523 MSqlQuery: SELECT data FROM settings WHERE value = 'HTTPKeepAliveTimeoutSecs' AND hostname IS NULL;
2006-10-09 15:47:44.524 Main::Registering HttpStatus Extension
2006-10-09 15:47:44.526 MSqlQuery: SELECT data FROM settings WHERE value = 'RecordPreRoll' AND hostname = 'mythtv-be' ;
2006-10-09 15:47:44.527 MSqlQuery: SELECT data FROM settings WHERE value = 'RecordPreRoll' AND hostname IS NULL;
2006-10-09 15:47:44.528 mythbackend version: 0.20.20060828-3 www.mythtv.org
2006-10-09 15:47:44.528 Enabled verbose msgs: important general database
2006-10-09 15:47:44.528 AutoExpire: Found 3 recorders w/max rate of 216 MiB/min
2006-10-09 15:47:44.530 MSqlQuery: SELECT data FROM settings WHERE value = 'AutoExpireExtraSpace' AND hostname = 'mythtv-be' ;
2006-10-09 15:47:44.531 MSqlQuery: SELECT data FROM settings WHERE value = 'AutoExpireExtraSpace' AND hostname IS NULL;
2006-10-09 15:47:44.531 AutoExpire: Required Free Space: 2.7 GB w/freq: 5 min
2006-10-09 15:47:44.533 MSqlQuery: SELECT data FROM settings WHERE value = 'MasterBackendOverride' AND hostname = 'mythtv-be' ;
2006-10-09 15:47:44.535 MSqlQuery: SELECT data FROM settings WHERE value = 'MasterBackendOverride' AND hostname IS NULL;
2006-10-09 15:47:45.539 MSqlQuery: SELECT data FROM settings WHERE value = 'MasterServerPort' AND hostname = 'mythtv-be' ;
2006-10-09 15:47:45.540 MSqlQuery: SELECT data FROM settings WHERE value = 'MasterServerPort' AND hostname IS NULL;
2006-10-09 15:47:45.541 Connecting to master server: 192.168.1.16:6543
2006-10-09 15:47:45.541 Connected successfully
2006-10-09 15:47:54.288 MSqlQuery: SELECT lastrun FROM housekeeping WHERE tag = 'JobQueueRecover-mythtv-be' ;
2006-10-09 15:47:54.530 MSqlQuery: SELECT data FROM settings WHERE value = 'JobQueueCheckFrequency' AND hostname = 'mythtv-be' ;
2006-10-09 15:47:54.533 MSqlQuery: SELECT data FROM settings WHERE value = 'JobQueueWindowStart' AND hostname = 'mythtv-be' ;
2006-10-09 15:47:54.535 MSqlQuery: SELECT data FROM settings WHERE value = 'JobQueueWindowEnd' AND hostname = 'mythtv-be' ;
2006-10-09 15:47:54.537 MSqlQuery: SELECT data FROM settings WHERE value = 'JobQueueMaxSimultaneousJobs' AND hostname = 'mythtv-be' ;
2006-10-09 15:47:54.540 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-10-09 15:48:04.516 MSqlQuery: SELECT chanid, starttime, lastupdatetime, recusage, hostname FROM inuseprograms;
2006-10-09 15:48:04.519 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 = 'mythtv-be' AND deletepending = 0 ORDER BY autoexpire DESC, starttime ASC
2006-10-09 15:48:15.548 MythSocket(b5402d60:9): readStringList: Error, timeout.
2006-10-09 15:48:15.551 adding: mythtv-be as a slave backend server
2006-10-09 15:48:15.556 MythSocket(b5404550:-1): writeStringList: Error, socket went unconnected.
2006-10-09 15:48:21.557 AutoExpire: Found 3 recorders w/max rate of 216 MiB/min
2006-10-09 15:48:21.557 AutoExpire: Required Free Space: 2.7 GB w/freq: 5 min
2006-10-09 15:48:32.316 MainServer::HandleAnnounce Monitor
2006-10-09 15:48:32.317 adding: mythtv-be as a client (events: 0)
2006-10-09 15:48:32.317 MainServer::HandleAnnounce Monitor
2006-10-09 15:48:32.318 adding: mythtv-be as a client (events: 1)
More information about the mythtv-users
mailing list