Re: Can't create table

[Maurice Sobiera]

Hi Mauritz,

none of the api and data nodes are connecting after submiting this command on the management servers.

ndb_mgmd --reload --config-file=/var/lib/mysql-cluster/config.ini --configdir=/var/lib/mysql-cluster/

ndbd shows:


ndb_mgm> Node 4: Forced node shutdown completed. Occurred during startphase 0. Initiated by signal 9.


ndb_mgm> Node 3: Forced node shutdown completed. Occurred during startphase 0. Initiated by signal 9.


ndb_mgm> show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=3 (not connected, accepting connect from XXX.XXX.XXX.X87)
id=4 (not connected, accepting connect from XXX.XXX.XXX.X98)

[ndb_mgmd(MGM)] 2 node(s)
id=1 @XXX.XXX.XXX.X26 (mysql-8.0.23 ndb-8.0.23)
id=2 @XXX.XXX.XXX.X00 (mysql-8.0.23 ndb-8.0.23)

[mysqld(API)] 2 node(s)
id=5 (not connected, accepting connect from XXX.XXX.XXX.X29)
id=6 (not connected, accepting connect from XXX.XXX.XXX.X64)

87 Shows:


[root@v220210316867147015 ~]# ndbd
2021-04-28 22:09:00 [ndbd] INFO -- Angel connected to 'XXX.XXX.XXX.X26:1186'
2021-04-28 22:09:00 [ndbd] INFO -- Angel allocated nodeid: 4
[root@v220210316867147015 ~]#


cluster log says: Unable to allocate nodeid for API at XXX.XXX.XXX.X64. Returned error: 'Cluster not ready for nodeid allocation.