thanks
tim
2004-05-21 16:07:58.18 spid4
Deadlock encountered ... Printing deadlock information
2004-05-21 16:07:58.18 spid4
2004-05-21 16:07:58.18 spid4 Wait-for graph
2004-05-21 16:07:58.18 spid4
2004-05-21 16:07:58.18 spid4 Node:1
2004-05-21 16:07:58.18 spid4 RID: 5:1:536178:4 CleanCnt:1 Mode: X Flags: 0x2
2004-05-21 16:07:58.18 spid4 Grant List 3::
2004-05-21 16:07:58.18 spid4 Owner:0x68e15860 Mode: X Flg:0x0 Ref:0 Life:02000000 SPID:54 ECID:0
2004-05-21 16:07:58.18 spid4 SPID: 54 ECID: 0 Statement Type: UPDATE Line #: 2
2004-05-21 16:07:58.18 spid4 Input Buf: RPC Event: dbo.NEXTKEYZZZbIGIp$7;1
2004-05-21 16:07:58.18 spid4 Requested By:
2004-05-21 16:07:58.18 spid4 ResType:LockOwner Stype:'OR' Mode: U SPID:51 ECID:0 Ec


2004-05-21 16:07:58.18 spid4
2004-05-21 16:07:58.18 spid4 Node:2
2004-05-21 16:07:58.18 spid4 KEY: 5:1685581043:2 (6401bf0349e3) CleanCnt:1 Mode: U Flags: 0x0
2004-05-21 16:07:58.18 spid4 Grant List 2::
2004-05-21 16:07:58.18 spid4 Owner:0x70573a40 Mode: U Flg:0x0 Ref:1 Life:00000000 SPID:51 ECID:0
2004-05-21 16:07:58.18 spid4 SPID: 51 ECID: 0 Statement Type: UPDATE Line #: 2
2004-05-21 16:07:58.18 spid4 Input Buf: RPC Event: dbo.NEXTKEYZZZbIGIp$7;1
2004-05-21 16:07:58.18 spid4 Requested By:
2004-05-21 16:07:58.18 spid4 ResType:LockOwner Stype:'OR' Mode: U SPID:54 ECID:0 Ec


2004-05-21 16:07:58.18 spid4 Victim Resource Owner:
2004-05-21 16:07:58.18 spid4 ResType:LockOwner Stype:'OR' Mode: U SPID:51 ECID:0 Ec


2004-05-21 16:11:50.78 spid4 Victim Resource Owner:
2004-05-21 16:11:50.78 spid4 ResType:ExchangeId Stype:'AND' SPID:69 ECID:22 Ec


2004-05-21 16:11:55.78 spid4 Victim Resource Owner:
2004-05-21 16:11:55.78 spid4 ResType:ExchangeId Stype:'AND' SPID:69 ECID:22 Ec


Hi
Looks like you may have trace flag 1204 set?
http://msdn.microsoft.com/library/de...tabse_5xrn.asp
http://msdn.microsoft.com/library/de...tabse_8v5f.asp
John
"Tim Graham" <tgraham3@.metlife.com> wrote in message news:OtlW4R7PEHA.2704@.TK2MSFTNGP10.phx.gbl...
I am finding some unusual deadlock victum messages in my errorlogs that I have included in this message. I would appreciate any information about these messages. I am familiar with the normal deadlock message, it is the statements in red that I need help with.
thanks
tim
2004-05-21 16:07:58.18 spid4
Deadlock encountered ... Printing deadlock information
2004-05-21 16:07:58.18 spid4
2004-05-21 16:07:58.18 spid4 Wait-for graph
2004-05-21 16:07:58.18 spid4
2004-05-21 16:07:58.18 spid4 Node:1
2004-05-21 16:07:58.18 spid4 RID: 5:1:536178:4 CleanCnt:1 Mode: X Flags: 0x2
2004-05-21 16:07:58.18 spid4 Grant List 3::
2004-05-21 16:07:58.18 spid4 Owner:0x68e15860 Mode: X Flg:0x0 Ref:0 Life:02000000 SPID:54 ECID:0
2004-05-21 16:07:58.18 spid4 SPID: 54 ECID: 0 Statement Type: UPDATE Line #: 2
2004-05-21 16:07:58.18 spid4 Input Buf: RPC Event: dbo.NEXTKEYZZZbIGIp$7;1
2004-05-21 16:07:58.18 spid4 Requested By:
2004-05-21 16:07:58.18 spid4 ResType:LockOwner Stype:'OR' Mode: U SPID:51 ECID:0 Ec


2004-05-21 16:07:58.18 spid4
2004-05-21 16:07:58.18 spid4 Node:2
2004-05-21 16:07:58.18 spid4 KEY: 5:1685581043:2 (6401bf0349e3) CleanCnt:1 Mode: U Flags: 0x0
2004-05-21 16:07:58.18 spid4 Grant List 2::
2004-05-21 16:07:58.18 spid4 Owner:0x70573a40 Mode: U Flg:0x0 Ref:1 Life:00000000 SPID:51 ECID:0
2004-05-21 16:07:58.18 spid4 SPID: 51 ECID: 0 Statement Type: UPDATE Line #: 2
2004-05-21 16:07:58.18 spid4 Input Buf: RPC Event: dbo.NEXTKEYZZZbIGIp$7;1
2004-05-21 16:07:58.18 spid4 Requested By:
2004-05-21 16:07:58.18 spid4 ResType:LockOwner Stype:'OR' Mode: U SPID:54 ECID:0 Ec


2004-05-21 16:07:58.18 spid4 Victim Resource Owner:
2004-05-21 16:07:58.18 spid4 ResType:LockOwner Stype:'OR' Mode: U SPID:51 ECID:0 Ec


2004-05-21 16:11:50.78 spid4 Victim Resource Owner:
2004-05-21 16:11:50.78 spid4 ResType:ExchangeId Stype:'AND' SPID:69 ECID:22 Ec


2004-05-21 16:11:55.78 spid4 Victim Resource Owner:
2004-05-21 16:11:55.78 spid4 ResType:ExchangeId Stype:'AND' SPID:69 ECID:22 Ec


No comments:
Post a Comment