innobackupex/xbstream Fails Intermittently With Error 17

MySQL & MariaDB Percona XtraBackup
1

Hello,

I’m streaming full and incremental backups remotely using innobackupex/xbstream. It’s successful 9 times out of 10, but sometimes it fails with the following:

xbstream: Can’t create/write to file ‘./backup-my.cnf’ (Errcode: 17)

Here is my command:

innobackupex --incremental --incremental-basedir=/root/scripts/mysql_backup --host=$mysql_host --user=$mysql_user --password=$mysql_password --stream=xbstream ./ | /usr/bin/ssh -i -lbackup $backup_host "mkdir -p $remote_target_path/incremental/$backup_dir-incremental-$dat e && cat - | xbstream -x -C $remote_target_path/incremental/$backup_dir-incremental-$dat e "

Any help would be massively appreciated. Thanks!

2

Hi,

Its really difficult to find out the issue when error comes sometimes :slight_smile: Can you paste here the full log/command output when you run the backup command and getting this error? It might help to troubleshoot this issue.