Details
-
Bug
-
Status: Open (View Workflow)
-
Critical
-
Resolution: Unresolved
-
12.2, 12.3
-
Can result in hang or crash
Description
# mysqld options required for replay: --log-bin |
SET sql_mode=''; |
CREATE TEMPORARY TABLE t ENGINE=MyISAM AS SELECT @a AS c; |
INSERT INTO t VALUES (0xABB0); |
SET autocommit=OFF; |
CREATE TABLE t (c INT PRIMARY KEY) ENGINE=MyISAM SELECT * FROM t FOR UPDATE; |
Leads to:
|
CS 12.3.0 fa36b269f139252b81d4384fbed07b167855cabb (Debug, Clang 21.1.3-20250923) Build 05/02/2026 |
mariadbd: /test/12.3_dbg/sql/sql_base.cc:999: int close_thread_tables(THD *): Assertion `(thd->state_flags & Open_tables_state::BACKUPS_AVAIL) || !thd->has_pending_row_events()' failed.
|
|
CS 12.3.0 fa36b269f139252b81d4384fbed07b167855cabb (Debug, Clang 21.1.3-20250923) Build 05/02/2026 |
Core was generated by `/test/MD050226-mariadb-12.3.0-linux-x86_64-dbg/bin/mariadbd --no-defaults --max'.
|
Program terminated with signal SIGABRT, Aborted.
|
Download failed: Invalid argument. Continuing without source file ./nptl/./nptl/pthread_kill.c.
|
#0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
|
 |
[Current thread is 1 (LWP 160556)]
|
(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 0x000074ad93e4526e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
|
#4 0x000074ad93e288ff in __GI_abort () at ./stdlib/abort.c:79
|
#5 0x000074ad93e2881b in __assert_fail_base (fmt=0x74ad93fd01e8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x6522166679e3 "(thd->state_flags & Open_tables_state::BACKUPS_AVAIL) || !thd->has_pending_row_events()", file=file@entry=0x6522164c98c1 "/test/12.3_dbg/sql/sql_base.cc", line=line@entry=999, function=function@entry=0x65221651ed26 "int close_thread_tables(THD *)")at ./assert/assert.c:94
|
#6 0x000074ad93e3b507 in __assert_fail (assertion=0x6522166679e3 "(thd->state_flags & Open_tables_state::BACKUPS_AVAIL) || !thd->has_pending_row_events()", file=0x6522164c98c1 "/test/12.3_dbg/sql/sql_base.cc", line=999, function=0x65221651ed26 "int close_thread_tables(THD *)")at ./assert/assert.c:103
|
#7 0x00006522170900ad in close_thread_tables (thd=0x74ac48000d58)at /test/12.3_dbg/sql/sql_base.cc:998
|
#8 0x000065221708fb4d in close_thread_tables_for_query (thd=0x74ac48000d58)at /test/12.3_dbg/sql/sql_base.cc:821
|
#9 0x00006522171fbd5e in mysql_execute_command (thd=0x74ac48000d58, is_called_from_prepared_stmt=false) at /test/12.3_dbg/sql/sql_parse.cc:6003
|
#10 0x00006522171eca58 in mysql_parse (thd=0x74ac48000d58, rawbuf=0x74ac48019f80 "CREATE TABLE t (c INT PRIMARY KEY) ENGINE=MyISAM SELECT * FROM t FOR UPDATE", length=75, parser_state=0x74ad8bfb2a00)at /test/12.3_dbg/sql/sql_parse.cc:7950
|
#11 0x00006522171ea20e in dispatch_command (command=COM_QUERY, thd=0x74ac48000d58, packet=0x74ac4800b2d9 "CREATE TABLE t (c INT PRIMARY KEY) ENGINE=MyISAM SELECT * FROM t FOR UPDATE", packet_length=75, blocking=true)at /test/12.3_dbg/sql/sql_parse.cc:1896
|
#12 0x00006522171ed4da in do_command (thd=0x74ac48000d58, blocking=true)at /test/12.3_dbg/sql/sql_parse.cc:1432
|
#13 0x00006522173e542e in do_handle_one_connection (connect=0x65221a63c338, put_in_cache=true) at /test/12.3_dbg/sql/sql_connect.cc:1503
|
#14 0x00006522173e5211 in handle_one_connection (arg=0x65221a56fc18)at /test/12.3_dbg/sql/sql_connect.cc:1415
|
#15 0x000074ad93e9ca94 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
|
#16 0x000074ad93f29c3c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
|
|
Bug Detection Matrix |
Rel o/d Build Commit UniqueID observed
|
CS 10.6 dbg 230126 cd02709a315c9f08965d6b8fb7e75baaae17a4f4 No bug found
|
CS 10.6 opt 230126 cd02709a315c9f08965d6b8fb7e75baaae17a4f4 No bug found
|
CS 10.11 dbg 230126 b061b5ab1f2cd2a6993e53dc24a865304ced14cd No bug found
|
CS 10.11 opt 230126 b061b5ab1f2cd2a6993e53dc24a865304ced14cd No bug found
|
CS 11.4 dbg 260126 b6d0e23d76fe5936b6a29379ab494852e4d493b1 No bug found
|
CS 11.4 opt 260126 b6d0e23d76fe5936b6a29379ab494852e4d493b1 No bug found
|
CS 11.8 dbg 230126 01ff5ae6b677bead4c41d91bf5afb25c593a1d02 No bug found
|
CS 11.8 opt 230126 01ff5ae6b677bead4c41d91bf5afb25c593a1d02 No bug found
|
CS 12.2 dbg 230126 6ca70dd64ce56da40fad3bcd0641493210dd0a4c (thd->state_flags & Open_tables_state::BACKUPS_AVAIL) || !thd->has_pending_row_events()|SIGABRT|close_thread_tables|close_thread_tables_for_query|mysql_execute_command|mysql_parse
|
CS 12.2 opt 230126 6ca70dd64ce56da40fad3bcd0641493210dd0a4c No bug found
|
CS 12.3 dbg 050226 fa36b269f139252b81d4384fbed07b167855cabb (thd->state_flags & Open_tables_state::BACKUPS_AVAIL) || !thd->has_pending_row_events()|SIGABRT|close_thread_tables|close_thread_tables_for_query|mysql_execute_command|mysql_parse
|
CS 12.3 opt 050226 fa36b269f139252b81d4384fbed07b167855cabb No bug found
|
ES 10.6 dbg 230126 0fe345fff3a0463224ca714831303d40fb83648b No bug found
|
ES 10.6 opt 230126 0fe345fff3a0463224ca714831303d40fb83648b No bug found
|
ES 11.4 dbg 230126 34f616d5fd2c649d0c79acb4e2423c90b8f10436 No bug found
|
ES 11.4 opt 230126 34f616d5fd2c649d0c79acb4e2423c90b8f10436 No bug found
|
ES 11.8 dbg 230126 405ee76b60c4ab82155f339136ed20d3b7363717 No bug found
|
ES 11.8 opt 230126 405ee76b60c4ab82155f339136ed20d3b7363717 No bug found
|
MS 5.5 dbg 070123 bac287c315b1792e7ae33f91add6a60292f9bae8 No bug found
|
MS 5.5 opt 070123 bac287c315b1792e7ae33f91add6a60292f9bae8 No bug found
|
MS 5.6 dbg 070123 dab95781a1244104d6b87020ac2fc4d190ba2946 No bug found
|
MS 5.6 opt 070123 dab95781a1244104d6b87020ac2fc4d190ba2946 No bug found
|
MS 5.7 dbg 070525 f7680e98b6bbe3500399fbad465d08a6b75d7a5c No bug found
|
MS 5.7 opt 070525 f7680e98b6bbe3500399fbad465d08a6b75d7a5c No bug found
|
MS 8.0 dbg 060224 49ef33f7edadef3ae04665e73d1babd40179a4f1 No bug found
|
MS 8.0 opt 060224 49ef33f7edadef3ae04665e73d1babd40179a4f1 No bug found
|
MS 9.1 dbg 211024 61a3a1d8ef15512396b4c2af46e922a19bf2b174 No bug found
|
MS 9.1 opt 211024 61a3a1d8ef15512396b4c2af46e922a19bf2b174 No bug found
|