Bug #27644 ndb: connecting api node/mysqld may "steal" node_id from running mysqld
Submitted: 4 Apr 2007 14:30 Modified: 5 Apr 2007 11:31
Reporter: Tomas Ulin
Status: Verified
Category:Server: Cluster Severity:S3 (Non-critical)
Version:mysql-5.0 OS:Any
Assigned to: [ name withheld ] Target Version:5.0+
Triage: Triaged: D3 (Medium)

[4 Apr 2007 14:30] Tomas Ulin 
Description:
this can be seen causing failure of ndb_autodiscover3 on occasion

in this case the utility program ndb_desc connects to ndb_mgmd right after cluster comes
up and receives the same node id as one of the mysqld's

How to repeat:
.

Suggested fix:
on disconnect the mysqld must disconnect completely and delete cluster connection, and
recreate, to allocate new node id
[5 Apr 2007 8:58] 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/23864

ChangeSet@1.2433, 2007-04-05 09:12:30+02:00, tomas@whalegate.ndb.mysql.com +1 -0
  Bug#27644 ndb: connecting api node/mysqld may "steal" node_id from running mysqld
  - test case workaround to avoid random failures
[7 Apr 2007 9:00] Bugs System 
Pushed into 5.0.40
[7 Apr 2007 9:00] Bugs System 
Pushed into 5.1.18-beta