[mythtv-users] MySQL recordedseek regularly getting corrupted

[Jean-Yves Avenard]

Hi

I'm at my wit ends and it's something I have to fix rather regularly.
Used to be every few months, now it can happen several times a week.

When that happen, I can no longer seek in the file.

running mysqlcheck gives me:
mythconverg.recordedseek
error    : Can't create new tempfile: './mythconverg/recordedseek.TMD'
status   : Operation failed


I have deleted the database, and restored from a backend last time.
and now it has happen again.

I see nothing particularly wrong with the /var/lib/mysql/mythconverg folder.

permission of the folders are:
drwx------ 1 mysql mysql     11698 Nov 30 10:00 .

the recorded seek tables:
-rw-rw---- 1 mysql mysql      8698 Nov 27 21:53 recordedseek.frm
-rw-rw---- 1 mysql mysql 751934500 Nov 30 05:05 recordedseek.MYD
-rw-rw---- 1 mysql mysql 688532480 Nov 30 10:00 recordedseek.MYI
-rw-rw---- 1 mysql mysql 569909248 Nov 30 07:52 recordedseek.TMD

last time I could repair the table with:
myisamchk -r -f recordedseek.MYI

But surely, I shouldn't have to do this on a weekly basis :(

I deleted 3/4th of my recordings hoping to make the recordedseek table
less big, but still.

Any ideas would be greatly appreciated.

Thanks in advance
Jean-Yves