Advertisement
Guest User

Untitled

a guest
Jan 24th, 2017
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.84 KB | None | 0 0
  1. <deadlock>
  2. <victim-list>
  3. <victimProcess id="process12ce90f848" />
  4. </victim-list>
  5. <process-list>
  6. <process id="process12ce90f848" taskpriority="0" logused="18772" waitresource="RID: 24:1:57228177:30" waittime="623" ownerId="11236734576" transactionname="INSERT" lasttranstarted="2017-01-23T10:31:14.193" XDES="0x2e2994d90" lockMode="S" schedulerid="32" kpid="34436" status="suspended" spid="157" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2017-01-23T10:31:14.197" lastbatchcompleted="2017-01-23T10:31:14.203" lastattention="1900-01-01T00:00:00.203" clientapp="IMG.Share" hostname="WIN01SV0296" hostpid="6660" loginname="IMGUser" isolationlevel="read committed (2)" xactid="11236734576" currentdb="24" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
  7. <executionStack>
  8. <frame procname="adhoc" line="1" stmtstart="160" stmtend="366" sqlhandle="0x0200000036829f178721a0c82c83ea2d38a8f64e8fe365290000000000000000000000000000000000000000">
  9. unknown </frame>
  10. <frame procname="adhoc" line="1" stmtstart="160" stmtend="366" sqlhandle="0x0200000011b8110afdc6128367011dfd02167125c84417d10000000000000000000000000000000000000000">
  11. unknown </frame>
  12. <frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000">
  13. unknown </frame>
  14. </executionStack>
  15. <inputbuf>
  16. (@Bytes varbinary(max) ,@FileName varchar(max) ,@MediaBinaryId uniqueidentifier)INSERT INTO BinaryFileTable ( stream_id, file_stream, name ) VALUES( @MediaBinaryId, @Bytes, @FileName ); </inputbuf>
  17. </process>
  18. <process id="process12cf901c28" taskpriority="0" logused="18832" waitresource="RID: 24:1:56798698:7" waittime="1076" ownerId="11236724841" transactionname="INSERT" lasttranstarted="2017-01-23T10:31:13.847" XDES="0x78e2fb560" lockMode="S" schedulerid="14" kpid="15620" status="suspended" spid="176" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2017-01-23T10:31:13.840" lastbatchcompleted="2017-01-23T10:31:13.843" lastattention="1900-01-01T00:00:00.843" clientapp="IMG.Processor" hostname="WIN03SV0492" hostpid="7424" loginname="IMGUser" isolationlevel="read committed (2)" xactid="11236724841" currentdb="24" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
  19. <executionStack>
  20. <frame procname="adhoc" line="1" stmtstart="160" stmtend="366" sqlhandle="0x0200000036829f178721a0c82c83ea2d38a8f64e8fe365290000000000000000000000000000000000000000">
  21. unknown </frame>
  22. <frame procname="adhoc" line="1" stmtstart="160" stmtend="366" sqlhandle="0x0200000011b8110afdc6128367011dfd02167125c84417d10000000000000000000000000000000000000000">
  23. unknown </frame>
  24. <frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000">
  25. unknown </frame>
  26. </executionStack>
  27. <inputbuf>
  28. (@Bytes varbinary(max) ,@FileName varchar(max) ,@MediaBinaryId uniqueidentifier)INSERT INTO BinaryFileTable ( stream_id, file_stream, name ) VALUES( @MediaBinaryId, @Bytes, @FileName ); </inputbuf>
  29. </process>
  30. </process-list>
  31. <resource-list>
  32. <ridlock fileid="1" pageid="57228177" dbid="24" objectname="IMG_PROD02_BINARIES.prod.BinaryFileTable" id="lock288d692880" mode="X" associatedObjectId="72057594040680448">
  33. <owner-list>
  34. <owner id="process12cf901c28" mode="X" />
  35. </owner-list>
  36. <waiter-list>
  37. <waiter id="process12ce90f848" mode="S" requestType="wait" />
  38. </waiter-list>
  39. </ridlock>
  40. <ridlock fileid="1" pageid="56798698" dbid="24" objectname="IMG_PROD02_BINARIES.prod.BinaryFileTable" id="lock4716c56700" mode="X" associatedObjectId="72057594040680448">
  41. <owner-list>
  42. <owner id="process12ce90f848" mode="X" />
  43. </owner-list>
  44. <waiter-list>
  45. <waiter id="process12cf901c28" mode="S" requestType="wait" />
  46. </waiter-list>
  47. </ridlock>
  48. </resource-list>
  49. </deadlock>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement