Deadlock : What the meaning of associatedObjectId

[Med Bouchenafa]

In 2005, when 1222 trace flag is activated, I get in the error log file, among other very useful informations, this kind of message

keylock hobtid=xxxxxxx dbid=XX indexname=....objectname=.... id=lock13c50480 mode=S associatedObjectId=72057594039304192
or
pagelock fileid=X pageid=xxxx dbid=XX objectname=..... id=lock5f69480 mode=IX associatedObjectId=72057594378518528


What is the meaning of associatedObjectId?

It always starts with 72057594xxxxx and does not look like it is related to the locked object
In my case, OBJECT_NAME and OBJECT_ID did not return any relevant information

Thanks
Med

[John Bell]

Hi

This should match a waitresource in the process list and in the waiter list,
you should also should also see that database id for this which is probably 2
ie tempdb.

Check out Bart Duncan Blog
http://blogs.msdn.com/bartd/archive/2006/09/09/Deadlock-Troubleshooting_2C00_-Part-1.aspx

John

Post by Med Bouchenafa
In 2005, when 1222 trace flag is activated, I get in the error log file, among other very useful informations, this kind of message
keylock hobtid=xxxxxxx dbid=XX indexname=....objectname=.... id=lock13c50480 mode=S associatedObjectId=72057594039304192
or
pagelock fileid=X pageid=xxxx dbid=XX objectname=..... id=lock5f69480 mode=IX associatedObjectId=72057594378518528
What is the meaning of associatedObjectId?
It always starts with 72057594xxxxx and does not look like it is related to the locked object
In my case, OBJECT_NAME and OBJECT_ID did not return any relevant information
Thanks
Med

[Russell Fields]

Med,

I don't know if the associatedObjectId will help you any, although you do
have the dbid and the objectname to focus your attention. From the Books
Online article "Detecting and Ending Deadlocks"
http://msdn2.microsoft.com/en-us/library/ms178104.aspx :
associatedObjectId. Represents the HoBT (heap or b-tree) ID.

RLF

"Med Bouchenafa" <***@bouchenafa> wrote in message news:%***@TK2MSFTNGP02.phx.gbl...
In 2005, when 1222 trace flag is activated, I get in the error log file,
among other very useful informations, this kind of message

keylock hobtid=xxxxxxx dbid=XX indexname=....objectname=....
id=lock13c50480 mode=S associatedObjectId=72057594039304192
or
pagelock fileid=X pageid=xxxx dbid=XX objectname=.....
id=lock5f69480 mode=IX associatedObjectId=72057594378518528


What is the meaning of associatedObjectId?

It always starts with 72057594xxxxx and does not look like it is related to
the locked object
In my case, OBJECT_NAME and OBJECT_ID did not return any relevant
information

Thanks
Med

[Med Bouchenafa]

You're right...
That's the way it is documented in the books online.
To have the object name, I run a query like this
SELECT OBJECT_NAME(object_id) FROM sys.partitions WHERE partition_id =
@associatedObjectId
and it worked

What surprised me is the fact that they all started with 72057594xxxxx
It looks like partion_id is a component of two or more values....

Thanks again
Med

Post by Russell Fields
Med,
I don't know if the associatedObjectId will help you any, although you do
have the dbid and the objectname to focus your attention. From the Books
Online article "Detecting and Ending Deadlocks"
associatedObjectId. Represents the HoBT (heap or b-tree) ID.
RLF
In 2005, when 1222 trace flag is activated, I get in the error log file,
among other very useful informations, this kind of message
keylock hobtid=xxxxxxx dbid=XX indexname=....objectname=....
id=lock13c50480 mode=S associatedObjectId=72057594039304192
or
pagelock fileid=X pageid=xxxx dbid=XX
objectname=..... id=lock5f69480 mode=IX
associatedObjectId=72057594378518528
What is the meaning of associatedObjectId?
It always starts with 72057594xxxxx and does not look like it is related
to the locked object
In my case, OBJECT_NAME and OBJECT_ID did not return any relevant information
Thanks
Med