Cumulative Update 6 for SQL Server 2019

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

This article describes Cumulative Update package 6 (CU6) 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.4053.23 2019.150.4053.23
Analysis Services 15.0.34.21 2018.150.34.21

 

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 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.

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 in SQL Server 2019 CU1, you can perform in-place upgrades for Big Data Clusters from the production supported releases (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.

List of improvements and fixes included in this Cumulative Update


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 KB article number Description Fix area Platform
13534591   This improvement changes the behavior of Availability Group informational messages to not be printed to the log by default:
UpdateHadronTruncationLsn(X) (force=Y): Primary: Z:Z:Z Secondary: A:A:A Partial Quorum : B:B:B Aggregation: C:C:C Persistent: D:D:D
High Availability All
13554274   This update contains an improvement for object level lock optimization on secondary replicas of Always On Availability Groups. This improvement addresses the schema lock contention on secondary replica redo, especially when the number of logical processors is large. High Availability All
13582824   Fixes high CPU consumption on Availability Group secondary database when using multiple redo threads and uninitialized LSN, leading to extra reads under some rare scenarios High Availability All
13592713   Fixes access violation exception that occurs when plan cache involves sys.dm_hadr_ag_threads and sys.dm_hadr_db_threads DMVs High Availability All
13580008   Fixes race condition where a PolyBase query might hang when the corresponding execution plan involves a query against a external data source that fails right after submission SQL BDC All
13551991   Fixes the following numeric overflow error when you attempt to create a PolyBase external table targeting a Teradata table with more than 2,147,483,647 rows, the Teradata system’s default session mode is ‘Teradata’, and you didn’t change the session mode of the PolyBase connection by including ‘SessionMode=ANSI’ in the CONNECTION_OPTIONS of the external data source that is used in the CREATE EXTERNAL TABLE statement.
Error: 105082;Generic ODBC error: [Microsoft][ODBC Teradata Driver][Teradata Database](-2616)Numeric overflow occurred during computation.
SQL Engine All
13554533   When you execute a select query against a PolyBase external data source and the query contains columns whose names only differ by case (such as ID and Id), you notice that PDW engine may generate an incorrect landing table schema which results in following error: Msg 7320: Cannot execute the query "Remote Query" against OLE DB provider "MSOLEDBSQL" for linked server "(null)". Column names in each table must be unique. Column name 'ID' in table 'TableName' is specified more than once. SQL Engine All
13480950 4568448 FIX: Support for REJECT_ROW_LOCATION parameter in CREATE EXTERNAL TABLE in SQL Server 2019 box product SQL Engine All
13584506 4568653 FIX: INSERT EXEC doesn't work when you insert row containing explicit identity value into table with IDENTITY column and IDENTITY_INSERT is OFF by default in SQL Server 2019 SQL Engine All
13590483 4538581 FIX: Scalar UDF Inlining issues in SQL Server 2019 SQL Engine All
13575426   Adds support to communicate with a private network from sp_execute_external_script query in SQL Server 2019 "OSError: [WinError 10013] An attempt was made to access a socket in a way forbidden by its access permissions" SQL Engine All
13581481   Fixes a case where an error for a failed PolyBase query may not always get propagated to the user, instead returning the partial result set SQL Engine All
13584821   Fixes error "Field not found in the applicable tables" when you query external table with DATE/TIMESTAMP literals in WHERE clause and the external data source ODBC driver does support not ANSI format SQL Engine All
13592980   This update fixes a rare race condition in PolyBase query cancellation SQL Engine All
13491005 4551220 FIX: Assertion error occurs when you run resumable index build statement in SQL Server SQL performance All
13594414   Fixes an access violation error that might occur when auditing commands that require password masking SQL security All
13603758   Fixes an issue in agent join during deployment due to pod IP address mismatch in SQL Server 2019 SQL BDC Linux
13518086   Fixes an issue with an orphaned spinlock due to access violation and results in the  repeatedly printed in messages log: "getspinlock pre-Sleep() after AV" SQL Engine Linux
13571700 4570355 FIX: Error occurs when you insert data from one replicated BDC data pool table to another in SQL Server 2019 SQL Engine Linux
13575481   Adds a new dsqlplan XEvent in PDW to collect dsql plan SQL Engine Linux
13576520   This update allows PolyBase external tables for Teradata database to map ByteInt data type to TinyInt data type SQL Engine Linux
13586194   Removes unrelated warning message that is generated during PolyBase engine start or when PolyBase XEvent config environment variable is not set "is not a rooted path. Expect a rooted path for XE config file from envrionment variable." SQL Engine Linux
13520896   Fixes issue with access violation exception when you execute query with UDF and multiple grouping. After applying this update, SQL Server blocks UDF inlining if group by includes multiple groupings. SQL performance Linux
13592120 4570679 FIX: Remote Hadoop bridge fails when using Hadoop connectivity levels other than seven in SQL Server 2019 on Linux SQL Engine Linux
13601596 4577562 FIX: Istio proxy fails as automountServiceAccountToken is set to FALSE in CU5 for SQL Server 2019 SQL BDC Linux
13521097   Excel MDX queries running against an SSAS Tabular instance may return incorrect result when you convert PivotTable Filters to formulas. Analysis Services Windows
13491013   DMV query $system.DISCOVER_STORAGE_TABLES can execute slowly against in-memory model which contains many tables and large table row counts in SQL Server 2019 Analysis services Windows
13528240   Corrects a regression to allow Recursive Hierarchies to display child items correctly. Data Quality Services (DQS) Windows
13407621 4538849 FIX: Transaction commit delay time is higher under low usage workloads in SQL Server 2017 and 2019 High Availability Windows
13491006 4551221 FIX: Error occurs when you try to create a differential backup on secondary replica in SQL Server High Availability Windows
13563157 4570571 FIX: Query slowness occurs when CPU-intensive SQL Server system tasks run in SQL Server 2019 High Availability Windows
13540086   This update contains an improvement for XML Validation in SSIS XML Tasks. This improvement allows validation of INCLUDED schemas in XML task. Integration Services Windows
13500184 4547890 FIX: ISDBUpgradeWizard.exe throws error when you try to upgrade SSISDB after restoring from earlier versions in SQL Server 2019 Integration Services Windows
13544859   When using FileTables in SQL Server, you may notice dumps being generated periodically that contain an assertion in function FFtFileObject::ProcessPostCreate. In some environments, these dumps may trigger a failover FtFileObject::ProcessPostCreate file = fftfo.cpp line = LineNumber  expression = FALSE SQL Engine Windows
13525673 4563597 FIX: Assertion dump occurs when Implicit Transactions are enabled in SQL Server 2016, 2017, and 2019 SQL Engine Windows
13592393 4570433 FIX: "Culture is not supported" error occurs when you execute PolyBase query in SQL Server 2019  SQL Engine Windows
13516056 4571296 Improvement: Option to forcefully turn QDS off by specifying the additional option in ALTER DB command SQL Engine Windows
13588307 4575275 FIX: Access violation occurs when MSTVF references an In-Memory OLTP large-value data type with interleaved execution enabled in SQL Server 2019 SQL Engine Windows
13563533   Assertion exception occurs when the system function sys.fn_xe_file_target_read_file is executed in SQL Server 2019 Assert reference (Location: FileName:LineNumber, Expression: pvb->FInUse ()) or (Location: FileName:LineNumber, Expression: !"No exceptions should be raised by this code") SQL Engine Windows
13571478   Updates the Zulu JRE version to zulu11.37.18-sa-jre11.0.6.101 SQL Engine Windows
13633260   Fixes errors that occur in SCOM 2019, when you upgrade from SQL Server 2016 or 2017 to SQL Server 2019 CU5 with UDF inlining ON SQL Engine Windows
13562930   Fixes an unexpected result issue for variables when you use multiple variable assignments from select statement that has scalar UDF inlining. After you apply this update, SQL Server blocks UDF inlining in special cases of select-with-assignment queries. SQL performance Window
13594832   The external satellite processes in SQL Server have a restriction to not use more than 8 cores on the system for satellite worker threads, but in case of highly parallel execution all the process are restricted to same set of 8 cores on the machine and don’t use the other cores available on the system. This issue only happens on Windows and slows down highly parallel queries. The fix is to allow the processes to use 8 cores rather than the fixed set of cores on the system SQL Extensibility Windows
13593722   Fixes an access violation that occurs when executing system function sys.fn_get_audit_file to read Audit file in SQL Server 2019 SQL security Windows

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.

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: