[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