Note
Access to this page requires authorization. You can try signing in or .
Access to this page requires authorization. You can try .
KB5027505 - Cumulative Update 6 for SQL Server 2022
Release Date: July 13, 2023
Version: 16.0.4055.4
Summary
This article describes Cumulative Update package 6 (CU6) for Microsoft SQL Server 2022. This update contains 15 fixes that were issued after the release of SQL Server 2022 Cumulative Update 5, and it updates components in the following builds:
- SQL Server - Product version: 16.0.4055.4, file version: 2022.160.4055.4
- Analysis Services - Product version: 16.0.43.219, file version: 2022.160.43.219
Known issues in this update
Incorrect behavior of SESSION_CONTEXT in parallel plans
Queries that use the built-in SESSION_CONTEXT function might return incorrect results or trigger access violation (AV) dump files when run in parallel query plans. This issue occurs because of the manner in which SESSION_CONTEXT interacts with parallel execution threads, particularly if the session is reset for reuse.
For more information, see the Known issues section in SESSION_CONTEXT.
Improvements and fixes included in this update
A downloadable Excel workbook that contains a summary list of builds, together with their current support lifecycle, is available. The Excel file also contains detailed fix lists for SQL Server 2022, SQL Server 2019, and SQL Server 2017. Select to download this Excel file now.
Note
Individual entries in the following table can be referenced directly through a bookmark. If you select any bug reference ID in the table, a bookmark tag is added to the URL by using the "#NNNNNNN" format. You can then share this URL with others so that they can jump directly to the desired fix in the table.
For more information about the bugs that are fixed and enhancements that are included in this cumulative update, see the following Microsoft Knowledge Base articles.
| Bug reference | Description | Fix area | Component | Platform |
|---|---|---|---|---|
| 2439381 | Fixes potential memory access violations and incorrect results when executing specific Data Analysis Expressions (DAX) queries that trigger the internal Horizontal Fusion query optimization. Note: Before you apply the cumulative update, you can disable the feature by setting the DAX\HorizontalFusion configuration option to 0 as a workaround. |
Analysis Services | Analysis Services | Windows |
| 2442140 | Fixes an issue in which an alias error occurs during a database upgrade if you apply the name "en" to an attribute. | Master Data Services | Master Data Services | Windows |
| 2424714 | Fixes a non-yielding scheduler condition (Msg 17883) that you encounter when backup operations can't handle abort signals correctly in some cases while waiting for pending I/O writes. | SQL Server Engine | Backup Restore | All |
| 2449506 | Fixes an issue in which the SQL Server instance stops responding when it calls a memory-optimized stored procedure from another memory-optimized stored procedure in which the called procedure isn't yet in the plan cache, and a statistics update is triggered during query compilation. | SQL Server Engine | In-Memory OLTP | All |
| 2382857 | Fixes an issue in which the node profile information from parallel threads for Cardinality Estimation (CE) feedback is missing. After you apply this fix, CE feedback can suggest hints for parallel queries. | SQL Server Engine | Query Execution | All |
| 2470755 | Fixes an access violation that you encounter under a race condition if the parameter sensitive plan (PSP) optimization feature has Query Store integration enabled, and a query variant's reference to its associated dispatcher or original parent statement is dereferenced prematurely within the in-memory representation of the Query Store. | SQL Server Engine | Query Execution | All |
| 2434843 | Fixes an issue in which a thread deadlock between Query Store (QDS) background tasks blocks the database shutdown. | SQL Server Engine | Query Store | All |
| 2266818 | Adds a new error 673 that helps avoid the assertion failure (Location: IndexRowScanner.cpp:1449; Expression: m_versionStatus.IsVisible ()) that you might encounter when you enable change tracking on a database that has snapshot isolation turned on. Error message: Failure to access row object in snapshot isolation. Note: You need to turn on trace flag 8285. |
SQL Server Engine | Replication | All |
| 2442348 | Fixes an issue in which applying a patch on the secondary replica or performing an in-place upgrade fails if a database has change data capture (CDC) enabled and is in an availability group. The following error is returned: <DateTime> Error: 912, Severity: 21, State: 2. <DateTime> Script level upgrade for database 'master' failed because upgrade step 'repl_upgrade.sql' encountered error 35262, state 4, severity 10. This is a serious error condition which might interfere with regular operation and the database will be taken offline. If the error happened during upgrade of the 'master' database, it will prevent the entire SQL Server instance from starting. Examine the previous errorlog entries for errors, take the appropriate corrective actions and re-start the database so that the script upgrade steps run to completion. |
SQL Server Engine | Replication | Windows |
| 2397656 | FIX: SQL Server Audit Events fail to write to the Security log (KB4052136) | SQL Server Engine | Security Infrastructure | Windows |
| 2472403 | Fixes the following error 41313 that you encounter when you create a natively compiled stored procedure that contains a CASE statement and a column that uses dynamic data masking (DDM): Msg 41313, Level 16, State 1, Procedure <ProcedureName>, Line <LineNumber> [Batch Start Line <LineNumber>] The C compiler encountered a failure. The exit code was 2. |
SQL Server Engine | Security Infrastructure | All |
| 2475171 | Enables Microsoft Entra authentication for SQL Server replication. Microsoft Entra authentication for replication can be disabled by using trace flag 11561. Using Microsoft Entra authentication for replication is currently in public preview. For more information, see Configure replication with Microsoft Entra authentication. | SQL Server Engine | Security Infrastructure | All |
| 2405773 | Fixes an issue in which upgrading SQL Server 2017 to SQL Server 2022 on Linux fails and returns an error such as "'model_replicatedmaster.ldf' file does not exist." | SQL Server Engine | SQL Agent | Linux |
| 2425643 | Fixes an issue in which running DBCC CHECKDB reports RBPEX::NotifyFileShutdown in the SQL Server error log. |
SQL Server Engine | SQL Server Engine | All |
| 2431805 | Fixes a non-yielding dump issue that you encounter when the IORequestDispenser is waiting for the I/O to finish. |
SQL Server Engine | Storage Management | All |
How to obtain or download this or the latest cumulative update package
File information
Notes for this update
How to uninstall this update
References
- Announcing updates to the SQL Server Incremental Servicing Model (ISM)
- SQL Server Service Packs are no longer supported starting from SQL Server 2017
- Determine which version and edition of SQL Server Database Engine is running
- Servicing models for SQL Server
- Naming schema and Fix area descriptions for SQL Server software update packages
- Description of the standard terminology that is used to describe Microsoft software updates
Feedback
Was this page helpful?