I am using SQL 2016 (13.0.5888.11).
Last Saturday (18th September), in non-office hours, my SQL Server Always On Availability Group got much errors, from the primary server's Event Viewer, I see:
1480 - The availability group database "xxxxx" is changing roles from "PRIMARY" to "RESOLVING" because the mirroring session or availability group failed over due to role synchronization.
41049 - Always On Availability Groups: Local Windows Server Failover Clustering node is no longer online.
41092 - Always On: The availability replica manager is going offline because the local Windows Server Failover Clustering (WSFC) node has lost quorum.
However, some how it started by itself, .........
41110 - Always On: The availability replica manager is starting.
In the morning, when we came back to office, I found the SQL Server runs as normal no role fail over occurred.
My Session-Timeout : 10 seconds (default).
I can't explain these to my colleagues.
- Why no failover occurred?
- Did it really no failover during the non-office hours?
- If there is a role switch, I can find it out from Event Viewer, but in my case, I couldn't.
Can you help me? Thanks a lot.