MySQL Forums
Forum List  »  MyISAM

Re: ERROR 126 (HY000): Incorrect key file for table
Posted by: Hamish Moffatt
Date: October 01, 2007 04:59AM

I am running 5.0.45 and getting incorrect key file error messages.
I am using MythTV which generates some rather large tables; one particular table is crashing quite often and it contains over 493000 rows.

For example just now I ran a "REPAIR TABLE" ... on every table in the MythTV database, then immediately ran the mythcommflag process which will delete a bunch of rows and recreate them. Straight away I got:

DELETE FROM recordedseek WHERE chanid = '1001' AND starttime = '2006-10-08T20:29:00' AND type = 9 ;
Driver error was [2/126]:
QMYSQL3: Unable to execute query
Database error was:
Incorrect key file for table './mythconverg/recordedseek.MYI'; try to repair it


I'm running on 64-bit AMD x2 (dual core), for what that's worth.

This recordedseek table is crashing a few times a week. If I run MythTV's utility which regenerates a lot of that table, the error will occur within a few minutes.

Hamish

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: ERROR 126 (HY000): Incorrect key file for table
10034
October 01, 2007 04:59AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.