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

Compressed lz4 files are also copied in restored data dir

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Low
    • Resolution: Fixed
    • Affects Version/s: 8.0.7
    • Fix Version/s: 8.0.7
    • Component/s: None
    • Labels:
      None

      Description

      Take full backup

      ./xtrabackup --user=root --password='' --backup --target-dir=$HOME/dbbackup_PS8/full -S $HOME/PS230719_8_0_16_6_debug/socket.sock --datadir=$HOME/PS230719_8_0_16_6_debug/data --compress=lz4 --compress-threads=10 --parallel=10 --keyring_file_data=$HOME/PS230719_8_0_16_6_debug/keyring --xtrabackup-plugin-dir=$HOME/pxb_8_0_7_debug/lib/plugin 2>full_backup_$(date +"%d_%m_%Y")_log

      Decompress the backup

      ./xtrabackup --decompress --parallel=10 --target-dir=$HOME/dbbackup_PS8/full 2>decompressfullbackuplog

      Prepare the backup

      ./xtrabackup --prepare --target_dir=$HOME/dbbackup_PS8/full --keyring_file_data=$HOME/PS230719_8_0_16_6_debug/keyring --xtrabackup-plugin-dir=$HOME/pxb_8_0_7_debug/lib/plugin 2>&1 | tee prepare_full_backup_$(date +"%d_%m_%Y")_log

      Restore the backup

      ./xtrabackup --copy-back --target-dir=$HOME/dbbackup_PS8/full --datadir=$HOME/PS230719_8_0_16_6_debug/data --keyring_file_data=$HOME/PS230719_8_0_16_6_debug/keyring --xtrabackup-plugin-dir=$HOME/pxb_8_0_7_debug/lib/plugin 2>&1 | tee restore_full_backup_$(date +"%d_%m_%Y")_log

      After the restore, the data dir contains the compressed lz4 files also

      -rw-r----- 1 mchawla mchawla 12582912 Jul 29 13:12 undo_001
      -rw-r----- 1 mchawla mchawla 12582912 Jul 29 13:12 undo_002
      -rw-r----- 1 mchawla mchawla 50331648 Jul 29 13:12 ib_logfile0
      -rw-r----- 1 mchawla mchawla 50331648 Jul 29 13:12 ib_logfile1
      -rw-r----- 1 mchawla mchawla 12582912 Jul 29 13:12 ibdata1
      -rw-r----- 1 mchawla mchawla 515 Jul 29 13:12 binlog.000030
      -rw-r----- 1 mchawla mchawla 16 Jul 29 13:12 binlog.index
      -rw-r----- 1 mchawla mchawla 424 Jul 29 13:12 backup-my.cnf.lz4
      -rw-r----- 1 mchawla mchawla 329 Jul 29 13:12 binlog.000030.lz4
      -rw-r----- 1 mchawla mchawla 869 Jul 29 13:12 xtrabackup_info.lz4
      -rw-r----- 1 mchawla mchawla 45 Jul 29 13:12 binlog.index.lz4
      -rw-r----- 1 mchawla mchawla 190 Jul 29 13:12 xtrabackup_tablespaces.lz4
      -rw-r----- 1 mchawla mchawla 1230 Jul 29 13:12 ib_buffer_pool.lz4
      -rw-r----- 1 mchawla mchawla 3510 Jul 29 13:12 ib_buffer_pool
      drwxr-x--- 2 mchawla mchawla 4096 Jul 29 13:12 sys
      -rw-r----- 1 mchawla mchawla 24117248 Jul 29 13:12 mysql.ibd
      drwxr-x--- 2 mchawla mchawla 4096 Jul 29 13:12 mysql
      drwxr-x--- 2 mchawla mchawla 4096 Jul 29 13:12 test
      -rw-r----- 1 mchawla mchawla 306 Jul 29 13:12 xtrabackup_binlog_info.lz4
      drwxr-x--- 2 mchawla mchawla 16384 Jul 29 13:12 performance_schema
      -rw-r----- 1 mchawla mchawla 12582912 Jul 29 13:12 ibtmp1
      drwxr-x--- 2 mchawla mchawla 4096 Jul 29 13:12 test_rocksdb
      -rw-r----- 1 mchawla mchawla 513 Jul 29 13:12 xtrabackup_logfile.lz4
      -rw-r----- 1 mchawla mchawla 2055352 Jul 29 13:12 mysql.ibd.lz4
      -rw-r----- 1 mchawla mchawla 1214 Jul 29 13:12 xtrabackup_info
      -rw-r----- 1 mchawla mchawla 18 Jul 29 13:12 xtrabackup_binlog_pos_innodb
      -rw-r----- 1 mchawla mchawla 1 Jul 29 13:12 xtrabackup_master_key_id

      Though the database is able to come up successfully, the compressed files can be ignored while copying the data files in the data directory.

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              sergei.glushchenko Sergei Glushchenko (Inactive)
              Reporter:
              manish.chawla Manish Chawla
              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 - 4 hours, 28 minutes
                  4h 28m