IDS Forum

Re: wait for mutex ... IDS hang....

Posted By: JACQUES RENAUT
Date: Tuesday, 17 August 2010, at 1:51 p.m.

In Response To: wait for mutex ... IDS hang.... (FRANK)

Frank wrote:
(4) mutex holder ??? it shows session 88852, but onstat -g ses 88852 shows
nothing ( see below)

informix@dora $ onstat -g lmx

IBM Informix Dynamic Server Version 11.10.UC2 -- On-Line -- Up 4 days
03:03:29 -- 2120544 Kbytes

Locked mutexes:
mid addr name holder lkcnt waiter waittime
13 407aa028 session 88852 0 13 48356

Response:

The "88852" is not the session number for the holder of the mutex. It's the thread id, as is the waiter field. So instead of looking at onstat -g ses for that number, you need to look at onstat -g ath and get the matching thread id (first column output). Then take the value for the rstcb column from that onstat -g ath output and match that to the 1st column of the onstat -u output, and then use the session number from the onstat -u. You would probably also want to get onstat -g stk <thread id> output for the holder of the mutex. This looks like some sort of mutex deadlock, but onstat -g stk 88852 output along with onstat -g ses output for the correct session of the holder would probably help.

Jacques Renaut
IBM Informix Advanced Support
APD Team

Messages In This Thread

• wait for mutex ... IDS hang....
  FRANK -- Tuesday, 17 August 2010, at 1:15 p.m.
  • Re: wait for mutex ... IDS hang....
    JACQUES RENAUT -- Tuesday, 17 August 2010, at 1:51 p.m.
    • Re: wait for mutex ... IDS hang....
      FRANK -- Tuesday, 17 August 2010, at 2:28 p.m.
      • Re: wait for mutex ... IDS hang....
        JACQUES RENAUT -- Tuesday, 17 August 2010, at 3:08 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.