Guest User

Untitled

a guest
Mar 20th, 2018
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.33 KB | None | 0 0
  1. <deadlock-list>
  2. <deadlock victim="processb1f0c1498">
  3. <process-list>
  4. <process id="processb1f0c1498" taskpriority="0" logused="2168" waitresource="RID: 27:1:30449:23" waittime="4232" ownerId="20896443558" transactionname="implicit_transaction" lasttranstarted="2018-03-09T16:57:57.037" XDES="0xf225183a8" lockMode="U" schedulerid="8" kpid="9736" status="suspended" spid="72" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2018-03-09T16:57:57.077" lastbatchcompleted="2018-03-09T16:57:57.077" lastattention="1900-01-01T00:00:00.077" clientapp="jTDS" hostname="JIRASVR" hostpid="123" loginname="JiraApp" isolationlevel="read committed (2)" xactid="20896443558" currentdb="27" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128058">
  5. <executionStack>
  6. <frame procname="adhoc" line="1" stmtstart="88" sqlhandle="0x02000000bf7aec1fb39ea87c02d404222bd6af21bd14f0820000000000000000000000000000000000000000">
  7. UPDATE dbo.jiraissue SET DESCRIPTION= @P0 , UPDATED= @P1 WHERE ID= @P2
  8. </frame>
  9. </executionStack>
  10. <inputbuf>
  11. (@P0 nvarchar(4000),@P1 datetime,@P2 bigint)UPDATE dbo.jiraissue SET DESCRIPTION= @P0 , UPDATED= @P1 WHERE ID= @P2
  12. </inputbuf>
  13. </process>
  14. <process id="process1baf46d0c8" taskpriority="0" logused="6364" waitresource="RID: 27:1:6966:18" waittime="4185" ownerId="20896443443" transactionname="implicit_transaction" lasttranstarted="2018-03-09T16:57:56.527" XDES="0xb18f58d28" lockMode="U" schedulerid="11" kpid="5188" status="suspended" spid="75" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2018-03-09T16:57:57.133" lastbatchcompleted="2018-03-09T16:57:57.133" lastattention="1900-01-01T00:00:00.133" clientapp="jTDS" hostname="JIRASVR" hostpid="123" loginname="JiraApp" isolationlevel="read committed (2)" xactid="20896443443" currentdb="27" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128058">
  15. <executionStack>
  16. <frame procname="adhoc" line="1" stmtstart="902" sqlhandle="0x020000007e528313f10b169994e266259a2c9a5bd6df6ee60000000000000000000000000000000000000000">
  17. UPDATE dbo.jiraissue SET pkey= @P0 , issuenum= @P1 , PROJECT= @P2 , REPORTER= @P3 , ASSIGNEE= @P4 , CREATOR= @P5 , issuetype= @P6 , SUMMARY= @P7 , DESCRIPTION= @P8 , ENVIRONMENT= @P9 , PRIORITY= @P10 , RESOLUTION= @P11 , issuestatus= @P12 , CREATED= @P13 , UPDATED= @P14 , DUEDATE= @P15 , RESOLUTIONDATE= @P16 , VOTES= @P17 , WATCHES= @P18 , TIMEORIGINALESTIMATE= @P19 , TIMEESTIMATE= @P20 , TIMESPENT= @P21 , WORKFLOW_ID= @P22 , SECURITY= @P23 , FIXFOR= @P24 , COMPONENT= @P25 WHERE ID= @P26
  18. </frame>
  19. </executionStack>
  20. <inputbuf>
  21. (@P0 nvarchar(4000),@P1 bigint,@P2 bigint,@P3 nvarchar(4000),@P4 nvarchar(4000),@P5 nvarchar(4000),@P6 nvarchar(4000),@P7 nvarchar(4000),@P8 nvarchar(4000),@P9 nvarchar(4000),@P10 nvarchar(4000),@P11 nvarchar(4000),@P12 nvarchar(4000),@P13 datetime,@P14 datetime,@P15 datetime,@P16 datetime,@P17 bigint,@P18 bigint,@P19 decimal(38,10),@P20 decimal(38,10),@P21 decimal(38,10),@P22 bigint,@P23 bigint,@P24 decimal(38,10),@P25 decimal(38,10),@P26 bigint)UPDATE dbo.jiraissue SET pkey= @P0 , issuenum= @P1 , PROJECT= @P2 , REPORTER= @P3 , ASSIGNEE= @P4 , CREATOR= @P5 , issuetype= @P6 , SUMMARY= @P7 , DESCRIPTION= @P8 , ENVIRONMENT= @P9 , PRIORITY= @P10 , RESOLUTION= @P11 , issuestatus= @P12 , CREATED= @P13 , UPDATED= @P14 , DUEDATE= @P15 , RESOLUTIONDATE= @P16 , VOTES= @P17 , WATCHES= @P18 , TIMEORIGINALESTIMATE= @P19 , TIMEESTIMATE= @P20 , TIMESPENT= @P21 , WORKFLOW_ID= @P22 , SECURITY= @P23 , FIXFOR= @P24 , COMPONENT= @P25 WHERE ID= @P26
  22. </inputbuf>
  23. </process>
  24. </process-list>
  25. <resource-list>
  26. <ridlock fileid="1" pageid="30449" dbid="27" objectname="JIRA.dbo.jiraissue" id="lockb954c5980" mode="X" associatedObjectId="72057594054443008">
  27. <owner-list>
  28. <owner id="process1baf46d0c8" mode="X"></owner>
  29. </owner-list>
  30. <waiter-list>
  31. <waiter id="processb1f0c1498" mode="U" requestType="wait"></waiter>
  32. </waiter-list>
  33. </ridlock>
  34.  
  35. <ridlock fileid="1" pageid="6966" dbid="27" objectname="JIRA.dbo.jiraissue" id="lockc8b55ae00" mode="X" associatedObjectId="72057594054443008">
  36. <owner-list>
  37. <owner id="processb1f0c1498" mode="X"></owner>
  38. </owner-list>
  39. <waiter-list>
  40. <waiter id="process1baf46d0c8" mode="U" requestType="wait"></waiter>
  41. </waiter-list>
  42. </ridlock>
  43. </resource-list>
  44. </deadlock>
  45. </deadlock-list>
Add Comment
Please, Sign In to add comment