Table with page compression lz4/zlib marked as corrupted
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona XtraBackup moved to https://jira.percona.com/projects/PXB | Status tracked in 2.4 | |||||
2.4 |
Fix Released
|
High
|
Sergei Glushchenko |
Bug Description
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=
Try to backup:
./xtrabackup --defaults-
160112 07:13:08 [01] Copying ./dbtest/
[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/
[01] xtrabackup: Error: xtrabackup_
[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)
Please test with latest branch