Draft: Assertion `index == cursor->index' failed in btr0sea.cc

There are two quite similar looking asserts

origin/10.6, 10.6 a1542f8a57390bbad916ddfd335e1c751ffb3de5 2021-02-12T17:44:58+02:00

mysqld: /Server/10.6K/storage/innobase/btr/btr0sea.cc:709: void btr_search_update_hash_ref(const btr_search_t*, buf_block_t*, const btr_cur_t*): Assertion `index == cursor->index' failed.

# 2021-02-15T15:35:04 [3408208] #0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50

# 2021-02-15T15:35:04 [3408208] #1  0x00007ff1bf91f859 in __GI_abort () at abort.c:79

# 2021-02-15T15:35:04 [3408208] #2  0x00007ff1bf91f729 in __assert_fail_base (fmt=0x7ff1bfab5588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x5561318f43a0 "index == cursor->index", file=0x5561318f3600 "/Server/10.6K/storage/innobase/btr/btr0sea.cc", line=709, function=<optimized out>) at assert.c:92

# 2021-02-15T15:35:04 [3408208] #3  0x00007ff1bf930f36 in __GI___assert_fail (assertion=0x5561318f43a0 "index == cursor->index", file=0x5561318f3600 "/Server/10.6K/storage/innobase/btr/btr0sea.cc", line=709, function=0x5561318f41c0 "void btr_search_update_hash_ref(const btr_search_t*, buf_block_t*, const btr_cur_t*)") at assert.c:101

# 2021-02-15T15:35:04 [3408208] #4  0x00005561302c8663 in btr_search_update_hash_ref (info=0x61a000c325c0, block=0x7ff1a2895d60, cursor=0x7ff196130090) at /Server/10.6K/storage/innobase/btr/btr0sea.cc:709

# 2021-02-15T15:35:04 [3408208] #5  0x00005561302cd8c5 in btr_search_info_update_slow (info=0x61a000c325c0, cursor=0x7ff196130090) at /Server/10.6K/storage/innobase/btr/btr0sea.cc:1666

# 2021-02-15T15:35:04 [3408208] #6  0x000055613027dec1 in btr_search_info_update (index=0x616000a18620, cursor=0x7ff196130090) at /Server/10.6K/storage/innobase/include/btr0sea.ic:81

# 2021-02-15T15:35:04 [3408208] #7  0x000055613028c104 in btr_cur_search_to_nth_level_func (index=0x616000a18620, level=0, tuple=0x61a0050d9120, mode=PAGE_CUR_LE, latch_mode=2, cursor=0x7ff196130090, ahi_latch=0x0, mtr=0x7ff196130590, autoinc=0) at /Server/10.6K/storage/innobase/btr/btr0cur.cc:2455

# 2021-02-15T15:35:04 [3408208] #8  0x00005561300f89a3 in btr_pcur_open_low (index=0x616000a18620, level=0, tuple=0x61a0050d9120, mode=PAGE_CUR_LE, latch_mode=8194, cursor=0x7ff196130090, autoinc=0, mtr=0x7ff196130590) at /Server/10.6K/storage/innobase/include/btr0pcur.ic:439

# 2021-02-15T15:35:04 [3408208] #9  0x00005561300ff478 in row_search_index_entry (index=0x616000a18620, entry=0x61a0050d9120, mode=8194, pcur=0x7ff196130090, mtr=0x7ff196130590) at /Server/10.6K/storage/innobase/row/row0row.cc:1301

# 2021-02-15T15:35:04 [3408208] #10 0x00005561300e97dc in row_purge_remove_sec_if_poss_leaf (node=0x61b000001fe8, index=0x616000a18620, entry=0x61a0050d9120) at /Server/10.6K/storage/innobase/row/row0purge.cc:456

# 2021-02-15T15:35:04 [3408208] #11 0x00005561300ea167 in row_purge_remove_sec_if_poss (node=0x61b000001fe8, index=0x616000a18620, entry=0x61a0050d9120) at /Server/10.6K/storage/innobase/row/row0purge.cc:565

# 2021-02-15T15:35:04 [3408208] #12 0x00005561300ebc4e in row_purge_upd_exist_or_extern_func (thr=0x61b000001f40, node=0x61b000001fe8, undo_rec=0x621000248b00 "") at /Server/10.6K/storage/innobase/row/row0purge.cc:758

# 2021-02-15T15:35:04 [3408208] #13 0x00005561300ee041 in row_purge_record_func (node=0x61b000001fe8, undo_rec=0x621000248b00 "", thr=0x61b000001f40, updated_extern=false) at /Server/10.6K/storage/innobase/row/row0purge.cc:1071

# 2021-02-15T15:35:04 [3408208] #14 0x00005561300ee397 in row_purge (node=0x61b000001fe8, undo_rec=0x621000248b00 "", thr=0x61b000001f40) at /Server/10.6K/storage/innobase/row/row0purge.cc:1110

# 2021-02-15T15:35:04 [3408208] #15 0x00005561300ee6dd in row_purge_step (thr=0x61b000001f40) at /Server/10.6K/storage/innobase/row/row0purge.cc:1159

# 2021-02-15T15:35:04 [3408208] #16 0x000055612ffc4ff1 in que_thr_step (thr=0x61b000001f40) at /Server/10.6K/storage/innobase/que/que0que.cc:653

# 2021-02-15T15:35:04 [3408208] #17 0x000055612ffc5399 in que_run_threads_low (thr=0x61b000001f40) at /Server/10.6K/storage/innobase/que/que0que.cc:709

# 2021-02-15T15:35:04 [3408208] #18 0x000055612ffc553b in que_run_threads (thr=0x61b000001f40) at /Server/10.6K/storage/innobase/que/que0que.cc:729

# 2021-02-15T15:35:04 [3408208] #19 0x00005561301718b6 in srv_task_execute () at /Server/10.6K/storage/innobase/srv/srv0srv.cc:1798

# 2021-02-15T15:35:04 [3408208] #20 0x0000556130172710 in purge_worker_callback () at /Server/10.6K/storage/innobase/srv/srv0srv.cc:1961

# 2021-02-15T15:35:04 [3408208] #21 0x00005561305602c8 in tpool::task_group::execute (this=0x5561337e1200 <purge_task_group>, t=0x5561337e12c0 <purge_worker_task>) at /Server/10.6K/tpool/task_group.cc:55

# 2021-02-15T15:35:04 [3408208] #22 0x0000556130560bcf in tpool::task::execute (this=0x5561337e12c0 <purge_worker_task>) at /Server/10.6K/tpool/task.cc:47

# 2021-02-15T15:35:04 [3408208] #23 0x000055613054cb8d in tpool::thread_pool_generic::worker_main (this=0x618000000480, thread_var=0x63000001fd00) at /Server/10.6K/tpool/tpool_generic.cc:546

# 2021-02-15T15:35:04 [3408208] #24 0x000055613055fd29 in std::__invoke_impl<void, void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> (__f=@0x6040000010a8: (void (tpool::thread_pool_generic::*)(class tpool::thread_pool_generic * const, struct tpool::worker_data *)) 0x55613054c9aa <tpool::thread_pool_generic::worker_main(tpool::worker_data*)>, __t=@0x6040000010a0: 0x618000000480) at /usr/include/c++/9/bits/invoke.h:73

# 2021-02-15T15:35:04 [3408208] #25 0x000055613055fad4 in std::__invoke<void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> (__fn=@0x6040000010a8: (void (tpool::thread_pool_generic::*)(class tpool::thread_pool_generic * const, struct tpool::worker_data *)) 0x55613054c9aa <tpool::thread_pool_generic::worker_main(tpool::worker_data*)>) at /usr/include/c++/9/bits/invoke.h:95

# 2021-02-15T15:35:04 [3408208] #26 0x000055613055f965 in std::thread::_Invoker<std::tuple<void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> >::_M_invoke<0ul, 1ul, 2ul> (this=0x604000001098) at /usr/include/c++/9/thread:244

# 2021-02-15T15:35:04 [3408208] #27 0x000055613055f8af in std::thread::_Invoker<std::tuple<void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> >::operator() (this=0x604000001098) at /usr/include/c++/9/thread:251

# 2021-02-15T15:35:04 [3408208] #28 0x000055613055f814 in std::thread::_State_impl<std::thread::_Invoker<std::tuple<void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> > >::_M_run (this=0x604000001090) at /usr/include/c++/9/thread:195

# 2021-02-15T15:35:04 [3408208] #29 0x00007ff1bfd2cd84 in ?? () from /lib/x86_64-linux-gnu/libstdc++.so.6

# 2021-02-15T15:35:04 [3408208] #30 0x00007ff1bfe48609 in start_thread (arg=<optimized out>) at pthread_create.c:477

# 2021-02-15T15:35:04 [3408208] #31 0x00007ff1bfa1c293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

and

# 2021-02-15T21:44:04 [602181] | Version: '10.6.0-MariaDB-debug-log'  socket: '/dev/shm/vardir/1613386710/10/1/mysql.sock'  port: 24780  Source distribution

# 2021-02-15T21:44:04 [602181] | 2021-02-15 21:43:41 0x7fc683bf4700  InnoDB: Assertion failure in file /Server/10.6K/storage/innobase/btr/btr0sea.cc line 1783

# 2021-02-15T21:44:04 [602181] | InnoDB: Failing assertion: index == cursor->index

#3  <signal handler called>

# 2021-02-15T21:44:04 [602181] #4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50

# 2021-02-15T21:44:04 [602181] #5  0x00007fc6ae3e2859 in __GI_abort () at abort.c:79

# 2021-02-15T21:44:04 [602181] #6  0x000055d3ac24b855 in ut_dbg_assertion_failed (expr=0x55d3ad91b3a0 "index == cursor->index", file=0x55d3ad91a600 "/Server/10.6K/storage/innobase/btr/btr0sea.cc", line=1783) at /Server/10.6K/storage/innobase/ut/ut0dbg.cc:60

# 2021-02-15T21:44:04 [602181] #7  0x000055d3ac2f5894 in btr_search_update_hash_on_delete (cursor=0x7fc683bf2090) at /Server/10.6K/storage/innobase/btr/btr0sea.cc:1783

# 2021-02-15T21:44:04 [602181] #8  0x000055d3ac2ca378 in btr_cur_optimistic_delete_func (cursor=0x7fc683bf2090, flags=0, mtr=0x7fc683bf2590) at /Server/10.6K/storage/innobase/btr/btr0cur.cc:5554

# 2021-02-15T21:44:04 [602181] #9  0x000055d3ac110eb7 in row_purge_remove_sec_if_poss_leaf (node=0x61b000001d20, index=0x6160045b1a20, entry=0x61a002bf9f20) at /Server/10.6K/storage/innobase/row/row0purge.cc:517

# 2021-02-15T21:44:04 [602181] #10 0x000055d3ac111167 in row_purge_remove_sec_if_poss (node=0x61b000001d20, index=0x6160045b1a20, entry=0x61a002bf9f20) at /Server/10.6K/storage/innobase/row/row0purge.cc:565

# 2021-02-15T21:44:04 [602181] #11 0x000055d3ac112c4e in row_purge_upd_exist_or_extern_func (thr=0x617000000c58, node=0x61b000001d20, undo_rec=0x62100010b378 "") at /Server/10.6K/storage/innobase/row/row0purge.cc:758

# 2021-02-15T21:44:04 [602181] #12 0x000055d3ac115041 in row_purge_record_func (node=0x61b000001d20, undo_rec=0x62100010b378 "", thr=0x617000000c58, updated_extern=false) at /Server/10.6K/storage/innobase/row/row0purge.cc:1071

# 2021-02-15T21:44:04 [602181] #13 0x000055d3ac115397 in row_purge (node=0x61b000001d20, undo_rec=0x62100010b378 "", thr=0x617000000c58) at /Server/10.6K/storage/innobase/row/row0purge.cc:1110

# 2021-02-15T21:44:04 [602181] #14 0x000055d3ac1156dd in row_purge_step (thr=0x617000000c58) at /Server/10.6K/storage/innobase/row/row0purge.cc:1159

# 2021-02-15T21:44:04 [602181] #15 0x000055d3abfebff1 in que_thr_step (thr=0x617000000c58) at /Server/10.6K/storage/innobase/que/que0que.cc:653

# 2021-02-15T21:44:04 [602181] #16 0x000055d3abfec399 in que_run_threads_low (thr=0x617000000c58) at /Server/10.6K/storage/innobase/que/que0que.cc:709

# 2021-02-15T21:44:04 [602181] #17 0x000055d3abfec53b in que_run_threads (thr=0x617000000c58) at /Server/10.6K/storage/innobase/que/que0que.cc:729

# 2021-02-15T21:44:04 [602181] #18 0x000055d3ac1988b6 in srv_task_execute () at /Server/10.6K/storage/innobase/srv/srv0srv.cc:1798

# 2021-02-15T21:44:04 [602181] #19 0x000055d3ac199710 in purge_worker_callback () at /Server/10.6K/storage/innobase/srv/srv0srv.cc:1961

# 2021-02-15T21:44:04 [602181] #20 0x000055d3ac5872c8 in tpool::task_group::execute (this=0x55d3af808200 <purge_task_group>, t=0x55d3af8082c0 <purge_worker_task>) at /Server/10.6K/tpool/task_group.cc:55

# 2021-02-15T21:44:04 [602181] #21 0x000055d3ac587bcf in tpool::task::execute (this=0x55d3af8082c0 <purge_worker_task>) at /Server/10.6K/tpool/task.cc:47

# 2021-02-15T21:44:04 [602181] #22 0x000055d3ac573b8d in tpool::thread_pool_generic::worker_main (this=0x618000000480, thread_var=0x63000001fc00) at /Server/10.6K/tpool/tpool_generic.cc:546

# 2021-02-15T21:44:04 [602181] #23 0x000055d3ac586d29 in std::__invoke_impl<void, void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> (__f=@0x604000004028: (void (tpool::thread_pool_generic::*)(class tpool::thread_pool_generic * const, struct tpool::worker_data *)) 0x55d3ac5739aa <tpool::thread_pool_generic::worker_main(tpool::worker_data*)>, __t=@0x604000004020: 0x618000000480) at /usr/include/c++/9/bits/invoke.h:73

# 2021-02-15T21:44:04 [602181] #24 0x000055d3ac586ad4 in std::__invoke<void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> (__fn=@0x604000004028: (void (tpool::thread_pool_generic::*)(class tpool::thread_pool_generic * const, struct tpool::worker_data *)) 0x55d3ac5739aa <tpool::thread_pool_generic::worker_main(tpool::worker_data*)>) at /usr/include/c++/9/bits/invoke.h:95

# 2021-02-15T21:44:04 [602181] #25 0x000055d3ac586965 in std::thread::_Invoker<std::tuple<void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> >::_M_invoke<0ul, 1ul, 2ul> (this=0x604000004018) at /usr/include/c++/9/thread:244

# 2021-02-15T21:44:04 [602181] #26 0x000055d3ac5868af in std::thread::_Invoker<std::tuple<void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> >::operator() (this=0x604000004018) at /usr/include/c++/9/thread:251

# 2021-02-15T21:44:04 [602181] #27 0x000055d3ac586814 in std::thread::_State_impl<std::thread::_Invoker<std::tuple<void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> > >::_M_run (this=0x604000004010) at /usr/include/c++/9/thread:195

# 2021-02-15T21:44:04 [602181] #28 0x00007fc6ae7efd84 in ?? () from /lib/x86_64-linux-gnu/libstdc++.so.6

# 2021-02-15T21:44:04 [602181] #29 0x00007fc6ae90b609 in start_thread (arg=<optimized out>) at pthread_create.c:477

# 2021-02-15T21:44:04 [602181] #30 0x00007fc6ae4df293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Only the second seems to be covered by MDEV-24863.

The automatic grammar simplifier is running and making progress.