fork download
  1. <deadlock-list>
  2. <deadlock victim="process6593498">
  3. <process-list>
  4. <process id="process6593498" taskpriority="0" logused="0" waitresource="PAGE: 46:1:25319 " waittime="19337" ownerId="4542574113" transactionname="user_transaction" lasttranstarted="2013-07-26T18:21:47.380" XDES="0x6f5d23cb0" lockMode="S" schedulerid="7" kpid="5232" status="suspended" spid="144" sbid="0" ecid="5" priority="0" trancount="0" lastbatchstarted="2013-07-26T18:21:47.373" lastbatchcompleted="2013-07-26T18:21:47.373" lastattention="1900-01-01T00:00:00.373" clientapp=".Net SqlClient Data Provider" hostname="PORTAL" hostpid="3804" isolationlevel="read committed (2)" xactid="4542574113" currentdb="46" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
  5. <executionStack>
  6. <frame procname="adhoc" line="1" stmtstart="166" sqlhandle="0x0200000058cc821a46d092833b8faccd3a332eb1ad3f69740000000000000000000000000000000000000000">
  7. SELECT * FROM [WP_CashCenter_StockContainer] WHERE [PreannouncementType] = 0 AND ([Number] = @number OR [SecondNumber] = @number OR [PermanentNumber] = @number) AND ( [Type] IN (1,2) OR [Type] IS NULL ) </frame>
  8. <frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000">
  9. unknown </frame>
  10. </executionStack>
  11. <inputbuf>
  12. (@number nvarchar(18),@secondNumber nvarchar(4000),@permanentNumber nvarchar(4000))SELECT * FROM [WP_CashCenter_StockContainer] WHERE [PreannouncementType] = 0 AND ([Number] = @number OR [SecondNumber] = @number OR [PermanentNumber] = @number) AND ( [Type] IN (1,2) OR [Type] IS NULL ) </inputbuf>
  13. </process>
  14. <process id="process5cc1498" taskpriority="0" logused="10000" waittime="19324" schedulerid="5" kpid="4184" status="suspended" spid="144" sbid="0" ecid="0" priority="0" trancount="1" lastbatchstarted="2013-07-26T18:21:47.373" lastbatchcompleted="2013-07-26T18:21:47.373" lastattention="2013-07-26T17:15:04.347" clientapp=".Net SqlClient Data Provider" hostname="PORTAL" hostpid="3804" loginname="IIS APPPOOL\ASP.NET v4.0 Classic" isolationlevel="read committed (2)" xactid="4542574113" currentdb="46" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
  15. <executionStack>
  16. <frame procname="adhoc" line="1" stmtstart="166" sqlhandle="0x0200000058cc821a46d092833b8faccd3a332eb1ad3f69740000000000000000000000000000000000000000">
  17. SELECT * FROM [WP_CashCenter_StockContainer] WHERE [PreannouncementType] = 0 AND ([Number] = @number OR [SecondNumber] = @number OR [PermanentNumber] = @number) AND ( [Type] IN (1,2) OR [Type] IS NULL ) </frame>
  18. <frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000">
  19. unknown </frame>
  20. </executionStack>
  21. <inputbuf>
  22. (@number nvarchar(18),@secondNumber nvarchar(4000),@permanentNumber nvarchar(4000))SELECT * FROM [WP_CashCenter_StockContainer] WHERE [PreannouncementType] = 0 AND ([Number] = @number OR [SecondNumber] = @number OR [PermanentNumber] = @number) AND ( [Type] IN (1,2) OR [Type] IS NULL ) </inputbuf>
  23. </process>
  24. <process id="process5332cf8" taskpriority="0" logused="337420" waitresource="PAGE: 46:1:22665 " waittime="4471" ownerId="4542347955" transactionname="user_transaction" lasttranstarted="2013-07-26T18:21:42.883" XDES="0x6c4f1f6a8" lockMode="IX" schedulerid="8" kpid="4812" status="suspended" spid="126" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2013-07-26T18:22:02.280" lastbatchcompleted="2013-07-26T18:22:02.277" lastattention="1900-01-01T00:00:00.277" clientapp=".Net SqlClient Data Provider" hostname="PORTAL" hostpid="3804" loginname="IIS APPPOOL\ASP.NET v4.0 Classic" isolationlevel="snapshot (5)" xactid="4542347955" currentdb="46" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
  25. <executionStack>
  26. <frame procname="adhoc" line="1" stmtstart="1132" sqlhandle="0x02000000f2c9e01e497fe5f30fa866b1b7802362db0da14d0000000000000000000000000000000000000000">
  27. UPDATE [WP_CashCenter_StockContainer] SET [number] = @number, [type] = @type, [preannouncementtype] = @preannouncementtype, [servicedate] = @servicedate, [status] = @status, [totalquantity] = @totalquantity, [totalvalue] = @totalvalue, [totalweight] = @totalweight, [datecreated] = @datecreated, [dateupdated] = @dateupdated, [stockorder_id] = @stockorder_id, [parentcontainer_id] = @parentcontainer_id, [locationfrom_id] = @locationfrom_id, [locationto_id] = @locationto_id, [isexpected] = @isexpected, [isopen] = @isopen, [ismissing] = @ismissing, [ismisscan] = @ismisscan, [datecollected] = @datecollected, [ismultienvelope] = @ismultienvelope, [uid] = @uid, [isprecrediting] = @isprecrediting, [isfordispatching] = @isfordispatching, [isdetonated] = @isdetonated, [isonhold] = @isonhold, [iscancelled] = @iscancelled, [editor_id] = @editor_id WHERE [id] = @id </frame>
  28. <frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000">
  29. unknown </frame>
  30. </executionStack>
  31. <inputbuf>
  32. (@number nvarchar(18),@type int,@preannouncementtype int,@servicedate datetime,@status int,@totalquantity int,@totalvalue decimal(2,2),@totalweight decimal(5,5),@datecreated datetime,@dateupdated datetime,@stockorder_id bigint,@parentcontainer_id bigint,@locationfrom_id decimal(10,0),@locationto_id decimal(10,0),@isexpected bit,@isopen bit,@ismissing bit,@ismisscan bit,@datecollected datetime,@ismultienvelope bit,@uid uniqueidentifier,@isprecrediting bit,@isfordispatching bit,@isdetonated bit,@isonhold bit,@iscancelled bit,@editor_id nvarchar(4000),@id bigint)UPDATE [WP_CashCenter_StockContainer] SET [number] = @number, [type] = @type, [preannouncementtype] = @preannouncementtype, [servicedate] = @servicedate, [status] = @status, [totalquantity] = @totalquantity, [totalvalue] = @totalvalue, [totalweight] = @totalweight, [datecreated] = @datecreated, [dateupdated] = @dateupdated, [stockorder_id] = @stockorder_id, [parentcontainer_id] = @parentcontainer_id, [locationfrom_id] = @locationfrom_id, [locationto_id] </inputbuf>
  33. </process>
  34. </process-list>
  35. <resource-list>
  36. <pagelock fileid="1" pageid="25319" dbid="46" subresource="FULL" objectname="Test4.dbo.WP_CashCenter_StockContainer" id="lock86f7f3b00" mode="IX" associatedObjectId="72057594131972096">
  37. <owner-list>
  38. <owner id="process5332cf8" mode="IX"/>
  39. </owner-list>
  40. <waiter-list>
  41. <waiter id="process6593498" mode="S" requestType="wait"/>
  42. </waiter-list>
  43. </pagelock>
  44. <exchangeEvent id="Pipe7f878a500" WaitType="e_waitPipeGetRow" nodeId="0">
  45. <owner-list>
  46. <owner id="process6593498"/>
  47. </owner-list>
  48. <waiter-list>
  49. <waiter id="process5cc1498"/>
  50. </waiter-list>
  51. </exchangeEvent>
  52. <pagelock fileid="1" pageid="22665" dbid="46" subresource="FULL" objectname="Test4.dbo.WP_CashCenter_StockContainer" id="lock9076d5d00" mode="S" associatedObjectId="72057594131972096">
  53. <owner-list>
  54. <owner id="process5cc1498" mode="S"/>
  55. </owner-list>
  56. <waiter-list>
  57. <waiter id="process5332cf8" mode="IX" requestType="wait"/>
  58. </waiter-list>
  59. </pagelock>
  60. </resource-list>
  61. </deadlock>
  62. </deadlock-list>
  63.  
Not running #stdin #stdout 0s 0KB
stdin
Standard input is empty
stdout

Standard output is empty