MySQL Forums
Forum List  »  NDB clusters

XA transaction causes Mysql crash in 8.0.34
Posted by: Raul Andres
Date: August 16, 2023 02:14AM

I have the following snippet:

# cat xacrash.sql
drop database if exists newdb;
create database newdb;
use newdb;
create table innodbtable(id int) engine=innodb;
xa begin 'innodbtx';
insert into innodbtable values(3);
xa end 'innodbtx';
xa prepare 'innodbtx';
xa commit 'innodbtx';
create table ndbtable(id int) engine=ndbcluster;
xa begin 'ndbtx';
insert into ndbtable values(3);
xa end 'ndbtx';
xa prepare 'ndbtx';
xa commit 'ndbtx';

When running against 8.0.28 works without problems, but crashes connection in 8.0.34

--------------
xa prepare 'ndbtx'
--------------

ERROR 2013 (HY000) at line 14: Lost connection to MySQL server during query

And writes a crash report

Aug 16 10:08:54 hostname mysqld[606104]: 2023-08-16T08:08:54Z UTC - mysqld got signal 11 ;
Aug 16 10:08:54 hostname mysqld[606104]: Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
Aug 16 10:08:54 hostname mysqld[606104]: BuildID[sha1]=a570f2d544031bf853200e0bb758215b0b317fb1
Aug 16 10:08:54 hostname mysqld[606104]: Thread pointer: 0x7fa758000fe0
Aug 16 10:08:54 hostname mysqld[606104]: Attempting backtrace. You can use the following information to find out
Aug 16 10:08:54 hostname mysqld[606104]: where mysqld died. If you see no messages after this, something went
Aug 16 10:08:54 hostname mysqld[606104]: terribly wrong...
Aug 16 10:08:54 hostname mysqld[606104]: stack_bottom = 7fa7b42edc10 thread_stack 0x100000
Aug 16 10:08:54 hostname mysqld[606104]: /usr/sbin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x41) [0x2131091]
Aug 16 10:08:54 hostname mysqld[606104]: /usr/sbin/mysqld(print_fatal_signal(int)+0x2a2) [0xfee7d2]
Aug 16 10:08:54 hostname mysqld[606104]: /usr/sbin/mysqld(handle_fatal_signal+0xa5) [0xfee985]
Aug 16 10:08:54 hostname mysqld[606104]: /lib64/libpthread.so.0(+0x12cf0) [0x7fa7dcabbcf0]
Aug 16 10:08:54 hostname mysqld[606104]: Trying to get some variables.
Aug 16 10:08:54 hostname mysqld[606104]: Some pointers may be invalid and cause the dump to abort.
Aug 16 10:08:54 hostname mysqld[606104]: Query (7fa7581af9c0): xa prepare 'ndbtx'
Aug 16 10:08:54 hostname mysqld[606104]: Connection ID (thread ID): 14
Aug 16 10:08:54 hostname mysqld[606104]: Status: NOT_KILLED
Aug 16 10:08:54 hostname mysqld[606104]: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
Aug 16 10:08:54 hostname mysqld[606104]: information that should help you find out what is causing the crash.


# rpm -qi mysql-cluster-community-server
Name : mysql-cluster-community-server
Version : 8.0.34
Release : 1.el8
Architecture: x86_64

Options: ReplyQuote


Subject
Views
Written By
Posted
XA transaction causes Mysql crash in 8.0.34
405
August 16, 2023 02:14AM


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.