1 | 2006-08-10 20:07:18.128 Using runtime prefix = /usr/local |
---|
2 | 2006-08-10 20:07:18.267 New DB connection, total: 1 |
---|
3 | 2006-08-10 20:07:18.280 Connected to database 'mythconverg' at host: localhost |
---|
4 | 2006-08-10 20:07:18.291 Enabling Settings Cache. |
---|
5 | 2006-08-10 20:07:18.303 Clearing Settings Cache. |
---|
6 | 2006-08-10 20:07:18.311 Disabling Settings Cache. |
---|
7 | 2006-08-10 20:07:18.319 Clearing Settings Cache. |
---|
8 | 2006-08-10 20:07:18.327 MSqlQuery: SELECT data FROM settings WHERE value = 'DBSchemaVer' AND hostname = 'Novoli' ; |
---|
9 | 2006-08-10 20:07:18.335 MSqlQuery: SELECT data FROM settings WHERE value = 'DBSchemaVer' AND hostname IS NULL; |
---|
10 | 2006-08-10 20:07:18.343 Current Schema Version: 1155 |
---|
11 | 2006-08-10 20:07:18.354 Enabling Settings Cache. |
---|
12 | 2006-08-10 20:07:18.362 Clearing Settings Cache. |
---|
13 | 2006-08-10 20:07:18.371 MSqlQuery: SELECT data FROM settings WHERE value = 'BackendServerPort' AND hostname = 'Novoli' ; |
---|
14 | 2006-08-10 20:07:18.379 MSqlQuery: SELECT data FROM settings WHERE value = 'BackendStatusPort' AND hostname = 'Novoli' ; |
---|
15 | 2006-08-10 20:07:18.387 MSqlQuery: SELECT data FROM settings WHERE value = 'BackendServerIP' AND hostname = 'Novoli' ; |
---|
16 | 2006-08-10 20:07:18.395 MSqlQuery: SELECT data FROM settings WHERE value = 'MasterServerIP' AND hostname = 'Novoli' ; |
---|
17 | 2006-08-10 20:07:18.403 MSqlQuery: SELECT data FROM settings WHERE value = 'MasterServerIP' AND hostname IS NULL; |
---|
18 | Starting up as the master server. |
---|
19 | 2006-08-10 20:07:18.423 MSqlQuery: SELECT data FROM settings WHERE value = 'LogEnabled' AND hostname = 'Novoli' ; |
---|
20 | 2006-08-10 20:07:18.431 MSqlQuery: SELECT data FROM settings WHERE value = 'LogEnabled' AND hostname IS NULL; |
---|
21 | 2006-08-10 20:07:18.439 MSqlQuery: SELECT data FROM settings WHERE value = 'LogMaxCount' AND hostname = 'Novoli' ; |
---|
22 | 2006-08-10 20:07:18.447 MSqlQuery: SELECT data FROM settings WHERE value = 'LogPrintLevel' AND hostname = 'Novoli' ; |
---|
23 | 2006-08-10 20:07:18.456 MSqlQuery: DELETE FROM inuseprograms WHERE hostname = 'Novoli' AND ( recusage = 'recorder' OR recusage LIKE 'Unknown %' ); |
---|
24 | 2006-08-10 20:07:18.467 MSqlQuery: UPDATE recorded SET basename = CONCAT(chanid, '_', DATE_FORMAT(starttime, '%Y%m%d%H%i00'), '_', DATE_FORMAT(endtime, '%Y%m%d%H%i00'), '.nuv') WHERE basename = ''; |
---|
25 | 2006-08-10 20:07:18.475 MSqlQuery: UPDATE channel SET callsign=chanid WHERE callsign IS NULL OR callsign=''; |
---|
26 | 2006-08-10 20:07:18.483 MSqlQuery: SELECT MIN(chanid) FROM channel; |
---|
27 | 2006-08-10 20:07:18.491 MSqlQuery: UPDATE record SET chanid = 1501 WHERE chanid IS NULL; |
---|
28 | 2006-08-10 20:07:18.499 New DB connection, total: 2 |
---|
29 | 2006-08-10 20:07:18.507 Connected to database 'mythconverg' at host: localhost |
---|
30 | 2006-08-10 20:07:18.515 MSqlQuery: SELECT record.chanid, channel.callsign FROM record LEFT JOIN channel ON record.chanid = channel.chanid WHERE record.station=''; |
---|
31 | 2006-08-10 20:07:18.522 MSqlQuery: SELECT cardid, hostname FROM capturecard WHERE parentid = '0' ORDER BY cardid |
---|
32 | 2006-08-10 20:07:18.532 MSqlQuery: SELECT data FROM settings WHERE value = 'EITTimeOffset' AND hostname = 'Novoli' ; |
---|
33 | 2006-08-10 20:07:18.543 MSqlQuery: SELECT data FROM settings WHERE value = 'EITTimeOffset' AND hostname IS NULL; |
---|
34 | 2006-08-10 20:07:18.551 EITHelper: localtime offset 2:00:00 |
---|
35 | 2006-08-10 20:07:18.559 MSqlQuery: SELECT data FROM settings WHERE value = 'ISO639Language0' AND hostname = 'Novoli' ; |
---|
36 | 2006-08-10 20:07:18.567 MSqlQuery: SELECT data FROM settings WHERE value = 'ISO639Language1' AND hostname = 'Novoli' ; |
---|
37 | 2006-08-10 20:07:18.575 MSqlQuery: SELECT data FROM settings WHERE value = 'ISO639Language2' AND hostname = 'Novoli' ; |
---|
38 | 2006-08-10 20:07:18.583 MSqlQuery: SELECT data FROM settings WHERE value = 'ISO639Language2' AND hostname IS NULL; |
---|
39 | 2006-08-10 20:07:18.591 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 |
---|
40 | 2006-08-10 20:07:18.603 MSqlQuery: SELECT startchan FROM capturecard, cardinput WHERE capturecard.cardid = cardinput.cardid AND capturecard.cardid = 3 AND inputname = 'DVBInput' |
---|
41 | 2006-08-10 20:07:18.611 DVBChan(0): Opening DVB channel |
---|
42 | 2006-08-10 20:07:18.618 DVBChan(0): Using DVB card 0, with frontend 'Conexant CX24123/CX24109'. |
---|
43 | 2006-08-10 20:07:18.627 MSqlQuery: SELECT diseqcid FROM capturecard WHERE cardid = 3 |
---|
44 | 2006-08-10 20:07:18.636 New DB connection, total: 3 |
---|
45 | 2006-08-10 20:07:18.647 Connected to database 'mythconverg' at host: localhost |
---|
46 | 2006-08-10 20:07:18.655 MSqlQuery: SELECT type, description FROM diseqc_tree WHERE diseqcid = 8 |
---|
47 | 2006-08-10 20:07:18.663 New DB connection, total: 4 |
---|
48 | 2006-08-10 20:07:18.671 Connected to database 'mythconverg' at host: localhost |
---|
49 | 2006-08-10 20:07:18.679 MSqlQuery: SELECT subtype, lnb_lof_switch, lnb_lof_hi, lnb_lof_lo FROM diseqc_tree WHERE diseqcid = 8 |
---|
50 | 2006-08-10 20:07:18.686 DiSEqCDevTree: Changing LNB voltage to 18V |
---|
51 | 2006-08-10 20:07:19.198 DiSEqCDevTree: Resetting DiSEqC Bus |
---|
52 | 2006-08-10 20:07:19.207 DiSEqCDevTree: Sending DiSEqC Command: e0 0 0 |
---|
53 | 2006-08-10 20:07:19.475 MSqlQuery: SELECT cardinputid, inputname, startchan, tunechan, externalcommand, sourceid, childcardid FROM cardinput WHERE cardid = 3 |
---|
54 | 2006-08-10 20:07:19.483 MSqlQuery: SELECT chanid, favid FROM favorites |
---|
55 | 2006-08-10 20:07:19.491 MSqlQuery: SELECT channum, callsign, chanid, atsc_major_chan, atsc_minor_chan, name, icon FROM channel WHERE sourceid='1' |
---|
56 | 2006-08-10 20:07:19.499 MSqlQuery: SELECT data FROM settings WHERE value = 'ChannelOrdering' AND hostname = 'Novoli' ; |
---|
57 | 2006-08-10 20:07:19.507 ChannelBase(3): Input #2: 'DVBInput' schan(514) sourceid(1) ccid(3) |
---|
58 | 2006-08-10 20:07:19.515 ChannelBase(3): Current Input #2: 'DVBInput' |
---|
59 | 2006-08-10 20:07:19.522 DVBChan(0): SetChannelByString(514): |
---|
60 | 2006-08-10 20:07:19.531 MSqlQuery: SELECT channel.chanid FROM channel, capturecard, cardinput WHERE channel.channum = '514' AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = 'DVBInput' AND cardinput.cardid = capturecard.cardid AND capturecard.cardid = 3 AND capturecard.hostname = 'Novoli' |
---|
61 | 2006-08-10 20:07:19.539 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 = '514' AND channel.sourceid = 1 |
---|
62 | 2006-08-10 20:07:19.547 MSqlQuery: SELECT transportid, networkid, frequency, modulation FROM dtv_multiplex WHERE mplexid = 5 |
---|
63 | 2006-08-10 20:07:19.556 MSqlQuery: SELECT frequency, inversion, symbolrate, fec, polarity, hp_code_rate, lp_code_rate, constellation, transmission_mode, guard_interval, hierarchy, modulation, bandwidth FROM dtv_multiplex WHERE dtv_multiplex.mplexid = 5 |
---|
64 | 2006-08-10 20:07:19.567 DVBChan(0): Frequency: 12480000 Symbol Rate: 27500000 Pol: v Inv: Auto |
---|
65 | 2006-08-10 20:07:19.576 MSqlQuery: SELECT diseqcid, value FROM diseqc_config WHERE cardinputid = 2 |
---|
66 | 2006-08-10 20:07:19.587 DiSEqCDevTree: Changing LNB voltage to 13V |
---|
67 | 2006-08-10 20:07:19.601 DVBChan(0): Old Params: Frequency: 0 Symbol Rate: 0 Pol: v Inv: Off |
---|
68 | DVBChan(0): New Params: Frequency: 12480000 Symbol Rate: 27500000 Pol: v Inv: Auto |
---|
69 | 2006-08-10 20:07:19.610 DVBChan(0): Tune(): Tuning to 1880000kHz |
---|
70 | 2006-08-10 20:07:19.730 dvbchannel.cpp:wait_for_backend: Status: Signal,Carrier, |
---|
71 | 2006-08-10 20:07:19.739 DVBChan(0): Tune(): Frequency tuning successful. |
---|
72 | 2006-08-10 20:07:19.747 DVBChan(0): SetChannelByString(514): Tuned to frequency. |
---|
73 | 2006-08-10 20:07:19.755 MSqlQuery: SELECT data FROM settings WHERE value = 'EITIgnoresSource' AND hostname = 'Novoli' ; |
---|
74 | 2006-08-10 20:07:19.763 MSqlQuery: SELECT data FROM settings WHERE value = 'EITIgnoresSource' AND hostname IS NULL; |
---|
75 | 2006-08-10 20:07:19.771 MSqlQuery: SELECT data FROM settings WHERE value = 'AutoTranscodeBeforeAutoCommflag' AND hostname = 'Novoli' ; |
---|
76 | 2006-08-10 20:07:19.787 MSqlQuery: SELECT data FROM settings WHERE value = 'AutoTranscodeBeforeAutoCommflag' AND hostname IS NULL; |
---|
77 | 2006-08-10 20:07:19.795 MSqlQuery: SELECT data FROM settings WHERE value = 'AutoCommflagWhileRecording' AND hostname = 'Novoli' ; |
---|
78 | 2006-08-10 20:07:19.803 MSqlQuery: SELECT data FROM settings WHERE value = 'AutoCommflagWhileRecording' AND hostname IS NULL; |
---|
79 | 2006-08-10 20:07:19.811 MSqlQuery: SELECT data FROM settings WHERE value = 'JobsRunOnRecordHost' AND hostname = 'Novoli' ; |
---|
80 | 2006-08-10 20:07:19.819 MSqlQuery: SELECT data FROM settings WHERE value = 'JobsRunOnRecordHost' AND hostname IS NULL; |
---|
81 | 2006-08-10 20:07:19.827 MSqlQuery: SELECT data FROM settings WHERE value = 'EITTransportTimeout' AND hostname = 'Novoli' ; |
---|
82 | 2006-08-10 20:07:19.839 MSqlQuery: SELECT data FROM settings WHERE value = 'EITTransportTimeout' AND hostname IS NULL; |
---|
83 | 2006-08-10 20:07:19.848 MSqlQuery: SELECT data FROM settings WHERE value = 'EITCrawIdleStart' AND hostname = 'Novoli' ; |
---|
84 | 2006-08-10 20:07:19.859 MSqlQuery: SELECT data FROM settings WHERE value = 'EITCrawIdleStart' AND hostname IS NULL; |
---|
85 | 2006-08-10 20:07:19.867 MSqlQuery: SELECT data FROM settings WHERE value = 'AudioSampleRate' AND hostname = 'Novoli' ; |
---|
86 | 2006-08-10 20:07:19.875 MSqlQuery: SELECT data FROM settings WHERE value = 'AudioSampleRate' AND hostname IS NULL; |
---|
87 | 2006-08-10 20:07:19.883 MSqlQuery: SELECT data FROM settings WHERE value = 'RecordOverTime' AND hostname = 'Novoli' ; |
---|
88 | 2006-08-10 20:07:19.891 MSqlQuery: SELECT data FROM settings WHERE value = 'RecordOverTime' AND hostname IS NULL; |
---|
89 | 2006-08-10 20:07:19.899 MSqlQuery: SELECT data FROM settings WHERE value = 'CategoryOverTime' AND hostname = 'Novoli' ; |
---|
90 | 2006-08-10 20:07:19.907 MSqlQuery: SELECT data FROM settings WHERE value = 'CategoryOverTime' AND hostname IS NULL; |
---|
91 | 2006-08-10 20:07:19.915 MSqlQuery: SELECT data FROM settings WHERE value = 'OverTimeCategory' AND hostname = 'Novoli' ; |
---|
92 | 2006-08-10 20:07:19.923 MSqlQuery: SELECT data FROM settings WHERE value = 'OverTimeCategory' AND hostname IS NULL; |
---|
93 | 2006-08-10 20:07:19.931 MSqlQuery: SELECT data FROM settings WHERE value = 'RecordFilePrefix' AND hostname = 'Novoli' ; |
---|
94 | 2006-08-10 20:07:19.939 TVRec(3): SetFlags(RunMainLoop,) -> RunMainLoop, |
---|
95 | 2006-08-10 20:07:19.943 TVRec(3): ClearFlags(ExitPlayer,FinishRecording,) -> RunMainLoop, |
---|
96 | 2006-08-10 20:07:19.943 New DB scheduler connection |
---|
97 | 2006-08-10 20:07:19.956 Connected to database 'mythconverg' at host: localhost |
---|
98 | 2006-08-10 20:07:19.967 MSqlQuery: SELECT NULL FROM capturecard; |
---|
99 | 2006-08-10 20:07:19.975 MSqlQuery: SELECT sourceid,name FROM videosource ORDER BY sourceid; |
---|
100 | 2006-08-10 20:07:19.983 MSqlQuery: SELECT cardinputid FROM cardinput WHERE sourceid = 1 ORDER BY cardinputid; |
---|
101 | 2006-08-10 20:07:19.991 MSqlQuery: SELECT data FROM settings WHERE value = 'JobQueueCPU' AND hostname = 'Novoli' ; |
---|
102 | 2006-08-10 20:07:19.991 MSqlQuery: SELECT data FROM settings WHERE value = 'blockSDWUwithoutClient' AND hostname = 'Novoli' ; |
---|
103 | 2006-08-10 20:07:19.999 Main::Starting HttpServer |
---|
104 | 2006-08-10 20:07:19.999 JobQueue: RecoverQueue: Checking for unfinished jobs to recover. |
---|
105 | 2006-08-10 20:07:20.003 MSqlQuery: SELECT data FROM settings WHERE value = 'blockSDWUwithoutClient' AND hostname IS NULL; |
---|
106 | 2006-08-10 20:07:20.015 MSqlQuery: SELECT data FROM settings WHERE value = 'ThreadCountInitial_HTTP' AND hostname = 'Novoli' ; |
---|
107 | 2006-08-10 20:07:20.020 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; |
---|
108 | 2006-08-10 20:07:20.028 MSqlQuery: UPDATE oldrecorded SET recstatus = -4 WHERE recstatus = -2 |
---|
109 | 2006-08-10 20:07:20.047 MSqlQuery: SELECT data FROM settings WHERE value = 'ThreadCountInitial_HTTP' AND hostname IS NULL; |
---|
110 | 2006-08-10 20:07:20.051 JobQueue: GetJobsInQueue: findJobs search bitmask 4, found 0 total jobs |
---|
111 | 2006-08-10 20:07:20.067 MSqlQuery: SELECT data FROM settings WHERE value = 'ThreadCountMax_HTTP' AND hostname = 'Novoli' ; |
---|
112 | 2006-08-10 20:07:20.083 MSqlQuery: SELECT data FROM settings WHERE value = 'ThreadCountMax_HTTP' AND hostname IS NULL; |
---|
113 | 2006-08-10 20:07:20.091 MSqlQuery: SELECT data FROM settings WHERE value = 'HTTPKeepAliveTimeoutSecs' AND hostname = 'Novoli' ; |
---|
114 | 2006-08-10 20:07:20.099 MSqlQuery: SELECT data FROM settings WHERE value = 'HTTPKeepAliveTimeoutSecs' AND hostname IS NULL; |
---|
115 | 2006-08-10 20:07:20.107 Main::Registering HttpStatus Extension |
---|
116 | 2006-08-10 20:07:20.115 MSqlQuery: SELECT data FROM settings WHERE value = 'RecordPreRoll' AND hostname = 'Novoli' ; |
---|
117 | 2006-08-10 20:07:20.124 MSqlQuery: SELECT data FROM settings WHERE value = 'RecordPreRoll' AND hostname IS NULL; |
---|
118 | 2006-08-10 20:07:20.136 UPnp::UPnp:Begin |
---|
119 | 2006-08-10 20:07:20.147 UPnp::UPnp:Starting TaskQueue |
---|
120 | 2006-08-10 20:07:20.155 UPnp::UPnp:Loading UPnp Description |
---|
121 | 2006-08-10 20:07:20.163 MSqlQuery: SELECT data FROM settings WHERE value = 'upnpDescXmlPath' AND hostname = 'Novoli' ; |
---|
122 | 2006-08-10 20:07:20.171 MSqlQuery: SELECT data FROM settings WHERE value = 'upnpDescXmlPath' AND hostname IS NULL; |
---|
123 | 2006-08-10 20:07:20.180 UPnp::UPnp:Starting SSDP Thread |
---|
124 | 2006-08-10 20:07:20.191 UPnp::UPnp:Adding Context Listener |
---|
125 | 2006-08-10 20:07:20.191 MSqlQuery: SELECT data FROM settings WHERE value = 'upnpTTL' AND hostname = 'Novoli' ; |
---|
126 | 2006-08-10 20:07:20.199 UPnp::UPnp:End |
---|
127 | 2006-08-10 20:07:20.203 MSqlQuery: SELECT data FROM settings WHERE value = 'upnpTTL' AND hostname IS NULL; |
---|
128 | 2006-08-10 20:07:20.215 Main::Registering UPnpCDSTv Extension |
---|
129 | 2006-08-10 20:07:20.234 Main::Registering UPnpCDSMusic Extension |
---|
130 | 2006-08-10 20:07:20.242 mythbackend version: 0.19.20060708-1 www.mythtv.org |
---|
131 | 2006-08-10 20:07:20.251 Enabled verbose msgs: all |
---|
132 | 2006-08-10 20:07:20.259 MSqlQuery: SELECT data FROM settings WHERE value = 'upnpMaxAge' AND hostname = 'Novoli' ; |
---|
133 | 2006-08-10 20:07:20.259 AutoExpire: Found 1 recorders w/max rate of 138 MiB/min |
---|
134 | 2006-08-10 20:07:20.263 MSqlQuery: SELECT data FROM settings WHERE value = 'upnpMaxAge' AND hostname IS NULL; |
---|
135 | 2006-08-10 20:07:20.275 MSqlQuery: SELECT data FROM settings WHERE value = 'AutoExpireExtraSpace' AND hostname = 'Novoli' ; |
---|
136 | 2006-08-10 20:07:20.279 MSqlQuery: SELECT data FROM settings WHERE value = 'upnp:UDN:urn:schemas-upnp-org:device:MediaServer:1' AND hostname = 'Novoli' ; |
---|
137 | 2006-08-10 20:07:20.299 MSqlQuery: SELECT data FROM settings WHERE value = 'AutoExpireExtraSpace' AND hostname IS NULL; |
---|
138 | 2006-08-10 20:07:20.315 AutoExpire: Required Free Space: 5.0 GB w/freq: 10 min |
---|
139 | 2006-08-10 20:07:20.323 MSqlQuery: SELECT data FROM settings WHERE value = 'MasterBackendOverride' AND hostname = 'Novoli' ; |
---|
140 | 2006-08-10 20:07:20.331 MSqlQuery: SELECT data FROM settings WHERE value = 'MasterBackendOverride' AND hostname IS NULL; |
---|
141 | 2006-08-10 20:07:20.339 MSqlQuery: SELECT data FROM settings WHERE value = 'WOLslaveBackendsCommand' AND hostname = 'Novoli' ; |
---|
142 | 2006-08-10 20:07:20.347 MSqlQuery: SELECT data FROM settings WHERE value = 'WOLslaveBackendsCommand' AND hostname IS NULL; |
---|
143 | 2006-08-10 20:07:22.059 Reschedule requested for id -1. |
---|
144 | 2006-08-10 20:07:22.064 MSqlQuery: DELETE FROM recordmatch WHERE recordid = -1 OR -1 = -1; |
---|
145 | 2006-08-10 20:07:22.064 MSqlQuery: DELETE FROM program WHERE manualid = -1 OR (manualid <> 0 AND -1 = -1) |
---|
146 | 2006-08-10 20:07:22.065 MSqlQuery: SELECT recordid,search,subtitle,description FROM record WHERE search <> 0 AND (recordid = -1 OR -1 = -1) |
---|
147 | Query 0: /record.search = :NRST AND (record.recordid = :NRRECORDID OR :NRRECORDID = -1) AND program.manualid = 0 AND program.title = record.title |
---|
148 | 2006-08-10 20:07:22.066 |-- Start DB Query 0... |
---|
149 | 2006-08-10 20:07:22.068 MSqlQuery: INSERT INTO recordmatch (recordid, chanid, starttime, manualid) SELECT record.recordid, program.chanid, program.starttime, IF(search = 5, recordid, 0) FROM (record, program INNER JOIN channel ON channel.chanid = program.chanid) WHERE record.search = 0 AND (record.recordid = -1 OR -1 = -1) AND program.manualid = 0 AND program.title = record.title AND channel.visible = 1 AND ((record.type = 4 OR record.type = 6 OR record.type = 9 OR record.type = 10) OR ((record.station = channel.callsign) AND ((record.type = 3) OR ((TIME_TO_SEC(record.starttime) = TIME_TO_SEC(program.starttime)) AND ((record.type = 2) OR ((DAYOFWEEK(record.startdate) = DAYOFWEEK(program.starttime) AND ((record.type = 5) OR ((TO_DAYS(record.startdate) = TO_DAYS(program.starttime)) ) ) ) ) ) ) ) )) |
---|
150 | 2006-08-10 20:07:22.084 |-- -1 results in 0.017643 sec. |
---|
151 | 2006-08-10 20:07:22.084 +-- Done. |
---|
152 | 2006-08-10 20:07:22.085 Encoder card 3 free space 1572864 |
---|
153 | 2006-08-10 20:07:22.086 MSqlQuery: SELECT data FROM settings WHERE value = 'SchedMoveHigher' AND hostname = 'Novoli' ; |
---|
154 | 2006-08-10 20:07:22.086 MSqlQuery: SELECT data FROM settings WHERE value = 'SchedMoveHigher' AND hostname IS NULL; |
---|
155 | 2006-08-10 20:07:22.087 PruneOldRecords... |
---|
156 | 2006-08-10 20:07:22.088 AddNewRecords... |
---|
157 | 2006-08-10 20:07:22.088 MSqlQuery: SELECT data FROM settings WHERE value = 'ComplexPriority' AND hostname = 'Novoli' ; |
---|
158 | 2006-08-10 20:07:22.089 MSqlQuery: SELECT data FROM settings WHERE value = 'ComplexPriority' AND hostname IS NULL; |
---|
159 | 2006-08-10 20:07:22.089 MSqlQuery: SELECT data FROM settings WHERE value = 'PrefInputPriority' AND hostname = 'Novoli' ; |
---|
160 | 2006-08-10 20:07:22.090 MSqlQuery: SELECT data FROM settings WHERE value = 'PrefInputPriority' AND hostname IS NULL; |
---|
161 | 2006-08-10 20:07:22.091 MSqlQuery: SELECT data FROM settings WHERE value = 'OnceRecPriority' AND hostname = 'Novoli' ; |
---|
162 | 2006-08-10 20:07:22.091 MSqlQuery: SELECT data FROM settings WHERE value = 'OnceRecPriority' AND hostname IS NULL; |
---|
163 | 2006-08-10 20:07:22.092 MSqlQuery: SELECT data FROM settings WHERE value = 'HDTVRecPriority' AND hostname = 'Novoli' ; |
---|
164 | 2006-08-10 20:07:22.093 MSqlQuery: SELECT data FROM settings WHERE value = 'HDTVRecPriority' AND hostname IS NULL; |
---|
165 | 2006-08-10 20:07:22.093 MSqlQuery: SELECT data FROM settings WHERE value = 'CCRecPriority' AND hostname = 'Novoli' ; |
---|
166 | 2006-08-10 20:07:22.094 MSqlQuery: SELECT data FROM settings WHERE value = 'CCRecPriority' AND hostname IS NULL; |
---|
167 | 2006-08-10 20:07:22.094 MSqlQuery: SELECT recordid,title,maxepisodes,maxnewest FROM record; |
---|
168 | 2006-08-10 20:07:22.095 |-- Start DB Query... |
---|
169 | 2006-08-10 20:07:22.096 MSqlQuery: SELECT DISTINCT channel.chanid, channel.sourceid, program.starttime, program.endtime, program.title, program.subtitle, program.description, channel.channum, channel.callsign, channel.name, oldrecorded.endtime IS NOT NULL AS oldrecduplicate, program.category, record.recpriority, record.dupin, recorded.endtime IS NOT NULL AS recduplicate, oldfind.findid IS NOT NULL AS findduplicate, record.type, record.recordid, program.starttime - INTERVAL record.startoffset minute AS recstartts, program.endtime + INTERVAL record.endoffset minute AS recendts, program.previouslyshown, record.recgroup, record.dupmethod, channel.commfree, capturecard.cardid, cardinput.cardinputid, UPPER(cardinput.shareable) = 'Y' AS shareable, program.seriesid, program.programid, program.category_type, program.airdate, program.stars, program.originalairdate, record.inactive, record.parentid, (CASE record.type WHEN 6 THEN record.findid WHEN 9 THEN to_days(date_sub(program.starttime, interval time_format(record.findtime, '%H:%i') hour_minute)) WHEN 10 THEN floor((to_days(date_sub(program.starttime, interval time_format(record.findtime, '%H:%i') hour_minute)) - record.findday)/7) * 7 + record.findday WHEN 7 THEN record.findid ELSE 0 END) , record.playgroup, oldrecstatus.recstatus, oldrecstatus.reactivate, channel.recpriority + cardinput.recpriority, record.prefinput, program.hdtv, program.closecaptioned, program.first, program.last, program.stereo FROM recordmatch INNER JOIN record ON (recordmatch.recordid = record.recordid) INNER JOIN program ON (recordmatch.chanid = program.chanid AND recordmatch.starttime = program.starttime AND recordmatch.manualid = program.manualid) INNER JOIN channel ON (channel.chanid = program.chanid) INNER JOIN cardinput ON (channel.sourceid = cardinput.sourceid) INNER JOIN capturecard ON (capturecard.cardid = cardinput.cardid) LEFT JOIN oldrecorded as oldrecstatus ON ( oldrecstatus.station = channel.callsign AND oldrecstatus.starttime = program.starttime AND oldrecstatus.title = program.title ) LEFT JOIN oldrecorded ON ( record.dupmethod > 1 AND oldrecorded.duplicate <> 0 AND program.title = oldrecorded.title AND ( (program.programid <> '' AND program.generic = 0 AND program.programid = oldrecorded.programid) OR (oldrecorded.findid <> 0 AND oldrecorded.findid = (CASE record.type WHEN 6 THEN record.findid WHEN 9 THEN to_days(date_sub(program.starttime, interval time_format(record.findtime, '%H:%i') hour_minute)) WHEN 10 THEN floor((to_days(date_sub(program.starttime, interval time_format(record.findtime, '%H:%i') hour_minute)) - record.findday)/7) * 7 + record.findday WHEN 7 THEN record.findid ELSE 0 END) ) OR ( program.generic = 0 AND (program.programid = '' OR oldrecorded.programid = '') AND (((record.dupmethod & 0x02) = 0) OR (program.subtitle <> '' AND program.subtitle = oldrecorded.subtitle)) AND (((record.dupmethod & 0x04) = 0) OR (program.description <> '' AND program.description = oldrecorded.description)) ) ) ) LEFT JOIN recorded ON ( record.dupmethod > 1 AND recorded.duplicate <> 0 AND program.title = recorded.title AND recorded.recgroup <> 'LiveTV' AND ( (program.programid <> '' AND program.generic = 0 AND program.programid = recorded.programid) OR (recorded.findid <> 0 AND recorded.findid = (CASE record.type WHEN 6 THEN record.findid WHEN 9 THEN to_days(date_sub(program.starttime, interval time_format(record.findtime, '%H:%i') hour_minute)) WHEN 10 THEN floor((to_days(date_sub(program.starttime, interval time_format(record.findtime, '%H:%i') hour_minute)) - record.findday)/7) * 7 + record.findday WHEN 7 THEN record.findid ELSE 0 END) ) OR ( program.generic = 0 AND (program.programid = '' OR recorded.programid = '') AND (((record.dupmethod & 0x02) = 0) OR (program.subtitle <> '' AND program.subtitle = recorded.subtitle)) AND (((record.dupmethod & 0x04) = 0) OR (program.description <> '' AND program.description = recorded.description)) ) ) ) LEFT JOIN oldfind ON (oldfind.recordid = recordmatch.recordid AND oldfind.findid = (CASE record.type WHEN 6 THEN record.findid WHEN 9 THEN to_days(date_sub(program.starttime, interval time_format(record.findtime, '%H:%i') hour_minute)) WHEN 10 THEN floor((to_days(date_sub(program.starttime, interval time_format(record.findtime, '%H:%i') hour_minute)) - record.findday)/7) * 7 + record.findday WHEN 7 THEN record.findid ELSE 0 END) ) ORDER BY record.recordid DESC |
---|
170 | 2006-08-10 20:07:22.098 |-- 0 results in 0.002211 sec. Processing... |
---|
171 | 2006-08-10 20:07:22.098 +-- Cleanup... |
---|
172 | 2006-08-10 20:07:22.099 AddNotListed... |
---|
173 | 2006-08-10 20:07:22.099 |-- Start DB Query... |
---|
174 | 2006-08-10 20:07:22.100 MSqlQuery: SELECT record.recordid, record.type, record.chanid, record.starttime, record.startdate, record.endtime, record.enddate, record.startoffset, record.endoffset, record.title, record.subtitle, record.description, channel.channum, channel.callsign, channel.name FROM record INNER JOIN channel ON (channel.chanid = record.chanid) LEFT JOIN recordmatch on record.recordid = recordmatch.recordid WHERE (type = 1 OR type = 7) AND recordmatch.chanid IS NULL |
---|
175 | 2006-08-10 20:07:22.101 |-- 0 results in 0.000751 sec. Processing... |
---|
176 | 2006-08-10 20:07:22.101 Sort by time... |
---|
177 | 2006-08-10 20:07:22.101 PruneOverlaps... |
---|
178 | 2006-08-10 20:07:22.102 Sort by priority... |
---|
179 | 2006-08-10 20:07:22.102 BuildListMaps... |
---|
180 | 2006-08-10 20:07:22.103 SchedNewRecords... |
---|
181 | 2006-08-10 20:07:22.104 Scheduling: |
---|
182 | 2006-08-10 20:07:22.104 ClearListMaps... |
---|
183 | 2006-08-10 20:07:22.104 Sort by time... |
---|
184 | 2006-08-10 20:07:22.105 PruneRedundants... |
---|
185 | 2006-08-10 20:07:22.106 Sort by time... |
---|
186 | --- print list start --- |
---|
187 | Title - Subtitle Chan ChID Day Start End C I T N Pri |
---|
188 | --- print list end --- |
---|
189 | 2006-08-10 20:07:22.106 Scheduled 0 items in 0.0 = 0.03 match + 0.02 place |
---|
190 | 2006-08-10 20:07:22.107 MSqlQuery: SELECT data FROM settings WHERE value = 'idleTimeoutSecs' AND hostname = 'Novoli' ; |
---|
191 | 2006-08-10 20:07:22.108 MSqlQuery: SELECT data FROM settings WHERE value = 'idleTimeoutSecs' AND hostname IS NULL; |
---|
192 | 2006-08-10 20:07:22.108 MSqlQuery: SELECT data FROM settings WHERE value = 'idleWaitForRecordingTime' AND hostname = 'Novoli' ; |
---|
193 | 2006-08-10 20:07:22.109 MSqlQuery: SELECT data FROM settings WHERE value = 'idleWaitForRecordingTime' AND hostname IS NULL; |
---|
194 | 2006-08-10 20:07:22.110 Seem to be woken up by USER |
---|
195 | 2006-08-10 20:07:22.115 MSqlQuery: SELECT data FROM settings WHERE value = 'startupCommand' AND hostname = 'Novoli' ; |
---|
196 | 2006-08-10 20:07:22.116 MSqlQuery: SELECT data FROM settings WHERE value = 'startupCommand' AND hostname IS NULL; |
---|
197 | 2006-08-10 20:07:28.471 MSqlQuery: SELECT data FROM settings WHERE value = 'MythFillEnabled' AND hostname = 'Novoli' ; |
---|
198 | 2006-08-10 20:07:28.476 MSqlQuery: SELECT data FROM settings WHERE value = 'MythFillEnabled' AND hostname IS NULL; |
---|
199 | 2006-08-10 20:07:28.476 MSqlQuery: SELECT lastrun FROM housekeeping WHERE tag = 'JobQueueCleanup' ; |
---|
200 | 2006-08-10 20:07:28.477 MSqlQuery: SELECT lastrun FROM housekeeping WHERE tag = 'InUseProgramsCleanup' ; |
---|
201 | 2006-08-10 20:07:28.477 MSqlQuery: SELECT lastrun FROM housekeeping WHERE tag = 'JobQueueRecover-Novoli' ; |
---|
202 | 2006-08-10 20:07:30.075 JobQueue: ProcessQueue() started |
---|
203 | 2006-08-10 20:07:30.080 MSqlQuery: SELECT data FROM settings WHERE value = 'JobQueueCheckFrequency' AND hostname = 'Novoli' ; |
---|
204 | 2006-08-10 20:07:30.081 MSqlQuery: SELECT data FROM settings WHERE value = 'JobQueueWindowStart' AND hostname = 'Novoli' ; |
---|
205 | 2006-08-10 20:07:30.095 MSqlQuery: SELECT data FROM settings WHERE value = 'JobQueueWindowEnd' AND hostname = 'Novoli' ; |
---|
206 | 2006-08-10 20:07:30.096 MSqlQuery: SELECT data FROM settings WHERE value = 'JobQueueMaxSimultaneousJobs' AND hostname = 'Novoli' ; |
---|
207 | 2006-08-10 20:07:30.096 JobQueue: Currently set at 1 job(s) max and to run new jobs from 00:00 to 23:59 |
---|
208 | 2006-08-10 20:07:30.097 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; |
---|
209 | 2006-08-10 20:07:30.097 JobQueue: GetJobsInQueue: findJobs search bitmask 4, found 0 total jobs |
---|
210 | 2006-08-10 20:07:39.995 MSqlQuery: SELECT chanid, starttime, lastupdatetime, recusage, hostname FROM inuseprograms; |
---|
211 | 2006-08-10 20:07:50.100 JobQueue: Currently set at 1 job(s) max and to run new jobs from 00:00 to 23:59 |
---|
212 | 2006-08-10 20:07:50.105 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; |
---|
213 | 2006-08-10 20:07:50.105 JobQueue: GetJobsInQueue: findJobs search bitmask 4, found 0 total jobs |
---|
214 | 2006-08-10 20:08:10.108 JobQueue: Currently set at 1 job(s) max and to run new jobs from 00:00 to 23:59 |
---|
215 | 2006-08-10 20:08:10.110 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; |
---|
216 | 2006-08-10 20:08:10.111 JobQueue: GetJobsInQueue: findJobs search bitmask 4, found 0 total jobs |
---|
217 | 2006-08-10 20:08:30.118 JobQueue: Currently set at 1 job(s) max and to run new jobs from 00:00 to 23:59 |
---|
218 | 2006-08-10 20:08:30.137 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; |
---|
219 | 2006-08-10 20:08:30.138 JobQueue: GetJobsInQueue: findJobs search bitmask 4, found 0 total jobs |
---|
220 | 2006-08-10 20:08:40.022 MSqlQuery: SELECT chanid, starttime, lastupdatetime, recusage, hostname FROM inuseprograms; |
---|
221 | 2006-08-10 20:08:40.034 AutoExpire: ExpireLiveTV(10000) |
---|
222 | 2006-08-10 20:08:40.051 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 = 'Novoli' AND deletepending = 0 ORDER BY autoexpire DESC, starttime ASC |
---|
223 | 2006-08-10 20:08:40.052 AutoExpire: SendDeleteMessages. Nothing to expire. |
---|
224 | 2006-08-10 20:08:40.052 AutoExpire: ExpireLiveTV(10001) |
---|
225 | 2006-08-10 20:08:40.053 MSqlQuery: SELECT data FROM settings WHERE value = 'AutoExpireLiveTVMaxAge' AND hostname = 'Novoli' ; |
---|
226 | 2006-08-10 20:08:40.053 MSqlQuery: SELECT data FROM settings WHERE value = 'AutoExpireLiveTVMaxAge' AND hostname IS NULL; |
---|
227 | 2006-08-10 20:08:40.054 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 '-1' DAY) AND hostname = 'Novoli' AND deletepending = 0 ORDER BY autoexpire DESC, starttime ASC |
---|
228 | 2006-08-10 20:08:40.055 AutoExpire: SendDeleteMessages. Nothing to expire. |
---|
229 | 2006-08-10 20:08:40.055 MSqlQuery: SELECT recordid, maxepisodes, title FROM record WHERE maxepisodes > 0 ORDER BY recordid ASC, maxepisodes DESC |
---|
230 | 2006-08-10 20:08:40.056 AutoExpire: Checking episode count for each recording profile using max episodes |
---|
231 | 2006-08-10 20:08:40.056 AutoExpire: Running autoexpire, we want 5153 MB free, but only have 1532 MB. |
---|
232 | 2006-08-10 20:08:40.057 MSqlQuery: SELECT data FROM settings WHERE value = 'AutoExpireMethod' AND hostname = 'Novoli' ; |
---|
233 | 2006-08-10 20:08:40.057 MSqlQuery: SELECT data FROM settings WHERE value = 'AutoExpireMethod' AND hostname IS NULL; |
---|
234 | 2006-08-10 20:08:40.058 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 autoexpire > 0 AND deletepending = 0 ORDER BY autoexpire DESC, recorded.recpriority ASC, starttime ASC |
---|
235 | 2006-08-10 20:08:40.059 AutoExpire: SendDeleteMessages. WARNING: below free disk space threshold, but nothing to expire~ |
---|
236 | 2006-08-10 20:08:48.946 MSqlQuery: SELECT SUM(useeit) FROM videosource, cardinput WHERE videosource.sourceid = cardinput.sourceid AND cardinput.cardid = 3 |
---|
237 | 2006-08-10 20:08:48.955 MSqlQuery: SELECT min(channum) FROM channel, cardinput, capturecard, videosource WHERE cardinput.sourceid = channel.sourceid AND videosource.sourceid = channel.sourceid AND capturecard.cardid = cardinput.cardid AND channel.mplexid IS NOT NULL AND useonairguide = 1 AND useeit = 1 AND channum != '' AND cardinput.cardid = 3 GROUP BY mplexid ORDER BY cardinput.sourceid, mplexid, atsc_major_chan, atsc_minor_chan |
---|
238 | 2006-08-10 20:08:48.964 EITScanner: StartActiveScan called with 0 multiplexes |
---|
239 | 2006-08-10 20:08:48.965 TVRec(3): SetFlags(EITScannerRunning,) -> RunMainLoop,EITScannerRunning, |
---|
240 | 2006-08-10 20:08:50.142 JobQueue: Currently set at 1 job(s) max and to run new jobs from 00:00 to 23:59 |
---|
241 | 2006-08-10 20:08:50.148 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; |
---|
242 | 2006-08-10 20:08:50.148 JobQueue: GetJobsInQueue: findJobs search bitmask 4, found 0 total jobs |
---|
243 | 2006-08-10 20:09:10.151 JobQueue: Currently set at 1 job(s) max and to run new jobs from 00:00 to 23:59 |
---|
244 | 2006-08-10 20:09:10.175 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; |
---|
245 | 2006-08-10 20:09:10.176 JobQueue: GetJobsInQueue: findJobs search bitmask 4, found 0 total jobs |
---|
246 | 2006-08-10 20:09:30.180 JobQueue: Currently set at 1 job(s) max and to run new jobs from 00:00 to 23:59 |
---|
247 | 2006-08-10 20:09:30.190 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; |
---|
248 | 2006-08-10 20:09:30.190 JobQueue: GetJobsInQueue: findJobs search bitmask 4, found 0 total jobs |
---|
249 | 2006-08-10 20:09:40.110 MSqlQuery: SELECT chanid, starttime, lastupdatetime, recusage, hostname FROM inuseprograms; |
---|
250 | 2006-08-10 20:09:50.193 JobQueue: Currently set at 1 job(s) max and to run new jobs from 00:00 to 23:59 |
---|
251 | 2006-08-10 20:09:50.200 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; |
---|
252 | 2006-08-10 20:09:50.200 JobQueue: GetJobsInQueue: findJobs search bitmask 4, found 0 total jobs |
---|
253 | 2006-08-10 20:10:10.218 JobQueue: Currently set at 1 job(s) max and to run new jobs from 00:00 to 23:59 |
---|
254 | 2006-08-10 20:10:10.411 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; |
---|
255 | 2006-08-10 20:10:10.411 JobQueue: GetJobsInQueue: findJobs search bitmask 4, found 0 total jobs |
---|
256 | 2006-08-10 20:10:30.414 JobQueue: Currently set at 1 job(s) max and to run new jobs from 00:00 to 23:59 |
---|
257 | 2006-08-10 20:10:30.419 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; |
---|
258 | 2006-08-10 20:10:30.420 JobQueue: GetJobsInQueue: findJobs search bitmask 4, found 0 total jobs |
---|
259 | 2006-08-10 20:10:40.223 MSqlQuery: SELECT chanid, starttime, lastupdatetime, recusage, hostname FROM inuseprograms; |
---|
260 | 2006-08-10 20:10:40.228 AutoExpire: ExpireLiveTV(10000) |
---|
261 | 2006-08-10 20:10:40.229 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 = 'Novoli' AND deletepending = 0 ORDER BY autoexpire DESC, starttime ASC |
---|
262 | 2006-08-10 20:10:40.246 AutoExpire: SendDeleteMessages. Nothing to expire. |
---|
263 | 2006-08-10 20:10:50.475 JobQueue: Currently set at 1 job(s) max and to run new jobs from 00:00 to 23:59 |
---|
264 | 2006-08-10 20:10:50.511 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; |
---|
265 | 2006-08-10 20:10:50.517 JobQueue: GetJobsInQueue: findJobs search bitmask 4, found 0 total jobs |
---|