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

Assertion `!block->n_pointers' failed

    XMLWordPrintable

Details

    • Can result in hang or crash

    Description

      This issue was found on latest main branch

      Cli compatible test case

      SET GLOBAL innodb_adaptive_hash_index=ON;
      CREATE TABLE t (a INT PRIMARY KEY) ENGINE=InnoDB;
      BEGIN;
      INSERT INTO t SELECT seq FROM seq_1_to_200;
      SELECT COUNT(*) FROM t AS t1 JOIN t AS t2 ON t1.a=t2.a;
      SET GLOBAL innodb_adaptive_hash_index=IF_SPECIFIED;
      ROLLBACK;
      

      Leads to:

      CS 13.1.0 b2a8c2234dbc276fe3947633c9ffea454badf48f (Debug, Clang 22.1.8-20260621) Build 03/09/2026

      mariadbd: /test/13.1_dbg/storage/innobase/btr/btr0sea.cc:1690: void btr_search_drop_page_hash_index(buf_block_t *, const dict_index_t *, uint32_t *): Assertion `!block->n_pointers' failed.
      

      CS 13.1.0 b2a8c2234dbc276fe3947633c9ffea454badf48f (Debug, Clang 22.1.8-20260621) Build 03/09/2026

      Core was generated by `/test/MD030926-mariadb-13.1.0-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 88660)]
      (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  0x00007e71d3c4527e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
      #4  0x00007e71d3c288ff in __GI_abort () at ./stdlib/abort.c:79
      #5  0x00007e71d3c2881b in __assert_fail_base (fmt=0x7e71d3dd01e8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x5bdcd7edb8d9 "!block->n_pointers", file=file@entry=0x5bdcd7edae2e "/test/13.1_dbg/storage/innobase/btr/btr0sea.cc", line=line@entry=1690, function=function@entry=0x5bdcd7edb6cf "void btr_search_drop_page_hash_index(buf_block_t *, const dict_index_t *, uint32_t *)") at ./assert/assert.c:96
      #6  0x00007e71d3c3b517 in __assert_fail (assertion=0x5bdcd7edb8d9 "!block->n_pointers", file=0x5bdcd7edae2e "/test/13.1_dbg/storage/innobase/btr/btr0sea.cc", line=1690, function=0x5bdcd7edb6cf "void btr_search_drop_page_hash_index(buf_block_t *, const dict_index_t *, uint32_t *)") at ./assert/assert.c:105
      #7  0x00005bdcd781b123 in btr_search_drop_page_hash_index (block=0x7671a800e700, not_garbage=0x0, folds=0x7e71ac510cd0)at /test/13.1_dbg/storage/innobase/btr/btr0sea.cc:1690
      #8  0x00005bdcd7819fb7 in btr_search_drop_page_hash_index (block=0x7671a800e700, not_garbage=0x0)at /test/13.1_dbg/storage/innobase/btr/btr0sea.cc:1704
      #9  0x00005bdcd77cfb70 in btr_page_empty (block=0x7671a800e700, page_zip=0x0, index=0x7670bc298ae8, level=0, mtr=0x7e71ac5114b8)at /test/13.1_dbg/storage/innobase/btr/btr0btr.cc:1628
      #10 0x00005bdcd78044eb in btr_cur_optimistic_delete (cursor=0x7670bc2f5618, flags=0, mtr=0x7e71ac5114b8)at /test/13.1_dbg/storage/innobase/btr/btr0cur.cc:4483
      #11 0x00005bdcd795cb2a in row_undo_ins_remove_clust_rec (node=0x7670bc2f55a8)at /test/13.1_dbg/storage/innobase/row/row0uins.cc:192
      #12 0x00005bdcd795ae55 in row_undo_ins (node=0x7670bc2f55a8, thr=0x7670bc2f53d8) at /test/13.1_dbg/storage/innobase/row/row0uins.cc:593
      #13 0x00005bdcd774e23d in row_undo (node=0x7670bc2f55a8, thr=0x7670bc2f53d8)at /test/13.1_dbg/storage/innobase/row/row0undo.cc:401
      #14 0x00005bdcd774df6c in row_undo_step (thr=0x7670bc2f53d8)at /test/13.1_dbg/storage/innobase/row/row0undo.cc:442
      #15 0x00005bdcd76868f8 in que_thr_step (thr=0x7670bc2f53d8)at /test/13.1_dbg/storage/innobase/que/que0que.cc:551
      #16 0x00005bdcd7686026 in que_run_threads_low (thr=0x7670bc2f53d8)at /test/13.1_dbg/storage/innobase/que/que0que.cc:609
      #17 0x00005bdcd7685e47 in que_run_threads (thr=0x7670bc2f53d8)at /test/13.1_dbg/storage/innobase/que/que0que.cc:629
      #18 0x00005bdcd779ec23 in trx_t::rollback_low (this=0x7e71d1504b80, savept=0x0)at /test/13.1_dbg/storage/innobase/trx/trx0roll.cc:123
      #19 0x00005bdcd779f8a0 in trx_rollback_for_mysql (trx=0x7e71d1504b80)at /test/13.1_dbg/storage/innobase/trx/trx0roll.cc:220
      #20 0x00005bdcd7516150 in innobase_rollback (thd=0x7670bc000d60, rollback_trx=true)at /test/13.1_dbg/storage/innobase/handler/ha_innodb.cc:4906
      #21 0x00005bdcd7117186 in ha_rollback_trans (thd=0x7670bc000d60, all=true)at /test/13.1_dbg/sql/handler.cc:2397
      #22 0x00005bdcd6eede3b in trans_rollback (thd=0x7670bc000d60)at /test/13.1_dbg/sql/transaction.cc:388
      #23 0x00005bdcd6d06740 in mysql_execute_command (thd=0x7670bc000d60, is_called_from_prepared_stmt=false) at /test/13.1_dbg/sql/sql_parse.cc:5602
      #24 0x00005bdcd6cf88b8 in mysql_parse (thd=0x7670bc000d60, rawbuf=0x7670bc01a490 "ROLLBACK", length=8, parser_state=0x7e71ac5139c0)at /test/13.1_dbg/sql/sql_parse.cc:7968
      #25 0x00005bdcd6cf5fde in dispatch_command (command=COM_QUERY, thd=0x7670bc000d60, packet=0x7670bc00b6c1 "ROLLBACK", packet_length=8, blocking=true) at /test/13.1_dbg/sql/sql_parse.cc:1903
      #26 0x00005bdcd6cf933a in do_command (thd=0x7670bc000d60, blocking=true)at /test/13.1_dbg/sql/sql_parse.cc:1437
      #27 0x00005bdcd6ed0a5e in do_handle_one_connection (connect=0x5bdce9c2b6e0, put_in_cache=true) at /test/13.1_dbg/sql/sql_connect.cc:1514
      #28 0x00005bdcd6ed0841 in handle_one_connection (arg=0x5bdce9bc4090)at /test/13.1_dbg/sql/sql_connect.cc:1426
      #29 0x00007e71d3c9cb84 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
      #30 0x00007e71d3d29d6c 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  030926  1bc9eca856a32065fddce1db68edcfa6f4342578  No bug found                  
      CS  10.11  opt  030926  1bc9eca856a32065fddce1db68edcfa6f4342578  No bug found                  
      CS  11.4   dbg  030926  79f96bf15d2538cb78201cc85681571f56548957  No bug found                  
      CS  11.4   opt  030926  79f96bf15d2538cb78201cc85681571f56548957  No bug found                  
      CS  11.8   dbg  030926  e2e060ce3d8c3ce11b6c7ba28ced0f1a30c50a54  No bug found                  
      CS  11.8   opt  030926  e2e060ce3d8c3ce11b6c7ba28ced0f1a30c50a54  No bug found                  
      CS  12.3   dbg  030926  ab9657491197ac6a32f4f325388badda974f2fe2  No bug found                  
      CS  12.3   opt  030926  ab9657491197ac6a32f4f325388badda974f2fe2  No bug found                  
      CS  13.0   dbg  030926  b2c4e675049e23ce8c7346985f40840fcd4e583f  No bug found                  
      CS  13.0   opt  030926  b2c4e675049e23ce8c7346985f40840fcd4e583f  No bug found                  
      CS  13.1   dbg  030926  b2a8c2234dbc276fe3947633c9ffea454badf48f  !block->n_pointers|SIGABRT|btr_search_drop_page_hash_index|btr_search_drop_page_hash_index|btr_page_empty|btr_cur_optimistic_delete
      CS  13.1   opt  030926  b2a8c2234dbc276fe3947633c9ffea454badf48f  No bug found                  
      ES  10.6   dbg  030926  47e099839c30841f59054ff738662d3fd5f58a08  No bug found                  
      ES  10.6   opt  030926  47e099839c30841f59054ff738662d3fd5f58a08  No bug found                  
      ES  11.4   dbg  030926  e953e9092e7e78da74eec4a80ead7b67d55f3772  No bug found                  
      ES  11.4   opt  030926  e953e9092e7e78da74eec4a80ead7b67d55f3772  No bug found                  
      ES  11.8   dbg  030926  72bfb892c8537baa3e0e5ea16e24e79171a9be22  No bug found                  
      ES  11.8   opt  030926  72bfb892c8537baa3e0e5ea16e24e79171a9be22  No bug found                  
      ES  12.3   dbg  030926  31a1c7393d7f943ff9e335c84923988876681b44  No bug found                  
      ES  12.3   opt  030926  31a1c7393d7f943ff9e335c84923988876681b44  No bug found                  
      

      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:

                Time Tracking

                  Estimated:
                  Original Estimate - 0d
                  0d
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 1.5h
                  1.5h

                  Git Integration

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