Consulta Salida Deadlock

06/09/2006 - 20:25 por Pao | Informe spam
Hola a todos. Estoy revisando mi motor SQLServer y tengo unos bloqueos que se
han estado dando algo frecuente:
SQLServer2000 con sp3a sobre windows 2003.

Lo que quisera saber es como me doy cuenta de los objetos o tablas
involucradas y donde debo correr el comando, he visto que se puede usar el
DBCC Page pero cuando lo quiero usar no me vota nada.
Nodo 2
PAG: 5:1:60507
DBCC PAGE(5,1,60507,1)
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.

Para el Nodo 1 tengo esto que significa Port: 0x19838280


Por otro lado la salida que me presenta este deadlock es difernte porque
tiene varios nodos, algo de lo que vi es que esto es una salida de deadlock
con paralelismo...
Agradecería que me ayuden a despejar mis dudas.Gracias.

Deadlock encountered Printing deadlock information
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3 Wait-for graph
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3 Node:1
2006-08-22 17:05:07.73 spid3 Port: 0x19838280 Xid Slot: -1, EC:
0x54b83508, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeClose
2006-08-22 17:05:07.73 spid3 SPID: 81 ECID: 0 Statement Type: SELECT
INTO Line #: 1
2006-08-22 17:05:07.73 spid3 Input Buf: Language Event: EXEC
SP_S_GET_GESTION 'tbcob_bresults', 9,'2006-08-22',28, 1
2006-08-22 17:05:07.73 spid3 Coordinator: EC = 0x54b83508, SPID: 81,
ECID: 0, Not Blocking
2006-08-22 17:05:07.73 spid3 Consumer List::
2006-08-22 17:05:07.73 spid3 Consumer: Xid Slot: 1, EC = 0x54ca6098,
SPID: 81, ECID: 7, Blocking
2006-08-22 17:05:07.73 spid3 Consumer: Xid Slot: 3, EC = 0x548b8098,
SPID: 81, ECID: 8, Blocking
2006-08-22 17:05:07.73 spid3 Producer List::
2006-08-22 17:05:07.73 spid3 Producer: Xid Slot: 0, EC = 0x54cb0098,
SPID: 81, ECID: 10, Blocking
2006-08-22 17:05:07.73 spid3 Producer: Xid Slot: 2, EC = 0x548b2098,
SPID: 81, ECID: 9, Blocking
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3 Node:2
2006-08-22 17:05:07.73 spid3 PAG: 5:1:60507 CleanCnt:2
Mode: IX Flags: 0x0
2006-08-22 17:05:07.73 spid3 Wait List:
2006-08-22 17:05:07.73 spid3 Owner:0x4abc0900 Mode: S Flg:0x0
Ref:1 Life:00000000 SPID:81 ECID:9
2006-08-22 17:05:07.73 spid3 Requested By:
2006-08-22 17:05:07.73 spid3 ResType:LockOwner Stype:'OR' Mode: S
SPID:81 ECID:10 Ec:(0x54CB0098) Value:0x36547520 Cost:(0/0)
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3 Node:3
2006-08-22 17:05:07.73 spid3 PAG: 5:1:60507 CleanCnt:2
Mode: IX Flags: 0x0
2006-08-22 17:05:07.73 spid3 Grant List 1::
2006-08-22 17:05:07.73 spid3 Owner:0x46e1a8c0 Mode: IX Flg:0x0
Ref:0 Life:02000000 SPID:83 ECID:0
2006-08-22 17:05:07.73 spid3 SPID: 83 ECID: 0 Statement Type: INSERT
Line #: 1
2006-08-22 17:05:07.73 spid3 Input Buf: Language Event: INSERT INTO
tbsma_call_log
( campaign, start_time, agent, extension, contact_id, doc_number,
comments, navegation, ph_number, dnis, app_ref_id )
VALUES ( 11, getdate(), 42, '15', 1180,
NULL, 'Call log start...', '', '042801803', '', 14
2006-08-22 17:05:07.73 spid3 Requested By:
2006-08-22 17:05:07.73 spid3 ResType:LockOwner Stype:'OR' Mode: S
SPID:81 ECID:9 Ec:(0x548B2098) Value:0x4abc0900 Cost:(0/0)
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3 Node:4
2006-08-22 17:05:07.73 spid3 PAG: 5:1:60261 CleanCnt:1
Mode: S Flags: 0x2
2006-08-22 17:05:07.73 spid3 Grant List 0::
2006-08-22 17:05:07.73 spid3 Owner:0x5259b9c0 Mode: S Flg:0x0
Ref:1 Life:00000000 SPID:81 ECID:0
2006-08-22 17:05:07.73 spid3 Requested By:
2006-08-22 17:05:07.73 spid3 ResType:LockOwner Stype:'OR' Mode: IX
SPID:83 ECID:0 Ec:(0x54309530) Value:0x478be3a0 Cost:(0/1BC)
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3 -- next branch --
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3 Node:1
2006-08-22 17:05:07.73 spid3 Port: 0x19838280 Xid Slot: -1, EC:
0x54b83508, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeClose
2006-08-22 17:05:07.73 spid3 Coordinator: EC = 0x54b83508, SPID: 81,
ECID: 0, Not Blocking
2006-08-22 17:05:07.73 spid3 Consumer List::
2006-08-22 17:05:07.73 spid3 Consumer: Xid Slot: 1, EC = 0x54ca6098,
SPID: 81, ECID: 7, Blocking
2006-08-22 17:05:07.73 spid3 Consumer: Xid Slot: 3, EC = 0x548b8098,
SPID: 81, ECID: 8, Blocking
2006-08-22 17:05:07.73 spid3 Producer List::
2006-08-22 17:05:07.73 spid3 Producer: Xid Slot: 0, EC = 0x54cb0098,
SPID: 81, ECID: 10, Blocking
2006-08-22 17:05:07.73 spid3 Producer: Xid Slot: 2, EC = 0x548b2098,
SPID: 81, ECID: 9, Blocking
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3 Node:7
2006-08-22 17:05:07.73 spid3 Port: 0x19838280 Xid Slot: 1, EC:
0x54ca6098, ECID: 7 (Consumer), Exchange Wait Type :e_etypeCXPacket
2006-08-22 17:05:07.73 spid3 Coordinator: EC = 0x54b83508, SPID: 81,
ECID: 0, Not Blocking
2006-08-22 17:05:07.73 spid3 Consumer List::
2006-08-22 17:05:07.73 spid3 Consumer: Xid Slot: 1, EC = 0x54ca6098,
SPID: 81, ECID: 7, Not Blocking
2006-08-22 17:05:07.73 spid3 Consumer: Xid Slot: 3, EC = 0x548b8098,
SPID: 81, ECID: 8, Not Blocking
2006-08-22 17:05:07.73 spid3 Producer List::
2006-08-22 17:05:07.73 spid3 Producer: Xid Slot: 0, EC = 0x54cb0098,
SPID: 81, ECID: 10, Blocking
2006-08-22 17:05:07.73 spid3 Producer: Xid Slot: 2, EC = 0x548b2098,
SPID: 81, ECID: 9, Blocking
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3 -- next branch --
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3 Node:7
2006-08-22 17:05:07.73 spid3 Port: 0x19838280 Xid Slot: 1, EC:
0x54ca6098, ECID: 7 (Consumer), Exchange Wait Type :e_etypeCXPacket
2006-08-22 17:05:07.73 spid3 Coordinator: EC = 0x54b83508, SPID: 81,
ECID: 0, Not Blocking
2006-08-22 17:05:07.73 spid3 Consumer List::
2006-08-22 17:05:07.73 spid3 Consumer: Xid Slot: 1, EC = 0x54ca6098,
SPID: 81, ECID: 7, Not Blocking
2006-08-22 17:05:07.73 spid3 Consumer: Xid Slot: 3, EC = 0x548b8098,
SPID: 81, ECID: 8, Not Blocking
2006-08-22 17:05:07.73 spid3 Producer List::
2006-08-22 17:05:07.73 spid3 Producer: Xid Slot: 0, EC = 0x54cb0098,
SPID: 81, ECID: 10, Blocking
2006-08-22 17:05:07.73 spid3 Producer: Xid Slot: 2, EC = 0x548b2098,
SPID: 81, ECID: 9, Blocking
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3 -- next branch --
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3 Node:7
2006-08-22 17:05:07.73 spid3 Port: 0x19838280 Xid Slot: 1, EC:
0x54ca6098, ECID: 7 (Consumer), Exchange Wait Type :e_etypeCXPacket
2006-08-22 17:05:07.73 spid3 Coordinator: EC = 0x54b83508, SPID: 81,
ECID: 0, Not Blocking
2006-08-22 17:05:07.73 spid3 Consumer List::
2006-08-22 17:05:07.73 spid3 Consumer: Xid Slot: 1, EC = 0x54ca6098,
SPID: 81, ECID: 7, Not Blocking
2006-08-22 17:05:07.73 spid3 Consumer: Xid Slot: 3, EC = 0x548b8098,
SPID: 81, ECID: 8, Not Blocking
2006-08-22 17:05:07.73 spid3 Producer List::
2006-08-22 17:05:07.73 spid3 Producer: Xid Slot: 0, EC = 0x54cb0098,
SPID: 81, ECID: 10, Blocking
2006-08-22 17:05:07.73 spid3 Producer: Xid Slot: 2, EC = 0x548b2098,
SPID: 81, ECID: 9, Blocking
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3 -- next branch --
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3 Node:1
2006-08-22 17:05:07.73 spid3 Port: 0x19838280 Xid Slot: -1, EC:
0x54b83508, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeClose
2006-08-22 17:05:07.73 spid3 Coordinator: EC = 0x54b83508, SPID: 81,
ECID: 0, Not Blocking
2006-08-22 17:05:07.73 spid3 Consumer List::
2006-08-22 17:05:07.73 spid3 Consumer: Xid Slot: 1, EC = 0x54ca6098,
SPID: 81, ECID: 7, Blocking
2006-08-22 17:05:07.73 spid3 Consumer: Xid Slot: 3, EC = 0x548b8098,
SPID: 81, ECID: 8, Blocking
2006-08-22 17:05:07.73 spid3 Producer List::
2006-08-22 17:05:07.73 spid3 Producer: Xid Slot: 0, EC = 0x54cb0098,
SPID: 81, ECID: 10, Blocking
2006-08-22 17:05:07.73 spid3 Producer: Xid Slot: 2, EC = 0x548b2098,
SPID: 81, ECID: 9, Blocking
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3 -- next branch --
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3 Node:1
2006-08-22 17:05:07.73 spid3 Port: 0x19838280 Xid Slot: -1, EC:
0x54b83508, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeClose
2006-08-22 17:05:07.73 spid3 Coordinator: EC = 0x54b83508, SPID: 81,
ECID: 0, Not Blocking
2006-08-22 17:05:07.73 spid3 Consumer List::
2006-08-22 17:05:07.73 spid3 Consumer: Xid Slot: 1, EC = 0x54ca6098,
SPID: 81, ECID: 7, Blocking
2006-08-22 17:05:07.73 spid3 Consumer: Xid Slot: 3, EC = 0x548b8098,
SPID: 81, ECID: 8, Blocking
2006-08-22 17:05:07.73 spid3 Producer List::
2006-08-22 17:05:07.73 spid3 Producer: Xid Slot: 0, EC = 0x54cb0098,
SPID: 81, ECID: 10, Blocking
2006-08-22 17:05:07.73 spid3 Producer: Xid Slot: 2, EC = 0x548b2098,
SPID: 81, ECID: 9, Blocking
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3 Node:15
2006-08-22 17:05:07.73 spid3 Port: 0x19838280 Xid Slot: 3, EC:
0x548b8098, ECID: 8 (Consumer), Exchange Wait Type :e_etypeCXPacket
2006-08-22 17:05:07.73 spid3 Coordinator: EC = 0x54b83508, SPID: 81,
ECID: 0, Not Blocking
2006-08-22 17:05:07.73 spid3 Consumer List::
2006-08-22 17:05:07.73 spid3 Consumer: Xid Slot: 1, EC = 0x54ca6098,
SPID: 81, ECID: 7, Not Blocking
2006-08-22 17:05:07.73 spid3 Consumer: Xid Slot: 3, EC = 0x548b8098,
SPID: 81, ECID: 8, Not Blocking
2006-08-22 17:05:07.73 spid3 Producer List::
2006-08-22 17:05:07.73 spid3 Producer: Xid Slot: 0, EC = 0x54cb0098,
SPID: 81, ECID: 10, Blocking
2006-08-22 17:05:07.73 spid3 Producer: Xid Slot: 2, EC = 0x548b2098,
SPID: 81, ECID: 9, Blocking
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3 -- next branch --
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3 Node:15
2006-08-22 17:05:07.73 spid3 Port: 0x19838280 Xid Slot: 3, EC:
0x548b8098, ECID: 8 (Consumer), Exchange Wait Type :e_etypeCXPacket
2006-08-22 17:05:07.73 spid3 Coordinator: EC = 0x54b83508, SPID: 81,
ECID: 0, Not Blocking
2006-08-22 17:05:07.73 spid3 Consumer List::
2006-08-22 17:05:07.73 spid3 Consumer: Xid Slot: 1, EC = 0x54ca6098,
SPID: 81, ECID: 7, Not Blocking
2006-08-22 17:05:07.73 spid3 Consumer: Xid Slot: 3, EC = 0x548b8098,
SPID: 81, ECID: 8, Not Blocking
2006-08-22 17:05:07.73 spid3 Producer List::
2006-08-22 17:05:07.73 spid3 Producer: Xid Slot: 0, EC = 0x54cb0098,
SPID: 81, ECID: 10, Blocking
2006-08-22 17:05:07.73 spid3 Producer: Xid Slot: 2, EC = 0x548b2098,
SPID: 81, ECID: 9, Blocking
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3 -- next branch --
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3 Node:15
2006-08-22 17:05:07.73 spid3 Port: 0x19838280 Xid Slot: 3, EC:
0x548b8098, ECID: 8 (Consumer), Exchange Wait Type :e_etypeCXPacket
2006-08-22 17:05:07.73 spid3 Coordinator: EC = 0x54b83508, SPID: 81,
ECID: 0, Not Blocking
2006-08-22 17:05:07.73 spid3 Consumer List::
2006-08-22 17:05:07.73 spid3 Consumer: Xid Slot: 1, EC = 0x54ca6098,
SPID: 81, ECID: 7, Not Blocking
2006-08-22 17:05:07.73 spid3 Consumer: Xid Slot: 3, EC = 0x548b8098,
SPID: 81, ECID: 8, Not Blocking
2006-08-22 17:05:07.73 spid3 Producer List::
2006-08-22 17:05:07.73 spid3 Producer: Xid Slot: 0, EC = 0x54cb0098,
SPID: 81, ECID: 10, Blocking
2006-08-22 17:05:07.73 spid3 Producer: Xid Slot: 2, EC = 0x548b2098,
SPID: 81, ECID: 9, Blocking
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3 -- next branch --
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3 Node:1
2006-08-22 17:05:07.73 spid3 Port: 0x19838280 Xid Slot: -1, EC:
0x54b83508, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeClose
2006-08-22 17:05:07.73 spid3 Coordinator: EC = 0x54b83508, SPID: 81,
ECID: 0, Not Blocking
2006-08-22 17:05:07.73 spid3 Consumer List::
2006-08-22 17:05:07.73 spid3 Consumer: Xid Slot: 1, EC = 0x54ca6098,
SPID: 81, ECID: 7, Blocking
2006-08-22 17:05:07.73 spid3 Consumer: Xid Slot: 3, EC = 0x548b8098,
SPID: 81, ECID: 8, Blocking
2006-08-22 17:05:07.73 spid3 Producer List::
2006-08-22 17:05:07.73 spid3 Producer: Xid Slot: 0, EC = 0x54cb0098,
SPID: 81, ECID: 10, Blocking
2006-08-22 17:05:07.73 spid3 Producer: Xid Slot: 2, EC = 0x548b2098,
SPID: 81, ECID: 9, Blocking
2006-08-22 17:05:07.73 spid3 Victim Resource Owner:
2006-08-22 17:05:07.73 spid3 ResType:LockOwner Stype:'OR' Mode: S
SPID:81 ECID:9 Ec:(0x548B2098) Value:0x4abc0900 Cost:(0/0)
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3 End deadlock search 8560 ... a deadlock was
found.
2006-08-22 17:05:07.73 spid3 -
 

Leer las respuestas

#1 Isaias
06/09/2006 - 20:32 | Informe spam
Pao

Miguel Egea, que anda de vacaciones, nos sugiere un proceso para CAZAR a los
procesos bloqueadores:

http://www.configuracionesintegrale...articulo%6

Lo mas rapido es ejecutar en tu analizador de consultas:

DBCC OPENTRAN

Eso te dara que transaccion esta abierta y por cuanto tiempo.
Saludos
IIslas


"Pao" wrote:

Hola a todos. Estoy revisando mi motor SQLServer y tengo unos bloqueos que se
han estado dando algo frecuente:
SQLServer2000 con sp3a sobre windows 2003.

Lo que quisera saber es como me doy cuenta de los objetos o tablas
involucradas y donde debo correr el comando, he visto que se puede usar el
DBCC Page pero cuando lo quiero usar no me vota nada.
Nodo 2
PAG: 5:1:60507
DBCC PAGE(5,1,60507,1)
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.

Para el Nodo 1 tengo esto que significa Port: 0x19838280


Por otro lado la salida que me presenta este deadlock es difernte porque
tiene varios nodos, algo de lo que vi es que esto es una salida de deadlock
con paralelismo...
Agradecería que me ayuden a despejar mis dudas.Gracias.

Deadlock encountered Printing deadlock information
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3 Wait-for graph
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3 Node:1
2006-08-22 17:05:07.73 spid3 Port: 0x19838280 Xid Slot: -1, EC:
0x54b83508, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeClose
2006-08-22 17:05:07.73 spid3 SPID: 81 ECID: 0 Statement Type: SELECT
INTO Line #: 1
2006-08-22 17:05:07.73 spid3 Input Buf: Language Event: EXEC
SP_S_GET_GESTION 'tbcob_bresults', 9,'2006-08-22',28, 1
2006-08-22 17:05:07.73 spid3 Coordinator: EC = 0x54b83508, SPID: 81,
ECID: 0, Not Blocking
2006-08-22 17:05:07.73 spid3 Consumer List::
2006-08-22 17:05:07.73 spid3 Consumer: Xid Slot: 1, EC = 0x54ca6098,
SPID: 81, ECID: 7, Blocking
2006-08-22 17:05:07.73 spid3 Consumer: Xid Slot: 3, EC = 0x548b8098,
SPID: 81, ECID: 8, Blocking
2006-08-22 17:05:07.73 spid3 Producer List::
2006-08-22 17:05:07.73 spid3 Producer: Xid Slot: 0, EC = 0x54cb0098,
SPID: 81, ECID: 10, Blocking
2006-08-22 17:05:07.73 spid3 Producer: Xid Slot: 2, EC = 0x548b2098,
SPID: 81, ECID: 9, Blocking
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3 Node:2
2006-08-22 17:05:07.73 spid3 PAG: 5:1:60507 CleanCnt:2
Mode: IX Flags: 0x0
2006-08-22 17:05:07.73 spid3 Wait List:
2006-08-22 17:05:07.73 spid3 Owner:0x4abc0900 Mode: S Flg:0x0
Ref:1 Life:00000000 SPID:81 ECID:9
2006-08-22 17:05:07.73 spid3 Requested By:
2006-08-22 17:05:07.73 spid3 ResType:LockOwner Stype:'OR' Mode: S
SPID:81 ECID:10 Ec:(0x54CB0098) Value:0x36547520 Cost:(0/0)
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3 Node:3
2006-08-22 17:05:07.73 spid3 PAG: 5:1:60507 CleanCnt:2
Mode: IX Flags: 0x0
2006-08-22 17:05:07.73 spid3 Grant List 1::
2006-08-22 17:05:07.73 spid3 Owner:0x46e1a8c0 Mode: IX Flg:0x0
Ref:0 Life:02000000 SPID:83 ECID:0
2006-08-22 17:05:07.73 spid3 SPID: 83 ECID: 0 Statement Type: INSERT
Line #: 1
2006-08-22 17:05:07.73 spid3 Input Buf: Language Event: INSERT INTO
tbsma_call_log
( campaign, start_time, agent, extension, contact_id, doc_number,
comments, navegation, ph_number, dnis, app_ref_id )
VALUES ( 11, getdate(), 42, '15', 1180,
NULL, 'Call log start...', '', '042801803', '', 14
2006-08-22 17:05:07.73 spid3 Requested By:
2006-08-22 17:05:07.73 spid3 ResType:LockOwner Stype:'OR' Mode: S
SPID:81 ECID:9 Ec:(0x548B2098) Value:0x4abc0900 Cost:(0/0)
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3 Node:4
2006-08-22 17:05:07.73 spid3 PAG: 5:1:60261 CleanCnt:1
Mode: S Flags: 0x2
2006-08-22 17:05:07.73 spid3 Grant List 0::
2006-08-22 17:05:07.73 spid3 Owner:0x5259b9c0 Mode: S Flg:0x0
Ref:1 Life:00000000 SPID:81 ECID:0
2006-08-22 17:05:07.73 spid3 Requested By:
2006-08-22 17:05:07.73 spid3 ResType:LockOwner Stype:'OR' Mode: IX
SPID:83 ECID:0 Ec:(0x54309530) Value:0x478be3a0 Cost:(0/1BC)
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3 -- next branch --
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3 Node:1
2006-08-22 17:05:07.73 spid3 Port: 0x19838280 Xid Slot: -1, EC:
0x54b83508, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeClose
2006-08-22 17:05:07.73 spid3 Coordinator: EC = 0x54b83508, SPID: 81,
ECID: 0, Not Blocking
2006-08-22 17:05:07.73 spid3 Consumer List::
2006-08-22 17:05:07.73 spid3 Consumer: Xid Slot: 1, EC = 0x54ca6098,
SPID: 81, ECID: 7, Blocking
2006-08-22 17:05:07.73 spid3 Consumer: Xid Slot: 3, EC = 0x548b8098,
SPID: 81, ECID: 8, Blocking
2006-08-22 17:05:07.73 spid3 Producer List::
2006-08-22 17:05:07.73 spid3 Producer: Xid Slot: 0, EC = 0x54cb0098,
SPID: 81, ECID: 10, Blocking
2006-08-22 17:05:07.73 spid3 Producer: Xid Slot: 2, EC = 0x548b2098,
SPID: 81, ECID: 9, Blocking
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3 Node:7
2006-08-22 17:05:07.73 spid3 Port: 0x19838280 Xid Slot: 1, EC:
0x54ca6098, ECID: 7 (Consumer), Exchange Wait Type :e_etypeCXPacket
2006-08-22 17:05:07.73 spid3 Coordinator: EC = 0x54b83508, SPID: 81,
ECID: 0, Not Blocking
2006-08-22 17:05:07.73 spid3 Consumer List::
2006-08-22 17:05:07.73 spid3 Consumer: Xid Slot: 1, EC = 0x54ca6098,
SPID: 81, ECID: 7, Not Blocking
2006-08-22 17:05:07.73 spid3 Consumer: Xid Slot: 3, EC = 0x548b8098,
SPID: 81, ECID: 8, Not Blocking
2006-08-22 17:05:07.73 spid3 Producer List::
2006-08-22 17:05:07.73 spid3 Producer: Xid Slot: 0, EC = 0x54cb0098,
SPID: 81, ECID: 10, Blocking
2006-08-22 17:05:07.73 spid3 Producer: Xid Slot: 2, EC = 0x548b2098,
SPID: 81, ECID: 9, Blocking
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3 -- next branch --
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3 Node:7
2006-08-22 17:05:07.73 spid3 Port: 0x19838280 Xid Slot: 1, EC:
0x54ca6098, ECID: 7 (Consumer), Exchange Wait Type :e_etypeCXPacket
2006-08-22 17:05:07.73 spid3 Coordinator: EC = 0x54b83508, SPID: 81,
ECID: 0, Not Blocking
2006-08-22 17:05:07.73 spid3 Consumer List::
2006-08-22 17:05:07.73 spid3 Consumer: Xid Slot: 1, EC = 0x54ca6098,
SPID: 81, ECID: 7, Not Blocking
2006-08-22 17:05:07.73 spid3 Consumer: Xid Slot: 3, EC = 0x548b8098,
SPID: 81, ECID: 8, Not Blocking
2006-08-22 17:05:07.73 spid3 Producer List::
2006-08-22 17:05:07.73 spid3 Producer: Xid Slot: 0, EC = 0x54cb0098,
SPID: 81, ECID: 10, Blocking
2006-08-22 17:05:07.73 spid3 Producer: Xid Slot: 2, EC = 0x548b2098,
SPID: 81, ECID: 9, Blocking
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3 -- next branch --
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3 Node:7
2006-08-22 17:05:07.73 spid3 Port: 0x19838280 Xid Slot: 1, EC:
0x54ca6098, ECID: 7 (Consumer), Exchange Wait Type :e_etypeCXPacket
2006-08-22 17:05:07.73 spid3 Coordinator: EC = 0x54b83508, SPID: 81,
ECID: 0, Not Blocking
2006-08-22 17:05:07.73 spid3 Consumer List::
2006-08-22 17:05:07.73 spid3 Consumer: Xid Slot: 1, EC = 0x54ca6098,
SPID: 81, ECID: 7, Not Blocking
2006-08-22 17:05:07.73 spid3 Consumer: Xid Slot: 3, EC = 0x548b8098,
SPID: 81, ECID: 8, Not Blocking
2006-08-22 17:05:07.73 spid3 Producer List::
2006-08-22 17:05:07.73 spid3 Producer: Xid Slot: 0, EC = 0x54cb0098,
SPID: 81, ECID: 10, Blocking
2006-08-22 17:05:07.73 spid3 Producer: Xid Slot: 2, EC = 0x548b2098,
SPID: 81, ECID: 9, Blocking
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3 -- next branch --
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3 Node:1
2006-08-22 17:05:07.73 spid3 Port: 0x19838280 Xid Slot: -1, EC:
0x54b83508, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeClose
2006-08-22 17:05:07.73 spid3 Coordinator: EC = 0x54b83508, SPID: 81,
ECID: 0, Not Blocking
2006-08-22 17:05:07.73 spid3 Consumer List::
2006-08-22 17:05:07.73 spid3 Consumer: Xid Slot: 1, EC = 0x54ca6098,
SPID: 81, ECID: 7, Blocking
2006-08-22 17:05:07.73 spid3 Consumer: Xid Slot: 3, EC = 0x548b8098,
SPID: 81, ECID: 8, Blocking
2006-08-22 17:05:07.73 spid3 Producer List::
2006-08-22 17:05:07.73 spid3 Producer: Xid Slot: 0, EC = 0x54cb0098,
SPID: 81, ECID: 10, Blocking
2006-08-22 17:05:07.73 spid3 Producer: Xid Slot: 2, EC = 0x548b2098,
SPID: 81, ECID: 9, Blocking
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3 -- next branch --
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3 Node:1
2006-08-22 17:05:07.73 spid3 Port: 0x19838280 Xid Slot: -1, EC:
0x54b83508, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeClose
2006-08-22 17:05:07.73 spid3 Coordinator: EC = 0x54b83508, SPID: 81,
ECID: 0, Not Blocking
2006-08-22 17:05:07.73 spid3 Consumer List::
2006-08-22 17:05:07.73 spid3 Consumer: Xid Slot: 1, EC = 0x54ca6098,
SPID: 81, ECID: 7, Blocking
2006-08-22 17:05:07.73 spid3 Consumer: Xid Slot: 3, EC = 0x548b8098,
SPID: 81, ECID: 8, Blocking
2006-08-22 17:05:07.73 spid3 Producer List::
2006-08-22 17:05:07.73 spid3 Producer: Xid Slot: 0, EC = 0x54cb0098,
SPID: 81, ECID: 10, Blocking
2006-08-22 17:05:07.73 spid3 Producer: Xid Slot: 2, EC = 0x548b2098,
SPID: 81, ECID: 9, Blocking
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3 Node:15
2006-08-22 17:05:07.73 spid3 Port: 0x19838280 Xid Slot: 3, EC:
0x548b8098, ECID: 8 (Consumer), Exchange Wait Type :e_etypeCXPacket
2006-08-22 17:05:07.73 spid3 Coordinator: EC = 0x54b83508, SPID: 81,
ECID: 0, Not Blocking
2006-08-22 17:05:07.73 spid3 Consumer List::
2006-08-22 17:05:07.73 spid3 Consumer: Xid Slot: 1, EC = 0x54ca6098,
SPID: 81, ECID: 7, Not Blocking
2006-08-22 17:05:07.73 spid3 Consumer: Xid Slot: 3, EC = 0x548b8098,
SPID: 81, ECID: 8, Not Blocking
2006-08-22 17:05:07.73 spid3 Producer List::
2006-08-22 17:05:07.73 spid3 Producer: Xid Slot: 0, EC = 0x54cb0098,
SPID: 81, ECID: 10, Blocking
2006-08-22 17:05:07.73 spid3 Producer: Xid Slot: 2, EC = 0x548b2098,
SPID: 81, ECID: 9, Blocking
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3 -- next branch --
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3 Node:15
2006-08-22 17:05:07.73 spid3 Port: 0x19838280 Xid Slot: 3, EC:
0x548b8098, ECID: 8 (Consumer), Exchange Wait Type :e_etypeCXPacket
2006-08-22 17:05:07.73 spid3 Coordinator: EC = 0x54b83508, SPID: 81,
ECID: 0, Not Blocking
2006-08-22 17:05:07.73 spid3 Consumer List::
2006-08-22 17:05:07.73 spid3 Consumer: Xid Slot: 1, EC = 0x54ca6098,
SPID: 81, ECID: 7, Not Blocking
2006-08-22 17:05:07.73 spid3 Consumer: Xid Slot: 3, EC = 0x548b8098,
SPID: 81, ECID: 8, Not Blocking
2006-08-22 17:05:07.73 spid3 Producer List::
2006-08-22 17:05:07.73 spid3 Producer: Xid Slot: 0, EC = 0x54cb0098,
SPID: 81, ECID: 10, Blocking
2006-08-22 17:05:07.73 spid3 Producer: Xid Slot: 2, EC = 0x548b2098,
SPID: 81, ECID: 9, Blocking
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3 -- next branch --
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3 Node:15
2006-08-22 17:05:07.73 spid3 Port: 0x19838280 Xid Slot: 3, EC:
0x548b8098, ECID: 8 (Consumer), Exchange Wait Type :e_etypeCXPacket
2006-08-22 17:05:07.73 spid3 Coordinator: EC = 0x54b83508, SPID: 81,
ECID: 0, Not Blocking
2006-08-22 17:05:07.73 spid3 Consumer List::
2006-08-22 17:05:07.73 spid3 Consumer: Xid Slot: 1, EC = 0x54ca6098,
SPID: 81, ECID: 7, Not Blocking
2006-08-22 17:05:07.73 spid3 Consumer: Xid Slot: 3, EC = 0x548b8098,
SPID: 81, ECID: 8, Not Blocking
2006-08-22 17:05:07.73 spid3 Producer List::
2006-08-22 17:05:07.73 spid3 Producer: Xid Slot: 0, EC = 0x54cb0098,
SPID: 81, ECID: 10, Blocking
2006-08-22 17:05:07.73 spid3 Producer: Xid Slot: 2, EC = 0x548b2098,
SPID: 81, ECID: 9, Blocking
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3 -- next branch --
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3 Node:1
2006-08-22 17:05:07.73 spid3 Port: 0x19838280 Xid Slot: -1, EC:
0x54b83508, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeClose
2006-08-22 17:05:07.73 spid3 Coordinator: EC = 0x54b83508, SPID: 81,
ECID: 0, Not Blocking
2006-08-22 17:05:07.73 spid3 Consumer List::
2006-08-22 17:05:07.73 spid3 Consumer: Xid Slot: 1, EC = 0x54ca6098,
SPID: 81, ECID: 7, Blocking
2006-08-22 17:05:07.73 spid3 Consumer: Xid Slot: 3, EC = 0x548b8098,
SPID: 81, ECID: 8, Blocking
2006-08-22 17:05:07.73 spid3 Producer List::
2006-08-22 17:05:07.73 spid3 Producer: Xid Slot: 0, EC = 0x54cb0098,
SPID: 81, ECID: 10, Blocking
2006-08-22 17:05:07.73 spid3 Producer: Xid Slot: 2, EC = 0x548b2098,
SPID: 81, ECID: 9, Blocking
2006-08-22 17:05:07.73 spid3 Victim Resource Owner:
2006-08-22 17:05:07.73 spid3 ResType:LockOwner Stype:'OR' Mode: S
SPID:81 ECID:9 Ec:(0x548B2098) Value:0x4abc0900 Cost:(0/0)
2006-08-22 17:05:07.73 spid3
2006-08-22 17:05:07.73 spid3 End deadlock search 8560 ... a deadlock was
found.
2006-08-22 17:05:07.73 spid3 -

Preguntas similares