May 12, 2016 at 3:09 am
Hi Experts,
Am facing the issue in Always on Environment.
My application team is running a batch job from UI which will DML operations in DB.
after sometime they said their job got aborted. when I checked in SQL error logs following is the error logged.
"AlwaysOn: The local replica of availability group XXX is going offline because either the lease expired or lease renewal failed. This is an informational message only. No user action is required."
and in Clustered events below error is logged:
"Cluster resource XXX of type 'SQL Server Availability Group' in clustered role XXX failed.
Based on the failure policies for the resource and role, the cluster service may try to bring the resource online on this node or move the group to another node of the cluster and then restart it. Check the resource and group state using Failover Cluster Manager or the Get-ClusterResource Windows PowerShell cmdlet."
I checked here primary is not failing over to secondary since there is no issue with cluster.
Please advice me to resolve the issue.
May 13, 2016 at 12:24 am
Hi Experts, adding to the above details, below are the error messages logged in sql server at the time of job failure.
The lease between availability group XXX 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 is
AlwaysOn: The local replica of availability group XXX is going offline because either the lease expired or lease renewal failed. This is an informational message only. No user action is required.
The state of the local availability replica in availability group XXX has changed from 'PRIMARY_NORMAL' to 'RESOLVING_NORMAL'. The state changed because the lease between the local availability replica and Windows Server Failover Clustering (WSFC)
The availability group database "XXX" is changing roles from "PRIMARY" to "RESOLVING" because the mirroring session or availability group failed over due to role synchronization. This is an informational message only. No user action is required.
AlwaysOn Availability Groups connection with secondary database terminated for primary database XXX on the availability replica XXX with Replica ID: {63f85b4b-ceea-4600-af80-1ee1d317dcf7}. This is an informational message only. No u
Stopped listening on virtual network name XXX. No user action is required.
Need your help on this.
May 15, 2016 at 1:01 pm
sounds like you're using DHCP assigned addresses, configure reservations for the addresses
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 24, 2016 at 1:10 am
Hi, Can you please let me know how to do those reservations in the system.
May 24, 2016 at 6:29 am
MasterDB (5/24/2016)
Hi, Can you please let me know how to do those reservations in the system.
If you have a handy friendly network sysadmin nearby, that would be something they can set up for you.
September 23, 2019 at 11:34 am
I also facing the same issue.
Have you cleared this? Any clue to resolve this.?
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply