Details
-
Bug
-
Status: Done
-
High
-
Resolution: Fixed
-
8.0.29-21 (Q2 2022)
-
None
-
None
Description
MySQL 8.0.29 fails to perform crash recovery. Below is the stack trace seen
Assertion failure: rem0lrec.h:316:len2 == len thread 139790809937664 #0 __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56 #1 0x0000558cb5d976c8 in my_write_core (sig=6) at /home/mohit.joshi/upstream-8.0/mysys/stacktrace.cc:295 #2 0x0000558cb4812984 in handle_fatal_signal (sig=6) at /home/mohit.joshi/upstream-8.0/sql/signal_handler.cc:202 #3 <signal handler called> #4 __GI_raise ([email protected]=6) at ../sysdeps/unix/sysv/linux/raise.c:50 #5 0x00007f23a9a5f859 in __GI_abort () at abort.c:79 #6 0x0000558cb4812b0d in my_server_abort () at /home/mohit.joshi/upstream-8.0/sql/signal_handler.cc:258 #7 0x0000558cb5d8dacc in my_abort () at /home/mohit.joshi/upstream-8.0/mysys/my_init.cc:258 #8 0x0000558cb625f34a in ut_dbg_assertion_failed (expr=0x558cb81524a3 "len2 == len", file=0x558cb8152300 "/home/mohit.joshi/upstream-8.0/storage/innobase/include/rem0lrec.h", line=316) at /home/mohit.joshi/upstream-8.0/storage/innobase/ut/ut0dbg.cc:99 #9 0x0000558cb60e7929 in rec_set_nth_field_low (rec=0x7f238da843b7 "", offsets=0x7f2370002ed8, n=8, data=0x7f2370001a78, len=9) at /home/mohit.joshi/upstream-8.0/storage/innobase/include/rem0lrec.h:316 #10 0x0000558cb60e8515 in rec_set_nth_field (index=0x7f2370001558, rec=0x7f238da843b7 "", offsets=0x7f2370002ed8, n=8, data=0x7f2370001a78, len=9) at /home/mohit.joshi/upstream-8.0/storage/innobase/rem/rem0wrec.cc:134 #11 0x0000558cb6190351 in row_upd_rec_in_place (rec=0x7f238da843b7 "", index=0x7f2370001558, offsets=0x7f2370002ed8, update=0x7f2370001998, page_zip=0x0) at /home/mohit.joshi/upstream-8.0/storage/innobase/row/row0upd.cc:531 #12 0x0000558cb62e13b2 in btr_cur_parse_update_in_place (ptr=0x7f238c2c6f67 "", end_ptr=0x7f238c2c6f67 "", page=0x7f238da84000 "", page_zip=0x0, index=0x7f2370001558) at /home/mohit.joshi/upstream-8.0/storage/innobase/btr/btr0cur.cc:3243 #13 0x0000558cb604aa81 in recv_parse_or_apply_log_rec_body (type=MLOG_REC_UPDATE_IN_PLACE, ptr=0x7f238c2c6f4a "\002\001\002", end_ptr=0x7f238c2c6f67 "", space_id=301, page_no=4, block=0x7f2387e5efc8, mtr=0x7f239591a1b0, parsed_bytes=18446744073709551615, start_lsn=9223372036854775807) at /home/mohit.joshi/upstream-8.0/storage/innobase/log/log0recv.cc:2107 #14 0x0000558cb604d18b in recv_recover_page_func (just_read_in=true, block=0x7f2387e5efc8) at /home/mohit.joshi/upstream-8.0/storage/innobase/log/log0recv.cc:2837 #15 0x0000558cb62fefce in recv_recover_page (jri=true, block=0x7f2387e5efc8) at /home/mohit.joshi/upstream-8.0/storage/innobase/include/log0recv.h:185 #16 0x0000558cb6310e87 in buf_page_io_complete (bpage=0x7f2387e5efc8, evict=false) at /home/mohit.joshi/upstream-8.0/storage/innobase/buf/buf0buf.cc:5633 #17 0x0000558cb6494483 in fil_aio_wait (segment=4) at /home/mohit.joshi/upstream-8.0/storage/innobase/fil/fil0fil.cc:8277 #18 0x0000558cb61ba7cc in io_handler_thread (segment=4) at /home/mohit.joshi/upstream-8.0/storage/innobase/srv/srv0start.cc:279 #19 0x0000558cb61d5afc in std::__invoke_impl<void, void (*&)(unsigned long), unsigned long&> ([email protected]: 0x558cb61ba772 <io_handler_thread(ulint)>) at /usr/include/c++/9/bits/invoke.h:60 #20 0x0000558cb61d5a53 in std::__invoke<void (*&)(unsigned long), unsigned long&> ([email protected]: 0x558cb61ba772 <io_handler_thread(ulint)>) at /usr/include/c++/9/bits/invoke.h:95 #21 0x0000558cb61d5999 in std::_Bind<void (*(unsigned long))(unsigned long)>::__call<void, , 0ul>(std::tuple<>&&, std::_Index_tuple<0ul>) (this=0x7f239591ab70, __args=...) at /usr/include/c++/9/functional:400 #22 0x0000558cb61d58d1 in std::_Bind<void (*(unsigned long))(unsigned long)>::operator()<, void>() (this=0x7f239591ab70) at /usr/include/c++/9/functional:484 #23 0x0000558cb61d5809 in Detached_thread::operator()<void (*)(unsigned long), unsigned long> (this=0x7f23983e66b8, [email protected]: 0x558cb61ba772 <io_handler_thread(ulint)>) at /home/mohit.joshi/upstream-8.0/storage/innobase/include/os0thread-create.h:193 #24 0x0000558cb61d56e3 in std::__invoke_impl<void, Detached_thread, void (*)(unsigned long), unsigned long> (__f=...) at /usr/include/c++/9/bits/invoke.h:60 #25 0x0000558cb61d561a in std::__invoke<Detached_thread, void (*)(unsigned long), unsigned long> (__fn=...) at /usr/include/c++/9/bits/invoke.h:95 #26 0x0000558cb61d5539 in std::thread::_Invoker<std::tuple<Detached_thread, void (*)(unsigned long), unsigned long> >::_M_invoke<0ul, 1ul, 2ul> (this=0x7f23983e66a8) at /usr/include/c++/9/thread:244 #27 0x0000558cb61d54d4 in std::thread::_Invoker<std::tuple<Detached_thread, void (*)(unsigned long), unsigned long> >::operator() (this=0x7f23983e66a8) at /usr/include/c++/9/thread:251 #28 0x0000558cb61d54b4 in std::thread::_State_impl<std::thread::_Invoker<std::tuple<Detached_thread, void (*)(unsigned long), unsigned long> > >::_M_run (this=0x7f23983e66a0) at /usr/include/c++/9/thread:195 #29 0x00007f23a9e6fde4 in ?? () from /lib/x86_64-linux-gnu/libstdc++.so.6 #30 0x00007f23a9f83609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #31 0x00007f23a9b5c163 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95