InnoDB: Doing recovery: scanned up to log sequence number 2910532608 (52%)
InnoDB: Ignoring data file './db2/sb1.ibd' with space ID 113. Another data file called ./db2/#sql-2cf2_5d.ibd exists with the same space ID.
InnoDB: Cannot rename './db2/#sql-2cf2_5d.ibd' to './db2/sb1.ibd' for space ID 113 because the target file exists. Remove the target file and try again.
InnoDB: Cannot replay file rename. Remove either file and try again.
InnoDB: Plugin initialization aborted at srv0start.cc[2206] with error Generic error
xtrabackup: innodb_init(): Error occured.
Could reproduce with PS 5.7.11-4.
Slightly changed test.sh and added alter encryption:
root@percona- XPS-15: ~# cat test.sh
#!/bin/bash
echo "drop table if exists db1.sb1" | /opt/percona- 5.7.11- 4/bin/mysql -u root -pBaku12345# --socket= /opt/percona- 5.7.11- 4/datadir/ mysqld. sock --port=5711 5.7.11- 4/bin/mysql -u root -pBaku12345# --socket= /opt/percona- 5.7.11- 4/datadir/ mysqld. sock --port=5711 5.7.11- 4/bin/mysql -u root -pBaku12345# --socket= /opt/percona- 5.7.11- 4/datadir/ mysqld. sock --port=5711 5.7.11- 4/bin/mysql -u root -pBaku12345# --socket= /opt/percona- 5.7.11- 4/datadir/ mysqld. sock --port=5711 5.7.11- 4/bin/mysql -u root -pBaku12345# --socket= /opt/percona- 5.7.11- 4/datadir/ mysqld. sock --port=5711 5.7.11- 4/bin/mysql -u root -pBaku12345# --socket= /opt/percona- 5.7.11- 4/datadir/ mysqld. sock --port=5711 5.7.11- 4/bin/mysql -u root -pBaku12345# --socket= /opt/percona- 5.7.11- 4/datadir/ mysqld. sock --port=5711 5.7.11- 4/bin/mysql -u root -pBaku12345# --socket= /opt/percona- 5.7.11- 4/datadir/ mysqld. sock --port=5711
echo "create table db1.sb1 as select id,c from db1.sbtest1 where id < 150000;"| /opt/percona-
echo "alter table db1.sb1 encryption='Y'" | /opt/percona-
echo "create unique index ix on db1.sb1 (id)" | /opt/percona-
sleep 1
echo "drop table if exists db2.sb1" | /opt/percona-
echo "create table db2.sb1 as select id,c from db2.sbtest1 where id < 150000;" | /opt/percona-
echo "alter table db2.sb1 encryption='Y'" | /opt/percona-
echo "create unique index ix on db2.sb1 (id)" | /opt/percona-
Take Backup:
root@percona- XPS-15: /usr/local/ xtrabackup/ bin# cat run_backup.sh file=/opt/ percona- 5.7.11- 4/my.cnf --backup --datadir= /opt/percona- 5.7.11- 4/datadir --target- dir=/home/ backup_ dir/full/ --user=root --password= Baku12345# --socket= /opt/percona- 5.7.11- 4/datadir/ mysqld. sock --port=5711 --no-version-check --keyring- file-data= /opt/percona- 5.7.11- 4/keyring/ keyring --server-id=0
./xtrabackup --defaults-
sleep 10
./xtrabackup --defaults- file=/opt/ percona- 5.7.11- 4/my.cnf --backup --target- dir=/home/ backup_ dir/inc/ inc1 --incremental- basedir= /home/backup_ dir/full --datadir= /opt/percona- 5.7.11- 4/datadir --user=root --password= Baku12345# --socket= /opt/percona- 5.7.11- 4/datadir/ mysqld. sock --port=5711 --no-version-check --keyring- file-data= /opt/percona- 5.7.11- 4/keyring/ keyring --server-id=0
sleep 10
./xtrabackup --defaults- file=/opt/ percona- 5.7.11- 4/my.cnf --backup --target- dir=/home/ backup_ dir/inc/ inc2 --incremental- basedir= /home/backup_ dir/inc/ inc1 --datadir= /opt/percona- 5.7.11- 4/datadir --user=root --password= Baku12345# --socket= /opt/percona- 5.7.11- 4/datadir/ mysqld. sock --port=5711 --no-version-check --keyring- file-data= /opt/percona- 5.7.11- 4/keyring/ keyring --server-id=0
sleep 10
./xtrabackup --defaults- file=/opt/ percona- 5.7.11- 4/my.cnf --backup --target- dir=/home/ backup_ dir/inc/ inc3 --incremental- basedir= /home/backup_ dir/inc/ inc2 --datadir= /opt/percona- 5.7.11- 4/datadir --user=root --password= Baku12345# --socket= /opt/percona- 5.7.11- 4/datadir/ mysqld. sock --port=5711 --no-version-check --keyring- file-data= /opt/percona- 5.7.11- 4/keyring/ keyring --server-id=0
Prepare backups:
root@percona- XPS-15: /usr/local/ xtrabackup/ bin# cat prepare_backup.sh file=/home/ backup_ dir/full/ backup- my.cnf --prepare --apply-log-only --target- dir=/home/ backup_ dir/full --keyring- file-data= /opt/percona- 5.7.11- 4/keyring/ keyring --server-id=0
./xtrabackup --defaults-
sleep 10
./xtrabackup --defaults- file=/home/ backup_ dir/full/ backup- my.cnf --prepare --apply-log-only --target- dir=/home/ backup_ dir/full --incremental- dir=/home/ backup_ dir/inc/ inc1 --keyring- file-data= /opt/percona- 5.7.11- 4/keyring/ keyring --server-id=0
sleep 10
./xtrabackup --defaults- file=/home/ backup_ dir/full/ backup- my.cnf --prepare --apply-log-only --target- dir=/home/ backup_ dir/full --incremental- dir=/home/ backup_ dir/inc/ inc2 --keyring- file-data= /opt/percona- 5.7.11- 4/keyring/ keyring --server-id=0
sleep 10
./xtrabackup --defaults- file=/home/ backup_ dir/full/ backup- my.cnf --prepare --target- dir=/home/ backup_ dir/full --incremental- dir=/home/ backup_ dir/inc/ inc3 --keyring- file-data= /opt/percona- 5.7.11- 4/keyring/ keyring --server-id=0
Result:
InnoDB: Doing recovery: scanned up to log sequence number 2910532608 (52%) sql-2cf2_ 5d.ibd exists with the same space ID. #sql-2cf2_ 5d.ibd' to './db2/sb1.ibd' for space ID 113 because the target file exists. Remove the target file and try again.
InnoDB: Ignoring data file './db2/sb1.ibd' with space ID 113. Another data file called ./db2/#
InnoDB: Cannot rename './db2/
InnoDB: Cannot replay file rename. Remove either file and try again.
InnoDB: Plugin initialization aborted at srv0start.cc[2206] with error Generic error
xtrabackup: innodb_init(): Error occured.