Note
Access to this page requires authorization. You can try signing in or .
Access to this page requires authorization. You can try .
KB5000642 - Cumulative Update 9 for SQL Server 2019
Release Date: February 11, 2021
Version: 15.0.4102.2
Summary
This article describes Cumulative Update package 9 (CU9) for Microsoft SQL Server 2019. This update contains 90 fixes that were issued after the release of SQL Server 2019 Cumulative Update 8, and it updates components in the following builds:
- SQL Server - Product version: 15.0.4102.2, file version: 2019.150.4102.2
- Analysis Services - Product version: 15.0.34.29, file version: 2018.150.34.29
Known issues in this update
After changes that are related to Scalar UDF Inlining were made in CU9, a defect was introduced in which an access violation can occur when an object invokes a scalar inlineable UDF (UDF1) together with a scalar inlineable UDF (UDF2) that's used as an input parameter:
OBJECT DEFINITION(view/UDF/TVF/procedure)
…
SELECT UDF1(UDF2());
…
To mitigate this problem, disable Scalar UDF inlining by using either of the following options:
Change the definition of UDF2 by adding
WITH INLINE = OFFto the definition.Disable inlining on the database by using
ALTER DATABASE SCOPED CONFIGURATION SET TSQL_SCALAR_UDF_INLINING = OFF.
For examples of disabling Scalar UDF inlining, see Disable Scalar UDF Inlining without changing the compatibility level.
This issue is fixed in SQL Server 2019 CU11.
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 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 "#NNNNNNNN" 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 |
|---|---|---|---|---|
| 13770140 | FIX: Indefinite hang occurs during cube processing after applying SSAS 2016 SP2 CU7 (KB4589170) | Analysis Services | Analysis Services | Windows |
| 13770147 | FIX: Unexpected error occurs when a query is run on an instance of SSAS (KB4589171) | Analysis Services | Analysis Services | Windows |
| 13745344 | Fixes deadlocks that occur in [catalog].[set_execution_property_override_value]. |
Integration Services | Engine | Windows |
| 13704071 | FIX: SSIS ScaleOut Execution intermittently reports "Unexpected Termination" in the execution status but all tasks get completed successfully. | Integration Services | ScaleOut | Windows |
| 13607161 | Improves SSISDB performance by adding indexes to event_message_context and execution_property_override_values tables in SQL Server 2019. |
Integration Services | Server | Windows |
| 13745356 | FIX: Intermittent connection error occurs when an expression is used for both connection string and password of a connection manager (KB4569837) | Integration Services | Tasks_Components | Windows |
| 13888649 | FIX: When the master SSIS package calls multiple child packages and their connection managers are parameterized, the SSIS package execution fails with UNEXPECTED TERMINATION or INVALID CONNECTION STRING ATTRIBUTE error while updating connection strings. | Integration Services | Tasks_Components | Windows |
| 13745362 | FIX: ISDBUpgradeWizard.exe throws error when you try to upgrade SSISDB after restoring from earlier versions in SQL Server (KB4547890) | Integration Services | Tools | Windows |
| 13723579 | Fixes Recursive hierarchy in explore page that's not working properly in MDS version 2019. | Master Data Services | Master Data Services | Windows |
| 13770149 | FIX: SQL Server crashes when Afd!DbCreateSocketOperation process fails (KB4588977) | SQL Server Connectivity | Protocols | Linux |
| 13757446 | Fixes the issue of sending done token before sending the session kill state when session got killed. This fixes the issue of incorrect session state that occurs when a session is killed on SQL Server external data source instance. | SQL Server Connectivity | SQL Connectivity | Windows |
| 13746925 | When running a RESTORE HEADERONLY of a SQL Server 2016 backup you may notice error 3285 even if the correct block size has been specified. If the error persists after applying this fix, specify the proper block size or contact Microsoft Support for assistance. |
SQL Server Engine | Backup Restore | Windows |
| 13746927 | FIX: When you try to restore from a compressed or encrypted backup over an existing TDE enabled database, you may notice that the restore operation may take longer time than expected. | SQL Server Engine | Backup Restore | Windows |
| 13768244 | Fixes an error where you may receive the following error when you restore a TDE enabled database from a backup with compression option and "WITH FILE =" option is greater than 1: Msg 3241, Level 16, State 40, Line <LineNumber> The media family on device '<FilePath>\<FileName>' is incorrectly formed. SQL Server cannot process this media family. |
SQL Server Engine | Backup Restore | Windows |
| 13819319 | Fixes an issue where a database restore fails with an error 3257 (insufficient free space error) when the database is larger than 2 TB. The issue happens when the TotalAllocationUnits on the target volume is more than 4,294,967,295 units, for example when the target volume is larger than 16 TB and uses an allocation unit size = 512 bytes and a single sector per cluster. |
SQL Server Engine | Backup Restore | Windows |
| 13807755 | Improvement: New trace Flags for better maintenance of deleted rows in Clustered Columnstore Index (KB5000895) | SQL Server Engine | Column Stores | Windows |
| 13770156 | FIX: Higher than expected number of single row Columnstore rowgroups may be generated for Columnstore bulk insert when both large page allocator and scalable Columnstore bulk insert features are turned on (KB4588980) | SQL Server Engine | Column Stores | All |
| 13746938 | FIX: VERIFY_CLONEDB prints message 'Clone database verification has failed' for the database if the database name starts with a number. |
SQL Server Engine | DB Management | Windows |
| 13887793 | Updates the Zulu JRE version to mssql-zulu-jre-11.43.56-1 and mssql-zulu-jre-8-8.50.0.52-1. |
SQL Server Engine | Extensibility | Linux |
| 13887794 | Updates the Zulu JRE version to mssql-zulu-jre-11.43.56. |
SQL Server Engine | Extensibility | Windows |
| 13607162 | Improvement: A manual method to set maximum group commit time in SQL Server 2017 and 2019 (KB4565944) | SQL Server Engine | High Availability and Disaster Recovery | Windows |
| 13717020 | FIX: Access Violation exception occurs in Availability Groups in SQL Server 2017 under certain conditions (KB4577932) | SQL Server Engine | High Availability and Disaster Recovery | Windows |
| 13745332 | FIX: Automatic seeding failure occurs for a secondary replica in SQL Server 2016 and 2019 (KB4568447) | SQL Server Engine | High Availability and Disaster Recovery | Windows |
| 13770154 | FIX: Fail to create AG on top of FCI in SQL Server 2019 (KB4588979) | SQL Server Engine | High Availability and Disaster Recovery | Linux |
| 13770157 | FIX: "LogConsumer::StartScan failed to get the control lock" error occurs and the log writer activity stops completely in SQL Server 2019 (KB4588981) | SQL Server Engine | High Availability and Disaster Recovery | Windows |
| 13651126 | Fixes an issue where selecting from sys.databases when there are a large number of databases in SQL Server 2019 take longer time to execute when compared to earlier versions of SQL Server. |
SQL Server Engine | High Availability and Disaster Recovery | Windows |
| 13746921 | Unable to connect to primary database replica after failing over the Availability Group in SQL Server. | SQL Server Engine | High Availability and Disaster Recovery | Windows |
| 13760269 | Forwarder is unable to reconnect to global primary following Global primary planned failover if the LISTENER_URL is modified. |
SQL Server Engine | High Availability and Disaster Recovery | Windows |
| 13878941 | Fixes an issue where SQL process isn't killed properly resulting in subsequent start of SQL Server fails when the AG-Helper sends the KILL 9 command to terminate the SQL Server process. |
SQL Server Engine | High Availability and Disaster Recovery | Linux |
| 13916584 | FIX: Assertion or RaiseInconsistencyError occurs when you use VersionStoreTableAccess::PopulateRowData on SQL 2019 Always On Availability Group Readable replica, but actually there's no corruption. |
SQL Server Engine | High Availability and Disaster Recovery | Windows |
| 13717040 | FIX: Incorrect results occur when you run INSERT INTO SELECT statement on memory-optimized table variables in SQL Server (KB4580397) | SQL Server Engine | In-Memory OLTP | Windows |
| 13828883 | Fixes an error that occurs when you execute a query by using sp_send_dbmail inside a SQL Agent Job to send mails with attachments. |
SQL Server Engine | Linux | Linux |
| 13865722 | Fixes infinite loop in VDI due to improper initialization of errno variable. |
SQL Server Engine | Linux | Linux |
| 13651862 | FIX: Database mail doesn't send e-mail messages when IP address is specified in mssql-conf (KB5000663) | SQL Server Engine | Management Services | Linux |
| 13813500 | FIX: SQL Agent job fails with a sharing violation when writing to step output file in SQL 2019. | SQL Server Engine | Management Services | Windows |
| 13770057 | Fixes an issue where an online index operation using WHEN_SUPPORTED will fail on LOBs if in a transaction that has already done an update. |
SQL Server Engine | Metadata | All |
| 13773237 | Fixes an issue where stack dumps may be generated frequently due to failed assertions and access violations when you enable Memory-Optimized tempdb Metadata (HkTempdb). | SQL Server Engine | Metadata | Windows |
| 13949618 | FIX: Assertion failure error occurs on sqlmin.dll!XdesRMBase::StartStmtSnapshot in SQL Server 2019 (KB4594016) | SQL Server Engine | Methods to access stored data | Windows |
| 13756064 | Improvement: Adds a new external generic query builder in SQL Server 2019 (KB5000669) | SQL Server Engine | PolyBase | Linux |
| 13770152 | FIX: Statistics are ignored when a query is run on PolyBase external table in SQL Server 2019 (KB4588978) | SQL Server Engine | PolyBase | Windows |
| 13770159 | FIX: CREATE STATISTICS WITH SAMPLE PERCENT command fails with error when Oracle data source has partitioned table (KB4588983) | SQL Server Engine | PolyBase | All |
| 13909240 | FIX: Error occurs when you map an Oracle NUMBER type to a T-SQL DECIMAL/NUMERIC type (KB5000670) | SQL Server Engine | PolyBase | All |
| 13909360 | FIX: Error occurs when casting non-Unicode string column using a Unicode-only UTF8 collation in SQL Server 2019 (KB5000671) | SQL Server Engine | PolyBase | All |
| 13909404 | FIX: Fixes reading of NULL Time fields for non-sqlserver backends (KB5000672) | SQL Server Engine | PolyBase | All |
| 13737330 | Enables async path for PolyBase remote query and add cleanups for timeout/abort in SQL Server 2019. | SQL Server Engine | PolyBase | All |
| 13737331 | Fixes the query hang issue that occurs in SQL Server 2019 when querying an external table through PDW. | SQL Server Engine | PolyBase | All |
| 13738992 | Adds a randomization logic when mapping writers to pods in SQL Server 2019. | SQL Server Engine | PolyBase | All |
| 13752408 | This fix makes sure that when the "EXECUTE ('sql query') AT DATA_SOURCE [mydatasource]" query is executed, the connection options of [mydatasource] will be used when connecting to that data source. |
SQL Server Engine | PolyBase | All |
| 13752425 | Fixes an issue with PolyBase SQL dump hash computation that uses MD5 which isn't FIPS compliant. | SQL Server Engine | PolyBase | All |
| 13752426 | Fixes an issue where PolyBase fails when it's deployed on a platform (Windows or Linux) and the control node hostname resolves to an IPv6. | SQL Server Engine | PolyBase | All |
| 13878949 | Fixes an issue where the PolyBase query against the backend may result in a dump of the PolyBase engine process when you try to resolve partitioning information and the connection to an external database backend is unreliable or interrupted. | SQL Server Engine | PolyBase | All |
| 13880787 | Fixes an issue where a message occurs in the error log and the Application event log: Error: 46906, Severity: 16, State: 1. Unable to retrieve registry value 'NodeRole' from Windows registry key 'Software\Microsoft\Microsoft SQL Server\MSSQL\Polybase\Configuration': (null) |
SQL Server Engine | PolyBase | All |
| 13880798 | When you use EXECUTE with AT DATA_SOURCE in SQL Server 2019, the query gets truncated at 8000 byte length and may cause errors or wrong results. |
SQL Server Engine | PolyBase | All |
| 13770158 | FIX: sys.dm_exec_requests returns transaction_id as "0" in certain scenarios in SQL Server 2019 (KB4588982) | SQL Server Engine | Programmability | Windows |
| 13904898 | FIX: Scalar UDF Inlining issues in SQL Server 2019 (KB4538581) | SQL Server Engine | Programmability | All |
| 13668231 | Fixes an Access violation error that occurs whenever 'sp_refreshsqlmodule' function is executed quickly several times in a row causing a stack dump to be generated. |
SQL Server Engine | Programmability | Windows |
| 13771532 | Fixes an access violation dump that occurs after you run a query by using OUTER APPLY on sys.dm_db_index_operational_stats. |
SQL Server Engine | Programmability | Windows |
| 13724507 | FIX: Wrong results due to undetected concatenation parameters from scalar expression (KB5000649) | SQL Server Engine | Query Execution | All |
| 13777701 | FIX: Error 3625 occurs during query execution when batch mode on rowstore is enabled in SQL Server 2019 (KB4589345) | SQL Server Engine | Query Execution | Windows |
| 13891302 | FIX: MERGE statement fails with Access Violation at BTreeRow::DisableAccessReleaseOnWait in SQL Server (KB4589350) | SQL Server Engine | Query Execution | Windows |
| 13718092 | Fixes Graph LAST_NODE = LAST_NODE predicate issue by including a second pass for LAST_NODE expressions and to include an appropriate predicate in the query tree. |
SQL Server Engine | Query Execution | All |
| 13718123 | Fixes an access violation that occurs when Showplan XML Xevent is enabled, and an in-memory procedure containing a 'SELECT without FROM clause' is executed. |
SQL Server Engine | Query Execution | All |
| 13717021 | FIX: Incorrect results can occur when you run linked server query with aggregates or joins on table with filtered index on a remote server in SQL Server (KB4575689) | SQL Server Engine | Query Optimizer | Windows |
| 13717028 | FIX: COMPILE blocking occurs when executing many concurrent stored procedures in SQL Server 2017 and 2019 (KB4577976) | SQL Server Engine | Query Optimizer | Windows |
| 13717029 | FIX: Cascade delete on key values outside of leading table histogram bounds causes index scan in SQL Server 2017 and 2019 (KB4577933) | SQL Server Engine | Query Optimizer | Windows |
| 13647678 | FIX: Query returns different result set when run on In-memory optimized tables and disk-based tables in SQL Server 2019. | SQL Server Engine | Query Optimizer | Windows |
| 13722862 | Fixes the Assertion failure that occurs when group properties for CLeafOp children are derived. |
SQL Server Engine | Query Optimizer | All |
| 13745342 | Fixes an access violation exception that occurs while querying sys.dm_db_stats_properties for a table with a spatial index in SQL Server 2019. |
SQL Server Engine | Query Optimizer | Windows |
| 13746944 | Fixes Non-yielding Scheduler error that may occur when Query Store tries to grow its memory structure during heavy workload. | SQL Server Engine | Query Store | Windows |
| 13749461 | Fixes Query Store scalability improvement for ad-hoc workloads. Query Store now imposes internal limits to the amount of memory it can use, and automatically changes the operation mode to read-only until enough memory has been returned to the Database Engine, preventing performance issues. | SQL Server Engine | Query Store | All |
| 13745336 | FIX: Log reader agent generates access violation exception for P2P or transactional replication with partitioning tables in SQL Server 2016 and 2019 (KB4575939) | SQL Server Engine | Replication | Windows |
| 13745358 | FIX: Newly added articles' snapshot doesn't get applied to subscriber in SQL Server 2016 and 2019 (KB4575940) | SQL Server Engine | Replication | Windows |
| 13717026 | Fixes Monitor and Sync replication agent job error that occurs when a job runs on the new secondary replica after failover of the Availability Group that hosts the distribution database for transactional replication. Unable to post notification to SQLServerAgent (reason: The maximum number of pending SQLServerAgent notifications has been exceeded. The notification will be ignored.) [SQLSTATE 42000] (Error 22022). The step failed |
SQL Server Engine | Replication | Windows |
| 13759515 | Fixes an error that occurs when a change tracking function is called in MSTVF. Msg 443, Level 16, State 1, Procedure <ProcedureName>, Line <LineNumber> [Batch Start Line <LineNumber>] Invalid use of a side-effecting operator 'change_tracking_current_version' within a function. |
SQL Server Engine | Replication | Windows |
| 13769810 | When the full-text service fdhost is attempting to index a column with the content of type .eml using the filter c:\windows\system32\mimefilt.dll version 2008.0.19041.1, the fdhost.exe process stops with 0xc0000409 STATUS_STACK_BUFFER_OVERRUN. |
SQL Server Engine | Search | Windows |
| 13909232 | FIX: Memory leak may occur when SQL Server auditing feature is used on an instance of SQL Server 2019 (KB5000655) | SQL Server Engine | Security Infrastructure | All |
| 13909239 | FIX: Incorrect type of data mask is applied when DDM is used with queries that have UDFs in SQL Server 2019 (KB5000656) | SQL Server Engine | Security Infrastructure | All |
| 13771348 | Fixes an issue where deployment is stuck in 'WaitingForControlPlaneFilesDownload' state with ObjectDisposedException in controller. |
SQL Server Engine | SQL Big Data Cluster | Linux |
| 13770160 | FIX: Contention on XVB_List spinlock in highly concurrent workloads when using RCSI (KB4588984) | SQL Server Engine | SQL OS | Windows |
| 13817504 | FIX: Severe spinlock contention occurs in SQL Server 2019 (KB4538688) | SQL Server Engine | SQL OS | Windows |
| 13599202 | Fixes the non-yielding scheduler condition that occurs when AG listener is created with invalid IP address in SQL Server 2019 on Linux. | SQL Server Engine | SQL OS | Linux |
| 13744390 | New logging and XEvents to help troubleshoot long-running Buffer Pool scans. | SQL Server Engine | SQL OS | All |
| 13882987 | Adds improvement to increase the default size and file retention on AlwaysOn_health. Note: The current definition for the AlwaysOn_health XEvent session has a maximum file size of 5 megabytes (MB) and maximum number of files of 4, for a maximum of 20 MB of AlwaysOn_health XEvent data. On a busy system, you can roll over this limitation quickly and miss important information in the event of an issue that affects the system. In order to keep more troubleshooting data available on the system, the default file size is changed from 5 MB to 100 MB and the default number of files is changed from 4 to 10, for a maximum of 1 GB of AlwaysOn_health XEvent data, in this update. If the definition of the AlwaysOn_health session has already been modified from the default values, this improvement won't overwrite the existing settings. |
SQL Server Engine | SQL OS | All |
| 13746919 | Fixes an issue where the session gets killed when you run DBCC CHECKTABLE with PHYSICAL_ONLY due to disk full. The session remains in KILLED\ROLLBACK state and threads are waiting on CHECK_TABLES_THREAD_BARRIER wait type with increasing wait time. |
SQL Server Engine | Storage Management | Windows |
| 13717030 | DBCC SHRINKFLE or SHRINKDATABASE can cause an assertion exception error when executed against database or files containing system-versioned temporal tables. |
SQL Server Engine | Temporal | Windows |
| 13784190 | FIX: User session is in rollback state indefinitely after it is killed in SQL Server 2016 (KB4585971) | SQL Server Engine | Transaction Services | Windows |
| 13746942 | Fixes SQL Server Assertion that occurs when the availability group is failed over manually to another replica. The failover succeeds however, the databases from the earlier primary (now the secondary) where the AG was failed from, doesn't come online and generates the assertion dumps. File: <FilePath\FileName>, line=<LineNumber> Failed Assertion = 'inCorrectOrder' |
SQL Server Engine | Transaction Services | Windows |
| 13891577 | Adds a new option to free the LogPool cache only: DBCC FREESYSTEMCACHE('LogPool'). |
SQL Server Engine | Transaction Services | Windows |
| 13955875 | Fixes the assertion failure that occurs at FAILED_ASSERTION_42ac_sqlmin.dll!LogLockCollectionVerify::Callback in SQL Server 2019. |
SQL Server Engine | Transaction Services | Windows |
| 13866862 | Fixes an issue where an access violation exception may occur when you execute queries in read uncommitted mode with high concurrent read or write pattern over XML data types. | SQL Server Engine | XML | Windows |
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?