Deadlock Object ID

Monitor, diagnose and receive alerts to problems across your SQL Servers.

Moderators: eddie davis, david connell, dlkj, Colin Millerchip, priyasinha, Emma A

Deadlock Object ID

Postby bwilkinson » Thu Apr 08, 2010 2:51 pm

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 :oops: .

-Brian
bwilkinson
 
Posts: 6
Joined: Mon Jul 27, 2009 7:02 pm
Location: Quickie Manufacturing

Postby Brian Donahue » Fri Apr 09, 2010 3:47 pm

Hi Brian,

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

I hope this helps!
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby bwilkinson » Fri Apr 09, 2010 4:06 pm

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.
bwilkinson
 
Posts: 6
Joined: Mon Jul 27, 2009 7:02 pm
Location: Quickie Manufacturing

Postby Brian Donahue » Fri Apr 09, 2010 5:23 pm

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

http://connect.microsoft.com/SQLServer/ ... g-deadlock
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby kevriley » Mon Apr 12, 2010 11:35 am

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
kevriley
 
Posts: 71
Joined: Tue Apr 07, 2009 12:46 pm
Location: UK


Return to SQL Response 1

Who is online

Users browsing this forum: No registered users and 0 guests