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

InnoDB: Failing assertion: !fts_lock_common_tables(ctx->trx, *ctx->new_table)

    XMLWordPrintable

Details

    • 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                  
      

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0d
                0d
                Logged:
                Time Spent - 1h
                1h

                Git Integration

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