Bug #114773 lost connection in MySQL NDB cluster
| Submitted: | 25 Apr 2024 6:13 | Modified: | 25 Apr 2024 12:13 |
|---|---|---|---|
| Reporter: | CunDi Fang | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Cluster: Cluster (NDB) storage engine | Severity: | S2 (Serious) |
| Version: | 8.0.35-cluster MySQL Cluster Community S | OS: | Any (20.04) |
| Assigned to: | Assigned Account | CPU Architecture: | Any |
[25 Apr 2024 12:13]
MySQL Verification Team
Hi, This is again the same underlying issue as 114464. We do not mind multiple submissions but please upload ndb_error_reporter output or collect all the logs from all the nodes, zip to a file and upload to the issue. Duplicate of Bug #114464
[25 Apr 2024 12:15]
MySQL Verification Team
Please use ndb_error_reporter to collect all the required log files https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-error-reporter.html Duplicate of Bug #114464
[26 Apr 2024 20:51]
MySQL Verification Team
Hi, Yes, thanks, ndb_error_report log file help us solve this. Even as all these are duplicates from same underlying condition, multiple log files help us solve the issue faster.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.058 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
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.
Description: Hello, I found a bug in 8.0.35-cluster version of MYSQL cluster. It will cause the current mysql service to crash. The detail is as follow. 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 Poc: ``` delete from mytest90.test9 where EXISTS ( select ref_0.column1 as c0, (select node_id from ndbinfo.cpuinfo limit 1 offset 6) as c1, subq_0.c1 as c2, ref_0.column2 as c3, case when (false) or (false) then 21 else 21 end as c4 from mytest90.test1 as ref_0 right join (select (select mysql_version from sys.version limit 1 offset 48) as c0, ref_1.column6 as c1, (select LOCK_DATA from performance_schema.data_locks limit 1 offset 4) as c2, mytest90.test9.column5 as c3, ref_1.column4 as c4, ref_1.column5 as c5 from mytest90.test4 as ref_1 where ref_1.column6 is NULL) as subq_0 on (false) where (true) and ((true) or ((mytest90.test9.column8 is not NULL) and ((false) or ((mytest90.test9.column10 is not NULL) or ((true) and (EXISTS ( select subq_0.c2 as c0, subq_0.c2 as c1, ref_0.column2 as c2, ref_2.column1 as c3 from mytest90.test3 as ref_2 where subq_0.c1 is NULL limit 150))))))) limit 120); ``` It manifests itself in this way: ``` ERROR 2013 (HY000): Lost connection to MySQL server during query No connection. Trying to reconnect... ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/usr/local/mysql-cluster/sock/mysql.sock' (111) ERROR: Can't connect to the server ``` 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 ''' Attempted and successfully reproduced! How to repeat: Importing the database file I give later, and then executing Poc Suggested fix: I'm not sure why this issue is occurring, but since there are multiple layers of nested queries and EXISTS clauses involved, it may be that there is a problem with the synchronization process?