Database ID not identified in deadlock alert
ginacresse
Posts: 10
We get a lot of deadlock alerts that look like this:
Deadlocked processes: 139 139 139 139
Object blocked: Unknown
Deadlocked processes
SPID Victim Lock details Statement type
139
No Event:
Port: 0x00000000BA5BF650 Xid Slot: 13, Wait Slot: 5, Task: 0x000000034C499B88, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1 INSERT Line #: 8823
139
No Event:
Port: 0x0000000382C8B500 Xid Slot: 13, Wait Slot: 5, Task: 0x000000034C4994C8, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1 INSERT Line #: 8823
139
No Event:
Port: 0x00000004B6DF00F0 Xid Slot: 5, Wait Slot: 14, Task: 0x000000034C498508, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 INSERT Line #: 8823
139
No Event:
Port: 0x0000000A21867470 Xid Slot: 6, Wait Slot: 13, Task: 0x000000033DEE5948, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 INSERT Line #: 8823
SQL query fragment:
No Event:
I don't see anything that identifies the database or object. Where can I find this information?
Deadlocked processes: 139 139 139 139
Object blocked: Unknown
Deadlocked processes
SPID Victim Lock details Statement type
139
No Event:
Port: 0x00000000BA5BF650 Xid Slot: 13, Wait Slot: 5, Task: 0x000000034C499B88, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1 INSERT Line #: 8823
139
No Event:
Port: 0x0000000382C8B500 Xid Slot: 13, Wait Slot: 5, Task: 0x000000034C4994C8, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1 INSERT Line #: 8823
139
No Event:
Port: 0x00000004B6DF00F0 Xid Slot: 5, Wait Slot: 14, Task: 0x000000034C498508, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 INSERT Line #: 8823
139
No Event:
Port: 0x0000000A21867470 Xid Slot: 6, Wait Slot: 13, Task: 0x000000033DEE5948, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 INSERT Line #: 8823
SQL query fragment:
No Event:
I don't see anything that identifies the database or object. Where can I find this information?
Comments
I am not a DBA but I think this deadlock is called "intra-query parallelism deadlocks". They occur between worker threads in a parallel query. They all show up with the same SPID.
You might find more information here.
Thanks,
Priya
Project Manager
Red Gate Software