MariaBackup prepare fails with InnoDB: Database page corruption on disk or a failed file read

...

2019-04-26 22:27:27 139757398472128 [Note] InnoDB: Ignoring data file './test/#sql-7c3a_9.ibd' with space ID 14. Another data file called test/t6.ibd exists with the same space ID.

2019-04-26 22:27:27 139757398472128 [Note] InnoDB: Starting final batch to recover 361 pages from redo log.

2019-04-26 22:27:27 139757197797120 [ERROR] InnoDB: Database page corruption on disk or a failed file read of tablespace test/t6 page [page id: space=14, page number=3]. You may have to recover from a backup.

2019-04-26 22:27:27 139757197797120 [Note] InnoDB: Page dump in ascii and hex (4096 bytes):

...

InnoDB: End of page dump

2019-04-26 22:27:27 139757197797120 [Note] InnoDB: Uncompressed page, stored checksum in field1 3070644445, calculated checksums for field1: crc32 75358379, innodb 887337880,  page type 17855 == INDEX.none 3735928559, stored checksum in field2 3070644445, calculated checksums for field2: crc32 75358379, innodb 2072860611, none 3735928559,  page LSN 0 1102123, low 4 bytes of LSN at page end 1102123, page number (if stored to page already) 3, space id (if created with >= MySQL-4.1.1 and stored already) 14

2019-04-26 22:27:27 139757197797120 [Note] InnoDB: Page may be an index page where index id is 9896656056595753379

2019-04-26 22:27:27 139757197797120 [Note] InnoDB: It is also possible that your operating system has corrupted its own file cache and rebooting your computer removes the error. If the corrupt page is an index page. You can also try to fix the corruption by dumping, dropping, and reimporting the corrupt table. You can use CHECK TABLE to scan your table for corruption. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.

2019-04-26 22:27:27 139757197797120 [ERROR] InnoDB: Failed to read file 'test/t6.ibd' at offset 3: Page read from tablespace is corrupted.

2019-04-26 22:27:27 139757398472128 [Note] InnoDB: Set innodb_force_recovery=1 to ignore corrupted pages.

2019-04-26 22:27:27 139757398472128 [ERROR] InnoDB: Plugin initialization aborted at srv0start.cc[2228] with error Data structure corruption

[00] FATAL ERROR: 2019-04-26 22:27:28 mariabackup: innodb_init() returned 39 (Data structure corruption).

--mysqld=--innodb-encrypt-tables --mysqld=--innodb-encryption-threads=1  --mysqld=--file-key-management --mysqld=--file-key-management-filename=`pwd`/std_data/keys.txt --mysqld=--plugin-load-add=file_key_management --mysqld=--innodb-page-size=4K  --mysqld=--innodb_change_buffering=none --force-restart --repeat=10

--source include/have_innodb.inc

SET @stats.persistent= @@innodb_stats_persistent;

SET GLOBAL innodb_stats_persistent= ON;

CREATE TABLE t1 ( 

  pk SERIAL,

  PRIMARY KEY(pk)

) ENGINE=InnoDB;

CREATE TABLE t2 ( 

  pk INT,

  PRIMARY KEY(pk)

) ENGINE=InnoDB;

CREATE TABLE t3 ( 

  col_year YEAR NOT NULL DEFAULT '1970',

  pk INT,

  PRIMARY KEY(pk)

) ENGINE=InnoDB;

ALTER TABLE t3 ADD INDEX(col_year);

CREATE TABLE t4 ( 

  col_timestamp TIMESTAMP(5) NULL,

  pk INT,

  col_varchar VARCHAR(27) NULL,

  PRIMARY KEY(pk)

) ENGINE=InnoDB;

ALTER TABLE t4 ADD INDEX(col_varchar(27));

CREATE TABLE t5 ( 

  col_year YEAR NULL,

  col_int SMALLINT(35) NULL,

  col_varchar VARCHAR(2817) NULL,

  col_blob TEXT NULL,

  col_time TIME NOT NULL DEFAULT '00:00:00',

  col_timestamp TIMESTAMP(6) NOT NULL DEFAULT '1971-01-01 00:00:00',

  col_date DATE NULL,

  col_char CHAR(170) NOT NULL DEFAULT '',

  col_dec DECIMAL(16,0) UNSIGNED NOT NULL DEFAULT 0,

  pk INT,

  col_datetime DATETIME(5) NULL,

  col_enum ENUM('','a','b','c','d','e','f','foo','bar') NULL,

  PRIMARY KEY(pk)

) ENGINE=InnoDB;

ALTER TABLE t5 ADD INDEX(col_dec);

ALTER TABLE t5 ADD UNIQUE(col_date);

ALTER TABLE t5 ADD INDEX(pk);

ALTER TABLE t5 ADD INDEX(col_time);

CREATE TABLE t9 ( 

  col_year YEAR NOT NULL DEFAULT '1970',

  col_timestamp TIMESTAMP(1) NULL,

  col_date DATE NULL,

  col_enum SET('','a','b','c','d','e','f','foo','bar') NULL,

  col_int SMALLINT(13) NULL,

  col_varchar VARCHAR(3450) NOT NULL DEFAULT '',

  col_time TIME(6) NULL,

  pk INT,

  col_datetime DATETIME(4) NULL,

  col_char BINARY(141) NOT NULL DEFAULT '',

  col_bit BIT(17) NOT NULL DEFAULT 0,

  col_dec DECIMAL(31,0) UNSIGNED ZEROFILL NULL,

  col_blob BLOB NOT NULL DEFAULT '',

  PRIMARY KEY(pk)

) ENGINE=InnoDB;

ALTER TABLE t9 ADD INDEX(col_int);

ALTER TABLE t9 ADD INDEX(col_char(64));

ALTER TABLE t9 ADD INDEX(pk);

ALTER TABLE t9 ADD UNIQUE(col_bit);

CREATE OR REPLACE TABLE t4 (a INT) ENGINE=InnoDB;

CREATE OR REPLACE TABLE t6 (b INT) ENGINE=InnoDB;

INSERT INTO t4 () VALUES ();

INSERT INTO t6 () VALUES (),(),(),();

ALTER TABLE t5 ORDER BY tscol7;

ALTER TABLE t9 FORCE;

OPTIMIZE TABLE t6;

--echo # Running backup...

--exec $XTRABACKUP --backup --target-dir=$MYSQL_TMP_DIR/backup --protocol=tcp --port=$MASTER_MYPORT --user=root > $MYSQL_TMP_DIR/backup.log 2>&1

--exec cp -r $MYSQL_TMP_DIR/backup $MYSQL_TMP_DIR/backup_before_prepare

--echo # Running prepare...

--exec sh -c " if ! $XTRABACKUP --prepare --target-dir=$MYSQL_TMP_DIR/backup --user=root > $MYSQL_TMP_DIR/prepare.log 2>&1 || grep 'Data structure corruption' $MYSQL_TMP_DIR/prepare.log ; then cat $MYSQL_TMP_DIR/prepare.log ; exit 1 ; fi"

--echo # Prepare succeeded

DROP TABLE t1, t2, t3, t4, t5, t6, t9;

--rmdir $MYSQL_TMP_DIR/backup

--rmdir $MYSQL_TMP_DIR/backup_before_prepare

SET GLOBAL innodb_stats_persistent= @stats.persistent;