Red Gate forums :: View topic - Deadlock Object ID
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Response 1
SQL Response 1 forum

Deadlock Object ID

Search in SQL Response 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
bwilkinson



Joined: 27 Jul 2009
Posts: 6
Location: Quickie Manufacturing

PostPosted: Thu Apr 08, 2010 2:51 pm    Post subject: Deadlock Object ID Reply with quote

I have a deadlock message that I am having a little trouble decipering.

the DBID I have converted to the correct DB using sys.objects with no problem but the Object ID and Index ID I can not figure out how to find the actual objects in my DB.

107 Index (Key) dbid: 6, object id: 72057598122328064, index id: (a603eec0617a) UPDATE Line #: 565

Any help would be great Embarassed .

-Brian
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6674

PostPosted: Fri Apr 09, 2010 3:47 pm    Post subject: Reply with quote

Hi Brian,

You can resolve the object ID to an object name using
SELECT object_name(72057598122328064)

I hope this helps!
Back to top
View user's profile Send private message
bwilkinson



Joined: 27 Jul 2009
Posts: 6
Location: Quickie Manufacturing

PostPosted: Fri Apr 09, 2010 4:06 pm    Post subject: Reply with quote

When I try that I get the following error message

Msg 8115, Level 16, State 2, Line 1
Arithmetic overflow error converting expression to data type int.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6674

PostPosted: Fri Apr 09, 2010 5:23 pm    Post subject: Reply with quote

Hi Brian,
It looks like SQL Server has a bug. Please see this Microsoft article for a workaround.

http://connect.microsoft.com/SQLServer/feedback/details/276695/certain-dmvs-causing-arithmetic-overflow-during-deadlock
Back to top
View user's profile Send private message
kevriley



Joined: 07 Apr 2009
Posts: 70
Location: UK

PostPosted: Mon Apr 12, 2010 11:35 am    Post subject: Reply with quote

That id looks more like the bigint field partition_id or hobt_id that you find in sys.partitions.

Try ...

select * from sys.partitions where partition_id = '72057598122328064'

or
select * from sys.partitions where hobt_id = '72057598122328064'

this will then give you an object_id (int) that can be used with Object_name() to resolve
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group