innobackupex --rsync 報錯 Error: can't create file (null)/xtrabackup_rsyncfiles_pass1
在使用最新版的innobackupex(2.3.2):
innobackupex /backup --rsync --user=xx --password=xxx 備份時報錯：
Error: can't create file (null)/xtrabackup_rsyncfiles_pass1
網上搜索沒有找到答案，於是向官方報告 bug ，發現已經有人匯報了該bug：
https://bugs.launchpad.net/percona-xtrabackup/+bug/1511701
Bug Description
After latest update xtrabackup to 2.3.2 my backup scripts stop working.
Problem in "--rsync" argument. With it in half of "copying X to Y" xtrabackup exit with error message:
~~
can't create file (null)/xtrabackup rsync files pass1
~~
With previous builds all was fine.
Problem command line:
~~
innobackupex --defaults-file=/etc/mysql/my.cnf --user=root --password=`cat /root/passwords/.mysql` --no-timestamp --throttle=40 --rsync /var/backups/separate_disk/mysql/${WEEK_DAY_NUMBER}f 2>&1
~~
If remove "--rsync" - all work without errors.
P.S. and previous versions uses "root" as default user name. Now it use "mysql" if in command line didn't defined "--user". (Back incompatibility)
Add tags Tag help
Sergei Glushchenko (sergei.glushchenko) wrote on 2015-10-30: #1
Would specifying --tmpdir=/tmp (or other directory) resolve the rsync issue?
Maxim (sailormax) wrote on 2015-11-01: #2
yes.
Sergei Glushchenko (sergei.glushchenko) wrote on 2015-11-09: #3
We'll set tmpdir to system/user default when it is not specified.
Changed in percona-xtrabackup:
status: New → Triaged
importance: Undecided → High
解決辦法：
在使用 --rsync 選項時，需要增加 --tmpdir=/tmp 選擇，來指定 xtrabackup_rsyncfiles_pass1 臨時文件的存儲位置：
innobackupex /backup/ --rsync --tmpdir=/tmp --user=xxx --password=xxx
