February 14, 2008 at 6:47 am
Hy guys can anyone give some help understanding this:
Deadlock encountered .... Printing deadlock information
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 Wait-for graph
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 Node:1
2008-02-14 14:18:05.73 spid4 PAG: 19:1:57093 CleanCnt:2 Mode: S Flags: 0x2
2008-02-14 14:18:05.73 spid4 Grant List 0::
2008-02-14 14:18:05.73 spid4 Owner:0x42bfc060 Mode: S Flg:0x0 Ref:0 Life:00000001 SPID:164 ECID:0
2008-02-14 14:18:05.73 spid4 SPID: 164 ECID: 0 Statement Type: UPDATE Line #: 2
2008-02-14 14:18:05.73 spid4 Input Buf: Language Event: EXEC "dbo"."Vista_Parafarmaco"
2008-02-14 14:18:05.73 spid4 Requested By:
2008-02-14 14:18:05.73 spid4 ResType:LockOwner Stype:'OR' Mode: IX SPID:150 ECID:0 Ec:(0x21C4BA88) Value:0x645fe9c0 Cost:(0/A50)
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 Node:2
2008-02-14 14:18:05.73 spid4 Port: 0x42c30100 Xid Slot: -1, EC: 0x3c783a70, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeClose
2008-02-14 14:18:05.73 spid4 Coordinator: EC = 0x3c783a70, SPID: 164, ECID: 0, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer List::
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 0, EC = 0x3bd000c0, SPID: 164, ECID: 3, Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 1, EC = 0x3b8f80c0, SPID: 164, ECID: 2, Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 2, EC = 0x3bc940c0, SPID: 164, ECID: 4, Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 7, EC = 0x3b8e80c0, SPID: 164, ECID: 1, Blocking
2008-02-14 14:18:05.73 spid4 Producer List::
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 3, EC = 0x3ba7c0c0, SPID: 164, ECID: 11, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 4, EC = 0x3bd6a0c0, SPID: 164, ECID: 13, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 5, EC = 0x3ba740c0, SPID: 164, ECID: 12, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 6, EC = 0x3bf6a0c0, SPID: 164, ECID: 10, Blocking
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 Node:3
2008-02-14 14:18:05.73 spid4 Port: 0x42c30100 Xid Slot: 0, EC: 0x3bd000c0, ECID: 3 (Consumer), Exchange Wait Type :e_etypeCXPacket
2008-02-14 14:18:05.73 spid4 Coordinator: EC = 0x3c783a70, SPID: 164, ECID: 0, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer List::
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 0, EC = 0x3bd000c0, SPID: 164, ECID: 3, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 1, EC = 0x3b8f80c0, SPID: 164, ECID: 2, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 2, EC = 0x3bc940c0, SPID: 164, ECID: 4, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 7, EC = 0x3b8e80c0, SPID: 164, ECID: 1, Not Blocking
2008-02-14 14:18:05.73 spid4 Producer List::
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 3, EC = 0x3ba7c0c0, SPID: 164, ECID: 11, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 4, EC = 0x3bd6a0c0, SPID: 164, ECID: 13, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 5, EC = 0x3ba740c0, SPID: 164, ECID: 12, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 6, EC = 0x3bf6a0c0, SPID: 164, ECID: 10, Blocking
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 Node:4
2008-02-14 14:18:05.73 spid4 PAG: 19:1:506746 CleanCnt:5 Mode: IX Flags: 0x2
2008-02-14 14:18:05.73 spid4 Wait List:
2008-02-14 14:18:05.73 spid4 Owner:0x42c297c0 Mode: S Flg:0x0 Ref:1 Life:00000001 SPID:164 ECID:10
2008-02-14 14:18:05.73 spid4 Requested By:
2008-02-14 14:18:05.73 spid4 ResType:LockOwner Stype:'OR' Mode: S SPID:164 ECID:11 Ec:(0x3BA7C0C0) Value:0x42c28740 Cost:(0/0)
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 Node:5
2008-02-14 14:18:05.73 spid4 PAG: 19:1:506746 CleanCnt:5 Mode: IX Flags: 0x2
2008-02-14 14:18:05.73 spid4 Grant List 0::
2008-02-14 14:18:05.73 spid4 Owner:0x645ff160 Mode: IX Flg:0x0 Ref:1 Life:02000000 SPID:150 ECID:0
2008-02-14 14:18:05.73 spid4 SPID: 150 ECID: 0 Statement Type: INSERT Line #: 28
2008-02-14 14:18:05.73 spid4 Input Buf: RPC Event: sp_executesql;1
2008-02-14 14:18:05.73 spid4 Grant List 3::
2008-02-14 14:18:05.73 spid4 Requested By:
2008-02-14 14:18:05.73 spid4 ResType:LockOwner Stype:'OR' Mode: S SPID:164 ECID:10 Ec:(0x3BF6A0C0) Value:0x42c297c0 Cost:(0/0)
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 -- next branch --
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 Node:3
2008-02-14 14:18:05.73 spid4 Port: 0x42c30100 Xid Slot: 0, EC: 0x3bd000c0, ECID: 3 (Consumer), Exchange Wait Type :e_etypeCXPacket
2008-02-14 14:18:05.73 spid4 Coordinator: EC = 0x3c783a70, SPID: 164, ECID: 0, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer List::
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 0, EC = 0x3bd000c0, SPID: 164, ECID: 3, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 1, EC = 0x3b8f80c0, SPID: 164, ECID: 2, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 2, EC = 0x3bc940c0, SPID: 164, ECID: 4, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 7, EC = 0x3b8e80c0, SPID: 164, ECID: 1, Not Blocking
2008-02-14 14:18:05.73 spid4 Producer List::
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 3, EC = 0x3ba7c0c0, SPID: 164, ECID: 11, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 4, EC = 0x3bd6a0c0, SPID: 164, ECID: 13, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 5, EC = 0x3ba740c0, SPID: 164, ECID: 12, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 6, EC = 0x3bf6a0c0, SPID: 164, ECID: 10, Blocking
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 Node:8
2008-02-14 14:18:05.73 spid4 PAG: 19:1:506746 CleanCnt:5 Mode: IX Flags: 0x2
2008-02-14 14:18:05.73 spid4 Wait List:
2008-02-14 14:18:05.73 spid4 Owner:0x42c297c0 Mode: S Flg:0x0 Ref:1 Life:00000001 SPID:164 ECID:10
2008-02-14 14:18:05.73 spid4 Requested By:
2008-02-14 14:18:05.73 spid4 ResType:LockOwner Stype:'OR' Mode: S SPID:164 ECID:13 Ec:(0x3BD6A0C0) Value:0x42c28fe0 Cost:(0/0)
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 -- next branch --
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 Node:3
2008-02-14 14:18:05.73 spid4 Port: 0x42c30100 Xid Slot: 0, EC: 0x3bd000c0, ECID: 3 (Consumer), Exchange Wait Type :e_etypeCXPacket
2008-02-14 14:18:05.73 spid4 Coordinator: EC = 0x3c783a70, SPID: 164, ECID: 0, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer List::
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 0, EC = 0x3bd000c0, SPID: 164, ECID: 3, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 1, EC = 0x3b8f80c0, SPID: 164, ECID: 2, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 2, EC = 0x3bc940c0, SPID: 164, ECID: 4, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 7, EC = 0x3b8e80c0, SPID: 164, ECID: 1, Not Blocking
2008-02-14 14:18:05.73 spid4 Producer List::
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 3, EC = 0x3ba7c0c0, SPID: 164, ECID: 11, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 4, EC = 0x3bd6a0c0, SPID: 164, ECID: 13, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 5, EC = 0x3ba740c0, SPID: 164, ECID: 12, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 6, EC = 0x3bf6a0c0, SPID: 164, ECID: 10, Blocking
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 Node:11
2008-02-14 14:18:05.73 spid4 PAG: 19:1:506746 CleanCnt:5 Mode: IX Flags: 0x2
2008-02-14 14:18:05.73 spid4 Wait List:
2008-02-14 14:18:05.73 spid4 Owner:0x42c297c0 Mode: S Flg:0x0 Ref:1 Life:00000001 SPID:164 ECID:10
2008-02-14 14:18:05.73 spid4 Requested By:
2008-02-14 14:18:05.73 spid4 ResType:LockOwner Stype:'OR' Mode: S SPID:164 ECID:12 Ec:(0x3BA740C0) Value:0x42c286e0 Cost:(0/0)
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 -- next branch --
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 Node:3
2008-02-14 14:18:05.73 spid4 Port: 0x42c30100 Xid Slot: 0, EC: 0x3bd000c0, ECID: 3 (Consumer), Exchange Wait Type :e_etypeCXPacket
2008-02-14 14:18:05.73 spid4 Coordinator: EC = 0x3c783a70, SPID: 164, ECID: 0, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer List::
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 0, EC = 0x3bd000c0, SPID: 164, ECID: 3, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 1, EC = 0x3b8f80c0, SPID: 164, ECID: 2, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 2, EC = 0x3bc940c0, SPID: 164, ECID: 4, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 7, EC = 0x3b8e80c0, SPID: 164, ECID: 1, Not Blocking
2008-02-14 14:18:05.73 spid4 Producer List::
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 3, EC = 0x3ba7c0c0, SPID: 164, ECID: 11, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 4, EC = 0x3bd6a0c0, SPID: 164, ECID: 13, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 5, EC = 0x3ba740c0, SPID: 164, ECID: 12, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 6, EC = 0x3bf6a0c0, SPID: 164, ECID: 10, Blocking
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 -- next branch --
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 Node:3
2008-02-14 14:18:05.73 spid4 Port: 0x42c30100 Xid Slot: 0, EC: 0x3bd000c0, ECID: 3 (Consumer), Exchange Wait Type :e_etypeCXPacket
2008-02-14 14:18:05.73 spid4 Coordinator: EC = 0x3c783a70, SPID: 164, ECID: 0, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer List::
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 0, EC = 0x3bd000c0, SPID: 164, ECID: 3, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 1, EC = 0x3b8f80c0, SPID: 164, ECID: 2, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 2, EC = 0x3bc940c0, SPID: 164, ECID: 4, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 7, EC = 0x3b8e80c0, SPID: 164, ECID: 1, Not Blocking
2008-02-14 14:18:05.73 spid4 Producer List::
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 3, EC = 0x3ba7c0c0, SPID: 164, ECID: 11, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 4, EC = 0x3bd6a0c0, SPID: 164, ECID: 13, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 5, EC = 0x3ba740c0, SPID: 164, ECID: 12, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 6, EC = 0x3bf6a0c0, SPID: 164, ECID: 10, Blocking
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 -- next branch --
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 Node:2
2008-02-14 14:18:05.73 spid4 Port: 0x42c30100 Xid Slot: -1, EC: 0x3c783a70, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeClose
2008-02-14 14:18:05.73 spid4 Coordinator: EC = 0x3c783a70, SPID: 164, ECID: 0, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer List::
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 0, EC = 0x3bd000c0, SPID: 164, ECID: 3, Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 1, EC = 0x3b8f80c0, SPID: 164, ECID: 2, Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 2, EC = 0x3bc940c0, SPID: 164, ECID: 4, Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 7, EC = 0x3b8e80c0, SPID: 164, ECID: 1, Blocking
2008-02-14 14:18:05.73 spid4 Producer List::
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 3, EC = 0x3ba7c0c0, SPID: 164, ECID: 11, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 4, EC = 0x3bd6a0c0, SPID: 164, ECID: 13, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 5, EC = 0x3ba740c0, SPID: 164, ECID: 12, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 6, EC = 0x3bf6a0c0, SPID: 164, ECID: 10, Blocking
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 Node:17
2008-02-14 14:18:05.73 spid4 Port: 0x42c30100 Xid Slot: 1, EC: 0x3b8f80c0, ECID: 2 (Consumer), Exchange Wait Type :e_etypeCXPacket
2008-02-14 14:18:05.73 spid4 Coordinator: EC = 0x3c783a70, SPID: 164, ECID: 0, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer List::
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 0, EC = 0x3bd000c0, SPID: 164, ECID: 3, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 1, EC = 0x3b8f80c0, SPID: 164, ECID: 2, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 2, EC = 0x3bc940c0, SPID: 164, ECID: 4, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 7, EC = 0x3b8e80c0, SPID: 164, ECID: 1, Not Blocking
2008-02-14 14:18:05.73 spid4 Producer List::
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 3, EC = 0x3ba7c0c0, SPID: 164, ECID: 11, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 4, EC = 0x3bd6a0c0, SPID: 164, ECID: 13, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 5, EC = 0x3ba740c0, SPID: 164, ECID: 12, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 6, EC = 0x3bf6a0c0, SPID: 164, ECID: 10, Blocking
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 -- next branch --
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 Node:17
2008-02-14 14:18:05.73 spid4 Port: 0x42c30100 Xid Slot: 1, EC: 0x3b8f80c0, ECID: 2 (Consumer), Exchange Wait Type :e_etypeCXPacket
2008-02-14 14:18:05.73 spid4 Coordinator: EC = 0x3c783a70, SPID: 164, ECID: 0, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer List::
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 0, EC = 0x3bd000c0, SPID: 164, ECID: 3, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 1, EC = 0x3b8f80c0, SPID: 164, ECID: 2, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 2, EC = 0x3bc940c0, SPID: 164, ECID: 4, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 7, EC = 0x3b8e80c0, SPID: 164, ECID: 1, Not Blocking
2008-02-14 14:18:05.73 spid4 Producer List::
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 3, EC = 0x3ba7c0c0, SPID: 164, ECID: 11, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 4, EC = 0x3bd6a0c0, SPID: 164, ECID: 13, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 5, EC = 0x3ba740c0, SPID: 164, ECID: 12, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 6, EC = 0x3bf6a0c0, SPID: 164, ECID: 10, Blocking
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 -- next branch --
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 Node:17
2008-02-14 14:18:05.73 spid4 Port: 0x42c30100 Xid Slot: 1, EC: 0x3b8f80c0, ECID: 2 (Consumer), Exchange Wait Type :e_etypeCXPacket
2008-02-14 14:18:05.73 spid4 Coordinator: EC = 0x3c783a70, SPID: 164, ECID: 0, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer List::
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 0, EC = 0x3bd000c0, SPID: 164, ECID: 3, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 1, EC = 0x3b8f80c0, SPID: 164, ECID: 2, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 2, EC = 0x3bc940c0, SPID: 164, ECID: 4, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 7, EC = 0x3b8e80c0, SPID: 164, ECID: 1, Not Blocking
2008-02-14 14:18:05.73 spid4 Producer List::
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 3, EC = 0x3ba7c0c0, SPID: 164, ECID: 11, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 4, EC = 0x3bd6a0c0, SPID: 164, ECID: 13, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 5, EC = 0x3ba740c0, SPID: 164, ECID: 12, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 6, EC = 0x3bf6a0c0, SPID: 164, ECID: 10, Blocking
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 -- next branch --
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 Node:17
2008-02-14 14:18:05.73 spid4 Port: 0x42c30100 Xid Slot: 1, EC: 0x3b8f80c0, ECID: 2 (Consumer), Exchange Wait Type :e_etypeCXPacket
2008-02-14 14:18:05.73 spid4 Coordinator: EC = 0x3c783a70, SPID: 164, ECID: 0, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer List::
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 0, EC = 0x3bd000c0, SPID: 164, ECID: 3, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 1, EC = 0x3b8f80c0, SPID: 164, ECID: 2, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 2, EC = 0x3bc940c0, SPID: 164, ECID: 4, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 7, EC = 0x3b8e80c0, SPID: 164, ECID: 1, Not Blocking
2008-02-14 14:18:05.73 spid4 Producer List::
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 3, EC = 0x3ba7c0c0, SPID: 164, ECID: 11, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 4, EC = 0x3bd6a0c0, SPID: 164, ECID: 13, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 5, EC = 0x3ba740c0, SPID: 164, ECID: 12, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 6, EC = 0x3bf6a0c0, SPID: 164, ECID: 10, Blocking
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 -- next branch --
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 Node:17
2008-02-14 14:18:05.73 spid4 Port: 0x42c30100 Xid Slot: 1, EC: 0x3b8f80c0, ECID: 2 (Consumer), Exchange Wait Type :e_etypeCXPacket
2008-02-14 14:18:05.73 spid4 Coordinator: EC = 0x3c783a70, SPID: 164, ECID: 0, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer List::
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 0, EC = 0x3bd000c0, SPID: 164, ECID: 3, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 1, EC = 0x3b8f80c0, SPID: 164, ECID: 2, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 2, EC = 0x3bc940c0, SPID: 164, ECID: 4, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 7, EC = 0x3b8e80c0, SPID: 164, ECID: 1, Not Blocking
2008-02-14 14:18:05.73 spid4 Producer List::
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 3, EC = 0x3ba7c0c0, SPID: 164, ECID: 11, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 4, EC = 0x3bd6a0c0, SPID: 164, ECID: 13, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 5, EC = 0x3ba740c0, SPID: 164, ECID: 12, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 6, EC = 0x3bf6a0c0, SPID: 164, ECID: 10, Blocking
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 -- next branch --
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 Node:2
2008-02-14 14:18:05.73 spid4 Port: 0x42c30100 Xid Slot: -1, EC: 0x3c783a70, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeClose
2008-02-14 14:18:05.73 spid4 Coordinator: EC = 0x3c783a70, SPID: 164, ECID: 0, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer List::
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 0, EC = 0x3bd000c0, SPID: 164, ECID: 3, Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 1, EC = 0x3b8f80c0, SPID: 164, ECID: 2, Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 2, EC = 0x3bc940c0, SPID: 164, ECID: 4, Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 7, EC = 0x3b8e80c0, SPID: 164, ECID: 1, Blocking
2008-02-14 14:18:05.73 spid4 Producer List::
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 3, EC = 0x3ba7c0c0, SPID: 164, ECID: 11, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 4, EC = 0x3bd6a0c0, SPID: 164, ECID: 13, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 5, EC = 0x3ba740c0, SPID: 164, ECID: 12, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 6, EC = 0x3bf6a0c0, SPID: 164, ECID: 10, Blocking
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 Node:27
2008-02-14 14:18:05.73 spid4 Port: 0x42c30100 Xid Slot: 2, EC: 0x3bc940c0, ECID: 4 (Consumer), Exchange Wait Type :e_etypeCXPacket
2008-02-14 14:18:05.73 spid4 Coordinator: EC = 0x3c783a70, SPID: 164, ECID: 0, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer List::
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 0, EC = 0x3bd000c0, SPID: 164, ECID: 3, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 1, EC = 0x3b8f80c0, SPID: 164, ECID: 2, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 2, EC = 0x3bc940c0, SPID: 164, ECID: 4, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 7, EC = 0x3b8e80c0, SPID: 164, ECID: 1, Not Blocking
2008-02-14 14:18:05.73 spid4 Producer List::
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 3, EC = 0x3ba7c0c0, SPID: 164, ECID: 11, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 4, EC = 0x3bd6a0c0, SPID: 164, ECID: 13, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 5, EC = 0x3ba740c0, SPID: 164, ECID: 12, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 6, EC = 0x3bf6a0c0, SPID: 164, ECID: 10, Blocking
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 -- next branch --
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 Node:27
2008-02-14 14:18:05.73 spid4 Port: 0x42c30100 Xid Slot: 2, EC: 0x3bc940c0, ECID: 4 (Consumer), Exchange Wait Type :e_etypeCXPacket
2008-02-14 14:18:05.73 spid4 Coordinator: EC = 0x3c783a70, SPID: 164, ECID: 0, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer List::
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 0, EC = 0x3bd000c0, SPID: 164, ECID: 3, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 1, EC = 0x3b8f80c0, SPID: 164, ECID: 2, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 2, EC = 0x3bc940c0, SPID: 164, ECID: 4, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 7, EC = 0x3b8e80c0, SPID: 164, ECID: 1, Not Blocking
2008-02-14 14:18:05.73 spid4 Producer List::
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 3, EC = 0x3ba7c0c0, SPID: 164, ECID: 11, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 4, EC = 0x3bd6a0c0, SPID: 164, ECID: 13, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 5, EC = 0x3ba740c0, SPID: 164, ECID: 12, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 6, EC = 0x3bf6a0c0, SPID: 164, ECID: 10, Blocking
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 -- next branch --
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 Node:27
2008-02-14 14:18:05.73 spid4 Port: 0x42c30100 Xid Slot: 2, EC: 0x3bc940c0, ECID: 4 (Consumer), Exchange Wait Type :e_etypeCXPacket
2008-02-14 14:18:05.73 spid4 Coordinator: EC = 0x3c783a70, SPID: 164, ECID: 0, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer List::
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 0, EC = 0x3bd000c0, SPID: 164, ECID: 3, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 1, EC = 0x3b8f80c0, SPID: 164, ECID: 2, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 2, EC = 0x3bc940c0, SPID: 164, ECID: 4, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 7, EC = 0x3b8e80c0, SPID: 164, ECID: 1, Not Blocking
2008-02-14 14:18:05.73 spid4 Producer List::
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 3, EC = 0x3ba7c0c0, SPID: 164, ECID: 11, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 4, EC = 0x3bd6a0c0, SPID: 164, ECID: 13, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 5, EC = 0x3ba740c0, SPID: 164, ECID: 12, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 6, EC = 0x3bf6a0c0, SPID: 164, ECID: 10, Blocking
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 -- next branch --
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 Node:27
2008-02-14 14:18:05.73 spid4 Port: 0x42c30100 Xid Slot: 2, EC: 0x3bc940c0, ECID: 4 (Consumer), Exchange Wait Type :e_etypeCXPacket
2008-02-14 14:18:05.73 spid4 Coordinator: EC = 0x3c783a70, SPID: 164, ECID: 0, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer List::
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 0, EC = 0x3bd000c0, SPID: 164, ECID: 3, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 1, EC = 0x3b8f80c0, SPID: 164, ECID: 2, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 2, EC = 0x3bc940c0, SPID: 164, ECID: 4, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 7, EC = 0x3b8e80c0, SPID: 164, ECID: 1, Not Blocking
2008-02-14 14:18:05.73 spid4 Producer List::
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 3, EC = 0x3ba7c0c0, SPID: 164, ECID: 11, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 4, EC = 0x3bd6a0c0, SPID: 164, ECID: 13, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 5, EC = 0x3ba740c0, SPID: 164, ECID: 12, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 6, EC = 0x3bf6a0c0, SPID: 164, ECID: 10, Blocking
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 -- next branch --
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 Node:27
2008-02-14 14:18:05.73 spid4 Port: 0x42c30100 Xid Slot: 2, EC: 0x3bc940c0, ECID: 4 (Consumer), Exchange Wait Type :e_etypeCXPacket
2008-02-14 14:18:05.73 spid4 Coordinator: EC = 0x3c783a70, SPID: 164, ECID: 0, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer List::
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 0, EC = 0x3bd000c0, SPID: 164, ECID: 3, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 1, EC = 0x3b8f80c0, SPID: 164, ECID: 2, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 2, EC = 0x3bc940c0, SPID: 164, ECID: 4, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 7, EC = 0x3b8e80c0, SPID: 164, ECID: 1, Not Blocking
2008-02-14 14:18:05.73 spid4 Producer List::
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 3, EC = 0x3ba7c0c0, SPID: 164, ECID: 11, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 4, EC = 0x3bd6a0c0, SPID: 164, ECID: 13, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 5, EC = 0x3ba740c0, SPID: 164, ECID: 12, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 6, EC = 0x3bf6a0c0, SPID: 164, ECID: 10, Blocking
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 -- next branch --
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 Node:2
2008-02-14 14:18:05.73 spid4 Port: 0x42c30100 Xid Slot: -1, EC: 0x3c783a70, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeClose
2008-02-14 14:18:05.73 spid4 Coordinator: EC = 0x3c783a70, SPID: 164, ECID: 0, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer List::
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 0, EC = 0x3bd000c0, SPID: 164, ECID: 3, Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 1, EC = 0x3b8f80c0, SPID: 164, ECID: 2, Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 2, EC = 0x3bc940c0, SPID: 164, ECID: 4, Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 7, EC = 0x3b8e80c0, SPID: 164, ECID: 1, Blocking
2008-02-14 14:18:05.73 spid4 Producer List::
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 3, EC = 0x3ba7c0c0, SPID: 164, ECID: 11, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 4, EC = 0x3bd6a0c0, SPID: 164, ECID: 13, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 5, EC = 0x3ba740c0, SPID: 164, ECID: 12, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 6, EC = 0x3bf6a0c0, SPID: 164, ECID: 10, Blocking
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 -- next branch --
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 Node:2
2008-02-14 14:18:05.73 spid4 Port: 0x42c30100 Xid Slot: -1, EC: 0x3c783a70, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeClose
2008-02-14 14:18:05.73 spid4 Coordinator: EC = 0x3c783a70, SPID: 164, ECID: 0, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer List::
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 0, EC = 0x3bd000c0, SPID: 164, ECID: 3, Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 1, EC = 0x3b8f80c0, SPID: 164, ECID: 2, Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 2, EC = 0x3bc940c0, SPID: 164, ECID: 4, Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 7, EC = 0x3b8e80c0, SPID: 164, ECID: 1, Blocking
2008-02-14 14:18:05.73 spid4 Producer List::
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 3, EC = 0x3ba7c0c0, SPID: 164, ECID: 11, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 4, EC = 0x3bd6a0c0, SPID: 164, ECID: 13, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 5, EC = 0x3ba740c0, SPID: 164, ECID: 12, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 6, EC = 0x3bf6a0c0, SPID: 164, ECID: 10, Blocking
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 -- next branch --
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 Node:2
2008-02-14 14:18:05.73 spid4 Port: 0x42c30100 Xid Slot: -1, EC: 0x3c783a70, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeClose
2008-02-14 14:18:05.73 spid4 Coordinator: EC = 0x3c783a70, SPID: 164, ECID: 0, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer List::
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 0, EC = 0x3bd000c0, SPID: 164, ECID: 3, Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 1, EC = 0x3b8f80c0, SPID: 164, ECID: 2, Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 2, EC = 0x3bc940c0, SPID: 164, ECID: 4, Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 7, EC = 0x3b8e80c0, SPID: 164, ECID: 1, Blocking
2008-02-14 14:18:05.73 spid4 Producer List::
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 3, EC = 0x3ba7c0c0, SPID: 164, ECID: 11, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 4, EC = 0x3bd6a0c0, SPID: 164, ECID: 13, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 5, EC = 0x3ba740c0, SPID: 164, ECID: 12, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 6, EC = 0x3bf6a0c0, SPID: 164, ECID: 10, Blocking
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 -- next branch --
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 Node:2
2008-02-14 14:18:05.73 spid4 Port: 0x42c30100 Xid Slot: -1, EC: 0x3c783a70, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeClose
2008-02-14 14:18:05.73 spid4 Coordinator: EC = 0x3c783a70, SPID: 164, ECID: 0, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer List::
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 0, EC = 0x3bd000c0, SPID: 164, ECID: 3, Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 1, EC = 0x3b8f80c0, SPID: 164, ECID: 2, Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 2, EC = 0x3bc940c0, SPID: 164, ECID: 4, Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 7, EC = 0x3b8e80c0, SPID: 164, ECID: 1, Blocking
2008-02-14 14:18:05.73 spid4 Producer List::
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 3, EC = 0x3ba7c0c0, SPID: 164, ECID: 11, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 4, EC = 0x3bd6a0c0, SPID: 164, ECID: 13, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 5, EC = 0x3ba740c0, SPID: 164, ECID: 12, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 6, EC = 0x3bf6a0c0, SPID: 164, ECID: 10, Blocking
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 -- next branch --
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 Node:2
2008-02-14 14:18:05.73 spid4 Port: 0x42c30100 Xid Slot: -1, EC: 0x3c783a70, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeClose
2008-02-14 14:18:05.73 spid4 Coordinator: EC = 0x3c783a70, SPID: 164, ECID: 0, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer List::
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 0, EC = 0x3bd000c0, SPID: 164, ECID: 3, Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 1, EC = 0x3b8f80c0, SPID: 164, ECID: 2, Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 2, EC = 0x3bc940c0, SPID: 164, ECID: 4, Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 7, EC = 0x3b8e80c0, SPID: 164, ECID: 1, Blocking
2008-02-14 14:18:05.73 spid4 Producer List::
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 3, EC = 0x3ba7c0c0, SPID: 164, ECID: 11, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 4, EC = 0x3bd6a0c0, SPID: 164, ECID: 13, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 5, EC = 0x3ba740c0, SPID: 164, ECID: 12, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 6, EC = 0x3bf6a0c0, SPID: 164, ECID: 10, Blocking
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 Node:45
2008-02-14 14:18:05.73 spid4 Port: 0x42c30100 Xid Slot: 7, EC: 0x3b8e80c0, ECID: 1 (Consumer), Exchange Wait Type :e_etypeCXPacket
2008-02-14 14:18:05.73 spid4 Coordinator: EC = 0x3c783a70, SPID: 164, ECID: 0, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer List::
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 0, EC = 0x3bd000c0, SPID: 164, ECID: 3, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 1, EC = 0x3b8f80c0, SPID: 164, ECID: 2, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 2, EC = 0x3bc940c0, SPID: 164, ECID: 4, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 7, EC = 0x3b8e80c0, SPID: 164, ECID: 1, Not Blocking
2008-02-14 14:18:05.73 spid4 Producer List::
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 3, EC = 0x3ba7c0c0, SPID: 164, ECID: 11, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 4, EC = 0x3bd6a0c0, SPID: 164, ECID: 13, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 5, EC = 0x3ba740c0, SPID: 164, ECID: 12, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 6, EC = 0x3bf6a0c0, SPID: 164, ECID: 10, Blocking
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 -- next branch --
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 Node:45
2008-02-14 14:18:05.73 spid4 Port: 0x42c30100 Xid Slot: 7, EC: 0x3b8e80c0, ECID: 1 (Consumer), Exchange Wait Type :e_etypeCXPacket
2008-02-14 14:18:05.73 spid4 Coordinator: EC = 0x3c783a70, SPID: 164, ECID: 0, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer List::
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 0, EC = 0x3bd000c0, SPID: 164, ECID: 3, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 1, EC = 0x3b8f80c0, SPID: 164, ECID: 2, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 2, EC = 0x3bc940c0, SPID: 164, ECID: 4, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 7, EC = 0x3b8e80c0, SPID: 164, ECID: 1, Not Blocking
2008-02-14 14:18:05.73 spid4 Producer List::
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 3, EC = 0x3ba7c0c0, SPID: 164, ECID: 11, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 4, EC = 0x3bd6a0c0, SPID: 164, ECID: 13, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 5, EC = 0x3ba740c0, SPID: 164, ECID: 12, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 6, EC = 0x3bf6a0c0, SPID: 164, ECID: 10, Blocking
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 -- next branch --
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 Node:45
2008-02-14 14:18:05.73 spid4 Port: 0x42c30100 Xid Slot: 7, EC: 0x3b8e80c0, ECID: 1 (Consumer), Exchange Wait Type :e_etypeCXPacket
2008-02-14 14:18:05.73 spid4 Coordinator: EC = 0x3c783a70, SPID: 164, ECID: 0, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer List::
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 0, EC = 0x3bd000c0, SPID: 164, ECID: 3, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 1, EC = 0x3b8f80c0, SPID: 164, ECID: 2, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 2, EC = 0x3bc940c0, SPID: 164, ECID: 4, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 7, EC = 0x3b8e80c0, SPID: 164, ECID: 1, Not Blocking
2008-02-14 14:18:05.73 spid4 Producer List::
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 3, EC = 0x3ba7c0c0, SPID: 164, ECID: 11, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 4, EC = 0x3bd6a0c0, SPID: 164, ECID: 13, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 5, EC = 0x3ba740c0, SPID: 164, ECID: 12, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 6, EC = 0x3bf6a0c0, SPID: 164, ECID: 10, Blocking
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 -- next branch --
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 Node:45
2008-02-14 14:18:05.73 spid4 Port: 0x42c30100 Xid Slot: 7, EC: 0x3b8e80c0, ECID: 1 (Consumer), Exchange Wait Type :e_etypeCXPacket
2008-02-14 14:18:05.73 spid4 Coordinator: EC = 0x3c783a70, SPID: 164, ECID: 0, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer List::
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 0, EC = 0x3bd000c0, SPID: 164, ECID: 3, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 1, EC = 0x3b8f80c0, SPID: 164, ECID: 2, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 2, EC = 0x3bc940c0, SPID: 164, ECID: 4, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 7, EC = 0x3b8e80c0, SPID: 164, ECID: 1, Not Blocking
2008-02-14 14:18:05.73 spid4 Producer List::
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 3, EC = 0x3ba7c0c0, SPID: 164, ECID: 11, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 4, EC = 0x3bd6a0c0, SPID: 164, ECID: 13, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 5, EC = 0x3ba740c0, SPID: 164, ECID: 12, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 6, EC = 0x3bf6a0c0, SPID: 164, ECID: 10, Blocking
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 -- next branch --
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 Node:45
2008-02-14 14:18:05.73 spid4 Port: 0x42c30100 Xid Slot: 7, EC: 0x3b8e80c0, ECID: 1 (Consumer), Exchange Wait Type :e_etypeCXPacket
2008-02-14 14:18:05.73 spid4 Coordinator: EC = 0x3c783a70, SPID: 164, ECID: 0, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer List::
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 0, EC = 0x3bd000c0, SPID: 164, ECID: 3, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 1, EC = 0x3b8f80c0, SPID: 164, ECID: 2, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 2, EC = 0x3bc940c0, SPID: 164, ECID: 4, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 7, EC = 0x3b8e80c0, SPID: 164, ECID: 1, Not Blocking
2008-02-14 14:18:05.73 spid4 Producer List::
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 3, EC = 0x3ba7c0c0, SPID: 164, ECID: 11, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 4, EC = 0x3bd6a0c0, SPID: 164, ECID: 13, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 5, EC = 0x3ba740c0, SPID: 164, ECID: 12, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 6, EC = 0x3bf6a0c0, SPID: 164, ECID: 10, Blocking
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 -- next branch --
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4
2008-02-14 14:18:05.73 spid4 Node:2
2008-02-14 14:18:05.73 spid4 Port: 0x42c30100 Xid Slot: -1, EC: 0x3c783a70, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeClose
2008-02-14 14:18:05.73 spid4 Coordinator: EC = 0x3c783a70, SPID: 164, ECID: 0, Not Blocking
2008-02-14 14:18:05.73 spid4 Consumer List::
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 0, EC = 0x3bd000c0, SPID: 164, ECID: 3, Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 1, EC = 0x3b8f80c0, SPID: 164, ECID: 2, Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 2, EC = 0x3bc940c0, SPID: 164, ECID: 4, Blocking
2008-02-14 14:18:05.73 spid4 Consumer: Xid Slot: 7, EC = 0x3b8e80c0, SPID: 164, ECID: 1, Blocking
2008-02-14 14:18:05.73 spid4 Producer List::
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 3, EC = 0x3ba7c0c0, SPID: 164, ECID: 11, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 4, EC = 0x3bd6a0c0, SPID: 164, ECID: 13, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 5, EC = 0x3ba740c0, SPID: 164, ECID: 12, Blocking
2008-02-14 14:18:05.73 spid4 Producer: Xid Slot: 6, EC = 0x3bf6a0c0, SPID: 164, ECID: 10, Blocking
2008-02-14 14:18:05.73 spid4 Victim Resource Owner:
2008-02-14 14:18:05.73 spid4 ResType:LockOwner Stype:'OR' Mode: S SPID:164 ECID:10 Ec:(0x3BF6A0C0) Value:0x42c297c0 Cost:(0/0)
From the profiler I understood:
SPID 162 : makes an update on table1 trough the SP "Vista_Parafarmaco"
SPID 150: makes an insert on table1 trough an update Trigger
Why SQL Server is unable to handle this situation?
Thanks
Ruggiero Lauria
February 14, 2008 at 6:49 am
Ops... SPID 162=164 little mistake
February 14, 2008 at 8:13 am
Probably both have select locks on a page and both want to escalate to exclusive. Instant deadlock.
Could you post the code for both the proc and the trigger, as well as the schema for table1 and the indexes?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 14, 2008 at 8:30 am
Thanks a lot Gila
Here there is everyting you asked for:
/* SP */
CREATE PROCEDURE dbo.Vista_Parafarmaco
AS UPDATE dbo.Parafarmaco_AGG
SET Vistato = 1
WHERE (Numero_aggiornamento IS NULL) AND (Vistato = 0)
GO
/* SP end */
/* View Script */
create view
Parafarmaco_AGG
as
SELECT Parafarmaco.dbo.Log_Parafarmaco.*, dbo.Ordinamento_Operazioni.Ordine AS Expr1
FROM Parafarmaco.dbo.Log_Parafarmaco INNER JOIN
dbo.Ordinamento_Operazioni ON Parafarmaco.dbo.Log_Parafarmaco.Tipo_Operazione = dbo.Ordinamento_Operazioni.Tipo_Operazione
WHERE (Parafarmaco.dbo.Log_Parafarmaco.Tipo_Operazione = N'CANCELLAZIONE') AND (Parafarmaco.dbo.Log_Parafarmaco.Bloccato_Vecchio = 0) OR
(Parafarmaco.dbo.Log_Parafarmaco.Bloccato = 0) OR
(Parafarmaco.dbo.Log_Parafarmaco.Bloccato_Vecchio = 0) AND (Parafarmaco.dbo.Log_Parafarmaco.Bloccato = 1)
/* View Script END*/
/* TRIGGER Script */
CREATE Trigger Parafarmaco_TriggerInsert
On dbo.Parafarmaco
instead of Insert not for replication
As
DECLARE @id_salvato integer, @temp as varchar(200)
SET @temp =(select codice_minsan from inserted)
set nocount on
insert into farmaco.dbo.id_merqurio (Id_tipo_prodotto,codice_minsan,Id_Locale) select Id_tipo_prodotto,codice_minsan,Id_Locale from inserted
where not exists (SELECT codice_Minsan from farmaco.dbo.id_merqurio a where inserted.codice_minsan=a.codice_Minsan and inserted.Id_Tipo_Prodotto=a.id_Tipo_Prodotto)
/*set @id_salvato = (SELECT farmaco.dbo.id_merqurio.id_merqurio from farmaco.dbo.id_merqurio inner join inserted on farmaco.dbo.id_merqurio.codice_minsan=inserted.codice_minsan)
Print @id_salvato
*/
INSERT INTO Parafarmaco
(ID_Merqurio,
Codice_Minsan,
Id_Tipo_Prodotto,
Descrizione_Breve,
Id_Linea,
Numero,
Soggetto,
Confezione,
Confezione_Nuova,
Descrizione,
Descrizione_Nuova,
Nome,
Id_Forma_Farmaceutica,
Id_Ditta,
Data_Validita_Id_Ditta,
Id_Divisione_Ditta,
Id_Atc,
Id_Sostanza,
Prezzo,
Data_Validita_Prezzo,
Data_NAscita,
Id_Vendibilita,
Data_Validita_Id_Vendibilita,
Data_Max_Vendibilita,
Id_Distributore,
Data_Validita_Id_Distributore,
Id_Classe_SSN,
Data_Validita_Id_Classe_SSN,
IVA,
Data_Validita_Iva,
GRUPPOMERC,
Codice_EAN,
Codice_AIC_Nuova_Confezione,
Codice_Interno_Ditta,
Testo_Composizione,
Memorandum,
Esaurimento,
Data_Validita_Esaurimento,
Commercio,
Data_I_Commercializzazione,
Id_Monografia,
Id_Tipo_Prezzo,
Id_fonte_di_comunicazione,
Numero_provvedimento,
Data_Provvedimento,
Uso_Interno,
Protocollo,
Data_validita,
Quantita,
Id_Unita_di_Misura,
bloccato)
SELECT Farmaco.dbo.Id_Merqurio.Id_Merqurio,
inserted.Codice_Minsan,
inserted.Id_Tipo_Prodotto,
inserted.Descrizione_Breve,
Inserted.Id_Linea,
inserted.Numero,
inserted.Soggetto,
dbo.dopoasterisco(inserted.Descrizione),
inserted.confezione_nuova,
Descrizione,
ltrim(CASE WHEN dbo.Linee.Descrizione_Linea IS NULL THEN '' ELSE linee.descrizione_linea END + CASE WHEN inserted.numero IS NULL THEN '' ELSE ' ' + CAST(inserted.Numero AS varchar(5))
END + '*' + CASE WHEN inserted.Soggetto IS NULL THEN '' ELSE inserted.soggetto + ' ' END + CASE WHEN inserted.Confezione_Nuova IS NULL
THEN '' ELSE inserted.confezione_Nuova END),
dbo.primadiasterisco(inserted.Descrizione),
inserted.Id_Forma_Farmaceutica,
inserted.Id_Ditta,
inserted.Data_Validita_Id_Ditta,
inserted.Id_Divisione_Ditta,
inserted.Id_Atc,
inserted.Id_Sostanza,
inserted.Prezzo,
inserted.Data_Validita_Prezzo,
inserted.Data_Nascita,
inserted.Id_Vendibilita,
inserted.Data_Validita_Id_Vendibilita,
inserted.Data_Max_Vendibilita,
inserted.Id_Distributore,
inserted.Data_Validita_Id_Distributore,
inserted.Id_Classe_SSN,
inserted.Data_Validita_Id_Classe_SSN,
inserted.IVA,
inserted.Data_Validita_Iva,
inserted.GRUPPOMERC,
inserted.Codice_EAN,
inserted.Codice_AIC_Nuova_Confezione,
inserted.Codice_Interno_Ditta,
inserted.Testo_Composizione,
inserted.Memorandum,
inserted.Esaurimento,
inserted.Data_Validita_Esaurimento,
CASE WHEN vendibile IS NULL THEN 1 ELSE vendibile END AS commercio,
inserted.Data_I_Commercializzazione,
inserted.Id_Monografia,
inserted.Id_Tipo_Prezzo,
inserted.Id_fonte_di_comunicazione,
inserted.Numero_provvedimento,
inserted.Data_Provvedimento,
inserted.Uso_Interno,
inserted.Protocollo,
inserted.Data_validita,
inserted.Quantita,
inserted.Id_Unita_di_Misura,
inserted.bloccato
FROM inserted INNER JOIN farmaco.dbo.Id_Merqurio ON farmaco.dbo.Id_Merqurio.Codice_Minsan = inserted.Codice_Minsan
LEFT OUTER JOIN dbo.Linee ON inserted.Id_Linea = dbo.Linee.Id_Linea
LEFT OUTER JOIN dbo.Vendibilita ON inserted.Id_Vendibilita = dbo.Vendibilita.Id_Vendibilita
SET @id_salvato=@@IDENTITY
INSERT INTO [Log_Parafarmaco]
SELECT 'INSERIMENTO' ,
suser_sname(),
GetDate(),
NULL,
NULL,
I.[Uso_Interno],
I.protocollo,
I.[Data_Validita],
P.Id_Merqurio,
0 as Vistato,
P.Id_Locale,
I.Codice_Minsan,
NULL,
I.Id_Tipo_Prodotto,
NULL,
I.Descrizione_Breve ,
NULL,
I.Descrizione,
NULL,
I.Id_Forma_Farmaceutica ,
NULL,
I.Id_Classificazione_Merceologica,
NULL,
I.Id_Soggetto,
NULL,
I.Id_Sito_di_Azione,
NULL,
I.Id_Ditta,
NULL,
I.Data_Validita_Id_Ditta,
NULL,
I.Id_Divisione_Ditta,
NULL,
I.Id_Atc,
NULL,
I.Id_Sostanza,
NULL,
I.[Prezzo],
NULL,
I.Data_Validita_Prezzo,
NULL,
I.Data_Nascita ,
NULL,
I.Id_Vendibilita,
NULL,
I.Data_Validita_Id_Vendibilita,
NULL,
I.Data_Max_Vendibilita,
NULL,
I.Id_Distributore,
NULL,
I.Data_Validita_Id_Distributore,
NULL,
I.Id_Classe_SSN,
NULL,
I.Data_Validita_Id_Classe_SSN,
NULL,
I.IVA,
NULL,
I.Data_Validita_IVA,
NULL,
I.GRUPPOMERC,
NULL,
I.Codice_EAN,
NULL,
I.Codice_Interno_Ditta,
NULL,
I.Codice_AIC_Nuova_Confezione,
NULL,
P.Testo_Composizione,
NULL,
I.memorandum,
NULL,
I.Esaurimento,
NULL,
I.[Data_Validita_Esaurimento],
NULL,
I.commercio,
NULL,
I.[Data_I_Commercializzazione],
NULL,
I.[Id_Monografia],
NULL,
I.[Id_Tipo_Prezzo],
NULL,
I.[Id_fonte_di_comunicazione],
NULL,
I.[Numero_provvedimento],
NULL,
I.[Data_Provvedimento],
NULL,
I.Id_Linea,
NULL,
I.Numero,
NULL,
I.Soggetto,
NULL,
I.Confezione,
NULL,
I.Quantita,
NULL,
I.Id_Unita_di_Misura,
NULL,
I.Bloccato,
NULL
FROM Parafarmaco P INNER JOIN Inserted I ON P.Codice_Minsan = I.Codice_Minsan
set @temp = 'SELECT Identity (Int, ' + Cast(@id_salvato As Varchar(10)) + ',1) AS id INTO #Tmp'
EXECUTE (@temp)
/* Trigger end*/
/* Log_Parafarmaco TABLE script: */
CREATE TABLE [dbo].[Log_Parafarmaco] (
[Tipo_Operazione] [nvarchar] (15) COLLATE Latin1_General_CI_AS NULL ,
[Utente] [nvarchar] (30) COLLATE Latin1_General_CI_AS NULL ,
[Data_Modifica] [datetime] NOT NULL ,
[Numero_aggiornamento] [int] NULL ,
[Data_Aggiornamento] [datetime] NULL ,
[Uso_Interno] [bit] NULL ,
[Protocollo] [int] NULL ,
[Data_Validita] [datetime] NULL ,
[Id_Merqurio] [int] NOT NULL ,
[Vistato] [bit] NULL ,
[Id_Locale] [int] NULL ,
[Codice_Minsan] [nvarchar] (9) COLLATE Latin1_General_CI_AS NULL ,
[Codice_Minsan_Vecchio] [nvarchar] (9) COLLATE Latin1_General_CI_AS NULL ,
[Id_Tipo_Prodotto] [nvarchar] (3) COLLATE Latin1_General_CI_AS NULL ,
[Id_Tipo_Prodotto_Vecchio] [nvarchar] (3) COLLATE Latin1_General_CI_AS NULL ,
[Descrizione_Breve] [nvarchar] (28) COLLATE Latin1_General_CI_AS NULL ,
[Descrizione_Breve_Vecchio] [nvarchar] (28) COLLATE Latin1_General_CI_AS NULL ,
[Descrizione] [nvarchar] (60) COLLATE Latin1_General_CI_AS NULL ,
[Descrizione_Vecchio] [nvarchar] (60) COLLATE Latin1_General_CI_AS NULL ,
[Id_Forma_Farmaceutica] [nvarchar] (3) COLLATE Latin1_General_CI_AS NULL ,
[Id_Forma_Farmaceutica_Vecchio] [nvarchar] (3) COLLATE Latin1_General_CI_AS NULL ,
[Id_Classificazione_Merceologica] [int] NULL ,
[Id_Classificazione_Merceologica_Vecchio] [int] NULL ,
[Id_Soggetto] [int] NULL ,
[Id_Soggetto_Vecchio] [int] NULL ,
[Id_Sito_di_Azione] [int] NULL ,
[Id_Sito_di_Azione_Vecchio] [int] NULL ,
[Id_Ditta] [nvarchar] (4) COLLATE Latin1_General_CI_AS NULL ,
[Id_Ditta_Vecchio] [nvarchar] (4) COLLATE Latin1_General_CI_AS NULL ,
[Data_Validita_Id_Ditta] [datetime] NULL ,
[Data_Validita_Id_Ditta_Vecchio] [datetime] NULL ,
[Id_Divisione_Ditta] [nvarchar] (2) COLLATE Latin1_General_CI_AS NULL ,
[Id_Divisione_Ditta_Vecchio] [nvarchar] (2) COLLATE Latin1_General_CI_AS NULL ,
[Id_Atc] [nvarchar] (7) COLLATE Latin1_General_CI_AS NULL ,
[Id_Atc_Vecchio] [nvarchar] (7) COLLATE Latin1_General_CI_AS NULL ,
[Id_Sostanza] [nvarchar] (6) COLLATE Latin1_General_CI_AS NULL ,
[Id_Sostanza_Vecchio] [nvarchar] (6) COLLATE Latin1_General_CI_AS NULL ,
[Prezzo] [float] NULL ,
[Prezzo_Vecchio] [float] NULL ,
[Data_Validita_Prezzo] [datetime] NULL ,
[Data_Validita_Prezzo_Vecchio] [datetime] NULL ,
[Data_Nascita] [datetime] NULL ,
[Data_Nascita_Vecchio] [datetime] NULL ,
[Id_Vendibilita] [nvarchar] (1) COLLATE Latin1_General_CI_AS NULL ,
[Id_Vendibilita_Vecchio] [nvarchar] (1) COLLATE Latin1_General_CI_AS NULL ,
[Data_Validita_Id_Vendibilita] [datetime] NULL ,
[Data_Validita_Id_Vendibilita_Vecchio] [datetime] NULL ,
[Data_Max_Vendibilita] [datetime] NULL ,
[Data_Max_Vendibilita_Vecchio] [datetime] NULL ,
[Id_Distributore] [nvarchar] (4) COLLATE Latin1_General_CI_AS NULL ,
[Id_Distributore_Vecchio] [nvarchar] (4) COLLATE Latin1_General_CI_AS NULL ,
[Data_Validita_Id_Distributore] [datetime] NULL ,
[Data_Validita_Id_Distributore_Vecchio] [datetime] NULL ,
[Id_Classe_SSN] [nvarchar] (1) COLLATE Latin1_General_CI_AS NULL ,
[Id_Classe_SSN_Vecchio] [nvarchar] (1) COLLATE Latin1_General_CI_AS NULL ,
[Data_Validita_Id_Classe_SSN] [datetime] NULL ,
[Data_Validita_Id_Classe_SSN_Vecchio] [datetime] NULL ,
[IVA] [nvarchar] (2) COLLATE Latin1_General_CI_AS NULL ,
[IVA_Vecchio] [nvarchar] (2) COLLATE Latin1_General_CI_AS NULL ,
[Data_Validita_Iva] [datetime] NULL ,
[Data_Validita_Iva_Vecchio] [datetime] NULL ,
[GRUPPOMERC] [nvarchar] (6) COLLATE Latin1_General_CI_AS NULL ,
[GRUPPOMERC_Vecchio] [nvarchar] (6) COLLATE Latin1_General_CI_AS NULL ,
[Codice_EAN] [nvarchar] (13) COLLATE Latin1_General_CI_AS NULL ,
[Codice_EAN_Vecchio] [nvarchar] (13) COLLATE Latin1_General_CI_AS NULL ,
[Codice_Interno_Ditta] [nvarchar] (13) COLLATE Latin1_General_CI_AS NULL ,
[Codice_Interno_Ditta_Vecchio] [nvarchar] (13) COLLATE Latin1_General_CI_AS NULL ,
[Codice_AIC_Nuova_Confezione] [nvarchar] (9) COLLATE Latin1_General_CI_AS NULL ,
[Codice_AIC_Nuova_confezione_Vecchio] [nvarchar] (9) COLLATE Latin1_General_CI_AS NULL ,
[Testo_Composizione] [ntext] COLLATE Latin1_General_CI_AS NULL ,
[Testo_Composizione_Vecchio] [ntext] COLLATE Latin1_General_CI_AS NULL ,
[Memorandum] [nvarchar] (4000) COLLATE Latin1_General_CI_AS NULL ,
[Memorandum_Vecchio] [nvarchar] (4000) COLLATE Latin1_General_CI_AS NULL ,
[Esaurimento] [bit] NULL ,
[Esaurimento_Vecchio] [bit] NULL ,
[Data_Validita_Esaurimento] [datetime] NULL ,
[Data_Validita_Esaurimento_Vecchio] [datetime] NULL ,
[Commercio] [bit] NULL ,
[Commercio_Vecchio] [bit] NULL ,
[Data_I_Commercializzazione] [datetime] NULL ,
[Data_I_Commercializzazione_Vecchio] [datetime] NULL ,
[Id_Monografia] [int] NULL ,
[Id_Monografia_Vecchio] [int] NULL ,
[Id_Tipo_Prezzo] [int] NULL ,
[Id_Tipo_Prezzo_Vecchio] [int] NULL ,
[Id_fonte_di_comunicazione] [int] NULL ,
[Id_fonte_di_comunicazione_Vecchio] [int] NULL ,
[Numero_provvedimento] [nvarchar] (10) COLLATE Latin1_General_CI_AS NULL ,
[Numero_provvedimento_Vecchio] [nvarchar] (10) COLLATE Latin1_General_CI_AS NULL ,
[Data_Provvedimento] [datetime] NULL ,
[Data_Provvedimento_Vecchio] [datetime] NULL ,
[Id_Linea] [int] NULL ,
[Id_Linea_Vecchio] [int] NULL ,
[Numero] [int] NULL ,
[Numero_Vecchio] [int] NULL ,
[Soggetto] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL ,
[Soggetto_Vecchio] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL ,
[Confezione] [nvarchar] (60) COLLATE Latin1_General_CI_AS NULL ,
[Confezione_Vecchio] [nvarchar] (60) COLLATE Latin1_General_CI_AS NULL ,
[Quantita] [decimal](7, 3) NULL ,
[Quantita_Vecchio] [decimal](7, 3) NULL ,
[Id_Unita_di_Misura] [int] NULL ,
[Id_Unita_di_Misura_Vecchio] [int] NULL ,
[Bloccato] [bit] NULL ,
[Bloccato_Vecchio] [bit] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[Log_Parafarmaco] ADD
CONSTRAINT [DF_Log_Parafarmaco_Vistato] DEFAULT (0) FOR [Vistato],
CONSTRAINT [PK_Log_Parafarmaco] PRIMARY KEY NONCLUSTERED
(
[Id_Merqurio],
[Data_Modifica]
) WITH FILLFACTOR = 90 ON [PRIMARY]
GO
CREATE INDEX [IX_Log_Parafarmaco] ON [dbo].[Log_Parafarmaco]([Numero_aggiornamento], [Data_Modifica]) WITH FILLFACTOR = 90 ON [PRIMARY]
GO
CREATE INDEX [IX_Log_Parafarmaco_1] ON [dbo].[Log_Parafarmaco]([Data_Modifica] DESC , [Utente]) WITH FILLFACTOR = 90 ON [PRIMARY]
GO
CREATE INDEX [minsan] ON [dbo].[Log_Parafarmaco]([Codice_Minsan], [Data_Modifica] DESC ) WITH FILLFACTOR = 90 ON [PRIMARY]
GO
CREATE INDEX [Bloccato] ON [dbo].[Log_Parafarmaco]([Tipo_Operazione], [Bloccato], [Bloccato_Vecchio]) ON [PRIMARY]
GO
/* Log_Parafarmaco TABLE script: END*/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply