InnoDB: FIL_PAGE_TYPE=18463 on BLOB read file

mariadb crash

possibly related to MDEV-23992

the statement being executed is not known

after mariadb restarted, the table impacted did not lose data

table reported in the crash log (anonymized):

Create Table: CREATE TABLE `tablename` (
`id_column` int(11) NOT NULL,
`payload_column` text DEFAULT NULL ,
PRIMARY KEY (`id_column`),
CONSTRAINT `constraint_name` FOREIGN KEY (`id_column`) REFERENCES `other_table` (`other_id_column`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci

payload_column length was 12k average, 29k max

crash log (anonymized):

Jun 25 08:43:44 HOSTNAME mariadbd[208519]: 2025-06-25 8:43:44 98029 [ERROR] [FATAL] InnoDB: FIL_PAGE_TYPE=18463 on BLOB read file ./dbname/tablename.ibd page 20690
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: 250625 8:43:44 [ERROR] mysqld got signal 6 ;
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: This could be because you hit a bug. It is also possible that this binary
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: or one of the libraries it was linked against is corrupt, improperly built,
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: or misconfigured. This error can also be caused by malfunctioning hardware.
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: We will try our best to scrape up some info that will hopefully help
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: diagnose the problem, but since we have already crashed,
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: something is definitely wrong and this may fail.
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: Server version: 10.5.19-MariaDB-0+deb11u2 source revision: f8a85af8ca1c937b8d4f847477bd282f80251cde
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: key_buffer_size=134217728
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: read_buffer_size=131072
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: max_used_connections=249
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: max_threads=502
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: thread_count=249
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: It is possible that mysqld could use up to
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 1236215 K bytes of memory
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: Hope that's ok; if not, decrease some variables in the equation.
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: Thread pointer: 0x7fcf7c082728
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: Attempting backtrace. You can use the following information to find out
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: where mysqld died. If you see no messages after this, something went
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: terribly wrong...
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: stack_bottom = 0x7fcf70ae2d78 thread_stack 0x49000
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: /usr/sbin/mariadbd(my_print_stacktrace+0x2e)[0x558d911a016e]
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: Printing to addr2line failed
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: /usr/sbin/mariadbd(handle_fatal_signal+0x485)[0x558d90c98f45]
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: /lib/x86_64-linux-gnu/libpthread.so.0(+0x13140)[0x7fd048e54140]
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x141)[0x7fd04898cce1]
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: /lib/x86_64-linux-gnu/libc.so.6(abort+0x123)[0x7fd048976537]
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: /usr/sbin/mariadbd(+0x646205)[0x558d90978205]
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: /usr/sbin/mariadbd(+0x649059)[0x558d9097b059]
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: /usr/sbin/mariadbd(+0xd6195d)[0x558d9109395d]
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: /usr/sbin/mariadbd(+0xd6ddf6)[0x558d9109fdf6]
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: /usr/sbin/mariadbd(+0xd0a17a)[0x558d9103c17a]
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: /usr/sbin/mariadbd(+0xd0a59c)[0x558d9103c59c]
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: /usr/sbin/mariadbd(+0xd1045c)[0x558d9104245c]
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: /usr/sbin/mariadbd(+0xc52812)[0x558d90f84812]
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: /usr/sbin/mariadbd(_ZN7handler18index_read_idx_mapEPhjPKhm16ha_rkey_function+0x73)[0x558d90c9b113]
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: /usr/sbin/mariadbd(_ZN7handler21ha_index_read_idx_mapEPhjPKhm16ha_rkey_function+0x2df)[0x558d90c9eeff]
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: /usr/sbin/mariadbd(+0x7bbf09)[0x558d90aedf09]
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: /usr/sbin/mariadbd(+0x7bc058)[0x558d90aee058]
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: /usr/sbin/mariadbd(_ZN4JOIN14optimize_innerEv+0x22e0)[0x558d90b01b30]
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: /usr/sbin/mariadbd(_ZN4JOIN8optimizeEv+0xa0)[0x558d90b03300]
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: /usr/sbin/mariadbd(_Z12mysql_selectP3THDP10TABLE_LISTR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0xb3)[0x558d90b033d3]
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: /usr/sbin/mariadbd(_Z13handle_selectP3THDP3LEXP13select_resultm+0x138)[0x558d90b03e98]
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: /usr/sbin/mariadbd(+0x761d91)[0x558d90a93d91]
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: /usr/sbin/mariadbd(_Z21mysql_execute_commandP3THD+0x3d7b)[0x558d90aa0abb]
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: /usr/sbin/mariadbd(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x20b)[0x558d90aa1f6b]
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: /usr/sbin/mariadbd(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0xd9d)[0x558d90aa3d2d]
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: /usr/sbin/mariadbd(_Z10do_commandP3THD+0x120)[0x558d90aa5c70]
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: /usr/sbin/mariadbd(_Z24do_handle_one_connectionP7CONNECTb+0x2f2)[0x558d90b996c2]
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: /usr/sbin/mariadbd(handle_one_connection+0x5d)[0x558d90b9993d]
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: /usr/sbin/mariadbd(+0xba775b)[0x558d90ed975b]
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: /lib/x86_64-linux-gnu/libpthread.so.0(+0x7ea7)[0x7fd048e48ea7]
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: /lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7fd048a4fa2f]
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: Trying to get some variables.
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: Some pointers may be invalid and cause the dump to abort.
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: Query (0x7fcf7c098eb0): SELECT dv.inventory_json AS inventory_json FROM device_inventory_values dv WHERE dv.id_column = 16636 LIMIT 1
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: Connection ID (thread ID): 98029
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: Status: NOT_KILLED
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on,not_null_range_scan=off
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: information that should help you find out what is causing the crash.
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: Writing a core file...
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: Working directory at /var/lib/mysql
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: Resource Limits:
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: Limit Soft Limit Hard Limit Units
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: Max cpu time unlimited unlimited seconds
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: Max file size unlimited unlimited bytes
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: Max data size unlimited unlimited bytes
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: Max stack size 8388608 unlimited bytes
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: Max core file size 0 unlimited bytes
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: Max resident set unlimited unlimited bytes
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: Max processes 31685 31685 processes
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: Max open files 32768 32768 files

Jun 25 08:43:44 HOSTNAME mariadbd[208519]: Max locked memory 65536 65536 bytes
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: Max address space unlimited unlimited bytes
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: Max file locks unlimited unlimited locks
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: Max pending signals 31685 31685 signals
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: Max msgqueue size 819200 819200 bytes
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: Max nice priority 0 0
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: Max realtime priority 0 0
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: Max realtime timeout unlimited unlimited us
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: Core pattern: core
Jun 25 08:43:44 HOSTNAME mariadbd[208519]: Kernel version: Linux version 5.10.0-19-amd64 (debian-kernel@lists.debian.org) (gcc-10 (Debian 10.2.1-6) 10.2.1 20210110, GNU ld (GNU Binutils for Debian) 2.35.2) #1 SMP Debian 5.10.149-2 (2022-10-21)
Jun 25 08:43:45 HOSTNAME systemd[1]: mariadb.service: Main process exited, code=killed, status=6/ABRT
Jun 25 08:43:45 HOSTNAME systemd[1]: mariadb.service: Failed with result 'signal'.
Jun 25 08:43:45 HOSTNAME systemd[1]: mariadb.service: Consumed 1w 2d 19h 57min 46.633s CPU time.