Description:
we are facing MySQL crashes always with the same error logļ¼
[ERROR] [MY-013183] [InnoDB] Assertion failure: buf0buf.cc:3096:buf_page_in_file(bpage) thread 139857235662592
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
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: http://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
2024-06-25T00:32:17Z UTC - mysqld got signal 6 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
BuildID[sha1]=de067437aaa93eddcdea4f74da1812fc78965373
Thread pointer: 0x7f343945e0b0
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 = 7f330cd9cc50 thread_stack 0x100000
/usr/libexec/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x41) [0x55658a50e2c1]
/usr/libexec/mysqld(print_fatal_signal(int)+0x3c3) [0x556589544fc3]
/usr/libexec/mysqld(my_server_abort()+0x76) [0x5565895450e6]
/usr/libexec/mysqld(my_abort()+0xe) [0x55658a50824e]
/usr/libexec/mysqld(ut_dbg_assertion_failed(char const*, char const*, unsigned long)+0x32a) [0x55658a76fffa]
/usr/libexec/mysqld(buf_page_make_young(buf_page_t*)+0x84) [0x55658a7d5b44]
/usr/libexec/mysqld(Buf_fetch<Buf_fetch_normal>::single_page()+0x22d) [0x55658a7db20d]
/usr/libexec/mysqld(buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, Page_fetch, ut::Location, mtr_t*, bool)+0x1fa) [0x55658a7dbd0a]
/usr/libexec/mysqld(btr_cur_search_to_nth_level(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, unsigned long, btr_cur_t*, unsigned long, char const*, unsigned long, mtr_t*)+0x657) [0x55658a7bb3c7]
/usr/libexec/mysqld(Row_sel_get_clust_rec_for_mysql::operator()(row_prebuilt_t*, dict_index_t*, unsigned char const*, que_thr_t*, unsigned char const**, unsigned long**, mem_block_info_t**, dtuple_t const**, mtr_t*, lob::undo_vers_t*)+0x117) [0x55658a6d6ec7]
/usr/libexec/mysqld(row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long)+0x21c1) [0x55658a6e10f1]
/usr/libexec/mysqld(ha_innobase::general_fetch(unsigned char*, unsigned int, unsigned int)+0x1f8) [0x55658a567478]
/usr/libexec/mysqld(handler::ha_index_next_same(unsigned char*, unsigned char const*, unsigned int)+0x76) [0x556589653fd6]
/usr/libexec/mysqld(RefIterator<false>::Read()+0x106) [0x55658991d2a6]
/usr/libexec/mysqld(FilterIterator::Read()+0x18) [0x55658990b8e8]
/usr/libexec/mysqld(filesort(THD*, Filesort*, RowIterator*, unsigned long, unsigned long long, Filesort_info*, Sort_result*, unsigned long long*)+0x8c8) [0x5565896399e8]
/usr/libexec/mysqld(SortingIterator::DoSort()+0x72) [0x5565897a3e72]
/usr/libexec/mysqld(SortingIterator::Init()+0x34) [0x5565897a3f04]
/usr/libexec/mysqld(Query_expression::ExecuteIteratorQuery(THD*)+0x322) [0x5565894aec62]
/usr/libexec/mysqld(Query_expression::execute(THD*)+0x2d) [0x5565894aef6d]
/usr/libexec/mysqld(Sql_cmd_dml::execute(THD*)+0x31c) [0x55658943a1ac]
/usr/libexec/mysqld(mysql_execute_command(THD*, bool)+0xcad) [0x5565893d54fd]
/usr/libexec/mysqld(dispatch_sql_command(THD*, Parser_state*)+0x46b) [0x5565893d8f9b]
/usr/libexec/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x2288) [0x5565893db858]
/usr/libexec/mysqld(do_command(THD*)+0x207) [0x5565893dc8e7]
/usr/libexec/mysqld(+0x11a7928) [0x556589535928]
/usr/libexec/mysqld(+0x269e8fa) [0x55658aa2c8fa]
/lib64/libpthread.so.0(+0x81ca) [0x7f3493bb31ca]
/lib64/libc.so.6(clone+0x43) [0x7f348ec28e73]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (7f343981b570): is an invalid pointer
Connection ID (thread ID): 417847
Status: NOT_KILLED
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
How to repeat:
Unfortunately i can't provide an exact path, but everytime the restarted logs is the same.
Suggested fix:
The MySQL should not frequently restarted unexpectedly.
