Cumulative Update 1 for SQL Server 2019

Applies to: SQL Server 2019 on LinuxSQL Server 2019 on Windows

This article describes Cumulative Update package 1 (CU1) for SQL Server 2019. This update contains fixes that were released after the initial release of SQL Server 2019 and updates the SQL Server and Analysis services components to the following builds:

Component Product version File version
SQL Server 15.0.4003.23 2019.150.4003.23
Analysis Services 15.0.32.52 2018.150.32.52

 

Important notices

This article also provides important information about the following situations:

Cumulative updates (CU)

  • Each new CU contains all the fixes that were included with the previous CU for the installed version of SQL Server.
  • SQL Server CUs are certified to the same levels as Service Packs, and should be installed at the same level of confidence.
  • Microsoft recommends ongoing, proactive installation of CUs as they become available according to these guidelines:
     
    • Historical data shows that a significant number of support cases involve an issue that has already been addressed in a released CU.
    • CUs may contain added value over and above hotfixes. This includes supportability, manageability, and reliability updates.
  • We recommend that you test SQL Server CUs before deploying to production environments.

How to obtain this cumulative update package for SQL Server 2019 on Linux


To update SQL Server 2019 on Linux to the latest CU, you must first have the Cumulative Update repository configured. Then, update your SQL Server packages by using the appropriate platform-specific update command.

For installation instructions and direct links to the CU package downloads, see the SQL Server 2019 Release Notes.

How to obtain this cumulative update package for SQL Server 2019 Big Data Clusters (BDC)


To implement SQL Server 2019 BDC on Linux to the latest CU, see the Big Data Clusters Deployment Guidance.

Starting with SQL Server 2019 CU1, you can perform in place upgrades for Big Data Clusters from the production supported releases (i.e. SQL Server 2019 GDR1). For more information, see How to upgrade SQL Server Big Data Clusters.

For additional information, see the Big Data Clusters release notes.

How to obtain this cumulative update package for SQL Server 2019 on Windows


The following update is available from the Microsoft Download Center:

Download icon
Microsoft Download Center: Download the latest cumulative update package for SQL Server 2019 now. 

  • Note Microsoft Download Center will always present the latest SQL Server 2019 CU release.
  • If the download page does not appear, contact Microsoft Customer Service and Support to obtain the cumulative update package.

Download icon
Microsoft Update Catalog: Download cumulative update packages for SQL Server 2019

  • Note Microsoft Update Catalog contains this SQL Server 2019 CU and previously released SQL Server 2019 CU releases.
  • This CU is also available through Windows Server Update Services (WSUS).
  • We recommend that you always install the latest cumulative update that is available.

Additional hotfixes that are included in this cumulative update package


VSTS bug number KB article number Description Fix area Platform
13198910 4515772 FIX: Transaction log isn't truncated on a single node Availability Group in SQL Server High Availability Windows
13211958 4516999 FIX: File content is sent twice when copied to HDFS using Hadoop File System Task in SQL Server 2017 and 2019 Integration Services Windows
13198916 4517771 FIX: Orphaned CLR sessions cause blocking in SQL Server SQL Engine Windows
13211959 4518364 FIX: Access violation occurs when you run queries that involve PIVOT or UNPIVOT in SQL Server 2016, 2017 and 2019 SQL Engine Windows
13222690 4519366 FIX: Incorrect results occur with index intersection on partitioned table with a clustered columnstore index in SQL Server SQL performance All
13198914 4519668 FIX: Access violation occurs when you enable TF 3924 to clean orphaned DTC transactions in SQL Server 2016, 2017 and 2019 SQL Engine Windows
13166853 4519796 FIX: Stack dump occurs when table type has a user-defined constraint in SQL Server 2016, 2017 and 2019 SQL Engine Windows
13211965 4521659 FIX: SQL Writer Service fails to back up in non-component backup path in SQL Server 2016, 2017 and 2019 SQL Engine Windows
13166854 4521702 FIX: ObjectPropertyEx Cardinality property for columnstore table doesn't include rows in delta store rowset or account rows in deleted bitmap rowset in SQL Server 2019 SQL Engine Windows
13200684 4521739 FIX: Error occurs when CDC capture process tries to insert duplicate key in table "cdc.lsn_time_mapping" in SQL Server 2016, 2017 and 2019 SQL Engine Windows
13211966 4521960 FIX: Access violation occurs when a clone database verification fails in SQL Server 2016, 2017 and 2019 SQL Engine Windows
13211951 4522002 FIX: SQL Server 2017 and 2019 on Linux fails with an Assertion error SQL Engine Linux
13211960 4522405 FIX: Non-yielding scheduler error occurs when you run batch query with sort operation in SQL Server 2017 and 2019 SQL performance All
13218547 4526315 FIX: Database cannot recover and reports error 5243 in SQL Server SQL Engine Windows
13253822 4527538 FIX: "A system assertion check has failed" error when a procedure call is made from CLR with an OUTPUT large object argument SQL performance All
13240867 4528097 FIX: Access violation occurs when you query sys.dm_db_persisted_sku_features DMV in SQL Server 2019 SQL Engine All
13234473 4528139 FIX: "Debug Assertion Failed" error if you create objects that are not hashed by name in SQL Server 2019 SQL Engine All
13238936 4528168 FIX: Using temporary tables across multiple scopes may cause Error 213 or access violation in SQL Server 2019 SQL Engine All
13234379 4528337 FIX: Assertion error when you run internal query in batch mode for populating full-text index on computed LOB in SQL Server 2019 SQL performance All
13234479 4528490 FIX: Access violation occurs when attempting to fetch the IAM page of the table in SQL Server 2019 SQL Engine All
13234476 4528491 FIX: Access violation occurs when you call HkError.Throw() in SQL Server 2019 SQL Engine All
13234477 4528492 FIX: DTC transaction scenario reports unsupported transaction error when HkTempdb transaction is used in SQL Server 2019 SQL Engine All
13234380 4529848 FIX: PolyBase DMVs may return unexpected results after changing PolyBase enabled setting in SQL Server 2019 SQL Engine All
13251715 4529893 FIX: Audit of batch may be skipped when the batch causes a failure that closes the session in SQL Server 2019 SQL security All
13202468 4529942 FIX: Restore fails when you try to restore compressed TDE backups prior to SQL Server 2016 SP2 CU4 on SQL Server 2016 SP2 CU8 SQL Engine Windows
13255810 4529944 FIX: Unsigned files are installed through the Microsoft MPI in SQL Server 2019 SQL Engine Windows
13239089 4530054 FIX: Worker stealing stops working when AG contains one or more encrypted databases in SQL Server 2019 High Availability All
13239100 4530055 FIX: Access violation occurs when worker stealing is enabled and CPU capacity reaches maximal configured value in SQL Server 2019 High Availability All
13254382 4530079 Improvement: Update error messages of Always Encrypted with secure enclaves in SQL Server 2019 SQL security Windows
13254394 4530080 Improvement: Update the misspelled words in server_principal_sid and server_principal_name description in SQL Server 2019 SQL security Windows
13254368 4530084 FIX: Error occurs when you try to install SQL Server 2019 on a low power CPU SQL security Windows
13254376 4530097 FIX: Package execution may be impacted in SQL Server 2019 Integration Services Integration services Windows
13264113 4530251 FIX: Error 8601 occurs when you run a query with partition function in SQL Server SQL performance Windows
13234475 4530280 Improvement: Add new fields to latch_suspend_end Extended Event in SQL Server 2019 SQL Engine  All
13240653 4530281 FIX: Typo in error message for Columnstore indexes on temporary tables in SQL Server 2019 SQL Engine All
13256585 4530283 Improvement: Execute Database upgrade scripts when Database state changes in SQL Server 2019 SQL Engine Windows
13254376 4530286 Improvement: Update SDK to improve security of Always Encrypted by using secure enclaves in SQL Server 2019 SQL security Windows
13254388 4530287 Improvement: Dynamic Management View is added for external authentication in SQL Server 2019 SQL security Windows
13255812 4530302 Improvement: Add unlimited buffer size to support TDS V1 and V2 in SQL Server 2019 SQL security All
13254399 4530303 FIX: Data masking of user-defined functions may result in crashes in SQL Server 2019 SQL security All
13259822 4530427 FIX: sp_describe_parameter_encryption returns different results with different parameter positions in SQL Server 2019 SQL security Windows
13261241 4530468 FIX: PolyBase Hadoop queries may fail when the launchpadd service is restarted or killed in SQL Server 2019 SQL Engine Linux
13262593 4530496 FIX: Data pool database may be deleted if you fail to drop database on master in SQL Server 2019 SQL Engine All
13262614 4530499 FIX: Non-yielding scheduler error when Polybase function call to shared memory takes long time in SQL Server 2019 SQL Engine All
13262374 4530500 FIX: Assertion dump occurs when sp_cdc_disable_db is executed to disable CDC or when distributed transaction is committed after ROLLBACK SAVEPOINT in SQL Server SQL Engine Windows
13224872 4530720 FIX: "The File location cannot be opened" error occurs when you try to open a FileTable directory in SQL Server SQL Engine Windows
13262616 4530769 FIX: FSM may be called when you create a database in SQL Server 2019 Big Data Clusters SQL Engine All
13254405 4530814 Improvement: Add support to create index on encrypted unique identifier using Always Encrypted feature in SQL Server 2019 SQL security Windows
13187033 4530827 FIX: Two issues with remote Hadoop bridge process in SQL Server 2019 SQL Engine Linux
13262555 4530907 Improvement: Corrupt statistics can be detected by using extended_logical_checks in SQL Server 2019 SQL Engine All
13265941 4531025 Improvement: Update PolyBase vbump to 150.1812.0 in SQL Server 2019 SQL Engine Linux
13262868 4531026 FIX: NullPointerException occurs when the name node is not active and the HTTP request has other failures in SQL Server 2019 SQL Engine Linux
13263004 4531029 FIX: Query may fail when you join a storage pool table with a data pool table in SQL Server 2019 SQL Engine All
13262517 4531049 FIX: Access violation occurs when you set database containment to NONE in SQL Server 2019 SQL Engine All
13264231 4531125 Improvement: Update the hktempdb.dll version in SQL Server 2019 SQL Engine All
13262844 4531224 FIX: Spurious lines may be added to the SQL Server error log at each initialization in SQL Server 2019 SQL Engine All
13262848 4531225 FIX: PolyBase query may hang when DMS restarts in SQL Server 2019 SQL Engine All
13265940 4531226 FIX: Error occurs when you select from storage pool table and insert into another external table in SQL Server 2019 SQL Engine Linux
13268501 4531238 FIX: Heap corruption occurs when ADR is disabled and aborted transactions are present in SQL Server 2019 database SQL Engine  All
13268527 4531349 FIX: DMVs fail when Big Data Cluster has multiple compute nodes in SQL Server 2019 SQL Engine Linu
13294167 4533251 FIX: Upgrading FCI passive node from SQL Server 2019 RC1 to RTM fails when you try to access the MSSQL\JOBS which is on the shared drive High Availability All
13221770 4536077 FIX: Dump is generated when you create an AG with more than 122 characters in SQL Server 2019 High Availability  All

Notes for this update


Hybrid environments deployment

When you deploy an update to a hybrid environment (such as AlwaysOn, replication, cluster, and mirroring), we recommend that you refer to the following articles before you deploy the update:
 

Cumulative update package information


Prerequisites

To apply this cumulative update package, you must be running SQL Server 2019.

Restart information

You may have to restart the computer after you apply this cumulative update package.

Registry information

To use one of the hotfixes in this package, you do not have to make any changes to the registry.