Skip to content

Instantly share code, notes, and snippets.

@hakandilek
Created July 13, 2013 14:13
Show Gist options
  • Save hakandilek/5990850 to your computer and use it in GitHub Desktop.
Save hakandilek/5990850 to your computer and use it in GitHub Desktop.
mssql server deadlock2
2013-07-09 16:30:57.09 spid8s Deadlock encountered .... Printing deadlock information
2013-07-09 16:30:57.09 spid8s Wait-for graph
2013-07-09 16:30:57.09 spid8s
2013-07-09 16:30:57.09 spid8s Node:1
2013-07-09 16:30:57.09 spid8s KEY: 7:72057629167386624 (6afd4a6f08c4) CleanCnt:5 Mode:U Flags: 0x1
2013-07-09 16:30:57.09 spid8s Grant List 0:
2013-07-09 16:30:57.09 spid8s Owner:0x0000000B328E4200 Mode: U Flg:0x40 Ref:0 Life:00000001 SPID:199 ECID:0 XactLockInfo: 0x0000000CA29A0EC0
2013-07-09 16:30:57.09 spid8s SPID: 199 ECID: 0 Statement Type: MERGE Line #: 19
2013-07-09 16:30:57.09 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:57.09 spid8s Requested by:
2013-07-09 16:30:57.09 spid8s ResType:LockOwner Stype:'OR'Xdes:0x0000000C5816D730 Mode: U SPID:206 BatchID:2 ECID:0 TaskProxy:(0x0000000DB5F22540) Value:0x700ad1c0 Cost:(0/1528)
2013-07-09 16:30:57.09 spid8s
2013-07-09 16:30:57.09 spid8s Node:2
2013-07-09 16:30:57.09 spid8s KEY: 7:72057629167386624 (11f81edf19ac) CleanCnt:2 Mode:X Flags: 0x1
2013-07-09 16:30:57.09 spid8s Grant List 2:
2013-07-09 16:30:57.09 spid8s Owner:0x0000001146084BC0 Mode: X Flg:0x40 Ref:0 Life:02000000 SPID:124 ECID:0 XactLockInfo: 0x0000000C5816CEC0
2013-07-09 16:30:57.09 spid8s SPID: 124 ECID: 0 Statement Type: MERGE Line #: 28
2013-07-09 16:30:57.09 spid8s Input Buf: Language Event: (@0 uniqueidentifier)update [dbo].[MonthlyActionValue]
set [ForecastValue] = null
where ([Id] = @0)
select [CalculatedValue]
from [dbo].[MonthlyActionValue]
where @@ROWCOUNT > 0 and [Id] = @0
2013-07-09 16:30:57.09 spid8s Requested by:
2013-07-09 16:30:57.09 spid8s ResType:LockOwner Stype:'OR'Xdes:0x0000000CA29A0E80 Mode: U SPID:199 BatchID:2 ECID:0 TaskProxy:(0x000000038CA60540) Value:0xf8228f00 Cost:(0/3988)
2013-07-09 16:30:57.09 spid8s
2013-07-09 16:30:57.09 spid8s Node:3
2013-07-09 16:30:57.09 spid8s KEY: 7:72057629167386624 (6afd4a6f08c4) CleanCnt:5 Mode:U Flags: 0x1
2013-07-09 16:30:57.09 spid8s Wait List:
2013-07-09 16:30:57.09 spid8s Owner:0x00000011700AD1C0 Mode: U Flg:0x42 Ref:1 Life:00000001 SPID:206 ECID:0 XactLockInfo: 0x0000000C5816D770
2013-07-09 16:30:57.09 spid8s SPID: 206 ECID: 0 Statement Type: MERGE Line #: 19
2013-07-09 16:30:57.09 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:57.09 spid8s Requested by:
2013-07-09 16:30:57.09 spid8s ResType:LockOwner Stype:'OR'Xdes:0x0000000C5816CE80 Mode: U SPID:124 BatchID:2 ECID:0 TaskProxy:(0x0000000664CCE540) Value:0x7068fa80 Cost:(0/16188)
2013-07-09 16:30:57.09 spid8s
2013-07-09 16:30:57.09 spid8s Victim Resource Owner:
2013-07-09 16:30:57.09 spid8s ResType:LockOwner Stype:'OR'Xdes:0x0000000C5816D730 Mode: U SPID:206 BatchID:2 ECID:0 TaskProxy:(0x0000000DB5F22540) Value:0x700ad1c0 Cost:(0/1528)
2
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment