Not the answer you need?
Register and ask your own question!

innobackupex/xbstream Fails Intermittently With Error 17

dannycolumbusdannycolumbus EntrantInactive User Role Beginner
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!

Comments

  • niljoshiniljoshi MySQL Sage Inactive User Role Beginner
    Hi,

    Its really difficult to find out the issue when error comes sometimes :) 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.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.