[mythtv-users] Wrong Time on Progress Bar

[Eric S]

On Friday, October 24, 2003, at 03:09 PM, Bruce Markey wrote:

> Eric S wrote:
>> On Friday, October 24, 2003, at 05:23 AM, Joseph A. Caputo wrote:
>>> On Friday 24 October 2003 02:26, Eric S wrote:
>>>
>>>> Wondering if anyone has dealt with this problem.  I've had a couple
>>>> mishaps the past couple days, mysql lock-up, a 0 KB size recording
>>>> that would immediately crash the front end in preview.  May have had
>>>> some disk problems, need to move to the new back-end box soon.
>>>>
>>>> Anyway, the problem is that even old recordings are showing the 
>>>> wrong
>>>> program length in the progress bar when paused.  It shows 48:38 for 
>>>> a
>>>> half hour show (usually 29:56 I think).  Saved position is also not
>>>> working as a possible side effect . . .
>>>
>>>
>>> This may or may not help, but have you tried regenerating your 
>>> seektable
>>> with mythcommflag?  Though I believe there was a thread recently that
>>> indicated mythcommflag wouldn't regen the seektable if one (even a
>>> broken one) already existed.  Worth a try, though, maybe...
>>>
>> Poking through the database with webmin I got this:
>> SQL desc `recordedmarkup` failed : Can't open file: 
>> 'recordedmarkup.MYI'. (errno: 145)
>> Any way to rebuild this??
>
> man mysqlcheck
>
> This has happened to others, usually on the `recordedmarkup`
> table. "mysqlcheck -r -u mythtv -pmythtv mythconverg" should
> fix it.
>
>

Yep, this fixed it, figured out yesterday.  A couple questions though . 
. .

Why is it usually this database that goes bad?

Is there any reason not to run mysqlcheck -r daily as part of a 
self-maintainence routine ??

Thanks,

-Eric