June 27, 2016 at 6:26 pm
All, I have this error in a logfile "Unable to access availability database because the database replica is not in the PRIMARY or SECONDARY role. Connections to an availability database is permitted only when the database replica is in the PRIMARY or SECONDARY role. Try the operation again later.
2016-06-26 19:43:31.60 Logon Error: 983, Severity: 14, State: 1.
Not freaking out but would like to know on how to solve.
June 27, 2016 at 7:58 pm
What is the status of the other database? Is it suspect, offline or something like that?
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
June 27, 2016 at 11:14 pm
take a look at these links: https://social.technet.microsoft.com/Forums/office/en-US/0f7fd256-d469-4408-982c-0f1a9aa74026/sql-server-2014-always-on-ha-takes-814-seconds-to-fail-over-application-side-timeouts-occur?forum=winserverClustering
https://blogs.msdn.microsoft.com/sql_pfe_blog/2013/04/08/sql-2012-alwayson-availability-groups-automatic-failover-doesnt-occur-or-does-it-a-look-at-the-logs/ [/url]
June 28, 2016 at 8:26 am
TheSQLGuru (6/27/2016)
What is the status of the other database? Is it suspect, offline or something like that?
All DBs are online and in sync
This was the error in the log file
AlwaysOn: The availability replica manager is going offline because the local Windows Server Failover Clustering (WSFC) node has lost quorum.
June 28, 2016 at 3:31 pm
Chitown (6/28/2016)
TheSQLGuru (6/27/2016)
What is the status of the other database? Is it suspect, offline or something like that?All DBs are online and in sync
This was the error in the log file
AlwaysOn: The availability replica manager is going offline because the local Windows Server Failover Clustering (WSFC) node has lost quorum.
The error tells you quite directly what the issue is. There are a number of possible scenarios and recoveries here. Can't advise you without details of your environment. But WSFC quorum stuff is easily searchable ...
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
June 29, 2016 at 7:43 am
Chitown (6/28/2016)
TheSQLGuru (6/27/2016)
What is the status of the other database? Is it suspect, offline or something like that?All DBs are online and in sync
This was the error in the log file
AlwaysOn: The availability replica manager is going offline because the local Windows Server Failover Clustering (WSFC) node has lost quorum.
Check the event logs and the cluster events, my guess is a network comm issue.
Can you provide more detail on the networks used for the WSFC, also does a cluster validation report come back clean
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 5, 2016 at 8:56 am
The validation report didn't come clean. There are some network related issues we are experiencing. For time being, I have deleted Always ON. (T logs backup are in place every 15 minutes). Question. Do I shutdown failover cluster as well and leave it as it is? Because I am still seeing connectivity issues.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply