API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 19th, 2014
400
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.94 KB | None | 0 0
raw download clone embed print report
  1. spid22s,Unknown,waiter id=process8661658 mode=U requestType=wait
  2. spid22s,Unknown,waiter-list
  3. spid22s,Unknown,owner id=processfbcf468 mode=IX
  4. spid22s,Unknown,owner-list
  5. spid22s,Unknown,pagelock fileid=1 pageid=1966 dbid=7 subresource=FULL objectname=TRZIC.dbo.CODES id=lock3cbc200 mode=IX associatedObjectId=72057594039828480
  6. spid22s,Unknown,waiter id=processfbcf468 mode=S requestType=wait
  7. spid22s,Unknown,waiter-list
  8. spid22s,Unknown,owner id=process8661658 mode=UIX
  9. spid22s,Unknown,owner-list
  10. spid22s,Unknown,pagelock fileid=1 pageid=1957 dbid=7 subresource=FULL objectname=TRZIC.dbo.CODES id=lock3cb4700 mode=UIX associatedObjectId=72057594039828480
  11. spid22s,Unknown,resource-list
  12. spid22s,Unknown,Proc [Database Id = 7 Object Id = 277576027]
  13. spid22s,Unknown,inputbuf
  14. spid22s,Unknown,EXEC TRZIC.dbo.SendCommissioning
  15. spid22s,Unknown,frame procname=TRZIC.dbo.ReadCodeAuto line=48 stmtstart=2490 stmtend=2568 sqlhandle=0x030007005b798b10845dce0017a30000010000000000000000000000000000000000000000000000
  16. spid22s,Unknown,-- Clean up temporary table.
  17. spid22s,Unknown,WHERE ID_CODE IN (SELECT ID_CODE FROM TRZIC.dbo.CODES_TEMP)
  18. spid22s,Unknown,SET IS_TRANSMITTED = 1
  19. spid22s,Unknown,UPDATE TRZIC.dbo.CODES
  20. spid22s,Unknown,frame procname=TRZIC.dbo.SendCommissioning line=66 stmtstart=4134 stmtend=4440 sqlhandle=0x0300070024e1c120959909014ea30000010000000000000000000000000000000000000000000000
  21. spid22s,Unknown,executionStack
  22. spid22s,Unknown,process id=process8661658 taskpriority=0 logused=432 waitresource=PAGE: 7:1:1966 waittime=663 ownerId=1178366 transactionguid=0x5ba531963a2d1e40a7357071eae7e486 transactionname=user_transaction lasttranstarted=2014-06-19T10:37:21.940 XDES=0x3c84b78 lockMode=U schedulerid=1 kpid=3488 status=suspended spid=52 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2014-06-19T10:37:21.880 lastbatchcompleted=2014-06-19T10:37:21.877 lastattention=1900-01-01T00:00:00.877 clientapp=.Net SqlClient Data Provider hostname=CP-112990 hostpid=2728 loginname=CP-112990\Administrator isolationlevel=read committed (2) xactid=1178366 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
  23. spid22s,Unknown,Proc [Database Id = 7 Object Id = 261575970]
  24. spid22s,Unknown,inputbuf
  25. spid22s,Unknown,exec @ret= dbo.GetNumberOfCodes @aggregationLevel
  26. spid22s,Unknown,frame procname=TRZIC.dbo.GetCode line=29 stmtstart=1812 stmtend=1920 sqlhandle=0x030007002255970f615d09014ea30000010000000000000000000000000000000000000000000000
  27. spid22s,Unknown,RETURN (SELECT COUNT(CODE) FROM NO_IMPRESOS WHERE CODE_LEVEL= @codelevel)
  28. spid22s,Unknown,frame procname=TRZIC.dbo.GetNumberOfCodes line=11 stmtstart=690 stmtend=838 sqlhandle=0x03000700cdc17312bfe9b80015a30000000000000000000000000000000000000000000000000000
  29. spid22s,Unknown,executionStack
  30. spid22s,Unknown,process id=processfbcf468 taskpriority=0 logused=280 waitresource=PAGE: 7:1:1957 waittime=659 ownerId=1178391 transactionname=user_transaction lasttranstarted=2014-06-19T10:37:22.070 XDES=0x3c85598 lockMode=S schedulerid=1 kpid=1576 status=suspended spid=55 sbid=0 ecid=0 priority=0 trancount=1 lastbatchstarted=2014-06-19T10:37:22.070 lastbatchcompleted=2014-06-19T10:37:22.063 lastattention=1900-01-01T00:00:00.063 clientapp=.Net SqlClient Data Provider hostname=CP-112990 hostpid=2448 loginname=CP-112990\Administrator isolationlevel=read committed (2) xactid=1178391 currentdb=7 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
  31. spid22s,Unknown,process-list
  32. spid22s,Unknown,deadlock victim=processfbcf468
  33. spid22s,Unknown,deadlock-list
  34. spid3s,Unknown,ResType:LockOwner Stype:'OR'Xdes:0x03C85598 Mode: S SPID:55 BatchID:0 ECID:0 TaskProxy:(0x0843A430) Value:0x2d64680 Cost:(0/280)
  35. spid3s,Unknown,Victim Resource Owner:
  36. spid3s,Unknown,
  37. spid3s,Unknown,ResType:LockOwner Stype:'OR'Xdes:0x03C84B78 Mode: U SPID:52 BatchID:0 ECID:0 TaskProxy:(0x0F6AE430) Value:0x2d6dd20 Cost:(0/432)
  38. spid3s,Unknown,Requested by:
  39. spid3s,Unknown,Input Buf: RPC Event: Proc [Database Id = 7 Object Id = 261575970]
  40. spid3s,Unknown,SPID: 55 ECID: 0 Statement Type: SELECT Line #: 11
  41. spid3s,Unknown,Owner:0x02D64FC0 Mode: IX Flg:0x40 Ref:0 Life:02000000 SPID:55 ECID:0 XactLockInfo: 0x03C855C0
  42. spid3s,Unknown,Grant List 0:
  43. spid3s,Unknown,PAGE: 7:1:1966 CleanCnt:2 Mode:IX Flags: 0x3
  44. spid3s,Unknown,Node:2
  45. spid3s,Unknown,
  46. spid3s,Unknown,ResType:LockOwner Stype:'OR'Xdes:0x03C85598 Mode: S SPID:55 BatchID:0 ECID:0 TaskProxy:(0x0843A430) Value:0x2d64680 Cost:(0/280)
  47. spid3s,Unknown,Requested by:
  48. spid3s,Unknown,Input Buf: RPC Event: Proc [Database Id = 7 Object Id = 277576027]
  49. spid3s,Unknown,SPID: 52 ECID: 0 Statement Type: UPDATE Line #: 66
  50. spid3s,Unknown,Owner:0x02D6A220 Mode: UIX Flg:0x40 Ref:0 Life:02000001 SPID:52 ECID:0 XactLockInfo: 0x03C84BA0
  51. spid3s,Unknown,Grant List 0:
  52. spid3s,Unknown,PAGE: 7:1:1957 CleanCnt:2 Mode:UIX Flags: 0x3
  53. spid3s,Unknown,Node:1
  54. spid3s,Unknown,
  55. spid3s,Unknown,Wait-for graph
  56. spid3s,Unknown,Deadlock encountered .... Printing deadlock information
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!