Uploaded image for project: 'Percona XtraBackup'
  1. Percona XtraBackup
  2. PXB-1937

xtrabackup --move-back is failing due to encrypted binlog file

Details

    • Bug
    • Status: Done
    • High
    • Resolution: Fixed
    • None
    • 8.0.8
    • 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 
      
      

      Attachments

        Activity

          People

            sergei.glushchenko Sergei Glushchenko (Inactive)
            ramesh.sivaraman Ramesh Sivaraman (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - Not Specified
                Not Specified
                Logged:
                Time Spent - 2 hours, 42 minutes
                2h 42m

                Smart Checklist