[mythtv-users] Show total times are incorrect

Melunko melunko at gmail.com
Fri Dec 22 14:40:13 UTC 2006


Hi,

I have a similar problem, but with the recorded file sizes (recorded table).
The file size in the table is wrong. Should it be a table corruption as
well? Or a mythtv problem? I am using  0.20.20060828-3.

BR
Melunko

On 12/22/06, Dylan Keon <dbkeon.ml at gmail.com> wrote:
>
> 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
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20061222/45a64b27/attachment-0001.htm 


More information about the mythtv-users mailing list