MS SQL Server - sp_MShasdbaccess deadlocks?

Author

sp_MShasdbaccess deadlocks?

2006-11-29, 7:13 pm

Anyone know why this happens when the SQL Server 2000 is just starting
up? Is it unavoidable?

Deadlock encountered .... Printing deadlock information
2006-11-29 12:09:21.74 spid3
2006-11-29 12:09:21.74 spid3 Wait-for graph
2006-11-29 12:09:21.74 spid3
2006-11-29 12:09:21.74 spid3 Node:1
2006-11-29 12:09:21.74 spid3 DB: 94
CleanCnt:1 Mode: X Flags: 0x0
2006-11-29 12:09:21.74 spid3 Grant List 0::
2006-11-29 12:09:21.74 spid3 Owner:0x5430fac0 Mode: X
Flg:0x0 Ref:2 Life:00000000 SPID:578 ECID:0
2006-11-29 12:09:21.74 spid3 SPID: 578 ECID: 0 Statement Type:
SELECT Line #: 17
2006-11-29 12:09:21.74 spid3 Input Buf: Language Event:
master.dbo.sp_MShasdbaccess
2006-11-29 12:09:21.74 spid3 Requested By:
2006-11-29 12:09:21.74 spid3 ResType:LockOwner Stype:'OR' Mode:
S SPID:506 ECID:0 Ec:(0x6F7A7538) Value:0x42bd5bc0 Cost:(1/2710)
2006-11-29 12:09:21.74 spid3
2006-11-29 12:09:21.74 spid3 Node:2
2006-11-29 12:09:21.74 spid3 KEY: 1:30:1 (91013cde5e38)
CleanCnt:1 Mode: U Flags: 0x0
2006-11-29 12:09:21.74 spid3 Grant List 0::
2006-11-29 12:09:21.74 spid3 Owner:0x42bcd0e0 Mode: S
Flg:0x0 Ref:1 Life:00000000 SPID:506 ECID:0
2006-11-29 12:09:21.74 spid3 SPID: 506 ECID: 0 Statement Type:
SELECT Line #: 17
2006-11-29 12:09:21.74 spid3 Input Buf: Language Event:
dbo.sp_MShasdbaccess
2006-11-29 12:09:21.74 spid3 Requested By:
2006-11-29 12:09:21.74 spid3 ResType:LockOwner Stype:'OR' Mode:
X SPID:578 ECID:0 Ec:(0x491AD548) Value:0x42bcd320 Cost:(1/44)
2006-11-29 12:09:21.74 spid3 Victim Resource Owner:
2006-11-29 12:09:21.74 spid3 ResType:LockOwner Stype:'OR' Mode: X
SPID:578 ECID:0 Ec:(0x491AD548) Value:0x42bcd320 Cost:(1/44)
2006-11-29 12:09:21.74 spid3
2006-11-29 12:09:21.74 spid3 End deadlock search 139 ... a deadlock
was found.

Sponsored Links