Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-37103

innodb_immediate_scrub_data_uncompressed=ON may break innodb_undo_log_truncate=ON

    XMLWordPrintable

Details

    • Can result in hang or crash
    • InnoDB could crash when innodb_immediate_scrub_data_uncompressed=ON and innodb_undo_log_truncate=ON were enabled at the same time.

    Description

      innodb.undo_truncate fails with this message, from time to time, on many (mostly on slow) builders,
      here is the evidence

      A fresh stacktrace example from https://buildbot.mariadb.org/#/builders/534/builds/28504/steps/6/logs/stdio

      #6  0x00007fb83f9857f3 in abort () from /lib/x86_64-linux-gnu/libc.so.6
      #7  0x0000556f838b83e6 in fil_invalid_page_access_msg (name=0x556f86e1ede8 ".//undo002", offset=7004160, len=8192, is_read=false) at /home/buildbot/amd64-ubuntu-2204-debug-ps/build/storage/innobase/fil/fil0fil.cc:2765
      #8  0x0000556f838b8d3c in fil_space_t::io (this=0x556f8739b068, type=..., offset=7004160, len=8192, buf=0x556f872f3000, bpage=0x0) at /home/buildbot/amd64-ubuntu-2204-debug-ps/build/storage/innobase/fil/fil0fil.cc:2840
      #9  0x0000556f83834488 in fil_space_t::flush_freed (this=0x556f8739b068, writable=true) at /home/buildbot/amd64-ubuntu-2204-debug-ps/build/storage/innobase/buf/buf0flu.cc:1000
      #10 0x0000556f838352c5 in buf_flush_space (id=9) at /home/buildbot/amd64-ubuntu-2204-debug-ps/build/storage/innobase/buf/buf0flu.cc:1184
      #11 0x0000556f838369b7 in buf_do_flush_list_batch (max_n=67, lsn=18446744073709551615) at /home/buildbot/amd64-ubuntu-2204-debug-ps/build/storage/innobase/buf/buf0flu.cc:1499
      #12 0x0000556f838371bc in buf_flush_list_holding_mutex (max_n=67, lsn=18446744073709551615) at /home/buildbot/amd64-ubuntu-2204-debug-ps/build/storage/innobase/buf/buf0flu.cc:1599
      #13 0x0000556f8383ae01 in buf_flush_page_cleaner () at /home/buildbot/amd64-ubuntu-2204-debug-ps/build/storage/innobase/buf/buf0flu.cc:2711
      #14 0x0000556f8383f39b in std::__invoke_impl<void, void (*)() noexcept>(std::__invoke_other, void (*&&)() noexcept) (__f=@0x556f8735d6e8: 0x556f8383a0bd <buf_flush_page_cleaner()>) at /usr/include/c++/11/bits/invoke.h:61
      #15 0x0000556f8383f347 in std::__invoke<void (*)() noexcept>(void (*&&)() noexcept) (__fn=@0x556f8735d6e8: 0x556f8383a0bd <buf_flush_page_cleaner()>) at /usr/include/c++/11/bits/invoke.h:96
      #16 0x0000556f8383f2e8 in std::thread::_Invoker<std::tuple<void (*)() noexcept> >::_M_invoke<0ul>(std::_Index_tuple<0ul>) (this=0x556f8735d6e8) at /usr/include/c++/11/bits/std_thread.h:259
      #17 0x0000556f8383f2b8 in std::thread::_Invoker<std::tuple<void (*)() noexcept> >::operator()() (this=0x556f8735d6e8) at /usr/include/c++/11/bits/std_thread.h:266
      #18 0x0000556f8383f298 in std::thread::_State_impl<std::thread::_Invoker<std::tuple<void (*)() noexcept> > >::_M_run() (this=0x556f8735d6e0) at /usr/include/c++/11/bits/std_thread.h:211
      #19 0x00007fb83fd6b253 in ?? () from /lib/x86_64-linux-gnu/libstdc++.so.6
      

      Attachments

        Issue Links

          Activity

            People

              marko Marko Mäkelä
              wlad Vladislav Vaintroub
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.