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

You May Also Like