[MXS-1588] Switchover fails randomly Created: 2017-12-21  Updated: 2018-01-03  Resolved: 2018-01-02

Status: Closed
Project: MariaDB MaxScale
Component/s: mariadbmon
Affects Version/s: 2.2.1
Fix Version/s: 2.2.1

Type: Bug Priority: Major
Reporter: Esa Korhonen Assignee: Esa Korhonen
Resolution: Fixed Votes: 0
Labels: failover_issues

Sprint: 2017-49

 Description   

Running switchover may leave some slaves only [Running] and they cannot continue replication. The effect is somewhat random and probably depends on timing between queries during switchover and replication lag. Seems to be fixed by swapping the order of "FLUSH TABLES;" and "FLUSH LOGS;" during master demotion. Another way to fix this would be to add some slack time and more checks and MASTER_GTID_WAIT-calls to make sure the cluster is in sync before "STOP SLAVE".


Generated at Thu Feb 08 04:07:54 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.