Bug #18472 race condition between multiple mysqld's when setting up cluster/schema
Submitted: 23 Mar 2006 20:44 Modified: 5 Apr 2006 4:31
Reporter: Tomas Ulin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S2 (Serious)
Version:5.1.8 bk src OS:
Assigned to: Tomas Ulin CPU Architecture:Any

[23 Mar 2006 20:44] Tomas Ulin
Description:
2 mysqlds starting up simultaneously like in mysql-test-run

they will create cluster/schema table simultaneously

a race happens for the create table - create event sequence

the mysql server that "discovers" finds that no event has been created, and will attempt to create one, inbetween the first mysqld comes in and creates the event, create event code from second mysqld will attempt to recoved by (wrongly) deleting the event, and recreating it

How to repeat:
see above
[23 Mar 2006 20:55] 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/commits/4093
[4 Apr 2006 8:05] Tomas Ulin
peshed to 5.1.8
[5 Apr 2006 4:31] Jon Stephens
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:

Documented bugfix in 5.1.8 changelog. Closed.