views:

77

answers:

0

I am looking for code to generate a reproducible deadlock that occurs from the use of Cascading Constraints. I can find references online for the specific problem, and I have answered dozens of questions on deadlocks where cascading constraints were in use, but none of them has a reproducible version of the deadlock.

I am not looking for information about how to troubleshoot a deadlock, capture or read the deadlock graph, or that I should use trace flags to get a deadlock graph. I got all that, I want to see the specifics of the locking that lead to this specific type of deadlock. If you can provide the specifics that allow me to write a reproduction of this deadlock, that's a good enough answer.

I have numerous scripts to reproduce other types of deadlocks involving Bookmark Lookups, inconsistent table access in stored procedures using explicit transactions, and existence checks under serializable isolation. I just can't figure out a reproduction for a Cascading Constraint deadlock.