Ramesh Sivaraman added a comment - 2025-02-13 09:37 CS 11.4.6 ef966af801afc2a07222b5df65dddd52c77431dd (Debug) Build 13/02/2025 mariadbd: /test/11.4_dbg/storage/innobase/handler/ha_innodb.cc:4598: int innobase_commit(handlerton*, THD*, bool): Assertion `commit_trx || trx->is_wsrep()' failed. CS 11.4.6 ef966af801afc2a07222b5df65dddd52c77431dd (Debug) Build 13/02/2025 Core was generated by `/test/MD130225-mariadb-11.4.6-linux-x86_64-dbg/bin/mariadbd --no-defaults --max'. Program terminated with signal SIGABRT, Aborted. #0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44   [Current thread is 1 (Thread 0x14e1ce0b76c0 (LWP 3864801))] (gdb) bt #0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44 #1 __pthread_kill_internal (signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:78 #2 __GI___pthread_kill (threadid=<optimized out>, signo=signo@entry=6)at ./nptl/pthread_kill.c:89 #3 0x000014e1d524527e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26 #4 0x000014e1d52288ff in __GI_abort () at ./stdlib/abort.c:79 #5 0x000014e1d522881b in __assert_fail_base (fmt=0x14e1d53d01e8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x55a1fb80f2b3 "commit_trx || trx->is_wsrep()", file=file@entry=0x55a1fb706cf0 "/test/11.4_dbg/storage/innobase/handler/ha_innodb.cc", line=line@entry=4598, function=function@entry=0x55a1fb70ccf8 "int innobase_commit(handlerton*, THD*, bool)") at ./assert/assert.c:96 #6 0x000014e1d523b517 in __assert_fail (assertion=0x55a1fb80f2b3 "commit_trx || trx->is_wsrep()", file=0x55a1fb706cf0 "/test/11.4_dbg/storage/innobase/handler/ha_innodb.cc", line=4598, function=0x55a1fb70ccf8 "int innobase_commit(handlerton*, THD*, bool)")at ./assert/assert.c:105 #7 0x000055a1fb14c8e4 in innobase_commit (hton=<optimized out>, thd=0x14e16c000d58, commit_trx=false)at /test/11.4_dbg/storage/innobase/handler/ha_innodb.cc:4598 #8 0x000055a1faedac59 in commit_one_phase_2 (thd=thd@entry=0x14e16c000d58, all=all@entry=false, trans=trans@entry=0x14e16c004860, is_real_trans=is_real_trans@entry=true)at /test/11.4_dbg/sql/handler.cc:2198 #9 0x000055a1faee71af in ha_commit_trans (thd=thd@entry=0x14e16c000d58, all=all@entry=false) at /test/11.4_dbg/sql/handler.cc:2016 #10 0x000055a1fad8ecf8 in trans_commit_stmt (thd=0x14e16c000d58)at /test/11.4_dbg/sql/transaction.cc:501 #11 0x000055a1fac13ad2 in select_create::send_eof (this=0x14e16c01b400)at /test/11.4_dbg/sql/sql_insert.cc:5266 #12 0x000055a1facbe591 in JOIN::exec_inner (this=this@entry=0x14e16c01b540)at /test/11.4_dbg/sql/sql_select.cc:4930 #13 0x000055a1facbea6c in JOIN::exec (this=this@entry=0x14e16c01b540)at /test/11.4_dbg/sql/sql_select.cc:4831 #14 0x000055a1facbd75c in mysql_select (thd=thd@entry=0x14e16c000d58, tables=0x0, fields=@0x14e16c01a718: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14e16c01a9b0, last = 0x14e16c01a9b0, elements = 1}, <No data fields>}, conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2201187519232, result=0x14e16c01b400, unit=0x14e16c005000, select_lex=0x14e16c01a460) at /test/11.4_dbg/sql/sql_select.cc:5361 #15 0x000055a1facbdad8 in handle_select (thd=thd@entry=0x14e16c000d58, lex=lex@entry=0x14e16c004f20, result=result@entry=0x14e16c01b400, setup_tables_done_option=setup_tables_done_option@entry=0)at /test/11.4_dbg/sql/sql_select.cc:642 #16 0x000055a1fad0c198 in Sql_cmd_create_table_like::execute (this=<optimized out>, thd=0x14e16c000d58)at /test/11.4_dbg/sql/sql_table.cc:13366 #17 0x000055a1fac4c3ce in mysql_execute_command (thd=thd@entry=0x14e16c000d58, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false)at /test/11.4_dbg/sql/sql_parse.cc:5878 #18 0x000055a1fac4cf41 in mysql_parse (thd=thd@entry=0x14e16c000d58, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x14e1ce0b62f0)at /test/11.4_dbg/sql/sql_parse.cc:7907 #19 0x000055a1fac4e563 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x14e16c000d58, packet=packet@entry=0x14e16c00b159 "CREATE TABLE t AS SELECT 0", packet_length=packet_length@entry=26, blocking=blocking@entry=true)at /test/11.4_dbg/sql/sql_parse.cc:1904 #20 0x000055a1fac4fa37 in do_command (thd=thd@entry=0x14e16c000d58, blocking=blocking@entry=true) at /test/11.4_dbg/sql/sql_parse.cc:1417 #21 0x000055a1fad7d487 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55a215525b38, put_in_cache=put_in_cache@entry=true)at /test/11.4_dbg/sql/sql_connect.cc:1408 #22 0x000055a1fad7d6ac in handle_one_connection (arg=0x55a215525b38)at /test/11.4_dbg/sql/sql_connect.cc:1320 #23 0x000014e1d529caa4 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447 #24 0x000014e1d5329c3c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78

Elena Stepanova added a comment - 2025-02-20 23:43 - edited The failure started happening after the commit below in 10.6.21, but since it's the commit which added the assertion, it remains unclear whether it's a genuine regression. Still, it needs to be fixed, as rocksdb_rpl.mdev12179 started failing on the same assertions. It isn't run in buildbots on debug builds, but it is in Jenkins. commit ddd7d5d8e34c3edd7ebf4790eec2c4e4d9141e94 Author: Marko Mäkelä Date: Thu Dec 12 18:02:00 2024 +0200   MDEV-24035 Failing assertion: UT_LIST_GET_LEN(lock.trx_locks) == 0 causing disruption and replication failure

Marko Mäkelä added a comment - 2025-03-04 11:58 This test case will be fixed by cherry-picking this change that serg had pushed only to a later version branch.