Symptoms

Assume that you use a sequence object in Microsoft SQL Server 2012. When you view your session’s running status, you may find there is an undetected deadlock between the checkpoint process and the session that inserts the new sequence number. In this situation, the session hangs indefinitely.

Note When you kill the blocked session, the SQL Server process stops.

Cause

The issue occurs because a checkpoint thread tries to flush a sequence. However its row cannot be found in sysobjvalues table. This is because another thread performs a rollback on a transaction that has the next value of the sequence, in this situation, the row is removed from sysobjvalues table.

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.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×