MySQL Forums
Forum List  »  NDB clusters

Re: Can't create table
Posted by: Maurice Sobiera
Date: April 28, 2021 02:18PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
1018
April 14, 2021 01:57PM
429
April 14, 2021 02:51PM
407
April 15, 2021 03:51AM
445
April 15, 2021 06:02AM
439
April 16, 2021 08:01AM
449
April 16, 2021 11:31AM
361
April 17, 2021 04:33AM
398
April 17, 2021 03:29PM
348
April 28, 2021 10:50AM
385
April 28, 2021 11:51AM
Re: Can't create table
650
April 28, 2021 02:18PM
391
April 28, 2021 02:59PM
364
April 29, 2021 12:56AM
328
April 29, 2021 02:49AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.