MySQL Bugs: #4095: MyISAM corruption happens with concurrent INSERTs

Bug #4095	MyISAM corruption happens with concurrent INSERTs
Submitted:	10 Jun 2004 20:06	Modified:	17 Jun 2004 9:48
Reporter:	SINISA MILIVOJEVIC	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server: MyISAM storage engine	Severity:	S1 (Critical)
Version:	4.0, 4.1, 5.0	OS:	Any (any)
Assigned to:	Ingo Strüwing	CPU Architecture:	Any
Tags:	corruption

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
A merge table  consists of one or more tables with fixed record lenght format.

Tables have a primary key and a secondary non-unique key containing the same columns as a primary key.

How to repeat:

You start from empty tables. 

When one thread runs a script with delayed insert commands and second runs simple SELECT * FROM table commands, corruption happens in matter of 15 seconds to one minute. 

A full test case is available from me directly for two reasons. 

First one is that a script with delayed inserts is too big and second one is due to customer's request.

no luck in repeating the bug so far :(