【mysql问题】mysql8.0.18版本莫名宕机切换主从

 

报错信息如下：

2021-01-11T10:42:12.413442+08:00 0 [ERROR] [MY-013183] [InnoDB] Assertion failure: row0pread.cc:727:!page_cur_is_after_last(&page_cursor) thread 139896966547200
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.
02:42:12 UTC - mysqld got signal 6 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
Thread pointer: 0x0
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 = 0 thread_stack 0x30000
/usr/local/mysql80/bin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x2e) [0x1ed6cce]
/usr/local/mysql80/bin/mysqld(handle_fatal_signal+0x323) [0xfb2d23]
/lib64/libpthread.so.0(+0xf5f0) [0x7f3e8959e5f0]
/lib64/libc.so.6(gsignal+0x37) [0x7f3e8765d337]
/lib64/libc.so.6(abort+0x148) [0x7f3e8765ea28]
/usr/local/mysql80/bin/mysqld() [0xd2ef58]
/usr/local/mysql80/bin/mysqld(Parallel_reader::Scan_ctx::start_range(unsigned int, mtr_t*, dtuple_t const*, std::vector<std::pair<unsigned long, buf_block_t*>, ut_allocator<std::pair<unsigned long, buf_block_t*> > >&) const+0x24b) [0x20d94eb]
/usr/local/mysql80/bin/mysqld(Parallel_reader::Scan_ctx::create_ranges(Parallel_reader::Scan_range const&, unsigned int, unsigned long, unsigned long, std::vector<std::pair<std::shared_ptr<Parallel_reader::Scan_ctx::Iter>, std::shared_ptr<Parallel_reader::Scan_ctx::Iter> >, ut_allocator<std::pair<std::shared_ptr<Parallel_reader::Scan_ctx::Iter>, std::shared_ptr<Parallel_reader::Scan_ctx::Iter> > > >&, mtr_t*)+0x706) [0x20db916]
/usr/local/mysql80/bin/mysqld(Parallel_reader::Scan_ctx::create_ranges(Parallel_reader::Scan_range const&, unsigned int, unsigned long, unsigned long, std::vector<std::pair<std::shared_ptr<Parallel_reader::Scan_ctx::Iter>, std::shared_ptr<Parallel_reader::Scan_ctx::Iter> >, ut_allocator<std::pair<std::shared_ptr<Parallel_reader::Scan_ctx::Iter>, std::shared_ptr<Parallel_reader::Scan_ctx::Iter> > > >&, mtr_t*)+0xbae) [0x20dbdbe]
/usr/local/mysql80/bin/mysqld(Parallel_reader::Scan_ctx::partition(Parallel_reader::Scan_range const&, unsigned long)+0x169) [0x20dc429]
/usr/local/mysql80/bin/mysqld(Parallel_reader::Ctx::split()+0x52) [0x20dc7e2]
/usr/local/mysql80/bin/mysqld(Parallel_reader::worker(unsigned long)+0x7d) [0x20dcb1d]
/usr/local/mysql80/bin/mysqld(std::thread::_State_impl<std::thread::_Invoker<std::tuple<Runnable, void (Parallel_reader::*)(unsigned long), Parallel_reader*, unsigned long> > >::_M_run()+0xbc) [0x20d1ccc]
/usr/local/mysql80/bin/mysqld() [0x25d3f0f]
/lib64/libpthread.so.0(+0x7e65) [0x7f3e89596e65]
/lib64/libc.so.6(clone+0x6d) [0x7f3e8772588d]
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.