``copy-back`` did not move undo files to the *data directory*.
General
Escalation
General
Escalation
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
What about the other issue? Why are we seeing errors for undo_004 and undo_005 even though they don't exist? my_realpath(./undo_004) failed! my_realpath(./undo_005) failed!
Rahul Malik March 25, 2020 at 9:20 AM
the issue is with a relative path. works fine with an absolute path. so please --datadir absolute_path in copy-back
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.