I have A Problem In Alwayson Configuration - SQL 2012 SP3 -Windows server 2012 "FCI+AG" Configuration
Xnode-1 Xnode-2 'FCI' Cluser Name XDB + Xnode3 "Read-only Replica NonFailover Asynccommit " No listener All connect to XDB Cluster
Cluster Policy Role HealthCheckTimeout 40000 LeaseTimeout 20000 FailureConditionLevel 3
Suddenly Primary Replica Xdb Database Not Accessible
Unable to access database 'PROD_DB' because its replica role is RESOLVING which does not allow connections. Try the operation again later.
message The availability group database "prod_DB" 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.
and Secondary X-node3 Read Only Auot Check database Running For 5-7 Min after Finishing Check Database
Pls. Need to know WHY PRIMARY REPLICA Not Accessible !and Please How TO prevent that occur again ?
Another Log error AlwaysOn: The local replica of availability group 'X_AG' is going offline because the corresponding resource in the Windows Server Failover Clustering (WSFC) cluster is no longer online. This is an informational message only. No user action is required.
The state of the local availability replica in availability group 'X_AG' has changed from 'SECONDARY_NORMAL' to 'RESOLVING_NORMAL'. The replica state changed because of either a startup, a failover, a communication issue, or a cluster error. For more information, see the availability group dashboard, SQL Server error log, Windows Server Failover Cluster management console or Windows Server Failover Cluster log.