Bug #10167 Mysql crashes with concurrent DELETE and INSERT...SELECT queries As

Submitted:	26 Apr 2005 8:10	Modified:	27 Apr 2005 11:24
Reporter:	Hartmut Holzgraefe	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: MyISAM storage engine	Severity:	S1 (Critical)
Version:	4.1.11	OS:	Linux (linux)
Assigned to:	Michael Widenius	CPU Architecture:	Any

Description:
running the 3 attached perl scripts in parallel crashes the mysql server after a while,
reducing the key-buffer size seems to make the crash more likely to happen

How to repeat:
run the attached scripts in parallel, starting the insert script first, then the select script and finally the delete script

forgot to mention: this seems to affect multi-CPU machines only

glibc with LinuxThreads seems to show the problem more often than with NPTL
but both are affected

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

Fix (and test case) will be in 4.1.12 and 5.0.5

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/24364

Page generated in 0.040 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.