KB4074881 - FIX: Assertion error when data is bulk-inserted into a table that contains non-clustered and clustered columnstore indexes in SQL Server 2016 and 2017

Applies to: SQL Server 2016 Enterprise CoreSQL Server 2016 EnterpriseSQL Server 2016 Developer

Symptoms


Assume that you run a query that loads data by using the BULK INSERT statement into a table that has both a nonclustered columnstore index and a clustered columnstore index in SQL Server 2016 and 2017. If the query is run at the same time through multiple connections and SQL Server doesn't grant sufficient memory to some connections, the BULK INSERT operation might fail, and you receive assertion errors that resemble the following:

Additionally, a dump file is generated by SQL Server.

Resolution


This fix is included in the following cumulative updates for SQL Server:

Cumulative Update 6 for SQL Server 2017

Cumulative Update 8 for SQL Server 2016 Service Pack 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 Microsoft uses to describe software updates.