Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
13.1
-
Can result in hang or crash
Description
--source include/have_innodb.inc |
--source include/have_debug_sync.inc |
CREATE TABLE t1 (a INT PRIMARY KEY, b VARCHAR(10), FULLTEXT(b)) ENGINE=InnoDB; |
INSERT INTO t1 VALUES (1,'x'),(2,'x'),(3,'x'); |
SET DEBUG_SYNC='innodb_inplace_alter_table_enter SIGNAL ddl WAIT_FOR dml'; |
SET DEBUG_SYNC='lock_wait_start SIGNAL ddl_wait'; |
--send ALTER TABLE t1 ADD UNIQUE(b) |
--connect con1,localhost,root |
SET DEBUG_SYNC='now WAIT_FOR ddl'; |
SET DEBUG_SYNC='fts_instrument_sync_request SIGNAL dml WAIT_FOR go TIMEOUT 10'; |
--send UPDATE t1 SET b='y' WHERE a=1 |
--connect con2,localhost,root |
SET DEBUG_SYNC='now WAIT_FOR ddl_wait'; |
SET DEBUG_SYNC='lock_wait_start SIGNAL go'; |
DELETE FROM t1 WHERE a=2; |
--disconnect con2 |
--connection con1 |
--reap |
--disconnect con1 |
--connection default |
--error ER_DUP_ENTRY |
--reap |
SET DEBUG_SYNC='RESET'; |
DROP TABLE t1; |
Leads to:
|
CS 13.2.0 cf542109f3389838b4b688b78941797f6a95d51f (Debug, Clang 22.1.8-20260621) Build 12/10/2026 |
InnoDB: Failing assertion: !fts_lock_common_tables(ctx->trx, *ctx->new_table)
|
|
CS 13.2.0 cf542109f3389838b4b688b78941797f6a95d51f (Debug, Clang 22.1.8-20260621) Build 12/10/2026 |
Core was generated by `/test/MD121026-mariadb-13.2.0-linux-x86_64-dbg/bin/mariadbd --defaults-group-su'.
|
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 (LWP 3254008)]
|
(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 0x0000791e1724527e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
|
#4 0x0000791e172288ff in __GI_abort () at ./stdlib/abort.c:79
|
#5 0x000057beacdd5d6d in ut_dbg_assertion_failed (expr=0x57bead49f879 "!fts_lock_common_tables(ctx->trx, *ctx->new_table)", file=0x57bead49a516 "/test/13.1_dbg/storage/innobase/handler/handler0alter.cc", line=9261) at /test/13.1_dbg/storage/innobase/ut/ut0dbg.cc:60
|
#6 0x000057beacb6b675 in rollback_inplace_alter_table (ha_alter_info=0x791e14e8ebf8, table=0x711d2c0652f0, prebuilt=0x711d2c05fd08)at /test/13.1_dbg/storage/innobase/handler/handler0alter.cc:9261
|
#7 0x000057beacb580db in ha_innobase::commit_inplace_alter_table (this=0x711d2c0521e0, altered_table=0x791e14e8ef20, ha_alter_info=0x791e14e8ebf8, commit=false)at /test/13.1_dbg/storage/innobase/handler/handler0alter.cc:11306
|
#8 0x000057beac72ab60 in handler::ha_commit_inplace_alter_table (this=0x711d2c0521e0, altered_table=0x791e14e8ef20, ha_alter_info=0x791e14e8ebf8, commit=false)at /test/13.1_dbg/sql/handler.cc:6074
|
#9 0x000057beac429027 in mysql_inplace_alter_table (thd=0x711d2c000d60, table_list=0x711d2c017240, table=0x711d2c0652f0, altered_table=0x791e14e8ef20, ha_alter_info=0x791e14e8ebf8, target_mdl_request=0x791e14e90d10, ddl_log_state=0x791e14e8ee90, trigger_param=0x791e14e90900, alter_ctx=0x791e14e8fb88, partial_alter=@0x791e14e8ee5d: false, start_alter_id=@0x791e14e8ee50: 0, if_exists=false) at /test/13.1_dbg/sql/sql_table.cc:8834
|
#10 0x000057beac42164d in mysql_alter_table (thd=0x711d2c000d60, new_db=0x711d2c005c28, new_name=0x711d2c0060c0, create_info=0x791e14e91e00, table_list=0x711d2c017240, recreate_info=0x791e14e91508, alter_info=0x791e14e91c88, order_num=0, order=0x0, ignore=false, if_exists=false)at /test/13.1_dbg/sql/sql_table.cc:12170
|
#11 0x000057beac4e1c5b in Sql_cmd_alter_table::execute (this=0x711d2c017a90, thd=0x711d2c000d60) at /test/13.1_dbg/sql/sql_alter.cc:705
|
#12 0x000057beac3096ef in mysql_execute_command (thd=0x711d2c000d60, is_called_from_prepared_stmt=false) at /test/13.1_dbg/sql/sql_parse.cc:5947
|
#13 0x000057beac2fa738 in mysql_parse (thd=0x711d2c000d60, rawbuf=0x711d2c017130 "ALTER TABLE t1 ADD UNIQUE(b)", length=28, parser_state=0x791e14e939c0) at /test/13.1_dbg/sql/sql_parse.cc:8005
|
#14 0x000057beac2f7eee in dispatch_command (command=COM_QUERY, thd=0x711d2c000d60, packet=0x711d2c144d91 "ALTER TABLE t1 ADD UNIQUE(b)", packet_length=28, blocking=true) at /test/13.1_dbg/sql/sql_parse.cc:1903
|
#15 0x000057beac2fb1ba in do_command (thd=0x711d2c000d60, blocking=true)at /test/13.1_dbg/sql/sql_parse.cc:1437
|
#16 0x000057beac4d6f4e in do_handle_one_connection (connect=0x57bed49d49a0, put_in_cache=true) at /test/13.1_dbg/sql/sql_connect.cc:1514
|
#17 0x000057beac4d6d31 in handle_one_connection (arg=0x57bed49c1150)at /test/13.1_dbg/sql/sql_connect.cc:1426
|
#18 0x0000791e1729cb84 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
|
#19 0x0000791e17329ecc in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
|
|
Bug Detection Matrix |
Rel o/d Build Commit UniqueID observed
|
CS 10.11 dbg 121026 7aecfef1072045404167edaaba4656edf218a7a8 No bug found
|
CS 10.11 opt 121026 7aecfef1072045404167edaaba4656edf218a7a8 No bug found
|
CS 11.4 dbg 121026 fd85202eb2f866bac7117b5a4542b76f438e2780 No bug found
|
CS 11.4 opt 121026 fd85202eb2f866bac7117b5a4542b76f438e2780 No bug found
|
CS 11.8 dbg 121026 14362356d14b80242d60dceb9b34f988bbcc9945 No bug found
|
CS 11.8 opt 121026 14362356d14b80242d60dceb9b34f988bbcc9945 No bug found
|
CS 12.3 dbg 121026 5e1d303aa6acf34c09309a9d64d750f20fc1921d No bug found
|
CS 12.3 opt 121026 5e1d303aa6acf34c09309a9d64d750f20fc1921d No bug found
|
CS 13.0 dbg 121026 620a4b5624222048fece7fe1789978ae0675cae2 No bug found
|
CS 13.0 opt 121026 620a4b5624222048fece7fe1789978ae0675cae2 No bug found
|
CS 13.2 dbg 121026 cf542109f3389838b4b688b78941797f6a95d51f !fts_lock_common_tables(ctx->trx, *ctx->new_table)|SIGABRT|ut_dbg_assertion_failed|rollback_inplace_alter_table|ha_innobase::commit_inplace_alter_table|handler::ha_commit_inplace_alter_table
|
CS 13.2 opt 121026 cf542109f3389838b4b688b78941797f6a95d51f No bug found
|
ES 10.6 dbg 121026 4cdc4f0b741fd1a3cc3fc34c7dc197a5b12c65cc No bug found
|
ES 10.6 opt 121026 4cdc4f0b741fd1a3cc3fc34c7dc197a5b12c65cc No bug found
|
ES 11.4 dbg 121026 f1a52e7bb41922f37759b2d6a7d7dbd6b779dd40 No bug found
|
ES 11.4 opt 121026 f1a52e7bb41922f37759b2d6a7d7dbd6b779dd40 No bug found
|
ES 11.8 dbg 121026 2b449b705bc9223b003a05bed300873361e5e970 No bug found
|
ES 11.8 opt 121026 2b449b705bc9223b003a05bed300873361e5e970 No bug found
|
ES 12.3 dbg 121026 b09ac90250cf897f23f243954754ed88c57f4f31 No bug found
|
ES 12.3 opt 121026 b09ac90250cf897f23f243954754ed88c57f4f31 No bug found
|