[MDEV-13448] Slave should reconnect less quickly when being disconnected due to duplicate server id Created: 2017-08-04 Updated: 2018-10-30 |
|
| Status: | Confirmed |
| Project: | MariaDB Server |
| Component/s: | Replication |
| Affects Version/s: | 10.2.7 |
| Fix Version/s: | 10.2 |
| Type: | Bug | Priority: | Minor |
| Reporter: | Hartmut Holzgraefe | Assignee: | Andrei Elkin |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||||||
| Description |
|
With 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. |
| Comments |
| Comment by Elena Stepanova [ 2017-08-04 ] |
|
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. |
| Comment by Andrei Elkin [ 2017-08-05 ] |
|
I agree with As to the fighting of two identically numbered slaves a way to prevent |
| Comment by Elena Stepanova [ 2017-08-05 ] |
|
Just to clarify, I meant that automatic reconnect doesn't make sense in this particular situation, when identical slave IDs are detected, not in general. For example, automatic reconnect after a temporary loss of connection to the master, e.g. due to network issues, master restart and such, makes all sense (although, I have no strong opinion on the right default value of retries). |
| Comment by Andrei Elkin [ 2017-08-07 ] |
|
Let also expand my response idea, the identical slave IDs may appear without in sense two master side may appear with a single slave server, to remind about a zombie dump thread. |