Bug #10167 Mysql crashes with concurrent DELETE and INSERT...SELECT queries As
Submitted: 26 Apr 2005 10:10 Modified: 27 Apr 2005 13:24
Reporter: Hartmut Holzgraefe
Status: Closed
Category:Server: MyISAM Severity:S1 (Critical)
Version:4.1.11 OS:Linux (linux)
Assigned to: Bugs System Target Version:

[26 Apr 2005 10:10] Hartmut Holzgraefe 
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
[26 Apr 2005 10:19] Hartmut Holzgraefe 
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
[27 Apr 2005 13:24] Michael Widenius 
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
[27 Apr 2005 13:27] Bugs System 
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