MySQL Bugs: #50654: ndbinfo reports wrong transporter status for disconnected node

Bug #50654	ndbinfo reports wrong transporter status for disconnected node
Submitted:	27 Jan 2010 10:44	Modified:	11 Feb 2010 19:12
Reporter:	Bernd Ocklin	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Cluster: Cluster (NDB) storage engine	Severity:	S3 (Non-critical)
Version:	mysql-5.1-telco-7.1	OS:	Any
Assigned to:	Magnus Blåudd	CPU Architecture:	Any
Tags:	ndbinfo, STATUS, transporters

Description:
ndbinfo.transporter reports DISCONNECTING instead of DISCONNECTED.

How to repeat:
have a config with free unconnected API slots:

-- NDB Cluster -- Management Client --
ndb_mgm> show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)]	1 node(s)
id=2	@127.0.0.1  (mysql-5.1.41 ndb-7.1.0, Nodegroup: 0, Master)

[ndb_mgmd(MGM)]	1 node(s)
id=1	@127.0.0.1  (mysql-5.1.41 ndb-7.1.0)

[mysqld(API)]	5 node(s)
id=6	@127.0.0.1  (mysql-5.1.41 ndb-7.1.0)
id=7 (not connected, accepting connect from 127.0.0.1)
id=8 (not connected, accepting connect from 127.0.0.1)
id=9 (not connected, accepting connect from 127.0.0.1)
id=10 (not connected, accepting connect from 127.0.0.1)

select * from ndbinfo.transporters;

mysql> select * from ndb$transporters;
+---------+----------------+-------------------+
| node_id | remote_node_id | connection_status |
+---------+----------------+-------------------+
|       2 |              1 |                 0 |
|       2 |              2 |                 0 |
|       2 |              6 |                 0 |
|       2 |              7 |                 3 |
|       2 |              8 |                 3 |
|       2 |              9 |                 3 |
|       2 |             10 |                 3 |
+---------+----------------+-------------------+
7 rows in set (0.02 sec)

Suggested fix:
Use performStates in TransporterRegistry instead of IOState. The please use lower case state strings as also mgm server uses them.

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/99899

3403 Magnus Blaudd	2010-02-11
      Bug#50654	ndbinfo reports wrong transporter status for disconnected node
       - Make CMVMI report performState instead of ioState

Pushed to 7.1.2

Documented bugfix in the NDB-7.1.2 changelog as follows:

      The ndbinfo.transporters table (see "The ndbinfo transporters 
      Table") showed the status of disconnected nodes as DISCONNECTING 
      rather than DISCONNECTED.

Closed.