| Pablo Silva 2006-10-24, 6:38 pm |
| Can anyone please help me to clarify the following trace regarding deadlocks:
Deadlock encountered .... Printing deadlock information
2006-08-14 15:45:55.04 spid4
2006-08-14 15:45:55.04 spid4 Wait-for graph
2006-08-14 15:45:55.04 spid4
2006-08-14 15:45:55.04 spid4 Node:1
2006-08-14 15:45:55.04 spid4 KEY: 9:363864363:1 (2002aa6e06a0)
CleanCnt:1 Mode: X Flags: 0x0
2006-08-14 15:45:55.04 spid4 Grant List 1::
2006-08-14 15:45:55.04 spid4 Owner:0x3f81b5c0 Mode: X Flg:0x0
Ref:0 Life:02000000 SPID:60 ECID:0
2006-08-14 15:45:55.04 spid4 SPID: 60 ECID: 0 Statement Type: SELECT
Line #: 40
2006-08-14 15:45:55.04 spid4 Input Buf: RPC Event: spManagePVOrder;1
2006-08-14 15:45:55.04 spid4 Requested By:
2006-08-14 15:45:55.04 spid4 ResType:LockOwner Stype:'OR' Mode: U
SPID:59 ECID:0 Ec:(0x3B241530) Value:0x77a971a0 Cost:(0/0)
2006-08-14 15:45:55.04 spid4
2006-08-14 15:45:55.04 spid4 Node:2
2006-08-14 15:45:55.04 spid4 PAG: 12:1:144496 CleanCnt:1
Mode: SIX Flags: 0x0
2006-08-14 15:45:55.04 spid4 Grant List 1::
2006-08-14 15:45:55.04 spid4 Owner:0x3f81bce0 Mode: SIX Flg:0x0
Ref:0 Life:02000000 SPID:59 ECID:0
2006-08-14 15:45:55.04 spid4 SPID: 59 ECID: 0 Statement Type: DELETE
Line #: 136
2006-08-14 15:45:55.04 spid4 Input Buf: RPC Event: sp_executesql;1
2006-08-14 15:45:55.04 spid4 Requested By:
2006-08-14 15:45:55.04 spid4 ResType:LockOwner Stype:'OR' Mode: S
SPID:60 ECID:0 Ec:(0x6D8454E8) Value:0x77a97a00 Cost:(0/0)
2006-08-14 15:45:55.04 spid4 Victim Resource Owner:
2006-08-14 15:45:55.04 spid4 ResType:LockOwner Stype:'OR' Mode: S
SPID:60 ECID:0 Ec:(0x6D8454E8) Value:0x77a97a00 Cost:(0/0)
I am not sure how to interpretate this. Please let me know if the following
statements are correct:
- Node 1 is a table index (KEY: 9:363864363:1) which was blocked by a SELECT
statement in line 40 of the store procedure sp_managePVorder. This Node was
also requested by process 59 (sp_executesql).
- Node 2 is PAG: 12:1:144496 (???) which was blocked by a DELETE statement
in store procedure sp_executesql. This Node was also requested by process 60
(sp_managePVorder).
- The victim of the deadlock is process 60, which means this process didn't
finish successfully its execution.
My questions would be:
- It is Ok my interpretation ?
- How can I know what object is PAG: 12:1:144496. I tried DBCC PAGE
(12,144496,1) but all I get is message "DBCC execution completed. If DBCC
printed error messages, contact your system administrator."
- I have control only over the store procedure spManageorder. How could I
avoid the deadlock ?.
Regards,
Pablo Silva
Pablo.Silva@aspentech.com
|