sql server deadlock message - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Old Forums

CLOSED - General SQL Server

sql server deadlock message

Author

Topic

lavenders
Starting Member

2 Posts

Posted - 2004-12-21 : 20:23:16

hi, everyone

My sql server2000 encounted deadlock and reported message like follow;

...

Deadlock encountered .... Printing deadlock information
2004-12-21 11:10:28.06 spid2
2004-12-21 11:10:28.06 spid2 Wait-for graph
2004-12-21 11:10:28.06 spid2
2004-12-21 11:10:28.06 spid2 Node:1
2004-12-21 11:10:28.07 spid2 PAG: 7:1:12997 CleanCnt:2 Mode: IX Flags: 0x0
2004-12-21 11:10:28.07 spid2 Grant List::
2004-12-21 11:10:28.07 spid2 Owner:0x42bc5700 Mode: IX Flg:0x0 Ref:0 Life:02000000 SPID:53 ECID:0
2004-12-21 11:10:28.07 spid2 SPID: 53 ECID: 0 Statement Type: UPDATE Line #: 1
2004-12-21 11:10:28.07 spid2 Input Buf: RPC Event: #jtds000008;1
2004-12-21 11:10:28.07 spid2 Requested By:
2004-12-21 11:10:28.07 spid2 ResType:LockOwner Stype:'OR' Mode: U SPID:61 ECID:0 Ec:(0x579314f8) Value:0x42bcd540 Cost:(0/334)
2004-12-21 11:10:28.07 spid2
2004-12-21 11:10:28.07 spid2 Node:2
2004-12-21 11:10:28.07 spid2 PAG: 7:1:12997 CleanCnt:2 Mode: IX Flags: 0x0
2004-12-21 11:10:28.07 spid2 Grant List::
2004-12-21 11:10:28.07 spid2 Owner:0x52e9a980 Mode: IX Flg:0x0 Ref:0 Life:02000000 SPID:61 ECID:0
2004-12-21 11:10:28.07 spid2 SPID: 61 ECID: 0 Statement Type: UPDATE Line #: 1
2004-12-21 11:10:28.07 spid2 Input Buf: RPC Event: #jtds000017;1
2004-12-21 11:10:28.07 spid2 Requested By:
2004-12-21 11:10:28.07 spid2 ResType:LockOwner Stype:'OR' Mode: U SPID:53 ECID:0 Ec:(0x4c2fd4f8) Value:0x42be58c0 Cost:(0/104)
2004-12-21 11:10:28.07 spid2 Victim Resource Owner:
2004-12-21 11:10:28.07 spid2 ResType:LockOwner Stype:'OR' Mode: U SPID:53 ECID:0 Ec:(0x4c2fd4f8) Value:0x42be58c0 Cost:(0/104)
2004-12-21 11:10:45.59 spid2

...

it's same 2 page locks resulted in deadlock, but howw can I know
which tables the deadlock occured?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-12-22 : 15:06:41

You can use SQL Profiler to view them or you can add the deadlock trace flags to the startup of SQL Server. Check SQL Server Books Online for details.

Tara

lavenders
Starting Member

2 Posts

Posted - 2004-12-22 : 21:33:59

Thanks, Tara

I've add trace flags and got the above message lines in log.
Now I wanna to know whick table was locked.
I think the useful line is: PAG: 7:1:12997 ...
It indcates db-id is 7, file-id is 1 and page-id is 12997 is locked,
but whick table is locked?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-12-23 : 12:09:35

The log contains the object id of which ones were involved in the deadlock situation as well.

Tara

jcelano@netkey.com
Starting Member

1 Post

Posted - 2005-10-21 : 15:42:50

Hi.

did you ever find a resolution to this problem. we are experiencing a similiar one in our application. we are using hibernate/jboss for data access and these jtds transactions don't go away.

joe

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources