Home Dashboard Directory Help
Search

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


Status: 

Active


2
0
Sign in
to vote
Type: Bug
ID: 770993
Opened: 11/13/2012 8:36:14 PM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

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 http://support.microsoft.com/kb/974319?wa=wsignin1.0.

Problem has re-surfaced. I have multiple databases mirrored but this issue will occur on a single database, seemingly at random.
Details
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
Sign in to post a workaround.