Symptoms
Assume that you use Microsoft SQL Server 2014. When you run an online index build/switch partition with the option ABORT_AFTER_WAIT=BLOCKERS and parallel queries at the same time, a system assertion occurs and dump files are generated. Additionally, you receive the following errors:
<Date><Time> spid# Error: 1203, Severity: 20, State: 1.
<Date><Time> spid# Process ID # attempted to unlock a resource it does not own: OBJECT: 9:245575913:0 . Retry the transaction, because this error may be caused by a timing condition. If the problem persists, contact the database administrator.
……
<Date><Time> spid# Exception occurred in destructor of RowsetNewSS 0x00000004C468A7C0. This error may indicate a problem related to releasing pre-allocated disk blocks used during bulk-insert operations. Restart the server to resolve this problem.
<Date><Time> spid# Using 'dbghelp.dll' version '4.0.5'
<Date><Time> spid# **Dump thread - spid = 92, EC = 0x00000004C3B98580
<Date><Time> spid# ***Stack Dump being sent to <PathName>\<FileName>.txt
Note You can repro the issue by using the following commands:
ALTER INDEX ALL ON <TableName>
REBUILD WITH ( ONLINE = ON ( WAIT_AT_LOW_PRIORITY ( MAX_DURATION = 0 MINUTES, ABORT_AFTER_WAIT = BLOCKERS ) ))
Resolution
The issue was first fixed in the following cumulative update of SQL Server.
Cumulative Update 1 for SQL Server 2014 /en-us/help/2931693
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:
Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
