MySQL Bugs: #89535: NDBD node not coming up

Bug #89535	NDBD node not coming up
Submitted:	5 Feb 2018 13:17	Modified:	14 Mar 2018 18:18
Reporter:	Abdulla Saiyed	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Cluster: Cluster (NDB) storage engine	Severity:	S2 (Serious)
Version:	5.6.21	OS:	Red Hat (RHEL 6.8)
Assigned to:	MySQL Verification Team	CPU Architecture:	Any
Tags:	5.6.21-ndb-7.3.7-cluster-gpl, NDBD issue

Description:
Dear Team,

I have a setup with DC and DR
In DC I have two nodes - Primary and Secondary.

The NDBD node is working only in Primary but after backup restore the NDBD of secondary and DR site is not coming up
and it give below error:

Forced node shutdown completed. Occured during startphase 3. Caused by error 2311: 'Conflict when selecting restart type(Internal error, programming error or missing error message, please report a bug). Temporary error, restart node'.

Please provide the suggestions/solution.

How to repeat:
I have tried to up the node by NDBD -n but no luck

[bofmysql@BOF-DB1 ~]$ ndb_mgm
-- NDB Cluster -- Management Client --
ndb_mgm> show;
Connected to Management Server at: 192.168.8.35:1186
Cluster Configuration
---------------------
[ndbd(NDB)]	3 node(s)
id=4	@192.168.8.35  (mysql-5.6.21 ndb-7.3.7, Nodegroup: 0, *)
id=5	@192.168.8.41  (mysql-5.6.21 ndb-7.3.7, not started)
id=6	@192.168.8.46  (mysql-5.6.21 ndb-7.3.7, not started)

[ndb_mgmd(MGM)]	3 node(s)
id=1	@192.168.8.35  (mysql-5.6.21 ndb-7.3.7)
id=2	@192.168.8.41  (mysql-5.6.21 ndb-7.3.7)
id=3	@192.168.8.46  (mysql-5.6.21 ndb-7.3.7)

[mysqld(API)]	3 node(s)
id=7	@192.168.8.35  (mysql-5.6.21 ndb-7.3.7)
id=8	@192.168.8.41  (mysql-5.6.21 ndb-7.3.7)
id=9	@192.168.8.46  (mysql-5.6.21 ndb-7.3.7)

Hi,

I doubt this is a bug, it looks like you should start that node with --initial due to config changes you made, but can't say for sure without full logs.

all best
Bogdan

Error log files

Attachment: BOF-DB.zip (application/octet-stream, text), 908.37 KiB.

Dear Bodgan,

Thank you for reply,
I have attached here BOF-DB.zip it contains BOF-DB.err and ndb_6_out.log

Waiting for you reply.

Regards,
Dushyant.

Dear Bogdan,

Kindly help.

Regards,
Dushyant.

Hi,

As I suspected this is not a bug.
With regards to properly configure and use MySQL Cluster I suggest you contact our Support and Consulting team, or check out our forum.

kind regards
Bogdan