API tools faq
paste
Advertisement
Guest User

DeadLock

a guest
Jun 15th, 2016
215
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.97 KB | None | 0 0
raw download clone embed print report
  1.  
  2. 2016-06-14 13:56:21.750 spid8s Deadlock encountered .... Printing deadlock information
  3. 2016-06-14 13:56:21.750 spid8s Wait-for graph
  4. 2016-06-14 13:56:21.750 spid8s NULL
  5. 2016-06-14 13:56:21.750 spid8s Node:1
  6. 2016-06-14 13:56:21.750 spid8s OBJECT: 10:1520724470:15 CleanCnt:2 Mode:S Flags: 0x1
  7. 2016-06-14 13:56:21.750 spid8s Grant List 0:
  8. 2016-06-14 13:56:21.750 spid8s Owner:0x000000071234DC00 Mode: S Flg:0x40 Ref:0 Life:20000000 SPID:187 ECID:0 XactLockInfo: 0x00000000800A9AD0
  9. 2016-06-14 13:56:21.750 spid8s SPID: 187 ECID: 0 Statement Type: SELECT Line #: 8
  10. 2016-06-14 13:56:21.750 spid8s Input Buf: RPC Event: Proc [Database Id = 10 Object Id = 301452348]
  11. 2016-06-14 13:56:21.750 spid8s Requested by:
  12. 2016-06-14 13:56:21.750 spid8s ResType:LockOwner Stype:'OR'Xdes:0x0000000766918B50 Mode: IX SPID:186 BatchID:0 ECID:0 TaskProxy:(0x0000000C785F2540) Value:0x6deeb680 Cost:(5/34960)
  13. 2016-06-14 13:56:21.750 spid8s NULL
  14. 2016-06-14 13:56:21.750 spid8s Node:2
  15. 2016-06-14 13:56:21.750 spid8s PAGE: 10:1:787903 CleanCnt:2 Mode:IX Flags: 0x3
  16. 2016-06-14 13:56:21.750 spid8s Grant List 1:
  17. 2016-06-14 13:56:21.750 spid8s Owner:0x00000008D87482C0 Mode: IX Flg:0x40 Ref:0 Life:02000000 SPID:186 ECID:0 XactLockInfo: 0x0000000766918B90
  18. 2016-06-14 13:56:21.750 spid8s SPID: 186 ECID: 0 Statement Type: INSERT Line #: 468
  19. 2016-06-14 13:56:21.750 spid8s Input Buf: RPC Event: Proc [Database Id = 10 Object Id = 2060742594]
  20. 2016-06-14 13:56:21.750 spid8s Requested by:
  21. 2016-06-14 13:56:21.750 spid8s ResType:LockOwner Stype:'OR'Xdes:0x00000000800A9A90 Mode: S SPID:187 BatchID:0 ECID:0 TaskProxy:(0x00000012886FE540) Value:0x8a0b6840 Cost:(0/0)
  22. 2016-06-14 13:56:21.750 spid8s NULL
  23. 2016-06-14 13:56:21.750 spid8s Victim Resource Owner:
  24. 2016-06-14 13:56:21.750 spid8s ResType:LockOwner Stype:'OR'Xdes:0x0000000766918B50 Mode: IX SPID:186 BatchID:0 ECID:0 TaskProxy:(0x0000000C785F2540) Value:0x6deeb680 Cost:(5/34960)
  25. 2016-06-14 13:56:21.750 spid18s deadlock-list
  26. 2016-06-14 13:56:21.750 spid18s deadlock victim=process56df048
  27. 2016-06-14 13:56:21.750 spid18s process-list
  28. 2016-06-14 13:56:21.750 spid18s process id=process56df048 taskpriority=5 logused=34960 waitresource=OBJECT: 10:1520724470:15 waittime=568 ownerId=3203602771 transactionname=user_transaction lasttranstarted=2016-06-14T13:56:17.993 XDES=0x766918b50 lockMode=IX schedulerid=16 kpid=12880
  29. 2016-06-14 13:56:21.750 spid18s executionStack
  30. 2016-06-14 13:56:21.750 spid18s frame procname=materialinmotioninc.dbo.sproc_VoidDocumentBody line=468 stmtstart=36988 stmtend=40008 sqlhandle=0x03000a00b0f59d489fd49300daa300000100000000000000
  31. 2016-06-14 13:56:21.750 spid18s INSERT INTO PostingTable
  32. (
  33. FinancialAccountID,
  34. AmountDebit,
  35. AmountCredit,
  36. PostingType,
  37. DocumentLineID,
  38. TaxCodeID,
  39. TaxPercentage,
  40. TransactionID,
  41. AccountID,
  42. FinancialDateTime,
  43. JobAccountID
  44. 2016-06-14 13:56:21.750 spid18s frame procname=materialinmotioninc.dbo.sproc_ProcessJournalEntrySheet line=197 stmtstart=20398 stmtend=20576 sqlhandle=0x03000a00c26fd47a0cd69300daa300000100000000000000
  45. 2016-06-14 13:56:21.750 spid18s EXEC @ReturnValue = sproc_VoidDocumentBody @DocumentID = @UpdateFromEntityID
  46. 2016-06-14 13:56:21.750 spid18s inputbuf
  47. 2016-06-14 13:56:21.750 spid18s Proc [Database Id = 10 Object Id = 2060742594]
  48. 2016-06-14 13:56:21.750 spid18s process id=process4e4c508 taskpriority=0 logused=0 waitresource=PAGE: 10:1:787903 waittime=2272 ownerId=3203599914 transactionname=SELECT lasttranstarted=2016-06-14T13:56:17.030 XDES=0x800a9a90 lockMode=S schedulerid=6 kpid=2924 status=suspended spid=18
  49. executionStack
  50. 2016-06-14 13:56:21.750 spid18s frame procname=materialinmotioninc.dbo.spRptCFTReceivables line=8 stmtstart=190 stmtend=2334 sqlhandle=0x03000a003cccf711aad29300daa300000100000000000000
  51. 2016-06-14 13:56:21.750 spid18s SELECT CAST (CASE WHEN (rpt.DueDate > @ToDate) THEN 0 ELSE 1 END as bit) as Checked,
  52. 2016-06-14 13:56:21.750 spid18s CASE WHEN (DEV.DocumentType = /* EnumValue DocumentType.CustomerPayment */ 11 /*End*/)
  53. 2016-06-14 13:56:21.750 spid18s THEN 4
  54. 2016-06-14 13:56:21.750 spid18s WHEN (DEV.DocumentType = /* EnumValue DocumentType.CashInvoiceDocument */ 8 /*End*/)
  55. 2016-06-14 13:56:21.750 spid18s THEN 8
  56. 2016-06-14 13:56:21.750 spid18s WHEN (DEV.DocumentType = /* EnumValue DocumentType.CustomerCreditMemo */ 5 /*End*/)
  57. 2016-06-14 13:56:21.750 spid18s THEN 10
  58. 2016-06-14 13:56:21.750 spid18s WHEN (DEV.DocumentType = /* EnumValue DocumentType.JournalEntry */ 10 /*End*/)
  59. 2016-06-14 13:56:21.750 spid18s THEN 11
  60. 2016-06-14 13:56:21.750 spid18s WHEN (DEV.DocumentType = /* EnumValue DocumentType.CustomerRefund */ 24 /*End*/)
  61. 2016-06-14 13:56:21.750 spid18s THEN 14
  62. 2016-06-14 13:56:21.750 spid18s ELSE 3
  63. 2016-06-14 13:56:21.750 spid18s END AS Icon,
  64. 2016-06-14 13:56:21.750 spid18s rpt.FriendlyDocumentName,
  65. 2016-06-14 13:56:21.750 spid18s acct.AccountID as AccountID, acct.Name as CustomerName,
  66. 2016-06-14 13:56:21.750 spid18s rpt.DocumentDisplayNumber, rpt.AlphaPart, rpt.IntegerPart,
  67. 2016-06-14 13:56:21.750 spid18s rpt.DueDate, rpt.OpenBalanceCompanyCurrency as BalanceCompanyCurrency,
  68. 2016-06-14 13:56:21.750 spid18s rpt.DocumentID,
  69. 2016-06-14 13:56:21.750 spid18s rpt.TransactionID FROM fnRptGetARAgingZoomReport(@ToDate) AS rpt
  70. 2016-06-14 13:56:21.750 spid18s INNER JOIN AccountTable AS acct ON rpt.AccountID = acct.AccountID
  71. 2016-06-14 13:56:21.750 spid18s INNER JOIN DocumentEntityView AS DEV
  72. 2016-06-14 13:56:21.750 spid18s ON DEV.Docu
  73. 2016-06-14 13:56:21.750 spid18s inputbuf
  74. 2016-06-14 13:56:21.750 spid18s Proc [Database Id = 10 Object Id = 301452348]
  75. 2016-06-14 13:56:21.750 spid18s resource-list
  76. 2016-06-14 13:56:21.750 spid18s objectlock lockPartition=15 objid=1520724470 subresource=FULL dbid=10 objectname=materialinmotioninc.dbo.PostingTable id=lock710b65180 mode=S associatedObjectId=1520724470
  77. 2016-06-14 13:56:21.750 spid18s owner-list
  78. 2016-06-14 13:56:21.750 spid18s owner id=process4e4c508 mode=S
  79. 2016-06-14 13:56:21.750 spid18s waiter-list
  80. 2016-06-14 13:56:21.750 spid18s waiter id=process56df048 mode=IX requestType=wait
  81.  
  82. 2016-06-14 13:56:21.750 spid18s pagelock fileid=1 pageid=787903 dbid=10 objectname=materialinmotioninc.dbo.DocumentTable id=lock9935b4180 mode=IX associatedObjectId=72057596161949696
  83. 2016-06-14 13:56:21.750 spid18s owner-list
  84. 2016-06-14 13:56:21.750 spid18s owner id=process56df048 mode=IX
  85. 2016-06-14 13:56:21.750 spid18s waiter-list
  86. 2016-06-14 13:56:21.750 spid18s waiter id=process4e4c508 mode=S requestType=wait
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!