Somewhat urgent issue related to AG

  • 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.

  • 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

  • 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]

  • 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.

  • 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

  • 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" 😉

  • 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