Details
-
Bug
-
Status: Open (View Workflow)
-
Critical
-
Resolution: Unresolved
-
12.3, 13.0, 13.1
-
Can result in hang or crash
Description
--source include/have_innodb.inc
|
--source include/have_partition.inc
|
CREATE TABLE t1 (c1 INT)Engine=InnoDB PARTITION BY HASH(c1) PARTITIONS 2; |
SET GLOBAL innodb_default_row_format=REDUNDANT; |
ALTER TABLE t1 COALESCE PARTITION 1; |
SET GLOBAL innodb_default_row_format=DYNAMIC; |
ALTER TABLE t1 PAGE_COMPRESSED=1; |
Leads to:
|
CS 12.3.3 add63991988734383c5e942de2a19c6c45f511f7 (Optimized, Clang 22.1.8-20260621) Build 21/08/2026 |
InnoDB: Failing assertion: dict_tf2_is_valid(flags, flags2)
|
|
CS 12.3.3 add63991988734383c5e942de2a19c6c45f511f7 (Optimized, Clang 22.1.8-20260621) Build 21/08/2026 |
Core was generated by `/test/MD210826-mariadb-12.3.3-linux-x86_64-opt/bin/mariadbd --no-defaults --loo'.
|
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 3939444)]
|
(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 0x0000704a11a4527e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
|
#4 0x0000704a11a288ff in __GI_abort () at ./stdlib/abort.c:79
|
#5 0x00005b56bb9c946c in ut_dbg_assertion_failed (expr=0x5b56bc562b0a "dict_tf2_is_valid(flags, flags2)", file=0x5b56bc562b2b "/test/12.3_opt/storage/innobase/dict/dict0mem.cc", line=131) at /test/12.3_opt/storage/innobase/ut/ut0dbg.cc:60
|
#6 0x00005b56bc1bf2ed in dict_table_t::create (name=<optimized out>, space=<optimized out>, n_cols=<optimized out>, n_v_cols=0, flags=1664, flags2=80) at /test/12.3_opt/storage/innobase/dict/dict0mem.cc:131
|
#7 0x00005b56bc09d41a in prepare_inplace_alter_table_dict (ha_alter_info=ha_alter_info@entry=0x7049e3e74150, altered_table=altered_table@entry=0x7049e3e74300, old_table=0x68491802e1a0, old_opt=0x684918025ac0, table_name=0x684918022085 "t1", flags=1664, flags2=0, fts_doc_id_col=18446744073709551615, add_fts_doc_id=false, add_fts_doc_id_idx=false)at /test/12.3_opt/storage/innobase/handler/handler0alter.cc:6783
|
#8 0x00005b56bc099b78 in ha_innobase::prepare_inplace_alter_table (this=0x6849180244a0, altered_table=0x7049e3e74300, ha_alter_info=0x7049e3e74150)at /test/12.3_opt/storage/innobase/handler/handler0alter.cc:8756
|
#9 0x00005b56bbfe79d0 in ha_partition::prepare_inplace_alter_table (this=0x684918023b90, altered_table=0x7049e3e74300, ha_alter_info=0x7049e3e74150) at /test/12.3_opt/sql/ha_partition.cc:10946
|
#10 0x00005b56bbbe1e21 in mysql_inplace_alter_table (thd=thd@entry=0x684918000c70, table_list=0x684918017c70, table=table@entry=0x68491802e1a0, altered_table=altered_table@entry=0x7049e3e74300, ha_alter_info=ha_alter_info@entry=0x7049e3e74150, target_mdl_request=<optimized out>, ddl_log_state=ddl_log_state@entry=0x7049e3e74260, trigger_param=0x7049e3e75930, alter_ctx=0x7049e3e74c08, partial_alter=@0x7049e3e742ea: false, start_alter_id=@0x7049e3e742a8: 0, if_exists=<optimized out>) at /test/12.3_opt/sql/sql_table.cc:8303
|
#11 0x00005b56bbbddc3e in mysql_alter_table (thd=thd@entry=0x684918000c70, new_db=new_db@entry=0x684918005ae0, new_name=new_name@entry=0x684918005f58, create_info=create_info@entry=0x7049e3e76ca8, table_list=0x684918017c70, recreate_info=recreate_info@entry=0x7049e3e763e0, alter_info=0x7049e3e76b30, order_num=0, order=0x0, ignore=<optimized out>, if_exists=<optimized out>) at /test/12.3_opt/sql/sql_table.cc:11864
|
#12 0x00005b56bbc52583 in Sql_cmd_alter_table::execute (this=<optimized out>, thd=0x684918000c70) at /test/12.3_opt/sql/sql_alter.cc:705
|
#13 0x00005b56bbb28c10 in mysql_execute_command (thd=thd@entry=0x684918000c70, is_called_from_prepared_stmt=false) at /test/12.3_opt/sql/sql_parse.cc:5908
|
#14 0x00005b56bbb244bd in mysql_parse (thd=thd@entry=0x684918000c70, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7049e3e774f0)at /test/12.3_opt/sql/sql_parse.cc:7945
|
#15 0x00005b56bbb22c8f in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x684918000c70, packet=packet@entry=0x684918008d81 "ALTER TABLE t1 PAGE_COMPRESSED=1", packet_length=packet_length@entry=32, blocking=true)at /test/12.3_opt/sql/sql_parse.cc:1903
|
#16 0x00005b56bbb24940 in do_command (thd=thd@entry=0x684918000c70, blocking=true) at /test/12.3_opt/sql/sql_parse.cc:1437
|
#17 0x00005b56bbc4be6d in do_handle_one_connection (connect=<optimized out>, connect@entry=0x5b56c3da7460, put_in_cache=true)at /test/12.3_opt/sql/sql_connect.cc:1514
|
#18 0x00005b56bbc4bca2 in handle_one_connection (arg=arg@entry=0x5b56c3da7460)at /test/12.3_opt/sql/sql_connect.cc:1426
|
#19 0x00005b56bbfeca63 in pfs_spawn_thread (arg=0x5b56c3dc7b20)at /test/12.3_opt/storage/perfschema/pfs.cc:2198
|
#20 0x0000704a11a9cb84 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
|
#21 0x0000704a11b29d6c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
|
|
CS 12.3.3 add63991988734383c5e942de2a19c6c45f511f7 (Debug, Clang 22.1.8-20260621) Build 21/08/2026 |
InnoDB: Failing assertion: dict_tf2_is_valid(flags, flags2)
|
|
CS 12.3.3 add63991988734383c5e942de2a19c6c45f511f7 (Debug, Clang 22.1.8-20260621) Build 21/08/2026 |
Core was generated by `/test/MD210826-mariadb-12.3.3-linux-x86_64-dbg/bin/mariadbd --no-defaults --loo'.
|
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 3940301)]
|
(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 0x00007bd56564527e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
|
#4 0x00007bd5656288ff in __GI_abort () at ./stdlib/abort.c:79
|
#5 0x0000618a9d263ebd in ut_dbg_assertion_failed (expr=0x618a9d96d751 "dict_tf2_is_valid(flags, flags2)", file=0x618a9d96d772 "/test/12.3_dbg/storage/innobase/dict/dict0mem.cc", line=131) at /test/12.3_dbg/storage/innobase/ut/ut0dbg.cc:60
|
#6 0x0000618a9d32e6ed in dict_table_t::create (name=@0x7bd53f87aa08: {data_ = 0x73d44c04c9c8 "test/#sql-alter-3c1b1f-4-1#P#p0", size_ = 31}, space=0x0, n_cols=1, n_v_cols=0, flags=1664, flags2=80)at /test/12.3_dbg/storage/innobase/dict/dict0mem.cc:131
|
#7 0x0000618a9d00207d in prepare_inplace_alter_table_dict (ha_alter_info=0x7bd53f87cc08, altered_table=0x7bd53f87cf30, old_table=0x73d44c02d110, old_opt=0x73d44c0375a0, table_name=0x73d44c02af95 "t1", flags=1664, flags2=80, fts_doc_id_col=18446744073709551615, add_fts_doc_id=false, add_fts_doc_id_idx=false)at /test/12.3_dbg/storage/innobase/handler/handler0alter.cc:6783
|
#8 0x0000618a9cffd55f in ha_innobase::prepare_inplace_alter_table (this=0x73d44c035f60, altered_table=0x7bd53f87cf30, ha_alter_info=0x7bd53f87cc08)at /test/12.3_dbg/storage/innobase/handler/handler0alter.cc:8756
|
#9 0x0000618a9cbe7231 in handler::ha_prepare_inplace_alter_table (this=0x73d44c035f60, altered_table=0x7bd53f87cf30, ha_alter_info=0x7bd53f87cc08) at /test/12.3_dbg/sql/handler.cc:6003
|
#10 0x0000618a9cf4d334 in ha_partition::prepare_inplace_alter_table (this=0x73d44c035650, altered_table=0x7bd53f87cf30, ha_alter_info=0x7bd53f87cc08) at /test/12.3_dbg/sql/ha_partition.cc:10946
|
#11 0x0000618a9cbe7231 in handler::ha_prepare_inplace_alter_table (this=0x73d44c035650, altered_table=0x7bd53f87cf30, ha_alter_info=0x7bd53f87cc08) at /test/12.3_dbg/sql/handler.cc:6003
|
#12 0x0000618a9c8f4898 in mysql_inplace_alter_table (thd=0x73d44c000d60, table_list=0x73d44c01a4d0, table=0x73d44c02d110, altered_table=0x7bd53f87cf30, ha_alter_info=0x7bd53f87cc08, target_mdl_request=0x7bd53f87eec0, ddl_log_state=0x7bd53f87cea0, trigger_param=0x7bd53f87eac0, alter_ctx=0x7bd53f87dd48, partial_alter=@0x7bd53f87ce6d: false, start_alter_id=@0x7bd53f87ce60: 0, if_exists=false) at /test/12.3_dbg/sql/sql_table.cc:8303
|
#13 0x0000618a9c8ed934 in mysql_alter_table (thd=0x73d44c000d60, new_db=0x73d44c005ba8, new_name=0x73d44c006020, create_info=0x7bd53f87ff90, table_list=0x73d44c01a4d0, recreate_info=0x7bd53f87f6a8, alter_info=0x7bd53f87fe18, order_num=0, order=0x0, ignore=false, if_exists=false)at /test/12.3_dbg/sql/sql_table.cc:11864
|
#14 0x0000618a9c9ad0ec in Sql_cmd_alter_table::execute (this=0x73d44c01acb0, thd=0x73d44c000d60) at /test/12.3_dbg/sql/sql_alter.cc:705
|
#15 0x0000618a9c7e03e4 in mysql_execute_command (thd=0x73d44c000d60, is_called_from_prepared_stmt=false) at /test/12.3_dbg/sql/sql_parse.cc:5908
|
#16 0x0000618a9c7d14f8 in mysql_parse (thd=0x73d44c000d60, rawbuf=0x73d44c01a3b0 "ALTER TABLE t1 PAGE_COMPRESSED=1", length=32, parser_state=0x7bd53f8819f0) at /test/12.3_dbg/sql/sql_parse.cc:7945
|
#17 0x0000618a9c7cec4e in dispatch_command (command=COM_QUERY, thd=0x73d44c000d60, packet=0x73d44c00b5e1 "ALTER TABLE t1 PAGE_COMPRESSED=1", packet_length=32, blocking=true) at /test/12.3_dbg/sql/sql_parse.cc:1903
|
#18 0x0000618a9c7d1f7a in do_command (thd=0x73d44c000d60, blocking=true)at /test/12.3_dbg/sql/sql_parse.cc:1437
|
#19 0x0000618a9c9a24ce in do_handle_one_connection (connect=0x618add547ca0, put_in_cache=true) at /test/12.3_dbg/sql/sql_connect.cc:1514
|
#20 0x0000618a9c9a22b1 in handle_one_connection (arg=0x618add6310a0)at /test/12.3_dbg/sql/sql_connect.cc:1426
|
#21 0x00007bd56569cb84 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
|
#22 0x00007bd565729d6c 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 210826 6415902490b1b0a9a500cee9bc0a41c342190605 No bug found
|
CS 10.11 opt 210826 6415902490b1b0a9a500cee9bc0a41c342190605 No bug found
|
CS 11.4 dbg 210826 1a052f27e374fc9b4cb5b1fd098cf10f0e1381cc No bug found
|
CS 11.4 opt 210826 1a052f27e374fc9b4cb5b1fd098cf10f0e1381cc No bug found
|
CS 11.8 dbg 210826 d26f9ab217a7fcf9d4eccc62c01020ff275ff42e No bug found
|
CS 11.8 opt 210826 d26f9ab217a7fcf9d4eccc62c01020ff275ff42e No bug found
|
CS 12.3 dbg 210826 add63991988734383c5e942de2a19c6c45f511f7 dict_tf2_is_valid(flags, flags2)|SIGABRT|ut_dbg_assertion_failed|dict_table_t::create|prepare_inplace_alter_table_dict|ha_innobase::prepare_inplace_alter_table
|
CS 12.3 opt 210826 add63991988734383c5e942de2a19c6c45f511f7 dict_tf2_is_valid(flags, flags2)|SIGABRT|ut_dbg_assertion_failed|dict_table_t::create|prepare_inplace_alter_table_dict|ha_innobase::prepare_inplace_alter_table
|
CS 13.0 dbg 210826 be111d2cd60d035d555b71da019765cfb42ea0d3 dict_tf2_is_valid(flags, flags2)|SIGABRT|ut_dbg_assertion_failed|dict_table_t::create|prepare_inplace_alter_table_dict|ha_innobase::prepare_inplace_alter_table
|
CS 13.0 opt 210826 be111d2cd60d035d555b71da019765cfb42ea0d3 dict_tf2_is_valid(flags, flags2)|SIGABRT|ut_dbg_assertion_failed|dict_table_t::create|prepare_inplace_alter_table_dict|ha_innobase::prepare_inplace_alter_table
|
CS 13.1 dbg 210826 ff09eefbe4e8b57846435ee4a928f17e49f0fdfc dict_tf2_is_valid(flags, flags2)|SIGABRT|ut_dbg_assertion_failed|dict_table_t::create|prepare_inplace_alter_table_dict|ha_innobase::prepare_inplace_alter_table
|
CS 13.1 opt 210826 ff09eefbe4e8b57846435ee4a928f17e49f0fdfc dict_tf2_is_valid(flags, flags2)|SIGABRT|ut_dbg_assertion_failed|dict_table_t::create|prepare_inplace_alter_table_dict|ha_innobase::prepare_inplace_alter_table
|
ES 10.6 dbg 210826 fcecb2620f25965723d640decede7c018bcb1dcc No bug found
|
ES 10.6 opt 210826 fcecb2620f25965723d640decede7c018bcb1dcc No bug found
|
ES 11.4 dbg 210826 3b34189bfe675c18c4ced3ef531d016ea74c76f4 No bug found
|
ES 11.4 opt 210826 3b34189bfe675c18c4ced3ef531d016ea74c76f4 No bug found
|
ES 11.8 dbg 210826 4694e931d10fecf733c34f83ea2146d31b708eb3 No bug found
|
ES 11.8 opt 210826 4694e931d10fecf733c34f83ea2146d31b708eb3 No bug found
|
ES 12.3 dbg 210826 f513f503feacabfb219d4a6f965b5f72b86d4db0 dict_tf2_is_valid(flags, flags2)|SIGABRT|ut_dbg_assertion_failed|dict_table_t::create|prepare_inplace_alter_table_dict|ha_innobase::prepare_inplace_alter_table
|
ES 12.3 opt 210826 f513f503feacabfb219d4a6f965b5f72b86d4db0 dict_tf2_is_valid(flags, flags2)|SIGABRT|ut_dbg_assertion_failed|dict_table_t::create|prepare_inplace_alter_table_dict|ha_innobase::prepare_inplace_alter_table
|