[mythtv-users] Can play recording, but can't fast forward !

Michael T. Dean mtdean at thirdcontact.com
Fri Aug 15 15:22:28 UTC 2008


On 08/15/2008 11:05 AM, Jean-Yves Avenard wrote:
> 2008/8/16 Michael T. Dean:
>   
>> No.  The optimize_mythdb.pl does a repair as well as an analyze and
>> optimize on all the myth tables (all three of which need to be done
>> "occasionally").  Perhaps it's possible (though I would say very
>> improbable) that the optimize/analyze (which can shrink database tables)
>> may have revealed more problems than were apparent after the first
>> repair, but I couldn't explain how (if it is possible)...
>>     
> Ok ... It seems now that it only happens with a few recordings ...
>   

When you say, "it only happens," do you mean the inability for ffwd or 
are you still getting a message about a crashed table?  If the former, 
no problem (keep reading), if the latter, I'd really think there's a 
filesystem issue.

> I can watch them or play them at 3X the speed ; anything faster than
> that and mythfrontend will hang forever.
>   

Yeah.  Note that neither mysqlcheck --auto-repair nor optimize_mythdb.pl 
can repair the /data/ within the crashed table.  They simply repair the 
table.  If data was corrupted, you have to recreate that data.  You can 
do that by running either mythcommflag --rebuild or mythtranscode 
--buildindex (the latter being required for most digital TV--and 
possibly PVR-x50--MPEG-2).

> Interestingly ; even though the recording is only about 30 minutes
> long ; mythtv show them as being 18+ hours
>   

Yeah.  That will happen with invalid data.

> for some reasons ; it seems obvious the database entry for those
> recordings is corrupted...
>   

Exactly.

>> So, I'd think if it happened again, you may have some problems with your
>> filesystem or storage.  Generally, the MySQL tables will only crash when
>> MySQL dies unexpectedly during a write or something (i.e. power blink or
>> whatever).  It definitely shouldn't be happening frequently.
>>     
> the PC did crash earlier today and I had to hard-reset it (holding the
> power button for a while)
>   

That would explain the initial corruption.

>> I'd highly recommend:
>> http://www.mythtv.org/wiki/index.php/Database_Backup_and_Restore .  As a
>> matter of fact, if I were you, I'd backup the DB (to another disk--or at
> setting it up now ;
> been running myth for over 3 years ; never bothered to do it :)

Never a bad thing to have backups.  :)

Mike


More information about the mythtv-users mailing list