[mythtv] backend deleted new recording "for no reason"
Steven Adeff
adeffs.mythtv at gmail.com
Thu Mar 9 03:33:26 UTC 2006
So the g/f is pretty pissed, 2hr America's Next Top model was
recording fine, we started to watch Bones and upon returning to the
recordings list noticed that America's Next Top Model is no longer
there.
I searched through the backend log and found the area where
mythbackend looks to have deleted it, but I can't find any reasoning
for it, here's the area of the log that shows it. I can provide the
whole log if more is needed....
2006-03-08 22:00:43.196 Scheduled 306 items in 1.2 = 0.00 match + 1.20 place
2006-03-08 22:00:43.197 write -> 15 45
BACKEND_MESSAGE[]:[]SCHEDULE_CHANGE[]:[]empty
2006-03-08 22:00:43.200 write -> 17 45
BACKEND_MESSAGE[]:[]SCHEDULE_CHANGE[]:[]empty
2006-03-08 22:00:44.580 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 = '2838' AND starttime = '2006-03-08T20:00:00' ;
2006-03-08 22:00:44.582 MSqlQuery: SELECT commflagged, cutlist,
autoexpire, editing, bookmark FROM recorded WHERE chanid = '2838' AND
starttime = '2006-03-08T20:00:00' ;
2006-03-08 22:00:44.583 MSqlQuery: UPDATE jobqueue SET status = 320
WHERE chanid = '2838' AND starttime = '2006-03-08T20:00:00' AND status
= 1;
2006-03-08 22:00:44.585 MSqlQuery: UPDATE jobqueue SET cmds = 4 WHERE
chanid = '2838' AND starttime = '2006-03-08T20:00:00' AND status <>
320;
2006-03-08 22:00:44.597 MSqlQuery: SELECT id FROM jobqueue WHERE
chanid = '2838' and starttime = '2006-03-08T20:00:00' AND status NOT
IN (272,288,304,320);
2006-03-08 22:00:44.598 MSqlQuery: SELECT id FROM jobqueue WHERE
chanid = '2838' and starttime = '2006-03-08T20:00:00' AND status NOT
IN (272,288,304,320);
2006-03-08 22:00:44.599 MSqlQuery: DELETE FROM jobqueue WHERE chanid =
'2838' AND starttime = '2006-03-08T20:00:00';
2006-03-08 22:00:44.600 About to unlink/delete file:
/MythTV/tv/2838_20060308200000.mpg
2006-03-08 22:00:54.244 MSqlQuery: DELETE FROM recorded WHERE chanid =
'2838' AND title = 'America''s Next Top Model' AND starttime =
'2006-03-08T20:00:00';
2006-03-08 22:00:54.259 MSqlQuery: SELECT COUNT(*) FROM recorded WHERE
chanid = '2838' AND progstart = '2006-03-08T20:00:00';
2006-03-08 22:00:54.260 MSqlQuery: DELETE FROM recordedrating WHERE
chanid = '2838' AND starttime = '2006-03-08T20:00:00';
2006-03-08 22:00:54.309 MSqlQuery: DELETE FROM recordedprogram WHERE
chanid = '2838' AND starttime = '2006-03-08T20:00:00';
2006-03-08 22:00:54.395 MSqlQuery: DELETE FROM recordedcredits WHERE
chanid = '2838' AND starttime = '2006-03-08T20:00:00';
2006-03-08 22:00:55.424 write -> 15 51
BACKEND_MESSAGE[]:[]RECORDING_LIST_CHANGE[]:[]empty
2006-03-08 22:00:55.425 write -> 17 51
BACKEND_MESSAGE[]:[]RECORDING_LIST_CHANGE[]:[]empty
2006-03-08 22:00:55.959 read <- 14 35 QUERY_REMOTEENCODER 1[]:[]GET_STATE
2006-03-08 22:00:55.960 write -> 14 1 0
2006-03-08 22:00:55.975 read <- 14 35 QUERY_REMOTEENCODER 9[]:[]GET_STATE
2006-03-08 22:00:55.976 write -> 14 1 0
2006-03-08 22:00:55.992 read <- 14 36 QUERY_REMOTEENCODER 10[]:[]GET_STATE
2006-03-08 22:00:55.993 write -> 14 1 0
2006-03-08 22:00:59.363 MSqlQuery: DELETE FROM recordedmarkup WHERE
chanid = '2838' AND starttime = '2006-03-08T20:00:00';
2006-03-08 22:00:59.364 Reschedule requested for id 0.
2006-03-08 22:00:59.364 PruneOldRecords...
2006-03-08 22:00:59.366 AddNewRecords...
2006-03-08 22:00:59.369 MSqlQuery: SELECT
recordid,title,maxepisodes,maxnewest FROM record;
2006-03-08 22:00:59.371 |-- Start DB Query...
2006-03-08 22:00:59.731 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.preference
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
2006-03-08 22:00:59.733 |-- 702 results in 0.3617 sec. Processing...
2006-03-08 22:01:00.002 +-- Cleanup...
2006-03-08 22:01:00.003 AddNotListed...
2006-03-08 22:01:00.004 |-- Start DB Query...
2006-03-08 22:01:00.014 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
2006-03-08 22:01:00.015 |-- 1 results in 0.001488 sec. Processing...
2006-03-08 22:01:00.016 Sort by time...
2006-03-08 22:01:00.017 PruneOverlaps...
2006-03-08 22:01:00.018 Sort by priority...
2006-03-08 22:01:00.030 BuildListMaps...
2006-03-08 22:01:00.032 SchedNewRecords...
2006-03-08 22:01:00.033 Scheduling:
--
Steve
More information about the mythtv-dev
mailing list