How can we help you today? How can we help you today?

Database ID not identified in deadlock alert

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?
ginacresse
0

Comments

1 comment

Sort by
  • priyasinha
    Hi,

    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
    priyasinha
    0

Add comment

Please sign in to leave a comment.