December 29, 2020 at 8:18 am
Hi Experts,
Have some question related to Lease timeout behaviour in AG.
2020-12-28 02:14:39.540 Server Error: 19419, Severity: 16, State: 1.
2020-12-28 02:14:39.540 Server Windows Server Failover Cluster did not receive a process event signal from SQL Server hosting availability group 'SalesdwAG02' within the lease timeout period.
2020-12-28 02:14:39.550 Server Error: 19407, Severity: 16, State: 1.
2020-12-28 02:14:39.550 Server The lease between availability group 'SalesdwAG02' and the Windows Server Failover Cluster has expired. A connectivity issue occurred between the instance of SQL Server and the Windows Server Failover Cluster. To determine whether the availability group i
2020-12-28 02:14:39.550 Server Always On: The local replica of availability group 'SalesdwAG02' is going offline because either the lease expired or lease renewal failed. This is an informational message only. No user action is required.
2020-12-28 02:14:39.550 Server The state of the local availability replica in availability group 'SalesdwAG02' has changed from 'PRIMARY_NORMAL' to 'RESOLVING_NORMAL'. The state changed because the lease between the local availability replica and Windows Server Failover Clustering (WS
Questions
==========
1. Why and when Lease timeout happens?
2. What value to be set for Lease timeout to start of with?
3. When Lease timeout happended, we expected a Automatic failover to happen, but it didn't happen why? Any reason for this behaviour. We have configure AG with "Synchronous commit" , "Automatic failover".
4. After changing the LeaseTimeout in windows failover cluster, do we need restart the nodes involved in AG to take into effect?
5. In SSMS, If we go to AG properties , we have setting called "Session timeout" default is 10 seconds. Any recommendations of what value to be set?
Regards,
Sam
December 30, 2020 at 9:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
December 31, 2020 at 5:07 am
This was removed by the editor as SPAM
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply