Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.11.7
-
None
-
None
-
Linux 5.10.237.x86_64 #1 SMP (2025-05-27) x86_64 GNU/Linux
Description
MariaDB crashed on !block->page.in_file() assertion during the insert operation.
Running 10.11.7 with no changes in schema related to the table in question as well as there were no significant traffic pattern changes either. This server is used as a writable primary.
Couldn't find any existing or resolved similar issues in Jira.
This was a one-time occurrence which we were not able to reproduce.
Is there anything that we can use to reason about this issue was addressed in later versions and upgrading will help?
Any additional data you'd like us to provide?
Assertion found in the error.log:
2025-07-16 14:23:23 0x7fe1ca2d2700 InnoDB: Assertion failure in file /local/workspace/build/MariaDB/MariaDB-10.11.7/src/storage/innobase/buf/buf0lru.cc line 281
|
InnoDB: Failing assertion: !block->page.in_file()
|
InnoDB: We intentionally generate a memory trap.
|
InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
|
InnoDB: If you get repeated assertion failures or crashes, even
|
InnoDB: immediately after the mariadbd startup, there may be
|
InnoDB: corruption in the InnoDB tablespace. Please refer to
|
InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/
|
InnoDB: about forcing recovery.
|
250716 14:23:23 [ERROR] mysqld got signal 6 ;
|
Sorry, we probably made a mistake, and this is a bug.
|
Full stack trace recovered from the core dump:
#0 0x00007fe1e2341ca0 in raise () from /lib64/libc.so.6
|
#1 0x00007fe1e2343226 in abort () from /lib64/libc.so.6
|
#2 0x0000559925497bea in ut_dbg_assertion_failed(char const*, char const*, unsigned int) ()
|
#3 0x0000559925ecf87e in buf_LRU_get_free_only() ()
|
#4 0x0000559925ed17e3 in buf_LRU_get_free_block(bool) ()
|
#5 0x0000559925f1df42 in fsp_alloc_free_page(fil_space_t*, unsigned int, mtr_t*, mtr_t*, dberr_t*) ()
|
#6 0x0000559925f1f5bd in fseg_alloc_free_page_low(fil_space_t*, unsigned char*, buf_block_t*, unsigned int, unsigned char, mtr_t*, mtr_t*, dberr_t*) ()
|
#7 0x0000559925f2002c in fseg_create(fil_space_t*, unsigned long, mtr_t*, dberr_t*, bool, buf_block_t*) ()
|
#8 0x0000559925e8629c in trx_undo_seg_create(fil_space_t*, buf_block_t*, unsigned long*, dberr_t*, mtr_t*) ()
|
#9 0x0000559925e8907b in trx_undo_create(trx_t*, trx_rseg_t*, trx_undo_t**, dberr_t*, mtr_t*) ()
|
#10 0x0000559925e8997b in buf_block_t* trx_undo_assign_low<false>(trx_t*, trx_rseg_t*, trx_undo_t**, mtr_t*, dberr_t*) ()
|
#11 0x0000559925e680f8 in trx_undo_report_row_operation(que_thr_t*, dict_index_t*, dtuple_t const*, upd_t const*, unsigned long, unsigned char const*, unsigned short const*, unsigned long*) ()
|
#12 0x0000559925ea342d in btr_cur_update_in_place(unsigned long, btr_cur_t*, unsigned short*, upd_t const*, unsigned long, que_thr_t*, unsigned long, mtr_t*) ()
|
#13 0x0000559925ea3a2e in btr_cur_optimistic_update(unsigned long, btr_cur_t*, unsigned short**, mem_block_info_t**, upd_t const*, unsigned long, que_thr_t*, unsigned long, mtr_t*) ()
|
#14 0x0000559925e426d1 in row_upd_clust_rec(unsigned long, upd_node_t*, dict_index_t*, unsigned short*, mem_block_info_t**, que_thr_t*, mtr_t*) ()
|
#15 0x0000559925e462fd in row_upd_clust_step(upd_node_t*, que_thr_t*) ()
|
#16 0x0000559925e4766d in row_upd_step(que_thr_t*) ()
|
#17 0x0000559925e23217 in row_update_for_mysql(row_prebuilt_t*) ()
|
#18 0x0000559925d6ec3c in ha_innobase::update_row(unsigned char const*, unsigned char const*) ()
|
#19 0x00005599257d39a8 in handler::ha_update_row(unsigned char const*, unsigned char const*) ()
|
#20 0x000055992557c20d in write_record(THD*, TABLE*, st_copy_info*, select_result*) ()
|
#21 0x0000559925585813 in mysql_insert(THD*, TABLE_LIST*, List<Item>&, List<List<Item> >&, List<Item>&, List<Item>&, enum_duplicates, bool, select_result*) ()
|
#22 0x00005599255ae258 in mysql_execute_command(THD*, bool) ()
|
#23 0x00005599255b1f66 in mysql_parse(THD*, char*, unsigned int, Parser_state*) ()
|
#24 0x00005599258caa3d in Query_log_event::do_apply_event(rpl_group_info*, char const*, unsigned int) ()
|
#25 0x00005599258bf083 in Log_event::apply_event(rpl_group_info*) ()
|
#26 0x000055992550bee9 in apply_event_and_update_pos_for_parallel(Log_event*, THD*, rpl_group_info*) ()
|
#27 0x000055992570f2cf in rpt_handle_event(rpl_parallel_thread::queued_event*, rpl_parallel_thread*) [clone .isra.55] ()
|
#28 0x0000559925713edf in handle_rpl_parallel_thread ()
|
#29 0x0000559925ce68ae in pfs_spawn_thread ()
|
#30 0x00007fe1e26c244b in start_thread () from /lib64/libpthread.so.0
|
#31 0x00007fe1e23fd52f in clone () from /lib64/libc.so.6
|
Attachments
Issue Links
- relates to
-
MDEV-35626 Race condition between buf_page_create_low() and read completion
-
- Closed
-