Broken Pipe while Backup over netcat +xbstream +parallel

[Florian Müller]

I'm trying to create a full backup of some Databases (~35GB Data) over Network (netcat).

database# $ innobackupex --parallel=2 --stream=xbstream /root/backup | nc backup 9999
---
backup # $ nc -l 9999 | xbstream -x -C /mnt/backup

database:
innobackupex: Backing up files '/mnt/mysqllv/mysql/*****Administration/*.{frm,MYD,MYI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (154 files)
>> log scanned up to (6536021589103)
>> log scanned up to (6536021589103)
innobackupex: Error: Broken pipe at /usr/bin/innobackupex line 371.

backup:
xb_stream_read_chunk(): unexpected end of stream at offset 0x7f370515d.

There's no specific point when it crashes. It might happen after the fifth table or while copying the files itself.

It works without the --parallel=2 parameter, but I need to use this to maximize the network throughput.

[Alexey Kopytov (akopytov)]

Florian,

It's most likely a duplicate of bug #977995. Feel free to reopen if the workaround from that bug doesn't work for you.