Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-40880

InnoDB: Failing assertion: dict_tf2_is_valid(flags, flags2)

    XMLWordPrintable

Details

    • 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
      

      Attachments

        Activity

          People

            thiru Thirunarayanan Balathandayuthapani
            saahil Saahil Alam
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Time Tracking

                Estimated:
                Original Estimate - 0d
                0d
                Remaining:
                Time Spent - 0.25d Remaining Estimate - 2d
                2d
                Logged:
                Time Spent - 0.25d Remaining Estimate - 2d
                0.25d

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.