Database Mirroring Suspended - SQL Server Assertion: File: <loglock.cpp>, line= Failed Assertion - by MissTipps

Status : 


Sign in
to vote
ID 770993 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 11/13/2012 8:36:14 PM
Access Restriction Public


Running SQL Server 2008 R2 SP2 V.10.50.4000.  (this is not a CTP as suggested in the 'Version' drop-down while completing this form)

Database mirroring is suspended.  Stack dump occurs and SQL Error log reads:
SQL Server Assertion: File: <loglock.cpp>, line=807 Failed Assertion = 'result == LCK_OK'. This error may be timing-related. 

I'm running database mirroring in high performance mode.  Applied SP after previously experiencing this error and referring to

Problem has re-surfaced.  I have multiple databases mirrored but this issue will occur on a single database, seemingly at random.
Sign in to post a comment.
Posted by Microsoft on 12/5/2013 at 11:35 AM
Hi MissTipps,

I've looked into this. With similar setup, I am not able to reproduce this issue. Can you share more information about reproducing this issue?

Thanks for taking the time.

Best regards,
Madhan Kumar Arumugam
SDE, Data Platform Engineering System
Posted by Microsoft on 11/21/2012 at 1:10 PM
Hi MissTipps,
thanks for taking the time to share your feedback, this is really important to us.
We will investigate the issue and get back to you.

Best regards
Jean-Yves Devant 
Program Manager Servicing and Lifecycle Experience of High Availability Technologies in SQL Server
Program Manager SQL Server Replication, Change Data Capture, Change Tracking