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

mariabackup.mdev-14447 test case fails with Table 'test.t' doesn't exist in engine




      mariabackup.mdev-14447 test case is in buildbot recently


      Root cause is that mariabackup validation of first page fails with checksum mis-match error. (It can be due to partial write or zero filled page).

      In xb_load_single_table_tablespace(), mariabackup allows the corrupted page 0

              if (err != DB_SUCCESS && err != DB_CORRUPTION && xtrabackup_backup) {
                      /* allow corrupted first page for xtrabackup, it could be just
                      zero-filled page, which we restore from redo log later */
                      die("Failed to not validate first page of the file %s, error %d",name, (int)err);

      Test case for it:

      call mtr.add_suppression("InnoDB: New log files created");
      let $basedir=$MYSQLTEST_VARDIR/tmp/backup;
      let $incremental_dir=$MYSQLTEST_VARDIR/tmp/backup_inc1;
      CREATE TABLE t(a varchar(40) PRIMARY KEY, b varchar(40), c varchar(40), d varchar(40), index(b,c,d)) ENGINE INNODB;
      set global innodb_log_checkpoint_now = true;
      let $backuplog=$MYSQLTEST_VARDIR/tmp/backup.log;
      echo # Create full backup , modify table, then create incremental/differential backup;
      --echo # dbug execute makes checksum mismatch while reading page 0 of table t.
      exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf  --backup --target-dir=$basedir --dbug=+d,page_intermittent_checksum_mismatch >$backuplog;
      echo # Prepare full backup, apply incremental one;
      exec $XTRABACKUP --prepare --verbose --apply-log-only --target-dir=$basedir;
      echo # Restore and check results;
      let $targetdir=$basedir;
      -- source include/restart_and_restore.inc
      SELECT count(*) FROM t;
      DROP TABLE t;
      # Cleanup
      rmdir $basedir;

      debug execute if code for validation fails:

      diff --git a/storage/innobase/buf/buf0buf.cc b/storage/innobase/buf/buf0buf.cc
      index 8dc2fd2..8f00c83 100644
      --- a/storage/innobase/buf/buf0buf.cc
      +++ b/storage/innobase/buf/buf0buf.cc
      @@ -1103,6 +1103,17 @@ buf_page_is_corrupted(
                              if (srv_checksum_algorithm
                                  == SRV_CHECKSUM_ALGORITHM_CRC32) {
      +                               DBUG_EXECUTE_IF(
      +                                       "page_intermittent_checksum_mismatch", {
      +                                       static int page_counter;
      +                                       if (page_counter++ == 4) {
      +                                               fprintf(stderr, "mismatch\n");
      +                                               checksum_field2++;
      +                                       }
      +                               });
                                      crc32 = buf_page_check_crc32(read_buf,


        Issue Links



              thiru Thirunarayanan Balathandayuthapani
              thiru Thirunarayanan Balathandayuthapani
              0 Vote for this issue
              2 Start watching this issue



                Git Integration

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