Expand all Collapse all
SQL Server 2019

SQL Server 2019 CU 16

 

KB

Description

Fix area

Platform

Learn More

The AlwaysOn_Health extended event doesn't set STARTUP_STATE to ON after installing a SQL Server Cumulative Update.

High Availability

Windows

The function sys.fn_hadr_backup_is_preferred_replica returns different results on primary or secondary replicas of read-scale availability groups (Cluster_Type=None) when running on standalone machines or cluster nodes

High Availability

Windows

The database recovery process is chosen as the deadlock victim on Availability Group (AG) failover under certain circumstances. The following error message is generated:

High Availability

Windows

An "Out of memory" error occurs when you take a log backup frequently and Stolen Server Memory grows at an synchronous secondary in Availability Groups.

High Availability

Windows

Resolves stalled I/O completion port (IOCP) issues when a heavily used service broker is configured on an availability group database.

High Availability

Windows

SQL Server 2019 using XTP UserDB for staging tables has a steady growing trend for "VARHEAP\Storage internal heap" in dm_db_xtp_memory_consumers that leads to OOM/41805 errors over time and requires proactive restart/failover to retain stability.

In-Memory OLTP

Windows

 Improves the dynamic management view (DMV) to help debug the out-of-memory (OOM) issues.

In-Memory OLTP

Windows

Memory-Optimized TempDB Metadata keeps consuming memory under VARHEAP: LOB Page Allocator, which causes out-of-memory (OOM) exceptions like error 701 or FAIL_PAGE_ALLOCATION.

In-Memory OLTP

Windows

Lets more flexible cleanup and merge operations enable by changing In-Memory during restore operations.

In-Memory OLTP

Windows

Improves the response time of the Sqldumpr.exe utility when in-memory objects are used in SQL Server or once existed.

In-Memory OLTP

Windows

An assertion failure occurs in tempdb during the rollback of transactions, and triggers a server shutdown. The following dump file is generated:

    **Dump thread - spid = 0, EC = 0x000004849143B870

    ***Stack Dump being sent to FilePath\FileName

    * *******************************************************************************

    *

    * BEGIN STACK DUMP:

    *   DateTime

    *

    * Location:         FilePath\FileName

    * Expression:         Dependencies.CommitDepCountOut >= 1

    * SPID:                 3984

    * Process ID:         ProcessID

    *

    * Input Buffer 26 bytes -

    *            ‰        16 00 00 00 12 00 00 00 02 00 89 01 00 00 90 0f 00 00

    *                     01 00 00 00 07 00 00 00

    SQL Server Assertion: File: < FilePath\FileName >, line=LineNumber Failed Assertion = 'Dependencies.CommitDepCountOut >= 1'. 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.

    Error: 3624, Severity: 20, State: 1.

    A system assertion check has failed. Check the SQL Server error log for details. Typically, an assertion failure is caused by a software bug or data corruption. To check for database corruption, consider running DBCC CHECKDB. If you agreed to send dumps to Microsoft during setup, a mini dump will be sent to Microsoft. An update might be available from Microsoft in the latest Service Pack or in a Hotfix from Technical Support.

    Error: 3314, Severity: 21, State: 3.

    During undoing of a logged operation in database 'DatabaseName' (page (1:139) if any), an error occurred at log record ID (3692:89591460:155). Typically, the specific failure is logged previously as an error in the operating system error log. Restore the database or file from a backup, or repair the database.

In-Memory OLTP

Windows

A memory dump and assertion failure "Dependencies.CommitDepCountOut >= 1" may occur after a transaction rolls back if in-memory tempdb is enabled.

In-Memory OLTP

Windows

The sqlcmd utility crashes when the batch_terminator parameter "-c" is set to ";" in SQL Server 2019.

Management Tools

Windows

The bulk insert is blocked when the lock of the target table is held by another session, and the session of the bulk insert will remain in SQL Server until its lock is released even if the client application disconnects or exits. This issue causes the session to leak and other requests to be blocked if the leaked sessions are accumulated too many.

SQL Connectivity

Windows

5012964

Improvement: Add an XEvent for tracking manual user plan forcing and unforcing

SQL Engine

Windows

Learn More

5014047

Improvement: Make the change tracking table lock escalation policy be the same as the base table’s

SQL Engine

Windows

Learn More

5014136

Improvement: Ship the EO-compliant ML service CAB packages for SQL Server 2019

SQL Engine

Windows

Learn More

5014137

Improvement: Ship the EO-compliant Microsoft Extensibility SDK for Java for SQL Server 2019

SQL Engine

Windows

Learn More

4538688

FIX: Severe spinlock contention occurs in SQL Server 2019

SQL Engine

Windows

Learn More

Restoring transaction logs from a compressed backup of a TDE-enabled database may cause a "misaligned I/O" message to be logged in the SQL Server error log:

    There have beenmisaligned log IOs which required falling back to synchronous IO.  The current IO is on file.

SQL Engine

Windows

A database freezes its I/O during a VSS backup but never thaws the I/O. This can lead to latch timeouts

SQL Engine

Windows

An offline, piecemeal restore sequence of restoring individual file groups fails when you use the WITH NO_LOG statement. Here are the error messages:

Msg 3241, Level 16, State 18, Line

The media family on device '' is incorrectly formed. SQL Server cannot process this media family.

Msg 3013, Level 16, State 1, Line

RESTORE DATABASE is terminating abnormally.

Note Transparent Data Encryption (TDE)-compressed backups that are made by using previous CU versions of SQL Server 2019 can be restored by using SQL Server 2019 CU 16 and later versions. However, TDE-compressed backups that are made by using SQL Server 2019 CU 16 and later cannot be restored to previous CU versions of SQL Server 2019.

SQL Engine

Windows

An access violation dump occurs when the query runs for a long time in parallel and tries to determine the version of the rowgroup for the particular transactions to read.

SQL Engine

Windows

The logon trigger may fail unexpectedly for the pooled connections even when the criteria are not met during the connection reset, and causes the following error:

Error:17892, Severity: 20, State: 1.

Logon failed for login '' due to trigger execution.

SQL Engine

Windows

Dropping temp tables in some rare cases causes an unresolved deadlock and dump.

SQL Engine

Windows

An access violation occurs if a query on sys.database_scoped_configurations is waiting for a shared lock on the database while another thread holds the exclusive lock to drop the same database.

SQL Engine

Windows

Running DBCC CHECKDB will report "corruption" errors when you use SQL Server graph databases that have edge constraints.

SQL Engine

Windows

An assertion failure, lck_sufficient (lckMode, LCK_M_IX) || lck_sufficient (lckMode, LCK_M_BU), occurs when you use Accelerated Database Recovery (ADR).

SQL Engine

Windows

Restoring from a compressed backup that contains filestream objects randomly fails if the process is run through the Virtual Device Interface (VDI) client. Here are the error messages:

Msg 3241, Level 16, State 18, Line

The media family on device '' is incorrectly formed. SQL Server cannot process this media family.

Unexpected termination: x80770004

SQL Engine

Windows

Calling CMEDScan::EvaluateCmpResult to evaluate filter predicates for the current metadata scan misses the "NE" predicate, which causes an "INVALID_SWITCH_VALUE" exception.

SQL Engine

Windows

Assume that you have tables with data on the peers and then you set a peer-to-peer publication by using a last-writer conflict detection policy. The distribution agent occurs the following conflict if you delete a row that was present before the publication was created:

A conflict of type 'Delete-Update' was detected at peer 1 between peer 100 (incoming), transaction id

and peer (null) (on disk), transaction id (null) for Tablewith Primary Key(s): PK values, Current Version '(null)', Pre-Version '(null)' and Post-Version

SQL Engine

Windows

A "Non-yielding Scheduler" issue and dump occur during a backup operation because of concurrent Page Free Space (PFS) updates.

SQL Engine

Windows

Adds two new Extended Events, iam_page_range_cache_invalidation and iam_page_range_cache_population, to respectively capture Index Allocation Map (IAM) page range cache invalidation and population.

SQL Engine

Windows

4538581

FIX: Scalar UDF Inlining issues in SQL Server 2019

SQL Performance

Windows

Learn More

SQL Server disconnects a session when it gets an attention and INTERLEAVED_EXECUTION_TVF is enabled.

SQL Performance

Windows

The query processor can't produce a query plan if the USE PLAN hint specifies a query plan that has a left outer join and an inner join.

SQL Performance

Windows

Executing a query where the plan contains an adaptive join may fail together with the following error:

Msg 8624, Level 16, State 21, Procedure ProcedureName, Line LineNumber [Batch Start Line 0]

Internal Query Processor Error: The query processor could not produce a query plan. For more information, contact Customer Support Services.

SQL Performance

Windows

SQL Server 2019 CU 15

 

KB

Description

Fix area

Platform

Learn More

5010555

Improvement: Add the usage of signed certificates with multiple DNS names

High Availability

All

Learn More

Adds improvement to capture sp_server_diagnostics XEvent in an AlwaysOn_health XEvent session when STATE is 3 (ERROR) to diagnose HADR Health Events

High Availability

Windows

Adds the Reverting progress to SQL Server error logs in SQL Server 2019 just like the Recovery progress

High Availability

Windows

Fixes an issue where assertion failure on secondary replica when you use Always On availability groups in high-latency networks in SQL Server 2019

High Availability

Windows

Fixes an error that occurs after a failover of a Distributed Availability Group that attempts to connect to the secondary AG listener with application intent set to READ ONLY

High Availability

Windows

Fixes the following insufficient memory error that occurs during In-Memory Online Transactional Processing (OLTP) if application native procedures update tables that have Large Object (LOB) columns and do not specify the LOB column in the UPDATE list:

    Disallowing page allocations for database 'Retail' due to insufficient memory in the resource pool 'IMOLTP'.

    XTP failed page allocation due to memory pressure: FAIL_PAGE_ALLOCATION 8

In-Memory OLTP

All

Fixes an issue where Distributed Replay Client may fail with an unhandled exception.

This fix is for the Distributed Replay Client that shipped with SQL Server 2019. The following is the error you may observe in the output/log file:

DateTime OPERATIONAL  [Common] Unhandled exception is encountered. [Exception Code = 3221225477]

DateTime OPERATIONAL  [Common] Invoking dump.

DateTime OPERATIONAL  [Common] Service terminating.

Management Tools

Windows

Fixes an issue where Cumulative Update (CU) patching fails with the following message when you set default data directory to Azure Blob Storage URL:

The given path's format is not supported.

Exception Type "System.NotSupportedException"

Note To work around the issue, you can change the data default directory to a local directory and rerun the SQL patch.

Setup & Install

Windows

5010246

Improvement: Add 1 (true) and 0 (false) as valid values to mssql-conf Boolean settings

SQL Engine

Linux

Learn More

5008647

Improvement: Add mssql-conf and adutil utilities to SQL Server 2019

SQL Engine

Linux

Learn More

5008648

Improvement: Add a setting for the machine key location on Linux

SQL Engine

Linux

Learn More

5010234

FIX: Buffer overruns when data buffer spans multiple SNI packets

SQL Engine

Windows

Learn More

5010653

FIX: Database corruption after creating an external library in SQL Server 2019

SQL Engine

All

Learn More

Adds improvement in capturing memory dumps on unexpected crashes in SQL Server 2019 on Linux

SQL Engine

Linux

Fixes an issue where different conversion results are displayed in publisher and subscriber database tables when using the ASCII function to convert a column. For more information, see ASCII function returns different results in Publisher and Subscriber database tables.

SQL Engine

Windows

Learn More

Fixes an issue where the default trace on Linux rolls over before the limit size of 20 MB

SQL Engine

Linux

Fixes an issue where a filtered index becomes corrupt after you drop a computed column on the same table, and the filtered index corruptions are reported as 8951 and 8955 errors when you run DBCC CHECKTABLE WITH EXTENDED_LOGICAL_CHECKS

SQL Engine

Windows

Fixes an issue where java.nio.BufferOverflowException error occurs when using PolyBase external tables to query data from Hadoop.

Note This error occurs when querying from a file that has columns of type varchar or nvarchar with a width greater than 256 characters.

SQL Engine

All

Fixes the memory release issue in execution of the STDistance spatial method while using spatial index. Before the fix, memory usage of MEMORYCLERK_SOSNODE gradually grew until all the memory available is taken

SQL Engine

Windows

Fixes an issue where the dm_db_page_info function may record spurious corrupted pages entries in the suspect_pages table when calling the function against the transaction log file

SQL Engine

Windows

Fixes an issue where the output of sp_pkeys KEY_SEQ column doesn't conform to the ordering of columns defined in the Primary Key

SQL Engine

Windows

Fixes a committed memory accounting issue, which under some circumstances, FAIL_PAGE_ALLOCATION error could occur a few days after starting SQL Server services on Linux

SQL Engine

Linux

Fixes an access violation that occurs when you use FileTable in SQL Server 2019

SQL Engine

Windows

Fixes the access violation sqldk!StringVPrintfWorkerW that occurs during the compilation of the query for Dynamic Management Views (DMVs) sys.dm_os_ring_buffers

SQL Engine

Windows

Fixes a system-wide low memory issue that occurs when SQL Server commits memory above the maximum server memory

SQL Engine

Windows

Fixes the following error that occurs when you back up a database by using virtual device interface (VDI) on ubuntu docker container installed SQL Server 2019:

Host_515697bb-6009-4018-b373-50c871ed736c_SQLVDIMemoryName_0: ClientBufferAreaManager::SyncWithGlobalTable: Open(hBufferMemory): error 2Host_515697bb-6009-4018-b373-50c871ed736c_SQLVDIMemoryName_0: TriggerAbort: invoked: error 0Host_515697bb-6009-4018-b373-50c871ed736c_SQLVDIMemoryName_0: TriggerAbort: ChannelSem: error 2Features returned by SQL Server: 0x10000

Opening the device.

VDS::OpenDevice fails: x80770004

Msg 18210, Level 16, State 1, Server , Line

BackupVirtualDeviceSet::AllocateBuffer:  failure on backup device '515697bb-6009-4018-b373-50c871ed736c'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).

Msg 3013, Level 16, State 1, Server , Line

BACKUP DATABASE is terminating abnormally.

SQL Engine

Linux

5009753

FIX: Physical reads are counted twice for read-ahead

SQL performance

All

Learn More

Fixes the following error 104 that occurs when you use scalar User-Defined Function (UDF) lnlining in the ORDER BY clause during the query compilation that has a UNION operator:

Msg 104, Level 16, State 1, Line

ORDER BY items must appear in the select list if the statement contains a UNION, INTERSECT or EXCEPT operato

SQL performance

All

Fixes an assertion in CQPOnDemandTask::ExecuteQPJob if auto async update statistics is enabled

SQL performance

Windows

Fixes an issue where the specific statement for compilation in stored procedures seems "stuck" and shows sqlsource_transform until manual intervention

SQL performance

Windows

Fixes an access violation that occurs in CXPort::Close after you use SQL Server 2019 Cumulative Update 14 (CU14)

SQL performance

Windows

SQL Server 2019 CU 14

 

KB

Description

Fix area

Platform

Learn More

Fixes the following error that occurs when you restore a database file (.mdf) that is larger than 15 GB on SQL Server 2019 Big Data Cluster (BDC) with high availability (HA) configuration:

Msg 42019, Level 16, State 4, Line

RESTORE MANAGED DATABASE operation failed. Internal service error.

Msg 3013, Level 16, State 1, Line

RESTORE DATABASE is terminating abnormally.

High Availability

Linux

Fixes an assert dump "pwchId && cwchId 0" during Always On availability group (AG) Virtual Device Interface (VDI) seeding.

High Availability

Windows

Fixes an access violation exception that may occur when sp_server_diagnostics is executed.

High Availability

Windows

Fixes an issue where Last_sent_time and Last_received_time columns in DMV dm_hadr_database_replica_states does not get updated

High Availability

Windows

Fixes an issue where you encounter an "ex_terminator - Last chance exception handling" memory dump. The memory dump is associated with a lease timeout while the recovery of an Always On availability groups (AG) database is in progress.

High Availability

Windows

5008107

Improvement: Cardinality estimation in Spatial TVF functions in SQL Server 2019

SQL Engine

All

Learn More

4538688

FIX: Severe spinlock contention occurs in SQL Server 2019

SQL Engine

All

Learn More

5004936

FIX: Error when you use column store indexes and run versioned scans if all rows in a compressed row group are deleted in SQL Server 2017 and 2019

SQL Engine

All

Learn More

5007794

FIX: Non-yielding scheduler dumps during the recovery of a secondary availability database with a database snapshot

SQL Engine

All

Learn More

5007719

FIX: Creating a resumable clustered index on a table with LOB causes corruption in SQL Server 2019

SQL Engine

All

Learn More

5007744

FIX: Add checkpoint handling for the first row in Non Optimized Get And Insert Rows

SQL Engine

All

Learn More

5008114

FIX: The built-in SESSION_CONTEXT returns wrong results in parallel plans

SQL Engine

All

Learn More

5008184

FIX: ForceLastGoodPlan doesn't account for aborted and timed out queries in regression detection logic

SQL Engine

All

Learn More

5008296

FIX: Missing change data capture cleanup execution isn't identified because of a deadlock without an error message

SQL Engine

Windows

Learn More

Fixes an issue where the CollectPageLatchFields can cause an access violation (AV) under certain timing conditions when the latch_suspend_end XEvent is turned on. The underlying reason is that this method assumes the Buffer is stable under the latch, which isn't true if the Buffer isn't in the Hashtable anymore. This hotfix avoids the AV by checking whether the Buffer is still in the Hashtable before accessing its underlying fields.

SQL Engine

All

Fixes an Access Violation (AV) at RbpEarlyFilter::TinyBitmapFilterSIMD that occurs when you run queries on CLUSTERED COLUMNSTORE INDEX (CCI) tables. Here is the dump file:

Stack Dump being sent to

SqlDumpExceptionHandler: Process 247 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

BEGIN STACK DUMP:

Exception Address = Module(sqlmin+)

Exception Code    = c0000005 EXCEPTION_ACCESS_VIOLATION

Access Violation occurred reading address

SQL Engine

All

Fixes the EXCEPTION_INVALID_CRT_PARAMETER dump that is generated on insert or update of wide replicated table.

SQL Engine

Windows

Fixes the failed assertion that occurs due to implicit conversion where predicate's precision is greater than the value.

Msg 3624, Level 20, State 1, Line

A system assertion check has failed. Check the SQL Server error log for details. Typically, an assertion failure is caused by a software bug or data corruption. To check for database corruption, consider running DBCC CHECKDB. If you agree to send dumps to Microsoft during setup, a mini dump will be sent to Microsoft. An update might be available from Microsoft in the latest Service Pack or in a Hotfix from Technical Support.

Msg 596, Level 21, State 1, Line

Cannot continue the execution because the session is in the kill state.

Msg 0, Level 20, State 0, Line

A severe error occurred on the current command. The results, if any, should be discarded.

SQL Engine

Windows

Fixes the following runtime error that occurs when you build a 32-bit application where Microsoft.SqlServer.Rmo.dll is referenced from C:\Program Files (x86)\Microsoft SQL Server\150\SDK\Assemblies\ but Microsoft.SqlServer.Replication.dll isn’t cached in GAC_32 folder (C:\Windows\Microsoft.NET\assembly\GAC_32) with SQL Server 2019:

System.IO.FileNotFoundException

HResult=0x80070002

Message= Could not load file or assembly 'Microsoft.SqlServer.Replication, Version=15.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

SQL Engine

Windows

Fixes an issue where SQL Server 2019 stops responding and crashes due to "ex_terminator - Last chance exception handling" when you use SQL Server Service Broker.

SQL Engine

Windows

Fixes an Access Violation (AV) that can occur when you run dynamic management views (DMVs) queries.

SQL Engine

Windows

5007842

FIX: An assertion occurs when Compute Scalar operator operates on computed, temporary lobs with batch mode

SQL performance

Windows

Learn More

Fixes an issue where executing a query with BATCH_MODE_ON_ROWSTORE = ON causes the following error and a dump occurs during compilation of the execution plan:

Msg 596, Level 21, State 1, Line

Cannot continue the execution because the session is in the kill state.

Msg 0, Level 20, State 0, Line

A severe error occurred on the current command. The results, if any, should be discarded.

SQL performance

All

Fixes a non-yielding scheduler dump in sqldk!SOS_MemoryWorkSpace::Lookup.

SQL performance

All

Fixes an issue in which the query processor can’t produce a query plan if the USE PLAN hint specifies a query plan that has a left outer join and an inner join.

SQL performance

Windows

Fixes a self-deadlock issue where thread always waits for HASH_TABLE_DELETE (HTDELETE) when you run parallel query in batch mode.

SQL performance

Windows

Fixes an issue causing the assertion fNoReaderWriterConflict.

SQL performance

Windows

Fixes an issue where the following warning message occurs during the snapshot creation when you run the DBCC CHECKDB against a database that has a memory optimized filegroup:

[WARNING] Unable to create PerfCounter instance for DB xx (xxx): 0x800700b7.

In-Memory OLTP

Windows

SQL Server 2019 CU 13

 

KB

Description

Fix area

Platform

Learn More

5006359

FIX: A dump occurs if you use the same synonym for a user-defined function in the view definition

SQL Engine

All

Learn More

Fixes an issue where 22836 error occurs when you add CDC job again after deleting CDC capture and removing jobs in SQL Server Agent

SQL Engine

All

Fixes an issue where Polybase is not generating the partition predicates for pushdown which generates the following error when you do cross-database joins in the backend where one or more of the tables is partitioned:

Msg 7320, Level LineNumber, State 110, Line LineNumber

Cannot execute the query "Remote Query" against OLE DB provider "MSOLEDBSQL" for linked server "(null)". 105082;Generic ODBC error: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid object name '$partition.PF_Polybase'

SQL Engine

All

Adds improvement to enable distributed availability group and service broker connections with Azure SQL Managed Instance

High Availability

All

Adds improvement to certificate-based authentication between endpoints for database mirroring and service broker connections, facilitating rotation and management of certificates issued by a certificate authority

High Availability

All

Fix an issue where AD Authentication in SQL Server BDC encounters an error "enctype aes256-cts found in keytab but cannot decrypt ticket" if support for 128-bit and 256-bit Kerberos AES encryption is enabled

SQL Engine

Linux

Adds improvement to enable timezone configuration as a Big Data Cluster (BDC) cluster-level setting

SQL BDC

Linux

Fixes an issue where you cannot edit jobs by using SQL Server Management Studio (SSMS) if SQLAgent permissions are granted at AD group level

SQL Engine

Linux

4530907

Improvement: Corrupted statistics can be detected by using extended_logical_checks in SQL Server 2016, 2017, and 2019

SQL Engine

Windows

Learn More

5005788

FIX: Access violation occurs when you use FileTable feature with Windows Defender enabled

SQL Engine

Windows

Learn More

5005832

FIX: Cannot fetch a row by using OPENROWSET or OPENDATASOURCE and "MSOLEDBSQL" OLE DB driver for SQL Server in batch mode

SQL Performance

Windows

Learn More

5006632

FIX: An assertion dump occurs many times in SQL Server 2019

SQL Engine

Windows

Learn More

5006665

Improvement: Last Writer Wins and support for P2P database in Availability Group

SQL Engine

Windows

Learn More

Fixes an intra-query deadlock that occurs with certain queries when verbose truncation feature is enabled

SQL Engine

Windows

Fixes an Access Violation that occurs in SQL Server 2019 when you attempt to add file to database that has backup in progress

SQL Engine

Windows

Adds pOwnerSess to the error message to find the owner session Id that runs the Log Reader Agent or log - related procedure in SQL Server 2017

SQL Engine

Windows

Fixes an issue where an incorrect name entry in sys.servers can result in Always On Availability Group (AG) replica being removed when the server name does not match Windows hostname

High Availability

Windows

Fixes an issue where Memory Optimized TempDB Metadata keeps consuming memory under VARHEAP: LOB Page Allocator

In-Memory OLTP

Windows

Fixes an issue where the assertion results in system suspend of asynchronous secondary replica:

DateTime spid36s     SQL Server Assertion: File: , line=LineNumber Failed Assertion = 'curr->VlfSeqNo == prev->VlfSeqNo + 1'. This error may be timing-related. restart the server to ensure in-memory data structures are not corrupted

High Availability

Windows

Fixes an issue where you cannot complete image because the prepared instance is grayed out if you select [Database Engine Services] along with [Machine Learning Services and Language Extensions]- [Java] in Prepare Image

Setup & Install

Windows

Fixes an issue about extended event version in Alwayson_health session is not changed automatically during Cumulative Update upgrade and downgrade

High Availability

Windows

Fixed an issue where resumable clustered index creation may sometimes fail if a table has lots of LOB columns

SQL Engine

Windows

SQL Server 2019 CU 12

 

KB

Description

Fix area

Platform

Learn More

5001045

FIX: Memory grant wait times out when you run many Columnstore bulk inserts concurrently in SQL Server 2017 and 2019

SQL Engine

All

Learn More

5004733

FIX: Debug assert when a lock is acquired by the ParNested Transaction and attempts to get logged in sLog for the parent transaction

SQL Engine

All

Learn More

5004734

FIX: Persisted computed columns not being consistently blocked for Columnstore index

SQL Engine

All

Learn More

5004936

FIX: Error when you use columnstore indexes and run versioned scans if all rows in a compressed rowgroup are deleted in SQL Server 2019

SQL Engine

All

Learn More

Fixes an issue that causes the SQL Server to terminate. ex_terminator - Last chance exception handling

SQL Engine

All

Fixes an issue where optimizer doesn't push down constant parameters to remote query via linked server

SQL performance

All

Ensures that the correct error is returned, when an invalid table name is referenced inside a SHORTEST_PATH query on graph tables in SQL Server

SQL performance

All

Fixes an issue where you see USERSTORE_SCHEMAMGR grow uncontrollably and eventually leading to memory contention issues when you use graph queries in SQL Server 2019

SQL performance

All

5004750

FIX: SQL Server often crashes when network.forceencryption property is set to '1'

SQL Engine

All

Learn More

Fixes an issue in SQL Server 2019, if IPv6 is disabled on Linux in the bootloader (GRUB), PolyBase will fail to start

SQL Engine

All

5004560

FIX: Wrong results during Clustered Columnstore Index alter "index reorganize" in versioned scans in SQL Server 2017 and 2019

SQL Engine

Windows

Learn More

5004573

FIX: SQL Server affinity settings are reset after applying CU for SQL Server 2019

SQL Engine

Windows

Learn More

5004649

FIX: Parallel redo failure on secondary replica in SQL Server 2019

High Availability

Windows

Learn More

5005321

FIX: Dropping an index from the view on the primary may cause access violation on readable secondary

SQL performance

Windows

Learn More

Fixes an issue where running a Full Database Backup on a read-only database containing memory optimized objects fails with the error 3906

"Failed to update database "" because the database is read-only."

SQL Engine

Windows

Fixes a second exception that occurs when trying to generate a dump on a latch timeout issue and crashes the SQL service entirely

High Availability

Windows

Fixed the memory release issue in execution of the STDistance spatial method while using spatial index. Before the fix, memory usage of MEMORYCLERK_SOSNODE gradually grew until all the memory available is taken

SQL Engine

Windows

Fixes an issue in SQL Server 2019 where you may encounter an Access Violation or Assertion when using the sys.dm_exec_query_statistics_xml Dynamic Management View

SQL performance

Windows

Fixes an issue where frozen I/O leads to latch timeout on database boot page (1:9) and leads to suspended availability group database REDO thread

SQL Engine

Windows

Fixes an issue where creating an availability group with automatic seeding fails with the error: "Error: 4353 - Conflicting file relocations have been specified for file ''. Only a single WITH MOVE clause should be specified for any logical file name." due to a database where some files have been created, deleted several times with the same logical filename.

High Availability

Windows

Fixes the access violation that occurs when you use graph shortest path expressions with LIKE predicates

SQL performance

Windows

Adds improvement to report SQL Server native error 35217 in the AlwaysOn_health XEvent log:

DateSpid      Error: 35217, Severity: 16, State: 1.

DateSpid      The thread pool for Always On Availability Groups was unable to start a new worker thread because there are not enough available worker threads. This may degrade Always On Availability Groups performance. Use the "max worker threads" configuration option to increase number of allowable threads.

High Availability

Windows

Fixes missing data in the Change Data Capture (CDC) side table and adds additional error handling to prevent data loss

SQL Engine

Windows

Fixes an issue where NULL values are populated for the $from_id, $to_id columns in a graph edge table when batch mode execution is chosen in SQL Server 2019

SQL performance

Windows

Adds improvement to replace High Availability Disaster Recovery (HADR) related logs output by Trace Flag (TF) 3605 to the errorlog to a new extended event hadr_trace_message which is written to the alwayson_health session

High Availability

Windows

Fixes the access violation that occurs at sqllang!srv_nameinfo::SkipOptionalTransportProvider in SQL Server 2019

SQL connectivity

Windows

SQL Server 2019 CU 11

 

KB

Description

Fix area

Platform

Learn More

4535851

FIX: Scalar UDF Inlining issues in SQL Server 2019

SQL Engine

All

Learn More

5003525

Improvement: ADLS Gen2 support for External Tables

SQL Engine

All

Learn More

5003589

FIX: Error 19432 occurs when Log Writer thread fails to send a log back and stop log capture on Log Writer threads in SQL Server 2019

High Availability

All

Learn More

5003596

FIX: Log line is extremely high when Always On Availability Group has many databases in SQL Server 2019

High Availability

All

Learn More

5003870

SQL Engine

All

Learn More

FIX: Support using the PolyBase SQL Server connector to create external table with remote database name containing a period

Fixes an issue where executing a PolyBase related query encounters error "Invocation of TransactionStateCreate resulted in -1" and causes PolyBase Data Movement service memory dump

SQL Engine

All

Fixes failures in PolyBase queries involving date/time literals or integer divisions that may occur when the Microsoft Spark ODBC driver is used to connect to a generic ODBC external data source

SQL Engine

All

Fixes the high SOS_SUSPEND_QUEUE spinlock contention with parallel window aggregate

SQL Engine

All

Fixes an issue where the JVM will eventually crash with an out of memory error after a certain number of queries due to threads not being properly cleaned up in certain scenarios when you use PolyBase Hadoop bridge data sources in SQL Server 2019 on Linux

SQL Engine

Linux

Fixes an issue which leads to the impossibility of creating JAVA dumps and thus hampers debuggability and supportability when a PolyBase JAVA HadoopBridge process is started under Linux, an invalid -XX:HeapDumpPath JVM option is passed to the JVM

SQL Engine

Linux

4023170

FIX: Error 574 when you try to install Service Pack 2 for SQL Server 2014

SQL Engine

Windows

Learn More

5003342

SQL Engine

Windows

Learn More

FIX: SQL Server Express LocalDB can't start or connect to shared instances of SQL Server Express LocalDB 2019 or 2017

5003750

FIX: Performance issues occur when metadata is scanned to find keys to be sent to the AE enclave in SQL Server 2019

SQL security

Windows

Learn More

5003869

FIX: Support schema reflection stored procedures for the Polybase generic ODBC connector

SQL Engine

Windows

Learn More

5003937

Improvement: New XEvents temp_table_cache_trace and temp_table_destroy_list_trace are created in SQL Server 2019

SQL Engine

Windows

Learn More

Prevents ghost cleanup from triggering a memory dump during latch time-out in SQL Server 2019

SQL Engine

Windows

Fixes the memory release issue in execution of the STDistance spatial method while using spatial index. Before the fix, memory usage of MEMORYCLERK_SOSNODE gradually grew until all the memory available is taken

Fixes an issue where sp_hadr_verify_replication_publisher displays wrong distribution database name in error

SQL Engine

Windows

Fixes an issue where an availability group database restart process is blocked when the database is transitioned to a new state because of an availability group failover or lease timeout on the primary replica

High Availability

Windows

Fixes the error 3628 that occurs frequently when In-Memory OLTP is enabled in SQL Server 2019 and you may receive an error message as shown below:                                                                                                 DateTime     Error: 3628, Severity: 16, State: 1.

SQL Engine

Windows

DateTime     The Database Engine received a floating point exception from the operating system while processing a user request. Try the transaction again. If the problem persists, contact your system administrator.

Fixes an issue where Setup Account Privileges check may not performed when installing CU or Security Update

Setup & Install

Windows

Adds improvement to increase the default size and file retention on AlwaysOn_health.

High Availability

Windows

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 will not overwrite the existing settings.

Fixes a potential issue that causes error 5511 when performing a log backup on a database that has filestream data

SQL Engine

Windows

Fixes an issue that causes database log_reuse_wait_desc to change to AVAILABILITY_REPLICA when a database is removed from Availability Group

High Availability

Windows

When published database is part of availability group and listener is on a non-default port, replication monitor doesn’t display publication and subscription information. This CU fixes that issue.

SQL Engine

Windows

Fixes the performance issues that occur with concurrent executions of stored procedures on CHANGETABLE and syscommittab by enforcing index seek on change tracking side tables in SQL Server 2019

SQL performance

Windows

Fixes an issues that causes query to be stuck in BATCH_MODE_SORT in SQL Server 2019

SQL performance

Windows

SQL Server 2019 CU 10

 

KB

Description

Fix Area

Platform

Learn More

4548523

FIX: Database creation to Azure blob storage from SQL Server 2017 or 2019 on Linux may fail with error

SQL Engine

All

Learn More

5000649

FIX: Wrong results due to undetected concatenation parameters from scalar expression

SQL performance

All

Learn More

5001044

FIX: Wrong results occur when you run a query on In-memory optimized tables in SQL Server

In-Memory OLTP

All

Learn More

5001260

Improvement: Performance improvements of several spatial built-in properties and methods in SQL Server

SQL Engine

All

Learn More

5001266

FIX: Access Violation occurs when hybrid buffer pool is enabled in SQL Server 2019

SQL Engine

All

Learn More

5001517

FIX: Metadata deadlock causes availability issues when changing auditing properties in SQL Server 2019

SQL security

All

Learn More

5001526

FIX: Access violation occurs when Dynamic Data Masking and nested UDFs are used in SQL Server 2019

SQL security

All

Learn More

Fixes an issue that enables Block Caching for MMLarge memory model in SQL Server 2019

SQL Engine

All

Fixes an Access Violation (AV) that occurs when error is being collected for Availability Group (AG) DB Failover while there is an AG failover undergoing

High Availability

All

Improvement: Records stage of failure and error during stack copy for better diagnostics

SQL Engine

All

Fixes an issue where you notice that spurious CAST operations in PolyBase external pushdown queries can dramatically affect the performance with some backends

SQL Engine

All

Disables FQDNs in AD usernames when creating/modifying SQL Logins/users for SQL Server 2019 on Linux

SQL Engine

Linux

Fixes an issue where a failed network connection results in a socket leak

SQL Engine

Linux

Improves AD keytab rotation by properly handling the keytab entries with future KVNOs when SSSD is disabled

SQL Engine

Linux

Fixes a high HADR_SYNC_COMMIT waits which may show on SQL Server with heavy workload after you apply CU7

SQL Engine

Linux

SQL Server Service is not starting and failing with core dump after applying SQL Server 2019 CU8

Big Data Cluster (BDC)

Linux

SQL Server Service is not starting and failing with core dump after applying SQL Server 2019 CU8

SQL Engine

Linux

Fixes an issue in SQL Server 2019 where kubeadm-prod install hangs on compute/master pods when netbios name and ouDistinguishedName have mismatch

Big Data Cluster (BDC)

Linux

4486936

FIX: "Login failed for user" error occurs when you run

Maintenance plan with SQL login account in SQL Server

SQL Engine

Windows

Learn More

4589350

FIX: MERGE statement fails with Access Violation at BTreeRow::DisableAccessReleaseOnWait in SQL Server

SQL performance

Windows

Learn More

5000650

FIX: Incorrect results occur when you run query on In-memory optimized table that has clustered columnstore index in SQL Server 2016 or 2019

In-Memory OLTP

Windows

Learn More

5000715

FIX: Failures with log reader agent occurs when you create and drop publication on CDC enabled database in SQL Server 2016 and 2019

SQL Engine

Windows

Learn More

5001159

FIX: Assertion failure occurs when Online Clustered Columnstore Index Rebuild reuses truncated hobt instead of new hobt in SQL Server 2019

SQL Engine

Windows

Learn More

When a VSS backup tries to back up SQL Server databases that are hosted on the forwarder replica of a Distributed Availability Group, the backup operation fails.

This BACKUP or RESTORE command is not supported on a database mirror or secondary replica.

BACKUP DATABASE is terminating abnormally.

In the error log, you may see the following error:         DateTime Backup      Error: 3041, Severity: 16, State: 1..

DateTime Backup      BACKUP failed to complete the command BACKUP DATABASE

DatabaseName. Check the backup application log for detailed messages.

SQL Engine

Windows

Allows pushdown of filter predicate for PolyBase query that utilizes FORMAT or TRIM functions in the SELECT clause if the query is otherwise qualified for pushdown

SQL Engine

Windows

Query execution may experience an intra-query deadlock if the query plan is using a single threaded batch mode sort operator before a Repartition Streams Parallelism operator

SQL Engine

Windows

Fixes to keep 'PERSIST_SAMPLE_PERCENT' value for statistics on an indexed column after index rebuild

SQL performance

Windows

Fixes an issue where synchronizeSecurity setting of AMO method 'Microsoft.AnalysisServices.Tabular.Server.Synchronize' shown in Server.Synchronize Method  is ignored

Analysis services

Windows

Fixes an issue with performance when tabular queries in SSAS 2019 take more time to execute compared to SSAS 2016

Analysis services

Windows

Fixes an issue with the Foreign Key added to a table that is referencing a table's column which is part of a unique index with included columns. When the table's ALTER command is replicated, Distribution Agent fails with the following error message

Number of referencing columns in foreign key differs from number of referenced columns, table 'TableName'. (Source: MSSQLServer, Error number: 8139)

SQL Engine

Windows

Fixes an issue where the query based on full-text indexes is not returning the expected values

SQL Engine

Windows

Fixes an Access Violation error that can occur when you import large amount of data to Windows Azure Blob storage. This can occur if PolyBase Data Movement Service encounters out-of-memory condition during large data insert transaction.

SQL Engine

Windows

Fixes an issue where out of memory occurs when you take a log backup frequently and Stolen Server Memory grows at an synchronous secondary in Availability Groups

High Availability

Windows

Fixes an issue where DBCC PAGE with option 3 generates access violation dumps after dropping a unique identifier column from the table in SQL Server 2019 

Msg 596, Level 21, State 1, Line LineNumber

Cannot continue the execution because the session is in the kill state.

Cannot continue the execution because the session is in the kill state.

Msg 0, Level 20, State 0, Line LineNumber

A severe error occurred on the current command. The results, if any, should be discarded.

SQL Engine

Windows

Fixes an issue where query compilation that involves auto create statistics fails with the following error log:

Datetime spidId      Error: 3628, Severity: 16, State: 1.

Datetime spidId      The Database Engine received a floating point exception from the operating system while processing a user request. Try the transaction again. If the problem persists, contact your system administrator.

SQL performance

Windows

Fixes an issue where performance counter Data File(s) Size (KB) doesn’t report the correct total size of database files if one file is created with initial size > 4 TB or grown by more than 4TB

SQL Engine

Windows

Adds a new option to free the LogPool cache only: DBCC FREESYSTEMCACHE('LogPool')

SQL Engine

Windows

Fixes the unexpected date conversion on some special date format

Data Quality Services (DQS)

Windows

Fixes the following dump exception after login failures in SQL Server 2019:

ex_raise2: Unhandled exception raised, major=36, minor=2, state=52, severity=25

High Availability

Windows

SQL Server 2019 CU 9

 

KB

Description

Fix area

Platform

Learn More

4538581

FIX: Scalar UDF Inlining issues in SQL Server 2019

SQL Engine

All

Learn More

4588980

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

SQL Engine

All

Learn More

4588983

FIX: CREATE STATISTICS WITH SAMPLE PERCENT command fails with error when Oracle data source has partitioned table

SQL Engine

All

Learn More

5000649

FIX: Wrong results due to undetected concatenation parameters from scalar expression

SQL performance

All

Learn More

5000655

FIX: Memory leak may occur when SQL Server auditing feature is used on an instance of SQL Server 2019

SQL Security

All

Learn More

5000656

FIX: Incorrect type of data mask is applied when DDM is used with queries that have UDFs in SQL Server 2019

SQL Security

All

Learn More

5000670

FIX: Error occurs when you map an Oracle NUMBER type to a T-SQL DECIMAL/NUMERIC type

SQL Engine

All

Learn More

5000671

FIX: Error occurs when casting non-Unicode string column using a Unicode-only UTF8 collation in SQL Server 2019

SQL Engine

All

Learn More

5000672

FIX: Fixes reading of NULL Time fields for non-sqlserver backends

SQL Engine

All

Learn More

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 performance

All

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 performance

All

Fixes the Assertion failure that occurs when group properties for CLeafOp children are derived

SQL performance

All

Enables async path for PolyBase remote query and add cleanups for timeout/abort in SQL Server 2019

SQL Engine

All

Fixes the query hang issue that occurs in SQL Server 2019 when querying an external table through PDW

SQL Engine

All

Adds a randomization logic when mapping writers to pods in SQL Server 2019

SQL Engine

All

New logging and XEvents to help troubleshoot long-running Buffer Pool scans

SQL Engine

All

Learn More

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 Engine

All

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 Engine

All

Learn More

Fixes an issue with PolyBase SQL dump hash computation that uses MD5 which is not FIPS compliant

SQL Engine

All

Fixes an issue where PolyBase fails when it is deployed on a platform (Windows or Linux) and the control node hostname resolves to an IPv6

SQL Engine

All

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 Engine

All

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 Engine

All

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 Engine

All

Adds improvement to increase the default size and file retention on AlwaysOn_health.

NoteThe 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 will not overwrite the existing settings.

SQL Engine

All

4588977

FIX: SQL Server crashes when Afd!DbCreateSocketOperation process fails

SQL connectivity

Linux

Learn More

4588979

FIX: Fail to create AG on top of FCI in SQL Server 2019

High Availability

Linux

Learn More

5000663

FIX: Database mail doesn't send e-mail messages when IP address is specified in mssql-conf

SQL Engine

Linux

Learn More

5000669

Improvement: Adds a new external generic query builder in SQL Server 2019

SQL Engine

Linux

Learn More

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 Engine

Linux

Fixes the non-yielding scheduler condition that occurs when AG listener is created with invalid IP address in SQL Server 2019 on Linux

SQL Engine

Linux

Fixes an issue where deployment is stuck in 'WaitingForControlPlaneFilesDownload' state with ObjectDisposedException in controller

Big Data Cluster (BDC)

Linux

Fixes infinite loop in VDI due to improper initialization of errno variable

SQL Engine

Linux

Fixes an issue where SQL process is not killed properly resulting in subsequent start of SQL Server fails when the AG-Helper send the KILL 9 command to terminate the SQL Server process

High Availability

Linux

Updates the Zulu JRE version to mssql-zulu-jre-11.43.56-1 and mssql-zulu-jre-8-8.50.0.52-1

SQL Engine

Linux

4538688

FIX: Severe spinlock contention occurs in SQL Server 2019

SQL Engine

Windows

Learn More

4547890

FIX: ISDBUpgradeWizard.exe throws error when you try to upgrade SSISDB after restoring from earlier versions in SQL Server

Integration services

Windows

Learn More

4565944

Improvement: A manual method to set maximum group commit time in SQL Server 2017 and 2019

High Availability

Windows

Learn More

4568447

FIX: Automatic seeding failure occurs for a secondary replica in SQL Server 2016 and 2019

High Availability

Windows

Learn More

4569837

FIX: Intermittent connection error occurs when an expression is used for both connection string and password of a connection manager

Integration services

Windows

Learn More

4575689

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

SQL Performance

Windows

Learn More

4575939

FIX: Log reader agent generates access violation exception for P2P or transactional replication with partitioning tables in SQL Server 2016 and 2019

SQL Engine

Windows

Learn More

4575940

FIX: Newly added articles' snapshot doesn't get applied to subscriber in SQL Server 2016 and 2019

SQL Engine

Windows

Learn More

4577932

FIX: Access Violation exception occurs in Availability Groups in SQL Server 2017 under certain conditions

High Availability

Windows

Learn More

4577933

FIX: Cascade delete on key values outside of leading table histogram bounds causes index scan in SQL Server 2017 and 2019

SQL Performance

Windows

Learn More

4577976

FIX: COMPILE blocking occurs when executing many concurrent stored procedures in SQL Server 2017 and 2019

SQL Performance

Windows

Learn More

4580397

FIX: Incorrect results occur when you run INSERT INTO SELECT statement on memory-optimized table variables in SQL Server

In-memory OLTP

Windows

Learn More

4585971

FIX: User session is in rollback state indefinitely after it is killed in SQL Server 2016

SQL Engine

Windows

Learn More

4588978

FIX: Statistics are ignored when a query is run on PolyBase external table in SQL Server 2019

SQL Engine

Windows

Learn More

4588981

FIX: "LogConsumer::StartScan failed to get the control lock" error occurs and the log writer activity stops completely in SQL Server 2019

High Availability

Windows

Learn More

4588982

FIX: sys.dm_exec_requests returns transaction_id as "0" in certain scenarios in SQL Server 2019

SQL Engine

Windows

Learn More

4588984

FIX: Contention on XVB_List spinlock in highly concurrent workloads when using RCSI

SQL Engine

Windows

Learn More

4589170

FIX: Indefinite hang occurs during cube processing after applying SSAS 2016 SP2 CU7

Analysis services

Windows

Learn More

4589171

FIX: Unexpected error occurs when a query is run on an instance of SSAS

Analysis services

Windows

Learn More

4589345

FIX: Error 3625 occurs during query execution when batch mode on rowstore is enabled in SQL Server 2019

SQL performance

Windows

Learn More

4589350

FIX: MERGE statement fails with Access Violation at BTreeRow::DisableAccessReleaseOnWait in SQL Server

SQL performance

Windows

Learn More

4594016

FIX: Assertion failure error occurs on sqlmin.dll!XdesRMBase::StartStmtSnapshot in SQL Server 2019

SQL Engine

Windows

Learn More

5000895

Improvement: New trace Flags for better maintenance of deleted rows in Clustered Columnstore Index

SQL Engine

Windows

Learn More

Improves SSISDB performance by adding indexes to event_message_context and execution_property_override_values tables in SQL Server 2019

Integration services

FIX: Query returns different result set when run on In-memory optimized tables and disk-based tables in SQL Server 2019

SQL performance

Windows

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

High Availability

Windows

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 Engine

Windows

FIX: SSIS ScaleOut Execution intermittently reports "Unexpected Termination" in the execution status but all tasks gets completed successfully

Integration services

Windows

Fixes Monitor and Sync replication agentjob 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.

SQL Engine

Windows

DBCC SHRINKFLE or SHRINKDATABASE can cause an assertion exception error when executed against database or files containing system-versioned temporal tables

SQL Engine

Windows

Fixes Recursive hierarchy in explore page that is not working properly in MDS version 2019

Data Quality Services (DQS)

Windows

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 performance

Windows

Fixes deadlocks that occur in [catalog].[set_execution_property_override_value]

Integration Services

Windows

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 Engine

Windows

Unable to connect to primary database replica after failing over the Availability Group in SQL Server

High Availability

Windows

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 Engine

Windows

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 Engine

Windows

FIX: VERIFY_CLONEDB prints message 'Clone database verification has failed' for the database if the database name starts with a number

SQL Engine

Windows

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, does not come online and generates the assertion dumps.

File: , line=LineNumber Failed Assertion = 'inCorrectOrder'

SQL Engine

Windows

Fixes Non-yielding Scheduler error that may occur when Query Store tries to grow its memory structure during heavy workload

SQL Engine

Windows

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 connectivity

Windows

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 Engine

Windows

Forwarder is unable to reconnect to global primary following Global primary planned failover if the LISTENER_URL is modified

High Availability

Windows

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 Engine

Windows

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 Engine

Windows

Fixes an access violation dump that occurs after you run a query by using OUTER APPLY on sys.dm_db_index_operational_stats

SQL Engine

Windows

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 Engine

Windows

FIX: SQL Agent job fails with a sharing violation when writing to step output file in SQL 2019

Management Tools

Windows

Fixes an issue where a database restore fails with an error 3257 (insufficient free space error) when the database is larger than 2TB. 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 16TB and uses an allocation unit size = 512 bytes and a single sector per cluster.

SQL Engine

Windows

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 Engine

Windows

Updates the Zulu JRE version to mssql-zulu-jre-11.43.56

SQL Engine

Windows

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

Windows

Adds a new option to free the LogPool cache only: DBCC FREESYSTEMCACHE('LogPool')

SQL Engine

Windows

FIX: Assertion or RaiseInconsistencyError occurs when you use  VersionStoreTableAccess::PopulateRowData on SQL 2019 Always On Availability Group Readable replica, but actually there is no corruption

High Availability

Windows

Fixes the assertion failure that occurs at FAILED_ASSERTION_42ac_sqlmin.dll!LogLockCollectionVerify::Callback in SQL Server 2019

SQL Engine

Windows

SQL Server 2019 CU 8

 

KB

Description

Fix Area

Platform

Learn More

Fixed an issue that reduced throughput and caused higher CPU when you run workloads that frequently allocate and release memory, such as XML related functions.

SQL Engine

All

PATINDEX returns wrong result for non-Latin input string when you use Latin1_General_100_BIN2_UTF8 collation.

SQL Engine

All

Python and R CAB files for SQL Server Machine Learning Services on Windows and mssql-mlservices packages on Linux are updated to version 9.4.7.958. On Windows, it fixes "Cannot resume session with terminated pooled process" error while launching Python/R runtimes. On Linux, it enables successful installation of mssql-mlservices-mlm-r package on RHEL8.

SQL Engine

All

Query Store scalability improvement for adhoc 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 Engine

All

Updated error messages to remove inconsistent use of word SQL.

SQL Engine

All

4579223

FIX: PolyBase processes will be started to avoid dump during provisioning in SQL Server 2019

SQL Engine

All

Learn More

4580648

FIX: Errors may occur or PolyBase services fail to start when you run PolyBase queries on a non-English OS

SQL Engine

All

Learn More

4580413

FIX: Deadlock occurs between Availability Group Configuration and Replica Transport State Lock in SQL Server 2019

High Availability

All

Learn More

This change improves external lease renew time for external cluster type in SQL Server 2019.

High Availability

All

4580639

FIX: PolyBase queries can now be run with EXECUTE AS impersonation context in SQL Server 2019

SQL Engine

All

Learn More

Fixed issue where ALTER AVAILABILITY GROUP SET (ROLE=SECONDARY) raises an error 41104. However, it doesn't impact the Always On Availability Group health.

High Availability

All

Fixed an issue with excessive number of informational messages in the Error log when Accelerated Database Recovery (ADR) is disabled for a database.

SQL Engine

All

4581882

FIX: Restoring database fails due to backup command timeout in SQL Server 2019

High Availability

Linux

Learn More

4582558

FIX: SQL Server 2019 service fails to start in Linux operating system

SQL Engine

Linux

Learn More

4577837

FIX: Queries may fail when storage pool caching is enabled by default in SQL Server 2019 Big Data Cluster

SQL Engine

Linux

Learn More

4578292

FIX: Error occurs when you try to deploy CU5 or CU6 for SQL Server 2019 BDC irrespective of the azdata version

Big Data Cluster (BDC)

Linux

Learn More

4580949

FIX: Snapshot agent fails when you create Transactional Publication with all tables and UDFs in SQL Server 2019

SQL Engine

Windows

Learn More

Fixed long package execution time involving SSIS task of type TransferSqlServerObjectsTask when database contains tens of thousands of tables and the db user is not db_owner.

Integration Services

Windows

4578267

FIX: Different result set for the same query using dm_sql_referenced_entities in SQL Server 2019

SQL Engine

Windows

Learn More

Fixed Web UI Explorer display issue in SQL Server 2019 Master Data Services (MDS) in which the column width remains constant irrespective of any display width configured at attribute level.

Data Quality service (DQS)

Windows

4581886

FIX: Joins not getting pushed down for PolyBase query that joins multiple external tables

SQL Engine

Windows

Learn More

XEvent sqlsni.sni_trace does not fire unless sqlsni.trace is enabled in SQL Server 2019.

SQL connectivity

Windows

Fixed issue where a plan does not get cached (no SP:CacheInsert in trace) when the Interleaved Execution for MSTVFs feature is used and the MSTVF contains a LOB parameter that requires a conversion.

SQL Engine

Windows

4578579

Improvement: Availability Group listener without the load balancer in SQL Server 2019

High Availability

Windows

Learn More

Fixed an unexpected error that occurs when you deploy a 1500 compatibility mode model with relationship and Direct Query mode ON.

An unexpected error occurred (file 'FileName', line LineNumber, function 'FunctionName')

Analysis services

Windows

4538688

FIX: Severe spinlock contention occurs in SQL Server 2019

SQL Engine

Windows

Learn More

When an extended event that outputs a query plan is enabled, execution of a natively compiled stored procedure incorrectly included actual execution plan information in the output, which could cause errors if the client application does not expect such output.

In-memory OLTP

Windows

SSAS Multidimensional deployment mode may encounter Access Violation (AV) upon Excel grouping with Create Session cube followed by MDSCHEMA_MEMBERS. AV exception may occur many times that SSAS may reach the maximum exception limit and eventually terminate.

Analysis services

Windows

Fixed Master Data Services (MDS) Filter for Business Rule Validation which doesn’t show a reason for failure after 'x' number of records.

Data Quality Service (DQS)

Windows

4580397

FIX: Incorrect results occur when you run INSERT INTO SELECT statement on memory-optimized table variables in SQL Server 2016

In-memory OLTP

Windows

Learn More

4580915

FIX: SQL Server error log receives several ADR enabled/disabled messages even when ADR isn't explicitly enabled/disabled

SQL Engine

Windows

Learn More

Fixed an issue in SQL Server Analysis Services to allow users to use AVERAGE function with extension columns.

Analysis services

Windows

4561305

FIX: Concurrent inserts against tables with columnstore indexes may cause queries to hang in SQL Server 2016 and 2019

SQL Engine

All

Learn More

When you run a SELECT query in Read Committed Snapshot Isolation (RCSI) on Clustered Columnstore Index (CCI) on a table in SQL Server 2019, the query may return incorrect number of rows under rare conditions.

SQL Engine

All

Fixes an assertion exception that occurs when you query the DMV sys.dm_hadr_automatic_seeding.

High Availability

All

This update fixes an issue with sys.dm_db_stats_histogram not showing NULL value histogram step.

SQL performance

All

4574801

FIX: Incorrect results occur when you run PolyBase query to read text files from Hadoop in SQL Server 2019

SQL Engine

All

Learn More

4578395

FIX: Error occurs when using DBCC operations while TDE key change happens in SQL Server 2019

SQL security

All

Learn More

4034376

FIX: Couldn't disable "change data capture" if any column is encrypted by "Always Encrypted" feature of SQL Server

SQL Engine

All

Learn More

4538581

FIX: Scalar UDF Inlining issues in SQL Server 2019

SQL Engine

All

Learn More

Fixes failure of SQL Server Extensibility Runtimes Setup on FIPS compliant servers.

SQL Engine

All

4577594

FIX: Add language and extension directories to the PATH environment variable in SQL Server 2019

SQL Engine

All

Learn More

4576778

FIX: Table Variable Deferred Compilation feature on SQL Server 2019 database remains enabled when database compatibility level is 140 or lower

SQL Engine

All

Learn More

4577836

FIX: Inconsistency occurs when ghost rows are inserted into mapping index rowset

SQL Engine

All

Learn More

4578011

FIX: Unable to restore SQL Server database from previous versions on NVMe device partitioned in 4K block size

SQL Engine

Linux

Learn More

4575453

FIX: SQL Server fails to start when remote admin connections are enabled and IPV6 is disabled on the host

SQL Engine

Linux

Learn More

Improvement: Enables RLS feature for PolyBase by default in SQL Server 2019.

SQL Engine

Linux

This updates adds detailed error information to the pacemaker log when pacemaker agent fails to connect to SQL Server resource to obtain health status.

High Availability

Linux

4569424

FIX: Intermittent Availability Group failover occurs as AG helper connection times out while connecting to SQL Server

High Availability

Linux

Learn More

4577591

FIX: Widerow insert to an external table is not supported when the row width is more than 32K in SQL Server 2019

SQL Engine

Linux

Learn More

4577590

FIX: Error occurs when row width is less than DMS buffer size of 32K and an incorrect return path is chosen in SQL Server 2019

SQL Engine

Linux

Learn More

Fixes an issue to reduce parallel redo thread shutdown and startup thread messages in error log on servers with fewer cores and more idle databases.

High Availability

Windows

4577561

FIX: Error occurs when you try to filter the members of an entity for numeric values less than or greater than '0' in MDS 2019

Master Data Services

Windows

Learn More

Fixes intermittent connection issue with SSIS package executions when expression is used for both connection string and password of a connection manager.

Integration services

Windows

4578110

FIX: Error 8992 occurs when you run DBCC CHECKDB on cloned database in SQL Server 2019

SQL Engine

Windows

Learn More

DBCC CHECKDB reports corruption on spatial index incorrectly if base table has a column called ID.

SQL Engine

Windows

SSRS 2016 URLs are case-sensitive after applying Security update GDRs: KB4532097 and KB4535706.

SQL Engine

Windows

When you concurrently create sub directories in a FileTable directory, a deadlock may occur internally in the SQL Server Engine and all subsequent requests to FileTable directories and files may not respond.

SQL Engine

Windows

When a replication error such as deadlock occurs, random id is inserted in MSRepl_Errors table while it should be just incremented by 1 from the previous id value. This cumulative update (CU) fixes the issue and the MSRepl_Errors will insert entries with row id incremented by 1 instead of using some random value.

SQL Engine

Windows

When you run an ALTER command WITH ROLLBACK IMMEDIATE, the rollback can trigger before the command is processed, thus rolling back transactions even if the ALTER itself fails due to lack of permissions. This fix makes sure that the rollback is processed only after the ALTER command completes.

SQL Engine

Windows

4511771

FIX: Full-Text search auto crawl stops when AG goes offline in SQL Server

SQL Engine

Windows

Learn More

4563115

FIX: Upgrade script may fail if you use Always On Failover Cluster Instance as a secondary replica in SQL Server 2016 and 2019

SQL Engine

Windows

Learn More

When DBCC CHECKTABLE, CHECKFILEGROUP and CHECKDB commands are issued against a database with table that contains columnstore index located on read-only non-primary filegroup, you may receive the following error:

Msg 8921, Level 16, State 1, Line LineNumber

Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.

SQL Engine

Windows

4560183

FIX: Distributed transactions may experience long waits with DTC_STATE wait type in SQL Server 2016 and 2019

SQL Engine

Windows

Learn More

FIX: Assertion error occurs on the mirror server during redo process hitting. Assertion: File: FilePath\FileName, line = LineNumber Failed Assertion = 'result == LCK_OK'

High Availability

Windows

Access violation exception occurs when a query that references a non-exsting partition function is executed.

SQL performance

Windows

Fixes the Japanese translation for "State" in SQL Configuration Manager.

SQL Engine

Windows

Unable to change the DateTime/Number attributed to NULL in Master Data Services (MDS).

Data Quality Services (DQS)

Windows

4569425

FIX: Transactional replication publications can support URL type device to initialize subscriptions from backups in Azure Blob Storage in SQL Server 2017

SQL Engine

Windows

Learn More

4567166

FIX: Assertion failure occurs when you try to insert record into a page in fully logged mode in SQL Server 2017 and 2019

SQL Engine

Windows

Learn More

Error occurs when mashup is used to import from Active Directory (AD) using the default M query generated from the connection wizard. Key Expression Error: The key didn't match any rows in the table

Analysis services

Windows

DELETE statement returns Foreign Key check constraint error even when REFERENCE table has no matching rows.

Msg 547, Level 16, State 0, Line LineNumber

The DELETE statement conflicted with the REFERENCE constraint "ConstraintName".

The conflict occurred in database "DatabaseName", table "TableName", column 'ColumnName'.

The statement has been terminated.

SQL performance

Windows

Fixes long duration for Integration Services Project deployment through powershell by improving search of operation messages in deployment process.

Integration services

Windows

Fixes an error that occurs when a session cube is created on a database and you try to query from that session cube. The following error is received when you query the session cube: Server: The operation has been cancelled because there is not enough memory available for the application. If using a 32-bit version of the product, consider upgrading to the 64-bit version or increasing the amount of memory available on the machine

Analysis services

Windows

Column description disappears after exporting/importing models through MDSModelDeploy for an approval required entity in SQL Server 2019.

Data Quality Services (DQS)

Windows

Fixes a performance issue when a query outputs NULL values following a semi join in SQL Server 2019 for a database with UTF8.

SQL performance

Windows

Updates RSetup with the updated FWLINK version 3.5.2.777.

SQL Engine

Windows

Fixes an issue in MDS Filtered results where the user is not returned to page 1 and the page count is not updated until returning to page 1.

Data Quality Services (DQS)

Windows

Updates the Zulu JRE version to zulu11.37.18-sa-jre11.0.6.101.

SQL Engine

Windows

Fixes an issue in Master Data Services 2019 where you cannot input multiline content in text attributes.

Data Quality Services (DQS)

Windows

Under (rare) certain circumstances, memory grant re-calculation can cause an access violation.

SQL performance

Windows

SQL Server 2019 CU 7

 

KB

Description

Fix Area

Platform

Learn More

4561305

FIX: Concurrent inserts against tables with columnstore indexes may cause queries to hang in SQL Server 2016 and 2019

All

Learn More

When you run a SELECT query in Read Committed Snapshot Isolation (RCSI) on Clustered Columnstore Index (CCI) on a table in SQL Server 2019, the query may return incorrect number of rows under rare conditions.

SQL Engine

All

Fixes an assertion exception that occurs when you query the DMV sys.dm_hadr_automatic_seeding.

High Availability

All

This update fixes an issue with sys.dm_db_stats_histogram not showing NULL value histogram step.

SQL performance

All

4574801

FIX: Incorrect results occur when you run PolyBase query to read text files from Hadoop in SQL Server 2019

SQL Engine

All

Learn More

4578395

FIX: Error occurs when using DBCC operations while TDE key change happens in SQL Server 2019

SQL security

All

Learn More

4034376

FIX: Couldn't disable "change data capture" if any column is encrypted by "Always Encrypted" feature of SQL Server

SQL Engine

All

Learn More

4538581

FIX: Scalar UDF Inlining issues in SQL Server 2019

SQL Engine

All

Learn More

Fixes failure of SQL Server Extensibility Runtimes Setup on FIPS compliant servers.

SQL Engine

All

4577594

FIX: Add language and extension directories to the PATH environment variable in SQL Server 2019

SQL Engine

All

Learn More

4576778

FIX: Table Variable Deferred Compilation feature on SQL Server 2019 database remains enabled when database compatibility level is 140 or lower

SQL Engine

All

Learn More

Python and R CAB files for SQL Server Machine Learning Services on Windows and mssql-mlservices packages on Linux are updated to version 9.4.7.958. On Windows, "Cannot resume session with terminated pooled proccess" error is fixed while launching Python/R runtimes. On Linux, this update enables successful installation of mssql-mlservices-mlm-r package on RHEL8.

SQL Engine

All

4577836

FIX: Inconsistency occurs when ghost rows are inserted into mapping index rowset

SQL Engine

All

Learn More

4578011

FIX: Unable to restore SQL Server database from previous versions on NVMe device partitioned in 4K block size

SQL Engine

Linux

Learn More

4575453

FIX: SQL Server fails to start when remote admin connections are enabled and IPV6 is disabled on the host

SQL Engine

Linux

Learn More

Improvement: Enables RLS feature for PolyBase by default in SQL Server 2019

SQL Engine

Linux

This updates adds detailed error information to the pacemaker log when pacemaker agent fails to connect to SQL Server resource to obtain health status.

High Availability

Linux

4569424

FIX: Intermittent Availability Group failover occurs as AG helper connection times out while connecting to SQL Server

High Availability

Linux

Learn More

4581882

FIX: Restoring database fails due to backup command timeout in SQL Server 2019 .

High Availability

Linux

Learn More

4577591

FIX: Widerow insert to an external table is not supported when the row width is more than 32K in SQL Server 2019

SQL Engine

Linux

Learn More

4577590

FIX: Error occurs when row width is less than DMS buffer size of 32K and an incorrect return path is chosen in SQL Server 2019

SQL Engine

Linux

Learn More

4577837

FIX: Queries may fail when storage pool caching is enabled by default in SQL Server 2019 Big Data Cluster

SQL Engine

Linux

Learn More

4578292

FIX: Error occurs when you try to deploy CU5 or CU6 for SQL Server 2019 BDC by using azdata client 20.0.0 on RHEL host OS

SQL BDC

Linux

Learn More

Fixes an issue to reduce parallel redo thread shutdown and startup thread messages in error log on servers with fewer cores and more idle databases.

High Availability

Windows

4577561

FIX: Error occurs when you try to filter the members of an entity for numeric values less than or greater than '0' in MDS 2019

Master Data Services

Windows

Learn More

Fixes intermittent connection issue with SSIS package executions when expression is used for both connection string and password of a connection manager.

Integration services

Windows

4578110

FIX: Error 8992 occurs when you run DBCC CHECKDB on cloned database in SQL Server 2019

SQL Engine

Windows

Learn More

DBCC CHECKDB reports corruption on spatial index incorrectly if base table has a column called ID.

SQL Engine

Windows

SSRS 2016 URLs are case-sensitive after applying Security update GDRs: KB4532097 and KB4535706.

SQL Engine

Windows

When you concurrently create sub directories in a FileTable directory, a deadlock may occur internally in the SQL Server Engine and all subsequent requests to FileTable directories and files may not respond.

SQL Engine

Windows

When a replication error such as deadlock occurs, random id is inserted in MSRepl_Errors table while it should be just incremented by 1 from the previous id value. This cumulative update (CU) fixes the issue and the MSRepl_Errors will insert entries with row id incremented by 1 instead of using some random value

SQL Engine

Windows

When you run an ALTER command WITH ROLLBACK IMMEDIATE, the rollback can trigger before the command is processed, thus rolling back transactions even if the ALTER itself fails due to lack of permissions. This fix makes sure that the rollback is processed only after the ALTER command completes.

SQL Engine

Windows

4511771

FIX: Full-Text search auto crawl stops when AG goes offline in SQL Server

SQL Engine

Windows

Learn More

4563115

FIX: Upgrade script may fail if you use Always On Failover Cluster Instance as a secondary replica in SQL Server 2016 and 2019

SQL Engine

Windows

Learn More

When DBCC CHECKTABLE, CHECKFILEGROUP and CHECKDB commands are issued against a database with table that contains columnstore index located on read-only non-primary filegroup, you may receive the following error:

Msg 8921, Level 16, State 1, Line LineNumber

Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.

SQL Engine

Windows

4560183

FIX: Distributed transactions may experience long waits with DTC_STATE wait type in SQL Server 2016 and 2019

SQL Engine

Windows

Learn More

FIX: Assertion error occurs on the mirror server during redo process hitting.
Assertion: File: ,File: FilePath\FileName, line = LineNumber Failed Assertion = 'result == LCK_OK'

High Availability

Windows

Access violation exception occurs when a query that references a non-exsting partition function is executed.

SQL performance

Windows

Fixes the Japanese translation for "State" in SQL Configuration Manager.

SQL Engine

Windows

Unable to change the DateTime/Number attributed to NULL in Master Data Services (MDS).

Data Quality Services (DQS)

Windows

4569425

FIX: Transactional replication publications can support URL type device to initialize subscriptions from backups in Azure Blob Storage in SQL Server 2017

SQL Engine

Windows

Learn More

4567166

FIX: Assertion failure occurs when you try to insert record into a page in fully logged mode in SQL Server 2017 and 2019

SQL Engine

Windows

Learn More

Error occurs when mashup is used to import from Active Directory (AD) using the default M query generated from the connection wizard. Key Expression Error: The key didn't match any rows in the table

Analysis services

Windows

DELETE statement returns Foreign Key check constraint error even when REFERENCE table has no matching rows.

Msg 547, Level 16, State 0, Line LineNumber

The DELETE statement conflicted with the REFERENCE constraint "ConstraintName".

The conflict occurred in database "DatabaseName", table "TableName", column 'ColumnName'.

The statement has been terminated.

SQL performance

Windows

Fixes long duration for Integration Services Project deployment through powershell by improving search of operation messages in deployment process.

Integration services

Windows

Fixes an error that occurs when a session cube is created on a database and you try to query from that session cube. The following error is received when you query the session cube: Server: The operation has been cancelled because there is not enough memory available for the application. If using a 32-bit version of the product, consider upgrading to the 64-bit version or increasing the amount of memory available on the machine.

Analysis services

Windows

Column description disappears after exporting/importing models through MDSModelDeploy for an approval required entity in SQL Server 2019.

Data Quality Services (DQS)

Windows

Fixes a performance issue when a query outputs NULL values following a semi join in SQL Server 2019 for a database with UTF8.

SQL performance

Windows

Updates RSetup with the updated FWLINK version 3.5.2.777.

SQL Engine

Windows

Fixes an issue in MDS Filtered results where the user is not returned to page 1 and the page count is not updated until returning to page 1.

Data Quality Services (DQS)

Windows

Updates the Zulu JRE version to zulu11.37.18-sa-jre11.0.6.101.

SQL Engine

Windows

Fixes an issue in Master Data Services 2019 where you cannot input multiline content in text attributes.

Data Quality Services (DQS)

Windows

Under (rare) certain circumstances, memory grant re-calculation can cause an access violation.

SQL performance

Windows

SQL Server 2019 CU 6

 

KB

Description

Fix Area

Platform

Learn More

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

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

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

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

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

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

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

4568448

FIX: Support for REJECT_ROW_LOCATION parameter in CREATE EXTERNAL TABLE in SQL Server 2019 box product

SQL Engine

All

Learn More

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

Learn More

4538581

FIX: Scalar UDF Inlining issues in SQL Server 2019

SQL Engine

All

Learn More

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

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

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

This update fixes a rare race condition in PolyBase query cancellation

SQL Engine

All

4551220

FIX: Assertion error occurs when you run resumable index build statement in SQL Server

SQL performance

All

Learn More

Fixes an access violation error that might occur when auditing commands that require password masking

SQL security

All

Fixes an issue in agent join during deployment due to pod IP address mismatch in SQL Server 2019

SQL BDC

Linux

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

4570355

FIX: Error occurs when you insert data from one replicated BDC data pool table to another in SQL Server 2019

SQL Engine

Linux

Learn More

Adds a new dsqlplan XEvent in PDW to collect dsql plan

SQL Engine

Linux

This update allows PolyBase external tables for Teradata database to map ByteInt data type to TinyInt data type

SQL Engine

Linux

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

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

4570679

FIX: Remote Hadoop bridge fails when using Hadoop connectivity levels other than seven in SQL Server 2019 on Linux

SQL Engine

Linux

Learn More

4577562

FIX: Istio proxy fails as automountServiceAccountToken is set to FALSE in CU5 for SQL Server 2019

SQL BDC

Linux

Learn More

Excel MDX queries running against an SSAS Tabular instance may return incorrect result when you convert PivotTable Filters to formulas.

Analysis Services

Windows

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

Corrects a regression to allow Recursive Hierarchies to display child items correctly.

Data Quality Services (DQS)

Windows

4538849

FIX: Transaction commit delay time is higher under low usage workloads in SQL Server 2017 and 2019

High Availability

Windows

Learn More

4551221

FIX: Error occurs when you try to create a differential backup on secondary replica in SQL Server

High Availability

Windows

Learn More

4570571

FIX: Query slowness occurs when CPU-intensive SQL Server system tasks run in SQL Server 2019

High Availability

Windows

Learn More

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

4547890

FIX: ISDBUpgradeWizard.exe throws error when you try to upgrade SSISDB after restoring from earlier versions in SQL Server 2019

Integration Services

Windows

Learn More

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

4563597

FIX: Assertion dump occurs when Implicit Transactions are enabled in SQL Server 2016, 2017, and 2019

SQL Engine

Windows

Learn More

4570433

FIX: "Culture is not supported" error occurs when you execute PolyBase query in SQL Server 2019

SQL Engine

Windows

Learn More

This improvement can force the Query Store option to be turned off by specifying the additional option FORCED in the ALTER DB command. FORCED option allows you to turn off Query Store immediately by aborting all background tasks.  ALTER DATABASE {0} SET QUERY_STORE = OFF (FORCED)

SQL Engine

Windows

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

Learn More

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

Updates the Zulu JRE version to zulu11.37.18-sa-jre11.0.6.101

SQL Engine

Windows

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

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

Windows

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

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

SQL Server 2019 CU 5

 

KB

Description

Fix Area

Platform

Learn More

SQL Server may block renaming a database when the database consists of one or more external data pool tables. If you attempt to rename the database in the scenario, you may get the following error:

Alter database name is not supported in Big Data Cluster if the database contains external data pool tables. Drop the external data pool tables to perform the operation.

SQL BDC

All

4538581

FIX: Scalar UDF Inlining issues in SQL Server 2019

SQL Engine

All

Learn More

4555232

FIX: Blocking may occur when Reduce Recompilations feature is enabled by default in SQL Server 2019

SQL Engine

All

Learn More

4561915

Improvement: MAXTRANSFERSIZE no longer required to enable backup compression on TDE encrypted databases

SQL Engine

All

Learn More

You can retrieve the SQL Server Big Data Cluster controller endpoint by querying the new property SELECT SERVERPROPERTY ('ControllerEndpoint').

SQL Engine

All

When shrinking a database, you may receive a database consistency error if the shrinking process encounters an IAM page that is the first and only IAM page. The symptoms may include assertions errors involving heapdataset. Confirm that you do not have any inconsistencies by executing DBCC CHECKDB after shrink operations. Applying this update will prevent future occurrence of this issue and not clean up past inconsistencies.

SQL Engine

All

When PolyBase queries are cancelled shortly after being scheduled, the cancellation may timeout after one hour (and fail to cancel the execution) and generate a dump of Data Movement service.

SQL Engine

All

When 32 or more PolyBase queries are scheduled concurrently, deadlock may occur and current and subsequent PolyBase queries may stall and may not be cancellable.

SQL Engine

All

When inserting into PolyBase external tables from SQL Server head data or tables, query may fail (instead of waiting for resources) if 32 PolyBase queries are currently running.

SQL Engine

All

Access violation exception occurs when querying sys.dm_cluster_endpoints in SQL Server 2019 on Big Data Cluster

SQL Engine

All

When using INSERT INTO … VALUES (…) or INSERT INTO SELECT… statement to populate Data Pool external table and if user specifies the target table columns, the list of target table column names must have the same order as the source table columns and must be the full list. Starting this cumulative update, you will get detailed new errors outlining these conditions:

"Source column count must match the # of columns in the destination table"

"Order of source columns must match the order of columns in the destination table"

SQL Engine

All

Encrypt keyword is missing from externalaccessconfig in SQL Server 2019

SQL Engine

All

When you deploy SQL Server Big Data Clusters in Active Directory mode, SQL Server uses domain DNS name to create user in sql server. When the DNS name and realm name are different, failures may occur. After installing this update, SQL Server will use realm name to create user in sql server.

SQL Engine

All

When you use Accelerated Database Recovery feature on a database in SQL Server 2019, which is part of an Availability Group or Transactional Replication, an assertion error occurs.

(Location: recovery.cpp:LineNumber,

Expression: (!!lp->IsFlagOn (LogRec::LOG_TO_SLOG)) == recXdes->DoesXactSupportCTR () || lp->GetOpCode () == LOP_CTR_NEST_ABORT)

SQL Engine

All

SQL Agent jobs that require access to credentials stored in master database may not be executed when you use Always On availability group in SQL Big Data Cluster.

SQL BDC

Linux

4556244

FIX: Credential update frequency option is added to mssql-conf option in SQL Server 2019 on Linux

SQL Engine

Linux

Learn More

4563007

FIX: VDI backup fails with error after applying SQL Server 2019 CU2/CU3/CU4

SQL Engine

Linux

Learn More

4561725

Improvement: Enables custom event configuration for XEVENT Session EngineService in SQL Server 2019

SQL Engine

Linux

Learn More

If trace flag 6424 is enabled, this fix will dump PolyBase processes if SQL Server dumps.

SQL Engine

Linux

For SQL Server 2019 on Linux or Big Data Cluster configured to use AD auth, you may notice a reduction in size of core dumps generated after installing the update.

SQL Engine

Linux

When you attempt to enable Log Shipping feature in SQL Server on Linux, you may receive an error message that resembles the following:

Msg 32018, Level 16, State 3, Server mssql02, Procedure master.dbo.sp_add_log_shipping_secondary_primary, Line LineNumber

Log shipping is not installed on this instance.

RegQueryValueEx() returned error 2, 'The system cannot find the file specified.'

SQL Engine

Linux

Enable SQL Server Big Data Clusters Active Directory (AD) deployments when domain controllers are not acting as DNS servers.

SQL Engine

Linux

Deployment gets blocked when domain DNS name and realm name are different in SQL Server 2019 BDC

SQL Engine

Linux

Memory may be increased and not be released when a SQL Server outbound connect like Linked Servers fails. This may happen because a socket structure is not deallocated properly

SQL Engine

Linux

AD access to SQL Server 2019 BDC endpoints fails when domain DNS name and endpoint DNS names do not match

SQL Engine

Linux

4539023

FIX: Analysis Services Execute DDL task may fail to impersonate the user context to the remote Analysis services instance in SQL Server 2017 and 2019

Analysis Services

Windows

Learn More

This will fix a functional results issue with the usage of NOT IN operator in DAX when OPTIMIZEDNOTINOPERATOR optimization is enabled.

Analysis Services

Windows

This will fix the functional issues with initial performance fix for dense measures evaluation in SuperDAXMD mode

Analysis Services

Windows

This will fix performance problems in PBI and Multidimensional models user scenario

Analysis Services

Windows

This improves MDX query execution performance against a dimension user hierarchy which is a ragged hierarchy (HideMemberIf property set ) and has deep hierarchy level in SSAS Multidimensional instance.

Analysis Services

Windows

When you try to build relationship on a model that contains many measures with USERELATIONSHIP function, this fix can improve the processing performance and also reduce the time of "sequence point algorithm" step.

Analysis Services

Windows

In explore page, you may not be able to revert the changes in changeset.

Data Quality Services (DQS)

Windows

"Show More Members" functionality for Explicit Hierarchies do not show more than 50 members in Master Data Services (MDS) 2019.

Data Quality Services (DQS)

Windows

4560051

FIX: SQL Server may still read data from secondary replica when ALLOW_CONNECTIONS is set to NO

High Availability

Windows

Learn More

4562173

FIX: Availability Group failover generates lot of dumps as DTC support is toggled between PER_DB and NONE multiple times

High Availability

Windows

Learn More

Fix the issue that when using ODBC components in Foreach Loop component, the ODBC component will meet "Function sequence error" in the second loop during package execution.

Integration Services

Windows

4556233

FIX: Setup is unable to extract product update when it is executed as LOCAL SYSTEM with UPDATE SOURCE option specified in SQL Server 2019

Setup & Install

Windows

Learn More

4540896

FIX: Access violation may occur when enumerating files in a FileTable in SQL Server

SQL Engine

Windows

Learn More

4552478

FIX: Distribution Agent "Parameterized values for above command" log message missing after SQL Server 2017 and 2019 upgrade

SQL Engine

Windows

Learn More

4562618

FIX: Changes to firewall rules created when you install PolyBase in scale-out group configuration in SQL Server 2019

SQL Engine

Windows

Learn More

4563044

FIX: Allow external resource pool to use more than one processor group in SQL Server 2019 on Windows

SQL Engine

Windows

Learn More

4563195

FIX: sp_execute_external_script may fail to run R scripts that use the RxLocalParallel compute context or the doParallel R package in SQL Server 2019

SQL Engine

Windows

Learn More

4563348

After upgrading SQL Server 2017 Distributor to SQL Server 2019, transactional push replication fails when subscriber is using non-default port

SQL Engine

Windows

Learn More

4564868

FIX: Assertion exception occurs when you query the DMV sys.dm_db_file_space_usage in SQL Server 2019

SQL Engine

Windows

Learn More

4564876

FIX: Unable to reconfigure Database mirroring when ADR is enabled and disabled in SQL Server 2019

SQL Engine

Windows

Learn More

When FIPS is enabled on the server (using MSKB article 811833), you may not be able to use Managed Backup on a SQL Server 2019 instance and you may encounter the following error:

Msg 45207, Level 17, State 17, Line 102

The operation failed because of an internal error. Exception has been thrown by the target of an invocation. Please retry later.

SQL Engine

Windows

Msg 3628 (The Database Engine may receive a floating point exception from the operating system while processing a user request) may occur during a clustered columnstore index rebuild.

SQL Engine

Windows

When a Windows principal that is not mapped to a specific database user accesses a database by using membership in a windows group or AAD group, a user id of 0 may be assigned to the user. When the user tries to use libraries that are installed by other dbo/sysadmin user, the user may not see any external libraries. After applying this update, a user id of 0 would have access to external libraries installed by the dbo (libraries in public scope). Since there is no database user that is mapped to the Windows principal, the user with user id 0 cannot create or install external libraries.

SQL Engine

Windows

You can access configurations that ship with PolyBase when specifying a DSN in the CONNECTION_OPTIONS of a Generic ODBC External Data Source definition. The options are picked up by matching the driver name used in the DSN definition. This currently applies to the following drivers:

• IBM DB2 ODBC DRIVER

• HDBODBC

• Microsoft Spark ODBC Driver

SQL Engine

Windows

sys.key_constraints reports two rows for an index if the XML component id is same as the "object_id" of a primary key

SQL Engine

Windows

Spatial data types (Geometry and Geography) are implemented as CLR data types in SQL Server. When the application domain hosting the spatial data type structures is unloaded, the engine treats this as a schema change to the underlying objects referenced in the cursor. As a result, spatial query may fail with related error message when the schema change is detected.

SQL Engine

Windows

Access violation may occur when a cursor is used to retrieve data from scalar UDF and the underlying table contains primary key.

SQL Engine

Windows

When you have external tables on a database in SQL Server 2019 and try to publish different tables from the same database, you may receive the following error message in SSMS:

New Publication Wizard encountered one or more errors while retrieving the list of articles on 'database name'. The list of articles may not be complete.

Additional Information: Data is Null. This method or property cannot be called on Null values.

SQL Engine

Windows

Disables PolyBase Generic ODBC External Data Sources' default behavior of pushing down the TOP operator and calling the SQLRowCount function

SQL Engine

Windows

Enables the following keys to be specified in the CONNECTION_OPTIONS of a PolyBase Generic ODBC External Data Source:

PolyBaseOdbcSupportsRowCount, PolyBaseOdbcSupportsMetadataIdAttributes, PolyBaseOdbcSupportsBindOffset, PolyBaseQoTopPushdownSyntax

SQL Engine

Windows

Script "system_xevents_modification.sql" downgraded failed with error 935 which causes master database not able to recover with error 3417 and then SQL Server is unable to start

SQL Engine

Windows

When you use DELETE statement on a table in SQL Server, you may receive the following error message as no matching rows exists in the referenced tables.

Msg 547, Level 16, State 0, Line LineNumber

The DELETE statement conflicted with the REFERENCE constraint "constraint name".

The conflict occurred in database "database name", table "table name", column 'column name'.

The statement has been terminated.

SQL performance

Windows

Access violation occurs when a query is executed against a filtered index in SQL Server 201

SQL performance

Windows

SQL Server 2019 CU 4

 

KB

Description

Fix Area

Platform

Learn More

Adds new SERVERPROPERTY "IsBigDataCluster" to retrieve a boolean value that describes whether the instance is BDC or not.

Big Data Cluster (BDC)

All

4538581

FIX: Scalar UDF Inlining issues in SQL Server 2019

SQL Engine

All

Learn More

4552159

FIX: Error occurs when you apply a security policy on PolyBase external table in SQL Server 2019

SQL Engine

All

Learn More

4552205

FIX: Error occurs when you try to create external table in PolyBase with database_default as collation in SQL Server 2019

SQL Engine

All

Learn More

4538688

FIX: Severe spinlock contention occurs in SQL Server 2019

SQL Engine

All

Learn More

Access violation error occurs when you cancel queries against Big Data Cluster (BDC) storage pool or any OPENROWSET query on an instance of SQL Server 2019.

SQL Engine

All

4538268

FIX: "Expired BLOB handle" error occurs when cross-database transaction involves communication with MSDTC in SQL Server 2017 and 2019

SQL performance

All

Learn More

4541096

FIX: Access Violation occurs when you run query on computed columns in SQL Server

SQL performance

All

Learn More

4543027

FIX: Parallel sampled filtered statistics may cause incorrect histogram scaling in SQL Server 2016 and 2019

SQL performance

All

Learn More

Starting from Cumulative Update 4 (CU4) for SQL Server 2019, when auditing DMVs and DBCC commands to get query optimization statistics and if sensitive data is revealed,  the 'data_sensitivity_information' column of the audit record will be populated.

SQL security

All

Improved error message is returned when you try to link the base and history tables on which data classification is already defined.

SQL security

All

4532432

Mssql-conf tool fails if IPV6 is disabled on the Linux system

SQL Engine

Linux

Learn More

Assume that the Format String Expression property of a Calculation Item from a Calculation Group is set. The performance degradation occurs when you run MDX queries generated by MDX based client tools and may also occur when MDX queries do not refer to the calculation item with Format String Expression set. However, the performance degradation is not so evident on equivalent DAX queries generated by Power BI Desktop visuals

Analysis Services

Windows

4541300

FIX: Fix incorrect values in auto seeding XEvents in SQL Server

High Availability

Windows

Learn More

4541303

FIX: Non-yielding Scheduler error may occur with Always On availability group in Microsoft SQL Server

High Availability

Windows

Learn More

4541309

FIX: Missing log block may occur when you use Always On availability group in SQL Server

High Availability

Windows

Learn More

4541724

FIX: Intermittent non-yielding scheduler occurs when memory-optimized database running under heavy I/O activities in SQL Server 2016 and 2019

In-Memory OLTP

Windows

Learn More

In the Service Accounts interface of SQL Server Setup, password validation may fail if only username is entered before the correct password is entered. This failed validation may lock out the domain service account if you do this repeatedly and domain policy set to lock accounts after few unsuccessful attempts.

Setup & Install

Windows

4538365

FIX: Change Tracking cleanup does not work when invalid cleanup and hardened cleanup version are negative in SQL Server 2017 and 2019

SQL Engine

Windows

Learn More

4539815

FIX: Access violation occurs when change tracking auto cleanup tries to clean up side tables in SQL Server

SQL Engine

Windows

Learn More

4540107

FIX: System or background task may fail when number of sessions reaches the maximum limit in SQL Server 2016 and 2019

SQL Engine

Windows

Learn More

4540121

FIX: sp_execute_external_script doesn't run when you install SQL Server 2019 with Machine Learning Services and a customized Shared feature directory

SQL Engine

Windows

Learn More

4540342

FIX: Non-yielding scheduler condition occurs with CONNECTION_MANAGER spinlock in SQL Server

SQL Engine

Windows

Learn More

4540903

FIX: Non-yielding scheduler dump occurs in InterlockedCompareExchangePointer and SOS_RWLock in SQL Server 2016 and 2019

SQL Engine

Windows

Learn More

4541435

FIX: Error occurs when you rename a column on temporal current table in SQL Server

SQL Engine

Windows

Learn More

4541520

FIX: Assertion occurs when you process a malformed XML message sent as message in Service Broker queue in SQL Server

SQL Engine

Windows

Learn More

4541762

FIX: Management Data Warehouse Server Activity Collection Set may fail in SQL Server 2016 and 2019

SQL Engine

Windows

Learn More

4541770

FIX: Assertion failure occurs when persistent log buffer is used in SQL Server 2016 and 2019

SQL Engine

Windows

Learn More

4548103

FIX: Performance degradation occurs on PMEM devices with Hybrid Buffer Pool enabled in SQL Server 2019

SQL Engine

Windows

Learn More

When an application performs bulk copy operations and a subsequent select in the same transaction against a database with simple or bulk-logged recovery model, SQL Server Access Violations may occur and repeat until the service is restarted.

SQL Engine

Windows

SQL Writer will add its version and log tracing parameters to the log header when the service starts.

SQL Engine

Windows

Improves SQL Writer for better handling of COPY_ONLY backup messages in SQL Server 2019.

SQL Engine

Windows

4538497

FIX: Slow query performance when using query predicates with UPPER, LOWER or RTRIM with default CE in SQL Server 2017 and 2019

SQL Engine

Windows

Learn More

4539880

FIX: Access violation occurs with wait_info XEvent on busy SQL Server

SQL performance

Windows

Learn More

4540346

FIX: MERGE statement fails with assert “Attempt to access expired blob handle (1)” in SQL Server 2016 and 2019

SQL performance

Windows

Learn More

4540901

FIX: SQL Server may terminate due to lock conflicts during error message processing in SQL Server 2016 and 2019

SQL security

Windows

Learn More

SQL Server 2019 CU 3

 

KB

Description

Fix Area

Platform

Learn More

SQL Server error log contains additional empty lines while printing In-memory OLTP related messages.

In-memory OLTP

All

4538118

Improvement: Enable hybrid buffer pool read caching in SQL Server 2019

SQL Engine

All

Learn More

4541132

Improvement: Size and retention policy are increased in default XEvent trace system_health in SQL Server 2019 and 2016

SQL Engine

All

Learn More

Enable SQL checksum sniffer for Pmm pages in hybrid buffer pool.

SQL Engine

All

Due to a new feature called concurrent PFS update in SQL Server 2019 which is enabled by default, in certain rare corner cases, you may encounter non-yielding threads and latch timeout errors in SQL Server.

SQL Engine

All

Updates the Zulu JRE version to zulu11.37.18-sa-jre11.0.6.

SQL Engine

All

When you run a query against sys.dm_db_stats_histogram, it may fail with access violation when a parallel plan is chosen.

SQL performance

All

4538686

Improvement: Add new Protection key feature work for SQL Server 2019 on Linux

SQL Engine

Linux

Learn More

4548131

FIX: Fail to access openmpi path when running rx jobs in parallel mode with Revo package in Linux SQL Server 2019

SQL Engine

Linux

Learn More

4548133

FIX: Data length/size of Unicode nvarchar data type column is not correct for OutputDataSet in sp_execute_external_script query in SQL Server 2019 on Linux

SQL Engine

Linux

Learn More

This update reduces query execution time for BDC storage pool tables and other Polybase external tables.

SQL Engine

Linux

Updates to SQL Server on Linux (mssql mlservices and extensibility) packages to address following issues:

1. BxlServer consumes 100% CPU

2. Python launcher encounters assert when deleting files

3. Data length mismatch when using Unicode string with OutputDataSet and InputDataSet of data passthrough query.

SQL Engine

Linux

4550657

FIX: Error occurs when you interact with SQL Server Agent in SQL Server 2019

High Availability

Windows

Learn More

4547890

FIX: ISDBUpgradeWizard.exe throws error when you try to upgrade SSISDB after restoring from earlier versions in SQL Server 2019

Integration Services

Windows

Learn More

Allow DTSWizard to support AAD when the selected driver is MSOLEDBSQL.

Integration Services

Windows

4529927

FIX: .NET Framework DbDataAdapter.FillSchema method returns NULL on database with compatibility level 140 in SQL Server 2019 and 2017

SQL Engine

Windows

Learn More

4539172

FIX: Launchpad services fails to start during failover in SQL Server 2019

SQL Engine

Windows

Learn More

4540121

FIX: sp_execute_external_script doesn't run when you install SQL Server 2019 with Machine Learning Services and a customized Shared feature directory

SQL Engine

Windows

Learn More

4548523

FIX: Database creation to Azure blob storage from SQL Server 2019 on Linux may fail with error

SQL Engine

Windows

Learn More

Updates RSetup with the updated FWLINK version 3.5.2.293

SQL Engine

Windows

"The JSON DDL request is missing the database name" error occurs when you delete the database property from the descriptive table under the JSON code in SQL Server 2019

SQL Engine

Wndows

When you repeatedly run a stored procedure that uses temporary table with indexes on SQL Server 2019, the client may receive an unexpected error with message "A severe error occurred on the current command" and an access violation exception is recorded on the SQL Server. If the same workload is executed on any previous major version of SQL Server, this issue does not occur.

SQL performance

Wndows

When you run a SELECT query returning empty/multiple rows with variable assignment in inline-able scalar UDFs, you may receive wrong results

SQL performance

Wndows

SQL Server 2019 CU 2

 

KB

Description

Fix Area

Platform

Learn More

4540449

FIX: Error occurs in sp_xml_preparedocument where MSXMLSQL tries to access virtual address space beyond limit in SQL Server 2017 and 2019

SQL Engine

All

Learn More

4540372

FIX: XML PATH queries in PolyBase fail with an error in SQL Server 2019

SQL Engine

Windows

Learn More

4540371

FIX: Query on Clustered Columnstore Index in SQL Server 2019 uses more CPU time than in SQL Server 2016

SQL Engine

Windows

Learn More

4540343

FIX: Contained AG master database dependency creates deadlock during replica restart at certain condition in SQL Server 2019

High Availability

All

Learn More

4539340

FIX: Include support for Excel ODBC driver and Text ODBC driver from Microsoft Access Database Engine Redistributable package in PolyBase for SQL Server 2019

SQL Engine

All

Learn More

4539203

FIX: Error occurs when you use PolyBase Generic ODBC connector with backend that has unsupported quote character in SQL Server 2019

SQL Engine

Windows

Learn More

4539201

FIX: XML queries in PolyBase fail with an unknown type error in SQL Server 2019

SQL Engine

Windows

Learn More

4539200

FIX: Internal DMS error when you use PolyBase Generic ODBC connector in SQL Server 2019

SQL Engine

All

Learn More

4539199

FIX: PolyBase defaults string mapping for Microsoft Spark ODBC driver in SQL Server 2019

SQL Engine

All

Learn More

4539198

FIX: Map large fixed width types to variable width types in PolyBase in SQL Server 2019

SQL Engine

All

Learn More

4539197

FIX: Null pointer exception error occurs when "latch_suspend_end" XEvent is enabled in SQL Server 2019

SQL Engine

All

Learn More

4539000

FIX: SSMS showplan error occurs for BDC query in SQL Server 2019

SQL Engine

All

Learn More

4538978

Improvement: Add BDC storage pool cache in SQL Server 2019

SQL Engine

All

Learn More

4538968

FIX: PolyBase query execution time may increase exponentially when you run concurrent queries in SQL Server 2019

SQL Engine

All

Learn More

4538858

FIX: Dumps occur because of OOM condition in SQL Server 2019

SQL Engine

All

Learn More

4538759

Improvement: Module and offset information is sent as output for dumps in SQL Server 2019

SQL Engine

Linux

Learn More

4538689

Improvement: Add BDC data/storage pool nodes DMVs in SQL Server 2019

SQL Engine

Linux

Learn More

4538688

FIX: Severe spinlock contention occurs in SQL Server 2019

SQL Engine

All

Learn More

4538685

FIX: SQL Server 2019 Express SLT incorrectly states that Express is not allowed for production use

SQL Engine

Windows

Learn More

4538661

FIX: New sandbox is created unexpectedly when sandbox cleanup fails and child process is still alive

SQL Engine

Linux

Learn More

4538595

Improvement: New features included in library management for external languages in SQL Server 2019

SQL Engine

All

Learn More

4538581

FIX: Scalar UDF Inlining issues in SQL Server 2019

SQL Engine

All

Learn More

4538575

FIX: Login and logout failures occur while auditing data classification attributes in SQL Server 2019

SQL security

All

Learn More

4538573

FIX: Changes made using ALTER DATABASE...SQL Server 2019 fails to log changes in SQL Error log or raise database trigger

SQL Engine

All

Learn More

4538515

FIX: Concurrent PFS update in SQL Server 2019 may cause corruption of ADR

SQL Engine

All

Learn More

4538496

FIX: Unable to encrypt data when using column encryption with symmetric keys in SQL Server 2019

SQL security

Windows

Learn More

4538495

FIX: Access violation occurs when you create remote stored procedure with one of the system variable (@@servername, @@servicename) in SQL Server 2019

SQL Engine

Windows

Learn More

4538493

Improvement: Restore database and add database to the AG in SQL Server 2019

High Availability

All

Learn More

4538481

FIX: Exception occurs when you run UNION ALL+ORDER BY/MERGE UNION ALL queries on table that contains randomized encrypted data in SQL Server 2019

SQL security

All

Learn More

4538382

Implement support for Kerberos constrained delegation in SQL Server 2019 on Linux

SQL Engine

Linux

Learn More

4538378

FIX: The "is_media_read_only" value remains unchanged for a SQL Server data file even though the media is no longer read-only

SQL Engine

Windows

Learn More

4538377

FIX: Non-yielding scheduler condition occurs when you run batch mode query with multiple joins in SQL Server 2017 and 2019

SQL performance

All

Learn More

4538344

FIX: Passwords are masked in audit logs in SQL Server 2019

SQL security

All

Learn More

4538342

FIX: Latest drivers fail to work with in-memory compiled queries in SQL Server 2019

SQL security

All

Learn More

4538205

Improvement: Download new CAB files that have fixes for R/Python runtime features

SQL Engine

Windows

Learn More

4538174

FIX: Error occurs and AG will be in non-synchronizing state when failover happens in primary AG of Distributed Availability Group in SQL Server 2017 on Linux

High Availability

All

Learn More

4538164

FIX: Error occurs when you run the same PolyBase query multiple times in SQL Server 2019

SQL Engine

All

Learn More

4538163

FIX: PolyBase may fail to generate dumps if an error occurs during the distributed query optimization phase in SQL Server 2019

SQL Engine

All

Learn More

4538162

FIX: Unable to start PolyBase services when TCP/IP is not enabled in SQL Server 2019 Developer Edition

SQL Engine

Windows

Learn More

4538161

FIX: Error occurs when you run queries in PolyBase scale-out groups in SQL Server 2019

SQL Engine

Windows

Learn More

4538160

Improvement: Correct the floating point data type in SQL Server 2019

SQL Engine

Linux

Learn More

4538112

Improvement: Use QUOTENAME with EXECUTE AT to query on table that has column name with quotes in SQL Server 2019

SQL Engine

All

Learn More

4538036

FIX: Error occurs when you query storage pool external table that contains column with money data type in SQL Server 2019 BDC

SQL Engine

Linux

Learn More

4538017

FIX: Severe contention on LOGCACHE_ACCESS spinlock in SQL Server 2019

SQL Engine

All

Learn More

4537869

FIX: Log shipping agent is not able to log history and error information to SQL Server 2019

High Availability

Windows

Learn More

4537868

Improvement: Enable DNN feature in SQL Server 2019 FCI

SQL connectivity

Windows

Learn More

4537751

FIX: Error due to explicit transaction isolation level hint when accessing Memory-Optimized Tempdb catalog views in SQL Server 2019

SQL Engine

Windows

Learn More

4537749

Improvement: Port additional two system tables in Tempdb Memory-Optimized Metatdata feature in SQL Server 2019

SQL Engine

All

Learn More

4537710

FIX: SOS_BLOCKALLOCPARTIALLIST spin lock contention may occur when TF 834 is enabled in SQL Server 2019

SQL Engine

All

Learn More

4537637

FIX: Master database takes primary database offline for 1.5 hours which causes the GiantDB to be in unhealthy state in SQL Server 2019

High Availability

All

Learn More

4537452

FIX: Logreader doesn't execute when you upgrade from SQL Server 2017 to 2019

SQL Engine

Windows

Learn More

4537350

FIX: Access violation occurs when you run DBCC CHECKTABLE against a table with Clustered Columnstore Index in SQL Server 2017 and 2019

SQL Engine

Windows

Learn More

4537347

FIX: Error 544 occurs when you use SET IDENTITY_INSERT on temp table in SQL Server 2019

SQL Engine

All

Learn More

4537300

FIX: Change the NuGet that's used for Polaris in SQL Server 2019

SQL Engine

Linux

Learn More

4537072

FIX: Creating an external table against an Oracle database in SQL Server 2019 may fail if using Oracle database 12.2 or later versions

SQL Engine

All

Learn More

4536841

FIX: Error occurs while creating External Data Source for Data Pool that has nondefault name for LOCATION in SQL Server 2019

SQL Engine

All

Learn More

4536684

FIX: Error occurs when QDS is turned on or you generate query plan for Polybase queries in SQL Server 2019

SQL Engine

All

Learn More

4536005

Improvement: Fix incorrect memory page accounting that causes out-of-memory errors in SQL Server 2019

SQL Engine

All

Learn More

4534249

FIX: Unable to execute sys.dm_exec_requests when you install SQL Server 2019 or when you upgrade from prior versions of SQL Server

High Availability

All

Learn More

4534148

FIX: PolyBase query may hang if you cancel the query after it is started in SQL Server 2019

SQL Engine

All

Learn More

4533497

FIX: External satellite process scripts like R, Python are unable to access any directories outside of their working directory in SQL Server 2019

SQL Engine

All

Learn More

4531736

FIX: SQLDiag fails to generate output due to missing stored procedure tempdb.dbo.sp_sqldiag14 in SQL Server 2017 and 2019

Management Tools

Windows

Learn More

4531702

FIX: Assertion occurs when TF 831 is turned ON/OFF multiple times in SQL Server 2019

SQL Engine

All

Learn More

4531384

FIX: Queries may fail in SQL Server 2019 when PolyBase is under stress and heavy cancellations

SQL Engine

All

Learn More

4531232

FIX: PolyBase Engine Service may dump if an error occurs during retrieval of Data Pool metadata in SQL Server 2019

SQL Engine

Linux

Learn More

4531010

FIX: CREATE INDEX with new CE reads the partition table and results in huge row count higher than the total table row count in SQL Server

SQL performance

Windows

Learn More

4530443

FIX: Non-yielding scheduler issue occurs in SQL Server when you run an online build for an index that's not partition-aligned

SQL performance

Windows

Learn More

4530259

FIX: Scripts generated by SSMS collect different wait types after you install SQL Server

SQL Engine

Windows

Learn More

4530251

FIX: Error 8601 occurs when you run a query with partition function in SQL Server

SQL performance

Windows

Learn More

4530212

FIX: Access violation occurs when you use sys.dm_os_memory_objects in SQL Server

SQL performance

Linux

Learn More

4529833

FIX: sp_describe_parameter_encryption returns different results if you switch parameter positions in SQL Server 2017 and 2019

SQL security

Windows

Learn More

4528250

FIX: Assertion error occurs when you use IDENT_CURRENT on view that has identity columns in SQL Server

In-Memory OLTP

Windows

Learn More

4528067

FIX: Error 8959 may occur on IAM page when you query sys.dm_db_index_physical_stats against partitioned columnstore table after partition switch in SQL Server

SQL performance

Windows

Learn More

4528066

FIX: Unable to restore SQL Server 2012 databases on SQL Server 2016, 2017 or 2019 because of NCCI

SQL Engine

Windows

Learn More

4527916

FIX: You may receive incorrect object_id after you switch a partition in SQL Server 2017 and 2019

SQL Engine

Windows

Learn More

4527716

FIX: You may encounter a non-yielding scheduler condition when you run query with parallel batch-mode sort operator in SQL Server

SQL performance

Windows

Learn More

4527355

FIX: Synchronized job may fail when the target servers start to synchronize the database in SQL Server 2016 and 2017

SQL Engine

Windows

Learn More

4527229

FIX: UPDATE STATISTICS takes very long time to generate maintenance plan for large databases in SQL Server

SQL Engine

Windows

Learn More

4525483

FIX: Exception error 3628 may occur when you run stored procedure in SQL Server

SQL Engine

Windows

Learn More

4524542

FIX: MDS and/or LocalDB patch installation fails if you patch SQL Server with a next CU

Setup & Install

Windows

Learn More

4523102

FIX: SQL Server database remains in frozen I/O state indefinitely when backed up by VSS

SQL Engine

Windows

Learn More

SQL Server 2019 CU 1

KB

Description

Cumulative Update

Fix area

Platform

Learn More

4536077

FIX: Dump is generated when you create an AG with more than 122 characters in SQL Server 2019

SQL Server 2019 CU1

High Availability

All

Learn More

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

SQL Server 2019 CU1

High Availability

All

Learn More

4531349

FIX: DMVs fail when Big Data Cluster has multiple compute nodes in SQL Server 2019

SQL Server 2019 CU1

SQL Engine

Linux

Learn More

4531238

FIX: Heap corruption occurs when ADR is disabled and aborted transactions are present in SQL Server 2019 database

SQL Server 2019 CU1

SQL Engine

All

Learn More

4531226

FIX: Error occurs when you select from storage pool table and insert into another external table in SQL Server 2019

SQL Server 2019 CU1

SQL Engine

Linux

Learn More

4531225

FIX: PolyBase query may hang when DMS restarts in SQL Server 2019

SQL Server 2019 CU1

SQL Engine

All

Learn More

4531224

FIX: Spurious lines may be added to the SQL Server error log at each initialization in SQL Server 2019

SQL Server 2019 CU1

SQL Engine

All

Learn More

4531125

Improvement: Update the hktempdb.dll version in SQL Server 2019

SQL Server 2019 CU1

SQL Engine

All

Learn More

4531049

FIX: Access violation occurs when you set database containment to NONE in SQL Server 2019

SQL Server 2019 CU1

SQL Engine

All

Learn More

4531029

FIX: Query may fail when you join a storage pool table with a data pool table in SQL Server 2019

SQL Server 2019 CU1

SQL Engine

All

Learn More

4531026

FIX: NullPointerException occurs when the name node is not active and the HTTP request has other failures in SQL Server 2019

SQL Server 2019 CU1

SQL Engine

Linux

Learn More

4531025

Improvement: Update PolyBase vbump to 150.1812.0 in SQL Server 2019

SQL Server 2019 CU1

SQL Engine

Linux

Learn More

4530907

Improvement: Corrupt statistics can be detected by using extended_logical_checks in SQL Server 2019

SQL Server 2019 CU1

SQL Engine

All

Learn More

4530827

FIX: Two issues with remote Hadoop bridge process in SQL Server 2019

SQL Server 2019 CU1

SQL Engine

Linux

Learn More

4530814

Improvement: Add support to create index on encrypted unique identifier using Always Encrypted feature in SQL Server 2019

SQL Server 2019 CU1

SQL security

Windows

Learn More

4530769

FIX: FSM may be called when you create a database in SQL Server 2019 Big Data Clusters

SQL Server 2019 CU1

SQL Engine

All

Learn More

4530720

FIX: "The File location cannot be opened" error occurs when you try to open a FileTable directory in SQL Server

SQL Server 2019 CU1

SQL Engine

Windows

Learn More

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 Server 2019 CU1

SQL Engine

Windows

Learn More

4530499

FIX: Non-yielding scheduler error when Polybase function call to shared memory takes long time in SQL Server 2019

SQL Server 2019 CU1

SQL Engine

All

Learn More

4530496

FIX: Data pool database may be deleted if you fail to drop database on master in SQL Server 2019

SQL Server 2019 CU1

SQL Engine

All

Learn More

4530468

FIX: PolyBase Hadoop queries may fail when the launchpadd service is restarted or killed in SQL Server 2019

SQL Server 2019 CU1

SQL Engine

Linux

Learn More

4530427

FIX: sp_describe_parameter_encryption returns different results with different parameter positions in SQL Server 2019

SQL Server 2019 CU1

SQL security

Windows

Learn More

4530303

FIX: Data masking of user-defined functions may result in crashes in SQL Server 2019

SQL Server 2019 CU1

SQL security

All

Learn More

4530302

Improvement: Add unlimited buffer size to support TDS V1 and V2 in SQL Server 2019

SQL Server 2019 CU1

SQL security

All

Learn More

4530287

Improvement: Dynamic Management View is added for external authentication in SQL Server 2019

SQL Server 2019 CU1

SQL security

Windows

Learn More

4530286

Improvement: Update SDK to improve security of Always Encrypted by using secure enclaves in SQL Server 2019

SQL Server 2019 CU1

SQL security

Windows

Learn More

4530283

Improvement: Execute Database upgrade scripts when Database state changes in SQL Server 2019

SQL Server 2019 CU1

SQL Engine

Windows

Learn More

4530281

FIX: Typo in error message for Columnstore indexes on temporary tables in SQL Server 2019

SQL Server 2019 CU1

SQL Engine

All

Learn More

4530280

Improvement: Add new fields to latch_suspend_end Extended Event in SQL Server 2019

SQL Server 2019 CU1

SQL Engine

All

Learn More

4530251

FIX: Error 8601 occurs when you run a query with partition function in SQL Server

SQL Server 2019 CU1

SQL performance

Windows

Learn More

4530084

FIX: Error occurs when you try to install SQL Server 2019 on a low power CPU

SQL Server 2019 CU1

SQL security

Windows

Learn More

4530080

Improvement: Update the misspelled words in server_principal_sid and server_principal_name description in SQL Server 2019

SQL Server 2019 CU1

SQL security

Windows

Learn More

4530079

Improvement: Update error messages of Always Encrypted with secure enclaves in SQL Server 2019

SQL Server 2019 CU1

SQL security

Windows

Learn More

4530055

FIX: Access violation occurs when worker stealing is enabled and CPU capacity reaches maximal configured value in SQL Server 2019

SQL Server 2019 CU1

High Availability

All

Learn More

4530054

FIX: Worker stealing stops working when AG contains one or more encrypted databases in SQL Server 2019

SQL Server 2019 CU1

High Availability

All

Learn More

4529944

FIX: Unsigned files are installed through the Microsoft MPI in SQL Server 2019

SQL Server 2019 CU1

SQL Engine

Windows

Learn More

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 Server 2019 CU1

SQL Engine

Windows

Learn More

4529893

FIX: Audit of batch may be skipped when the batch causes a failure that closes the session in SQL Server 2019

SQL Server 2019 CU1

SQL security

All

Learn More

4529848

FIX: PolyBase DMVs may return unexpected results after changing PolyBase enabled setting in SQL Server 2019

SQL Server 2019 CU1

SQL Engine

All

Learn More

4528492

FIX: DTC transaction scenario reports unsupported transaction error when HkTempdb transaction is used in SQL Server 2019

SQL Server 2019 CU1

SQL Engine

All

Learn More

4528491

FIX: Access violation occurs when you call HkError.Throw() in SQL Server 2019

SQL Server 2019 CU1

SQL Engine

All

Learn More

4528490

FIX: Access violation occurs when attempting to fetch the IAM page of the table in SQL Server 2019

SQL Server 2019 CU1

SQL Engine

All

Learn More

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 Server 2019 CU1

SQL performance

All

Learn More

4528168

FIX: Using temporary tables across multiple scopes may cause Error 213 or access violation in SQL Server 2019

SQL Server 2019 CU1

SQL Engine

All

Learn More

4528139

FIX: "Debug Assertion Failed" error if you create objects that are not hashed by name in SQL Server 2019

SQL Server 2019 CU1

SQL Engine

All

Learn More

4528097

FIX: Access violation occurs when you query sys.dm_db_persisted_sku_features DMV in SQL Server 2019

SQL Server 2019 CU1

SQL Engine

All

Learn More

4527538

FIX: "A system assertion check has failed" error when a procedure call is made from CLR with an OUTPUT large object argument

SQL Server 2019 CU1

SQL performance

All

Learn More

4526315

FIX: Database cannot recover and reports error 5243 in SQL Server

SQL Server 2019 CU1

SQL Engine

Windows

Learn More

4522405

FIX: Non-yielding scheduler error occurs when you run batch query with sort operation in SQL Server 2017 and 2019

SQL Server 2019 CU1

SQL performance

All

Learn More

4522002

FIX: SQL Server 2017 and 2019 on Linux fails with an Assertion error

SQL Server 2019 CU1

SQL Engine

Linux

Learn More

4521960

FIX: Access violation occurs when a clone database verification fails in SQL Server 2016, 2017 and 2019

SQL Server 2019 CU1

SQL Engine

Windows

Learn More

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 Server 2019 CU1

SQL Engine

Windows

Learn More

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 Server 2019 CU1

SQL Engine

Windows

Learn More

4521659

FIX: SQL Writer Service fails to back up in non-component backup path in SQL Server 2016, 2017 and 2019

SQL Server 2019 CU1

SQL Engine

Windows

Learn More

4519796

FIX: Stack dump occurs when table type has a user-defined constraint in SQL Server 2016, 2017 and 2019

SQL Server 2019 CU1

SQL Engine

Windows

Learn More

4519668

FIX: Access violation occurs when you enable TF 3924 to clean orphaned DTC transactions in SQL Server 2016, 2017 and 2019

SQL Server 2019 CU1

SQL Engine

Windows

Learn More

4519366

FIX: Incorrect results occur with index intersection on partitioned table with a clustered columnstore index in SQL Server

SQL Server 2019 CU1

SQL performance

All

Learn More

4518364

FIX: Access violation occurs when you run queries that involve PIVOT or UNPIVOT in SQL Server 2016, 2017 and 2019

SQL Server 2019 CU1

SQL Engine

Windows

Learn More

4517771

FIX: Orphaned CLR sessions cause blocking in SQL Server

SQL Server 2019 CU1

SQL Engine

Windows

Learn More

Learn More

4515772

FIX: Transaction log isn't truncated on a single node Availability Group in SQL Server

SQL Server 2019 CU1

High Availability

Windows

Learn More

SQL Server 2017

SQL Server 2017 CU 29

 

KB

Description

Fix area

Platform

Learn More

An error occurs after the failover of a Distributed Availability Group (AG) that attempts to connect to the secondary AG listener with application intent set to READ ONLY. Here are the possible error messages:

Sqlcmd: Error: Microsoft ODBC Driver 11 for SQL Server: Protocol error in TDS stream

Invalid routing information received.

High Availability

Windows

The AlwaysOn_Health extended event doesn't set STARTUP_STATE to ON during the instance starts.

High Availability

Windows

The database recovery process is chosen as the deadlock victim on Availability Group (AG) failover under certain circumstances. The following error message is generated:

    Error: 1205, Severity: 13, State: 51.

    Transaction (Process ID n) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

High Availability

Windows

Improves the response time of the Sqldumpr.exe utility when in-memory objects are used in SQL Server or once existed.

In-Memory OLTP

All

Lets more flexible cleanup and merge operations enable by changing In-Memory during restore operations.

In-Memory OLTP

Windows

5008296

FIX: Missing change data capture cleanup execution isn't identified because of a deadlock without an error message

SQL Engine

Windows

Learn More

5013181

FIX: A subscription is still active after the distribution retention period expires

SQL Engine

Windows

Learn More

5013207

FIX: Python is broken after the runtime upgrades to Python 3.7

SQL Engine

Windows

Learn More

A filtered index becomes corrupt after you drop a computed column on the same table, and the filtered index corruptions are reported as 8951 and 8955 errors when you run DBCC CHECKTABLE WITH EXTENDED_LOGICAL_CHECKS.

SQL Engine

Windows

An access violation occurs when you use FileTables in SQL Server 2017.

SQL Engine

Windows

The query against the dynamic management view (DMV) sys.dm_os_ring_buffers may cause an access violation (AV).

SQL Engine

All

An access violation dump occurs when the query runs for a long time in parallel and tries to determine the version of the rowgroup for the particular transactions to read.

SQL Engine

Windows

Restoring from a compressed backup that contains filestream content occasionally fails when the restore is run by using the Virtual Device Interface (VDI) client. The following error message is generated:

Msg 3241

The media family on device '' is incorrectly formed. SQL Server cannot process this media family.

SQL Engine

Windows

Traversing long IAM chains may cause a non-yielding scheduler and associated dump.

SQL Engine

Windows

The Table Valued Function (TVF) misses calling the execution plan if the same TVF is referenced more than once in the same SQL query.

SQL Performance

Windows

SQL Server 2017 CU 28

 

Description

Fix area

Platform

Fixes an issue where sys.fn_hadr_backup_is_preferred_replica returns different results on secondary replicas of read-scale availability groups (Cluster_Type=None) when running on standalone machines or cluster nodes

High Availability

Windows

Adds improvement to capture sp_server_diagnostics XEvent in an AlwaysOn_health XEvent session when STATE is 3 (ERROR) to diagnose HADR Health Events

SQL Engine

Windows

Fixes an issue in which some of the temporary working folders are not cleared when many R queries are run in parallel

SQL Engine

Windows

Fixes an issue where the default trace on Linux rolls over before the limit size of 20 MB

SQL Engine

Linux

Fixes the following error that occurs when you back up a database by using virtual device interface (VDI) on ubuntu docker container installed SQL Server 2017:

Host_515697bb-6009-4018-b373-50c871ed736c_SQLVDIMemoryName_0: ClientBufferAreaManager::SyncWithGlobalTable: Open(hBufferMemory): error 2Host_515697bb-6009-4018-b373-50c871ed736c_SQLVDIMemoryName_0: TriggerAbort: invoked: error 0Host_515697bb-6009-4018-b373-50c871ed736c_SQLVDIMemoryName_0: TriggerAbort: ChannelSem: error 2Features returned by SQL Server: 0x10000

Opening the device.

VDS::OpenDevice fails: x80770004

Msg 18210, Level 16, State 1, Server , Line

BackupVirtualDeviceSet::AllocateBuffer: failure on backup device '515697bb-6009-4018-b373-50c871ed736c'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).

Msg 3013, Level 16, State 1, Server , Line

BACKUP DATABASE is terminating abnormally.

SQL Engine

Linux

Fixes an issue where SQL Server disconnects a session when it gets an attention and INTERLEAVED_EXECUTION_TVF is enabled

SQL performance

Windows

Fixes an issue where executing concurrent queries with Large Object (LOB) parameters causes failed assertions in tmpilb.cpp and generates minidumps

SQL performance

Windows

Fixes an issue in which the query processor can't produce a query plan if the USE PLAN hint specifies a query plan that has a left outer join and an inner join

SQL performance

Windows

SQL Server 2017 CU 27

 

KB

Description

Fix area

Platform

Learn More

5007158

FIX: Access violation occurs when you use LOB data type with columnstore indexes in SQL Server 2017

SQL Engine

All

Learn More

5007039

FIX: You encounter error messages 8114 or 22122 when performing change tracking cleanup

SQL Engine

Windows

Learn More

5007381

FIX: Sp_execute_external_script fails after you configure new runtime and remove a new Cumulative Update patch in SQL Server 2017

SQL Engine

Windows

Learn More

Prevents ghost cleanup from triggering a memory dump during latch time-out in SQL Server 2019

SQL Engine

Windows

Fixes an issue where Failover Cluster Instance (FCI) setup fails on secondary nodes of a PolyBase scale-out group in a standard edition of SQL Server 2019. Here is the error message:

The specified scaleout setting for Polybase is not the same as that specified for the active node in the SQL Server Failover Cluster. To continue, please provide False for the setting.

SQL Engine

Windows

Fixes an intra-query deadlock that occurs with certain queries when verbose truncation feature is enabled

SQL Engine

Windows

Fixes the failed assertion that occurs due to implicit conversion where predicate's precision is greater than the value:

Msg 3624, Level 20, State 1, Line LineNumber

A system assertion check has failed. Check the SQL Server error log for details. Typically, an assertion failure is caused by a software bug or data corruption. To check for database corruption, consider running DBCC CHECKDB. If you agreed to send dumps to Microsoft during setup, a mini dump will be sent to Microsoft. An update might be available from Microsoft in the latest Service Pack or in a Hotfix from Technical Support.

Msg 596, Level 21, State 1, Line LineNumber

Cannot continue the execution because the session is in the kill state.

Msg 0, Level 20, State 0, Line LineNumber

A severe error occurred on the current command. The results, if any, should be discarded.

SQL Engine

Windows

Fixes an issue where an incorrect name entry in sys.servers can result in Always On Availability Group (AG) replica being removed when the server name does not match Windows hostname

High Availability

Windows

Fixes an issue where Cumulative Update (CU) patching fails with the following message when you set default data directory to Azure Blob Storage URL:

The given path's format is not supported.

Exception Type “System.NotSupportedException”

Note To work around the issue, you can change the data default directory to a local directory and rerun the SQL patch.

Setup & Install

Windows

Fixes an issue about extended event version in Alwayson_health session is not changed automatically during Cumulative Update upgrade and downgrade

High Availability

Windows

Fixes an issue where the output of sp_pkeys KEY_SEQ column doesn't conform to the ordering of columns defined in the Primary Key

SQL Engine

Windows

Fixes an access violation exception that may occur when sp_server_diagnostics is executed

High Availability

Windows

SQL Server 2017 CU 26

 

KB

Description

Fix area

Platform

Learn More

5004734

FIX: Persisted computed columns not being consistently blocked for Columnstore index

SQL performance

All

Learn More

5004936

FIX: Error when you use columnstore indexes and run versioned scans if all rows in a compressed rowgroup are deleted in SQL Server 2017 and 2019

SQL Engine

All

Learn More

Fixes an issue in SQL Server 2017 and 2019 where you may encounter an Access Violation or Assertion when using the sys.dm_exec_query_statistics_xml Dynamic Management View

SQL performance

All

5004750

FIX: SQL Server often crashes when network.forceencryption property is set to '1'

SQL Engine

Linux

Learn More

4039592

FIX: Cannot change the password for a SQL Server service account when additional LSA protection is enabled

Management Tools

Windows

Learn More

4530907

Improvement: Corrupt statistics can be detected by using extended_logical_checks in SQL Server 2019

SQL Engine

Windows

Learn More

5004573

FIX: SQL Server affinity settings are reset after applying CU for SQL Server 2017 and 2019

SQL Engine

Windows

Learn More

5005788

FIX: Access violation occurs when you use FileTable feature with Windows Defender enabled

SQL Engine

Windows

Learn More

5006029

FIX: Assertion failure may occur when sp_cleanup_history_table is executed in SQL Server 2017

SQL Engine

Windows

Learn More

Fixes an intra-query deadlock that occurs with certain queries when verbose truncation feature is enabled

SQL Engine

Windows

Fixes an issue where Last_sent_time and Last_received_time columns in DMV dm_hadr_database_replica_states does not get updated

High Availability

Windows

Adds improvement to report SQL Server native error 35217 in the AlwaysOn_health XEvent log:

DateTimeSpid      Error: 35217, Severity: 16, State: 1.

DateTimeSpid      The thread pool for Always On Availability Groups was unable to start a new worker thread because there are not enough available worker threads. This may degrade Always On Availability Groups performance. Use the "max worker threads" configuration option to increase number of allowable threads.

High Availability

Windows

Fixes missing data in the Change Data Capture (CDC) side table and adds additional error handling to prevent data loss

SQL Engine

Windows

Fixes an issue in SQL Server 2017 where you may encounter an Access Violation or Assertion when using the  sys.dm_exec_query_statistics_xml Dynamic Management View

SQL performance

Windows

Fixes an issue where Distributed Replay Client may fail with an unhandled exception.

This fix is for the Distributed Replay Client that shipped with SQL Server 2017.

The following is the error you may observe in the output/log file:

DateTime OPERATIONAL  [Common]  Unhandled exception is encountered. [Exception Code = 3221225477]

DateTime OPERATIONAL  [Common] Invoking dump.

DateTime OPERATIONAL  [Common] Service terminating

Management Tools

Windows

Adds pOwnerSess to the error message to find the owner session Id that runs the Log Reader Agent or log - related procedure in SQL Server 2017

SQL Engine

Windows

Fixes the issue where datatype is not included in the warning message instead a 'null' value appears:

Warning: Article with '(null)' data type column is not supported with memory optimized tables on subscribers running SQL Server 2014 or earlier

SQL Engine

Windows

Fix to keep 'PERSIST_SAMPLE_PERCENT' value for statistics on an indexed column after index rebuild

SQL performance

Windows

SQL Server 2017 CU 25

 

KB

Description

Fix area

Platform

Learn More

5004466

FIX: Update SQL Server 2017 CEIP service to send usage and diagnostic data to a new endpoint

SQL Engine

All

Learn More

Fixes the Assertion error that occurs while performing database recovery in SQL Server 2017

SQL Engine

All

Fixes an issue on how to rotate the service account password without restarting SQL Server

SQL Engine

Linux

5004560

FIX: Wrong results may occur during Clustered Columnstore Index alter index reorganize in versioned scans in SQL Server 2017

SQL Engine

Windows

Learn More

5004646

FIX: Access Violation on secondary replica may occur when you drop index from view on primary replica in SQL Server 2017

SQL performance

Windows

Learn More

5004766

Improvement: Failover Cluster DNN in SQL Server 2017

SQL connectivity

Windows

Learn More

4578579

Improvement: Availability Group listener without the load balancer in SQL Server 2017 and 2019

High Availability

Windows

Learn More

Fixes an issue where a query is stuck in BATCH_MODE_SORT in SQL Server 2017

SQL Engine

Windows

Fixes the EXCEPTION_INVALID_CRT_PARAMETER dump that is generated on performing INSERT\UPDATE of wide replicated table in SQL Server 2017

SQL Engine

Windows

Adds support for 32 key columns to system sp_pkeys and fixes the performance regression that occurs after the installation of Cumulative Update 21 (CU21) for SQL Server 2017

SQL Engine

Windows

Fixes an issue in which a database freezes its I/O during a VSS backup but never thaws the I/O. This can lead to latch timeouts

SQL Engine

Windows

Fixes an issue that causes the database log_reuse_wait_desc to change to AVAILABILITY_REPLICA when a database is removed from Availability Group

High Availability

Windows

Fixes an issue where Setup Account Privileges check may not be performed when installing Cumulative Update or Security Update

Setup & Install

Windows

Fixes an issue where you are unable to set up Managed Backup on SQL 2016/2017 by using Azure SAS credential with a long secret due to SAS expiration in SQL Server 2017

SQL Engine

Windows

Fixes a potential issue that causes error 5511 when performing a log backup on a database that has filestream data

SQL Engine

Windows

Fixes an issue where SQL Server 2017 CU22 using XTP UserDB for staging tables has steady growing trend for "VARHEAP\Storage internal heap" in dm_db_xtp_memory_consumers that leads to OOM/41805 errors when it reaches 50/60GB and requires proactive restart/failover to retain stability

In-Memory OLTP

Windows

Adds improvement to help diagnose replica connection timeout errors.

Note This improvement adds sqlserver.ucs_connection_setup XEvent and 35206, 35201 ERROR_REPORTED XEvent to AlwaysOn_health, to provide additional logging detail when connection timeout occurs between error log. SSAS does not work with AlwaysOn Availability Groups, but need a different solution for DR unless you are using SQL databases as your data source.

High Availability

Windows

SQL Server 2017 CU 24

 

KB

Description

Fix area

Platform

Learn More

5000651

FIX: Assert failure occurs when concurrent query modifies the same bitmap during clustered columnstore delete bitmap seek in SQL Server 2016 and 2017

SQL Engine

All

Learn More

5001260

Improvement: Performance improvements of several spatial built-in properties and methods in SQL Server

SQL Engine

All

Learn More

Fixes an Access Violation (AV) that occurs when error is being collected for Availability Group (AG) DB Failover while there is a AG failover undergoing

High Availability

All

Improves the records stage of failure and error during stack copy for better diagnostics

SQL Engine

All

Fixes an issue where optimizer doesn't push down constant parameter to remote query via linked server

SQL performance

All

Disables FQDNs in AD usernames when creating/modifying SQL Logins/users for SQL Server 2019 on Linux

SQL Engine

Linux

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 Engine

Linux

Fixes "Fast Fail" error that occurs when SQL Server 2017 on Linux creates core dumps and SQL Server not starting after applying the latest update

SQL Engine

Linux

4023170

FIX: Error 574 when you try to install Service Pack 2 for SQL Server 2014

SQL Engine

Windows

Learn More

4589350

FIX: MERGE statement fails with Access Violation at BTreeRow::DisableAccessReleaseOnWait in SQL Server

SQL performance

Windows

Learn More

5000715

FIX: Failures with log reader agent occurs when you create and drop publication on CDC-enabled database in SQL Server 2019, 2017, and 2016

SQL Engine

Windows

Learn More

5001423

FIX: Delete operation may fail with 7105 error in SQL Server 2017

SQL Engine

Windows

Learn More

5003342

FIX: SqlLocalDB fails to start shared instances or you cannot connect to shared instances of SqlLocalDB in SQL Server 2017

SQL Engine

Windows

Learn More

When a VSS backup tries to backup SQL Server databases that are hosted on the forwarder replica of a Distributed Availability Group, the backup operation fails.

This BACKUP or RESTORE command is not supported on a database mirror or secondary replica. BACKUP DATABASE is terminating abnormally.

In the error log, you may see the following error: DateTime Backup Error: 3041, Severity: 16, State: 1.

DateTime Backup BACKUP failed to complete the command BACKUP DATABASE DatabaseName. Check the backup application log for detailed messages.

SQL Engine

Windows

Fixes an issue with the Foreign Key added to a table that is referencing a table's column which is part of a unique index with included columns. When the table's ALTER command is replicated, Distribution Agent fails with the following error message.

Number of referencing columns in foreign key differs from number of referenced columns, table 'TableName'. (Source: MSSQLServer, Error number: 8139)

SQL Engine

Windows

Fixes an Access Violation error that occurs at sqllang!CStatement::SetDbIdMaskingUsageInfo+0x11 in SQL Server 2016

SQL security

Windows

Fixes FullText query not returning the expected values that are located on the FullText index structure with AccentSensitivity turned on

SQL Engine

Windows

Fixes the performance issue that occurs with CHANGETABLE function and syscommit on SQL Server 2017

SQL performance

Windows

Fixes an Access Violation error that occurs when importing large amount of data to Azure Blob storage. This can occur if PolyBase Data Movement Service encounters out-of-memory condition during large data insert transaction

SQL Engine

Windows

Fixes an issue where DBCC PAGE with option 3 generates access violation dumps after dropping a unique identifier column from the table in SQL Server 2017.

Msg 596, Level 21, State 1, Line LineNumber

Cannot continue the execution because the session is in the kill state.

Msg 0, Level 20, State 0, Line LineNumber

A severe error occurred on the current command. The results, if any, should be discarded.

SQL Engine

Windows

Fixed the memory release issue in execution of the STDistance spatial method while using spatial index. Before the fix, memory usage of MEMORYCLERK_SOSNODE gradually grew until all the memory available is taken.

SQL Engine

Windows

Fixes the sp_hadr_verify_replication_publisher displaying wrong distribution database name in error in SQL Server 2017

SQL Engine

Windows

After FIPS is enabled in Windows, you cannot enable Managed Backup in SQL Server 2017. When trying to do so, the Application event log will record a 57054 error (from the "Microsoft SQL Server Automated Backup" source) with the following message:

[Warning] ManagedBackupBackupCertificateFailed: System.Exception: Failed to backup certificate and upload it to Azure storage. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidOperationException: This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms.

SQL Engine

Windows

SQL Server 2017 CU 23

 

KB

Description

Fix area

Platform

                                    Learn More

5000649

FIX: Wrong results due to undetected concatenation parameters from scalar expression

SQL performance

All

Learn More

5001044

FIX: Wrong results when you run a query on In-Memory optimized tables in SQL Server 2017

In-memory OLTP

All

Learn More

5001045

FIX: Memory grant wait times out when you run many Columnstore bulk inserts concurrently in SQL Server 2017

SQL Engine

All

Learn More

Fixes an issue where ALTER AVAILABILITY GROUP SET (ROLE=SECONDARY) raises an error 41104. However, it doesn't impact the Always On Availability Group health

High Availability

All

Intermittent error 6552 occurs when running Spatial query with TOP or OFFSET ROWS FETCH NEXT ROWS ONLY clause and parallel plan

SQL Engine

All

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 Engine

All

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 Engine

All

4336876

FIX: SQL Server on Linux does not start after trace flag 8809 is enabled

SQL Engine

Linux

Learn More

4582558

FIX: SQL Server service fails to start in Linux operating system

SQL Engine

Linux

Learn More