[mythtv-users] Myth not autoexpiring since upgrade to 0.22RC1

[Nick Morrott]

2009/10/27 Duncan Brown <mythtv at duncb.co.uk>:
> On 27/10/2009 01:40, Chris Pinkham wrote:

>> See if that SQL generates an error or lists the info on the programs
>> that may be expired.

> Running that command showed that the recorded table was crashed. I ran
> optimize_mythdb  and then the above command produced a result.
>
> Looks like that's all the problem was, as now the autoexpire list is full.

Duncan,

It's advisable to have optimize_mythdb.pl run daily (via cron if your
system is left on, or during startup if you regularly turn it off/on)
to help eliminate issues like this.

Cheers,
Nick

-- 
Nick Morrott

MythTV Official wiki:
http://mythtv.org/wiki/
MythTV users list archive:
http://www.gossamer-threads.com/lists/mythtv/users

"An investment in knowledge always pays the best interest." - Benjamin Franklin