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.

        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

                  Smart Checklist