Created
July 13, 2013 14:13
-
-
Save hakandilek/5990850 to your computer and use it in GitHub Desktop.
mssql server deadlock2
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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