Customer is getting the following alarm: Availability Group - Failover Availability Message: Failover must be done manually
The customer has a SQL Server availability group in the Linux OS and they are following the "Two synchronous replicas and a configuration only replica" as described in the SQL Server documentation:
Because of that the configuration only replica, it is not a node in which the customer can failover to and because of that Spotlight does not recognize it and gave us the "must manually failover" error message.
A two-replica configuration that requires the ability to automatically fail over to another replica requires the use of a configuration-only replica, as described in Configuration-only replica and quorum. Configuration-only replicas were introduced in SQL Server 2017 (14.x) Cumulative Update 1 (CU1), so that should be the minimum version deployed for this configuration. From https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-availability-group-overview?view=sql-server-ver15
Enhancement request opened SOSSE-I-131
Please refer - https://jira.labs.quest.com/browse/SEMB-1350
