API tools faq
paste
Guest User

XDL deadlock info

a guest
Mar 17th, 2013
323
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.69 KB | None | 0 0
raw download clone embed print report
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <deadlock-list>
  3. <deadlock victim="process5b2cef8">
  4. <process-list>
  5. <process id="process5700ef8" taskpriority="0" logused="10002" waittime="4984" schedulerid="4" kpid="5472" status="suspended" spid="116" sbid="0" ecid="0" priority="0" transcount="1" lastbatchstarted="2013-03-04T13:32:56.450" lastbatchcompleted="2013-03-04T13:32:56.450" lastattention="2013-03-04T13:30:52.377" clientapp="jTDS" hostname="CDCDPAS2" hostpid="123" loginname="prod" isolationlevel="read committed (2)" xactid="449849894" currentdb="6" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128058">
  6. <executionStack>
  7. <frame procname="adhoc" line="1" stmtstart="264" sqlhandle="0x02000000f5e5993a52a6d7a03b7c3be641d9392876f1af6a">
  8. select ordersumma0_.ID as ID33_, ordersumma0_.TRANSACTIONID as TRANSACT2_33_, ordersumma0_.ORDERID as ORDERID33_, ordersumma0_.ORDERTYPE as ORDERTYPE33_, ordersumma0_.ORDERSTATUS as ORDERSTA5_33_, ordersumma0_.ORDERDISPATCHSTATUS as ORDERDIS6_33_, ordersumma0_.ORDERSIEBELINTERMEDIATESTATUS as ORDERSIE7_33_, ordersumma0_.ORDERINITDATE as ORDERINI8_33_, ordersumma0_.ORDERLASTACTIONDATE as ORDERLAS9_33_, ordersumma0_.CUSTOMERCODE as CUSTOME10_33_, ordersumma0_.CUSTOMERFIRSTNAME as CUSTOME11_33_, ordersumma0_.CUSTOMERLASTNAME as CUSTOME12_33_, ordersumma0_.SEGMENT as SEGMENT33_, ordersumma0_.SUBSEGMENT as SUBSEGMENT33_, ordersumma0_.CUSTOMERIDTYPE as CUSTOME15_33_, ordersumma0_.CUSTOMERIDNUMBER as CUSTOME16_33_, ordersumma0_.IMEI as IMEI33_, ordersumma0_.ACTIVE as ACTIVE33_, ordersumma0_.USERNAME as USERNAME33_, ordersumma0_.ELN as ELN33_, ordersumma0_.DEALERSHOPID as DEALERS21_33_, ordersumma0_.DEALERSHOPNAME as DEALERS22_33_, ordersumma0_.DEALERCHAINID as DEALERC23_33_, ordersumma0_.DEALERCHAINNAME as DEALERC24 </frame>
  9. </executionStack>
  10. <inputbuf>
  11. (@P0 int,@P1 nvarchar(4000),@P2 nvarchar(4000),@P3 nvarchar(4000),@P4 int,@P5 int,@P6 int,@P7 int,@P8 int,@P9 int,@P10 int,@P11 int)select ordersumma0_.ID as ID33_, ordersumma0_.TRANSACTIONID as TRANSACT2_33_, ordersumma0_.ORDERID as ORDERID33_, ordersumma0_.ORDERTYPE as ORDERTYPE33_, ordersumma0_.ORDERSTATUS as ORDERSTA5_33_, ordersumma0_.ORDERDISPATCHSTATUS as ORDERDIS6_33_, ordersumma0_.ORDERSIEBELINTERMEDIATESTATUS as ORDERSIE7_33_, ordersumma0_.ORDERINITDATE as ORDERINI8_33_, ordersumma0_.ORDERLASTACTIONDATE as ORDERLAS9_33_, ordersumma0_.CUSTOMERCODE as CUSTOME10_33_, ordersumma0_.CUSTOMERFIRSTNAME as CUSTOME11_33_, ordersumma0_.CUSTOMERLASTNAME as CUSTOME12_33_, ordersumma0_.SEGMENT as SEGMENT33_, ordersumma0_.SUBSEGMENT as SUBSEGMENT33_, ordersumma0_.CUSTOMERIDTYPE as CUSTOME15_33_, ordersumma0_.CUSTOMERIDNUMBER as CUSTOME16_33_, ordersumma0_.IMEI as IMEI33_, ordersumma0_.ACTIVE as ACTIVE33_, ordersumma0_.USERNAME as USERNAME33_, ordersumma0_.ELN as ELN33_, ordersumma0_.DEALERSHOPID as DEALERS21_33_, </inputbuf>
  12. </process>
  13. <process id="process5b2cef8" taskpriority="0" logused="0" waitresource="KEY: 6:72057594079870976 (d100dbc6890a)" waittime="7890" ownerId="449849894" transactionname="implicit_transaction" lasttranstarted="2013-03-04T13:32:56.450" XDES="0x3a63c4080" lockMode="U" schedulerid="6" kpid="2860" status="suspended" spid="116" sbid="0" ecid="5" priority="0" transcount="0" lastbatchstarted="2013-03-04T13:32:56.450" lastbatchcompleted="2013-03-04T13:32:56.450" clientapp="jTDS" hostname="CDCDPAS2" hostpid="123" isolationlevel="read committed (2)" xactid="449849894" currentdb="6" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128058">
  14. <executionStack>
  15. <frame procname="adhoc" line="1" stmtstart="264" sqlhandle="0x02000000f5e5993a52a6d7a03b7c3be641d9392876f1af6a">
  16. select ordersumma0_.ID as ID33_, ordersumma0_.TRANSACTIONID as TRANSACT2_33_, ordersumma0_.ORDERID as ORDERID33_, ordersumma0_.ORDERTYPE as ORDERTYPE33_, ordersumma0_.ORDERSTATUS as ORDERSTA5_33_, ordersumma0_.ORDERDISPATCHSTATUS as ORDERDIS6_33_, ordersumma0_.ORDERSIEBELINTERMEDIATESTATUS as ORDERSIE7_33_, ordersumma0_.ORDERINITDATE as ORDERINI8_33_, ordersumma0_.ORDERLASTACTIONDATE as ORDERLAS9_33_, ordersumma0_.CUSTOMERCODE as CUSTOME10_33_, ordersumma0_.CUSTOMERFIRSTNAME as CUSTOME11_33_, ordersumma0_.CUSTOMERLASTNAME as CUSTOME12_33_, ordersumma0_.SEGMENT as SEGMENT33_, ordersumma0_.SUBSEGMENT as SUBSEGMENT33_, ordersumma0_.CUSTOMERIDTYPE as CUSTOME15_33_, ordersumma0_.CUSTOMERIDNUMBER as CUSTOME16_33_, ordersumma0_.IMEI as IMEI33_, ordersumma0_.ACTIVE as ACTIVE33_, ordersumma0_.USERNAME as USERNAME33_, ordersumma0_.ELN as ELN33_, ordersumma0_.DEALERSHOPID as DEALERS21_33_, ordersumma0_.DEALERSHOPNAME as DEALERS22_33_, ordersumma0_.DEALERCHAINID as DEALERC23_33_, ordersumma0_.DEALERCHAINNAME as DEALERC24 </frame>
  17. </executionStack>
  18. <inputbuf>
  19. </inputbuf>
  20. </process>
  21. <process id="process6342ef8" taskpriority="0" logused="0" waitresource="KEY: 6:72057594079870976 (d100dbc6890a)" waittime="59015" ownerId="449838479" transactionname="implicit_transaction" lasttranstarted="2013-03-04T13:32:05.333" XDES="0x396e70700" lockMode="U" schedulerid="7" kpid="3484" status="suspended" spid="100" sbid="0" ecid="0" priority="0" transcount="1" lastbatchstarted="2013-03-04T13:32:05.333" lastbatchcompleted="2013-03-04T13:32:05.333" lastattention="2013-03-04T13:30:50.863" clientapp="jTDS" hostname="CDCDPAS4" hostpid="123" loginname="prod" isolationlevel="read committed (2)" xactid="449838479" currentdb="6" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128058">
  22. <executionStack>
  23. <frame procname="adhoc" line="1" stmtstart="224" sqlhandle="0x0200000057a36e1435b3a84e2f060ffc51a5e0acb392e6c7">
  24. select ordersumma0_.ID as ID33_, ordersumma0_.TRANSACTIONID as TRANSACT2_33_, ordersumma0_.ORDERID as ORDERID33_, ordersumma0_.ORDERTYPE as ORDERTYPE33_, ordersumma0_.ORDERSTATUS as ORDERSTA5_33_, ordersumma0_.ORDERDISPATCHSTATUS as ORDERDIS6_33_, ordersumma0_.ORDERSIEBELINTERMEDIATESTATUS as ORDERSIE7_33_, ordersumma0_.ORDERINITDATE as ORDERINI8_33_, ordersumma0_.ORDERLASTACTIONDATE as ORDERLAS9_33_, ordersumma0_.CUSTOMERCODE as CUSTOME10_33_, ordersumma0_.CUSTOMERFIRSTNAME as CUSTOME11_33_, ordersumma0_.CUSTOMERLASTNAME as CUSTOME12_33_, ordersumma0_.SEGMENT as SEGMENT33_, ordersumma0_.SUBSEGMENT as SUBSEGMENT33_, ordersumma0_.CUSTOMERIDTYPE as CUSTOME15_33_, ordersumma0_.CUSTOMERIDNUMBER as CUSTOME16_33_, ordersumma0_.IMEI as IMEI33_, ordersumma0_.ACTIVE as ACTIVE33_, ordersumma0_.USERNAME as USERNAME33_, ordersumma0_.ELN as ELN33_, ordersumma0_.DEALERSHOPID as DEALERS21_33_, ordersumma0_.DEALERSHOPNAME as DEALERS22_33_, ordersumma0_.DEALERCHAINID as DEALERC23_33_, ordersumma0_.DEALERCHAINNAME as DEALERC24 </frame>
  25. </executionStack>
  26. <inputbuf>
  27. (@P0 int,@P1 nvarchar(4000),@P2 nvarchar(4000),@P3 nvarchar(4000),@P4 nvarchar(4000),@P5 nvarchar(4000),@P6 int)select ordersumma0_.ID as ID33_, ordersumma0_.TRANSACTIONID as TRANSACT2_33_, ordersumma0_.ORDERID as ORDERID33_, ordersumma0_.ORDERTYPE as ORDERTYPE33_, ordersumma0_.ORDERSTATUS as ORDERSTA5_33_, ordersumma0_.ORDERDISPATCHSTATUS as ORDERDIS6_33_, ordersumma0_.ORDERSIEBELINTERMEDIATESTATUS as ORDERSIE7_33_, ordersumma0_.ORDERINITDATE as ORDERINI8_33_, ordersumma0_.ORDERLASTACTIONDATE as ORDERLAS9_33_, ordersumma0_.CUSTOMERCODE as CUSTOME10_33_, ordersumma0_.CUSTOMERFIRSTNAME as CUSTOME11_33_, ordersumma0_.CUSTOMERLASTNAME as CUSTOME12_33_, ordersumma0_.SEGMENT as SEGMENT33_, ordersumma0_.SUBSEGMENT as SUBSEGMENT33_, ordersumma0_.CUSTOMERIDTYPE as CUSTOME15_33_, ordersumma0_.CUSTOMERIDNUMBER as CUSTOME16_33_, ordersumma0_.IMEI as IMEI33_, ordersumma0_.ACTIVE as ACTIVE33_, ordersumma0_.USERNAME as USERNAME33_, ordersumma0_.ELN as ELN33_, ordersumma0_.DEALERSHOPID as DEALERS21_33_, ordersumma0_.DEALER </inputbuf>
  28. </process>
  29. <process id="process6359828" taskpriority="0" logused="0" waitresource="KEY: 6:72057594079870976 (f000bc814d99)" waittime="2656" ownerId="449838211" transactionname="implicit_transaction" lasttranstarted="2013-03-04T13:32:04.987" XDES="0x11d65eb60" lockMode="U" schedulerid="8" kpid="10440" status="suspended" spid="89" sbid="0" ecid="0" priority="0" transcount="1" lastbatchstarted="2013-03-04T13:32:04.987" lastbatchcompleted="2013-03-04T13:32:04.987" clientapp="jTDS" hostname="CDCDPAS3" hostpid="123" loginname="prod" isolationlevel="read committed (2)" xactid="449838211" currentdb="6" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128058">
  30. <executionStack>
  31. <frame procname="adhoc" line="1" stmtstart="224" sqlhandle="0x0200000057a36e1435b3a84e2f060ffc51a5e0acb392e6c7">
  32. select ordersumma0_.ID as ID33_, ordersumma0_.TRANSACTIONID as TRANSACT2_33_, ordersumma0_.ORDERID as ORDERID33_, ordersumma0_.ORDERTYPE as ORDERTYPE33_, ordersumma0_.ORDERSTATUS as ORDERSTA5_33_, ordersumma0_.ORDERDISPATCHSTATUS as ORDERDIS6_33_, ordersumma0_.ORDERSIEBELINTERMEDIATESTATUS as ORDERSIE7_33_, ordersumma0_.ORDERINITDATE as ORDERINI8_33_, ordersumma0_.ORDERLASTACTIONDATE as ORDERLAS9_33_, ordersumma0_.CUSTOMERCODE as CUSTOME10_33_, ordersumma0_.CUSTOMERFIRSTNAME as CUSTOME11_33_, ordersumma0_.CUSTOMERLASTNAME as CUSTOME12_33_, ordersumma0_.SEGMENT as SEGMENT33_, ordersumma0_.SUBSEGMENT as SUBSEGMENT33_, ordersumma0_.CUSTOMERIDTYPE as CUSTOME15_33_, ordersumma0_.CUSTOMERIDNUMBER as CUSTOME16_33_, ordersumma0_.IMEI as IMEI33_, ordersumma0_.ACTIVE as ACTIVE33_, ordersumma0_.USERNAME as USERNAME33_, ordersumma0_.ELN as ELN33_, ordersumma0_.DEALERSHOPID as DEALERS21_33_, ordersumma0_.DEALERSHOPNAME as DEALERS22_33_, ordersumma0_.DEALERCHAINID as DEALERC23_33_, ordersumma0_.DEALERCHAINNAME as DEALERC24 </frame>
  33. </executionStack>
  34. <inputbuf>
  35. (@P0 int,@P1 nvarchar(4000),@P2 nvarchar(4000),@P3 nvarchar(4000),@P4 nvarchar(4000),@P5 nvarchar(4000),@P6 int)select ordersumma0_.ID as ID33_, ordersumma0_.TRANSACTIONID as TRANSACT2_33_, ordersumma0_.ORDERID as ORDERID33_, ordersumma0_.ORDERTYPE as ORDERTYPE33_, ordersumma0_.ORDERSTATUS as ORDERSTA5_33_, ordersumma0_.ORDERDISPATCHSTATUS as ORDERDIS6_33_, ordersumma0_.ORDERSIEBELINTERMEDIATESTATUS as ORDERSIE7_33_, ordersumma0_.ORDERINITDATE as ORDERINI8_33_, ordersumma0_.ORDERLASTACTIONDATE as ORDERLAS9_33_, ordersumma0_.CUSTOMERCODE as CUSTOME10_33_, ordersumma0_.CUSTOMERFIRSTNAME as CUSTOME11_33_, ordersumma0_.CUSTOMERLASTNAME as CUSTOME12_33_, ordersumma0_.SEGMENT as SEGMENT33_, ordersumma0_.SUBSEGMENT as SUBSEGMENT33_, ordersumma0_.CUSTOMERIDTYPE as CUSTOME15_33_, ordersumma0_.CUSTOMERIDNUMBER as CUSTOME16_33_, ordersumma0_.IMEI as IMEI33_, ordersumma0_.ACTIVE as ACTIVE33_, ordersumma0_.USERNAME as USERNAME33_, ordersumma0_.ELN as ELN33_, ordersumma0_.DEALERSHOPID as DEALERS21_33_, ordersumma0_.DEALER </inputbuf>
  36. </process>
  37. </process-list>
  38. <resource-list>
  39. <keylock hobtid="72057594079870976" dbid="6" objectname="ProductTables.dbo.TORDERSUMMARY" indexname="PK_TORDERSUMMARY" id="lock23722a280" mode="U" associatedObjectId="72057594079870976">
  40. <owner-list>
  41. <owner id="process6359828" mode="U"/>
  42. </owner-list>
  43. <waiter-list>
  44. <waiter id="process6342ef8" mode="U" requestType="wait"/>
  45. <waiter id="process5b2cef8" mode="U" requestType="wait"/>
  46. </waiter-list>
  47. </keylock>
  48. <exchangeEvent id="port801f8320" nodeId="2">
  49. <owner-list>
  50. <owner event="e_waitNone" type="producer" id="process5b2cef8"/>
  51. </owner-list>
  52. <waiter-list>
  53. <waiter event="e_waitPipeGetRow" type="consumer" id="process5700ef8"/>
  54. </waiter-list>
  55. </exchangeEvent>
  56. <keylock hobtid="72057594079870976" dbid="6" objectname="ProductTables.dbo.TORDERSUMMARY" indexname="PK_TORDERSUMMARY" id="lock244ee9000" mode="U" associatedObjectId="72057594079870976">
  57. <owner-list>
  58. <owner id="process5700ef8" mode="U"/>
  59. </owner-list>
  60. <waiter-list>
  61. <waiter id="process6359828" mode="U" requestType="wait"/>
  62. </waiter-list>
  63. </keylock>
  64. </resource-list>
  65. </deadlock>
  66. </deadlock-list>
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
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!