Note

Access to this page requires authorization. You can try signing in or .

Access to this page requires authorization. You can try .

KB5030731 - Cumulative Update 9 for SQL Server 2022

  • Applies to: SQL Server 2022 on Windows, SQL Server 2022 on Linux

Release Date:   October 12, 2023
Version:   16.0.4085.2

Summary

This article describes Cumulative Update package 9 (CU9) for Microsoft SQL Server 2022. This update contains 26 fixes that were issued after the release of SQL Server 2022 Cumulative Update 8, and it updates components in the following builds:

  • SQL Server - Product version: 16.0.4085.2, file version: 2022.160.4085.2
  • Analysis Services - Product version: 16.0.43.222, file version: 2022.160.43.222

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
2641756 The RemoveDiscontinuedFeatures command that has the EnsureProperEncryption option is extended to support multidimensional model databases. For more information, see Multidimensional mode. Analysis Services Analysis Services Windows
2654343 Fixes an issue in which you search for a specific node and then fail to expand the node on the hierarchy page. Master Data Services Master Data Services Windows
2659495 Updates the version of the Microsoft ODBC driver to 17.10.5.1. For more information, see Release Notes for Microsoft ODBC Driver for SQL Server on Windows. SQL Connectivity SQL Connectivity Windows
2659497 Updates the version of the Microsoft OLE DB driver to 18.6.7. For more information, see Release notes for the Microsoft OLE DB Driver for SQL Server. SQL Connectivity SQL Connectivity Windows
2450865 Fixes an issue in which the following assertion failure occurs while you try to restore a database to a disk with insufficient storage, which causes the SQL Server instance to stop responding:

<DateTime>     Error: 17066, Severity: 16, State: 1.
<DateTime>     SQL Server Assertion: File: <buffer.cpp>, line=12797 Failed Assertion = 'bufDiscarded'. This error may be timing-related. If the error persists after rerunning the statement, use DBCC CHECKDB to check the database for structural integrity, or restart the server to ensure in-memory data structures are not corrupted.		 SQL Server Engine Backup Restore All
2630696 Fixes an issue in which restoring a transaction log backup to the specific point in time fails with the following error:

Msg 9003, Level 20, State 9, Line <LineNumber>
The log scan number (xxx:xxx:xxx) passed to log scan in database 'DatabaseName' is not valid.		 SQL Server Engine Backup Restore All
2518729 Fixes an issue in which an INSERT (or any Data Manipulation Language (DML)) statement is blocked if you run the statement before a clustered columnstore index (CCI) online rebuild or drop and then run the statement during the online rebuild or drop if the statement is still in the procedure cache. SQL Server Engine Column Stores All
2557526 Fixes an access violation issue that occurs when removing the database snapshot files on the readable secondary replica of an Always On availability group that has the buffer pool extension enabled. SQL Server Engine DB Management All
2670876 Updates the Pacemaker agent code to support Red Hat Enterprise Linux (RHEL) 9 and Ubuntu 22. SQL Server Engine High Availability and Disaster Recovery Linux
2557571 This improvement adds Extended Events functionality to enhance the periodic primary replica to secondary replica notification investigation in availability groups for an in-memory database. New events are generated that provide the oldest active transaction and end of log values.

This new tracing will help diagnose errors such as the following:

<DateTime>    Error: 41316, Severity: 23, State: 7.
<DateTime>    Restore operation failed for database '<DatabaseName>' with internal error code '0x84000004'.		 SQL Server Engine In-Memory OLTP Windows
2644031 Improves Data Definition Language (DDL) performance to create a large number of tables and partitions when the number of databases on a SQL Server instance exceeds 100. SQL Server Engine Methods to access stored data All
2627571 Enables the JSON_ARRAY and JSON_OBJECT functions by default in SQL Server 2022. SQL Server Engine Programmability All
2681462 Fixes the incorrect results that you encounter when you use JSON_ARRAY or JSON_OBJECT as a default column during the table creation. SQL Server Engine Programmability All
2636302 Fixes an access violation that may be encountered when querying the sys.dm_os_memory_objects dynamic management view (DMV). SQL Server Engine Query Execution All
2499342 Fixes an issue in which the plan cache entry is evicted when the Cardinality Estimation (CE) feedback tries to get the associated profile, which causes a memory corruption. SQL Server Engine Query Optimizer All
2499352 Updates the SQDSFeedbackEEFunctors constructor to prevent race conditions, which can cause double deletion during the construction. SQL Server Engine Query Optimizer All
2636294 Fixes an issue in which the cardinality estimation (CE) uniformly increases after each LEFT JOIN or RIGHT JOIN combines, which causes overestimation. This fix adds a limitation to the CE when the join predicates are the primary keys of the tables that are involved.

Note: Trace flag 9440 will turn off the functionality provided by this fix for databases with a compatibility level of 160 and earlier.		 SQL Server Engine Query Optimizer All
2690500 Fixes an issue in Cardinality Estimation (CE) feedback involving uninitialized variables in PStmtGetSafe. SQL Server Engine Query Optimizer All
2602744 Fixes an issue that you encounter in the following scenario:

- Configure the "Replication: agent custom shutdown" alert to respond to error 20578.

- Run sp_publication_validation with @shutdown_agent as 1 to initiate an article validation.

In this scenario, you notice that the "Replication: agent custom shutdown" alert doesn't respond, which occurs as error 20578 isn't logged in the application log.		 SQL Server Engine Replication All
2614104 Fixes an issue in which the Snapshot Agent incorrectly generates the script of the XXX_msrepl_ccs stored procedure if @sync_method is concurrent, and replication stored procedures are specified under a custom schema. SQL Server Engine Replication All
2675548 Fixes an error that you encounter when reading some .XEL files by using sys.fn_MSxe_read_event_stream. SQL Server Engine Resource Governor All
2659494 An attacker can send a malformed TDS (Tabular Data Stream) packet that causes a login failure, unavailability, or other undefined behavior. SQL Server Engine Security Infrastructure All
2674316 Fixes error 207 (Invalid column name '<ColumnName>') that you encounter when you run a user-defined function (UDF), which references a dropped column that uses data classification. SQL Server Engine Security Infrastructure All
2668476
2683132 		Fixes an assertion failure (Location: setypes.cpp:1274; Expression: !IsInRowDiff()) that you might encounter at FAILED_ASSERTION_42ac_sqlmin.dll!VersionRecPtr::IsNull when you have multiple nested inserts.

Note: You can enable trace flag (TF) 7117 to mitigate the issue. Turn off TF 7117 after the mitigation is done, which means after the version cleaner cleans the problematic page.		 SQL Server Engine SQL Server Engine All
2668765 Reduces the overall size of Ubuntu-based SQL Server container images. SQL Setup Linux Linux

How to obtain or download this or the latest cumulative update package

File information

Notes for this update

How to uninstall this update

References

Feedback

Was this page helpful?

Additional resources

  • Last updated on