Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.2.7
-
None
Description
With MDEV-11177 being fixed we are now getting duplicate server IDs reported properly in the slaves error log.
Affected slaves will still try to reconnect immediately though, so flooding their error log with several log lines per second.
As it's clear that a duplicate server id requires a configuration fix that wouldn't happen within a fraction of a second slaves should throttle their reconnect attempts to one per second max., maybe even less.
Attachments
Issue Links
- relates to
-
MDEV-11177 mysqlbinlog exits silently without error when another instance connects to server
-
- Closed
-
I would actually think that it makes no sense at all to try to reconnect automatically in this case, but instead let the administrator solve the problem and resume replication manually. Automatic reconnect makes both slave non-functional anyway, because they keep going in a loop and only burn CPU cycles and disk: slave1 connects, then slave2 connects and kicks out slave1, slave1 reconnects and kicks out slave2, slave2 reconnects and kicks out slave1, etc.
But I'll leave it to Elkin to decide what's the best way to handle it.