[MXS-2651] Failover/switchover on empty MariaDB replication cluster fails Created: 2019-08-30 Updated: 2020-08-27 Resolved: 2020-08-27 |
|
| Status: | Closed |
| Project: | MariaDB MaxScale |
| Component/s: | failover |
| Affects Version/s: | 2.3.9, 2.4.1 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Major |
| Reporter: | Michael Hinkel | Assignee: | Unassigned |
| Resolution: | Not a Bug | Votes: | 0 |
| Labels: | None | ||
| Description |
|
I've observed, that MaxScale reports the following error when being used on a freshly installed and configured MariaDB replication cluster (MariaDB version 10.4.7 (bionic)): . How to reproduce:
Results
How to work around this issue?
Hopefully there is a way for MaxScale to correclty detect whether or not GTID replication was configured. Maybe the respective variables of the slave nodes could be read and evaluated (e.g. Using_Gtid. The variable Gtid_IO_Pos won't give the correct result, because it only contains a value after at least one transaction has been done. |
| Comments |
| Comment by markus makela [ 2019-10-07 ] |
|
You can run the maxctrl call command mariadbmon reset-replication <monitor-name> <master-name> to initialize the cluster properly. Also make sure you configure replication with MASTER_USE_GTID. |
| Comment by markus makela [ 2020-08-27 ] |
|
As GTID replication is a requirement, this is expected behavior. |