LinHES Forums
http://forums.linhes.org/

Crashed table
http://forums.linhes.org/viewtopic.php?f=21&t=24326
Page 1 of 1

Author:  Big boy stan [ Sat Mar 12, 2016 3:28 pm ]
Post subject:  Crashed table

My system seems to responding very slowly to remote commands. At least for the first load of recordings. In other words after pressing recordings on the remote, the screen just freezes for 15 seconds and then the recording screen comes up just fine. Selecting a recording to watch does another 10-15 second delay before the recording starts. Anyone have any suggestions on what could cause this. Never had this problem before and it has just grown over time.

I did a
Code:
mysqlcheck -u mythtv -pmythtv mythconverg ;


and got an all clear except for

Code:
mythconverg.recordedseek
warning  : Table is marked as crashed and last repair failed
warning  : 1 client is using or hasn't closed the table properly
error    : Invalid key block position: 278660227118242200  key block size: 1024  file_length: 44106752
error    : key delete-link-chain corrupted
error    : Corrupt


Does this have anything to do with it? I thought this was just for jumping around inside of a recording.

Thanks for any help

Author:  christ [ Wed Mar 23, 2016 5:55 pm ]
Post subject:  Re: Crashed table

Have you tried:
Code:
optimize_mythdb.pl


It should repair any crashed tables as part of its process.

I also found: https://www.mythtv.org/wiki/Repairing_the_Seektable
but it looks a bit labourious.

with mysqlcheck I think you would use the --auto-repair or the --repair flag which I think amounts to the same thing as optimize_mythtb.pl

Also found this thread which I think is fairly complete in terms of options.
http://lists.mythtv.org/pipermail/mytht ... 39464.html

Hope that helps.

Page 1 of 1 All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/