[mythtv-users] Where do these expiry calls come from?

[Dave M G]

Nick,

Thank you for responding.

> ... I would recommend running the mythbackend with verbose
> database logging...
> It could well be the expirer code if the recording log output is
> correct.

I should mention that at this point, I have changed every table and text 
column in the database to use utf8 encoding. But that's just an aside at 
this point.

At first I ran debugging output for just database calls, and there was 
nothing obvious about the queries that indicated a collation, or any 
other problem.

So then I ran verbose mode to display absolutely all the output, which 
I've included some below.

 From my perspective, which is by no means expert, there is no 
indication in the output to indicate an error that would account for the 
incorrect OSD display.

That would suggest, from your comment above, that the problem lies in 
the expirer code...? However, I'm not sure that the expirer code can be 
the whole story, because why would the code that drives the expiry of 
programs have an influence on the OSD for when one changes a channel?

Output:

2007-02-16 20:10:36.593 MSqlQuery: SELECT chanid, starttime, 
lastupdatetime, recusage,  hostname FROM inuseprograms;
2007-02-16 20:10:36.593 AutoExpire: Adding Programs to 'Do Not Expire' List
2007-02-16 20:10:36.593     1009 @ Fri Feb 16 20:08:35 2007 in use by 
recorder on homebase
2007-02-16 20:10:36.594     1009 @ Fri Feb 16 20:08:35 2007 in use by 
player on homebase
2007-02-16 20:10:36.594 AutoExpire: ExpireLiveTV(10000)
2007-02-16 20:10:36.595 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 = 
'homebase'  AND deletepending = 0 ORDER BY autoexpire DESC, starttime ASC
2007-02-16 20:10:36.596 MSqlQuery: SELECT basename FROM recorded WHERE 
chanid = '1004' AND       starttime = '2007-02-16T20:07:24';
2007-02-16 20:10:36.596 AutoExpire: FillDBOrdered: Adding chanid 1004 @ 
Fri Feb 16 20:07:24 2007 to expire list
2007-02-16 20:10:36.597 MSqlQuery: SELECT basename FROM recorded WHERE 
chanid = '1005' AND       starttime = '2007-02-16T20:07:33';
2007-02-16 20:10:36.598 AutoExpire: FillDBOrdered: Adding chanid 1005 @ 
Fri Feb 16 20:07:33 2007 to expire list
2007-02-16 20:10:36.598 MSqlQuery: SELECT basename FROM recorded WHERE 
chanid = '1006' AND       starttime = '2007-02-16T20:07:38';
2007-02-16 20:10:36.599 AutoExpire: FillDBOrdered: Adding chanid 1006 @ 
Fri Feb 16 20:07:38 2007 to expire list
2007-02-16 20:10:36.599 MSqlQuery: SELECT basename FROM recorded WHERE 
chanid = '1007' AND       starttime = '2007-02-16T20:08:19';
2007-02-16 20:10:36.600 AutoExpire: FillDBOrdered: Adding chanid 1007 @ 
Fri Feb 16 20:08:19 2007 to expire list
2007-02-16 20:10:36.600 MSqlQuery: SELECT basename FROM recorded WHERE 
chanid = '1008' AND       starttime = '2007-02-16T20:08:25';
2007-02-16 20:10:36.601 AutoExpire: FillDBOrdered: Adding chanid 1008 @ 
Fri Feb 16 20:08:25 2007 to expire list
2007-02-16 20:10:36.601 AutoExpire: SendDeleteMessages, cycling through 
expire list.
2007-02-16 20:10:36.601     Checking 1004 @ Fri Feb 16 20:00:00 2007
2007-02-16 20:10:36.601 Expiring ???????????????????? from Fri Feb 16 
20:00:00 2007, 6 MBytes, forced expire (LiveTV recording)
2007-02-16 20:10:36.601     After unlink we should have 79062 MB free.
2007-02-16 20:10:36.601     Checking 1005 @ Fri Feb 16 19:00:00 2007
2007-02-16 20:10:36.602 Expiring ???? from Fri Feb 16 19:00:00 2007, 2 
MBytes, forced expire (LiveTV recording)
2007-02-16 20:10:36.602     After unlink we should have 79065 MB free.
2007-02-16 20:10:36.602     Checking 1006 @ Fri Feb 16 20:00:00 2007
2007-02-16 20:10:36.602 Expiring ????????? from Fri Feb 16 20:00:00 
2007, 25 MBytes, forced expire (LiveTV recording)
2007-02-16 20:10:36.602     After unlink we should have 79090 MB free.
2007-02-16 20:10:36.602     Checking 1007 @ Fri Feb 16 19:57:00 2007
2007-02-16 20:10:36.602 Expiring ???????????????? from Fri Feb 16 
19:57:00 2007, 3 MBytes, forced expire (LiveTV recording)
2007-02-16 20:10:36.603     After unlink we should have 79094 MB free.
2007-02-16 20:10:36.603     Checking 1008 @ Fri Feb 16 20:08:25 2007
2007-02-16 20:10:36.603 Expiring Unknown from Fri Feb 16 20:08:25 2007, 
6 MBytes, forced expire (LiveTV recording)
2007-02-16 20:10:36.603     After unlink we should have 79100 MB free.


-- 
Dave M G
Ubuntu 6.10 Edgy Eft
Kernel 2.6.17.7
Pentium D Dual Core Processor
PHP 5, MySQL 5, Apache 2