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

dberr_t fts_delete(fts_trx_table_t*, fts_trx_row_t*): Assertion `!(table->flags2 & (2U))' failed

    XMLWordPrintable

Details

    • Can result in hang or crash

    Description

      Assertion found while testing MDEV-28730

      origin/main-MDEV-28730 1ee1317ddd1103587eb9625729b0fb425da1bb50

      # 2025-11-21T10:50:35 [295106] | mariadbd: /data/Server/main-MDEV-28730/storage/innobase/fts/fts0fts.cc:2740: dberr_t fts_delete(fts_trx_table_t*, fts_trx_row_t*): Assertion `!(table->flags2 & (2U))' failed.
      

      Stacktrace

      # 2025-11-21T10:53:22 [295106] | #0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=139776154351168) at ./nptl/pthread_kill.c:44
      # 2025-11-21T10:53:22 [295106] | #1  __pthread_kill_internal (signo=6, threadid=139776154351168) at ./nptl/pthread_kill.c:78
      # 2025-11-21T10:53:22 [295106] | #2  __GI___pthread_kill (threadid=139776154351168, signo=signo@entry=6) at ./nptl/pthread_kill.c:89
      # 2025-11-21T10:53:22 [295106] | #3  0x00007f2057ae6476 in __GI_raise (sig=sig@entry=6) at ../sysdeps/posix/raise.c:26
      # 2025-11-21T10:53:22 [295106] | #4  0x00007f2057acc7f3 in __GI_abort () at ./stdlib/abort.c:79
      # 2025-11-21T10:53:22 [295106] | #5  0x00007f2057acc71b in __assert_fail_base (fmt=0x7f2057c81130 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x560e97bd5846 "!(table->flags2 & (2U))", file=0x560e97bd3ca0 "/data/Server/main-MDEV-28730/storage/innobase/fts/fts0fts.cc", line=2740, function=<optimized out>) at ./assert/assert.c:92
      # 2025-11-21T10:53:22 [295106] | #6  0x00007f2057adde96 in __GI___assert_fail (assertion=0x560e97bd5846 "!(table->flags2 & (2U))", file=0x560e97bd3ca0 "/data/Server/main-MDEV-28730/storage/innobase/fts/fts0fts.cc", line=2740, function=0x560e97bd3d50 "dberr_t fts_delete(fts_trx_table_t*, fts_trx_row_t*)") at ./assert/assert.c:101
      # 2025-11-21T10:53:22 [295106] | #7  0x0000560e9754fc96 in fts_delete (ftt=ftt@entry=0x7f20202120d8, row=row@entry=0x7f2020929b30) at /data/Server/main-MDEV-28730/storage/innobase/fts/fts0fts.cc:2740
      # 2025-11-21T10:53:22 [295106] | #8  0x0000560e97560e79 in fts_commit_table (ftt=0x7f20202120d8) at /data/Server/main-MDEV-28730/storage/innobase/fts/fts0fts.cc:2860
      # 2025-11-21T10:53:22 [295106] | #9  0x0000560e97560f3f in fts_commit (trx=trx@entry=0x7f204e7dfc00) at /data/Server/main-MDEV-28730/storage/innobase/fts/fts0fts.cc:2901
      # 2025-11-21T10:53:22 [295106] | #10 0x0000560e973e34ac in trx_t::commit_persist (this=this@entry=0x7f204e7dfc00) at /data/Server/main-MDEV-28730/storage/innobase/trx/trx0trx.cc:1563
      # 2025-11-21T10:53:22 [295106] | #11 0x0000560e973e4ebf in trx_t::commit (this=this@entry=0x7f204e7dfc00) at /data/Server/main-MDEV-28730/storage/innobase/trx/trx0trx.cc:1611
      # 2025-11-21T10:53:22 [295106] | #12 0x0000560e973e5cbd in trx_commit_for_mysql (trx=trx@entry=0x7f204e7dfc00) at /data/Server/main-MDEV-28730/storage/innobase/trx/trx0trx.cc:1726
      # 2025-11-21T10:53:22 [295106] | #13 0x0000560e97146f57 in innobase_commit_low (trx=trx@entry=0x7f204e7dfc00) at /data/Server/main-MDEV-28730/storage/innobase/handler/ha_innodb.cc:4322
      # 2025-11-21T10:53:22 [295106] | #14 0x0000560e97146fd6 in innobase_commit_ordered_2 (trx=trx@entry=0x7f204e7dfc00, thd=thd@entry=0x7f2020002568) at /data/Server/main-MDEV-28730/storage/innobase/handler/ha_innodb.cc:4414
      # 2025-11-21T10:53:22 [295106] | #15 0x0000560e971473eb in innobase_commit (thd=0x7f2020002568, commit_trx=<optimized out>) at /data/Server/main-MDEV-28730/storage/innobase/handler/ha_innodb.cc:4560
      # 2025-11-21T10:53:22 [295106] | #16 0x0000560e96d9fb0b in commit_one_phase_2 (thd=thd@entry=0x7f2020002568, all=all@entry=false, trans=trans@entry=0x7f20200061e0, is_real_trans=true) at /data/Server/main-MDEV-28730/sql/handler.cc:2249
      # 2025-11-21T10:53:22 [295106] | #17 0x0000560e96d9fc9a in ha_commit_one_phase (thd=thd@entry=0x7f2020002568, all=all@entry=false) at /data/Server/main-MDEV-28730/sql/handler.cc:2189
      # 2025-11-21T10:53:22 [295106] | #18 0x0000560e96da1177 in ha_commit_trans (thd=thd@entry=0x7f2020002568, all=all@entry=false) at /data/Server/main-MDEV-28730/sql/handler.cc:1979
      # 2025-11-21T10:53:22 [295106] | #19 0x0000560e96bd17db in trans_commit_stmt (thd=thd@entry=0x7f2020002568) at /data/Server/main-MDEV-28730/sql/transaction.cc:498
      # 2025-11-21T10:53:22 [295106] | #20 0x0000560e96a30bd7 in mysql_execute_command (thd=thd@entry=0x7f2020002568, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /data/Server/main-MDEV-28730/sql/sql_parse.cc:5947
      # 2025-11-21T10:53:22 [295106] | #21 0x0000560e96a31323 in mysql_parse (thd=thd@entry=0x7f2020002568, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7f202c072350) at /data/Server/main-MDEV-28730/sql/sql_parse.cc:7888
      # 2025-11-21T10:53:22 [295106] | #22 0x0000560e96a33328 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f2020002568, packet=packet@entry=0x7f202000cb29 " LOAD DATA INFILE 'load_table100_innodb_int_autoinc' REPLACE INTO TABLE table100_innodb_int_autoinc  /* E_R Thread1 QNO 559 CON_ID 15 */ ", packet_length=packet_length@entry=137, blocking=blocking@entry=true) at /data/Server/main-MDEV-28730/sql/sql_parse.cc:1878
      # 2025-11-21T10:53:22 [295106] | #23 0x0000560e96a35321 in do_command (thd=thd@entry=0x7f2020002568, blocking=blocking@entry=true) at /data/Server/main-MDEV-28730/sql/sql_parse.cc:1417
      # 2025-11-21T10:53:22 [295106] | #24 0x0000560e96bb8b63 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x560e9a8d5608, put_in_cache=put_in_cache@entry=true) at /data/Server/main-MDEV-28730/sql/sql_connect.cc:1503
      # 2025-11-21T10:53:22 [295106] | #25 0x0000560e96bb8da3 in handle_one_connection (arg=0x560e9a8d5608) at /data/Server/main-MDEV-28730/sql/sql_connect.cc:1415
      # 2025-11-21T10:53:22 [295106] | #26 0x00007f2057b38ac3 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
      # 2025-11-21T10:53:22 [295106] | #27 0x00007f2057bc9a04 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:100
      

      RR trace is present on pluto:-
      /data/results/1763714402/TBR-1746

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:

                Git Integration

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