x

DEADLOCK e_waitPipeNewRow e_waitPipeGetRow ?????? I DON'T KNOW WHAT CAUSED IT

GUYS ANY IDEA OF WHAT THIS DEADLOCK MEANS???? IF YOU SEARCH FOR THE WORD "Deadlock encountered" is come many times.

ALSO IT TRIGGERED THE TEMPDB OUT OF SPACE ERROR....IT JUMPED FROM 8GB TO 30GB IN 2 MINUTES.

THIS IS COMING FROM REDGATE SQL RESPONCE....

Deadlock encountered .... Printing deadlock information Wait-for graph

Node:1 Port: 0x00000000D4259670 Xid Slot: 13, Wait Slot: 6, Task: 0x00000002A28CBB88, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:30 TaskProxy0x000000037D9E6380) Value:0xa28cbb88 Cost20/0)

Node:2 Port: 0x000000021C125460 Xid Slot: 11, Wait Slot: 5, Task: 0x0000000009688988, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:9 TaskProxy0x000000068F131DC0) Value:0x9688988 Cost20/0)

Node:3 Port: 0x000000008040BB80 Xid Slot: 0, Wait Slot: 11, Task: 0x000000000A600088, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:32 TaskProxy0x000000037D9E6440) Value:0xa600088 Cost0/10000)

Node:4 Port: 0x00000005AE8CA290 Xid Slot: 9, Wait Slot: 0, Task: 0x00000000097CA748, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:16 TaskProxy0x000000068F131880) Value:0x97ca748 Cost0/10000)

Node:5 Port: 0x00000007726D38C0 Xid Slot: 6, Wait Slot: 10, Task: 0x00000001932E0988, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:22 TaskProxy0x000000037D9E6080) Value:0x932e0988 Cost0/10000)

Node:6 Port: 0x00000005AE8CA0D0 Xid Slot: 2, Wait Slot: 9, Task: 0x000000000A6042C8, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:26 TaskProxy0x000000037D9E6200) Value:0xa6042c8 Cost0/10000) Deadlock encountered .... Printing deadlock information Wait-for graph

Node:1 Port: 0x00000001E3562C30 Xid Slot: 13, Wait Slot: 7, Task: 0x00000002A28CBB88, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:30 TaskProxy0x000000037D9E6380) Value:0xa28cbb88 Cost20/0)

Node:2 Port: 0x000000021C125460 Xid Slot: 11, Wait Slot: 5, Task: 0x0000000009688988, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:9 TaskProxy0x000000068F131DC0) Value:0x9688988 Cost20/0)

Node:3 Port: 0x000000008040BB80 Xid Slot: 0, Wait Slot: 11, Task: 0x000000000A600088, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:32 TaskProxy0x000000037D9E6440) Value:0xa600088 Cost0/10000)

Node:4 Port: 0x00000005AE8CA290 Xid Slot: 9, Wait Slot: 0, Task: 0x00000000097CA748, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:16 TaskProxy0x000000068F131880) Value:0x97ca748 Cost0/10000)

Node:5 Port: 0x0000000447F5E6D0 Xid Slot: 7, Wait Slot: 10, Task: 0x000000068C511B88, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:23 TaskProxy0x000000037D9E60E0) Value:0x8c511b88 Cost0/10000)

Node:6 Port: 0x00000005AE8CA0D0 Xid Slot: 2, Wait Slot: 9, Task: 0x000000000A6042C8, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:26 TaskProxy0x000000037D9E6200) Value:0xa6042c8 Cost0/10000) Deadlock encountered .... Printing deadlock information Wait-for graph

Node:1 Port: 0x000000058A644FF0 Xid Slot: 8, Wait Slot: 2, Task: 0x0000000009415708, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:10 TaskProxy0x000000068F131E20) Value:0x9415708 Cost20/0)

Node:2 Port: 0x00000005243F08F0 Xid Slot: 0, Wait Slot: 8, Task: 0x000000000A600088, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:32 TaskProxy0x000000037D9E6440) Value:0xa600088 Cost0/10000)

Node:3 Port: 0x00000005AE8CA290 Xid Slot: 9, Wait Slot: 0, Task: 0x00000000097CA748, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:16 TaskProxy0x000000068F131880) Value:0x97ca748 Cost0/10000)

Node:4 Port: 0x00000005AE8CA0D0 Xid Slot: 2, Wait Slot: 9, Task: 0x000000000A6042C8, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:26 TaskProxy0x000000037D9E6200) Value:0xa6042c8 Cost0/10000) Deadlock encountered .... Printing deadlock information Wait-for graph

Node:1 Port: 0x00000005ADD352D0 Xid Slot: 11, Wait Slot: 2, Task: 0x0000000009688988, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:9 TaskProxy0x000000068F131DC0) Value:0x9688988 Cost20/0)

Node:2 Port: 0x000000008040BB80 Xid Slot: 0, Wait Slot: 11, Task: 0x000000000A600088, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:32 TaskProxy0x000000037D9E6440) Value:0xa600088 Cost0/10000)

Node:3 Port: 0x00000005AE8CA290 Xid Slot: 9, Wait Slot: 0, Task: 0x00000000097CA748, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:16 TaskProxy0x000000068F131880) Value:0x97ca748 Cost0/10000)

Node:4 Port: 0x00000005AE8CA0D0 Xid Slot: 2, Wait Slot: 9, Task: 0x000000000A6042C8, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:26 TaskProxy0x000000037D9E6200) Value:0xa6042c8 Cost0/10000) Deadlock encountered .... Printing deadlock information Wait-for graph

Node:1 Port: 0x00000005B6EEEBC0 Xid Slot: 13, Wait Slot: 2, Task: 0x000000000580C748, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:14 TaskProxy0x000000068F1317C0) Value:0x580c748 Cost20/0)

Node:2 Port: 0x00000006A3DDF5E0 Xid Slot: 0, Wait Slot: 13, Task: 0x000000000A600088, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:32 TaskProxy0x000000037D9E6440) Value:0xa600088 Cost0/10000)

Node:3 Port: 0x00000005AE8CA290 Xid Slot: 9, Wait Slot: 0, Task: 0x00000000097CA748, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:16 TaskProxy0x000000068F131880) Value:0x97ca748 Cost0/10000)

Node:4 Port: 0x00000005AE8CA0D0 Xid Slot: 2, Wait Slot: 9, Task: 0x000000000A6042C8, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:26 TaskProxy0x000000037D9E6200) Value:0xa6042c8 Cost0/10000) Deadlock encountered .... Printing deadlock information Wait-for graph

Node:1 Port: 0x00000006A4277750 Xid Slot: 14, Wait Slot: 2, Task: 0x000000000541D048, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:13 TaskProxy0x000000068F131F40) Value:0x541d048 Cost20/0)

Node:2 Port: 0x00000006A4276200 Xid Slot: 0, Wait Slot: 14, Task: 0x000000000A600088, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:32 TaskProxy0x000000037D9E6440) Value:0xa600088 Cost0/10000)

Node:3 Port: 0x00000005AE8CA290 Xid Slot: 9, Wait Slot: 0, Task: 0x00000000097CA748, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:16 TaskProxy0x000000068F131880) Value:0x97ca748 Cost0/10000)

Node:4 Port: 0x00000005AE8CA0D0 Xid Slot: 2, Wait Slot: 9, Task: 0x000000000A6042C8, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:26 TaskProxy0x000000037D9E6200) Value:0xa6042c8 Cost0/10000) Deadlock encountered .... Printing deadlock information Wait-for graph

Node:1 Port: 0x00000000807E3C20 Xid Slot: 15, Wait Slot: 2, Task: 0x00000002A28CA2C8, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:15 TaskProxy0x000000068F131820) Value:0xa28ca2c8 Cost20/0)

Node:2 Port: 0x00000000807E3090 Xid Slot: 0, Wait Slot: 15, Task: 0x000000000A600088, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:32 TaskProxy0x000000037D9E6440) Value:0xa600088 Cost0/10000)

Node:3 Port: 0x00000005AE8CA290 Xid Slot: 9, Wait Slot: 0, Task: 0x00000000097CA748, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:16 TaskProxy0x000000068F131880) Value:0x97ca748 Cost0/10000)

Node:4 Port: 0x00000005AE8CA0D0 Xid Slot: 2, Wait Slot: 9, Task: 0x000000000A6042C8, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:26 TaskProxy0x000000037D9E6200) Value:0xa6042c8 Cost0/10000) Deadlock encountered .... Printing deadlock information Wait-for graph

Node:1 Port: 0x000000021C125460 Xid Slot: 11, Wait Slot: 5, Task: 0x0000000009688988, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:9 TaskProxy0x000000068F131DC0) Value:0x9688988 Cost20/0)

Node:2 Port: 0x000000008040BB80 Xid Slot: 0, Wait Slot: 11, Task: 0x000000000A600088, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:32 TaskProxy0x000000037D9E6440) Value:0xa600088 Cost0/10000)

Node:3 Port: 0x00000002664C0CE0 Xid Slot: 10, Wait Slot: 0, Task: 0x000000000972EBC8, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:11 TaskProxy0x000000068F131E80) Value:0x972ebc8 Cost0/10000)

Node:4 Port: 0x000000038ADD93A0 Xid Slot: 5, Wait Slot: 10, Task: 0x00000002A28CBB88, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:30 TaskProxy0x000000037D9E6380) Value:0xa28cbb88 Cost0/10000) Deadlock encountered .... Printing deadlock information Wait-for graph

Node:1 Port: 0x00000000C442E4E0 Xid Slot: 13, Wait Slot: 5, Task: 0x000000000580C748, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:14 TaskProxy0x000000068F1317C0) Value:0x580c748 Cost20/0)

Node:2 Port: 0x00000002664C0CE0 Xid Slot: 10, Wait Slot: 0, Task: 0x000000000972EBC8, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:11 TaskProxy0x000000068F131E80) Value:0x972ebc8 Cost0/10000)

Node:3 Port: 0x000000038ADD93A0 Xid Slot: 5, Wait Slot: 10, Task: 0x00000002A28CBB88, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:30 TaskProxy0x000000037D9E6380) Value:0xa28cbb88 Cost0/10000)

Node:4 Port: 0x00000006A3DDF5E0 Xid Slot: 0, Wait Slot: 13, Task: 0x000000000A600088, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:32 TaskProxy0x000000037D9E6440) Value:0xa600088 Cost0/10000) Deadlock encountered .... Printing deadlock information Wait-for graph

Node:1 Port: 0x00000000CFBC53B0 Xid Slot: 14, Wait Slot: 5, Task: 0x000000000541D048, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:13 TaskProxy0x000000068F131F40) Value:0x541d048 Cost20/0)

Node:2 Port: 0x00000002664C0CE0 Xid Slot: 10, Wait Slot: 0, Task: 0x000000000972EBC8, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:11 TaskProxy0x000000068F131E80) Value:0x972ebc8 Cost0/10000)

Node:3 Port: 0x000000038ADD93A0 Xid Slot: 5, Wait Slot: 10, Task: 0x00000002A28CBB88, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:30 TaskProxy0x000000037D9E6380) Value:0xa28cbb88 Cost0/10000)

Node:4 Port: 0x00000006A4276200 Xid Slot: 0, Wait Slot: 14, Task: 0x000000000A600088, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:32 TaskProxy0x000000037D9E6440) Value:0xa600088 Cost0/10000) Deadlock encountered .... Printing deadlock information Wait-for graph

Node:1 Port: 0x000000036E103F80 Xid Slot: 15, Wait Slot: 5, Task: 0x00000002A28CA2C8, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:15 TaskProxy0x000000068F131820) Value:0xa28ca2c8 Cost20/0)

Node:2 Port: 0x00000002664C0CE0 Xid Slot: 10, Wait Slot: 0, Task: 0x000000000972EBC8, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:11 TaskProxy0x000000068F131E80) Value:0x972ebc8 Cost0/10000)

Node:3 Port: 0x000000038ADD93A0 Xid Slot: 5, Wait Slot: 10, Task: 0x00000002A28CBB88, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:30 TaskProxy0x000000037D9E6380) Value:0xa28cbb88 Cost0/10000)

Node:4 Port: 0x00000000807E3090 Xid Slot: 0, Wait Slot: 15, Task: 0x000000000A600088, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:32 TaskProxy0x000000037D9E6440) Value:0xa600088 Cost0/10000) Deadlock encountered .... Printing deadlock information Wait-for graph

Node:1 Port: 0x000000058A645130 Xid Slot: 8, Wait Slot: 3, Task: 0x0000000009415708, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:10 TaskProxy0x000000068F131E20) Value:0x9415708 Cost20/0)

Node:2 Port: 0x000000021AC5E8E0 Xid Slot: 11, Wait Slot: 0, Task: 0x00000000097DE748, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:27 TaskProxy0x000000037D9E6260) Value:0x97de748 Cost20/0)

Node:3 Port: 0x0000000683DC99D0 Xid Slot: 0, Wait Slot: 10, Task: 0x00000000096D1DC8, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:17 TaskProxy0x000000068F131BE0) Value:0x96d1dc8 Cost0/10000)

Node:4 Port: 0x00000005243F08F0 Xid Slot: 0, Wait Slot: 8, Task: 0x000000000A600088, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:32 TaskProxy0x000000037D9E6440) Value:0xa600088 Cost0/10000)

Node:5 Port: 0x00000005AE8CA290 Xid Slot: 9, Wait Slot: 0, Task: 0x00000000097CA748, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:16 TaskProxy0x000000068F131880) Value:0x97ca748 Cost0/10000)

Node:6 Port: 0x00000005AE8CA0D0 Xid Slot: 2, Wait Slot: 9, Task: 0x000000000A6042C8, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:26 TaskProxy0x000000037D9E6200) Value:0xa6042c8 Cost0/10000) Deadlock encountered .... Printing deadlock information Wait-for graph

Node:1 Port: 0x000000021AC5E8E0 Xid Slot: 11, Wait Slot: 0, Task: 0x00000000097DE748, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:27 TaskProxy0x000000037D9E6260) Value:0x97de748 Cost20/0)

Node:2 Port: 0x00000005ADD34920 Xid Slot: 11, Wait Slot: 3, Task: 0x0000000009688988, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:9 TaskProxy0x000000068F131DC0) Value:0x9688988 Cost20/0)

Node:3 Port: 0x0000000683DC99D0 Xid Slot: 0, Wait Slot: 10, Task: 0x00000000096D1DC8, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:17 TaskProxy0x000000068F131BE0) Value:0x96d1dc8 Cost0/10000)

Node:4 Port: 0x000000008040BB80 Xid Slot: 0, Wait Slot: 11, Task: 0x000000000A600088, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:32 TaskProxy0x000000037D9E6440) Value:0xa600088 Cost0/10000)

Node:5 Port: 0x00000005AE8CA290 Xid Slot: 9, Wait Slot: 0, Task: 0x00000000097CA748, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:16 TaskProxy0x000000068F131880) Value:0x97ca748 Cost0/10000)

Node:6 Port: 0x00000005AE8CA0D0 Xid Slot: 2, Wait Slot: 9, Task: 0x000000000A6042C8, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:26 TaskProxy0x000000037D9E6200) Value:0xa6042c8 Cost0/10000) Deadlock encountered .... Printing deadlock information Wait-for graph

Node:1 Port: 0x000000028F07F2E0 Xid Slot: 11, Wait Slot: 1, Task: 0x00000000097DE748, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:27 TaskProxy0x000000037D9E6260) Value:0x97de748 Cost20/0)

Node:2 Port: 0x00000005ADD34920 Xid Slot: 11, Wait Slot: 3, Task: 0x0000000009688988, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:9 TaskProxy0x000000068F131DC0) Value:0x9688988 Cost20/0)

Node:3 Port: 0x000000021A703240 Xid Slot: 1, Wait Slot: 10, Task: 0x00000000096B6508, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:18 TaskProxy0x000000068F131C40) Value:0x96b6508 Cost0/10000)

Node:4 Port: 0x000000008040BB80 Xid Slot: 0, Wait Slot: 11, Task: 0x000000000A600088, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:32 TaskProxy0x000000037D9E6440) Value:0xa600088 Cost0/10000)

Node:5 Port: 0x00000005AE8CA290 Xid Slot: 9, Wait Slot: 0, Task: 0x00000000097CA748, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:16 TaskProxy0x000000068F131880) Value:0x97ca748 Cost0/10000)

Node:6 Port: 0x00000005AE8CA0D0 Xid Slot: 2, Wait Slot: 9, Task: 0x000000000A6042C8, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:26 TaskProxy0x000000037D9E6200) Value:0xa6042c8 Cost0/10000) Deadlock encountered .... Printing deadlock information Wait-for graph

Node:1 Port: 0x00000005AAAA2B50 Xid Slot: 11, Wait Slot: 2, Task: 0x00000000097DE748, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:27 TaskProxy0x000000037D9E6260) Value:0x97de748 Cost20/0)

Node:2 Port: 0x00000005ADD34920 Xid Slot: 11, Wait Slot: 3, Task: 0x0000000009688988, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:9 TaskProxy0x000000068F131DC0) Value:0x9688988 Cost20/0)

Node:3 Port: 0x000000021A703E70 Xid Slot: 2, Wait Slot: 10, Task: 0x000000000A604088, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:24 TaskProxy0x000000037D9E6140) Value:0xa604088 Cost0/10000)

Node:4 Port: 0x000000008040BB80 Xid Slot: 0, Wait Slot: 11, Task: 0x000000000A600088, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:32 TaskProxy0x000000037D9E6440) Value:0xa600088 Cost0/10000)

Node:5 Port: 0x00000005AE8CA290 Xid Slot: 9, Wait Slot: 0, Task: 0x00000000097CA748, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:16 TaskProxy0x000000068F131880) Value:0x97ca748 Cost0/10000)

Node:6 Port: 0x00000005AE8CA0D0 Xid Slot: 2, Wait Slot: 9, Task: 0x000000000A6042C8, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:26 TaskProxy0x000000037D9E6200) Value:0xa6042c8 Cost0/10000) Deadlock encountered .... Printing deadlock information Wait-for graph

Node:1 Port: 0x00000005AAAA2BD0 Xid Slot: 11, Wait Slot: 3, Task: 0x00000000097DE748, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:27 TaskProxy0x000000037D9E6260) Value:0x97de748 Cost20/0)

Node:2 Port: 0x00000005ADD34920 Xid Slot: 11, Wait Slot: 3, Task: 0x0000000009688988, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:9 TaskProxy0x000000068F131DC0) Value:0x9688988 Cost20/0)

Node:3 Port: 0x00000005AE8CA0D0 Xid Slot: 2, Wait Slot: 9, Task: 0x000000000A6042C8, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:26 TaskProxy0x000000037D9E6200) Value:0xa6042c8 Cost0/10000)

Node:4 Port: 0x000000008040BB80 Xid Slot: 0, Wait Slot: 11, Task: 0x000000000A600088, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:32 TaskProxy0x000000037D9E6440) Value:0xa600088 Cost0/10000)

Node:5 Port: 0x00000005AE8CA290 Xid Slot: 9, Wait Slot: 0, Task: 0x00000000097CA748, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:16 TaskProxy0x000000068F131880) Value:0x97ca748 Cost0/10000)

Node:6 Port: 0x000000028F07E0D0 Xid Slot: 3, Wait Slot: 10, Task: 0x00000000097DE508, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:19 TaskProxy0x000000068F131CA0) Value:0x97de508 Cost0/10000) Deadlock encountered .... Printing deadlock information Wait-for graph

Node:1 Port: 0x0000000447F5FA40 Xid Slot: 11, Wait Slot: 4, Task: 0x00000000097DE748, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:27 TaskProxy0x000000037D9E6260) Value:0x97de748 Cost20/0)

Node:2 Port: 0x00000005ADD34920 Xid Slot: 11, Wait Slot: 3, Task: 0x0000000009688988, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:9 TaskProxy0x000000068F131DC0) Value:0x9688988 Cost20/0)

Node:3 Port: 0x00000007726D2E50 Xid Slot: 4, Wait Slot: 10, Task: 0x000000000580DDC8, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:20 TaskProxy0x000000068F131D00) Value:0x580ddc8 Cost0/10000)

Node:4 Port: 0x000000008040BB80 Xid Slot: 0, Wait Slot: 11, Task: 0x000000000A600088, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:32 TaskProxy0x000000037D9E6440) Value:0xa600088 Cost0/10000)

Node:5 Port: 0x00000005AE8CA290 Xid Slot: 9, Wait Slot: 0, Task: 0x00000000097CA748, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:16 TaskProxy0x000000068F131880) Value:0x97ca748 Cost0/10000)

Node:6 Port: 0x00000005AE8CA0D0 Xid Slot: 2, Wait Slot: 9, Task: 0x000000000A6042C8, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:26 TaskProxy0x000000037D9E6200) Value:0xa6042c8 Cost0/10000) Deadlock encountered .... Printing deadlock information Wait-for graph

Node:1 Port: 0x0000000141B35E70 Xid Slot: 11, Wait Slot: 5, Task: 0x00000000097DE748, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:27 TaskProxy0x000000037D9E6260) Value:0x97de748 Cost20/0)

Node:2 Port: 0x00000005ADD34920 Xid Slot: 11, Wait Slot: 3, Task: 0x0000000009688988, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:9 TaskProxy0x000000068F131DC0) Value:0x9688988 Cost20/0)

Node:3 Port: 0x0000000447F5E410 Xid Slot: 5, Wait Slot: 10, Task: 0x00000002A28CB948, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:21 TaskProxy0x000000068F131D60) Value:0xa28cb948 Cost0/10000)

Node:4 Port: 0x000000008040BB80 Xid Slot: 0, Wait Slot: 11, Task: 0x000000000A600088, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:32 TaskProxy0x000000037D9E6440) Value:0xa600088 Cost0/10000)

Node:5 Port: 0x00000005AE8CA290 Xid Slot: 9, Wait Slot: 0, Task: 0x00000000097CA748, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:16 TaskProxy0x000000068F131880) Value:0x97ca748 Cost0/10000)

Node:6 Port: 0x00000005AE8CA0D0 Xid Slot: 2, Wait Slot: 9, Task: 0x000000000A6042C8, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:26 TaskProxy0x000000037D9E6200) Value:0xa6042c8 Cost0/10000) Deadlock encountered .... Printing deadlock information Wait-for graph

Node:1 Port: 0x0000000141B34930 Xid Slot: 11, Wait Slot: 6, Task: 0x00000000097DE748, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:27 TaskProxy0x000000037D9E6260) Value:0x97de748 Cost20/0)

Node:2 Port: 0x00000005ADD34920 Xid Slot: 11, Wait Slot: 3, Task: 0x0000000009688988, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:9 TaskProxy0x000000068F131DC0) Value:0x9688988 Cost20/0)

Node:3 Port: 0x00000007726D38C0 Xid Slot: 6, Wait Slot: 10, Task: 0x00000001932E0988, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:22 TaskProxy0x000000037D9E6080) Value:0x932e0988 Cost0/10000)

Node:4 Port: 0x000000008040BB80 Xid Slot: 0, Wait Slot: 11, Task: 0x000000000A600088, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:32 TaskProxy0x000000037D9E6440) Value:0xa600088 Cost0/10000)

Node:5 Port: 0x00000005AE8CA290 Xid Slot: 9, Wait Slot: 0, Task: 0x00000000097CA748, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:16 TaskProxy0x000000068F131880) Value:0x97ca748 Cost0/10000)

Node:6 Port: 0x00000005AE8CA0D0 Xid Slot: 2, Wait Slot: 9, Task: 0x000000000A6042C8, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:26 TaskProxy0x000000037D9E6200) Value:0xa6042c8 Cost0/10000) Deadlock encountered .... Printing deadlock information Wait-for graph

Node:1 Port: 0x0000000141B353F0 Xid Slot: 11, Wait Slot: 7, Task: 0x00000000097DE748, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:27 TaskProxy0x000000037D9E6260) Value:0x97de748 Cost20/0)

Node:2 Port: 0x00000005ADD34920 Xid Slot: 11, Wait Slot: 3, Task: 0x0000000009688988, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:9 TaskProxy0x000000068F131DC0) Value:0x9688988 Cost20/0)

Node:3 Port: 0x0000000447F5E6D0 Xid Slot: 7, Wait Slot: 10, Task: 0x000000068C511B88, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:23 TaskProxy0x000000037D9E60E0) Value:0x8c511b88 Cost0/10000)

Node:4 Port: 0x000000008040BB80 Xid Slot: 0, Wait Slot: 11, Task: 0x000000000A600088, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:32 TaskProxy0x000000037D9E6440) Value:0xa600088 Cost0/10000)

Node:5 Port: 0x00000005AE8CA290 Xid Slot: 9, Wait Slot: 0, Task: 0x00000000097CA748, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:16 TaskProxy0x000000068F131880) Value:0x97ca748 Cost0/10000)

Node:6 Port: 0x00000005AE8CA0D0 Xid Slot: 2, Wait Slot: 9, Task: 0x000000000A6042C8, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:26 TaskProxy0x000000037D9E6200) Value:0xa6042c8 Cost0/10000) Deadlock encountered .... Printing deadlock information Wait-for graph

Node:1 Port: 0x00000004747C09B0 Xid Slot: 8, Wait Slot: 6, Task: 0x0000000009415708, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:10 TaskProxy0x000000068F131E20) Value:0x9415708 Cost20/0)

Node:2 Port: 0x00000005AD8E26C0 Xid Slot: 14, Wait Slot: 0, Task: 0x00000001932E14C8, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:28 TaskProxy0x000000037D9E62C0) Value:0x932e14c8 Cost20/0)

Node:3 Port: 0x0000000683DC99D0 Xid Slot: 0, Wait Slot: 10, Task: 0x00000000096D1DC8, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:17 TaskProxy0x000000068F131BE0) Value:0x96d1dc8 Cost0/10000)

Node:4 Port: 0x00000005243F08F0 Xid Slot: 0, Wait Slot: 8, Task: 0x000000000A600088, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 ResType:ExchangeId Stype:'AND' SPID:53 BatchID:0 ECID:32 TaskProxy0x000000037D9E6440) Value:0xa600088 Cost0/10000)

Node:5 Port: 0x00000005AE8CA290 Xid

more ▼

asked Dec 11, 2009 at 01:31 PM in Default

user-738 gravatar image

user-738
1 1 1 1

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

This is an intra query parallelism deadlocks. Bart Duncan coverd them on his blog post:

http://blogs.msdn.com/bartd/archive/2008/09/24/today-s-annoyingly-unwieldy-term-intra-query-parallel-thread-deadlocks.aspx

Make sure that you have the most recent patches applied to SQL Server, and then try tuning the query that triggered this deadlock by adjusting indexes or using optimizer hints to reduce the degree of parallelism that it runs under. Using OPTION(MAXDOP 1) will definitely fix the problem, but you should test other methods of solving it before getting that drastic.

more ▼

answered Dec 14, 2009 at 06:27 PM

Jonathan Kehayias gravatar image

Jonathan Kehayias
283 1 1 2

(comments are locked)
10|1200 characters needed characters left

Do you have trace flag 1222 enable ?

DBCC TRACEON (1222,-1)

This will give you the information about the resources causing the deadlock.

On another note, do you run any maint plan on the DB for rebuilding indexes.. ?

more ▼

answered Dec 11, 2009 at 02:07 PM

sp_lock gravatar image

sp_lock
9.3k 25 28 31

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x40

asked: Dec 11, 2009 at 01:31 PM

Seen: 8066 times

Last Updated: Dec 11, 2009 at 01:31 PM