Re: Node 6: Forced node shutdown completed. Occurred during startphase 5. Caused by error 2341

[Pradeep Manickam]

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!