Bug #18699 Wrong nodegroup shown in SHOW while data nodes are starting
Submitted: 31 Mar 2006 21:30 Modified: 8 Jun 2006 12:21
Reporter: Serge Kozlov Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S3 (Non-critical)
Version:4.1 -> OS:Linux (FC4)
Assigned to: Stewart Smith CPU Architecture:Any

[31 Mar 2006 21:30] Serge Kozlov
Description:
For cluster with 1 Replica 'SHOW' command shows wrong information about nodegroups. All nodes are in nodegroup 0 while they are  starting:

ndb_mgm> show
Cluster Configuration
---------------------
[ndbd(NDB)]     2 node(s)
id=2    @10.100.1.163  (Version: 5.1.9, starting, Nodegroup: 0, Master)
id=3    @10.100.1.163  (Version: 5.1.9, starting, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1   (Version: 5.1.9)

[mysqld(API)]   2 node(s)
id=15 (not connected, accepting connect from ndb16)
id=16 (not connected, accepting connect from any host)

ndb_mgm> Node 2: Started (version 5.1.9)
Node 3: Started (version 5.1.9)

ndb_mgm> show
Cluster Configuration
---------------------
[ndbd(NDB)]     2 node(s)
id=2    @10.100.1.163  (Version: 5.1.9, Nodegroup: 0, Master)
id=3    @10.100.1.163  (Version: 5.1.9, Nodegroup: 1)

[ndb_mgmd(MGM)] 1 node(s)
id=1    @10.100.1.163  (Version: 5.1.9)

How to repeat:
1. Create cluster config with 2 or more data nodes and 1 replica.
2. Start all nodes.
3. Run ndb_mgm and execute 'SHOW' command.

Suggested fix:
Remove nodegroup info while a node is starting?
[8 Jun 2006 12:21] Stewart Smith
ndb_mgm> show
Cluster Configuration
---------------------
[ndbd(NDB)]     2 node(s)
id=1    @127.0.0.1  (Version: 5.1.12, starting)
id=2    @127.0.0.1  (Version: 5.1.12, starting)

[ndb_mgmd(MGM)] 1 node(s)
id=3   (Version: 5.1.12)

[mysqld(API)]   8 node(s)
id=4 (not connected, accepting connect from any host)
id=5 (not connected, accepting connect from any host)
id=6 (not connected, accepting connect from any host)
id=7 (not connected, accepting connect from any host)
id=8 (not connected, accepting connect from any host)
id=9 (not connected, accepting connect from any host)
id=10 (not connected, accepting connect from any host)
id=11 (not connected, accepting connect from any host)

please re-open if can repeat in latest trees. also, step by step to reproduce would be great.