Table with page compression lz4/zlib marked as corrupted

[Shahriyar Rzayev]

Reproduce steps:
Create table with page compression:

CREATE TABLE `sbtest1` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `k` int(10) unsigned NOT NULL DEFAULT '0',
  `c` char(120) NOT NULL DEFAULT '',
  `pad` char(60) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `k_1` (`k`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMPRESSION='lz4'

Run sysbench:

sysbench --test=/usr/share/doc/sysbench/tests/db/insert.lua --oltp-test-mode=complex --num-threads=1000 --mysql-db=dbtest --mysql-user=root --mysql-password=Baku12345# --db-driver=mysql --max-requests=0 run

Try to backup:

./xtrabackup --defaults-file=/etc/my.cnf --backup --datadir=/var/lib/mysql/ --target-dir=/home/backup_dir/full/ --user=root --password=Baku12345# --no-version-check
160112 07:13:08 [01] Copying ./dbtest/sbtest1.ibd to /home/backup_dir/full/dbtest/sbtest1.ibd
[01] xtrabackup: Database page corruption detected at page 1, retrying...
[01] xtrabackup: Database page corruption detected at page 1, retrying...
[01] xtrabackup: Database page corruption detected at page 1, retrying...
[01] xtrabackup: Database page corruption detected at page 1, retrying...
[01] xtrabackup: Database page corruption detected at page 1, retrying...
[01] xtrabackup: Database page corruption detected at page 1, retrying...
160112 07:13:09 >> log scanned up to (10460647477)
[01] xtrabackup: Database page corruption detected at page 1, retrying...
[01] xtrabackup: Database page corruption detected at page 1, retrying...
[01] xtrabackup: Database page corruption detected at page 1, retrying...
[01] xtrabackup: Error: failed to read page after 10 retries. File ./dbtest/sbtest1.ibd seems to be corrupted.
[01] xtrabackup: Error: xtrabackup_copy_datafile() failed.
[01] xtrabackup: Error: failed to copy datafile.

Same thing with 'zlib' compression method.

Table has data:

mysql> select count(*) from sbtest1;
+----------+
| count(*) |
+----------+
| 1625469 |
+----------+
1 row in set (0,50 sec)

[Sergei Glushchenko (sergei.glushchenko)]

Please test with latest branch

[Shahriyar Rzayev (rzayev-sehriyar)]

Tested with latest branch:

[root@mysql-57 bin]# ./xtrabackup --version
./xtrabackup version 2.4.0alpha1 based on MySQL server 5.7.10 Linux (x86_64) (revision id: 3a6d676)

Same error here:

mysql> show create table sbtest1\G
*************************** 1. row ***************************
       Table: sbtest1
Create Table: CREATE TABLE `sbtest1` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `k` int(10) unsigned NOT NULL DEFAULT '0',
  `c` char(120) NOT NULL DEFAULT '',
  `pad` char(60) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `k_1` (`k`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMPRESSION='lz4'
1 row in set (0,00 sec)

[root@mysql-57 bin]# ./xtrabackup --defaults-file=/etc/my.cnf --backup --datadir=/var/lib/mysql/ --target-dir=/home/backup_dir/full/ --user=root --password=Baku12345# --no-version-check
160118 08:09:25 Connecting to MySQL server host: localhost, user: root, password: set, port: 0, socket: /var/lib/mysql/mysql.sock
Using server version 5.7.10-log
./xtrabackup version 2.4.0alpha1 based on MySQL server 5.7.10 Linux (x86_64) (revision id: 3a6d676)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /var/lib/mysql/
xtrabackup: open files limit requested 0, set to 1024
xtrabackup: using the following InnoDB configuration:
xtrabackup: innodb_data_home_dir = .
xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend
xtrabackup: innodb_log_group_home_dir = .
xtrabackup: innodb_log_files_in_group = 2
xtrabackup: innodb_log_file_size = 50331648
InnoDB: Number of pools: 1
160118 08:09:25 >> log scanned up to (8065406268)
xtrabackup: Generating a list of tablespaces
InnoDB: Allocated tablespace ID 39 for dbtest/sbtest1, old maximum was 0
160118 08:09:25 [01] Copying ./ibdata1 to /home/backup_dir/full/ibdata1
[01] xtrabackup: Page 188 is a doublewrite buffer page, skipping.
[01] xtrabackup: Page 189 is a doublewrite buffer page, skipping.
[01] xtrabackup: Page 190 is a doublewrite buffer page, skipping.
[01] xtrabackup: Page 191 is a doublewrite buffer page, skipping.
160118 08:09:26 >> log scanned up to (8065406268)
160118 08:09:26 [01] ...done
160118 08:09:27 >> log scanned up to (8065406268)
160118 08:09:27 [01] Copying ./dbtest/sbtest1.ibd to /home/backup_dir/full/dbtest/sbtest1.ibd
[01] xtrabackup: Database page corruption detected at page 1, retrying...
[01] xtrabackup: Database page corruption detected at page 1, retrying...
[01] xtrabackup: Database page corruption detected at page 1, retrying...
[01] xtrabackup: Database page corruption detected at page 1, retrying...
[01] xtrabackup: Database page corruption detected at page 1, retrying...
[01] xtrabackup: Database page corruption detected at page 1, retrying...
[01] xtrabackup: Database page corruption detected at page 1, retrying...
[01] xtrabackup: Database page corruption detected at page 1, retrying...
[01] xtrabackup: Database page corruption detected at page 1, retrying...
[01] xtrabackup: Error: failed to read page after 10 retries. File ./dbtest/sbtest1.ibd seems to be corrupted.
[01] xtrabackup: Error: xtrabackup_copy_datafile() failed.
[01] xtrabackup: Error: failed to copy datafile.

[Sergei Glushchenko (sergei.glushchenko)]

https://github.com/percona/percona-xtrabackup/pull/147

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXB-456