Comment 2 for bug 1533180

Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

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.