a ghost lock
SMITH JOHN, on IDS 9.40.FC9, could not lock a table exclusively; sysmaster syslocks showed IX locks owned by session 15 with no such session visible. Dan Mueller suspected an internal engine session, seen after an index build in HDR, and suggested a stack trace. Fernando Nunes asked about onstat -u. Dan explained working back from onstat -k to the thread id and onstat -g stk. Unresolved.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi to all under IDS 9.40.FC9, i try to lock a table begin work; lock table mytable in exclusive mode; it says that the table is already locked, i try to find out who is locking the table , NO ONE in the sysmaster.syslocks i found : dbsname mydb tabname mytable rowidlk 0 keynum 0 type IX owner 15 waiter dbsname mydb tabname mytable rowidlk 0 keynum 0 type IX owner 15 waiter but no trace of the session number 15. can anyone help me ?
With such a low session number I would think it is one of the engine's sessions. I run into this scenario after an index build in HDR. Can you trace things back to where you can get a stack trace? That would be helpful as to what is actually going on. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of SMITH JOHN Sent: Wednesday, February 09, 2011 10:06 AM To: ids@iiug.org Subject: a ghost lock [22736] Hi to all under IDS 9.40.FC9, i try to lock a table begin work; lock table mytable in exclusive mode; it says that the table is already locked, i try to find out who is locking the table , NO ONE in the sysmaster.syslocks i found : dbsname mydb tabname mytable rowidlk 0 keynum 0 type IX owner 15 waiter dbsname mydb tabname mytable rowidlk 0 keynum 0 type IX owner 15 waiter but no trace of the session number 15. can anyone help me ? ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
how can i find the stack trace ?
onstat -u doesn't show the SID 15? A low number can probably be an internal
session...
Regards.
On Wed, Feb 9, 2011 at 3:06 PM, SMITH JOHN <daylight@webmails.com> wrote:
> Hi to all
>
> under IDS 9.40.FC9, i try to lock a table
>
> begin work;
> lock table mytable in exclusive mode;
>
> it says that the table is already locked, i try to find out who is locking
> the
> table , NO ONE
>
> in the sysmaster.syslocks i found :
>
> dbsname mydb
> tabname mytable
> rowidlk 0
> keynum 0
> type IX
> owner 15
> waiter
>
> dbsname mydb
> tabname mytable
> rowidlk 0
> keynum 0
> type IX
> owner 15
> waiter
>
> but no trace of the session number 15.
>
> can anyone help me ?
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--
Fernando Nunes
Portugal
http://informix-technology.blogspot.com
My email works... but I don't check it frequently...
--0015174c1c8295e024049bdc109c
Using onstat work backwards from an onstan -k. Find the owner, get the thread
id onstat -g stk against the tid
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of SMITH
JOHN
Sent: Wednesday, February 09, 2011 11:02 AM
To: ids@iiug.org
Subject: Re: RE: a ghost lock [22739]
how can i find the stack trace ?
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.