Hi,<br><br>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><br>
BR<br>Melunko<br><br><div><span class="gmail_quote">On 12/22/06, <b class="gmail_sendername">Dylan Keon</b> <<a href="mailto:dbkeon.ml@gmail.com">dbkeon.ml@gmail.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
On 12/21/06, Leo Kliger <<a href="mailto:lkliger@bigpond.net.au">lkliger@bigpond.net.au</a>> wrote:<br>><br>> > ><br>> > >The "starttime" and "endtime" values appear correct in the various
<br>> > >record* tables. Not sure what else to check. Thanks for any tips.<br>> ><br>> > Sounds like a corrupt seek table to to me.<br>> ><br>> > myiasmchk /var/lib/mysql/mythconverg/*.MYI
<br>> ><br>> > That will tell you if you have any bad tables.<br>><br>> In my experience this has indicated a timezone mismatch between the FE<br>> and BE....<br>><br>> Answer is to make sure all systems use timezone and agree on what the
<br>> time is.<br><br><br>It is a combined FE/BE. The time zone is set correctly.<br><br>Good call on the MyISAM table corruption. I think that was the<br>problem. There were many errors (see below), but 'myisamchk --recover
<br>*.MYI' fixed everything.<br><br>Thanks!<br><br><br>Here is the myisamchk error output:<br><br># myisamchk *.MYI > /tmp/my.txt<br>myisamchk: warning: 5 clients are using or haven't closed the table properly<br>
MyISAM-table 'cardinput.MYI' is usable but should be fixed<br>myisamchk: warning: 4 clients are using or haven't closed the table properly<br>MyISAM-table 'credits.MYI' is usable but should be fixed<br>
myisamchk: warning: 4 clients are using or haven't closed the table properly<br>MyISAM-table 'housekeeping.MYI' is usable but should be fixed<br>myisamchk: warning: 5 clients are using or haven't closed the table properly
<br>MyISAM-table 'inuseprograms.MYI' is usable but should be fixed<br>myisamchk: warning: 4 clients are using or haven't closed the table properly<br>MyISAM-table 'jobqueue.MYI' is usable but should be fixed
<br>myisamchk: warning: 4 clients are using or haven't closed the table properly<br>MyISAM-table 'mythweb_sessions.MYI' is usable but should be fixed<br>myisamchk: warning: 4 clients are using or haven't closed the table properly
<br>MyISAM-table 'oldprogram.MYI' is usable but should be fixed<br>myisamchk: warning: 5 clients are using or haven't closed the table properly<br>MyISAM-table 'oldrecorded.MYI' is usable but should be fixed
<br>myisamchk: warning: 4 clients are using or haven't closed the table properly<br>MyISAM-table 'people.MYI' is usable but should be fixed<br>myisamchk: warning: 4 clients are using or haven't closed the table properly
<br>MyISAM-table 'programgenres.MYI' is usable but should be fixed<br>myisamchk: warning: 5 clients are using or haven't closed the table properly<br>MyISAM-table 'program.MYI' is usable but should be fixed
<br>myisamchk: warning: 4 clients are using or haven't closed the table properly<br>MyISAM-table 'programrating.MYI' is usable but should be fixed<br>myisamchk: warning: 5 clients are using or haven't closed the table properly
<br>MyISAM-table 'recordedcredits.MYI' is usable but should be fixed<br>myisamchk: warning: 5 clients are using or haven't closed the table properly<br>MyISAM-table 'recordedmarkup.MYI' is usable but should be fixed
<br>myisamchk: warning: 5 clients are using or haven't closed the table properly<br>MyISAM-table 'recorded.MYI' is usable but should be fixed<br>myisamchk: warning: 5 clients are using or haven't closed the table properly
<br>MyISAM-table 'recordedprogram.MYI' is usable but should be fixed<br>myisamchk: warning: 4 clients are using or haven't closed the table properly<br>MyISAM-table 'recordedrating.MYI' is usable but should be fixed
<br>myisamchk: warning: Table is marked as crashed<br>myisamchk: warning: 2 clients are using or haven't closed the table properly<br>myisamchk: error: Record at pos: 341020 is not remove-marked<br>myisamchk: error: record delete-link-chain corrupted
<br>myisamchk: error: Found 330137 keys of 290896<br>myisamchk: error: Unexpected byte: 3 at link: 341020<br>MyISAM-table 'recordedseek.MYI' is corrupted<br>Fix it using switch "-r" or "-o"<br>
myisamchk: warning: 1 client is using or hasn't closed the table properly<br>MyISAM-table 'recordmatch.MYI' is usable but should be fixed<br>myisamchk: warning: 5 clients are using or haven't closed the table properly
<br>MyISAM-table 'record.MYI' is usable but should be fixed<br>myisamchk: warning: 5 clients are using or haven't closed the table properly<br>MyISAM-table 'settings.MYI' is usable but should be fixed<br>
myisamchk: warning: 1 client is using or hasn't closed the table properly<br>MyISAM-table 'videometadata.MYI' is usable but should be fixed<br>_______________________________________________<br>mythtv-users mailing list
<br><a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br><a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br></blockquote></div>
<br>