January 13, 2015 at 3:31 am
Hello,
I have a problem I don't understand with SQL Server 2012 SP2.
I have an AlwaysOn AG configuration, with 2 nodes. The AG only have one database.
On my first node, if I shutdown the SQL Server service, the cluster shows that the "role" which hold the SQL Server listener is on "failed".
The cluster console shows 4 events with the ID 1069 (Cluster resource 'XXXX' of type 'SQL Server Availability Group' in clustered role 'XXXX' 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.)
Then I have an ID 1205 (The Cluster service failed to bring clustered role 'XXXX' completely online or offline. One or more resources may be in a failed state. This may impact the availability of the clustered role.)
Finally, I have the ID 1254 (Clustered role 'XXXX' has exceeded its failover threshold. It has exhausted the configured number of failover attempts within the failover period of time allotted to it and will be left in a failed state. No additional attempts will be made to bring the role online or fail it over to another node in the cluster. Please check the events associated with the failure. After the issues causing the failure are resolved the role can be brought online manually or the cluster may attempt to bring it online again after the restart delay period.)
So my understanding is that it tries to restart SQL Server on the node I manualy shutdown, but it can't. After serveral tries, it give up, but it doesn't try to failover on the other node, wich annoy me a lot.
If I try to do the opposite (shutdown the service on the other node), it's even worth : the cluster console doesn't see that the service is down.
Do you have any idea about what is wrong with my configuration ?
Thanks in advance,
Regards,
Vincent
January 13, 2015 at 5:59 am
What quorum configuration have you employed for the 2 node cluster?
What settings have been applied to the AlwaysOn group, synch or asynch, manual or auto failover?
Are the databases synchronised?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply