[MDEV-30029] Assertion `transaction_.active() == false' failed in virtual wsrep::client_state::~client_state() Created: 2022-11-18  Updated: 2023-04-11

Status: Open
Project: MariaDB Server
Component/s: Galera
Affects Version/s: 10.4, 10.5, 10.6
Fix Version/s: 10.4, 10.5, 10.6

Type: Bug Priority: Major
Reporter: Ramesh Sivaraman Assignee: Daniele Sciascia
Resolution: Unresolved Votes: 0
Labels: not-10.3, not-10.7, not-10.8, not-10.9


 Description   

SET GLOBAL wsrep_on=OFF;
SET max_session_mem_used = 50000;
XA START 'a';
CREATE TEMPORARY TABLE t1(a INT) engine=innodb;
SET @@session.query_prealloc_size = 30;
LOAD INDEX INTO CACHE t1;
SET GLOBAL wsrep_on = TRUE;
INSERT INTO t1 VALUES(1);
SHUTDOWN;

Leads to:

10.6.12 c4ce012e4b3dac44e76598a5d1f2fe92f836eb30 (Optimized)

mysqld: /test/10.6_opt/wsrep-lib/include/wsrep/client_state.hpp:169: virtual wsrep::client_state::~client_state(): Assertion `transaction_.active() == false' failed.

10.6.12 c4ce012e4b3dac44e76598a5d1f2fe92f836eb30 (Optimized)

Core was generated by `/test/GAL_MD081122-mariadb-10.6.12-linux-x86_64-opt/bin/mysqld --defaults-file='.
Program terminated with signal SIGABRT, Aborted.
#0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6)
    at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
[Current thread is 1 (Thread 0x14bf4cebe700 (LWP 898177))]
(gdb) bt
#0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
#1  0x0000561aa705138f in my_write_core (sig=sig@entry=6) at /test/10.6_opt/mysys/stacktrace.c:424
#2  0x0000561aa6b87780 in handle_fatal_signal (sig=6) at /test/10.6_opt/sql/signal_handler.cc:355
#3  <signal handler called>
#4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
#5  0x000014bf82eb6859 in __GI_abort () at abort.c:79
#6  0x000014bf82eb6729 in __assert_fail_base (fmt=0x14bf8304c588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x561aa71f1bf0 "transaction_.active() == false", file=0x561aa71f1bb8 "/test/10.6_opt/wsrep-lib/include/wsrep/client_state.hpp", line=169, function=<optimized out>) at assert.c:92
#7  0x000014bf82ec7fd6 in __GI___assert_fail (assertion=assertion@entry=0x561aa71f1bf0 "transaction_.active() == false", file=file@entry=0x561aa71f1bb8 "/test/10.6_opt/wsrep-lib/include/wsrep/client_state.hpp", line=line@entry=169, function=function@entry=0x561aa71f1b88 "virtual wsrep::client_state::~client_state()") at assert.c:101
#8  0x0000561aa69166ba in wsrep::client_state::~client_state (this=0x14bf0c006f18, __in_chrg=<optimized out>) at /test/10.6_opt/sql/sql_string.h:231
#9  Wsrep_client_state::~Wsrep_client_state (this=0x14bf0c006f18, __in_chrg=<optimized out>) at /test/10.6_opt/sql/wsrep_client_state.h:25
#10 THD::~THD (this=0x14bf0c000c58, __in_chrg=<optimized out>) at /test/10.6_opt/sql/sql_class.cc:1668
#11 0x0000561aa69166f6 in THD::~THD (this=0x14bf0c000c58, __in_chrg=<optimized out>) at /test/10.6_opt/sql/sql_class.cc:1668
#12 0x0000561aa6a6cecd in do_handle_one_connection (connect=<optimized out>, connect@entry=0x561aa88d73f8, put_in_cache=put_in_cache@entry=true) at /test/10.6_opt/sql/sql_connect.cc:1457
#13 0x0000561aa6a6d03d in handle_one_connection (arg=0x561aa88d73f8) at /test/10.6_opt/sql/sql_connect.cc:1318
#14 0x000014bf833c7609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#15 0x000014bf82fb3133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

10.5.19 fe330b63fe4ee51a26ac6e222d8eb4ee44a73d50 (Optimized)

mysqld: /test/10.5_opt/wsrep-lib/include/wsrep/client_state.hpp:169: virtual wsrep::client_state::~client_state(): Assertion `transaction_.active() == false' failed.

10.5.19 fe330b63fe4ee51a26ac6e222d8eb4ee44a73d50 (Optimized)

Core was generated by `/test/GAL_MD081122-mariadb-10.5.19-linux-x86_64-opt/bin/mysqld --defaults-file='.
Program terminated with signal SIGABRT, Aborted.
#0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6)
    at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
[Current thread is 1 (Thread 0x14cd5a390700 (LWP 4137690))]
(gdb) bt
#0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
#1  0x0000562676118b4f in my_write_core (sig=sig@entry=6) at /test/10.5_opt/mysys/stacktrace.c:424
#2  0x0000562675bee0e0 in handle_fatal_signal (sig=6) at /test/10.5_opt/sql/signal_handler.cc:354
#3  <signal handler called>
#4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
#5  0x000014cd9079d859 in __GI_abort () at abort.c:79
#6  0x000014cd9079d729 in __assert_fail_base (fmt=0x14cd90933588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x5626762b85d8 "transaction_.active() == false", file=0x5626762b7fe0 "/test/10.5_opt/wsrep-lib/include/wsrep/client_state.hpp", line=169, function=<optimized out>) at assert.c:92
#7  0x000014cd907aefd6 in __GI___assert_fail (assertion=assertion@entry=0x5626762b85d8 "transaction_.active() == false", file=file@entry=0x5626762b7fe0 "/test/10.5_opt/wsrep-lib/include/wsrep/client_state.hpp", line=line@entry=169, function=function@entry=0x5626762b85a8 "virtual wsrep::client_state::~client_state()") at assert.c:101
#8  0x00005626759a1b9a in wsrep::client_state::~client_state (this=0x14cd10006cd8, __in_chrg=<optimized out>) at /test/10.5_opt/sql/sql_string.h:641
#9  Wsrep_client_state::~Wsrep_client_state (this=0x14cd10006cd8, __in_chrg=<optimized out>) at /test/10.5_opt/sql/wsrep_client_state.h:25
#10 THD::~THD (this=0x14cd10000c58, __in_chrg=<optimized out>) at /test/10.5_opt/sql/sql_class.cc:1663
#11 0x00005626759a1bd6 in THD::~THD (this=0x14cd10000c58, __in_chrg=<optimized out>) at /test/10.5_opt/sql/sql_class.cc:1663
#12 0x0000562675aec2cd in do_handle_one_connection (connect=<optimized out>, connect@entry=0x5626782d8b98, put_in_cache=put_in_cache@entry=true) at /test/10.5_opt/sql/sql_connect.cc:1457
#13 0x0000562675aec43d in handle_one_connection (arg=0x5626782d8b98) at /test/10.5_opt/sql/sql_connect.cc:1318
#14 0x000014cd90cae609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#15 0x000014cd9089a133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Bug confirmed present in:
MariaDB: 10.4.28 (dbg), 10.4.28 (opt), 10.5.19 (dbg), 10.5.19 (opt), 10.6.12 (dbg), 10.6.12 (opt)

Bug (or feature/syntax) confirmed not present in:
MariaDB: 10.3.38 (dbg), 10.3.38 (opt), 10.7.8 (dbg), 10.7.8 (opt), 10.8.7 (dbg), 10.8.7 (opt), 10.9.5 (dbg), 10.9.5 (opt), 10.10.3 (dbg), 10.10.3 (opt), 10.11.1 (dbg), 10.11.1 (opt)


Generated at Thu Feb 08 10:13:06 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.