Sample Header Ad - 728x90

Why is a Shared lock blocking on an IX lock when Read Committed Snapshot is enabled?

1 vote
1 answer
497 views
Our system has randomly started deadlocking in areas where it previously had not, and an analysis of the deadlock graph looks like it should not even be happening to begin with. Here is a screenshot of the deadlock graph. enter image description here For reference: The left node is a basic insert into the sync_entities table, where the right node is:
update sync_entities 
set A=B, C=D 
from sync_entities e 
join sync_revisions r on e.id=r.entity_id 
where r.id in ()
Based on my understanding of lock compatibility, requesting an S lock when an IX lock exists would block only if **Read Committed Snapshot** is off, but it is turned on for this database, and has been for a very long time. Am I missing something? The deadlock XML says that both processes were using isolationlevel="read committed (2)".
Asked by Mirrana (224 rep)
Oct 28, 2020, 12:20 PM
Last activity: Oct 30, 2020, 05:41 AM