2022-05-02 18:20:14 1691406 [ERROR] InnoDB: Probable data corruption on page 519096. Original record on that page;
|
(compact record)2022-05-02 18:20:14 1691406 [ERROR] InnoDB: Cannot find the dir slot for this record on that page;
|
(compact record)2022-05-02 18:20:14 0x7f908931c700 InnoDB: Assertion failure in file /builddir/build/BUILD/mariadb-10.5.9/storage/innobase/page/page0page.cc line 138
|
|
The loop failure log is bellow:
|
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 mysqld 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.
|
220502 18:20:14 [ERROR] mysqld got signal 6 ;
|
This could be because you hit a bug. It is also possible that this binary
|
or one of the libraries it was linked against is corrupt, improperly built,
|
or misconfigured. This error can also be caused by malfunctioning hardware.
|
|
To report this bug, see https://mariadb.com/kb/en/reporting-bugs
|
|
We will try our best to scrape up some info that will hopefully help
|
diagnose the problem, but since we have already crashed,
|
something is definitely wrong and this may fail.
|
|
Server version: 10.5.9-MariaDB
|
key_buffer_size=402653184
|
read_buffer_size=2097152
|
max_used_connections=77
|
max_threads=302
|
thread_count=14
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 5967331 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
|
Thread pointer: 0x7f8f88071c48
|
Attempting backtrace. You can use the following information to find out
|
where mysqld died. If you see no messages after this, something went
|
terribly wrong...
|
stack_bottom = 0x7f908931bbd8 thread_stack 0x49000
|
??:0(my_print_stacktrace)[0x55b67cf70171]
|
??:0(handle_fatal_signal)[0x55b67ca18115]
|
sigaction.c:0(__restore_rt)[0x7f91b4904c20]
|
:0(__GI_raise)[0x7f91b269f37f]
|
:0(__GI_abort)[0x7f91b2689db5]
|
??:0(wsrep_write_dummy_event_low(THD*, char const*))[0x55b67c70990a]
|
??:0(wsrep_write_dummy_event_low(THD*, char const*))[0x55b67c6f0b34]
|
??:0(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > __gnu_cxx::__to_xstring<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, char>(int (*)(c
|
har*, unsigned long, char const*, __va_list_tag*), unsigned long, char const*, ...))[0x55b67cd53df8]
|
??:0(wsrep_notify_status(wsrep::server_state::state, wsrep::view const*))[0x55b67cd2187a]
|
??:0(wsrep_notify_status(wsrep::server_state::state, wsrep::view const*))[0x55b67cd2610c]
|
??:0(std::_Rb_tree<unsigned int, unsigned int, std::_Identity<unsigned int>, std::less<unsigned int>, std::allocator<unsigned int> >::_M_erase(std::_Rb_tree_node<unsigned int>*))[0x55b67ce53609]
|
??:0(std::_Rb_tree<unsigned int, unsigned int, std::_Identity<unsigned int>, std::less<unsigned int>, std::allocator<unsigned int> >::_M_erase(std::_Rb_tree_node<unsigned int>*))[0x55b67ce5369e]
|
??:0(std::_Rb_tree<unsigned int, unsigned int, std::_Identity<unsigned int>, std::less<unsigned int>, std::allocator<unsigned int> >::_M_erase(std::_Rb_tree_node<unsigned int>*))[0x55b67ce33107]
|
??:0(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > __gnu_cxx::__to_xstring<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, char>(int (*)(c
|
har*, unsigned long, char const*, __va_list_tag*), unsigned long, char const*, ...))[0x55b67cdb7992]
|
??:0(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > __gnu_cxx::__to_xstring<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, char>(int (*)(c
|
har*, unsigned long, char const*, __va_list_tag*), unsigned long, char const*, ...))[0x55b67cdb7a7e]
|
??:0(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > __gnu_cxx::__to_xstring<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, char>(int (*)(c
|
har*, unsigned long, char const*, __va_list_tag*), unsigned long, char const*, ...))[0x55b67cdc81e3]
|
??:0(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > __gnu_cxx::__to_xstring<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, char>(int (*)(c
|
har*, unsigned long, char const*, __va_list_tag*), unsigned long, char const*, ...))[0x55b67cdc8e57]
|
??:0(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > __gnu_cxx::__to_xstring<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, char>(int (*)(c
|
har*, unsigned long, char const*, __va_list_tag*), unsigned long, char const*, ...))[0x55b67cda3304]
|
??:0(wsrep_notify_status(wsrep::server_state::state, wsrep::view const*))[0x55b67ccebd16]
|
??:0(handler::ha_update_row(unsigned char const*, unsigned char const*))[0x55b67ca25d82]
|
??:0(mysql_update(THD*, TABLE_LIST*, List<Item>&, List<Item>&, Item*, unsigned int, st_order*, unsigned long long, bool, unsigned long long*, unsigned long long*))[0x55b67c8d42f5]
|
??:0(mysql_execute_command(THD*))[0x55b67c82961f]
|
??:0(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55b67c81b5ba]
|
??:0(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55b67c826755]
|
??:0(do_command(THD*))[0x55b67c827734]
|
??:0(do_handle_one_connection(CONNECT*, bool))[0x55b67c916268]
|
??:0(handle_one_connection)[0x55b67c91666d]
|
??:0(MyCTX_nopad::finish(unsigned char*, unsigned int*))[0x55b67cc3bb6f]
|
pthread_create.c:0(start_thread)[0x7f91b48fa17a]
|
:0(__GI___clone)[0x7f91b2764dc3]
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x7f8f8801e1e0): update feed308_buffer set Id = Id+15500070
|
|
Connection ID (thread ID): 1691406
|
Status: NOT_KILLED
|
|
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,deriv
|
ed_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,exi
|
sts_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
|
|
The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains
|
information that should help you find out what is causing the crash.
|
Writing a core file...
|
Working directory at /var/lib/mysql
|
Resource Limits:
|
Limit Soft Limit Hard Limit Units
|
Max cpu time unlimited unlimited seconds
|
Max file size unlimited unlimited bytes
|
Max data size unlimited unlimited bytes
|
Max stack size 8388608 unlimited bytes
|
Max core file size 0 unlimited bytes
|
Max resident set unlimited unlimited bytes
|
Max processes 63030 63030 processes
|
Max open files 8531 8531 files
|
Max locked memory 65536 65536 bytes
|
Max address space unlimited unlimited bytes
|
Max file locks unlimited unlimited locks
|
Max pending signals 63030 63030 signals
|
Max msgqueue size 819200 819200 bytes
|
Max nice priority 0 0
|
Max realtime priority 0 0
|
Max realtime timeout unlimited unlimited us
|
Core pattern: |/usr/lib/systemd/systemd-coredump %P %u %g %s %t %c %h %e
|