MySQL Bugs: #22460: MyISAM Incorrect Key File Error with large amount of DELETEs and INSERTs

Bug #22460	MyISAM Incorrect Key File Error with large amount of DELETEs and INSERTs
Submitted:	18 Sep 2006 22:53	Modified:	9 Oct 2006 5:29
Reporter:	Lachlan Mulcahy	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	4.0.26	OS:
Assigned to:	Assigned Account	CPU Architecture:	Any

Description:
A large amount of DELETE and INSERT traffic on a MyISAM table caused "Incorrect key file for table" corruption to occur.

How to repeat:
See Internal Notes.

Suggested fix:
Unknown

It is related to bug#22384.

Lachlan, I failed to repeat described problem on linux/686 using provided test case and both mysql-4.0.26 and mysql-4.0BK. Could you provide more information how to repeat this problem or try to repeat it yourself using freshly cloned 4.0?

I believe Ingo and Shane Bester have been able to reproduce the problem and my understanding is that this is now a duplicate of Bug #22384.

I will ask them to confirm this.

Thanks, Lachlan. I think I cannot mark this bug as duplicate, since I failed to repeat it with mysql-4.0.26.

I have included the steps I used to reproduce using customer data in a private note.

I confirmed these steps by reproducing the problem myself again today.

Let me know if you are still unable to reproduce, however, I already have a build in progress with the fix for bug#22384. I will see if I am able to reproduce the same problem on the build or not.

Kind Regards,
Lachlan

Lachlan, thanks for the description. If you're going to test this issue on the build based on latest 4.0, I believe there is no much sense to do the same work myself. Please post your results here.

I retested this on the latest 4.0.28 with the fix for Bug #22384 and I no longer receive the Incorrect Key File error.

You may close this bug as a duplicate of #22384.

Duplicate of BUG#22384.