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

Applies to: SQL Server 2014 DeveloperSQL Server 2014 DeveloperSQL Server 2014 Enterprise More

Symptoms


When you execute a query that includes an INSERT INTO...SELECT statement that inserts values into a partitioned clustered columnstore index in SQL Server 2014 or 2016, an intra-query deadlock occurs.

Resolution


This issue is fixed in the following cumulative updates for SQL Server:
 
Note After you install this update, you must set trace flag 2469 to enable the fix. To set trace flag 2469, see the Trace Flags (Transact-SQL) topic on the Microsoft Developer Network (MSDN) website.

Workaround


To work around this issue, use one of the following methods:
  • Store the intermediate results of the SELECT statement in a temporary table, and then insert the results into the clustered columnstore index from the temporary table.
  • Run the query by using 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.