FIX: An assertion occurs when you bulk insert data into a table from multiple connections in SQL Server 2016

Applies to: SQL Server 2016 DeveloperSQL Server 2016 EnterpriseSQL Server 2016 Enterprise Core

Symptoms


When you bulk insert data into a table from multiple connections in an instance of Microsoft SQL Server 2016, an assertion that resembles the following is logged in the SQL Server error log. Additionally, a dump file is generated.
SQL Server Assertion: File:< pageref.cpp>, line=LineNumber Failed Assertion = 'IS_OFF (BUF_MINLOGGED, m_buf->bstat) || pageModifyType != PageModifyType_Contents || GetPagePtr ()->IsTextPage ()'. 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.


 

Resolution


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

Cumulative Update 1 for SQL Server 2016 Service Pack 1 (SP1)

Cumulative Update 4 for SQL Server 2016



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.