This is a multi-part message in MIME format.
--=_NextPart_000_0006_01C84D3C.B9609430
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
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=3Dxxxxxxx dbid=3DXX = indexname=3D...objectname=3D... id=3Dlock13c50480 mode=3DS = associatedObjectId=3D72057594039304192
or
pagelock fileid=3DX pageid=3Dxxxx dbid=3DXX = objectname=3D.... id=3Dlock5f69480 mode=3DIX = associatedObjectId=3D72057594378518528
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
--=_NextPart_000_0006_01C84D3C.B9609430
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
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=3Dxxxxxxx dbid=3DXX = indexname=3D...objectname=3D... &nbs= p; id=3Dlock13c50480 = mode=3DS associatedObjectId=3D72057594039304192
or
pagelock fileid=3DX pageid=3Dxxxx dbid=3DXX &nbs= p; objectname=3D.... id=3Dlock5f69480 mode=3DIX associatedObjectId=3D7205759437851= 8528
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
--=_NextPart_000_0006_01C84D3C.B9609430--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
"Med Bouchenafa" wrote:
> 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,
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" <com.hotmail@.bouchenafa> wrote in message
news:%23znq0EVTIHA.5516@.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|||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
"Russell Fields" <russellfields@.nomail.com> wrote in message
news:uSgP$qVTIHA.5404@.TK2MSFTNGP03.phx.gbl...
> 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" <com.hotmail@.bouchenafa> wrote in message
> news:%23znq0EVTIHA.5516@.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
>
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment