Partial Backup Then Backup Hangs

[GoogleCodeExporter]

What steps will reproduce the problem?

When I execute a normal backup partial files are transferred. Almost all of the 
ibdata file come across, then the backup simply hangs, no other files come back 
to the backup host (no frm files, etc). Command is

xbm backup run hostname backupname

Logs indicate a full backup is started, netcat fires up all good, data starts 
to transfer (as mentioned above) then poof, nothing. Strace of running xbm 
processes show no activity, tcpdump of port 10000 captures nothing, and backup 
never finishes/times out.

So I increased the log verbosity to DEBUG, captured the command being used, and 
a error is reported there. Perhaps I 'fat fingered' the cut and paste to 
produce this error, but I don't think so. Log snippet below...

130830 14:17:28  innobackupex: Connecting to MySQL server with DSN 
'dbi:mysql:;mysql_read_default_group=xtrabackup' as 'backup'  (using password: 
YES).
130830 14:17:28  innobackupex: Connected to MySQL server
IMPORTANT: Please check that the backup run completes successfully.
           At the end of a successful backup run innobackupex
           prints "completed OK!".

innobackupex: Using mysql server version 5.5.32-0ubuntu0.12.04.1

innobackupex: Created backup directory /var/lib/mysql
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 389.

This machine connects to and backs up other hosts on the same network no prob. 
There are settle variations like data dir locations, other than that all my 
machines are in almost the same state (thanks Puppet).

What version of the product are you using? On what operating system?

XtraBackup Manager v0.81 running on 5.5.32-0ubuntu0.12.04.1

Please provide any additional information below.

I am sure this is a issue I/we introduced, however I spent some time trying to 
figure out what, and no love. I have been ensuring that permissions are correct 
for the needed directories, however I do run xbm as root, so I not sure if 
perms are messing me up.

Any help would be greatly appreciated.

Cheers.

Original issue reported on code.google.com by Travis.D...@gmail.com on 30 Aug 2013 at 9:25

[GoogleCodeExporter]

Which xtrabackup version are you using? XBM currently only works with 
xtrabackup 1.x

Original comment by arnaud.lb on 31 Aug 2013 at 2:21

[GoogleCodeExporter]

I have the following installed...

- xtrabackup version 2.0.6 for Percona Server 5.1.59 unknown-linux-gnu (x86_64) 
(revision id: undefined)
- xtrabackup_51 version 2.0.6 for MySQL server 5.1.59 unknown-linux-gnu 
(x86_64) (revision id: undefined)
- xtrabackup_55 version 2.0.6 for Percona Server 5.5.16 Linux (x86_64) 
(revision id: undefined)
- xtrabackup_56 version 2.0.6 for MySQL server 5.6.10 Linux (x86_64) (revision 
id: undefined)

Not entirely sure how to determine which one is used when XBM runs.

Original comment by Travis.D...@gmail.com on 3 Sep 2013 at 6:14

[GoogleCodeExporter]

On the machine that runs XBM, and on the backup that hangs, I see the following 
in xbm.log, the same query is written over and over again...

2013-09-03 11:22:42 -0700 [DEBUG] : [ dbConnection->getSchemaVersion: Sending 
SQL: SELECT version as version FROM schema_version ]
2013-09-03 11:22:42 -0700 [DEBUG] : [ dbConnection->getSchemaVersion: Query 
took 0.00051212310791016 ]
2013-09-03 11:22:42 -0700 [DEBUG] : [ backupJob->getInfo: Sending SQL: SELECT * 
FROM backup_jobs WHERE backup_job_id=369 ]
2013-09-03 11:22:42 -0700 [DEBUG] : [ backupJob->getInfo: Query took 
0.00032186508178711 ]

The queries work fine when run manually as the xbm user.

Hope this helps.

Original comment by Travis.D...@gmail.com on 3 Sep 2013 at 6:23