Issue with --safe-slave-backup option in 2.4.4
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona XtraBackup moved to https://jira.percona.com/projects/PXB | Status tracked in 2.4 | |||||
2.3 |
Fix Released
|
High
|
Sergei Glushchenko | |||
2.4 |
Fix Released
|
High
|
Sergei Glushchenko |
Bug Description
Hi,
The --safe-slave-option does not correctly operating its 3 sec time delay for re-tries.
Running an incremental backup this morning it failed while checking open tmp tables. Checking the log showed the 100 attempts with a 3 sec interval had only taken 1 sec in total. See below.
Mike
160916 08:22:06 Slave open temp tables: 1
160916 08:22:06 Starting slave SQL thread, waiting 3 seconds, then checking Slave_open_
...
160916 08:22:06 Slave open temp tables: 1
160916 08:22:07 Starting slave SQL thread, waiting 3 seconds, then checking Slave_open_
160916 08:22:07 Slave open temp tables: 1
160916 08:22:07 Restarting slave SQL thread.
160916 08:22:07 Slave_open_
Unsurprisingly, the backup failed, though a re-run was OK
https:/ /github. com/percona/ percona- xtrabackup/ pull/249