Bug #88915 ndbinfo.nodes doesn't show starting nodes

• Submitted: 14 Dec 2017 10:29
• Modified: 15 Dec 2017 7:02
• Reporter: Daniël van Eeden (OCA)
• Status: Not a Bug
• Category: MySQL Cluster: Cluster (NDB) storage engine
• Severity: S3 (Non-critical)
• Version: 7.6.3
• OS: Any
• Assigned to: MySQL Verification Team
• CPU Architecture: Any
• Tags: ndbinfo

[14 Dec 2017 10:29] Daniël van Eeden

Description:
A select * from nodes shows nodes which are started or stopping. Nodes which are starting are not visible.

This is odd as there is a status column and a start_phase column, so I would expect this information to be there.

ndbinfo.restart_info.node_restart_status_int for this node has value 17

ndb_mgm's status command shows:
starting (Last completed phase 4) (mysql-5.7.18 ndb-7.6.3)

How to repeat:
While a node starts compare ndbinfo.nodes and ndbinfo.restart_info.

Suggested fix:
Include information about starting nodes in ndbinfo.nodes

[15 Dec 2017 7:02] MySQL Verification Team

Hi,

We do show "STARTING" nodes after they connect to the cluster. For e.g.

mysql> select * from nodes;
+---------+---------+---------+-------------+-------------------+
| node_id | uptime  | status  | start_phase | config_generation |
+---------+---------+---------+-------------+-------------------+
|       2 | 4995678 | STARTED |           0 |                 1 |
+---------+---------+---------+-------------+-------------------+
1 row in set (0.00 sec)

mysql> select * from nodes;
+---------+---------+----------+-------------+-------------------+
| node_id | uptime  | status   | start_phase | config_generation |
+---------+---------+----------+-------------+-------------------+
|       2 | 4995679 | STARTED  |           0 |                 1 |
|       3 |       4 | STARTING |         100 |                 1 |
+---------+---------+----------+-------------+-------------------+
2 rows in set (0.00 sec)

mysql> select * from nodes;

+---------+---------+----------+-------------+-------------------+
| node_id | uptime  | status   | start_phase | config_generation |
+---------+---------+----------+-------------+-------------------+
|       2 | 4995683 | STARTED  |           0 |                 1 |
|       3 |       9 | STARTING |         100 |                 1 |
+---------+---------+----------+-------------+-------------------+
2 rows in set (0.00 sec)

mysql> select * from nodes;
+---------+---------+---------+-------------+-------------------+
| node_id | uptime  | status  | start_phase | config_generation |
+---------+---------+---------+-------------+-------------------+
|       2 | 4995684 | STARTED |           0 |                 1 |
|       3 |       9 | STARTED |           0 |                 1 |
+---------+---------+---------+-------------+-------------------+
2 rows in set (0.00 sec)