[MXS-4226] Force a Switchover Created: 2022-07-29  Updated: 2023-09-27  Resolved: 2023-06-19

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

Type: New Feature Priority: Major
Reporter: Edward Stoever Assignee: Esa Korhonen
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MXS-2744 Switchover improvements Closed
Sprint: MXS-SPRINT-183, MXS-SPRINT-184

 Description   

Error seen by users:

2022-06-16 22:44:55   warning: [mariadbmon] Query 'SET STATEMENT max_statement_time=3 FOR SET GLOBAL read_only=1;' timed out on 'rock4'. Retrying with 3.0 seconds left.
 
2022-06-16 22:44:58   error  : [mariadbmon] Failed to enable read_only on 'rock4': Query 'SET STATEMENT max_statement_time=3 FOR SET GLOBAL read_only=1;' failed on 'rock4': 'Query execution was interrupted (max_statement_time exceeded)' (1969).
 
2022-06-16 22:44:58   error  : [mariadbmon] Switchover rock4 -> rock1 failed.

I believe the only way to do this is to force users off of the database by killing connections.


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