[mythtv] [mythtv-commits] Ticket #5912: Cannot fast forward, skip forward with latest SVN

[Michael T. Dean]

On 11/16/2008 05:27 AM, MythTV wrote:
> #5912: Cannot fast forward, skip forward with latest SVN
>
> Comment(by Paul Lambert):
>
>  Fantastic - that was great advice.  It is indeed crashed when I look in
>  the database, and the optimize_mythdb.pl script has fixed it.
>
>  However, anything recorded whilst that table was crashed still won't fast
>  forward.  Anything I can do to resolve that?  I'm going to try running
>  commercial flagging again to see if that does the trick, but anything
>  else?
>   

This is a great question for the -users list (if you have any further 
questions, please follow up there).

http://www.mythtv.org/wiki/index.php/Repairing_the_Seektable

>  Also, any logic to why table crashes happen, or magic in myth that could
>  keep that under control?

Notice the comment at the top of the optimize_mythdb.pl script that 
suggests running the script in a daily cron job (ideally at a time when 
recordings are least likely to occur)?  :)

>   I guess I should have the optimize script in a
>  cronjob or something?

Yep (perhaps you did notice the comment).

>   Maybe that should be an automatically set option as
>  part of the base myth install?

That would be up to packagers.

Eventually, Myth will do all required database maintenance automatically 
by itself.  I have partially-written patches to allow this, but it 
requires a lot of changes to make doing so safe (from a "without the 
safety changes, automatically repairing the DB could destroy the entire 
DB/all its data" perspective), therefore it will be a while, still.

Mike