Bug #114464 hang bug in mysql NDB cluster
Submitted: 23 Mar 10:57 Modified: 2 Apr 10:33
Reporter: CunDi Fang Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S3 (Non-critical)
Version:8.0.35-cluster MySQL Cluster Community S OS:Any (20.04)
Assigned to: CPU Architecture:Any

[23 Mar 10:57] CunDi Fang 
Description:
[NDBD]
NodeId =2
hostname =192.172.10.9
datadir =/usr/local/mysql-cluster/data
NodeGroup=0
[NDBD]
NodeId =3
hostname =192.172.10.10
datadir =/usr/local/mysql-cluster/data
NodeGroup=1
[NDBD]
NodeId =4
hostname =192.172.10.11
datadir =/usr/local/mysql-cluster/data
NodeGroup=0
[NDBD]
NodeId =5
hostname =192.172.10.12
datadir =/usr/local/mysql-cluster/data
NodeGroup=1

[mysqld]
NodeId =6
hostname =192.172.10.9
[mysqld]
NodeId =7
hostname =192.172.10.10
[mysqld]
NodeId =8
hostname =192.172.10.11
[mysqld]
NodeId =9
hostname =192.172.10.12
'''

Attempted and successfully reproduced!

How to repeat:
Simply execute that PoC to trigger it.

Suggested fix:
It seems to be a problem with the "optimiser" part, which seems like a dead loop, I suggest to check the code of that part. I can provide the database at that time if you need.
[23 Mar 10:57] CunDi Fang 
the sql which result hang.

Attachment: mysql ndb cluster-114464.txt (text/plain), 10.33 KiB.
[2 Apr 10:33] MySQL Verification Team 
Hi,

Thank you for the report. This really is not a query that is meant to be run on ndbcluster. If you want to run queries like this please use innodbcluster and not ndbcluster but anyhow this should not hang. Verified as described. Thanks
[15 Apr 12:52] MySQL Verification Team 
Bug #114391 is marked as duplicate of this one
[13 May 18:17] MySQL Verification Team 
Bug #114916 is marked as duplicate of this one (with more details to reproduce)