FIX: Pacemaker promotes an unsynchronized replica to primary when you use AlwaysOn AG in SQL Server 2017 on Linux

Applies to: SQL Server 2017 Developer LinuxSQL Server 2017 Enterprise on LinuxSQL Server 2017 Enterprise Core on Linux

Symptoms


Assume that you use AlwaysOn availability groups (AG) in SQL Server 2017 on a Linux Pacemaker cluster. When the primary goes down, if there are one or more ASYNCHRONOUS_COMMIT replicas in the cluster, Pacemaker may promote an unsynchronized replica to the primary.

Resolution


This issue is fixed in the following cumulative update for SQL Server:

       Cumulative Update 5 for SQL Server 2017

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 that Microsoft uses to describe software updates.