Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-8292

MySQL 8.0.29 fails to perform crash recovery

Details

    • Bug
    • Status: Done
    • High
    • Resolution: Fixed
    • 8.0.29-21 (Q2 2022)
    • 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

      Attachments

        Activity

          People

            satya.bodapati Satya Bodapati
            mohit.joshi Mohit Joshi
            Votes:
            1 Vote for this issue
            Watchers:
            8 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - Not Specified
                Not Specified
                Logged:
                Time Spent - 2 days, 2 hours
                2d 2h

                Smart Checklist