Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Done
-
None
-
Can result in hang or crash
Description
Assertion found while testing MDEV-37482
origin/MDEV-37482 7430887b8069b990194b04eff2597fcdceab9470 |
# 2025-09-18T21:11:27 [4018698] | mariadbd: /data/Server/MDEV-37482/storage/innobase/btr/btr0sea.cc:1631: void btr_search_build_page_hash_index(dict_index_t*, buf_block_t*, btr_sea::partition&, uint32_t): Assertion `!block->n_pointers' failed.
|
Stacktrace |
# 2025-09-18T21:15:05 [4018698] Thread 1 (Thread 0x7f8188083640 (LWP 4026935)):
|
# 2025-09-18T21:15:05 [4018698] #0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=140194309748288) at ./nptl/pthread_kill.c:44
|
# 2025-09-18T21:15:05 [4018698] #1 __pthread_kill_internal (signo=6, threadid=140194309748288) at ./nptl/pthread_kill.c:78
|
# 2025-09-18T21:15:05 [4018698] #2 __GI___pthread_kill (threadid=140194309748288, signo=6) at ./nptl/pthread_kill.c:89
|
# 2025-09-18T21:15:05 [4018698] #3 0x000055b598d2b4ac in my_write_core (sig=6) at /data/Server/MDEV-37482/mysys/stacktrace.c:424
|
# 2025-09-18T21:15:05 [4018698] #4 0x000055b5984e42a4 in handle_fatal_signal (sig=6) at /data/Server/MDEV-37482/sql/signal_handler.cc:298
|
# 2025-09-18T21:15:05 [4018698] #5 <signal handler called>
|
# 2025-09-18T21:15:05 [4018698] #6 __pthread_kill_implementation (no_tid=0, signo=6, threadid=140194309748288) at ./nptl/pthread_kill.c:44
|
# 2025-09-18T21:15:05 [4018698] #7 __pthread_kill_internal (signo=6, threadid=140194309748288) at ./nptl/pthread_kill.c:78
|
# 2025-09-18T21:15:05 [4018698] #8 __GI___pthread_kill (threadid=140194309748288, signo=signo@entry=6) at ./nptl/pthread_kill.c:89
|
# 2025-09-18T21:15:05 [4018698] #9 0x00007f81928c4476 in __GI_raise (sig=sig@entry=6) at ../sysdeps/posix/raise.c:26
|
# 2025-09-18T21:15:05 [4018698] #10 0x00007f81928aa7f3 in __GI_abort () at ./stdlib/abort.c:79
|
# 2025-09-18T21:15:05 [4018698] #11 0x00007f81928aa71b in __assert_fail_base (fmt=0x7f8192a5f130 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55b59923c365 "!block->n_pointers", file=0x55b59923c4f0 "/data/Server/MDEV-37482/storage/innobase/btr/btr0sea.cc", line=1631, function=<optimized out>) at ./assert/assert.c:92
|
# 2025-09-18T21:15:05 [4018698] #12 0x00007f81928bbe96 in __GI___assert_fail (assertion=0x55b59923c365 "!block->n_pointers", file=0x55b59923c4f0 "/data/Server/MDEV-37482/storage/innobase/btr/btr0sea.cc", line=1631, function=0x55b59923d1f8 "void btr_search_build_page_hash_index(dict_index_t*, buf_block_t*, btr_sea::partition&, uint32_t)") at ./assert/assert.c:101
|
# 2025-09-18T21:15:05 [4018698] #13 0x000055b598b66180 in btr_search_build_page_hash_index (index=0x7f813809dbc8, block=0x7f8183802280, part=..., left_bytes_fields=<optimized out>) at /data/Server/MDEV-37482/storage/innobase/btr/btr0sea.cc:1631
|
# 2025-09-18T21:15:05 [4018698] #14 0x000055b598b6669c in btr_cur_t::search_info_update (this=this@entry=0x7f812402fb50) at /data/Server/MDEV-37482/storage/innobase/btr/btr0sea.cc:1679
|
# 2025-09-18T21:15:05 [4018698] #15 0x000055b598b5201b in btr_cur_t::search_leaf (this=this@entry=0x7f812402fb50, tuple=tuple@entry=0x7f812402fc70, mode=mode@entry=PAGE_CUR_GE, latch_mode=<optimized out>, latch_mode@entry=BTR_SEARCH_LEAF, mtr=mtr@entry=0x7f8188080e20) at /data/Server/MDEV-37482/storage/innobase/btr/btr0cur.cc:1431
|
# 2025-09-18T21:15:05 [4018698] #16 0x000055b598a81ed9 in btr_pcur_open_with_no_init (mtr=0x7f8188080e20, cursor=0x7f812402fb50, latch_mode=BTR_SEARCH_LEAF, mode=PAGE_CUR_GE, tuple=0x7f812402fc70) at /data/Server/MDEV-37482/storage/innobase/include/btr0pcur.inl:322
|
# 2025-09-18T21:15:05 [4018698] #17 row_sel_try_search_shortcut_for_mysql (out_rec=out_rec@entry=0x7f81880809c8, prebuilt=prebuilt@entry=0x7f812402f978, offsets=offsets@entry=0x7f81880809f0, heap=heap@entry=0x7f81880809e8, mtr=mtr@entry=0x7f8188080e20) at /data/Server/MDEV-37482/storage/innobase/row/row0sel.cc:3973
|
# 2025-09-18T21:15:05 [4018698] #18 0x000055b598a85048 in row_search_mvcc (buf=buf@entry=0x7f8124021520 "\377", ' ' <repeats 240 times>, "j", ' ' <repeats 479 times>, mode=PAGE_CUR_GE, prebuilt=<optimized out>, match_mode=1, direction=direction@entry=0) at /data/Server/MDEV-37482/storage/innobase/row/row0sel.cc:4561
|
# 2025-09-18T21:15:05 [4018698] #19 0x000055b598865e54 in ha_innobase::index_read (this=this@entry=0x7f8124020cc8, buf=buf@entry=0x7f8124021520 "\377", ' ' <repeats 240 times>, "j", ' ' <repeats 479 times>, key_ptr=key_ptr@entry=0x7f81382d88e4 "\t\034", key_len=4, find_flag=find_flag@entry=HA_READ_KEY_EXACT) at /data/Server/MDEV-37482/storage/innobase/handler/ha_innodb.cc:9067
|
# 2025-09-18T21:15:05 [4018698] #20 0x000055b59886618b in ha_innobase::rnd_pos (this=0x7f8124020cc8, buf=0x7f8124021520 "\377", ' ' <repeats 240 times>, "j", ' ' <repeats 479 times>, pos=0x7f81382d88e4 "\t\034") at /data/Server/MDEV-37482/storage/innobase/handler/ha_innodb.cc:9553
|
# 2025-09-18T21:15:05 [4018698] #21 0x000055b5984ee145 in handler::ha_rnd_pos (this=0x7f8124020cc8, buf=0x7f8124021520 "\377", ' ' <repeats 240 times>, "j", ' ' <repeats 479 times>, pos=0x7f81382d88e4 "\t\034") at /data/Server/MDEV-37482/sql/handler.cc:3824
|
# 2025-09-18T21:15:05 [4018698] #22 0x000055b59808954f in rr_from_pointers (info=0x7f813801bc50) at /data/Server/MDEV-37482/sql/records.cc:605
|
# 2025-09-18T21:15:05 [4018698] #23 0x000055b5981f3634 in READ_RECORD::read_record (this=0x7f813801bc50) at /data/Server/MDEV-37482/sql/records.h:77
|
# 2025-09-18T21:15:05 [4018698] #24 sub_select (join=0x7f81380199b0, join_tab=0x7f813801bb80, end_of_records=false) at /data/Server/MDEV-37482/sql/sql_select.cc:24307
|
# 2025-09-18T21:15:05 [4018698] #25 0x000055b59821bf23 in do_select (join=join@entry=0x7f81380199b0, procedure=<optimized out>) at /data/Server/MDEV-37482/sql/sql_select.cc:23801
|
# 2025-09-18T21:15:05 [4018698] #26 0x000055b598229f19 in JOIN::exec_inner (this=this@entry=0x7f81380199b0) at /data/Server/MDEV-37482/sql/sql_select.cc:5071
|
# 2025-09-18T21:15:05 [4018698] #27 0x000055b598229fba in JOIN::exec (this=this@entry=0x7f81380199b0) at /data/Server/MDEV-37482/sql/sql_select.cc:4859
|
# 2025-09-18T21:15:05 [4018698] #28 0x000055b598228863 in mysql_select (thd=thd@entry=0x7f8138000d58, tables=0x7f81380183d0, fields=..., conds=0x7f8138018d48, og_num=1, order=0x7f8138019840, group=0x0, having=0x0, proc_param=0x0, select_options=2164525824, result=0x7f8138019988, unit=0x7f8138005098, select_lex=0x7f8138017d78) at /data/Server/MDEV-37482/sql/sql_select.cc:5387
|
# 2025-09-18T21:15:05 [4018698] #29 0x000055b598228fbd in handle_select (thd=thd@entry=0x7f8138000d58, lex=lex@entry=0x7f8138004fb8, result=result@entry=0x7f8138019988, setup_tables_done_option=setup_tables_done_option@entry=0) at /data/Server/MDEV-37482/sql/sql_select.cc:633
|
# 2025-09-18T21:15:05 [4018698] #30 0x000055b59817c606 in execute_sqlcom_select (thd=thd@entry=0x7f8138000d58, all_tables=0x7f81380183d0) at /data/Server/MDEV-37482/sql/sql_parse.cc:6190
|
# 2025-09-18T21:15:05 [4018698] #31 0x000055b598188d36 in mysql_execute_command (thd=thd@entry=0x7f8138000d58, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /data/Server/MDEV-37482/sql/sql_parse.cc:3975
|
# 2025-09-18T21:15:05 [4018698] #32 0x000055b59818f957 in mysql_parse (thd=thd@entry=0x7f8138000d58, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7f8188082330) at /data/Server/MDEV-37482/sql/sql_parse.cc:7905
|
# 2025-09-18T21:15:05 [4018698] #33 0x000055b598191eec in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f8138000d58, packet=packet@entry=0x7f813800b1b9 "", packet_length=packet_length@entry=108, blocking=blocking@entry=true) at /data/Server/MDEV-37482/sql/sql_parse.cc:1903
|
# 2025-09-18T21:15:05 [4018698] #34 0x000055b598193ec3 in do_command (thd=thd@entry=0x7f8138000d58, blocking=blocking@entry=true) at /data/Server/MDEV-37482/sql/sql_parse.cc:1416
|
# 2025-09-18T21:15:05 [4018698] #35 0x000055b598318aed in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55b59c3f3268, put_in_cache=put_in_cache@entry=true) at /data/Server/MDEV-37482/sql/sql_connect.cc:1415
|
# 2025-09-18T21:15:05 [4018698] #36 0x000055b598318d2d in handle_one_connection (arg=0x55b59c3f3268) at /data/Server/MDEV-37482/sql/sql_connect.cc:1327
|
# 2025-09-18T21:15:05 [4018698] #37 0x00007f8192916ac3 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
# 2025-09-18T21:15:05 [4018698] #38 0x00007f81929a8850 in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
|
Core dump is present on pluto:-
/data/results/1758228918/TBR-2261
Attachments
Issue Links
- is caused by
-
MDEV-37482 Contention on btr_sea::partition::latch
-
- Closed
-
- relates to
-
MDEV-37697 dberr_t dict_index_t::clear(que_thr_t*): Assertion `!any_ahi_pages()' failed
-
- Closed
-
-
SAMU-322 Loading...