Details
-
Bug
-
Status: Done
-
High
-
Resolution: Fixed
-
None
-
None
-
None
Description
xtrabackup --move-back is failing due to encrypted binlog file
Testcase
OS : Xenail Ubuntu wget https://www.percona.com/downloads/Percona-Server-LATEST/Percona-Server-8.0.16-7/binary/tarball/Percona-Server-8.0.16-7-Linux.x86_64.ssl100.tar.gz tar -xzf Percona-Server-8.0.16-7-Linux.x86_64.ssl100.tar.gz mv Percona-Server-8.0.16-7-Linux.x86_64.ssl100 ps8016 cd ps8016/ my.cnf file [mysqld] basedir=/ssd/ramesh/ps8016 datadir=/ssd/ramesh/ps8016/data innodb_file_per_table innodb_autoinc_lock_mode=2 early-plugin-load=keyring_file.so keyring_file_data=keyring binlog_encryption=1 log-error=/ssd/ramesh/ps8016/data/mysql.err log-error-verbosity=3 socket=/ssd/ramesh/ps8016/data/socket.sock log-output=none port=21100 server-id=11 ssl-ca=/ssd/ramesh/ps8016/certs/ca.pem ssl-cert=/ssd/ramesh/ps8016/certs/server-cert.pem ssl-key=/ssd/ramesh/ps8016/certs/server-key.pem BASEDIR=/ssd/ramesh/ps8016 rm -rf $BASEDIR/data $BASEDIR/bin/mysqld --no-defaults --initialize-insecure --datadir=$BASEDIR/data --basedir=$BASEDIR $BASEDIR/bin/mysqld --defaults-file=$BASEDIR/my.cnf & xtrabackup --datadir=/ssd/ramesh/ps8016/data --innodb_file_per_table=1 --server-id=11 --defaults_group=mysqld --parallel=4 --user=root --socket=/ssd/ramesh/ps8016/data/socket.sock --lock-ddl=1 --backup=1 --transition-key=myname --target-dir=/ssd/ramesh/ps8016/data_backup --keyring-file-data=/ssd/ramesh/ps8016/data/keyring --early-plugin-load="keyring_file=keyring_file.so" > data_backup.log & xtrabackup --innodb_checksum_algorithm=crc32 --innodb_log_checksums=1 --innodb_data_file_path=ibdata1:12M:autoextend --innodb_log_files_in_group=2 --innodb_log_file_size=50331648 --innodb_page_size=16384 --innodb_undo_directory=./ --innodb_undo_tablespaces=2 --server-id=11 --innodb_log_checksums=ON --innodb_redo_log_encrypt=0 --innodb_undo_log_encrypt=0 --prepare=1 --transition-key=myname --rollback-prepared-trx=1 --target-dir=/ssd/ramesh/ps8016/data_backup --keyring-file-data=/ssd/ramesh/ps8016/data/keyring --early-plugin-load="keyring_file=keyring_file.so" > data_prepare.log & xtrabackup --datadir=/ssd/ramesh/ps8016/data_one --innodb_file_per_table=1 --server-id=12 --defaults_group=mysqld --move-back=1 --force-non-empty-directories=1 --transition-key=myname --generate-new-master-key=1 --early-plugin-load="keyring_file=keyring_file.so" --target-dir=/ssd/ramesh/ps8016/data_backup --keyring-file-data=/ssd/ramesh/ps8016/data/keyring