Details
-
Bug
-
Status: Open (View Workflow)
-
Critical
-
Resolution: Unresolved
-
13.1
-
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
- is caused by
-
MDEV-37070 Implement table and index options to enable/disable ADAPTIVE_HASH_INDEX
-
- Closed
-