MySQL Forums
Forum List  »  NDB clusters

Re: Node 6: Forced node shutdown completed. Occurred during startphase 5. Caused by error 2341
Posted by: Pradeep Manickam
Date: March 09, 2021 06:39PM

Hi Tiago,

I tried to create 2 new VMs and installed 8.0.23 and tried, but unfortunately ran into the same issue!

Then I installed 8.0.20 on the those VMs and they connected!

db_mgm> show
Cluster Configuration
---------------------
[ndbd(NDB)] 4 node(s)
id=4 @172.20.10.54 (mysql-8.0.23 ndb-8.0.23, Nodegroup: 0, *)
id=5 @172.20.10.53 (mysql-8.0.23 ndb-8.0.23, Nodegroup: 0)
id=6 @172.20.10.104 (mysql-8.0.20 ndb-8.0.20, no nodegroup)
id=7 @172.20.10.105 (mysql-8.0.20 ndb-8.0.20, no nodegroup)

[ndb_mgmd(MGM)] 1 node(s)
id=1 @172.20.10.50 (mysql-8.0.23 ndb-8.0.23)

[mysqld(API)] 2 node(s)
id=2 @172.20.10.51 (mysql-8.0.23 ndb-8.0.23)
id=3 @172.20.10.52 (mysql-8.0.23 ndb-8.0.23)

ndb_mgm> create nodegroup 6,7
* 763: Error
* 763-DDL is not supported with mixed data-node versions: Permanent error: Application error

Due to the error displayed, I had to downgrade all my data nodes and sql nodes to 8.0.20 and it worked!

Cluster Configuration
---------------------
[ndbd(NDB)] 4 node(s)
id=4 @172.20.10.54 (mysql-8.0.20 ndb-8.0.20, Nodegroup: 0, *)
id=5 @172.20.10.53 (mysql-8.0.20 ndb-8.0.20, Nodegroup: 0)
id=6 @172.20.10.104 (mysql-8.0.20 ndb-8.0.20, Nodegroup: 1)
id=7 @172.20.10.105 (mysql-8.0.20 ndb-8.0.20, Nodegroup: 1)

[ndb_mgmd(MGM)] 1 node(s)
id=1 @172.20.10.50 (mysql-8.0.23 ndb-8.0.23)

[mysqld(API)] 2 node(s)
id=2 @172.20.10.51 (mysql-8.0.23 ndb-8.0.23)
id=3 @172.20.10.52 (mysql-8.0.23 ndb-8.0.23)

I am still running the management node on 8.0.23, it seems to work fine.

I was also able to successfully import a database with 118 tables and 70MB of data. Another version of the same database with nearly 700MB of data failed to import due to redo logs running out of space. I am now trying different TimeBetweenLocalCheckpoints and NoOfFragmentLogFiles to make it work.

I know 8.0.23 version is the most recent and stable, but unfortunately it doesn't work for me. I am still testing this, hopefully I would be able to successfully test 8.0.23 before using this in production!

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Node 6: Forced node shutdown completed. Occurred during startphase 5. Caused by error 2341
341
March 09, 2021 06:39PM


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.