Bug #28199 Single User Mode. Status of sql nodes is shown wrong.
Submitted: 2 May 2007 13:12
Reporter: Serge Kozlov Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S3 (Non-critical)
Version:mysql-5.1 OS:Any
Assigned to: CPU Architecture:Any
Tags: 5.1.18-bk

[2 May 2007 13:12] Serge Kozlov
Description:
ndb_mgm shows wrong information about status of sql nodes (connected/not connected) if before entering in single user mode one data node was stopped (for cluster config with two replicas).

How to repeat:
1. Start cluster with two ndbd (R=2) and two sql nodes
2. Stop one ndbd node.
3. Switch one sql node to single user mode.
4. Look at list of sql nodes.

-- NDB Cluster -- Management Client --
ndb_mgm> show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)]     2 node(s)
id=2    @x.y.z.163  (mysql-5.1.18 ndb-6.2.1, Nodegroup: 0, Master)
id=3    @x.y.z.163  (mysql-5.1.18 ndb-6.2.1, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1    @x.y.z.163  (mysql-5.1.18 ndb-6.2.1)

[mysqld(API)]   2 node(s)
id=10   @x.y.z.163  (mysql-5.1.18 ndb-6.2.1)
id=20 (not connected, accepting connect from ndb17)

ndb_mgm> 3 stop
Node 3: Node shutdown initiated
Node 3: Node shutdown completed.
Node 3 has shutdown.

ndb_mgm> show
Cluster Configuration
---------------------
[ndbd(NDB)]     2 node(s)
id=2    @x.y.z.163  (mysql-5.1.18 ndb-6.2.1, Nodegroup: 0, Master)
id=3 (not connected, accepting connect from ndb16)

[ndb_mgmd(MGM)] 1 node(s)
id=1    @x.y.z.163  (mysql-5.1.18 ndb-6.2.1)

[mysqld(API)]   2 node(s)

id=10   @x.y.z.163  (mysql-5.1.18 ndb-6.2.1)
id=20 (not connected, accepting connect from ndb17)

ndb_mgm> enter single user mode 10
Single user mode entered
Access is granted for API node 10 only.
ndb_mgm> show
Cluster Configuration
---------------------
[ndbd(NDB)]     2 node(s)
id=2    @x.y.z.163  (mysql-5.1.18 ndb-6.2.1, single user mode, Nodegroup: 0,
Master)
id=3 (not connected, accepting connect from ndb16)

[ndb_mgmd(MGM)] 1 node(s)
id=1    @x.y.z.163  (mysql-5.1.18 ndb-6.2.1)

[mysqld(API)]   2 node(s)
id=10 (not connected, accepting connect from ndb16)
id=20 (not connected, accepting connect from ndb17)

ndb_mgm>