MySQL Bugs: #114916: Hang in mysql NDB cluster

Bug #114916	Hang in mysql NDB cluster
Submitted:	8 May 1:28	Modified:	13 May 18:17
Reporter:	CunDi Fang	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Cluster: Cluster (NDB) storage engine	Severity:	S2 (Serious)
Version:	8.0.35-cluster MySQL Cluster Community S	OS:	Any
Assigned to:	MySQL Verification Team	CPU Architecture:	Any

Description:
Hello, I found a hang in an 8.0.35-cluster version of the MYSQL cluster. Behaves much like bug #114391
The details are as follows.

OS version and name:
Ubuntu 22.04.3 LTS (Jammy Jellyfish)
Linux eb1f47b08982 6.5.11-8-pve #1 SMP PREEMPT_DYNAMIC PMX 6.5.11-8 (2024-01-30T12:27Z) x86_64 x86_64 x86_64 GNU/Linux

I'm on a four-node cluster and control the input SQL sequence with a granular time control. I have synchronized the time of each machine beforehand so that I can plot the SQL execution sequence of each node by point in time. And it happened a hang in node 1.

How to repeat:
I will give you four SQL logs of each node and also the time when I input the SQL. Also, the database file and log files I saved after the hang happened will be given.

Suggested fix:
In my experience, the odds are that there is something wrong with the query optimization for the join clause, which is an old problem.

Architecture Information:
'''
[NDBD DEFAULT]
NoOfReplicas =2
DataMemory = 512M
IndexMemory = 64M

[NDB_MGMD]
NodeId=1
hostname =192.172.10.8
datadir =/var/lib/mysql-cluster

[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
'''

SQL log of node 1

Attachment: mysql ndb cluster-114916-1-sql.txt (text/plain), 1.71 KiB.

Duplicate of Bug #114464