fork download
copy 
  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
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Standard output is empty
https://ideone.com/yuU9td
language:
Text (text 6.10)
created:
10 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!