Empty xtrabackup_slave_info file is created if --slave info passed with master server
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona XtraBackup moved to https://jira.percona.com/projects/PXB | Status tracked in 2.4 | |||||
2.4 |
Confirmed
|
High
|
Unassigned |
Bug Description
Testing latest 2.4 and 2.4 branch.
Taking backup with 2.4 + PS 5.6 master server:
/home/shahriyar
The result:
xtrabackup: The latest check point (for incremental): '1632376'
xtrabackup: Stopping log copying thread.
.171127 12:58:32 >> log scanned up to (1632376)
171127 12:58:32 Executing UNLOCK BINLOG
171127 12:58:32 Executing UNLOCK TABLES
171127 12:58:32 All tables unlocked
171127 12:58:32 Backup created in directory '/home/
MySQL binlog position: filename 'mysql-bin.000002', position '151', GTID of the last change ''
171127 12:58:32 [00] Writing /home/shahriyar
171127 12:58:32 [00] ...done
171127 12:58:32 [00] Writing /home/shahriyar
171127 12:58:32 [00] ...done
xtrabackup: Transaction log of lsn (1632369) to (1632376) was copied.
171127 12:58:33 completed OK!
In backup directory:
$ ls
backup-my.cnf ibdata1 mysql performance_schema test xtrabackup_
$ cat xtrabackup_
$ ls -ltr xtrabackup_
-rw-r----- 1 shahriyar.rzaev shahriyar.rzaev 0 Noy 27 12:58 xtrabackup_
Doing same thing with PXB 2.3 + PS 5.6:
/home/shahriyar
171127 13:03:01 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
171127 13:03:01 [00] Writing xtrabackup_
171127 13:03:01 [00] ...done
171127 13:03:01 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
xtrabackup: The latest check point (for incremental): '1632383'
xtrabackup: Stopping log copying thread.
.171127 13:03:01 >> log scanned up to (1632383)
171127 13:03:02 Executing UNLOCK BINLOG
171127 13:03:02 Executing UNLOCK TABLES
171127 13:03:02 All tables unlocked
171127 13:03:02 Backup created in directory '/home/
MySQL binlog position: filename 'mysql-bin.000002', position '151', GTID of the last change ''
171127 13:03:02 [00] Writing backup-my.cnf
171127 13:03:02 [00] ...done
171127 13:03:02 [00] Writing xtrabackup_info
171127 13:03:02 [00] ...done
xtrabackup: Transaction log of lsn (1632376) to (1632383) was copied.
171127 13:03:02 completed OK!
There is no xtrabackup_
$ ls
backup-my.cnf ibdata1 mysql performance_schema test xtrabackup_
Also please note the difference between outputs:
With 2.3 there is a note about ignoring --slave-info:
171127 13:03:01 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
171127 13:03:01 [00] Writing xtrabackup_
With 2.4 there is no such thing.
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/ /jira.percona. com/browse/ PXB-517