# how to  get {master\_log\_file,mater\_log\_pos} when gtid\_mode is enabled

**URL:** <https://forums.percona.com/t/how-to-get-master-log-file-mater-log-pos-when-gtid-mode-is-enabled/5727>\
**Category:** Percona XtraBackup\
**Created:** [July 11, 2017, 10:28pm UTC](https://forums.percona.com/t/how-to-get-master-log-file-mater-log-pos-when-gtid-mode-is-enabled/5727 "2017-07-11T22:28:38Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![seagen](https://avatars.discourse-cdn.com/v4/letter/s/439d5e/32.png) [@seagen](https://forums.percona.com/u/seagen)\
**Post date:** [July 11, 2017, 10:28pm UTC](https://forums.percona.com/t/how-to-get-master-log-file-mater-log-pos-when-gtid-mode-is-enabled/5727/1 "2017-07-11T22:28:38Z")

</div>

GTID is enabled on my instance. when using xtrabackup with 1) --slave-info 2) --prepare options, there is only master\_auto\_position option in the xtrabackup\_slave\_info file, instead of master\_log\_file and master\_log\_pos.

Is there any option available on the current versions for my need? I need to pass {file,pos} to mysqlbinlog, which is used to taking back up binlogs every full backup later.

thanks in advance!

---

<div class="post-metadata">

**Author:** ![mirfan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mirfan/32/16890_2.png) [@mirfan](https://forums.percona.com/u/mirfan)\
**Post date:** [July 18, 2017, 7:37am UTC](https://forums.percona.com/t/how-to-get-master-log-file-mater-log-pos-when-gtid-mode-is-enabled/5727/2 "2017-07-18T07:37:40Z")

</div>

This link contains steps [url][https://www.percona.com/doc/percona-xtrabackup/LATEST/howtos/recipes\_ibkx\_gtid.html[/url]](https://www.percona.com/doc/percona-xtrabackup/LATEST/howtos/recipes_ibkx_gtid.html%5B/url%5D)

Can you provide exact command used and listing of backup directory. Along with that version you are using.

$ xtrabackup --version

---

<div class="post-metadata">

**Author:** ![seagen](https://avatars.discourse-cdn.com/v4/letter/s/439d5e/32.png) [@seagen](https://forums.percona.com/u/seagen)\
**Post date:** [July 20, 2017, 9:21pm UTC](https://forums.percona.com/t/how-to-get-master-log-file-mater-log-pos-when-gtid-mode-is-enabled/5727/3 "2017-07-20T21:21:47Z")

</div>

Sorry for my pool english…it might be not clear to clarify my issue before. Actually I only need {file, pos} from xtrabackup\_slave\_info, but I found that the --slave-info option could not get the pair value when gtid\_mode is enabled.

a) As follow is my commands:  
shell\> ${xtrabackup} --defaults-file=${MYCNF} --slave-info --backup --target-dir=${localdir}/${bakdate}/ 2\>${localdir}/xtrabackup\_${bakdate}.log  
shell\>${xtrabackup} --defaults-file=${MYCNF} --prepare --target-dir=${localdir}/${bakdate}/ 2\>${localdir}/xtrabackup\_${bakdate}.log

b) xtrabackup version: 2.4.7

---

<div class="post-metadata">

**Author:** ![mirfan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mirfan/32/16890_2.png) [@mirfan](https://forums.percona.com/u/mirfan)\
**Post date:** [July 27, 2017, 2:42am UTC](https://forums.percona.com/t/how-to-get-master-log-file-mater-log-pos-when-gtid-mode-is-enabled/5727/4 "2017-07-27T02:42:30Z")

</div>

It seems like you are hitting this bug [url][https://bugs.launchpad.net/percona-xtrabackup/+bug/1705193[/url]](https://bugs.launchpad.net/percona-xtrabackup/+bug/1705193%5B/url%5D)  
Can you try Percona Xtrabackup 2.3.9 or 2.4.8 instead. In case, If still fails then provide listing of target directory and show us contents of xtrabackup\_slave\_info file

---

<div class="post-metadata">

**Author:** ![seagen](https://avatars.discourse-cdn.com/v4/letter/s/439d5e/32.png) [@seagen](https://forums.percona.com/u/seagen)\
**Post date:** [August 29, 2017, 1:42am UTC](https://forums.percona.com/t/how-to-get-master-log-file-mater-log-pos-when-gtid-mode-is-enabled/5727/5 "2017-08-29T01:42:15Z")

</div>

Thanks mirfan. I already read through the above bug. well I’m lucky to hit it 😛