Received: by 10.68.191.225 with SMTP id hb1mr4747060pbc.5.1337148070704;
        Tue, 15 May 2012 23:01:10 -0700 (PDT)
X-BeenThere: percona-discussion@googlegroups.com
Received: by 10.68.216.166 with SMTP id or6ls1412147pbc.9.gmail; Tue, 15 May
 2012 23:01:09 -0700 (PDT)
Received: by 10.68.125.201 with SMTP id ms9mr4758266pbb.3.1337148069368;
        Tue, 15 May 2012 23:01:09 -0700 (PDT)
Received: by 10.68.125.201 with SMTP id ms9mr4758259pbb.3.1337148069286;
        Tue, 15 May 2012 23:01:09 -0700 (PDT)
Return-Path: <alexey.kopy...@percona.com>
Received: from mail2.percona.com (mail2.percona.com. [65.49.72.137])
        by gmr-mx.google.com with ESMTP id iq5si5489800pbc.1.2012.05.15.23.01.09;
        Tue, 15 May 2012 23:01:09 -0700 (PDT)
Received-SPF: pass (google.com: domain of alexey.kopy...@percona.com designates 65.49.72.137 as permitted sender) client-ip=65.49.72.137;
Authentication-Results: gmr-mx.google.com; spf=pass (google.com: domain of alexey.kopy...@percona.com designates 65.49.72.137 as permitted sender) smtp.mail=alexey.kopy...@percona.com
Received: from mba.local (unknown [62.63.87.234])
	by mail2.percona.com (Postfix) with ESMTP id 637D78CDCF9
	for <percona-discussion@googlegroups.com>; Tue, 15 May 2012 23:01:08 -0700 (PDT)
Message-ID: <4FB342A2.6040102@percona.com>
Date: Wed, 16 May 2012 10:01:06 +0400
From: Alexey Kopytov <alexey.kopy...@percona.com>
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.7; rv:12.0) Gecko/20120428 Thunderbird/12.0.1
MIME-Version: 1.0
To: percona-discussion@googlegroups.com
Subject: Re: streaming backup failed with non-helpful error message
References: <CAFN1edqrB=cyRa=xOxF1QAyHRA37vU92OE7tZP7y-VDeQT357g@mail.gmail.com>
In-Reply-To: <CAFN1edqrB=cyRa=xOxF1QAyHRA37vU92OE7tZP7y-VDeQT357g@mail.gmail.com>
X-Enigmail-Version: 1.4.1
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Hi David,

On Tue, 15 May 2012 11:19:59 -0700, David Stainton wrote:

> Greetings,
> 
> 
> I need to perform streaming xtradb backups because my database machines
> don't have enough local disk
> available for snapshots. I've done it successfully a couple times however
> recently an attempt failed.
> 
> Is this not a totally useless error message? Or is there some information
> I'm not seeing here?

I don't see any messages that might be relevant either, except the
"log_copying_thread failed" one. I don't see any code paths that would
result in log copying failure without additional diagnostics.

It could have been a failing ssh connection, or an xbstream failure.
Though I would expect some additional error messages in both cases.

Can you try saving the stream to a file on the remote host rather than
unpacking it with xbstream simultaneously? That is, does the following
fail as well?

innobackupex --stream=xbstream /tmp --defaults-file=/etc/my.cnf
--slave-info | pv | ssh root@backup-boats-db 'cat -
/disk1/mysql/test/backup.xbstream'

Best regards,
Alexey.