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

[18 Sep 2006 22:53] Lachlan Mulcahy 
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
[29 Sep 2006 15:53] Calvin Sun 
It is related to bug#22384.
[4 Oct 2006 19:20] Sergey Vojtovich 
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?
[5 Oct 2006 3:05] Lachlan Mulcahy 
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.
[5 Oct 2006 9:14] Sergey Vojtovich 
Thanks, Lachlan. I think I cannot mark this bug as duplicate, since I failed to repeat it with mysql-4.0.26.
[6 Oct 2006 5:23] Lachlan Mulcahy 
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
[6 Oct 2006 5:46] Sergey Vojtovich 
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.
[8 Oct 2006 23:19] Lachlan Mulcahy 
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.
[9 Oct 2006 5:29] Sergey Vojtovich 
Duplicate of BUG#22384.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.043 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.