Hello,
I've just migrated to latest orchestrator version (3.0.14).
My DB topology is fairly simple 1 active master / 1 passive master and multiples readonly slaves with no binlogs. Percona (Oracle) GTIDs are enabled and in use (auto master position).
When trying to relocate slaves from one master to the other one by using this :
orchestrator-client -c can-replicate-from-gtid -i slave1 -d master2
I got this error :
Instance master2 has purged GTID entries not found on slave1
I checked on both servers and GTID were correct and no subset was missing.
After digging a while, I found that executed_gtid_set information is missing from orchestrator internal DB for MySQL instances w/o binlogs.
The check is done here : https://github.com/github/orchestrator/blob/7bef26f042aafbd956daeaede0cd4aab2ba46e65/go/inst/instance_topology.go#L558
Executed_Gtid_Set is fetched here :
https://github.com/github/orchestrator/blob/7bef26f042aafbd956daeaede0cd4aab2ba46e65/go/inst/instance_dao.go#L398
I made a fix and moved this into the select that gets other global informations (gtid_purged etc ..) :
fuyar@02153a4
I dont know if this is OK and I should push a PR ?
WDYT ?
Thanks !