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

SET GLOBAL innodb_log_archive=OFF may break recovery and backup

    XMLWordPrintable

Details

    • Can result in data loss
    • Q3/2026 Server Development

    Description

      The following test, which I wrote to cover the fix of MDEV-40667, revealed another problem: Backup (as well as crash recovery) would fail because log_t::set_archive() writes a log file header that does not match the sequence bits that have been written to the log file.

      diff --git a/mysql-test/suite/mariabackup/huge_lsn.test b/mysql-test/suite/mariabackup/huge_lsn.test
      index 0da67744457..a7c9b0f3f0d 100644
      --- a/mysql-test/suite/mariabackup/huge_lsn.test
      +++ b/mysql-test/suite/mariabackup/huge_lsn.test
      @@ -76,6 +76,10 @@ let SEARCH_FILE= $MYSQLTEST_VARDIR/log/mysqld.1.err;
       CREATE TABLE t(i INT) ENGINE=INNODB ENCRYPTED=YES;
       INSERT INTO t VALUES(1);
       
      +if (!$MTR_COMBINATION_STRICT_CRC32) {
      +SET GLOBAL innodb_log_archive=ON, innodb_log_archive=OFF;
      +}
      +
       echo # xtrabackup backup;
       let $targetdir=$MYSQLTEST_VARDIR/tmp/backup;
       --disable_result_log
      

      Attachments

        Issue Links

          Activity

            People

              thiru Thirunarayanan Balathandayuthapani
              marko Marko Mäkelä
              Marko Mäkelä Marko Mäkelä
              Thirunarayanan Balathandayuthapani Thirunarayanan Balathandayuthapani
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - 3.3h Original Estimate - 3.3h
                  3.3h
                  Remaining:
                  Time Spent - 5h Remaining Estimate - 3.3h
                  3.3h
                  Logged:
                  Time Spent - 5h Remaining Estimate - 3.3h
                  5h

                  Git Integration

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