Bug #22384 DELETE FROM table causes "Incorrect key file for table"
Submitted: 15 Sep 2006 11:42 Modified: 10 Oct 2006 20:33
Reporter: Shane Bester
Status: Closed
Category:Server: MyISAM Severity:S1 (Critical)
Version:4.0BK,4.1BK,5.0BK,5.1BK OS:Any (*)
Assigned to: Ingo Strüwing Target Version:
Tags: myisam, table, crash, keyfile, corruption

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-22384.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.

[17 Sep 2006 1:11] Shane Bester 
**NEW TESTCASE** Import into mysql using command line client

Attachment: bug22384_testcase.zip (application/zip, text), 161.79 KiB.
[17 Sep 2006 10:22] Shane Bester 
ANOTHER TESTCASE that can show key file crash when imported.

Attachment: bug22384_testcase2.zip (application/zip, text), 148.65 KiB.
[17 Sep 2006 12:34] Shane Bester 
Yes another slightly different testcase. import into mysql

Attachment: bug22384_testcase3.zip (application/zip, text), 190.85 KiB.
[28 Sep 2006 11:21] Ingo Strüwing 
My test case which seems too big for the test suite.

Attachment: bug22384.test.gz (application/x-tar, text), 148.63 KiB.
[29 Sep 2006 12:07] Shane Bester 
smallest testcase I can come up with on 5.0

Attachment: t1_120859_ark.zip (application/x-zip-compressed, text), 106.58 KiB.