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

lsn_t log_t::write_checkpoint(lsn_t, lsn_t): Assertion `current_lsn < archive_header_was_reset' failed

    XMLWordPrintable

Details

    • Can result in hang or crash

    Description

      CLI compatible test case

      SET GLOBAL innodb_log_archive=ON;
      SET GLOBAL innodb_file_per_table=0;
      CREATE TABLE t1 (b VARCHAR(8000)) STATS_PERSISTENT=0;
      SET GLOBAL innodb_trx_purge_view_update_only_debug=ON;
      SET GLOBAL debug_dbug='+d,ib_log_checkpoint_avoid';
      SET debug_dbug='+d,skip_page_checksum';
      INSERT INTO t1 SELECT REPEAT('x', 8000) FROM seq_1_to_10000;
      SET GLOBAL innodb_log_checkpoint_now=ON;
      DELIMITER //
      BEGIN NOT ATOMIC
        WHILE (@r:= 2 * @@innodb_log_file_size - 12304 - (SELECT variable_value FROM information_schema.global_status WHERE variable_name='INNODB_LSN_CURRENT')) >= 3000 DO
          INSERT INTO t1 VALUES (REPEAT('x', LEAST(8000, @r - 2500)));
        END WHILE;
        WHILE @r > @r MOD 10 * 11 DO SET GLOBAL innodb_fil_make_page_dirty_debug=0, @r=@r-10; END WHILE;
        SET GLOBAL innodb_saved_page_number_debug=1000;
        WHILE @r > 0 DO SET GLOBAL innodb_fil_make_page_dirty_debug=0, @r=@r-11; END WHILE;
      END//
      DELIMITER ;
      SET GLOBAL debug_dbug='';
      check table t1 ;
      

      Leads to:

      CS 13.0.2 620a4b5624222048fece7fe1789978ae0675cae2 (Debug, Clang 22.1.8-20260621) Build 25/09/2026

      mariadbd: /test/13.0_dbg/storage/innobase/buf/buf0flu.cc:1944: lsn_t log_t::write_checkpoint(lsn_t, lsn_t): Assertion `current_lsn < archive_header_was_reset' failed.
      

      CS 13.0.2 620a4b5624222048fece7fe1789978ae0675cae2 (Debug, Clang 22.1.8-20260621) Build 25/09/2026

      Core was generated by `/test/MD250926-mariadb-13.0.2-linux-x86_64-dbg/bin/mariadbd --no-defaults --loo'.
      Program terminated with signal SIGABRT, Aborted.
      #0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
       
      [Current thread is 1 (LWP 979056)]
      (gdb) bt
      #0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
      #1  __pthread_kill_internal (signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:78
      #2  __GI___pthread_kill (threadid=<optimized out>, signo=signo@entry=6)at ./nptl/pthread_kill.c:89
      #3  0x00007a24e8c4527e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
      #4  0x00007a24e8c288ff in __GI_abort () at ./stdlib/abort.c:79
      #5  0x00007a24e8c2881b in __assert_fail_base (fmt=0x7a24e8dd1208 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x6490d697b4bd "current_lsn < archive_header_was_reset", file=file@entry=0x6490d697a0b5 "/test/13.0_dbg/storage/innobase/buf/buf0flu.cc", line=line@entry=1944, function=function@entry=0x6490d697b1e6 "lsn_t log_t::write_checkpoint(lsn_t, lsn_t)") at ./assert/assert.c:96
      #6  0x00007a24e8c3b517 in __assert_fail (assertion=0x6490d697b4bd "current_lsn < archive_header_was_reset", file=0x6490d697a0b5 "/test/13.0_dbg/storage/innobase/buf/buf0flu.cc", line=1944, function=0x6490d697b1e6 "lsn_t log_t::write_checkpoint(lsn_t, lsn_t)")at ./assert/assert.c:105
      #7  0x00006490d62fcd12 in log_t::write_checkpoint (this=0x6490d7ce0a80 <log_sys>, checkpoint=200675242, end_lsn=201314288)at /test/13.0_dbg/storage/innobase/buf/buf0flu.cc:1944
      #8  0x00006490d62f7571 in log_checkpoint_low (oldest_lsn=200675242, end_lsn=201314288) at /test/13.0_dbg/storage/innobase/buf/buf0flu.cc:2270
      #9  0x00006490d62f59cc in log_checkpoint ()at /test/13.0_dbg/storage/innobase/buf/buf0flu.cc:2324
      #10 0x00006490d62f3abc in buf_flush_page_cleaner ()at /test/13.0_dbg/storage/innobase/buf/buf0flu.cc:2887
      #11 0x00006490d62ffc82 in std::__invoke_impl<void, void (*)() noexcept>(std::__invoke_other, void (*&&)() noexcept) (__f=@0x6490e1617248: 0x6490d62f34a0 <buf_flush_page_cleaner()>)at /usr/lib/gcc/x86_64-linux-gnu/13/../../../../include/c++/13/bits/invoke.h:61
      #12 0x00006490d62ffc35 in std::__invoke<void (*)() noexcept>(void (*&&)() noexcept) (__fn=@0x6490e1617248: 0x6490d62f34a0 <buf_flush_page_cleaner()>)at /usr/lib/gcc/x86_64-linux-gnu/13/../../../../include/c++/13/bits/invoke.h:96
      #13 0x00006490d62ffc0d in std::thread::_Invoker<std::tuple<void (*)() noexcept> >::_M_invoke<0ul>(std::_Index_tuple<0ul>) (this=0x6490e1617248)at /usr/lib/gcc/x86_64-linux-gnu/13/../../../../include/c++/13/bits/std_thread.h:292
      #14 0x00006490d62ffbe5 in std::thread::_Invoker<std::tuple<void (*)() noexcept> >::operator()() (this=0x6490e1617248)at /usr/lib/gcc/x86_64-linux-gnu/13/../../../../include/c++/13/bits/std_thread.h:299
      #15 0x00006490d62ffb49 in std::thread::_State_impl<std::thread::_Invoker<std::tuple<void (*)() noexcept> > >::_M_run() (this=0x6490e1617240)at /usr/lib/gcc/x86_64-linux-gnu/13/../../../../include/c++/13/bits/std_thread.h:244
      #16 0x00007a24e90ecdb4 in ?? () from /lib/x86_64-linux-gnu/libstdc++.so.6
      #17 0x00007a24e8c9cb84 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
      #18 0x00007a24e8d29ecc in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
      

      Bug Detection Matrix

          Rel    o/d  Build   Commit                                    UniqueID observed             
      CS  10.11  dbg  250926  307a82c97316ea0ed3fde318d19c0770ab898d89  No bug found                  
      CS  10.11  opt  250926  307a82c97316ea0ed3fde318d19c0770ab898d89  No bug found                  
      CS  11.4   dbg  250926  511d7527eb356aab52fa183456333c5ba9741bcf  No bug found                  
      CS  11.4   opt  250926  511d7527eb356aab52fa183456333c5ba9741bcf  No bug found                  
      CS  11.8   dbg  250926  e87b958d2e411af8e088d1716f99d06534e932f3  No bug found                  
      CS  11.8   opt  250926  e87b958d2e411af8e088d1716f99d06534e932f3  No bug found                  
      CS  12.3   dbg  250926  881b64e8add374802e1871814dd0a3a673a9b3e6  No bug found                  
      CS  12.3   opt  250926  881b64e8add374802e1871814dd0a3a673a9b3e6  No bug found                  
      CS  13.0   dbg  250926  620a4b5624222048fece7fe1789978ae0675cae2  current_lsn < archive_header_was_reset|SIGABRT|log_t::write_checkpoint|log_checkpoint_low|log_checkpoint|buf_flush_page_cleaner
      CS  13.0   opt  250926  620a4b5624222048fece7fe1789978ae0675cae2  No bug found                  
      CS  13.2   dbg  250926  45717ef4c736a6a92e0acf49399ce677bfcaea89  current_lsn < archive_header_was_reset|SIGABRT|log_t::write_checkpoint|log_checkpoint_low|log_checkpoint|buf_flush_page_cleaner
      CS  13.2   opt  250926  45717ef4c736a6a92e0acf49399ce677bfcaea89  No bug found                  
      ES  10.6   dbg  250926  aa3fb9800c358182ee2a1f8cca8ffbdd6d0a37eb  !thd || !coordinator_thd|SIGABRT|purge_sys_t::clone_oldest_view<false>|trx_purge|purge_coordinator_state::do_purge|purge_coordinator_callback
      ES  10.6   opt  250926  aa3fb9800c358182ee2a1f8cca8ffbdd6d0a37eb  No bug found                  
      ES  11.4   dbg  250926  5fa1ee1c7342644dda74ff137ff55c4df79939cf  No bug found                  
      ES  11.4   opt  250926  5fa1ee1c7342644dda74ff137ff55c4df79939cf  No bug found                  
      ES  11.8   dbg  250926  1eae6f8f0c743cbff67675ae3e5cf9d25a5d8f61  No bug found                  
      ES  11.8   opt  250926  1eae6f8f0c743cbff67675ae3e5cf9d25a5d8f61  No bug found                  
      ES  12.3   dbg  250926  f46597716bc5fbf9081c0fa17bd3e0d6c9e9db1d  No bug found                  
      ES  12.3   opt  250926  f46597716bc5fbf9081c0fa17bd3e0d6c9e9db1d  No bug found                  
      

      Attachments

        Issue Links

          Activity

            People

              marko Marko Mäkelä
              saahil Saahil Alam
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - 0d
                  0d
                  Remaining:
                  Time Spent - 0.25d Remaining Estimate - 1.5d
                  1.5d
                  Logged:
                  Time Spent - 0.25d Remaining Estimate - 1.5d
                  0.25d

                  Git Integration

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