December 31, 2015 at 1:38 pm
Came across one of the replicas in a 2012 Availability Group, which I am able to connect to via SSMS and run queries...but when I use SSMS to expand the databases it never recovers / responds...
I then reviewed to see if something was blocking my process, nope, then I went to active processes and their current wait and to my surprise every active process had a wait type of HADR_AG_MUTEX.
I cannot find anything online that would reflect why this is essentially locking everything up on this server from running but it is.
The definition for that wait type is as follows:
Occurs when an AlwaysOn DDL statement or Windows Server Failover Clustering command is waiting for exclusive read/write access to the configuration of an availability group.
I am not sure if there is a way to determine what that command that is waiting actually is.
At this moment in time, the only thing I can think of trying is rebooting this secondary replica and seeing if the server comes back up and resumes normal operations.
Additionally the A.G. is working fine as far as I can tell, the databases participating are all synchronized.
Has anyone seen this type of behavior before?
Thanks for any replies.
Lee
December 31, 2015 at 2:47 pm
I rebooted the secondary replica and the issue resolved...would be nice to know if anyone else has ever had this issue.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply