So why is it causing deadlock? - LATEST DETECTED DEADLOCK. I earlier thought it could be due to an index-record lock but the trace clearly shows that the statements that are blocking each other do not have any duplicate records. The table I am trying to insert a record into is like this:Ĭol1 and Col2 together form a composite primary key. At times I get Deadlock error, following is the trace. I have a multithreaded application that tries to INSERT a record in a table in multiple batches.
0 Comments
Leave a Reply. |