Server Management - Systems Insight Manager
1753374 Members
5110 Online
108792 Solutions
New Discussion юеВ

Re: Systems Insight Manager - SQL Server 2000 - Deadlock Error

 
Mike Godwin
New Member

Systems Insight Manager - SQL Server 2000 - Deadlock Error

I've noticed lately that I've been getting a lot of "Deadlock" errors in my SQL Server error logs. Is this something I need to look into further or just one of those many errors I should just let go past? Here's a copy of the error:
===============================================
Deadlock encountered .... Printing deadlock information
2007-10-09 09:17:52.04 spid4
2007-10-09 09:17:52.04 spid4 Wait-for graph
2007-10-09 09:17:52.04 spid4
2007-10-09 09:17:52.04 spid4 Node:1
2007-10-09 09:17:52.04 spid4 KEY: 7:2:1 (db0038d7124c) CleanCnt:2 Mode: U Flags: 0x0
2007-10-09 09:17:52.04 spid4 Grant List 0::
2007-10-09 09:17:52.04 spid4 Owner:0x25403e60 Mode: S Flg:0x0 Ref:1 Life:00000000 SPID:5 ECID:0
2007-10-09 09:17:52.04 spid4 SPID: 5 ECID: 0 Statement Type: UNKNOWN TOKEN Line #: 0
2007-10-09 09:17:52.04 spid4 Input Buf: No Event:
2007-10-09 09:17:52.04 spid4 Grant List 3::
2007-10-09 09:17:52.04 spid4 Requested By:
2007-10-09 09:17:52.04 spid4 ResType:LockOwner Stype:'OR' Mode: X SPID:58 ECID:0 Ec:(0x35F41540) Value:0x4456aac0 Cost:(0/4F34)
2007-10-09 09:17:52.04 spid4
2007-10-09 09:17:52.04 spid4 Node:2
2007-10-09 09:17:52.04 spid4 TAB: 7:1728725211 [] CleanCnt:2 Mode: Schema-Mod Flags: 0x0
2007-10-09 09:17:52.04 spid4 Grant List 3::
2007-10-09 09:17:52.04 spid4 Owner:0x4456a0e0 Mode: Schema-Mod Flg:0x0 Ref:1 Life:00000000 SPID:58 ECID:0
2007-10-09 09:17:52.04 spid4 SPID: 58 ECID: 0 Statement Type: TRUNCATE TABLE Line #: 1
2007-10-09 09:17:52.04 spid4 Input Buf: Language Event: truncate table consolidatedNodeAuths
2007-10-09 09:17:52.04 spid4 Requested By:
2007-10-09 09:17:52.04 spid4 ResType:LockOwner Stype:'OR' Mode: IX SPID:5 ECID:0 Ec:(0x2F9DA3F0) Value:0x1c514a40 Cost:(1/0)
2007-10-09 09:17:52.04 spid4 Victim Resource Owner:
2007-10-09 09:17:52.04 spid4 ResType:LockOwner Stype:'OR' Mode: IX SPID:5 ECID:0 Ec:(0x2F9DA3F0) Value:0x1c514a40 Cost:(1/0)
2007-10-09 09:17:52.04 spid5 Transaction (Process ID 5) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
============================================

Thanks for any information.
3 REPLIES 3
Aravindh Rajaram
Honored Contributor

Re: Systems Insight Manager - SQL Server 2000 - Deadlock Error

Which version of SIM are you using?
Mike Godwin
New Member

Re: Systems Insight Manager - SQL Server 2000 - Deadlock Error

Build version: C.05.01.00.02
Build date: 2007-04-11 17:26
Mike Godwin
New Member

Re: Systems Insight Manager - SQL Server 2000 - Deadlock Error

So, no one else is having this issue? I'm seeing this error about 5 times a day.

Thanks for any help.

Mike