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>