Deadlocked on thread | communication buffer resources with another process

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Roberto Souza (robertossantos_at_hotmail.com)
Date: 10/27/04

Next message: Peter The Spate: "Re: How to tell how much memory is actually needed by my SQL Server 2000??"
Previous message: Neil: "archiving"
Messages sorted by: [ date ] [ thread ]

Date: Wed, 27 Oct 2004 11:00:49 -0300

Hi, I'm getting this error

Server: Msg 1205, Level 13, State 1, Line 1
Transaction (Process ID 101) was deadlocked on thread | communication buffer
resources with another process and has been chosen as the deadlock victim.
Rerun the transaction.

when running this query:

SELECT
D_ATIVO_MENSAL.DATA_REFERENCIA,
D_OPERACAO_ATIVO.CODIGO_PRODUTO,
D_PRODUTO.PRODUTO,

Count(D_ATIVO_MENSAL.COD_OPER_ATIVO) AS 'Contagem de COD_OPER_ATIVO',
Sum(D_ATIVO_MENSAL.ULT_VLR_CONTRATADO) AS 'Soma de ULT_VLR_CONTRATADO',
Sum(D_ATIVO_MENSAL.ULT_SALDO_CONTABIL) AS 'Soma de ULT_SALDO_CONTABIL',
Sum(D_ATIVO_MENSAL.ULT_SALDO_FINANC) AS 'Soma de ULT_SALDO_FINANC',
Sum(D_ATIVO_MENSAL.ULT_REND_APROP_DEC) AS 'Soma de ULT_REND_APROP_DEC'
FROM
DBZB099D.dbo.D_ATIVO_MENSAL D_ATIVO_MENSAL,
DBZB099D.dbo.D_OPERACAO_ATIVO D_OPERACAO_ATIVO,
DBZB099D.dbo.D_PRODUTO D_PRODUTO
WHERE
D_ATIVO_MENSAL.COD_OPER_ATIVO = D_OPERACAO_ATIVO.COD_OPER_ATIVO AND
D_ATIVO_MENSAL.SISTEMA_ORIGEM = D_OPERACAO_ATIVO.SISTEMA_ORIGEM AND
D_OPERACAO_ATIVO.CODIGO_PRODUTO = D_PRODUTO.CODIGO_PRODUTO AND
((D_ATIVO_MENSAL.DATA_REFERENCIA={ts '2004-06-01 00:00:00'}) AND
(D_OPERACAO_ATIVO.SISTEMA_ORIGEM In ('OC','CRT')) AND
(D_OPERACAO_ATIVO.CODIGO_PRODUTO In (256,257,258,259,260,2)))
GROUP BY
D_ATIVO_MENSAL.DATA_REFERENCIA,
D_OPERACAO_ATIVO.CODIGO_PRODUTO, D_PRODUTO.PRODUTO

Since this is a thread deadlock, its hard to point the source of this
problem, and its much harder to avoid it.

The errorlog section reporting this deadlock (from 1204) is bellow:

Deadlock encountered .... Printing deadlock information
2004-10-27 09:59:52.28 spid4
2004-10-27 09:59:52.28 spid4 Wait-for graph
2004-10-27 09:59:52.28 spid4
2004-10-27 09:59:52.28 spid4 Node:1
2004-10-27 09:59:52.28 spid4 Port: 0x80070e80 Xid Slot: 0, EC:
0x72281538, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeCXPacket
2004-10-27 09:59:52.28 spid4 SPID: 101 ECID: 0 Statement Type: SELECT
Line #: 1
2004-10-27 09:59:52.28 spid4 Input Buf: Language Event: SELECT
D_ATIVO_MENSAL.DATA_REFERENCIA,
D_OPERACAO_ATIVO.CODIGO_PRODUTO,
D_PRODUTO.PRODUTO,
Count(D_ATIVO_MENSAL.COD_OPER_ATIVO) AS 'Contagem de COD_OPER_ATIVO',
Sum(D_ATIVO_MENSAL.ULT_VLR_CONTRATADO) AS 'Soma de ULT_VLR_CONTRATADO',
Sum(
2004-10-27 09:59:52.28 spid4 Coordinator: EC = 0x72281538, SPID: 101,
ECID: 0, Not Blocking
2004-10-27 09:59:52.28 spid4 Consumer List::
2004-10-27 09:59:52.28 spid4 Consumer: Xid Slot: 0, EC = 0x72281538,
SPID: 101, ECID: 0, Not Blocking
2004-10-27 09:59:52.28 spid4 Producer List::
2004-10-27 09:59:52.28 spid4 Producer: Xid Slot: 1, EC = 0x4d16a098,
SPID: 101, ECID: 3, Blocking
2004-10-27 09:59:52.28 spid4 Producer: Xid Slot: 2, EC = 0xbd1d0098,
SPID: 101, ECID: 2, Blocking
2004-10-27 09:59:52.28 spid4 Producer: Xid Slot: 3, EC = 0xbd3e6098,
SPID: 101, ECID: 1, Blocking
2004-10-27 09:59:52.28 spid4
2004-10-27 09:59:52.28 spid4 Node:2
2004-10-27 09:59:52.28 spid4 Port: 0x80070380 Xid Slot: 3, EC:
0x4d16a098, ECID: 3 (Consumer), Exchange Wait Type :e_etypeCXPacket
2004-10-27 09:59:52.28 spid4 Coordinator: EC = 0x72281538, SPID: 101,
ECID: 0, Not Blocking
2004-10-27 09:59:52.28 spid4 Consumer List::
2004-10-27 09:59:52.28 spid4 Consumer: Xid Slot: 3, EC = 0x4d16a098,
SPID: 101, ECID: 3, Not Blocking
2004-10-27 09:59:52.28 spid4 Consumer: Xid Slot: 4, EC = 0xbd1d0098,
SPID: 101, ECID: 2, Not Blocking
2004-10-27 09:59:52.28 spid4 Consumer: Xid Slot: 5, EC = 0xbd3e6098,
SPID: 101, ECID: 1, Not Blocking
2004-10-27 09:59:52.28 spid4 Producer List::
2004-10-27 09:59:52.28 spid4 Producer: Xid Slot: 0, EC = 0x4d09a098,
SPID: 101, ECID: 6, Blocking
2004-10-27 09:59:52.28 spid4 Producer: Xid Slot: 1, EC = 0x4d158098,
SPID: 101, ECID: 4, Blocking
2004-10-27 09:59:52.28 spid4 Producer: Xid Slot: 2, EC = 0x4d09e098,
SPID: 101, ECID: 5, Blocking
2004-10-27 09:59:52.28 spid4
2004-10-27 09:59:52.28 spid4 Node:3
2004-10-27 09:59:52.28 spid4 Port: 0x80070380 Xid Slot: 0, EC:
0x4d09a098, ECID: 6 (Producer), Exchange Wait Type :e_etypeCXPacket
2004-10-27 09:59:52.28 spid4 Coordinator: EC = 0x72281538, SPID: 101,
ECID: 0, Not Blocking
2004-10-27 09:59:52.28 spid4 Consumer List::
2004-10-27 09:59:52.28 spid4 Consumer: Xid Slot: 3, EC = 0x4d16a098,
SPID: 101, ECID: 3, Blocking
2004-10-27 09:59:52.28 spid4 Consumer: Xid Slot: 4, EC = 0xbd1d0098,
SPID: 101, ECID: 2, Blocking
2004-10-27 09:59:52.28 spid4 Consumer: Xid Slot: 5, EC = 0xbd3e6098,
SPID: 101, ECID: 1, Blocking
2004-10-27 09:59:52.28 spid4 Producer List::
2004-10-27 09:59:52.28 spid4 Producer: Xid Slot: 0, EC = 0x4d09a098,
SPID: 101, ECID: 6, Not Blocking
2004-10-27 09:59:52.28 spid4 Producer: Xid Slot: 1, EC = 0x4d158098,
SPID: 101, ECID: 4, Not Blocking
2004-10-27 09:59:52.28 spid4 Producer: Xid Slot: 2, EC = 0x4d09e098,
SPID: 101, ECID: 5, Not Blocking
2004-10-27 09:59:52.28 spid4
2004-10-27 09:59:52.28 spid4 -- next branch --
2004-10-27 09:59:52.28 spid4
2004-10-27 09:59:52.28 spid4
2004-10-27 09:59:52.28 spid4 Node:3
2004-10-27 09:59:52.28 spid4 Port: 0x80070380 Xid Slot: 0, EC:
0x4d09a098, ECID: 6 (Producer), Exchange Wait Type :e_etypeCXPacket
2004-10-27 09:59:52.28 spid4 Coordinator: EC = 0x72281538, SPID: 101,
ECID: 0, Not Blocking
2004-10-27 09:59:52.28 spid4 Consumer List::
2004-10-27 09:59:52.28 spid4 Consumer: Xid Slot: 3, EC = 0x4d16a098,
SPID: 101, ECID: 3, Blocking
2004-10-27 09:59:52.28 spid4 Consumer: Xid Slot: 4, EC = 0xbd1d0098,
SPID: 101, ECID: 2, Blocking
2004-10-27 09:59:52.28 spid4 Consumer: Xid Slot: 5, EC = 0xbd3e6098,
SPID: 101, ECID: 1, Blocking
2004-10-27 09:59:52.28 spid4 Producer List::
2004-10-27 09:59:52.28 spid4 Producer: Xid Slot: 0, EC = 0x4d09a098,
SPID: 101, ECID: 6, Not Blocking
2004-10-27 09:59:52.28 spid4 Producer: Xid Slot: 1, EC = 0x4d158098,
SPID: 101, ECID: 4, Not Blocking
2004-10-27 09:59:52.28 spid4 Producer: Xid Slot: 2, EC = 0x4d09e098,
SPID: 101, ECID: 5, Not Blocking
2004-10-27 09:59:52.28 spid4
2004-10-27 09:59:52.28 spid4 Node:6
2004-10-27 09:59:52.28 spid4 Port: 0x80070380 Xid Slot: 4, EC:
0xbd1d0098, ECID: 2 (Consumer), Exchange Wait Type :e_etypeCXPacket
2004-10-27 09:59:52.28 spid4 Coordinator: EC = 0x72281538, SPID: 101,
ECID: 0, Not Blocking
2004-10-27 09:59:52.28 spid4 Consumer List::
2004-10-27 09:59:52.28 spid4 Consumer: Xid Slot: 3, EC = 0x4d16a098,
SPID: 101, ECID: 3, Not Blocking
2004-10-27 09:59:52.28 spid4 Consumer: Xid Slot: 4, EC = 0xbd1d0098,
SPID: 101, ECID: 2, Not Blocking
2004-10-27 09:59:52.28 spid4 Consumer: Xid Slot: 5, EC = 0xbd3e6098,
SPID: 101, ECID: 1, Not Blocking
2004-10-27 09:59:52.28 spid4 Producer List::
2004-10-27 09:59:52.28 spid4 Producer: Xid Slot: 0, EC = 0x4d09a098,
SPID: 101, ECID: 6, Blocking
2004-10-27 09:59:52.28 spid4 Producer: Xid Slot: 1, EC = 0x4d158098,
SPID: 101, ECID: 4, Blocking
2004-10-27 09:59:52.28 spid4 Producer: Xid Slot: 2, EC = 0x4d09e098,
SPID: 101, ECID: 5, Blocking
2004-10-27 09:59:52.28 spid4
2004-10-27 09:59:52.28 spid4 -- next branch --
2004-10-27 09:59:52.28 spid4
2004-10-27 09:59:52.28 spid4
2004-10-27 09:59:52.28 spid4 Node:6
2004-10-27 09:59:52.28 spid4 Port: 0x80070380 Xid Slot: 4, EC:
0xbd1d0098, ECID: 2 (Consumer), Exchange Wait Type :e_etypeCXPacket
2004-10-27 09:59:52.28 spid4 Coordinator: EC = 0x72281538, SPID: 101,
ECID: 0, Not Blocking
2004-10-27 09:59:52.28 spid4 Consumer List::
2004-10-27 09:59:52.28 spid4 Consumer: Xid Slot: 3, EC = 0x4d16a098,
SPID: 101, ECID: 3, Not Blocking
2004-10-27 09:59:52.28 spid4 Consumer: Xid Slot: 4, EC = 0xbd1d0098,
SPID: 101, ECID: 2, Not Blocking
2004-10-27 09:59:52.28 spid4 Consumer: Xid Slot: 5, EC = 0xbd3e6098,
SPID: 101, ECID: 1, Not Blocking
2004-10-27 09:59:52.28 spid4 Producer List::
2004-10-27 09:59:52.28 spid4 Producer: Xid Slot: 0, EC = 0x4d09a098,
SPID: 101, ECID: 6, Blocking
2004-10-27 09:59:52.28 spid4 Producer: Xid Slot: 1, EC = 0x4d158098,
SPID: 101, ECID: 4, Blocking
2004-10-27 09:59:52.28 spid4 Producer: Xid Slot: 2, EC = 0x4d09e098,
SPID: 101, ECID: 5, Blocking
2004-10-27 09:59:52.28 spid4
2004-10-27 09:59:52.28 spid4 Node:9
2004-10-27 09:59:52.28 spid4 Port: 0x80070380 Xid Slot: 1, EC:
0x4d158098, ECID: 4 (Producer), Exchange Wait Type :e_etypeCXPacket
2004-10-27 09:59:52.28 spid4 Coordinator: EC = 0x72281538, SPID: 101,
ECID: 0, Not Blocking
2004-10-27 09:59:52.28 spid4 Consumer List::
2004-10-27 09:59:52.28 spid4 Consumer: Xid Slot: 3, EC = 0x4d16a098,
SPID: 101, ECID: 3, Blocking
2004-10-27 09:59:52.28 spid4 Consumer: Xid Slot: 4, EC = 0xbd1d0098,
SPID: 101, ECID: 2, Blocking
2004-10-27 09:59:52.28 spid4 Consumer: Xid Slot: 5, EC = 0xbd3e6098,
SPID: 101, ECID: 1, Blocking
2004-10-27 09:59:52.28 spid4 Producer List::
2004-10-27 09:59:52.28 spid4 Producer: Xid Slot: 0, EC = 0x4d09a098,
SPID: 101, ECID: 6, Not Blocking
2004-10-27 09:59:52.28 spid4 Producer: Xid Slot: 1, EC = 0x4d158098,
SPID: 101, ECID: 4, Not Blocking
2004-10-27 09:59:52.28 spid4 Producer: Xid Slot: 2, EC = 0x4d09e098,
SPID: 101, ECID: 5, Not Blocking
2004-10-27 09:59:52.28 spid4
2004-10-27 09:59:52.28 spid4 -- next branch --
2004-10-27 09:59:52.28 spid4
2004-10-27 09:59:52.28 spid4
2004-10-27 09:59:52.28 spid4 Node:9
2004-10-27 09:59:52.28 spid4 Port: 0x80070380 Xid Slot: 1, EC:
0x4d158098, ECID: 4 (Producer), Exchange Wait Type :e_etypeCXPacket
2004-10-27 09:59:52.28 spid4 Coordinator: EC = 0x72281538, SPID: 101,
ECID: 0, Not Blocking
2004-10-27 09:59:52.28 spid4 Consumer List::
2004-10-27 09:59:52.28 spid4 Consumer: Xid Slot: 3, EC = 0x4d16a098,
SPID: 101, ECID: 3, Blocking
2004-10-27 09:59:52.28 spid4 Consumer: Xid Slot: 4, EC = 0xbd1d0098,
SPID: 101, ECID: 2, Blocking
2004-10-27 09:59:52.28 spid4 Consumer: Xid Slot: 5, EC = 0xbd3e6098,
SPID: 101, ECID: 1, Blocking
2004-10-27 09:59:52.28 spid4 Producer List::
2004-10-27 09:59:52.28 spid4 Producer: Xid Slot: 0, EC = 0x4d09a098,
SPID: 101, ECID: 6, Not Blocking
2004-10-27 09:59:52.28 spid4 Producer: Xid Slot: 1, EC = 0x4d158098,
SPID: 101, ECID: 4, Not Blocking
2004-10-27 09:59:52.28 spid4 Producer: Xid Slot: 2, EC = 0x4d09e098,
SPID: 101, ECID: 5, Not Blocking
2004-10-27 09:59:52.28 spid4
2004-10-27 09:59:52.28 spid4 -- next branch --
2004-10-27 09:59:52.28 spid4
2004-10-27 09:59:52.28 spid4
2004-10-27 09:59:52.29 spid4 Node:9
2004-10-27 09:59:52.29 spid4 Port: 0x80070380 Xid Slot: 1, EC:
0x4d158098, ECID: 4 (Producer), Exchange Wait Type :e_etypeCXPacket
2004-10-27 09:59:52.29 spid4 Coordinator: EC = 0x72281538, SPID: 101,
ECID: 0, Not Blocking
2004-10-27 09:59:52.29 spid4 Consumer List::
2004-10-27 09:59:52.29 spid4 Consumer: Xid Slot: 3, EC = 0x4d16a098,
SPID: 101, ECID: 3, Blocking
2004-10-27 09:59:52.29 spid4 Consumer: Xid Slot: 4, EC = 0xbd1d0098,
SPID: 101, ECID: 2, Blocking
2004-10-27 09:59:52.29 spid4 Consumer: Xid Slot: 5, EC = 0xbd3e6098,
SPID: 101, ECID: 1, Blocking
2004-10-27 09:59:52.29 spid4 Producer List::
2004-10-27 09:59:52.29 spid4 Producer: Xid Slot: 0, EC = 0x4d09a098,
SPID: 101, ECID: 6, Not Blocking
2004-10-27 09:59:52.29 spid4 Producer: Xid Slot: 1, EC = 0x4d158098,
SPID: 101, ECID: 4, Not Blocking
2004-10-27 09:59:52.29 spid4 Producer: Xid Slot: 2, EC = 0x4d09e098,
SPID: 101, ECID: 5, Not Blocking
2004-10-27 09:59:52.29 spid4
2004-10-27 09:59:52.29 spid4 Node:14
2004-10-27 09:59:52.29 spid4 Port: 0x80070380 Xid Slot: 5, EC:
0xbd3e6098, ECID: 1 (Consumer), Exchange Wait Type :e_etypeCXPacket
2004-10-27 09:59:52.29 spid4 Coordinator: EC = 0x72281538, SPID: 101,
ECID: 0, Not Blocking
2004-10-27 09:59:52.29 spid4 Consumer List::
2004-10-27 09:59:52.29 spid4 Consumer: Xid Slot: 3, EC = 0x4d16a098,
SPID: 101, ECID: 3, Not Blocking
2004-10-27 09:59:52.29 spid4 Consumer: Xid Slot: 4, EC = 0xbd1d0098,
SPID: 101, ECID: 2, Not Blocking
2004-10-27 09:59:52.29 spid4 Consumer: Xid Slot: 5, EC = 0xbd3e6098,
SPID: 101, ECID: 1, Not Blocking
2004-10-27 09:59:52.29 spid4 Producer List::
2004-10-27 09:59:52.29 spid4 Producer: Xid Slot: 0, EC = 0x4d09a098,
SPID: 101, ECID: 6, Blocking
2004-10-27 09:59:52.29 spid4 Producer: Xid Slot: 1, EC = 0x4d158098,
SPID: 101, ECID: 4, Blocking
2004-10-27 09:59:52.29 spid4 Producer: Xid Slot: 2, EC = 0x4d09e098,
SPID: 101, ECID: 5, Blocking
2004-10-27 09:59:52.29 spid4
2004-10-27 09:59:52.29 spid4 -- next branch --
2004-10-27 09:59:52.29 spid4
2004-10-27 09:59:52.29 spid4
2004-10-27 09:59:52.29 spid4 Node:14
2004-10-27 09:59:52.29 spid4 Port: 0x80070380 Xid Slot: 5, EC:
0xbd3e6098, ECID: 1 (Consumer), Exchange Wait Type :e_etypeCXPacket
2004-10-27 09:59:52.29 spid4 Coordinator: EC = 0x72281538, SPID: 101,
ECID: 0, Not Blocking
2004-10-27 09:59:52.29 spid4 Consumer List::
2004-10-27 09:59:52.29 spid4 Consumer: Xid Slot: 3, EC = 0x4d16a098,
SPID: 101, ECID: 3, Not Blocking
2004-10-27 09:59:52.29 spid4 Consumer: Xid Slot: 4, EC = 0xbd1d0098,
SPID: 101, ECID: 2, Not Blocking
2004-10-27 09:59:52.29 spid4 Consumer: Xid Slot: 5, EC = 0xbd3e6098,
SPID: 101, ECID: 1, Not Blocking
2004-10-27 09:59:52.29 spid4 Producer List::
2004-10-27 09:59:52.29 spid4 Producer: Xid Slot: 0, EC = 0x4d09a098,
SPID: 101, ECID: 6, Blocking
2004-10-27 09:59:52.29 spid4 Producer: Xid Slot: 1, EC = 0x4d158098,
SPID: 101, ECID: 4, Blocking
2004-10-27 09:59:52.29 spid4 Producer: Xid Slot: 2, EC = 0x4d09e098,
SPID: 101, ECID: 5, Blocking
2004-10-27 09:59:52.29 spid4
2004-10-27 09:59:52.29 spid4 -- next branch --
2004-10-27 09:59:52.29 spid4
2004-10-27 09:59:52.29 spid4
2004-10-27 09:59:52.29 spid4 Node:14
2004-10-27 09:59:52.29 spid4 Port: 0x80070380 Xid Slot: 5, EC:
0xbd3e6098, ECID: 1 (Consumer), Exchange Wait Type :e_etypeCXPacket
2004-10-27 09:59:52.29 spid4 Coordinator: EC = 0x72281538, SPID: 101,
ECID: 0, Not Blocking
2004-10-27 09:59:52.29 spid4 Consumer List::
2004-10-27 09:59:52.29 spid4 Consumer: Xid Slot: 3, EC = 0x4d16a098,
SPID: 101, ECID: 3, Not Blocking
2004-10-27 09:59:52.29 spid4 Consumer: Xid Slot: 4, EC = 0xbd1d0098,
SPID: 101, ECID: 2, Not Blocking
2004-10-27 09:59:52.29 spid4 Consumer: Xid Slot: 5, EC = 0xbd3e6098,
SPID: 101, ECID: 1, Not Blocking
2004-10-27 09:59:52.29 spid4 Producer List::
2004-10-27 09:59:52.29 spid4 Producer: Xid Slot: 0, EC = 0x4d09a098,
SPID: 101, ECID: 6, Blocking
2004-10-27 09:59:52.29 spid4 Producer: Xid Slot: 1, EC = 0x4d158098,
SPID: 101, ECID: 4, Blocking
2004-10-27 09:59:52.29 spid4 Producer: Xid Slot: 2, EC = 0x4d09e098,
SPID: 101, ECID: 5, Blocking
2004-10-27 09:59:52.29 spid4
2004-10-27 09:59:52.29 spid4 Node:19
2004-10-27 09:59:52.29 spid4 Waiting for parallel threads to enlist.
2004-10-27 09:59:52.29 spid4
2004-10-27 09:59:52.29 spid4 -- next branch --
2004-10-27 09:59:52.29 spid4
2004-10-27 09:59:52.29 spid4
2004-10-27 09:59:52.29 spid4 Node:14
2004-10-27 09:59:52.29 spid4 Port: 0x80070380 Xid Slot: 5, EC:
0xbd3e6098, ECID: 1 (Consumer), Exchange Wait Type :e_etypeCXPacket
2004-10-27 09:59:52.29 spid4 Coordinator: EC = 0x72281538, SPID: 101,
ECID: 0, Not Blocking
2004-10-27 09:59:52.29 spid4 Consumer List::
2004-10-27 09:59:52.29 spid4 Consumer: Xid Slot: 3, EC = 0x4d16a098,
SPID: 101, ECID: 3, Not Blocking
2004-10-27 09:59:52.29 spid4 Consumer: Xid Slot: 4, EC = 0xbd1d0098,
SPID: 101, ECID: 2, Not Blocking
2004-10-27 09:59:52.29 spid4 Consumer: Xid Slot: 5, EC = 0xbd3e6098,
SPID: 101, ECID: 1, Not Blocking
2004-10-27 09:59:52.29 spid4 Producer List::
2004-10-27 09:59:52.29 spid4 Producer: Xid Slot: 0, EC = 0x4d09a098,
SPID: 101, ECID: 6, Blocking
2004-10-27 09:59:52.29 spid4 Producer: Xid Slot: 1, EC = 0x4d158098,
SPID: 101, ECID: 4, Blocking
2004-10-27 09:59:52.29 spid4 Producer: Xid Slot: 2, EC = 0x4d09e098,
SPID: 101, ECID: 5, Blocking
2004-10-27 09:59:52.29 spid4
2004-10-27 09:59:52.29 spid4 -- next branch --
2004-10-27 09:59:52.29 spid4
2004-10-27 09:59:52.29 spid4
2004-10-27 09:59:52.29 spid4 Node:9
2004-10-27 09:59:52.29 spid4 Port: 0x80070380 Xid Slot: 1, EC:
0x4d158098, ECID: 4 (Producer), Exchange Wait Type :e_etypeCXPacket
2004-10-27 09:59:52.29 spid4 Coordinator: EC = 0x72281538, SPID: 101,
ECID: 0, Not Blocking
2004-10-27 09:59:52.29 spid4 Consumer List::
2004-10-27 09:59:52.29 spid4 Consumer: Xid Slot: 3, EC = 0x4d16a098,
SPID: 101, ECID: 3, Blocking
2004-10-27 09:59:52.29 spid4 Consumer: Xid Slot: 4, EC = 0xbd1d0098,
SPID: 101, ECID: 2, Blocking
2004-10-27 09:59:52.29 spid4 Consumer: Xid Slot: 5, EC = 0xbd3e6098,
SPID: 101, ECID: 1, Blocking
2004-10-27 09:59:52.29 spid4 Producer List::
2004-10-27 09:59:52.29 spid4 Producer: Xid Slot: 0, EC = 0x4d09a098,
SPID: 101, ECID: 6, Not Blocking
2004-10-27 09:59:52.29 spid4 Producer: Xid Slot: 1, EC = 0x4d158098,
SPID: 101, ECID: 4, Not Blocking
2004-10-27 09:59:52.29 spid4 Producer: Xid Slot: 2, EC = 0x4d09e098,
SPID: 101, ECID: 5, Not Blocking
2004-10-27 09:59:52.29 spid4
2004-10-27 09:59:52.29 spid4 -- next branch --
2004-10-27 09:59:52.29 spid4
2004-10-27 09:59:52.29 spid4
2004-10-27 09:59:52.29 spid4 Node:6
2004-10-27 09:59:52.29 spid4 Port: 0x80070380 Xid Slot: 4, EC:
0xbd1d0098, ECID: 2 (Consumer), Exchange Wait Type :e_etypeCXPacket
2004-10-27 09:59:52.29 spid4 Coordinator: EC = 0x72281538, SPID: 101,
ECID: 0, Not Blocking
2004-10-27 09:59:52.29 spid4 Consumer List::
2004-10-27 09:59:52.29 spid4 Consumer: Xid Slot: 3, EC = 0x4d16a098,
SPID: 101, ECID: 3, Not Blocking
2004-10-27 09:59:52.29 spid4 Consumer: Xid Slot: 4, EC = 0xbd1d0098,
SPID: 101, ECID: 2, Not Blocking
2004-10-27 09:59:52.29 spid4 Consumer: Xid Slot: 5, EC = 0xbd3e6098,
SPID: 101, ECID: 1, Not Blocking
2004-10-27 09:59:52.29 spid4 Producer List::
2004-10-27 09:59:52.29 spid4 Producer: Xid Slot: 0, EC = 0x4d09a098,
SPID: 101, ECID: 6, Blocking
2004-10-27 09:59:52.29 spid4 Producer: Xid Slot: 1, EC = 0x4d158098,
SPID: 101, ECID: 4, Blocking
2004-10-27 09:59:52.29 spid4 Producer: Xid Slot: 2, EC = 0x4d09e098,
SPID: 101, ECID: 5, Blocking
2004-10-27 09:59:52.29 spid4
2004-10-27 09:59:52.29 spid4 -- next branch --
2004-10-27 09:59:52.29 spid4
2004-10-27 09:59:52.29 spid4
2004-10-27 09:59:52.29 spid4 Node:6
2004-10-27 09:59:52.29 spid4 Port: 0x80070380 Xid Slot: 4, EC:
0xbd1d0098, ECID: 2 (Consumer), Exchange Wait Type :e_etypeCXPacket
2004-10-27 09:59:52.29 spid4 Coordinator: EC = 0x72281538, SPID: 101,
ECID: 0, Not Blocking
2004-10-27 09:59:52.29 spid4 Consumer List::
2004-10-27 09:59:52.29 spid4 Consumer: Xid Slot: 3, EC = 0x4d16a098,
SPID: 101, ECID: 3, Not Blocking
2004-10-27 09:59:52.29 spid4 Consumer: Xid Slot: 4, EC = 0xbd1d0098,
SPID: 101, ECID: 2, Not Blocking
2004-10-27 09:59:52.29 spid4 Consumer: Xid Slot: 5, EC = 0xbd3e6098,
SPID: 101, ECID: 1, Not Blocking
2004-10-27 09:59:52.29 spid4 Producer List::
2004-10-27 09:59:52.29 spid4 Producer: Xid Slot: 0, EC = 0x4d09a098,
SPID: 101, ECID: 6, Blocking
2004-10-27 09:59:52.29 spid4 Producer: Xid Slot: 1, EC = 0x4d158098,
SPID: 101, ECID: 4, Blocking
2004-10-27 09:59:52.29 spid4 Producer: Xid Slot: 2, EC = 0x4d09e098,
SPID: 101, ECID: 5, Blocking
2004-10-27 09:59:52.29 spid4
2004-10-27 09:59:52.29 spid4 -- next branch --
2004-10-27 09:59:52.29 spid4
2004-10-27 09:59:52.29 spid4
2004-10-27 09:59:52.29 spid4 Node:3
2004-10-27 09:59:52.29 spid4 Port: 0x80070380 Xid Slot: 0, EC:
0x4d09a098, ECID: 6 (Producer), Exchange Wait Type :e_etypeCXPacket
2004-10-27 09:59:52.29 spid4 Coordinator: EC = 0x72281538, SPID: 101,
ECID: 0, Not Blocking
2004-10-27 09:59:52.29 spid4 Consumer List::
2004-10-27 09:59:52.29 spid4 Consumer: Xid Slot: 3, EC = 0x4d16a098,
SPID: 101, ECID: 3, Blocking
2004-10-27 09:59:52.29 spid4 Consumer: Xid Slot: 4, EC = 0xbd1d0098,
SPID: 101, ECID: 2, Blocking
2004-10-27 09:59:52.29 spid4 Consumer: Xid Slot: 5, EC = 0xbd3e6098,
SPID: 101, ECID: 1, Blocking
2004-10-27 09:59:52.29 spid4 Producer List::
2004-10-27 09:59:52.29 spid4 Producer: Xid Slot: 0, EC = 0x4d09a098,
SPID: 101, ECID: 6, Not Blocking
2004-10-27 09:59:52.29 spid4 Producer: Xid Slot: 1, EC = 0x4d158098,
SPID: 101, ECID: 4, Not Blocking
2004-10-27 09:59:52.29 spid4 Producer: Xid Slot: 2, EC = 0x4d09e098,
SPID: 101, ECID: 5, Not Blocking
2004-10-27 09:59:52.29 spid4
2004-10-27 09:59:52.29 spid4 -- next branch --
2004-10-27 09:59:52.29 spid4
2004-10-27 09:59:52.31 spid4
2004-10-27 09:59:52.31 spid4 Node:3
2004-10-27 09:59:52.31 spid4 Port: 0x80070380 Xid Slot: 0, EC:
0x4d09a098, ECID: 6 (Producer), Exchange Wait Type :e_etypeCXPacket
2004-10-27 09:59:52.31 spid4 Coordinator: EC = 0x72281538, SPID: 101,
ECID: 0, Not Blocking
2004-10-27 09:59:52.31 spid4 Consumer List::
2004-10-27 09:59:52.31 spid4 Consumer: Xid Slot: 3, EC = 0x4d16a098,
SPID: 101, ECID: 3, Blocking
2004-10-27 09:59:52.31 spid4 Consumer: Xid Slot: 4, EC = 0xbd1d0098,
SPID: 101, ECID: 2, Blocking
2004-10-27 09:59:52.31 spid4 Consumer: Xid Slot: 5, EC = 0xbd3e6098,
SPID: 101, ECID: 1, Blocking
2004-10-27 09:59:52.31 spid4 Producer List::
2004-10-27 09:59:52.31 spid4 Producer: Xid Slot: 0, EC = 0x4d09a098,
SPID: 101, ECID: 6, Not Blocking
2004-10-27 09:59:52.31 spid4 Producer: Xid Slot: 1, EC = 0x4d158098,
SPID: 101, ECID: 4, Not Blocking
2004-10-27 09:59:52.31 spid4 Producer: Xid Slot: 2, EC = 0x4d09e098,
SPID: 101, ECID: 5, Not Blocking
2004-10-27 09:59:52.31 spid4
2004-10-27 09:59:52.31 spid4 -- next branch --
2004-10-27 09:59:52.31 spid4
2004-10-27 09:59:52.31 spid4
2004-10-27 09:59:52.31 spid4 Node:2
2004-10-27 09:59:52.31 spid4 Port: 0x80070380 Xid Slot: 3, EC:
0x4d16a098, ECID: 3 (Consumer), Exchange Wait Type :e_etypeCXPacket
2004-10-27 09:59:52.31 spid4 Coordinator: EC = 0x72281538, SPID: 101,
ECID: 0, Not Blocking
2004-10-27 09:59:52.31 spid4 Consumer List::
2004-10-27 09:59:52.31 spid4 Consumer: Xid Slot: 3, EC = 0x4d16a098,
SPID: 101, ECID: 3, Not Blocking
2004-10-27 09:59:52.31 spid4 Consumer: Xid Slot: 4, EC = 0xbd1d0098,
SPID: 101, ECID: 2, Not Blocking
2004-10-27 09:59:52.31 spid4 Consumer: Xid Slot: 5, EC = 0xbd3e6098,
SPID: 101, ECID: 1, Not Blocking
2004-10-27 09:59:52.31 spid4 Producer List::
2004-10-27 09:59:52.31 spid4 Producer: Xid Slot: 0, EC = 0x4d09a098,
SPID: 101, ECID: 6, Blocking
2004-10-27 09:59:52.31 spid4 Producer: Xid Slot: 1, EC = 0x4d158098,
SPID: 101, ECID: 4, Blocking
2004-10-27 09:59:52.31 spid4 Producer: Xid Slot: 2, EC = 0x4d09e098,
SPID: 101, ECID: 5, Blocking
2004-10-27 09:59:52.31 spid4
2004-10-27 09:59:52.31 spid4 -- next branch --
2004-10-27 09:59:52.31 spid4
2004-10-27 09:59:52.31 spid4
2004-10-27 09:59:52.31 spid4 Node:2
2004-10-27 09:59:52.31 spid4 Port: 0x80070380 Xid Slot: 3, EC:
0x4d16a098, ECID: 3 (Consumer), Exchange Wait Type :e_etypeCXPacket
2004-10-27 09:59:52.31 spid4 Coordinator: EC = 0x72281538, SPID: 101,
ECID: 0, Not Blocking
2004-10-27 09:59:52.31 spid4 Consumer List::
2004-10-27 09:59:52.31 spid4 Consumer: Xid Slot: 3, EC = 0x4d16a098,
SPID: 101, ECID: 3, Not Blocking
2004-10-27 09:59:52.31 spid4 Consumer: Xid Slot: 4, EC = 0xbd1d0098,
SPID: 101, ECID: 2, Not Blocking
2004-10-27 09:59:52.31 spid4 Consumer: Xid Slot: 5, EC = 0xbd3e6098,
SPID: 101, ECID: 1, Not Blocking
2004-10-27 09:59:52.31 spid4 Producer List::
2004-10-27 09:59:52.31 spid4 Producer: Xid Slot: 0, EC = 0x4d09a098,
SPID: 101, ECID: 6, Blocking
2004-10-27 09:59:52.31 spid4 Producer: Xid Slot: 1, EC = 0x4d158098,
SPID: 101, ECID: 4, Blocking
2004-10-27 09:59:52.31 spid4 Producer: Xid Slot: 2, EC = 0x4d09e098,
SPID: 101, ECID: 5, Blocking
2004-10-27 09:59:52.31 spid4
2004-10-27 09:59:52.31 spid4 -- next branch --
2004-10-27 09:59:52.31 spid4
2004-10-27 09:59:52.31 spid4
2004-10-27 09:59:52.31 spid4 Node:2
2004-10-27 09:59:52.31 spid4 Port: 0x80070380 Xid Slot: 3, EC:
0x4d16a098, ECID: 3 (Consumer), Exchange Wait Type :e_etypeCXPacket
2004-10-27 09:59:52.31 spid4 Coordinator: EC = 0x72281538, SPID: 101,
ECID: 0, Not Blocking
2004-10-27 09:59:52.31 spid4 Consumer List::
2004-10-27 09:59:52.31 spid4 Consumer: Xid Slot: 3, EC = 0x4d16a098,
SPID: 101, ECID: 3, Not Blocking
2004-10-27 09:59:52.31 spid4 Consumer: Xid Slot: 4, EC = 0xbd1d0098,
SPID: 101, ECID: 2, Not Blocking
2004-10-27 09:59:52.31 spid4 Consumer: Xid Slot: 5, EC = 0xbd3e6098,
SPID: 101, ECID: 1, Not Blocking
2004-10-27 09:59:52.31 spid4 Producer List::
2004-10-27 09:59:52.31 spid4 Producer: Xid Slot: 0, EC = 0x4d09a098,
SPID: 101, ECID: 6, Blocking
2004-10-27 09:59:52.31 spid4 Producer: Xid Slot: 1, EC = 0x4d158098,
SPID: 101, ECID: 4, Blocking
2004-10-27 09:59:52.31 spid4 Producer: Xid Slot: 2, EC = 0x4d09e098,
SPID: 101, ECID: 5, Blocking
2004-10-27 09:59:52.31 spid4
2004-10-27 09:59:52.31 spid4 -- next branch --
2004-10-27 09:59:52.31 spid4
2004-10-27 09:59:52.31 spid4
2004-10-27 09:59:52.31 spid4 Node:1
2004-10-27 09:59:52.31 spid4 Port: 0x80070e80 Xid Slot: 0, EC:
0x72281538, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeCXPacket
2004-10-27 09:59:52.31 spid4 Coordinator: EC = 0x72281538, SPID: 101,
ECID: 0, Not Blocking
2004-10-27 09:59:52.31 spid4 Consumer List::
2004-10-27 09:59:52.31 spid4 Consumer: Xid Slot: 0, EC = 0x72281538,
SPID: 101, ECID: 0, Not Blocking
2004-10-27 09:59:52.31 spid4 Producer List::
2004-10-27 09:59:52.31 spid4 Producer: Xid Slot: 1, EC = 0x4d16a098,
SPID: 101, ECID: 3, Blocking
2004-10-27 09:59:52.31 spid4 Producer: Xid Slot: 2, EC = 0xbd1d0098,
SPID: 101, ECID: 2, Blocking
2004-10-27 09:59:52.31 spid4 Producer: Xid Slot: 3, EC = 0xbd3e6098,
SPID: 101, ECID: 1, Blocking
2004-10-27 09:59:52.31 spid4
2004-10-27 09:59:52.31 spid4 -- next branch --
2004-10-27 09:59:52.31 spid4
2004-10-27 09:59:52.31 spid4
2004-10-27 09:59:52.31 spid4 Node:1
2004-10-27 09:59:52.31 spid4 Port: 0x80070e80 Xid Slot: 0, EC:
0x72281538, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeCXPacket
2004-10-27 09:59:52.31 spid4 Coordinator: EC = 0x72281538, SPID: 101,
ECID: 0, Not Blocking
2004-10-27 09:59:52.31 spid4 Consumer List::
2004-10-27 09:59:52.31 spid4 Consumer: Xid Slot: 0, EC = 0x72281538,
SPID: 101, ECID: 0, Not Blocking
2004-10-27 09:59:52.31 spid4 Producer List::
2004-10-27 09:59:52.31 spid4 Producer: Xid Slot: 1, EC = 0x4d16a098,
SPID: 101, ECID: 3, Blocking
2004-10-27 09:59:52.31 spid4 Producer: Xid Slot: 2, EC = 0xbd1d0098,
SPID: 101, ECID: 2, Blocking
2004-10-27 09:59:52.31 spid4 Producer: Xid Slot: 3, EC = 0xbd3e6098,
SPID: 101, ECID: 1, Blocking
2004-10-27 09:59:52.31 spid4
2004-10-27 09:59:52.31 spid4 -- next branch --
2004-10-27 09:59:52.31 spid4
2004-10-27 09:59:52.31 spid4
2004-10-27 09:59:52.31 spid4 Node:1
2004-10-27 09:59:52.31 spid4 Port: 0x80070e80 Xid Slot: 0, EC:
0x72281538, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeCXPacket
2004-10-27 09:59:52.31 spid4 Coordinator: EC = 0x72281538, SPID: 101,
ECID: 0, Not Blocking
2004-10-27 09:59:52.31 spid4 Consumer List::
2004-10-27 09:59:52.31 spid4 Consumer: Xid Slot: 0, EC = 0x72281538,
SPID: 101, ECID: 0, Not Blocking
2004-10-27 09:59:52.31 spid4 Producer List::
2004-10-27 09:59:52.31 spid4 Producer: Xid Slot: 1, EC = 0x4d16a098,
SPID: 101, ECID: 3, Blocking
2004-10-27 09:59:52.31 spid4 Producer: Xid Slot: 2, EC = 0xbd1d0098,
SPID: 101, ECID: 2, Blocking
2004-10-27 09:59:52.31 spid4 Producer: Xid Slot: 3, EC = 0xbd3e6098,
SPID: 101, ECID: 1, Blocking
2004-10-27 09:59:52.31 spid4 Victim Resource Owner:
2004-10-27 09:59:52.31 spid4 ResType:PageSupp Stype:'OR' SPID:101
ECID:5 Ec:(0x4D09E098) Value:0x4d09e098 Cost:(0/2710)
2004-10-27 10:05:37.68 spid93 DBCC TRACEON 208, server process ID (SPID)
93.
2004-10-27 10:05:39.04 spid97 DBCC TRACEON 208, server process ID (SPID)
97.
2004-10-27 10:14:01.37 spid58 DBCC TRACEON 208, server process ID (SPID)
58.
2004-10-27 10:14:20.71 spid84 DBCC TRACEON 208, server process ID (SPID)
84.
2004-10-27 10:19:14.24 spid64 DBCC TRACEON 208, server process ID (SPID)
64.

Any clue?

TIA,

Roberto de Souza Santos.

Next message: Peter The Spate: "Re: How to tell how much memory is actually needed by my SQL Server 2000??"
Previous message: Neil: "archiving"
Messages sorted by: [ date ] [ thread ]

Relevant Pages

Dead Lock Again
... 2005-02-06 13:01:50.71 server All rights reserved. ... ECID: 0, Not Blocking ... SPID: 53, ECID: 7, Blocking ...
(microsoft.public.sqlserver.programming)
deadlock when reading most currently inserted records
... Mode: IX Flags: 0x2 ... Printing deadlock information ... SPID: 53, ECID: 0, Not Blocking ...
(microsoft.public.sqlserver.programming)
Identify problem in Error Log
... hung. ... SPID 133, ECID 0, UMS Context 0x063C15B0. ...
(microsoft.public.sqlserver.server)
Re: Transaction reaches commit :- but blocks
... > The app has a number of connections to the database. ... > first app generates a transaction, ... Note the spid that handled the inserts for the first ... > tx is not in the blocking chain and does not seem to cause this. ...
(microsoft.public.sqlserver.server)
RE: Alert for Blocked Process?
... "Blocking" as such is not a bad thing. ... Server is given a 'spid'. ... status, waittime and waittype. ... Microsoft, SQL Server ...
(microsoft.public.sqlserver.server)