MySQL Bugs: #116473: Can't start NDB cluster

Bug #116473	Can't start NDB cluster
Submitted:	24 Oct 2024 17:55	Modified:	30 Oct 2024 4:49
Reporter:	CunDi Fang	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Cluster: Cluster (NDB) storage engine	Severity:	S2 (Serious)
Version:	8.0.40-cluster MySQL Cluster Community S	OS:	Any
Assigned to:	MySQL Verification Team	CPU Architecture:	Any

Description:
A very strange bug, after I configured a cluster, it only ran smoothly for a sentence of transactions or so before it crashed, all ndbd's all crashed. Subsequently when I try to restart the ndbd, as soon as the last ndbd node is up and synchronized, all ndbd nodes crash at the same time!

How to repeat:
Start an NDB cluster and then I should just execute a create table statement and it happens. I will give you all the relevant log files. As of now this bug can't be fixed on its own and there is no other way to fix it but by reconfiguring the whole cluster.

Suggested fix:
From the log messages, it appears that there is a problem with metadata acquisition and synchronization.

024-10-24 13:51:20 [MgmtSrvr] ALERT    -- Node 4: Forced node shutdown completed. Caused by error 2815: 'File not found(Ndbd file system inconsistency error, please report a bug). Ndbd file system error, restart node initial'.
2024-10-24 13:51:20 [MgmtSrvr] ALERT    -- Node 3: Forced node shutdown completed. Caused by error 2815: 'File not found(Ndbd file system inconsistency error, please report a bug). Ndbd file system error, restart node initial'.
2024-10-24 13:51:20 [MgmtSrvr] ALERT    -- Node 5: Forced node shutdown completed. Caused by error 2815: 'File not found(Ndbd file system inconsistency error, please report a bug). Ndbd file system error, restart node initial'.

I am sorry but this is not a bug. There is something wrong with your setup.

Irrelevant to this, add free [mysqld] slots in your config. But this FS issues you are experiencing are something related to your setup, please investigate what is going on with your FS.