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.
Resolution
The issue was first fixed in the following cumulative update of SQL Server.
Cumulative Update 2 for SQL Server 2012 SP2 /en-us/help/2983175
Cumulative Update 11 for SQL Server 2012 SP1 /en-us/help/2975396
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.
