Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. FIX: Contained AG master database dependency creates deadlock during replica restart at certain condition in SQL Server 2019

FIX: Contained AG master database dependency creates deadlock during replica restart at certain condition in SQL Server 2019

View products that this article applies to.

Symptoms

Assume that contained Availability Group (AG) DTE support is added in SQL Server 2019 which will create database startup dependency. The AG master database has to be started up first. This dependency creates deadlock during the replica resolving state. 

↑ Back to the top

Status

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

↑ Back to the top

Resolution

This issue is fixed in the following cumulative update for SQL Server:
About cumulative updates for SQL Server:
Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server:

↑ Back to the top

References

Learn about the terminology that Microsoft uses to describe software updates.

↑ Back to the top

Keywords: kbqfe, kbfix, kbnotautohotfix, kbsurveynew, AG master database dependency creates deadlock, Dependency of contained AG master database in SQL Server 2019, kb, kbHotfixAuto, CI114004, kbexpertiseinter

↑ Back to the top

Article Info
Article ID : 4540343
Revision : 168
Created on : 2/15/2020
Published on : 2/15/2020
Exists online : False
Views : 437