Deadlock Object ID

bwilkinson

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

Brian Donahue

Hi Brian,

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

I hope this helps!

bwilkinson

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.

Brian Donahue

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

kevriley

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