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:	19 Sep 2006 0:53	Modified:	9 Oct 2006 7:29
Reporter:	Lachlan Mulcahy
Status:	Duplicate
Category:	Server	Severity:	S3 (Non-critical)
Version:	4.0.26	OS:
Assigned to:	Sergey Vojtovich	Target Version:

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.