HiveBrain v1.2.0
Get Started
← Back to all entries
debugsqlMinor

SQL Server 2014 Avaliability Group DbMgrPartnerCommitPolicy

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
groupsqlavaliabilitydbmgrpartnercommitpolicyserver2014

Problem

I have an environment with 2 Windows Server 2012 R2 servers, both with SQL Server 2014 Expensive edition.

Whenever a change happens in the AGs (such as: AlwaysOn Availability Groups connection with secondary database established for primary database 'AGDatabase' on the availability replica 'SecondaryReplicaThatIRestarted'), I get an error like this, in my SQL error log:


Source: SPID52s


Message

DbMgrPartnerCommitPolicy::SetSyncState:00000003BFC0B0E0:1

Ending with a result like this:

Imgur: Screenshot of the errorlog

EDIT:

Nothing in the Windows Error log, not even the mentioned error, which leads me to believe it's something SQL internal that's being leaked out into the errorlog.

Any ideas of what this could be caused by? I've set up multiple setups similiar to this, and this is the first time I've seen it.
I plan on patching the SQL to SP1 this week, however I don't see the error in the release notes.

Solution

For future readers :

DbMgrPartnerCommitPolicy::SetSyncState:00000003BFC0B0E0:1

The last integer describes the AG state

0 - Not Joined to AG
1 - Not Synchronized
2 - Suspended
4 - Synchronized
8 - Redo (redoing log)


Ref : DbMgrPartnerCommitPolicy::SetSyncState May Seem More Mysterious than It Actually Is

Code Snippets

0 - Not Joined to AG
1 - Not Synchronized
2 - Suspended
4 - Synchronized
8 - Redo (redoing log)

Context

StackExchange Database Administrators Q#112732, answer score: 5

Revisions (0)

No revisions yet.