Re: ERROR 126 (HY000): Incorrect key file for table
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
Subject
Views
Written By
Posted
57506
October 19, 2005 12:29PM
24595
October 19, 2005 01:19PM
21227
October 20, 2005 01:40AM
17680
October 20, 2005 03:36PM
16907
April 26, 2006 04:31AM
14675
January 24, 2007 10:59AM
12675
February 01, 2007 04:31AM
11026
April 09, 2007 06:11PM
9893
May 02, 2007 03:39AM
24487
May 02, 2007 09:06AM
13171
June 10, 2007 09:59AM
8834
August 31, 2007 02:48AM
7989
February 01, 2008 04:05AM
9341
March 11, 2008 11:09AM
7772
September 12, 2007 08:07PM
6945
September 20, 2007 03:28AM
Re: ERROR 126 (HY000): Incorrect key file for table
10034
October 01, 2007 04:59AM
6436
October 08, 2007 08:33AM
8331
October 31, 2007 09:37AM
5694
December 16, 2008 08:23PM
8227
November 07, 2005 01:26PM
6900
July 02, 2007 10:51PM
6222
April 26, 2006 04:02AM
7875
May 23, 2008 04:26AM
7872
December 16, 2008 08:19PM
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.