FIX: AlwaysOn database on a secondary replica shows a "NOT SYNCHRONIZING" status in SQL Server 2014

Symptoms

Assume that you use the AlwaysOn Availability Groups feature in Microsoft SQL Server 2014. After you restart an instance of SQL Server, the databases that participate in the availability groups may display a "NOT SYNCHRONIZING" status on the secondary replicas. Additionally, you can't join or remove the databases from the availability groups. And you also can't remove the availability groups from the secondary replicas.

In this situation, error messages that resemble the following are logged in the SQL Server error log:

Starting up database 'Database_Name'.
Skipping the default startup of database 'Database_Name' because the database belongs to an availability group (Group ID: Group_ID). The database will be started by the availability group. This is an informational message only. No user action is required.
State information for database 'Database_Name' - Hardended Lsn: '(0:0:0)' Commit LSN: '(0:0:0)' Commit Time: 'datetime'
AlwaysOn Availability Groups connection with primary database terminated for secondary database 'Database_Name' on the availability replica 'Replica_Name' with Replica ID: {Replica_ID}. This is an informational message only. No user action is required.
State information for database 'Database_Name' - Hardended Lsn: '(0:0:0)' Commit LSN: '(0:0:0)' Commit Time: 'datetime'
State information for database 'Database_Name' - Hardended Lsn: '(0:0:0)' Commit LSN: '(0:0:0)' Commit Time: 'datetime'
Starting up database 'Database_Name'.
AlwaysOn Availability Groups connection with primary database established for secondary database 'Database_Name' on the availability replica 'REPLICA_NAME' with Replica ID: {Replica_ID}. This is an informational message only. No user action is required.
2289 transactions rolled forward in database 'Database_Name' (107:0). This is an informational message only. No user action is required.
CHECKDB for database 'Database_Name' finished without errors on datetime (local time). This is an informational message only; no user action is required.
AlwaysOn Availability Groups connection with primary database terminated for secondary database 'Database_Name' on the availability replica 'REPLICA_NAME' with Replica ID: {Replica_ID}. This is an informational message only. No user action is required.

Cause

This issue occurs because of a deadlock condition between a redo thread and a switch-role thread.

Resolution

This problem was first fixed in the following cumulative updates for SQL Server 2014:


About cumulative updates for SQL Server
About cumulative updates for SQL Server

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References

Learn about the terminology Microsoft uses to describe software updates.
Özellikler

Makale No: 3057876 - Son İnceleme: 17 Ağu 2015 - Düzeltme: 1

Geri bildirim