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.
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 mysql/mysql. sock data_home_ dir = . data_file_ path = ibdata1: 12M:autoextend log_group_ home_dir = . log_files_ in_group = 2 log_file_ size = 50331648 dir/full/ ibdata1 sbtest1. ibd to /home/backup_ dir/full/ dbtest/ sbtest1. ibd sbtest1. ibd seems to be corrupted. copy_datafile( ) failed.
160118 08:09:25 Connecting to MySQL server host: localhost, user: root, password: set, port: 0, socket: /var/lib/
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_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
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_
[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/
[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/
[01] xtrabackup: Error: xtrabackup_
[01] xtrabackup: Error: failed to copy datafile.