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

``copy-back`` did not move undo files to the *data directory*.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: 8.0.x
    • Fix Version/s: 8.0.10
    • Component/s: None
    • Labels:
      None

      Description

      It is noticed that SST scripts copy back only the default undo logs - undo_001 and undo_002.
      The SST copy back command is missing --innodb_undo_directory option

      xtrabackup: recognized server arguments: --tmpdir=/dev/shm/962288/2/tmp2 --datadir=/dev/shm/962288/2/node2 --server-id=102 --innodb_file_per_table=1 --log_bin=binlog --defaults_group=mysqld --datadir=/dev/shm/962288/2/node2/
      xtrabackup: recognized client arguments: --ssl-ca=/home/mohit.joshi/pxc_runs/962288/cert/ca.pem --ssl-cert=/home/mohit.joshi/pxc_runs/962288/cert/client-cert.pem --ssl-key=/home/mohit.joshi/pxc_runs/962288/cert/client-key.pem --move-back=1 --force-non-empty-directories=1 --transition-key=* --generate-new-master-key=1 --xtrabackup-plugin-dir=/home/mohit.joshi/pxc-8.0_build/Percona-XtraDB-Cluster_8.0.18.9-26.4.3_debug.Linux.x86_64/bin/pxc_extra/pxb-8.0/lib/plugin --target-dir=/dev/shm/962288/2/node2//sst-xb-tmpdir
      /home/mohit.joshi/pxc-8.0_build/Percona-XtraDB-Cluster_8.0.18.9-26.4.3_debug.Linux.x86_64/bin/pxc_extra/pxb-8.0/bin/xtrabackup version 8.0.9 based on MySQL server 8.0.18 Linux (x86_64) (revision id: bc837f76260)
      200124 06:50:58 Loading xtrabackup_keys.
      200124 06:50:58 Loading xtrabackup_keys.
      200124 06:50:59 Generated new master key with ID 'e4c213ce-3e74-11ea-bac5-002590e9b459-3'.
      200124 06:50:59 [01] Moving undo_001 to /dev/shm/962288/2/node2//undo_001
      200124 06:50:59 [01] ...done
      200124 06:50:59 [01] Moving undo_002 to /dev/shm/962288/2/node2//undo_002
      200124 06:50:59 [01] ...done
      200124 06:50:59 [01] Moving ib_logfile0 to /dev/shm/962288/2/node2//ib_logfile0
      200124 06:50:59 [01] ...done
      200124 06:50:59 [01] Moving ib_logfile1 to /dev/shm/962288/2/node2//ib_logfile1
      200124 06:50:59 [01] ...done
      200124 06:50:59 [01] Moving ibdata1 to /dev/shm/962288/2/node2//ibdata1
      200124 06:50:59 [01] ...done

      ..

      ..

      ..

      200124 06:50:59 [01] Moving ./performance_schema/variables_info_188.sdi to /dev/shm/962288/2/node2//performance_schema/variables_info_188.sdi
      200124 06:50:59 [01] ...done
      200124 06:50:59 [01] Moving ./performance_schema/persisted_variab_189.sdi to /dev/shm/962288/2/node2//performance_schema/persisted_variab_189.sdi
      200124 06:50:59 [01] ...done
      200124 06:50:59 [01] Moving ./performance_schema/user_defined_fun_190.sdi to /dev/shm/962288/2/node2//performance_schema/user_defined_fun_190.sdi
      200124 06:50:59 [01] ...done
      200124 06:50:59 [01] Moving ./performance_schema/session_variable_187.sdi to /dev/shm/962288/2/node2//performance_schema/session_variable_187.sdi
      200124 06:50:59 [01] ...done
      200124 06:50:59 [01] Moving ./performance_schema/pxc_cluster_view_191.sdi to /dev/shm/962288/2/node2//performance_schema/pxc_cluster_view_191.sdi
      200124 06:50:59 [01] ...done
      Error: Move file ./undo_003.ibu to /dev/shm/962288/2/node1//undo_003.ibu failed: Destination file exists
      Error: copy-back thread 0 failed.

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              rahul.malik Rahul Malik
              Reporter:
              mohit.joshi Mohit Joshi
              Votes:
              0 Vote for this issue
              Watchers:
              3 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 days, 7 hours
                  2d 7h