question

pradnyag41 avatar image
pradnyag41 asked

Reading deadlock logs

I need some help to read below deadlock logs ,Unknown,waiter id=processb97275c28 ,Unknown,waiter-list ,Unknown,owner id=process5948088c8 ,Unknown,owner id=process1b1b65c28 ,Unknown,owner id=process7f0a74108 ,Unknown,owner-list ,Unknown,exchangeEvent id=Pipe483afc480 WaitType=e_waitPipeGetRow nodeId=2 ,Unknown,waiter id=process965921468 mode=U requestType=wait ,Unknown,waiter-list ,Unknown,owner id=processb97275c28 mode=IU ,Unknown,owner-list ,Unknown,pagelock fileid=1 pageid=6672 dbid=25 subresource=FULL objectname=DBA.dbo.LC_EMS id=lock69f973d00 mode=IU associatedObjectId=72057594042580992 ,Unknown,waiter id=process30976a0ca8 mode=U requestType=wait ,Unknown,waiter-list ,Unknown,owner id=processb97275c28 mode=IU ,Unknown,owner-list ,Unknown,pagelock fileid=1 pageid=6544 dbid=25 subresource=FULL objectname=DBA.dbo.LC_EMS id=lock86fcfca80 mode=IU associatedObjectId=72057594042580992 ,Unknown,waiter id=process304d353468 mode=U requestType=wait ,Unknown,waiter-list ,Unknown,owner id=processb97275c28 mode=IU ,Unknown,owner-list ,Unknown,pagelock fileid=1 pageid=6608 dbid=25 subresource=FULL objectname=DBA.dbo.LC_EMS id=lock870fd0200 mode=IU associatedObjectId=72057594042580992 ,Unknown,waiter id=process5948088c8 mode=IU requestType=wait ,Unknown,waiter-list ,Unknown,owner id=process304d353468 mode=U ,Unknown,owner-list ,Unknown,pagelock fileid=1 pageid=5104 dbid=25 subresource=FULL objectname=DBA.dbo.LC_EMS id=lock87048e380 mode=U associatedObjectId=72057594042580992 ,Unknown,waiter id=process1b1b65c28 mode=IU requestType=wait ,Unknown,waiter-list ,Unknown,owner id=process965921468 mode=U ,Unknown,owner-list ,Unknown,pagelock fileid=1 pageid=5216 dbid=25 subresource=FULL objectname=DBA.dbo.LC_EMS id=lock639c93480 mode=U associatedObjectId=72057594042580992 ,Unknown,waiter id=process7f0a74108 mode=IU requestType=wait ,Unknown,waiter-list ,Unknown,owner id=process30976a0ca8 mode=U ,Unknown,owner-list ,Unknown,pagelock fileid=1 pageid=4944 dbid=25 subresource=FULL objectname=DBA.dbo.LC_EMS id=lock86988d180 mode=U associatedObjectId=72057594042580992 why U and IU is causing deadlock situation?
deadlock
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.