Questions tagged [deadlock-graph]
The deadlock-graph tag has no usage guidance.
10
questions
1
vote
1answer
44 views
Deadlock Detection | Should the node T4 point to T1 and T2? [closed]
This example regarding deadlock detection was shown during one of my lectures and I have a doubt about it. The image is shown below.
For deadlock detection mechanism, why does T4 point only to T2 and ...
0
votes
0answers
77 views
SQL Server : Deadlock is happening even with small batch size
We have a stored procedure which purges old data. We do the purging on daily basis during off-business hours. Also we do purging in small batches. But in the 5 hour window of purging, we see around 2 ...
2
votes
1answer
232 views
What does exchangevent indicate in SQL deadlock graph?
Have a deadlock XDL file with several exchange events listed. Not sure if these are good or bad or what causes them. What causes exchange events in SQL deadlock graph?
<exchangeEvent id="...
1
vote
1answer
56 views
Purging SP getting deadlocked with App…Not able to completed understand Deadlock Graph
We have a stored procedure which purges old data. On a regular basis, it is getting deadlocked with an application stored procedure. Below is the deadlock graph:
Deadlock XML:
<deadlock> <...
0
votes
0answers
32 views
Is it possible than two simple updates on same table interlocks (deadlock)?
Table A is:
id integer
version varchar
data jsonb (large data 1mb)
fkToBid integer (references B.id constraint)
Table B is:
id integer
other...
Processes are aggressively running the two updates ...
1
vote
1answer
50 views
Postgres 9.5 deadlock with many updates on a table + many “select for update” on another table
I have two tables: "machines" and "magictools". "magictools" refers to "machines" with a foreign key.
I face a deadlock problem while executing many of these ...
1
vote
1answer
43 views
Why is a Shared lock blocking on an IX lock when Read Committed Snapshot is enabled?
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 ...
5
votes
1answer
584 views
SQL Server Deadlock between two selects and one update on one table
Our application encounters a deadlock every now and again (about once a week).
The main culprit seems to be a query with two selects. One of them is to fill a temp table for performance reasons, the ...
0
votes
1answer
70 views
Unusual deadlock occuring
I have spent a few days trying to debug a deadlock that occurs in production. This is one I didn't understand however.
Below is pseudo code for the stored procedure. The stored procedure generates a ...
5
votes
1answer
262 views
Deadlock Graph - Surviving Statement inputbuf does not show the object that was locked
I have captured a deadlock on my system and the (anonymised) XML output is as follows:
<deadlock>
<victim-list>
<victimProcess id="processf4d9233468" />
</victim-...
