Created
July 13, 2013 14:11
-
-
Save hakandilek/5990846 to your computer and use it in GitHub Desktop.
mssalserver deadlock
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: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