xtrabackup doesn't handle --slave-info option well with PXC

[kedar]

Xtrabackup Version: xtrabackup 2.3.2
Server Version: 5.6.26-74.0-56-log Percona XtraDB Cluster (GPL), Release rel74.0, Revision 624ef81, WSREP version 25.12, wsrep_25.12

Backup Command:
innobackupex --defaults-file=/etc/mysql/my.cnf --user=root --slave-info --tmpdir=/tmp --stream=tar ./ 2>/tmp/bkup.log | gzip > backup.tar.gz

Backup terminates without error.

Tail of backup log:

YYMMDD HH:MM:SS Executing LOCK BINLOG FOR BACKUP...
Failed to get master binlog coordinates from SHOW SLAVE STATUS
This means that the server is not a replication slave. Ignoring the --slave-info option

After the message "ignoring slave-info" backup actually terminates; it should continue and finish clean backup.

As such --slave-info is irrelevant to PXC and xtrabackup works well without that option though it should handle correctly.

Thanks.

[Sergei Glushchenko (sergei.glushchenko)]

Lets continue the backup instead of failing aborting it in this case as 2.2.x did.

[Max Bubenick (max-bubenick)]

This is not only affecting PXC but any server not running as slave.

[Sergei Glushchenko (sergei.glushchenko)]

https://github.com/percona/percona-xtrabackup/pull/131

[Edwin (ewang-d)]

Thank you Serfgei!

*Edwin Wang *
MySQL Database Consultant

Pythian — love your data

ewang <email address hidden>@pythian.com <email address hidden> | Skype name:
pythianewang

Tel: [phone] ext. 1289

Mobile: [phone]

On Thu, Dec 10, 2015 at 5:48 PM, Sergei Glushchenko <
<email address hidden>> wrote:

> ** Changed in: percona-xtrabackup/2.3
> Milestone: future-2.3-releases => 2.3.3
>
> --
> You received this bug notification because you are subscribed to a
> duplicate bug report (1511893).
> https://bugs.launchpad.net/bugs/1513520
>
> Title:
> xtrabackup doesn't handle --slave-info option well with PXC
>
> Status in Percona XtraBackup:
> Fix Released
> Status in Percona XtraBackup 2.3 series:
> Fix Released
>
> Bug description:
> Xtrabackup Version: xtrabackup 2.3.2
> Server Version: 5.6.26-74.0-56-log Percona XtraDB Cluster (GPL), Release
> rel74.0, Revision 624ef81, WSREP version 25.12, wsrep_25.12
>
> Backup Command:
> innobackupex --defaults-file=/etc/mysql/my.cnf --user=root --slave-info
> --tmpdir=/tmp --stream=tar ./ 2>/tmp/bkup.log | gzip > backup.tar.gz
>
> Backup terminates without error.
>
> Tail of backup log:
>
> YYMMDD HH:MM:SS Executing LOCK BINLOG FOR BACKUP...
> Failed to get master binlog coordinates from SHOW SLAVE STATUS
> This means that the server is not a replication slave. Ignoring the
> --slave-info option
>
>
> After the message "ignoring slave-info" backup actually terminates; it
> should continue and finish clean backup.
>
> As such --slave-info is irrelevant to PXC and xtrabackup works well
> without that option though it should handle correctly.
>
> Thanks.
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/percona-xtrabackup/+bug/1513520/+subscriptions
>

--

--

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXB-738