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

dberr_t btr_cur_t::search_leaf(const dtuple_t*, page_cur_mode_t, btr_latch_mode, mtr_t*): Assertion `index()->is_btree() || index()->is_ibuf()' failed

    XMLWordPrintable

Details

    • Can result in hang or crash

    Description

      Hi marko , please check if this could be related
      Assertion and corruption found while testing MDEV-37659

      Leads to:-

      origin/MDEV-37659 7ca59491647bac063b235b53523f7e9fe6a403f0

      		 
      # 2025-10-09T23:36:17 [4111395] | 2025-10-09 23:36:13 34 [ERROR] InnoDB: Flagged corruption of `FTS_DOC_ID_INDEX` in table `test`.`t2` in CHECK TABLE; Wrong count
      		 
      # 2025-10-09T23:36:17 [4111395] | 2025-10-09 23:36:13 34 [ERROR] InnoDB: Flagged corruption of `idx2` in table `test`.`t2` in CHECK TABLE; Wrong count
      		 
      # 2025-10-09T23:36:17 [4111395] | 2025-10-09 23:36:13 34 [ERROR] InnoDB: Flagged corruption of `MarvÃ<83>£o_idx3` in table `test`.`t2` in CHECK TABLE; Wrong count
      		 
      # 2025-10-09T23:36:17 [4111395] | mariadbd: /data/Server/MDEV-37659/storage/innobase/btr/btr0cur.cc:1093: dberr_t btr_cur_t::search_leaf(const dtuple_t*, page_cur_mode_t, btr_latch_mode, mtr_t*): Assertion `index()->is_btree() || index()->is_ibuf()' failed

      Stacktrace

      		 
      # 2025-10-09T23:39:01 [4111395] | #0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>) at ./nptl/pthread_kill.c:44
      		 
      # 2025-10-09T23:39:01 [4111395] | #1  __pthread_kill_internal (signo=6, threadid=<optimized out>) at ./nptl/pthread_kill.c:78
      		 
      # 2025-10-09T23:39:01 [4111395] | #2  __GI___pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ./nptl/pthread_kill.c:89
      		 
      # 2025-10-09T23:39:01 [4111395] | #3  0x000072a2efa4526e in __GI_raise (sig=sig@entry=6) at ../sysdeps/posix/raise.c:26
      		 
      # 2025-10-09T23:39:01 [4111395] | #4  0x000072a2efa288ff in __GI_abort () at ./stdlib/abort.c:79
      		 
      # 2025-10-09T23:39:01 [4111395] | #5  0x000072a2efa2881b in __assert_fail_base (fmt=0x72a2efbd01e8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x5c68afc67918 "index()->is_btree() || index()->is_ibuf()", file=file@entry=0x5c68afc64dd0 "/data/Server/MDEV-37659/storage/innobase/btr/btr0cur.cc", line=line@entry=1093, function=function@entry=0x5c68afc67b28 "dberr_t btr_cur_t::search_leaf(const dtuple_t*, page_cur_mode_t, btr_latch_mode, mtr_t*)") at ./assert/assert.c:94
      		 
      # 2025-10-09T23:39:01 [4111395] | #6  0x000072a2efa3b507 in __assert_fail (assertion=0x5c68afc67918 "index()->is_btree() || index()->is_ibuf()", file=0x5c68afc64dd0 "/data/Server/MDEV-37659/storage/innobase/btr/btr0cur.cc", line=1093, function=0x5c68afc67b28 "dberr_t btr_cur_t::search_leaf(const dtuple_t*, page_cur_mode_t, btr_latch_mode, mtr_t*)") at ./assert/assert.c:103
      		 
      # 2025-10-09T23:39:01 [4111395] | #7  0x00005c68af95b499 in btr_cur_t::search_leaf (this=this@entry=0x72a2e7f1b350, tuple=tuple@entry=0x72a2c00f9f70, mode=mode@entry=PAGE_CUR_LE, latch_mode=<optimized out>, latch_mode@entry=BTR_SEARCH_LEAF, mtr=mtr@entry=0x72a2e7f1b4f0) at /data/Server/MDEV-37659/storage/innobase/btr/btr0cur.cc:1093
      		 
      # 2025-10-09T23:39:01 [4111395] | #8  0x00005c68afa05228 in btr_pcur_open_with_no_init (mtr=0x72a2e7f1b4f0, cursor=0x72a2e7f1b350, latch_mode=BTR_SEARCH_LEAF, mode=PAGE_CUR_LE, tuple=0x72a2c00f9f70) at /data/Server/MDEV-37659/storage/innobase/include/btr0pcur.inl:322
      		 
      # 2025-10-09T23:39:01 [4111395] | #9  fts_add_doc_by_id (ftt=ftt@entry=0x72a2e809b0d0, doc_id=doc_id@entry=42) at /data/Server/MDEV-37659/storage/innobase/fts/fts0fts.cc:3444
      		 
      # 2025-10-09T23:39:01 [4111395] | #10 0x00005c68afa057e2 in fts_add (ftt=ftt@entry=0x72a2e809b0d0, row=<optimized out>) at /data/Server/MDEV-37659/storage/innobase/fts/fts0fts.cc:2820
      		 
      # 2025-10-09T23:39:01 [4111395] | #11 0x00005c68afa059ae in fts_commit_table (ftt=0x72a2e809b0d0) at /data/Server/MDEV-37659/storage/innobase/fts/fts0fts.cc:2982
      		 
      # 2025-10-09T23:39:01 [4111395] | #12 0x00005c68afa05a67 in fts_commit (trx=trx@entry=0x72a2eda04580) at /data/Server/MDEV-37659/storage/innobase/fts/fts0fts.cc:3031
      		 
      # 2025-10-09T23:39:01 [4111395] | #13 0x00005c68af91def6 in trx_t::commit_low (this=this@entry=0x72a2eda04580, mtr=0x72a2e7f1bb60) at /data/Server/MDEV-37659/storage/innobase/trx/trx0trx.cc:1537
      		 
      # 2025-10-09T23:39:01 [4111395] | #14 0x00005c68af91ec4f in trx_t::commit_persist (this=this@entry=0x72a2eda04580) at /data/Server/MDEV-37659/storage/innobase/trx/trx0trx.cc:1589
      		 
      # 2025-10-09T23:39:01 [4111395] | #15 0x00005c68af91ecac in trx_t::commit (this=this@entry=0x72a2eda04580) at /data/Server/MDEV-37659/storage/innobase/trx/trx0trx.cc:1598
      		 
      # 2025-10-09T23:39:01 [4111395] | #16 0x00005c68af91ef7c in trx_commit_for_mysql (trx=trx@entry=0x72a2eda04580) at /data/Server/MDEV-37659/storage/innobase/trx/trx0trx.cc:1710
      		 
      # 2025-10-09T23:39:01 [4111395] | #17 0x00005c68af765058 in innobase_commit_low (trx=trx@entry=0x72a2eda04580) at /data/Server/MDEV-37659/storage/innobase/handler/ha_innodb.cc:4438
      		 
      # 2025-10-09T23:39:01 [4111395] | #18 0x00005c68af7650d7 in innobase_commit_ordered_2 (trx=trx@entry=0x72a2eda04580, thd=thd@entry=0x72a2e8002848) at /data/Server/MDEV-37659/storage/innobase/handler/ha_innodb.cc:4532
      		 
      # 2025-10-09T23:39:01 [4111395] | #19 0x00005c68af76516d in innobase_commit_ordered (hton=<optimized out>, thd=0x72a2e8002848, all=true) at /data/Server/MDEV-37659/storage/innobase/handler/ha_innodb.cc:4578
      		 
      # 2025-10-09T23:39:01 [4111395] | #20 0x00005c68af5f84e7 in TC_LOG::run_commit_ordered (this=this@entry=0x5c68b0538480 <mysql_bin_log>, thd=0x72a2e8002848, all=true) at /data/Server/MDEV-37659/sql/log.cc:9515
      		 
      # 2025-10-09T23:39:01 [4111395] | #21 0x00005c68af600444 in MYSQL_BIN_LOG::trx_group_commit_leader (this=this@entry=0x5c68b0538480 <mysql_bin_log>, leader=leader@entry=0x72a2e7f1c2e0) at /data/Server/MDEV-37659/sql/log.cc:8705
      		 
      # 2025-10-09T23:39:01 [4111395] | #22 0x00005c68af6007ee in MYSQL_BIN_LOG::write_transaction_to_binlog_events (this=this@entry=0x5c68b0538480 <mysql_bin_log>, entry=entry@entry=0x72a2e7f1c2e0) at /data/Server/MDEV-37659/sql/log.cc:8273
      		 
      # 2025-10-09T23:39:01 [4111395] | #23 0x00005c68af600af2 in MYSQL_BIN_LOG::write_transaction_to_binlog (this=this@entry=0x5c68b0538480 <mysql_bin_log>, thd=thd@entry=0x72a2e8002848, cache_mngr=cache_mngr@entry=0x72a2e801e4d8, end_ev=end_ev@entry=0x72a2e7f1c460, all=all@entry=true, using_stmt_cache=using_stmt_cache@entry=true, using_trx_cache=true, is_ro_1pc=false) at /data/Server/MDEV-37659/sql/log.cc:7870
      		 
      # 2025-10-09T23:39:01 [4111395] | #24 0x00005c68af600bf8 in binlog_flush_cache (thd=thd@entry=0x72a2e8002848, cache_mngr=cache_mngr@entry=0x72a2e801e4d8, end_ev=end_ev@entry=0x72a2e7f1c460, all=all@entry=true, using_stmt=using_stmt@entry=true, using_trx=using_trx@entry=true, is_ro_1pc=false) at /data/Server/MDEV-37659/sql/log.cc:1835
      		 
      # 2025-10-09T23:39:01 [4111395] | #25 0x00005c68af60216b in binlog_commit_flush_xid_caches (thd=thd@entry=0x72a2e8002848, cache_mngr=cache_mngr@entry=0x72a2e801e4d8, all=all@entry=true, xid=xid@entry=4487) at /data/Server/MDEV-37659/sql/log.cc:1985
      		 
      # 2025-10-09T23:39:01 [4111395] | #26 0x00005c68af6022a9 in MYSQL_BIN_LOG::log_and_order (this=<optimized out>, thd=0x72a2e8002848, xid=4487, all=true, need_prepare_ordered=<optimized out>, need_commit_ordered=<optimized out>) at /data/Server/MDEV-37659/sql/log.cc:10455
      		 
      # 2025-10-09T23:39:01 [4111395] | #27 0x00005c68af5250ba in ha_commit_trans (thd=thd@entry=0x72a2e8002848, all=all@entry=true) at /data/Server/MDEV-37659/sql/handler.cc:1991
      		 
      # 2025-10-09T23:39:01 [4111395] | #28 0x00005c68af3f3680 in trans_commit (thd=thd@entry=0x72a2e8002848) at /data/Server/MDEV-37659/sql/transaction.cc:274
      		 
      # 2025-10-09T23:39:01 [4111395] | #29 0x00005c68af2cfeaa in mysql_execute_command (thd=thd@entry=0x72a2e8002848, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /data/Server/MDEV-37659/sql/sql_parse.cc:5789
      		 
      # 2025-10-09T23:39:01 [4111395] | #30 0x00005c68af2d18dc in mysql_parse (thd=thd@entry=0x72a2e8002848, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x72a2e7f1d410) at /data/Server/MDEV-37659/sql/sql_parse.cc:8200
      		 
      # 2025-10-09T23:39:01 [4111395] | #31 0x00005c68af2d2f48 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x72a2e8002848, packet=packet@entry=0x72a2e800ca59 " COMMIT  /* E_R Thread6 QNO 341 CON_ID 22 */ ", packet_length=packet_length@entry=45, blocking=blocking@entry=true) at /data/Server/MDEV-37659/sql/sql_parse.cc:1908
      		 
      # 2025-10-09T23:39:01 [4111395] | #32 0x00005c68af2d43e6 in do_command (thd=thd@entry=0x72a2e8002848, blocking=blocking@entry=true) at /data/Server/MDEV-37659/sql/sql_parse.cc:1421
      		 
      # 2025-10-09T23:39:01 [4111395] | #33 0x00005c68af3e2859 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x5c68b24c2738, put_in_cache=put_in_cache@entry=true) at /data/Server/MDEV-37659/sql/sql_connect.cc:1386
      		 
      # 2025-10-09T23:39:01 [4111395] | #34 0x00005c68af3e2a6a in handle_one_connection (arg=0x5c68b24c2738) at /data/Server/MDEV-37659/sql/sql_connect.cc:1298
      		 
      # 2025-10-09T23:39:01 [4111395] | #35 0x000072a2efa9ca94 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:447
      		 
      # 2025-10-09T23:39:01 [4111395] | #36 0x000072a2efb29a34 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:100

      RR trace is present on SDP
      /data/results/1760078060/TBR-1750

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-37831 The B-tree of index FTS_DOC_ID_INDEX is corrupted

          • Major - Major loss of function.
          • Open

          Activity

            People

              thiru Thirunarayanan Balathandayuthapani
              saahil Saahil Alam
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.