FIX: On failover, the new secondary replica stops accepting transaction log records until the instance is restarted in SQL Server

Consider the following scenario:
  • You use Microsoft SQL Server 2014 AlwaysOn Availability Groups.
  • A failover occurs, and the primary replica becomes the new secondary replica.
  • A part of the LSNs have to undo on the new secondary replica.
  • A deadlock occurs during the undo progress, and the failover associated transaction is picked as the deadlock victim by SQL lock manager.

In this scenario, the new secondary replica stops accepting transaction log records until the instance is restarted. Additionally, a latch time-out error message that resembles the following is logged in the SQL Server error log every few minutes:

Time out occurred while waiting for buffer latch -- type 3, bp 0000003CE3093CC0, page 1:0, stat 0x9, database id: 11, allocation unit id: 6488064, task 0x0000001436F2A558 : 0, waittime 300 seconds, flags 0x100000001a, owning task 0x0000001436F2A558. Continuing to wait.
Using 'dbghelp.dll' version '4.0.5'
**Dump thread - spid = 0, EC = 0x0000001038514B90
***Stack Dump being sent to file_path
* *******************************************************************************
* date time spid spid
* Latch timeout
* *******************************************************************************

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

About cumulative updates for SQL Server
Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server:

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Learn about the terminology Microsoft uses to describe software updates.
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

Article ID: 3207327 - Last Review: 12/28/2016 18:28:00 - Revision: 2.0

Microsoft SQL Server 2014 Developer, Microsoft SQL Server 2014 Enterprise, Microsoft SQL Server 2014 Enterprise Core, Microsoft SQL Server 2014 Standard

  • kbqfe kbfix kbexpertiseinter kbsurveynew KB3207327