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

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

Active

Type:	Bug
ID:	770993
Opened:	11/13/2012 8:36:14 PM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

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 (expand)

English

SQL Server 2008 R2 SP2 CTP

SQL Engine

Windows Server 2008 Enterprise

English

Configure database mirroring in asynchronous mode (high-performance)...and wait

Stack dump and error message on partner (mirror) server:
Message
SQL Server Assertion: File: <loglock.cpp>, line=807 Failed Assertion = 'result == LCK_OK'. This error may be timing-related. If the error persists after rerunning the statement, use DBCC CHECKDB to check the database for structural integrity, or restart the server to ensure in-memory data structures are not corrupted.

Expected that mirroring would perform without error

X64

0 attachments

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