Guest User

Untitled

a guest
Sep 25th, 2014
244
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Deadlock encountered .... Printing deadlock information
  2. Wait-for graph
  3. NULL
  4. Node:1
  5.  
  6. KEY: 66:72057594059882496 (e94412002af8) CleanCnt:2 Mode:X Flags: 0x1
  7. Grant List 2:
  8. Owner:0x00000001228A2280 Mode: X Flg:0x40 Ref:0 Life:02000000 SPID:78 ECID:0 XactLockInfo: 0x00000002E4A5CEC0
  9. SPID: 78 ECID: 0 Statement Type: INSERT Line #: 89
  10. Input Buf: RPC Event: Proc [Database Id = 66 Object Id = 517576882]
  11. Requested by:
  12. ResType:LockOwner Stype:'OR'Xdes:0x00000001714EFCF0 Mode: RangeS-S SPID:257 BatchID:0 ECID:0 TaskProxy:(0x000000012B7D6540) Value:0xa7350a80 Cost:(0/0)
  13. NULL
  14. Node:2
  15.  
  16. OBJECT: 66:516196889:0 CleanCnt:2 Mode:S Flags: 0x1
  17. Grant List 2:
  18. Grant List 3:
  19. Owner:0x0000000141136940 Mode: S Flg:0x40 Ref:2 Life:02000000 SPID:257 ECID:0 XactLockInfo: 0x00000001714EFD30
  20. SPID: 257 ECID: 0 Statement Type: SELECT Line #: 33
  21. Input Buf: RPC Event: Proc [Database Id = 66 Object Id = 1296723672]
  22. Requested by:
  23. ResType:LockOwner Stype:'OR'Xdes:0x00000002E4A5CE80 Mode: IX SPID:78 BatchID:0 ECID:0 TaskProxy:(0x000000014A296540) Value:0x21b86480 Cost:(0/488)
  24. NULL
  25. Victim Resource Owner:
  26. ResType:LockOwner Stype:'OR'Xdes:0x00000001714EFCF0 Mode: RangeS-S SPID:257 BatchID:0 ECID:0 TaskProxy:(0x000000012B7D6540) Value:0xa7350a80 Cost:(0/0)
  27. deadlock-list
  28. deadlock victim=process139a8db88
  29. process-list
  30. process id=process139a8db88 taskpriority=0 logused=0 waitresource=KEY: 66:72057594059882496 (e94412002af8) waittime=996 ownerId=72432528267 transactionname=SELECT lasttranstarted=2014-09-24T08:48:41.243 XDES=0x1714efcf0 lockMode=RangeS-S schedulerid=5 kpid=25688 status=suspended spid=257 sbid=0 ecid=0 priority=0 trancount=0 lastbatchstarted=2014-09-24T08:48:41.243 lastbatchcompleted=2014-09-24T08:48:41.243 clientapp=.Net SqlClient Data Provider hostname=WGIIS1 hostpid=864 loginname=web_app isolationlevel=serializable (4) xactid=72432528267 currentdb=66 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
  31. executionStack
  32. frame procname=eForms.dbo.Widget_PreApprovalForms_Search line=33 stmtstart=2172 sqlhandle=0x03004200d86e4a4d569d8d0079a300000100000000000000
  33. SELECT DISTINCT
  34. DT.* ,
  35. ISNULL(NULLIF(CAST(DT.FormRegionCode AS VARCHAR(50)), ''),
  36. Region.short_name) AS Region
  37. FROM ( SELECT FBD.FormId ,
  38. FBD.AlternateId ,
  39. FBD.VerificationValue ,
  40. FBD.TypeId AS FormTypeId ,
  41. FBD.FormTypeDescription AS Description ,
  42. FBD.DashboardIcon ,
  43. FBD.CreatedByName AS CreatedByUser ,
  44. CAST(NULL AS VARCHAR(20)) AS NonEmployeeName ,
  45. CAST(NULL AS VARCHAR(20)) AS ForUser ,
  46. FBD.EmployeeOrUserName AS ForDisplayName ,
  47. FBD.EmployeeIndex AS ForEmployeeIndex ,
  48. FBD.FormStatusId ,
  49. FBD.FormStatus AS FormStatusDescription ,
  50. FBD.CreatedDate ,
  51. FBD.ClosedDate ,
  52. DATEDIFF(d, FBD.Create
  53. inputbuf
  54. Proc [Database Id = 66 Object Id = 1296723672]
  55. process id=process6fb9708 taskpriority=0 logused=488 waitresource=OBJECT: 66:516196889:0 waittime=1314 ownerId=72432528155 transactionname=user_transaction lasttranstarted=2014-09-24T08:48:41.090 XDES=0x2e4a5ce80 lockMode=IX schedulerid=5 kpid=33964 status=suspended spid=78 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2014-09-24T08:48:41.440 lastbatchcompleted=2014-09-24T08:48:41.430 clientapp=.Net SqlClient Data Provider hostname=WGIIS2 hostpid=2744 loginname=web_app isolationlevel=serializable (4) xactid=72432528155 currentdb=66 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
  56. executionStack
  57. frame procname=eForms.dbo.RoutePlan_Save line=89 stmtstart=5540 stmtend=7444 sqlhandle=0x03004200b298d91e3a67110132a000000100000000000000
  58. INSERT
  59. INTO [RoutePlan]
  60. (
  61. [RoutePlan].[FormId],
  62. [RoutePlan].[UserId],
  63. [RoutePlan].[Rank],
  64. [RoutePlan].[RoutePlanStatusId],
  65. [RoutePlan].[StatusDate],
  66. [RoutePlan].[Notes],
  67. [RoutePlan].[IsStrict],
  68. [RoutePlan].[RoutePlanResponsibilityId],
  69. [RoutePlan].[IsPostApproval],
  70. [RoutePlan].[ProcessedByUserId],
  71. [RoutePlan].[Deleted],
  72. [RoutePlan].[CreatedById],
  73. [RoutePlan].[CreatedDate]
  74. )
  75. VALUES
  76. (
  77. @localFormId,
  78. @localUserId,
  79. @localRank,
  80. @localRoutePlanStatusId,
  81. @localStatusDate,
  82. @localNotes,
  83. @localIsStrict,
  84. @localRoutePlanResponsibilityId,
  85. @localIsPostApproval,
  86. @localProcessedByUserId,
  87. @localDeleted,
  88. @localCreatedById,
  89. GETDATE()
  90. )
  91. inputbuf
  92. Proc [Database Id = 66 Object Id = 517576882]
  93. resource-list
  94. keylock hobtid=72057594059882496 dbid=66 objectname=eForms.dbo.Form indexname=PK_Forms id=lock204d08500 mode=X associatedObjectId=72057594059882496
  95. owner-list
  96. owner id=process6fb9708 mode=X
  97. waiter-list
  98. waiter id=process139a8db88 mode=RangeS-S requestType=wait
  99. objectlock lockPartition=0 objid=516196889 subresource=FULL dbid=66 objectname=eForms.dbo.RoutePlan id=lock2044c5080 mode=S associatedObjectId=516196889
  100. owner-list
  101. owner id=process139a8db88 mode=S
  102. waiter-list
  103. waiter id=process6fb9708 mode=IX requestType=convert
RAW Paste Data