Skip to content

Instantly share code, notes, and snippets.

@hakandilek
Created July 13, 2013 14:11
Show Gist options
  • Save hakandilek/5990846 to your computer and use it in GitHub Desktop.
Save hakandilek/5990846 to your computer and use it in GitHub Desktop.
mssalserver deadlock
2013-07-09 16:30:49.56 spid8s Deadlock encountered .... Printing deadlock information
2013-07-09 16:30:49.56 spid8s Wait-for graph
2013-07-09 16:30:49.56 spid8s
2013-07-09 16:30:49.56 spid8s Node:1
2013-07-09 16:30:49.56 spid8s KEY: 7:72057629167386624 (5e585b32bf37) CleanCnt:2 Mode:X Flags: 0x1
2013-07-09 16:30:49.56 spid8s Grant List 0:
2013-07-09 16:30:49.56 spid8s Owner:0x0000000C4B80D740 Mode: X Flg:0x40 Ref:0 Life:02000000 SPID:93 ECID:0 XactLockInfo: 0x00000009BCBFB990
2013-07-09 16:30:49.56 spid8s SPID: 93 ECID: 0 Statement Type: MERGE Line #: 19
2013-07-09 16:30:49.56 spid8s Input Buf: Language Event: (@0 nvarchar(255),@1 nvarchar(max) ,@2 nvarchar(max) ,@3 nvarchar(max) ,@4 uniqueidentifier,@5 uniqueidentifier,@6 uniqueidentifier,@7 uniqueidentifier,@8 uniqueidentifier,@9 int,@10 int,@11 uniqueidentifier,@12 nvarchar(max) ,@13 bit,@14 decimal(18,4),@1
2013-07-09 16:30:49.56 spid8s Requested by:
2013-07-09 16:30:49.56 spid8s ResType:LockOwner Stype:'OR'Xdes:0x00000012896D5950 Mode: U SPID:237 BatchID:2 ECID:0 TaskProxy:(0x00000011D5840540) Value:0x5548c2c0 Cost:(0/1956)
2013-07-09 16:30:49.56 spid8s
2013-07-09 16:30:49.56 spid8s Node:2
2013-07-09 16:30:49.56 spid8s KEY: 7:72057629167386624 (6afd4a6f08c4) CleanCnt:3 Mode:U Flags: 0x1
2013-07-09 16:30:49.56 spid8s Grant List 2:
2013-07-09 16:30:49.56 spid8s Owner:0x0000001182A9A100 Mode: U Flg:0x40 Ref:0 Life:00000001 SPID:237 ECID:0 XactLockInfo: 0x00000012896D5990
2013-07-09 16:30:49.56 spid8s SPID: 237 ECID: 0 Statement Type: MERGE Line #: 19
2013-07-09 16:30:49.56 spid8s Input Buf: Language Event: (@0 nvarchar(255),@1 nvarchar(max) ,@2 nvarchar(max) ,@3 nvarchar(max) ,@4 uniqueidentifier,@5 uniqueidentifier,@6 uniqueidentifier,@7 uniqueidentifier,@8 uniqueidentifier,@9 int,@10 int,@11 uniqueidentifier,@12 nvarchar(max) ,@13 bit,@14 decimal(18,4),@1
2013-07-09 16:30:49.56 spid8s Requested by:
2013-07-09 16:30:49.56 spid8s ResType:LockOwner Stype:'OR'Xdes:0x00000009BCBFB950 Mode: U SPID:93 BatchID:2 ECID:0 TaskProxy:(0x00000004DF2CE540) Value:0x5194ef00 Cost:(0/71324)
2013-07-09 16:30:49.56 spid8s
2013-07-09 16:30:49.56 spid8s Victim Resource Owner:
2013-07-09 16:30:49.56 spid8s ResType:LockOwner Stype:'OR'Xdes:0x00000012896D5950 Mode: U SPID:237 BatchID:2 ECID:0 TaskProxy:(0x00000011D5840540) Value:0x5548c2c0 Cost:(0/1956)
2013-07-09 16:30:53.54 spid64 DBCC TRACEOFF 1, server process ID (SPID) 64. This is an informational message only; no user action is required.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment