FIX: Intra-query deadlock when values are inserted into a partitioned clustered columnstore index in SQL Server 2016 or 2017

Applies to: SQL Server 2016 Service Pack 1SQL Server 2016 DeveloperSQL Server 2016 Enterprise

Symptoms


When you execute an INSERT INTO...SELECT query to insert values into a partitioned clustered columnstore index (CCI) in Microsoft SQL Server 2016 or SQL Server 2017, an intra-query deadlock occurs. This deadlock issue occurs only after you split the CCI partition.

Resolution


This issue is fixed in the following cumulative updates for SQL Server:

       Cumulative Update 5 for SQL Server 2017

       Cumulative update 8 for SQL Server 2016 SP1

Note After you install this update, you must drop and re-create the CCI to completely remove the previous metadata structures for the CCI.

Workaround


To work around this issue, run the query by using degree of parallelism (DOP) = 1.

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
 

References


Learn about the terminology that Microsoft uses to describe software updates.