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 -

Siga el debate

2 respuestas

Tengo una respuesta

Preguntas similare

Mostrar todos los temas similares

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 -

Responder a este mensaje

#2 Alejandro Mesa

06/09/2006 - 20:47 | Informe spam

Pao,

Lo que pasa es que no estas usando los parametros correctamente.

Nodo 2
PAG: 5:1:60507
DBCC PAGE(5,1,60507,1)

La linea PAG: 5:1:60507, indica que la pagina pertence al la db 5, objeto 1,
pagina # 60507, por lo que el comando dbcc debera ser:

dbcc (5, 60507, 1)

AMB

"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 -

Siga el debate Respuesta

Responder a este mensaje

Ads by Google

Hacer una pregunta

Tengo una respuesta

Busqueda sugerida