MySQL Bugs: #25048: ERROR 126 : Incorrect key file for table '.XXXX.MYI'; try to repair it

Bug #25048	ERROR 126 : Incorrect key file for table '.XXXX.MYI'; try to repair it
Submitted:	13 Dec 2006 18:46	Modified:	3 Jan 2007 11:38
Reporter:	Ken Hall	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: MyISAM storage engine	Severity:	S1 (Critical)
Version:	5.0.27/5.0BK/5.1b	OS:	Windows (Windows/Linux)
Assigned to:	Sergey Vojtovich	CPU Architecture:	Any
Tags:	bfsm_2006_12_21, corruption, myisam

File:	Maximum allowed size is 50MB.
Description:
Privacy:

If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.

To split a large file:

On *nix platforms use the split command e.g. split -b 50MB <my_large_archive> <my_split_archive_prefix>
On windows use WinZip or a similar utility to split the large file

my.ini contents and information about the server configuration

Attachment: my.ini_and_machine_information.txt (text/plain), 11.13 KiB.

script which will reproduce the error

Attachment: reproducableError.sql (text/plain), 66.86 KiB.

slightly smaller testcase

Attachment: testcase1.sql (text/x-delimtext), 11.29 KiB.

testcase with fake data

Attachment: testcase2.sql (text/x-delimtext), 6.16 KiB.

debug trace of the failing DELETE statement

Attachment: bug25048.zip (application/x-zip-compressed, text), 45.40 KiB.

testcase with just 3 int columns and keys

Attachment: testcase3.sql (text/x-delimtext), 23.66 KiB.