Operational Defect Database

BugZero found this defect 459 days ago.

Microsoft SQL Server | 2162849

Fixes a self-deadlock issue where internal update statistic transactions persist locks, which can cause unresolved deadlocks with user queries. The issue occurs because the lock isn't released when the system runs the update query statistics. After you apply this fix, the lock can be released as intended.

Last update date:

2/16/2023

Affected products:

SQL Server 2022 on Linux

SQL Server 2022 on Windows

Affected releases:

build lower than 16.0.4003.1

Fixed releases:

16.0.4003.1

Description:

Fixes a self-deadlock issue where internal update statistic transactions persist locks, which can cause unresolved deadlocks with user queries. The issue occurs because the lock isn't released when the system runs the update query statistics. After you apply this fix, the lock can be released as intended.

Additional Resources / Links

Share:

BugZero® Risk Score

What's this?

Coming soon

Status

Unavailable

Learn More

Search:

...