[mythtv] Autoexpiring programs with no program information

[Buechler, Mark R]

Nothing returns for either of these queries. What's odd is that the
housekeeping thread queries recorded for recordings to expire/delete. If
you're saying it has nothing to do with guide information that I have to
wonder. The message hasn't come up since. I'll do some more checking.

Thanks, Mark.

-----Original Message-----
From: Chris Pinkham [mailto:cpinkham at bc2va.org] 
Sent: Wednesday, January 18, 2006 8:32 PM
To: mythtv-dev at mythtv.org
Subject: Re: [mythtv] Autoexpiring programs with no program information

> 2006-01-18 19:25:48.791 ERROR retrieving program info when trying to
delete
> program for chanid 15489 recorded at Wed Jan 18 19:00:26 2006. Recording
> will NOT be deleted.

This is saying that the delete code in mythbackend couldn't load the program
info for the recording from the recorded table.

> Now, I don't have guide information for many of my channels. Are these
> recordings being expired at some point or does mean these recordings will
> never get deleted?

Nothing to do with guide data, it should only look at the recorded table and
optionally the channel table.

What do you get when you run the following SQL?

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 = 15489
        AND starttime = 20060118190026;

If that returns nothing, how about this one:

SELECT chanid, starttime, title
    FROM recorded
    WHERE recorded.chanid = 15489
        AND starttime = 20060118190026;

-- 
Chris

_______________________________________________
mythtv-dev mailing list
mythtv-dev at mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev





EMAIL DISCLAIMER 

Please Note: The information contained in this message may be privileged and
confidential, protected from disclosure, and/or intended only for the use of
the individual or entity named above. If the reader of this message is not
the intended recipient, or an employee or agent responsible for delivering
this message to the intended recipient, you are hereby notified that any
disclosure, distribution, copying or other dissemination of this
communication is strictly prohibited. If you received this communication in
error, please immediately reply to the sender, delete the message and
destroy all copies of it.

Thank You