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

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

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 8.0.8
    • Component/s: None
    • Labels:
      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 
      
      

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              sergei.glushchenko Sergei Glushchenko (Inactive)
              Reporter:
              ramesh.sivaraman Ramesh Sivaraman
              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