Bug #25048 ERROR 126 : Incorrect key file for table '.XXXX.MYI'; try to repair it
Submitted: 13 Dec 2006 19:46 Modified: 3 Jan 2007 12:38
Reporter: Ken Hall
Status: Closed
Category:Server: MyISAM Severity:S1 (Critical)
Version:5.0.27/5.0BK/5.1b OS:Microsoft Windows (Windows/Linux)
Assigned to: Sergey Vojtovich Target Version:
Tags: bfsm_2006_12_21, corruption, myisam

File: Maximum allowed size is 500KB.
Description:
Privacy:

If the data you need to attach is more than 500KB, you should create a compressed archive of the data and a README file that describes the data with a filename that includes the bug number (example: bug-data-25048.zip), and use FTP to upload the archive to ftp://ftp.mysql.com/pub/mysql/upload/. Once you have uploaded the file, add a comment to this bug to notify us about it. Note: This directory is unlistable, which means that once you have uploaded your file, you will not be able to see it.

All entries become the exclusive editorial property of Sun Microsystems, Inc.

[13 Dec 2006 19:48] Ken Hall 
my.ini contents and information about the server configuration

Attachment: my.ini_and_machine_information.txt (text/plain), 11.13 KiB.
[13 Dec 2006 19:53] Ken Hall 
script which will reproduce the error

Attachment: reproducableError.sql (text/plain), 66.86 KiB.
[19 Dec 2006 11:12] Shane Bester 
slightly smaller testcase

Attachment: testcase1.sql (text/x-delimtext), 11.29 KiB.
[19 Dec 2006 16:25] Shane Bester 
testcase with fake data

Attachment: testcase2.sql (text/x-delimtext), 6.16 KiB.
[19 Dec 2006 16:51] Shane Bester 
debug trace of the failing DELETE statement

Attachment: bug25048.zip (application/x-zip-compressed, text), 45.40 KiB.
[19 Dec 2006 20:23] Shane Bester 
testcase with just 3 int columns and keys

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