When GTID_MODE=ON and slave uses MASTER_AUTO_POSITION=0, GTID is used in --slave-info

[Vasily Nemkov]

Copied from here: https://jira.percona.com/browse/PXB-193

When running xtrabackup --backup --slave-info I am getting a gtid, even though master_auto_position=0:

[root@perconaserver vagrant]# cat xtrabackup_backupfiles/xtrabackup_slave_info
SET GLOBAL gtid_purged='ad1ce570-f9d1-11e6-b066-08002789cd2e:1';
CHANGE MASTER TO MASTER_AUTO_POSITION=1

I am running:

    pxb 2.4.7
    percona server 5.7.18
    gtid_mode=on, master_auto_position=0
    running xtrabackup --backup --slave-info

I would expect as master_auto_position=0 that the backup uses the standard file and position OR have both options available all the time.

[Vasily Nemkov (vasily.nemkov)]

PR merged into 2.3 https://github.com/percona/percona-xtrabackup/pull/380

[Vasily Nemkov (vasily.nemkov)]

PR merged into 2.4: https://github.com/percona/percona-xtrabackup/pull/377

[Vasily Nemkov (vasily.nemkov)]

PXB used to determine GTID mode on slave incorrectly, and thus generated invalid xtrabackup_slave_info.

For MariaDB PXB used `gtid_slave_pos` variable, now we use `Using_Gtid` from `SHOW SLAVE STATUS`.
For MySQL PXB used `Executed_Gtid_Set` instead of correct `Auto_Position` from `SHOW SLAVE STATUS`.

[Shahriyar Rzayev (rzayev-sehriyar)]

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