[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