[mythtv-users] Show total times are incorrect

[Dylan Keon]

On 12/21/06, Leo Kliger <lkliger at bigpond.net.au> wrote:
>
> > >
> > >The "starttime" and "endtime" values appear correct in the various
> > >record* tables.  Not sure what else to check.  Thanks for any tips.
> >
> > Sounds like a corrupt seek table to to me.
> >
> > myiasmchk /var/lib/mysql/mythconverg/*.MYI
> >
> > That will tell you if you have any bad tables.
>
> In my experience this has indicated a timezone mismatch between the FE
> and BE....
>
> Answer is to make sure all systems use timezone and agree on what the
> time is.


It is a combined FE/BE.  The time zone is set correctly.

Good call on the MyISAM table corruption.  I think that was the
problem.  There were many errors (see below), but 'myisamchk --recover
*.MYI' fixed everything.

Thanks!


Here is the myisamchk error output:

# myisamchk *.MYI > /tmp/my.txt
myisamchk: warning: 5 clients are using or haven't closed the table properly
MyISAM-table 'cardinput.MYI' is usable but should be fixed
myisamchk: warning: 4 clients are using or haven't closed the table properly
MyISAM-table 'credits.MYI' is usable but should be fixed
myisamchk: warning: 4 clients are using or haven't closed the table properly
MyISAM-table 'housekeeping.MYI' is usable but should be fixed
myisamchk: warning: 5 clients are using or haven't closed the table properly
MyISAM-table 'inuseprograms.MYI' is usable but should be fixed
myisamchk: warning: 4 clients are using or haven't closed the table properly
MyISAM-table 'jobqueue.MYI' is usable but should be fixed
myisamchk: warning: 4 clients are using or haven't closed the table properly
MyISAM-table 'mythweb_sessions.MYI' is usable but should be fixed
myisamchk: warning: 4 clients are using or haven't closed the table properly
MyISAM-table 'oldprogram.MYI' is usable but should be fixed
myisamchk: warning: 5 clients are using or haven't closed the table properly
MyISAM-table 'oldrecorded.MYI' is usable but should be fixed
myisamchk: warning: 4 clients are using or haven't closed the table properly
MyISAM-table 'people.MYI' is usable but should be fixed
myisamchk: warning: 4 clients are using or haven't closed the table properly
MyISAM-table 'programgenres.MYI' is usable but should be fixed
myisamchk: warning: 5 clients are using or haven't closed the table properly
MyISAM-table 'program.MYI' is usable but should be fixed
myisamchk: warning: 4 clients are using or haven't closed the table properly
MyISAM-table 'programrating.MYI' is usable but should be fixed
myisamchk: warning: 5 clients are using or haven't closed the table properly
MyISAM-table 'recordedcredits.MYI' is usable but should be fixed
myisamchk: warning: 5 clients are using or haven't closed the table properly
MyISAM-table 'recordedmarkup.MYI' is usable but should be fixed
myisamchk: warning: 5 clients are using or haven't closed the table properly
MyISAM-table 'recorded.MYI' is usable but should be fixed
myisamchk: warning: 5 clients are using or haven't closed the table properly
MyISAM-table 'recordedprogram.MYI' is usable but should be fixed
myisamchk: warning: 4 clients are using or haven't closed the table properly
MyISAM-table 'recordedrating.MYI' is usable but should be fixed
myisamchk: warning: Table is marked as crashed
myisamchk: warning: 2 clients are using or haven't closed the table properly
myisamchk: error: Record at pos: 341020 is not remove-marked
myisamchk: error: record delete-link-chain corrupted
myisamchk: error: Found 330137 keys of 290896
myisamchk: error: Unexpected byte: 3 at link: 341020
MyISAM-table 'recordedseek.MYI' is corrupted
Fix it using switch "-r" or "-o"
myisamchk: warning: 1 client is using or hasn't closed the table properly
MyISAM-table 'recordmatch.MYI' is usable but should be fixed
myisamchk: warning: 5 clients are using or haven't closed the table properly
MyISAM-table 'record.MYI' is usable but should be fixed
myisamchk: warning: 5 clients are using or haven't closed the table properly
MyISAM-table 'settings.MYI' is usable but should be fixed
myisamchk: warning: 1 client is using or hasn't closed the table properly
MyISAM-table 'videometadata.MYI' is usable but should be fixed