Drop Table

Support Forum for database administrators and web based access to important newsgroups related to databases
Register on Database Support Forum Edit your profileCalendarFind other Database Support forum membersFrequently Asked QuestionsSearch this forum -> 
For Database admins: Free Database-related Magazines Now Free shipping to Texas


Post New Thread










Thread
Author

sp_MShasdbaccess deadlocks?
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.


Report this thread to moderator Post Follow-up to this message
Old Post
KJ
11-30-06 12:13 AM


Sponsored Links





Last Thread Next Thread
Post New Thread

MS SQL Server archive

Show a Printable Version Email This Page to Someone! Receive updates to this thread
Microsoft SQL Server
Access database support
PostgreSQL Replication
SQL Server ODBC
FoxPro Support
PostgreSQL pgAdmin
SQL Server Clustering
MySQL ODBC
Web Applications with dBASE
SQL Server CE
MySQL++
Sybase Database Support
MS SQL Full Text Search
PostgreSQL Administration
SQL Anywhere support
DB2 UDB Database
Paradox Database Support
Filemaker Database
Berkley DB
SQL 2000/2000i database
ASE Database
Forum Jump:
All times are GMT. The time now is 09:03 PM.

 
Mobile devices forum | Database support forum archive




Copyrights DropTable.com Database Support Forum 2004 - 2006