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

dberr_t recv_sys_t::find_checkpoint_archived(lsn_t, bool): Assertion `!silent' failed

    XMLWordPrintable

Details

    • Can result in hang or crash

    Description

      --source include/have_innodb.inc
      --source include/have_debug.inc
      --source include/have_sequence.inc
       
      --disable_query_log
      call mtr.add_suppression("InnoDB: Did not find innodb_log_recovery_start=");
      --enable_query_log
       
      CREATE TABLE t1(a INT PRIMARY KEY AUTO_INCREMENT, b VARCHAR(200)) ENGINE=InnoDB;
      SET GLOBAL innodb_log_archive=1;
       
      # Force the 4M (minimum) redo log to roll over into several archived
      # ib_<lsn>.log files, so that a later restart's recovery-start LSN will
      # fall inside a non-first archive file.
      --disable_query_log
      let $i=0;
      while ($i < 8)
      {
        INSERT INTO t1(b) SELECT REPEAT('y',180) FROM seq_1_to_3000;
        SET GLOBAL innodb_log_checkpoint_now=ON;
        inc $i;
      }
      --enable_query_log
       
      let $lsn= query_get_value(SHOW STATUS LIKE 'Innodb_lsn_current', Value, 1);
       
      --source include/shutdown_mysqld.inc
      --let $restart_parameters= --innodb-log-recovery-start=$lsn
      --source include/start_mysqld.inc
       
      SELECT COUNT(*) FROM t1;
      DROP TABLE t1;
      SET GLOBAL innodb_log_archive=0;
      

      Command to start the test

      ./mtr test --mysqld=--innodb-log-file-size=4194304
      

      Leads to :-

      CS 13.0.2 b2c4e675049e23ce8c7346985f40840fcd4e583f (Debug, Clang 22.1.8-20260621) Build 09/09/2026

      mariadbd: /test/13.0_dbg/storage/innobase/log/log0recv.cc:5854: dberr_t recv_sys_t::find_checkpoint_archived(lsn_t, bool): Assertion `!silent' failed.
      

      CS 13.0.2 b2c4e675049e23ce8c7346985f40840fcd4e583f (Debug, Clang 22.1.8-20260621) Build 09/09/2026

      Core was generated by `/test/MD090926-mariadb-13.0.2-linux-x86_64-dbg/bin/mariadbd --defaults-group-su'.
      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 3865302)]
      (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  0x00007c7382e4527e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
      #4  0x00007c7382e288ff in __GI_abort () at ./stdlib/abort.c:79
      #5  0x00007c7382e2881b in __assert_fail_base (fmt=0x7c7382fd1208 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x5876876e8bc9 "!silent", file=file@entry=0x5876876e723b "/test/13.0_dbg/storage/innobase/log/log0recv.cc", line=line@entry=5854, function=function@entry=0x5876876e8a5e "dberr_t recv_sys_t::find_checkpoint_archived(lsn_t, bool)") at ./assert/assert.c:96
      #6  0x00007c7382e3b517 in __assert_fail (assertion=0x5876876e8bc9 "!silent", file=0x5876876e723b "/test/13.0_dbg/storage/innobase/log/log0recv.cc", line=5854, function=0x5876876e8a5e "dberr_t recv_sys_t::find_checkpoint_archived(lsn_t, bool)") at ./assert/assert.c:105
      #7  0x0000587686e40941 in recv_sys_t::find_checkpoint_archived (this=0x5876880257c0 <recv_sys>, first_lsn=4194304, silent=true)at /test/13.0_dbg/storage/innobase/log/log0recv.cc:5854
      #8  0x0000587686e3e20b in recv_sys_t::find_checkpoint (this=0x5876880257c0 <recv_sys>)at /test/13.0_dbg/storage/innobase/log/log0recv.cc:2006
      #9  0x0000587686fca0c9 in srv_start (create_new_db=false)at /test/13.0_dbg/storage/innobase/srv/srv0start.cc:1419
      #10 0x0000587686d772c5 in innodb_init (p=0x5876a0ff8e30)at /test/13.0_dbg/storage/innobase/handler/ha_innodb.cc:4288
      #11 0x00005876869814fe in ha_initialize_handlerton (plugin_=0x5876a0fd4550)at /test/13.0_dbg/sql/handler.cc:737
      #12 0x00005876865aa27f in plugin_do_initialize (plugin=0x5876a0fd4550, state=@0x7ffc668b0584: 4) at /test/13.0_dbg/sql/sql_plugin.cc:1464
      #13 0x00005876865a9cb5 in plugin_initialize (tmp_root=0x7ffc668b0b88, plugin=0x5876a0fd4550, argc=0x587688236338 <remaining_argc>, argv=0x5876a0d38c90, options_only=false)at /test/13.0_dbg/sql/sql_plugin.cc:1518
      #14 0x00005876865a958b in plugin_init (argc=0x587688236338 <remaining_argc>, argv=0x5876a0d38c90, flags=0) at /test/13.0_dbg/sql/sql_plugin.cc:1762
      #15 0x00005876863c1a68 in init_server_components ()at /test/13.0_dbg/sql/mysqld.cc:5458
      #16 0x00005876863be46e in mysqld_main (argc=163, argv=0x5876a0d38c90)at /test/13.0_dbg/sql/mysqld.cc:6258
      #17 0x00005876863bb6b2 in main (argc=26, argv=0x7ffc668b3c28)at /test/13.0_dbg/sql/main.cc:34
      

      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 - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 0.25d
                  0.25d

                  Git Integration

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