I’m running into a problem where innobackup is failing, sometimes. My backup script is running innobackupex like this:
innobackupex --stream=tar --user=bkp_user --password=xxxxx ./ 2>> /mnt/backup/logs/backup_2013-04-20.log | pigz -c -p 20 -6 - > /mnt/backup/backup_2013-04-20.tar.gz
This works most of the time, but sometimes it fails on me. When it fails, it reports one of the following messages:
innobackupex: Created backup directory /root
tar: -: Cannot write: Broken pipe
tar: Error is not recoverable: exiting now
innobackupex: Error: Failed to stream ‘backup-my.cnf’: Inappropriate ioctl for device at /usr/bin/innobackupex line 381.
 Streaming /data/db/schemas/ibdata
innobackupex: Error: ibbackup child process has died at /usr/bin/innobackupex line 381.
How can I troubleshoot this, or gather additional information about the failures?