Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

SQL Server 2017 MERGE statement assertion error when database is in simple recovery model.

This appears to be identical to an earlier issue with MERGE statements in SQL Server 2014 and 2016, and to feedback closed for SQL Server 2016:

https://feedback.azure.com/forums/908035-sql-server/suggestions/32901826-sql-server-2016-merge-statement-fails-when-runni

When running a MERGE statement against a data warehouse database in simple recovery model, we receive the following fatal error: SQL Server Assertion: File: <pageref.cpp>, line=1496 Failed Assertion = 'IS_OFF (BUF_MINLOGGED, m_buf->bstat) || pageModifyType != PageModifyType_Contents || GetPagePtr ()->IsTextPage ()'.

We are running SQL Server 2017 Standard Edition with CU6 (14.0.3025.34).

A workaround for the assertion error is to set trace flag 692 which disables fast load.

5 votes
Sign in
(thinking…)
Sign in with: oidc
Signed in as (Sign out)

We’ll send you updates on this idea

donaldvc shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

3 comments

Sign in
(thinking…)
Sign in with: oidc
Signed in as (Sign out)
Submitting...
  • Stijn De Sloovere commented  ·   ·  Flag as inappropriate

    Got an answer from MS (I opened a case):
    As you have been receiving the following error as SQL Server Assertion: File: <pageref.cpp>, line=1496 Failed Assertion = 'IS_OFF (BUF_MINLOGGED, m_buf->bstat) || pageModifyType != PageModifyType_Contents || GetPagePtr ()->IsTextPage ()'.

    In this scenario, an assertion error occurs, that resembles the following:

    A system assertion check has failed. Typically, an assertion failure is caused by a software bug or data corruption. An update might be available from Microsoft in the latest Service Pack or in a Hotfix from Technical Support.

    Please get your server upgraded with the below hotfix i.e 14.0.3049.1 to overcome this issue .

    https://buildnumbers.wordpress.com/sqlserver/ -> "SQL Server 2017 14.0.1000.169 14.0.3049.1 (FIX) "

Feedback and Knowledge Base