FIX: "Non-yielding" error when you try to recover an In-Memory database in SQL Server

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

Symptoms


Consider the following scenario:

  • You run an instance of Microsoft SQL Server 2017.
  • You try to recover an In-Memory database.
  • There is a large transaction with millions of In-Memory rows that is affected.

In this scenario, In-Memory redo might process all the rows without yielding, and you might receive a "non-yielding" error.

Resolution


A fix for this problem is included in the following update for SQL Server:

Cumulative Update 7 for SQL Server 2017

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 standard terminology Microsoft uses to describe software updates.