help needed for the below error log information

Question

Post reply

help needed for the below error log information

ekknaveen

SSCrazy

Points: 2317
More actions
September 24, 2010 at 1:42 am

#142853

Hi,
I am not able to understand what is this, i got this informatin for sql server logs.
Please let me know what and why is it coming
09/24/2010 08:22:53,spid25s,Unknown,waiter id=process62c13a68 mode=U requestType=wait
09/24/2010 08:22:53,spid25s,Unknown,waiter-list
09/24/2010 08:22:53,spid25s,Unknown,owner id=process333b93d8 mode=X
09/24/2010 08:22:53,spid25s,Unknown,owner-list
09/24/2010 08:22:53,spid25s,Unknown,keylock hobtid=72057594065649664 dbid=9 objectname=KRM.dbo.ToolLock indexname=PK__ToolLock id=lock52f3cfc0 mode=X associatedObjectId=72057594065649664
09/24/2010 08:22:53,spid25s,Unknown,waiter id=process333b93d8 mode=U requestType=wait
09/24/2010 08:22:53,spid25s,Unknown,waiter-list
09/24/2010 08:22:53,spid25s,Unknown,owner id=process62c13a68 mode=X
09/24/2010 08:22:53,spid25s,Unknown,owner-list
09/24/2010 08:22:53,spid25s,Unknown,keylock hobtid=72057594065649664 dbid=9 objectname=KRM.dbo.ToolLock indexname=PK__ToolLock id=lock43f6f5c0 mode=X associatedObjectId=72057594065649664
09/24/2010 08:22:53,spid25s,Unknown,resource-list
09/24/2010 08:22:53,spid25s,Unknown,(@p1 int<c/>@p2 nvarchar(4000)<c/>@p3 int<c/>@p4 int<c/>@p5 datetime<c/>@p6 datetime)UPDATE ToolLock WITH(ROWLOCK) SET GeneratedKrmId = @p1 <c/> lastLockTime = GETUTCDATE() WHERE ToolLockId = @p2 and LockTool = @p3 AND ( GeneratedKrmId IN (NULL<c/> @p4 ) OR NOT ( ToolLock.lastLockTime > @p5 ) OR NOT exists (SELECT 1 from krmSERVER with(NOLOCK) where krmSERVER.generatedKrmId = ToolLock.GeneratedKrmId AND ( krmSERVER.lastActiveTime > @p6 AND krmSERVER.krmStatus = 1 ) ) )
09/24/2010 08:22:53,spid25s,Unknown,inputbuf
09/24/2010 08:22:53,spid25s,Unknown,unknown
09/24/2010 08:22:53,spid25s,Unknown,frame procname=unknown line=1 sqlhandle=0x000000000000000000000000000000000000000000000000
09/24/2010 08:22:53,spid25s,Unknown,UPDATE ToolLock WITH(ROWLOCK) SET GeneratedKrmId = @p1 <c/> lastLockTime = GETUTCDATE() WHERE ToolLockId = @p2 and LockTool = @p3 AND ( GeneratedKrmId IN (NULL<c/> @p4 ) OR NOT ( ToolLock.lastLockTime > @p5 ) OR NOT exists (SELECT 1 from krmSERVER with(NOLOCK) where krmSERVER.generatedKrmId = ToolLock.GeneratedKrmId AND ( krmSERVER.lastActiveTime > @p6 AND krmSERVER.krmStatus = 1 ) ) )
09/24/2010 08:22:53,spid25s,Unknown,frame procname=adhoc line=1 stmtstart=140 sqlhandle=0x02000000f78b2a3bb048b3ab6bf567be8512954033f47761
09/24/2010 08:22:53,spid25s,Unknown,executionStack
09/24/2010 08:22:53,spid25s,Unknown,process id=process62c13a68 taskpriority=0 logused=15672 waitresource=KEY: 9:72057594065649664 (97007e4639e5) waittime=3125 ownerId=1378349849 transactionname=T1 lasttranstarted=2010-09-24T08:12:34.243 XDES=0xdc2d2c8 lockMode=U schedulerid=8 kpid=9228 status=suspended spid=134 sbid=0 ecid=0 priority=0 transcount=9 lastbatchstarted=2010-09-24T08:22:50.253 lastbatchcompleted=2010-09-24T08:22:50.253 lastattention=2010-09-24T08:22:49.720 clientapp=i-net OPTA hostname=eudnt241 hostpid=2162 loginname=KNXMserver isolationlevel=read committed (2) xactid=1378349849 currentdb=9 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
09/24/2010 08:22:53,spid20s,Unknown,waiter id=process62c13a68 mode=U requestType=wait
09/24/2010 08:22:53,spid20s,Unknown,waiter-list
09/24/2010 08:22:53,spid20s,Unknown,owner id=process333b93d8 mode=X
09/24/2010 08:22:53,spid20s,Unknown,owner-list
09/24/2010 08:22:53,spid20s,Unknown,keylock hobtid=72057594065649664 dbid=9 objectname=KRM.dbo.ToolLock indexname=PK__ToolLock id=lock52f3cfc0 mode=X associatedObjectId=72057594065649664
09/24/2010 08:22:53,spid25s,Unknown,(@p1 int<c/>@p2 nvarchar(4000)<c/>@p3 int<c/>@p4 int<c/>@p5 datetime<c/>@p6 datetime)UPDATE ToolLock WITH(ROWLOCK) SET GeneratedKrmId = @p1 <c/> lastLockTime = GETUTCDATE() WHERE ToolLockId = @p2 and LockTool = @p3 AND ( GeneratedKrmId IN (NULL<c/> @p4 ) OR NOT ( ToolLock.lastLockTime > @p5 ) OR NOT exists (SELECT 1 from krmSERVER with(NOLOCK) where krmSERVER.generatedKrmId = ToolLock.GeneratedKrmId AND ( krmSERVER.lastActiveTime > @p6 AND krmSERVER.krmStatus = 1 ) ) )
09/24/2010 08:22:53,spid20s,Unknown,waiter id=process333b93d8 mode=U requestType=wait
09/24/2010 08:22:53,spid20s,Unknown,waiter id=process22afdf18 mode=U requestType=wait
09/24/2010 08:22:53,spid20s,Unknown,waiter-list
09/24/2010 08:22:53,spid20s,Unknown,owner id=process62c13a68 mode=X
09/24/2010 08:22:53,spid20s,Unknown,owner-list
09/24/2010 08:22:53,spid25s,Unknown,inputbuf
09/24/2010 08:22:53,spid20s,Unknown,keylock hobtid=72057594065649664 dbid=9 objectname=KRM.dbo.ToolLock indexname=PK__ToolLock id=lock43f6f5c0 mode=X associatedObjectId=72057594065649664
09/24/2010 08:22:53,spid25s,Unknown,unknown
09/24/2010 08:22:53,spid25s,Unknown,frame procname=unknown line=1 sqlhandle=0x000000000000000000000000000000000000000000000000
09/24/2010 08:22:53,spid20s,Unknown,resource-list
09/24/2010 08:22:53,spid20s,Unknown,(@p1 int<c/>@p2 nvarchar(4000)<c/>@p3 int<c/>@p4 int<c/>@p5 datetime<c/>@p6 datetime)UPDATE ToolLock WITH(ROWLOCK) SET GeneratedKrmId = @p1 <c/> lastLockTime = GETUTCDATE() WHERE ToolLockId = @p2 and LockTool = @p3 AND ( GeneratedKrmId IN (NULL<c/> @p4 ) OR NOT ( ToolLock.lastLockTime > @p5 ) OR NOT exists (SELECT 1 from krmSERVER with(NOLOCK) where krmSERVER.generatedKrmId = ToolLock.GeneratedKrmId AND ( krmSERVER.lastActiveTime > @p6 AND krmSERVER.krmStatus = 1 ) ) )
09/24/2010 08:22:53,spid25s,Unknown,UPDATE ToolLock WITH(ROWLOCK) SET GeneratedKrmId = @p1 <c/> lastLockTime = GETUTCDATE() WHERE ToolLockId = @p2 and LockTool = @p3 AND ( GeneratedKrmId IN (NULL<c/> @p4 ) OR NOT ( ToolLock.lastLockTime > @p5 ) OR NOT exists (SELECT 1 from krmSERVER with(NOLOCK) where krmSERVER.generatedKrmId = ToolLock.GeneratedKrmId AND ( krmSERVER.lastActiveTime > @p6 AND krmSERVER.krmStatus = 1 ) ) )
09/24/2010 08:22:53,spid20s,Unknown,inputbuf
09/24/2010 08:22:53,spid20s,Unknown,unknown
09/24/2010 08:22:53,spid20s,Unknown,frame procname=unknown line=1 sqlhandle=0x000000000000000000000000000000000000000000000000
09/24/2010 08:22:53,spid25s,Unknown,frame procname=adhoc line=1 stmtstart=140 sqlhandle=0x02000000f78b2a3bb048b3ab6bf567be8512954033f47761
09/24/2010 08:22:53,spid20s,Unknown,UPDATE ToolLock WITH(ROWLOCK) SET GeneratedKrmId = @p1 <c/> lastLockTime = GETUTCDATE() WHERE ToolLockId = @p2 and LockTool = @p3 AND ( GeneratedKrmId IN (NULL<c/> @p4 ) OR NOT ( ToolLock.lastLockTime > @p5 ) OR NOT exists (SELECT 1 from krmSERVER with(NOLOCK) where krmSERVER.generatedKrmId = ToolLock.GeneratedKrmId AND ( krmSERVER.lastActiveTime > @p6 AND krmSERVER.krmStatus = 1 ) ) )
09/24/2010 08:22:53,spid25s,Unknown,executionStack
09/24/2010 08:22:53,spid25s,Unknown,process id=process333b93d8 taskpriority=0 logused=260 waitresource=KEY: 9:72057594065649664 (d7004f6be3e9) waittime=60062 ownerId=1378432767 transactionname=UPDATE lasttranstarted=2010-09-24T08:21:53.337 XDES=0x752384e0 lockMode=U schedulerid=4 kpid=6580 status=suspended spid=168 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2010-09-24T08:21:53.337 lastbatchcompleted=2010-09-24T08:21:53.337 lastattention=2010-09-24T08:21:52.917 clientapp=i-net OPTA hostname=eudnt242 hostpid=2135 loginname=KNXMserver isolationlevel=read committed (2) xactid=1378432767 currentdb=9 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
09/24/2010 08:22:53,spid20s,Unknown,frame procname=adhoc line=1 stmtstart=140 sqlhandle=0x02000000f78b2a3bb048b3ab6bf567be8512954033f47761
09/24/2010 08:22:53,spid20s,Unknown,executionStack
09/24/2010 08:22:53,spid20s,Unknown,process id=process62c13a68 taskpriority=0 logused=15672 waitresource=KEY: 9:72057594065649664 (97007e4639e5) waittime=3125 ownerId=1378349849 transactionname=T1 lasttranstarted=2010-09-24T08:12:34.243 XDES=0xdc2d2c8 lockMode=U schedulerid=8 kpid=9228 status=suspended spid=134 sbid=0 ecid=0 priority=0 transcount=9 lastbatchstarted=2010-09-24T08:22:50.253 lastbatchcompleted=2010-09-24T08:22:50.253 lastattention=2010-09-24T08:22:49.720 clientapp=i-net OPTA hostname=eudnt241 hostpid=2162 loginname=KNXMserver isolationlevel=read committed (2) xactid=1378349849 currentdb=9 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
09/24/2010 08:22:53,spid25s,Unknown,process-list
09/24/2010 08:22:53,spid25s,Unknown,deadlock victim=process333b93d8
09/24/2010 08:22:53,spid25s,Unknown,deadlock-list
09/24/2010 08:22:53,spid20s,Unknown,(@p1 int<c/>@p2 nvarchar(4000)<c/>@p3 int<c/>@p4 int<c/>@p5 datetime<c/>@p6 datetime)UPDATE ToolLock WITH(ROWLOCK) SET GeneratedKrmId = @p1 <c/> lastLockTime = GETUTCDATE() WHERE ToolLockId = @p2 and LockTool = @p3 AND ( GeneratedKrmId IN (NULL<c/> @p4 ) OR NOT ( ToolLock.lastLockTime > @p5 ) OR NOT exists (SELECT 1 from krmSERVER with(NOLOCK) where krmSERVER.generatedKrmId = ToolLock.GeneratedKrmId AND ( krmSERVER.lastActiveTime > @p6 AND krmSERVER.krmStatus = 1 ) ) )
09/24/2010 08:22:53,spid20s,Unknown,inputbuf
09/24/2010 08:22:53,spid25s,Unknown,waiter id=process62c13a68 mode=U requestType=wait
09/24/2010 08:22:53,spid20s,Unknown,unknown
09/24/2010 08:22:53,spid20s,Unknown,frame procname=unknown line=1 sqlhandle=0x000000000000000000000000000000000000000000000000
09/24/2010 08:22:53,spid25s,Unknown,waiter-list
09/24/2010 08:22:53,spid25s,Unknown,owner id=process333b93d8 mode=X
09/24/2010 08:22:53,spid20s,Unknown,UPDATE ToolLock WITH(ROWLOCK) SET GeneratedKrmId = @p1 <c/> lastLockTime = GETUTCDATE() WHERE ToolLockId = @p2 and LockTool = @p3 AND ( GeneratedKrmId IN (NULL<c/> @p4 ) OR NOT ( ToolLock.lastLockTime > @p5 ) OR NOT exists (SELECT 1 from krmSERVER with(NOLOCK) where krmSERVER.generatedKrmId = ToolLock.GeneratedKrmId AND ( krmSERVER.lastActiveTime > @p6 AND krmSERVER.krmStatus = 1 ) ) )
09/24/2010 08:22:53,spid25s,Unknown,owner-list
09/24/2010 08:22:53,spid25s,Unknown,keylock hobtid=72057594065649664 dbid=9 objectname=KRM.dbo.ToolLock indexname=PK__ToolLock id=lock52f3cfc0 mode=X associatedObjectId=72057594065649664
09/24/2010 08:22:53,spid25s,Unknown,waiter id=process333b93d8 mode=U requestType=wait
09/24/2010 08:22:53,spid25s,Unknown,waiter id=process36194b68 mode=U requestType=wait
09/24/2010 08:22:53,spid20s,Unknown,frame procname=adhoc line=1 stmtstart=140 sqlhandle=0x02000000f78b2a3bb048b3ab6bf567be8512954033f47761
09/24/2010 08:22:53,spid25s,Unknown,waiter-list
09/24/2010 08:22:53,spid20s,Unknown,executionStack
09/24/2010 08:22:53,spid25s,Unknown,owner id=process62c13a68 mode=X
09/24/2010 08:22:53,spid20s,Unknown,process id=process333b93d8 taskpriority=0 logused=260 waitresource=KEY: 9:72057594065649664 (d7004f6be3e9) waittime=60062 ownerId=1378432767 transactionname=UPDATE lasttranstarted=2010-09-24T08:21:53.337 XDES=0x752384e0 lockMode=U schedulerid=4 kpid=6580 status=suspended spid=168 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2010-09-24T08:21:53.337 lastbatchcompleted=2010-09-24T08:21:53.337 lastattention=2010-09-24T08:21:52.917 clientapp=i-net OPTA hostname=eudnt242 hostpid=2135 loginname=KNXMserver isolationlevel=read committed (2) xactid=1378432767 currentdb=9 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
09/24/2010 08:22:53,spid25s,Unknown,owner-list
09/24/2010 08:22:53,spid25s,Unknown,keylock hobtid=72057594065649664 dbid=9 objectname=KRM.dbo.ToolLock indexname=PK__ToolLock id=lock43f6f5c0 mode=X associatedObjectId=72057594065649664
09/24/2010 08:22:53,spid25s,Unknown,resource-list
09/24/2010 08:22:53,spid25s,Unknown,(@p1 int<c/>@p2 nvarchar(4000)<c/>@p3 int<c/>@p4 int<c/>@p5 datetime<c/>@p6 datetime)UPDATE ToolLock WITH(ROWLOCK) SET GeneratedKrmId = @p1 <c/> lastLockTime = GETUTCDATE() WHERE ToolLockId = @p2 and LockTool = @p3 AND ( GeneratedKrmId IN (NULL<c/> @p4 ) OR NOT ( ToolLock.lastLockTime > @p5 ) OR NOT exists (SELECT 1 from krmSERVER with(NOLOCK) where krmSERVER.generatedKrmId = ToolLock.GeneratedKrmId AND ( krmSERVER.lastActiveTime > @p6 AND krmSERVER.krmStatus = 1 ) ) )
09/24/2010 08:22:53,spid20s,Unknown,(@p1 int<c/>@p2 nvarchar(4000)<c/>@p3 int<c/>@p4 int<c/>@p5 datetime<c/>@p6 datetime)UPDATE ToolLock WITH(ROWLOCK) SET GeneratedKrmId = @p1 <c/> lastLockTime = GETUTCDATE() WHERE ToolLockId = @p2 and LockTool = @p3 AND ( GeneratedKrmId IN (NULL<c/> @p4 ) OR NOT ( ToolLock.lastLockTime > @p5 ) OR NOT exists (SELECT 1 from krmSERVER with(NOLOCK) where krmSERVER.generatedKrmId = ToolLock.GeneratedKrmId AND ( krmSERVER.lastActiveTime > @p6 AND krmSERVER.krmStatus = 1 ) ) )
09/24/2010 08:22:53,spid25s,Unknown,inputbuf
09/24/2010 08:22:53,spid25s,Unknown,unknown
09/24/2010 08:22:53,spid25s,Unknown,frame procname=unknown line=1 sqlhandle=0x000000000000000000000000000000000000000000000000
09/24/2010 08:22:53,spid25s,Unknown,UPDATE ToolLock WITH(ROWLOCK) SET GeneratedKrmId = @p1 <c/> lastLockTime = GETUTCDATE() WHERE ToolLockId = @p2 and LockTool = @p3 AND ( GeneratedKrmId IN (NULL<c/> @p4 ) OR NOT ( ToolLock.lastLockTime > @p5 ) OR NOT exists (SELECT 1 from krmSERVER with(NOLOCK) where krmSERVER.generatedKrmId = ToolLock.GeneratedKrmId AND ( krmSERVER.lastActiveTime > @p6 AND krmSERVER.krmStatus = 1 ) ) )
09/24/2010 08:22:53,spid20s,Unknown,inputbuf
09/24/2010 08:22:53,spid20s,Unknown,unknown
09/24/2010 08:22:53,spid20s,Unknown,frame procname=unknown line=1 sqlhandle=0x000000000000000000000000000000000000000000000000
09/24/2010 08:22:53,spid20s,Unknown,UPDATE ToolLock WITH(ROWLOCK) SET GeneratedKrmId = @p1 <c/> lastLockTime = GETUTCDATE() WHERE ToolLockId = @p2 and LockTool = @p3 AND ( GeneratedKrmId IN (NULL<c/> @p4 ) OR NOT ( ToolLock.lastLockTime > @p5 ) OR NOT exists (SELECT 1 from krmSERVER with(NOLOCK) where krmSERVER.generatedKrmId = ToolLock.GeneratedKrmId AND ( krmSERVER.lastActiveTime > @p6 AND krmSERVER.krmStatus = 1 ) ) )
09/24/2010 08:22:53,spid25s,Unknown,frame procname=adhoc line=1 stmtstart=140 sqlhandle=0x02000000f78b2a3bb048b3ab6bf567be8512954033f47761
09/24/2010 08:22:53,spid25s,Unknown,executionStack
09/24/2010 08:22:53,spid25s,Unknown,process id=process62c13a68 taskpriority=0 logused=15672 waitresource=KEY: 9:72057594065649664 (97007e4639e5) waittime=3125 ownerId=1378349849 transactionname=T1 lasttranstarted=2010-09-24T08:12:34.243 XDES=0xdc2d2c8 lockMode=U schedulerid=8 kpid=9228 status=suspended spid=134 sbid=0 ecid=0 priority=0 transcount=9 lastbatchstarted=2010-09-24T08:22:50.253 lastbatchcompleted=2010-09-24T08:22:50.253 lastattention=2010-09-24T08:22:49.720 clientapp=i-net OPTA hostname=eudnt241 hostpid=2162 loginname=KNXMserver isolationlevel=read committed (2) xactid=1378349849 currentdb=9 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
09/24/2010 08:22:53,spid20s,Unknown,frame procname=adhoc line=1 stmtstart=140 sqlhandle=0x02000000f78b2a3bb048b3ab6bf567be8512954033f47761
09/24/2010 08:22:53,spid20s,Unknown,executionStack
09/24/2010 08:22:53,spid20s,Unknown,process id=process22afdf18 taskpriority=0 logused=0 waitresource=KEY: 9:72057594065649664 (d7004f6be3e9) waittime=60156 ownerId=1378432148 transactionname=UPDATE lasttranstarted=2010-09-24T08:21:53.240 XDES=0x25bf44e0 lockMode=U schedulerid=4 kpid=5872 status=suspended spid=89 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2010-09-24T08:21:53.240 lastbatchcompleted=2010-09-24T08:21:53.240 lastattention=2010-09-24T08:21:53.180 clientapp=i-net OPTA hostname=eudnt241 hostpid=2177 loginname=KNXMserver isolationlevel=read committed (2) xactid=1378432148 currentdb=9 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
09/24/2010 08:22:53,spid10s,Unknown,ResType:LockOwner Stype:'OR'Xdes:0x752384E0 Mode: U SPID:168 BatchID:0 ECID:0 TaskProxy:(0x51E2E378) Value:0x247aa900 Cost:(0/260)
09/24/2010 08:22:53,spid10s,Unknown,Victim Resource Owner:
09/24/2010 08:22:53,spid10s,Unknown,Log Viewer could not read information for this log entry. Cause: Data is Null. This method or property cannot be called on Null values.. Content:
09/24/2010 08:22:53,spid25s,Unknown,(@p1 int<c/>@p2 int)UPDATE ToolLock SET generatedKrmId = null WHERE LockTool = @p1 AND generatedKrmId = @p2
09/24/2010 08:22:53,spid25s,Unknown,inputbuf
09/24/2010 08:22:53,spid25s,Unknown,unknown
09/24/2010 08:22:53,spid25s,Unknown,frame procname=unknown line=1 sqlhandle=0x000000000000000000000000000000000000000000000000
09/24/2010 08:22:53,spid20s,Unknown,process-list
09/24/2010 08:22:53,spid20s,Unknown,deadlock victim=process22afdf18
09/24/2010 08:22:53,spid25s,Unknown,UPDATE ToolLock SET generatedKrmId = null WHERE LockTool = @p1 AND generatedKrmId = @p2
09/24/2010 08:22:53,spid20s,Unknown,deadlock-list
09/24/2010 08:22:53,spid25s,Unknown,frame procname=adhoc line=1 stmtstart=34 sqlhandle=0x020000009f804b01fa89e90400892af6cc68126652b3eb56
09/24/2010 08:22:53,spid10s,Unknown,ResType:LockOwner Stype:'OR'Xdes:0x752384E0 Mode: U SPID:168 BatchID:0 ECID:0 TaskProxy:(0x51E2E378) Value:0x247aa900 Cost:(0/260)
09/24/2010 08:22:53,spid10s,Unknown,Requested By:
09/24/2010 08:22:53,spid10s,Unknown,Input Buf: Language Event: (@p1 int<c/>@p2 nvarchar(4000)<c/>@p3 int<c/>@p4 int<c/>@p5 datetime<c/>@p6 datetime)UPDATE ToolLock WITH(ROWLOCK) SET GeneratedKrmId = @p1 <c/> lastLockTime = GETUTCDATE() WHERE ToolLockId = @p2 and LockTool = @p3 AND ( GeneratedKrmId IN (NULL<c/> @p4 ) OR NOT ( T
09/24/2010 08:22:53,spid25s,Unknown,executionStack
09/24/2010 08:22:53,spid10s,Unknown,SPID: 134 ECID: 0 Statement Type: UPDATE Line #: 1
09/24/2010 08:22:53,spid25s,Unknown,process id=process36194b68 taskpriority=0 logused=0 waitresource=KEY: 9:72057594065649664 (d7004f6be3e9) waittime=60218 ownerId=1378431472 transactionname=UPDATE lasttranstarted=2010-09-24T08:21:53.177 XDES=0x40486250 lockMode=U schedulerid=3 kpid=28380 status=suspended spid=103 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2010-09-24T08:21:53.177 lastbatchcompleted=2010-09-24T08:21:53.177 lastattention=2010-09-24T08:21:53.177 clientapp=i-net OPTA hostname=eudnt241 hostpid=2181 loginname=KNXMserver isolationlevel=read committed (2) xactid=1378431472 currentdb=9 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
09/24/2010 08:22:53,spid10s,Unknown,Owner:0x1AA9BBA0 Mode: X Flg:0x0 Ref:0 Life:02000000 SPID:134 ECID:0 XactLockInfo: 0x0DC2D2EC
09/24/2010 08:22:53,spid10s,Unknown,Grant List 3:
09/24/2010 08:22:53,spid10s,Unknown,KEY: 9:72057594065649664 (d7004f6be3e9) CleanCnt:2 Mode:X Flags: 0x0
09/24/2010 08:22:53,spid10s,Unknown,Node:2
09/24/2010 08:22:53,spid10s,Unknown,Log Viewer could not read information for this log entry. Cause: Data is Null. This method or property cannot be called on Null values.. Content:
09/24/2010 08:22:53,spid10s,Unknown,ResType:LockOwner Stype:'OR'Xdes:0x0DC2D2C8 Mode: U SPID:134 BatchID:0 ECID:0 TaskProxy:(0x612EC378) Value:0x5a1d7dc0 Cost:(0/15672)
09/24/2010 08:22:53,spid10s,Unknown,Requested By:
09/24/2010 08:22:53,spid10s,Unknown,Input Buf: Language Event: (@p1 int<c/>@p2 nvarchar(4000)<c/>@p3 int<c/>@p4 int<c/>@p5 datetime<c/>@p6 datetime)UPDATE ToolLock WITH(ROWLOCK) SET GeneratedKrmId = @p1 <c/> lastLockTime = GETUTCDATE() WHERE ToolLockId = @p2 and LockTool = @p3 AND ( GeneratedKrmId IN (NULL<c/> @p4 ) OR NOT ( T
09/24/2010 08:22:53,spid10s,Unknown,SPID: 168 ECID: 0 Statement Type: UPDATE Line #: 1
09/24/2010 08:22:53,spid10s,Unknown,Owner:0x51DA8760 Mode: X Flg:0x0 Ref:0 Life:02000000 SPID:168 ECID:0 XactLockInfo: 0x75238504
09/24/2010 08:22:53,spid10s,Unknown,Grant List 1:
09/24/2010 08:22:53,spid25s,Unknown,(@p1 int<c/>@p2 nvarchar(4000)<c/>@p3 int<c/>@p4 int<c/>@p5 datetime<c/>@p6 datetime)UPDATE ToolLock WITH(ROWLOCK) SET GeneratedKrmId = @p1 <c/> lastLockTime = GETUTCDATE() WHERE ToolLockId = @p2 and LockTool = @p3 AND ( GeneratedKrmId IN (NULL<c/> @p4 ) OR NOT ( ToolLock.lastLockTime > @p5 ) OR NOT exists (SELECT 1 from krmSERVER with(NOLOCK) where krmSERVER.generatedKrmId = ToolLock.GeneratedKrmId AND ( krmSERVER.lastActiveTime > @p6 AND krmSERVER.krmStatus = 1 ) ) )
09/24/2010 08:22:53,spid10s,Unknown,KEY: 9:72057594065649664 (97007e4639e5) CleanCnt:3 Mode:X Flags: 0x0
09/24/2010 08:22:53,spid10s,Unknown,Node:1
09/24/2010 08:22:53,spid10s,Unknown,Log Viewer could not read information for this log entry. Cause: Data is Null. This method or property cannot be called on Null values.. Content:
09/24/2010 08:22:53,spid10s,Unknown,Wait-for graph
09/24/2010 08:22:53,spid10s,Unknown,Deadlock encountered .... Printing deadlock information
09/24/2010 08:22:53,spid10s,Unknown,ResType:LockOwner Stype:'OR'Xdes:0x25BF44E0 Mode: U SPID:89 BatchID:0 ECID:0 TaskProxy:(0x6185E378) Value:0x2d037aa0 Cost:(0/0)
09/24/2010 08:22:53,spid25s,Unknown,inputbuf
09/24/2010 08:22:53,spid10s,Unknown,Victim Resource Owner:
09/24/2010 08:22:53,spid25s,Unknown,unknown
09/24/2010 08:22:53,spid10s,Unknown,Log Viewer could not read information for this log entry. Cause: Data is Null. This method or property cannot be called on Null values.. Content:
09/24/2010 08:22:53,spid25s,Unknown,frame procname=unknown line=1 sqlhandle=0x000000000000000000000000000000000000000000000000
09/24/2010 08:22:53,spid25s,Unknown,UPDATE ToolLock WITH(ROWLOCK) SET GeneratedKrmId = @p1 <c/> lastLockTime = GETUTCDATE() WHERE ToolLockId = @p2 and LockTool = @p3 AND ( GeneratedKrmId IN (NULL<c/> @p4 ) OR NOT ( ToolLock.lastLockTime > @p5 ) OR NOT exists (SELECT 1 from krmSERVER with(NOLOCK) where krmSERVER.generatedKrmId = ToolLock.GeneratedKrmId AND ( krmSERVER.lastActiveTime > @p6 AND krmSERVER.krmStatus = 1 ) ) )
09/24/2010 08:22:53,spid25s,Unknown,frame procname=adhoc line=1 stmtstart=140 sqlhandle=0x02000000f78b2a3bb048b3ab6bf567be8512954033f47761
09/24/2010 08:22:53,spid25s,Unknown,executionStack
09/24/2010 08:22:53,spid25s,Unknown,process id=process333b93d8 taskpriority=0 logused=260 waitresource=KEY: 9:72057594065649664 (d7004f6be3e9) waittime=60062 ownerId=1378432767 transactionname=UPDATE lasttranstarted=2010-09-24T08:21:53.337 XDES=0x752384e0 lockMode=U schedulerid=4 kpid=6580 status=suspended spid=168 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2010-09-24T08:21:53.337 lastbatchcompleted=2010-09-24T08:21:53.337 lastattention=2010-09-24T08:21:52.917 clientapp=i-net OPTA hostname=eudnt242 hostpid=2135 loginname=KNXMserver isolationlevel=read committed (2) xactid=1378432767 currentdb=9 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
09/24/2010 08:22:53,spid10s,Unknown,ResType:LockOwner Stype:'OR'Xdes:0x752384E0 Mode: U SPID:168 BatchID:0 ECID:0 TaskProxy:(0x51E2E378) Value:0x247aa900 Cost:(0/260)
09/24/2010 08:22:53,spid10s,Unknown,Requested By:
09/24/2010 08:22:53,spid10s,Unknown,Input Buf: Language Event: (@p1 int<c/>@p2 nvarchar(4000)<c/>@p3 int<c/>@p4 int<c/>@p5 datetime<c/>@p6 datetime)UPDATE ToolLock WITH(ROWLOCK) SET GeneratedKrmId = @p1 <c/> lastLockTime = GETUTCDATE() WHERE ToolLockId = @p2 and LockTool = @p3 AND ( GeneratedKrmId IN (NULL<c/> @p4 ) OR NOT ( T
09/24/2010 08:22:53,spid10s,Unknown,SPID: 89 ECID: 0 Statement Type: UPDATE Line #: 1
09/24/2010 08:22:53,spid10s,Unknown,Owner:0x2D037AA0 Mode: U Flg:0x2 Ref:1 Life:00000000 SPID:89 ECID:0 XactLockInfo: 0x25BF4504
09/24/2010 08:22:53,spid10s,Unknown,Wait List:
09/24/2010 08:22:53,spid10s,Unknown,KEY: 9:72057594065649664 (d7004f6be3e9) CleanCnt:4 Mode:X Flags: 0x0
09/24/2010 08:22:53,spid10s,Unknown,Node:3
09/24/2010 08:22:53,spid10s,Unknown,Log Viewer could not read information for this log entry. Cause: Data is Null. This method or property cannot be called on Null values.. Content:
09/24/2010 08:22:53,spid25s,Unknown,process-list
09/24/2010 08:22:53,spid10s,Unknown,ResType:LockOwner Stype:'OR'Xdes:0x0DC2D2C8 Mode: U SPID:134 BatchID:0 ECID:0 TaskProxy:(0x612EC378) Value:0x5a1d7dc0 Cost:(0/15672)
09/24/2010 08:22:53,spid25s,Unknown,deadlock victim=process36194b68
09/24/2010 08:22:53,spid10s,Unknown,Requested By:
09/24/2010 08:22:53,spid10s,Unknown,Input Buf: Language Event: (@p1 int<c/>@p2 nvarchar(4000)<c/>@p3 int<c/>@p4 int<c/>@p5 datetime<c/>@p6 datetime)UPDATE ToolLock WITH(ROWLOCK) SET GeneratedKrmId = @p1 <c/> lastLockTime = GETUTCDATE() WHERE ToolLockId = @p2 and LockTool = @p3 AND ( GeneratedKrmId IN (NULL<c/> @p4 ) OR NOT ( T
09/24/2010 08:22:53,spid25s,Unknown,deadlock-list
09/24/2010 08:22:53,spid10s,Unknown,SPID: 168 ECID: 0 Statement Type: UPDATE Line #: 1
09/24/2010 08:22:53,spid10s,Unknown,Owner:0x51DA8760 Mode: X Flg:0x0 Ref:0 Life:02000000 SPID:168 ECID:0 XactLockInfo: 0x75238504
09/24/2010 08:22:53,spid10s,Unknown,Grant List 1:
09/24/2010 08:22:53,spid10s,Unknown,KEY: 9:72057594065649664 (97007e4639e5) CleanCnt:2 Mode:X Flags: 0x0
09/24/2010 08:22:53,spid10s,Unknown,Node:2
09/24/2010 08:22:53,spid10s,Unknown,Log Viewer could not read information for this log entry. Cause: Data is Null. This method or property cannot be called on Null values.. Content:
09/24/2010 08:22:53,spid10s,Unknown,ResType:LockOwner Stype:'OR'Xdes:0x25BF44E0 Mode: U SPID:89 BatchID:0 ECID:0 TaskProxy:(0x6185E378) Value:0x2d037aa0 Cost:(0/0)
09/24/2010 08:22:53,spid10s,Unknown,Requested By:
09/24/2010 08:22:53,spid10s,Unknown,Input Buf: Language Event: (@p1 int<c/>@p2 nvarchar(4000)<c/>@p3 int<c/>@p4 int<c/>@p5 datetime<c/>@p6 datetime)UPDATE ToolLock WITH(ROWLOCK) SET GeneratedKrmId = @p1 <c/> lastLockTime = GETUTCDATE() WHERE ToolLockId = @p2 and LockTool = @p3 AND ( GeneratedKrmId IN (NULL<c/> @p4 ) OR NOT ( T
09/24/2010 08:22:53,spid10s,Unknown,SPID: 134 ECID: 0 Statement Type: UPDATE Line #: 1
09/24/2010 08:22:53,spid10s,Unknown,Owner:0x1AA9BBA0 Mode: X Flg:0x0 Ref:0 Life:02000000 SPID:134 ECID:0 XactLockInfo: 0x0DC2D2EC
09/24/2010 08:22:53,spid10s,Unknown,Grant List 3:
09/24/2010 08:22:53,spid10s,Unknown,KEY: 9:72057594065649664 (d7004f6be3e9) CleanCnt:4 Mode:X Flags: 0x0
09/24/2010 08:22:53,spid10s,Unknown,Node:1
09/24/2010 08:22:53,spid10s,Unknown,Log Viewer could not read information for this log entry. Cause: Data is Null. This method or property cannot be called on Null values.. Content:
09/24/2010 08:22:53,spid10s,Unknown,Wait-for graph
09/24/2010 08:22:53,spid10s,Unknown,Deadlock encountered .... Printing deadlock information
09/24/2010 08:22:53,spid10s,Unknown,ResType:LockOwner Stype:'OR'Xdes:0x40486250 Mode: U SPID:103 BatchID:0 ECID:0 TaskProxy:(0x34198378) Value:0x2a41c7a0 Cost:(0/0)
09/24/2010 08:22:53,spid10s,Unknown,Victim Resource Owner:
09/24/2010 08:22:53,spid10s,Unknown,Log Viewer could not read information for this log entry. Cause: Data is Null. This method or property cannot be called on Null values.. Content:
09/24/2010 08:22:53,spid10s,Unknown,ResType:LockOwner Stype:'OR'Xdes:0x40486250 Mode: U SPID:103 BatchID:0 ECID:0 TaskProxy:(0x34198378) Value:0x2a41c7a0 Cost:(0/0)
09/24/2010 08:22:53,spid10s,Unknown,Requested By:
09/24/2010 08:22:53,spid10s,Unknown,Owner:0x1AA9BBA0 Mode: X Flg:0x0 Ref:0 Life:02000000 SPID:134 ECID:0 XactLockInfo: 0x0DC2D2EC
09/24/2010 08:22:53,spid10s,Unknown,Grant List 3:
09/24/2010 08:22:53,spid10s,Unknown,KEY: 9:72057594065649664 (d7004f6be3e9) CleanCnt:3 Mode:X Flags: 0x0
09/24/2010 08:22:53,spid10s,Unknown,Node:4
09/24/2010 08:22:53,spid10s,Unknown,Log Viewer could not read information for this log entry. Cause: Data is Null. This method or property cannot be called on Null values.. Content:
09/24/2010 08:22:53,spid10s,Unknown,ResType:LockOwner Stype:'OR'Xdes:0x752384E0 Mode: U SPID:168 BatchID:0 ECID:0 TaskProxy:(0x51E2E378) Value:0x247aa900 Cost:(0/260)
09/24/2010 08:22:53,spid10s,Unknown,Requested By:
09/24/2010 08:22:53,spid10s,Unknown,Input Buf: Language Event: (@p1 int<c/>@p2 int)UPDATE ToolLock SET generatedKrmId = null WHERE LockTool = @p1 AND generatedKrmId = @p2
09/24/2010 08:22:53,spid10s,Unknown,SPID: 103 ECID: 0 Statement Type: UPDATE Line #: 1
09/24/2010 08:22:53,spid10s,Unknown,Owner:0x2A41C7A0 Mode: U Flg:0x2 Ref:1 Life:00000000 SPID:103 ECID:0 XactLockInfo: 0x40486274
09/24/2010 08:22:53,spid10s,Unknown,Wait List:
09/24/2010 08:22:53,spid10s,Unknown,KEY: 9:72057594065649664 (d7004f6be3e9) CleanCnt:3 Mode:X Flags: 0x0
09/24/2010 08:22:53,spid10s,Unknown,Node:3
09/24/2010 08:22:53,spid10s,Unknown,Log Viewer could not read information for this log entry. Cause: Data is Null. This method or property cannot be called on Null values.. Content:
09/24/2010 08:22:53,spid10s,Unknown,ResType:LockOwner Stype:'OR'Xdes:0x0DC2D2C8 Mode: U SPID:134 BatchID:0 ECID:0 TaskProxy:(0x612EC378) Value:0x5a1d7dc0 Cost:(0/15672)
09/24/2010 08:22:53,spid10s,Unknown,Requested By:
09/24/2010 08:22:53,spid10s,Unknown,Input Buf: Language Event: (@p1 int<c/>@p2 nvarchar(4000)<c/>@p3 int<c/>@p4 int<c/>@p5 datetime<c/>@p6 datetime)UPDATE ToolLock WITH(ROWLOCK) SET GeneratedKrmId = @p1 <c/> lastLockTime = GETUTCDATE() WHERE ToolLockId = @p2 and LockTool = @p3 AND ( GeneratedKrmId IN (NULL<c/> @p4 ) OR NOT ( T
09/24/2010 08:22:53,spid10s,Unknown,SPID: 168 ECID: 0 Statement Type: UPDATE Line #: 1
09/24/2010 08:22:53,spid10s,Unknown,Owner:0x51DA8760 Mode: X Flg:0x0 Ref:0 Life:02000000 SPID:168 ECID:0 XactLockInfo: 0x75238504
09/24/2010 08:22:53,spid10s,Unknown,Grant List 1:
09/24/2010 08:22:53,spid10s,Unknown,KEY: 9:72057594065649664 (97007e4639e5) CleanCnt:3 Mode:X Flags: 0x0
09/24/2010 08:22:53,spid10s,Unknown,Node:2
09/24/2010 08:22:53,spid10s,Unknown,Log Viewer could not read information for this log entry. Cause: Data is Null. This method or property cannot be called on Null values.. Content:
09/24/2010 08:22:53,spid10s,Unknown,ResType:LockOwner Stype:'OR'Xdes:0x529484E0 Mode: X SPID:98 BatchID:0 ECID:0 TaskProxy:(0x13530378) Value:0x3af87d20 Cost:(0/0)
09/24/2010 08:22:53,spid10s,Unknown,Requested By:
09/24/2010 08:22:53,spid10s,Unknown,Input Buf: Language Event: (@p1 int<c/>@p2 nvarchar(4000)<c/>@p3 int<c/>@p4 int<c/>@p5 datetime<c/>@p6 datetime)UPDATE ToolLock WITH(ROWLOCK) SET GeneratedKrmId = @p1 <c/> lastLockTime = GETUTCDATE() WHERE ToolLockId = @p2 and LockTool = @p3 AND ( GeneratedKrmId IN (NULL<c/> @p4 ) OR NOT ( T
09/24/2010 08:22:53,spid10s,Unknown,SPID: 134 ECID: 0 Statement Type: UPDATE Line #: 1
09/24/2010 08:22:53,spid10s,Unknown,Owner:0x72E403C0 Mode: X Flg:0x0 Ref:0 Life:02000000 SPID:134 ECID:0 XactLockInfo: 0x0DC2D2EC
09/24/2010 08:22:53,spid10s,Unknown,Grant List 3:
09/24/2010 08:22:53,spid10s,Unknown,KEY: 9:394038375415808 (ea01dfd99e50) CleanCnt:2 Mode:X Flags: 0x0
09/24/2010 08:22:53,spid10s,Unknown,Node:1
09/24/2010 08:22:53,spid10s,Unknown,Log Viewer could not read information for this log entry. Cause: Data is Null. This method or property cannot be called on Null values.. Content:
09/24/2010 08:22:53,spid10s,Unknown,Wait-for graph
09/24/2010 08:22:53,spid10s,Unknown,Deadlock encountered .... Printing deadlock information
09/24/2010 08:19:30,spid23s,Unknown,waiter id=process761445c8 mode=U requestType=wait
09/24/2010 08:19:30,spid23s,Unknown,waiter-list
09/24/2010 08:19:30,spid23s,Unknown,owner id=process333b93d8 mode=X
09/24/2010 08:19:30,spid23s,Unknown,owner-list
09/24/2010 08:19:30,spid23s,Unknown,keylock hobtid=72057594065649664 dbid=9 objectname=KRM.dbo.ToolLock indexname=PK__ToolLock id=lock4982d240 mode=X associatedObjectId=72057594065649664
09/24/2010 08:19:30,spid23s,Unknown,waiter id=process333b93d8 mode=U requestType=wait
09/24/2010 08:19:30,spid23s,Unknown,waiter-list
09/24/2010 08:19:30,spid23s,Unknown,owner id=process761445c8 mode=X
09/24/2010 08:19:30,spid23s,Unknown,owner-list
09/24/2010 08:19:30,spid23s,Unknown,keylock hobtid=72057594065649664 dbid=9 objectname=KRM.dbo.ToolLock indexname=PK__ToolLock id=lock1bce2400 mode=X associatedObjectId=72057594065649664
09/24/2010 08:19:30,spid23s,Unknown,resource-list
09/24/2010 08:19:30,spid23s,Unknown,(@p1 int<c/>@p2 nvarchar(4000)<c/>@p3 int<c/>@p4 int<c/>@p5 datetime<c/>@p6 datetime)UPDATE ToolLock WITH(ROWLOCK) SET GeneratedKrmId = @p1 <c/> lastLockTime = GETUTCDATE() WHERE ToolLockId = @p2 and LockTool = @p3 AND ( GeneratedKrmId IN (NULL<c/> @p4 ) OR NOT ( ToolLock.lastLockTime > @p5 ) OR NOT exists (SELECT 1 from krmSERVER with(NOLOCK) where krmSERVER.generatedKrmId = ToolLock.GeneratedKrmId AND ( krmSERVER.lastActiveTime > @p6 AND krmSERVER.krmStatus = 1 ) ) )
09/24/2010 08:19:30,spid23s,Unknown,inputbuf
09/24/2010 08:19:30,spid23s,Unknown,unknown
09/24/2010 08:19:30,spid23s,Unknown,frame procname=unknown line=1 sqlhandle=0x000000000000000000000000000000000000000000000000
09/24/2010 08:19:30,spid23s,Unknown,UPDATE ToolLock WITH(ROWLOCK) SET GeneratedKrmId = @p1 <c/> lastLockTime = GETUTCDATE() WHERE ToolLockId = @p2 and LockTool = @p3 AND ( GeneratedKrmId IN (NULL<c/> @p4 ) OR NOT ( ToolLock.lastLockTime > @p5 ) OR NOT exists (SELECT 1 from krmSERVER with(NOLOCK) where krmSERVER.generatedKrmId = ToolLock.GeneratedKrmId AND ( krmSERVER.lastActiveTime > @p6 AND krmSERVER.krmStatus = 1 ) ) )
09/24/2010 08:19:30,spid23s,Unknown,frame procname=adhoc line=1 stmtstart=140 sqlhandle=0x02000000f78b2a3bb048b3ab6bf567be8512954033f47761
09/24/2010 08:19:30,spid23s,Unknown,executionStack
09/24/2010 08:19:30,spid23s,Unknown,process id=process761445c8 taskpriority=0 logused=260 waitresource=KEY: 9:72057594065649664 (2f01c572c437) waittime=31937 ownerId=1378403438 transactionname=UPDATE lasttranstarted=2010-09-24T08:18:58.947 XDES=0x203a9ae0 lockMode=U schedulerid=6 kpid=26360 status=suspended spid=105 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2010-09-24T08:18:58.947 lastbatchcompleted=2010-09-24T08:18:58.947 lastattention=2010-09-24T08:18:58.370 clientapp=i-net OPTA hostname=eudnt241 hostpid=2124 loginname=KNXMserver isolationlevel=read committed (2) xactid=1378403438 currentdb=9 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
09/24/2010 08:19:30,spid23s,Unknown,(@p1 int<c/>@p2 nvarchar(4000)<c/>@p3 int<c/>@p4 int<c/>@p5 datetime<c/>@p6 datetime)UPDATE ToolLock WITH(ROWLOCK) SET GeneratedKrmId = @p1 <c/> lastLockTime = GETUTCDATE() WHERE ToolLockId = @p2 and LockTool = @p3 AND ( GeneratedKrmId IN (NULL<c/> @p4 ) OR NOT ( ToolLock.lastLockTime > @p5 ) OR NOT exists (SELECT 1 from krmSERVER with(NOLOCK) where krmSERVER.generatedKrmId = ToolLock.GeneratedKrmId AND ( krmSERVER.lastActiveTime > @p6 AND krmSERVER.krmStatus = 1 ) ) )
09/24/2010 08:19:30,spid23s,Unknown,inputbuf
09/24/2010 08:19:30,spid23s,Unknown,unknown
09/24/2010 08:19:30,spid23s,Unknown,frame procname=unknown line=1 sqlhandle=0x000000000000000000000000000000000000000000000000
09/24/2010 08:19:30,spid23s,Unknown,UPDATE ToolLock WITH(ROWLOCK) SET GeneratedKrmId = @p1 <c/> lastLockTime = GETUTCDATE() WHERE ToolLockId = @p2 and LockTool = @p3 AND ( GeneratedKrmId IN (NULL<c/> @p4 ) OR NOT ( ToolLock.lastLockTime > @p5 ) OR NOT exists (SELECT 1 from krmSERVER with(NOLOCK) where krmSERVER.generatedKrmId = ToolLock.GeneratedKrmId AND ( krmSERVER.lastActiveTime > @p6 AND krmSERVER.krmStatus = 1 ) ) )
09/24/2010 08:19:30,spid23s,Unknown,frame procname=adhoc line=1 stmtstart=140 sqlhandle=0x02000000f78b2a3bb048b3ab6bf567be8512954033f47761
09/24/2010 08:19:30,spid23s,Unknown,executionStack
09/24/2010 08:19:30,spid23s,Unknown,process id=process333b93d8 taskpriority=0 logused=50512 waitresource=KEY: 9:72057594065649664 (97007e4639e5) waittime=1703 ownerId=1378178870 transactionname=user_transaction lasttranstarted=2010-09-24T08:03:48.437 XDES=0x55e7c250 lockMode=U schedulerid=4 kpid=6580 status=suspended spid=168 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2010-09-24T08:19:29.183 lastbatchcompleted=2010-09-24T08:19:29.183 lastattention=2010-09-24T08:19:29.127 clientapp=i-net OPTA hostname=eudnt242 hostpid=2135 loginname=KNXMserver isolationlevel=read committed (2) xactid=1378178870 currentdb=9 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
09/24/2010 08:19:30,spid23s,Unknown,process-list
09/24/2010 08:19:30,spid23s,Unknown,deadlock victim=process761445c8
09/24/2010 08:19:30,spid23s,Unknown,deadlock-list
09/24/2010 08:19:30,spid10s,Unknown,ResType:LockOwner Stype:'OR'Xdes:0x203A9AE0 Mode: U SPID:105 BatchID:0 ECID:0 TaskProxy:(0x1B7DC378) Value:0x5f110420 Cost:(0/260)
09/24/2010 08:19:30,spid10s,Unknown,Victim Resource Owner:
09/24/2010 08:19:30,spid10s,Unknown,Log Viewer could not read information for this log entry. Cause: Data is Null. This method or property cannot be called on Null values.. Content:
09/24/2010 08:19:30,spid10s,Unknown,ResType:LockOwner Stype:'OR'Xdes:0x203A9AE0 Mode: U SPID:105 BatchID:0 ECID:0 TaskProxy:(0x1B7DC378) Value:0x5f110420 Cost:(0/260)
09/24/2010 08:19:30,spid10s,Unknown,Requested By:
09/24/2010 08:19:30,spid10s,Unknown,Owner:0x52F8D620 Mode: X Flg:0x0 Ref:0 Life:02000000 SPID:168 ECID:0 XactLockInfo: 0x55E7C274
09/24/2010 08:19:30,spid10s,Unknown,Grant List 1:
09/24/2010 08:19:30,spid10s,Unknown,KEY: 9:72057594065649664 (2f01c572c437) CleanCnt:2 Mode:X Flags: 0x0
09/24/2010 08:19:30,spid10s,Unknown,Node:3
09/24/2010 08:19:30,spid10s,Unknown,Log Viewer could not read information for this log entry. Cause: Data is Null. This method or property cannot be called on Null values.. Content:
09/24/2010 08:19:30,spid10s,Unknown,ResType:LockOwner Stype:'OR'Xdes:0x55E7C250 Mode: U SPID:168 BatchID:0 ECID:0 TaskProxy:(0x51E2E378) Value:0x352115e0 Cost:(0/50512)
09/24/2010 08:19:30,spid10s,Unknown,Requested By:
09/24/2010 08:19:30,spid10s,Unknown,Input Buf: Language Event: (@p1 int<c/>@p2 nvarchar(4000)<c/>@p3 int<c/>@p4 int<c/>@p5 datetime<c/>@p6 datetime)UPDATE ToolLock WITH(ROWLOCK) SET GeneratedKrmId = @p1 <c/> lastLockTime = GETUTCDATE() WHERE ToolLockId = @p2 and LockTool = @p3 AND ( GeneratedKrmId IN (NULL<c/> @p4 ) OR NOT ( T
09/24/2010 08:19:30,spid10s,Unknown,SPID: 105 ECID: 0 Statement Type: UPDATE Line #: 1
09/24/2010 08:19:30,spid10s,Unknown,Owner:0x37DD1FE0 Mode: X Flg:0x0 Ref:0 Life:02000000 SPID:105 ECID:0 XactLockInfo: 0x203A9B04
09/24/2010 08:19:30,spid10s,Unknown,Grant List 2:
09/24/2010 08:19:30,spid10s,Unknown,KEY: 9:72057594065649664 (97007e4639e5) CleanCnt:3 Mode:X Flags: 0x0
09/24/2010 08:19:30,spid10s,Unknown,Node:2
09/24/2010 08:19:30,spid10s,Unknown,Log Viewer could not read information for this log entry. Cause: Data is Null. This method or property cannot be called on Null values.. Content:
09/24/2010 08:19:30,spid10s,Unknown,ResType:LockOwner Stype:'OR'Xdes:0x529486E0 Mode: X SPID:119 BatchID:0 ECID:0 TaskProxy:(0x2D378378) Value:0x3af86560 Cost:(0/84)
09/24/2010 08:19:30,spid10s,Unknown,Requested By:
09/24/2010 08:19:30,spid10s,Unknown,Input Buf: Language Event: (@p1 int<c/>@p2 nvarchar(4000)<c/>@p3 int<c/>@p4 int<c/>@p5 datetime<c/>@p6 datetime)UPDATE ToolLock WITH(ROWLOCK) SET GeneratedKrmId = @p1 <c/> lastLockTime = GETUTCDATE() WHERE ToolLockId = @p2 and LockTool = @p3 AND ( GeneratedKrmId IN (NULL<c/> @p4 ) OR NOT ( T
09/24/2010 08:19:30,spid10s,Unknown,SPID: 168 ECID: 0 Statement Type: UPDATE Line #: 1
09/24/2010 08:19:30,spid10s,Unknown,Owner:0x52F8C9C0 Mode: X Flg:0x0 Ref:0 Life:02000000 SPID:168 ECID:0 XactLockInfo: 0x55E7C274
09/24/2010 08:19:30,spid10s,Unknown,Grant List 1:
09/24/2010 08:19:30,spid10s,Unknown,KEY: 9:72057594061586432 (1e02216f0984) CleanCnt:2 Mode:X Flags: 0x0
09/24/2010 08:19:30,spid10s,Unknown,Node:1
09/24/2010 08:19:30,spid10s,Unknown,Log Viewer could not read information for this log entry. Cause: Data is Null. This method or property cannot be called on Null values.. Content:
09/24/2010 08:19:30,spid10s,Unknown,Wait-for graph
09/24/2010 08:19:30,spid10s,Unknown,Deadlock encountered .... Printing deadlock information
Regards,
NAveen

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

Adiga One Orange Chip Points: 27284 More actions · Answer 1

These messages are part of the Dead Lock graph. Read more about Dead Lock here.

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga