Skip site navigation (1) Skip section navigation (2)

Re: Problem on AIX with current

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: tgl(at)sss(dot)pgh(dot)pa(dot)us
Cc: ZeugswetterA(at)spardat(dot)at, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Problem on AIX with current
Date: 2001-10-02 01:09:39
Message-ID: 20011002100939E.t-ishii@sra.co.jp (view raw or flat)
Thread:
Lists: pgsql-hackers
> > Here is a stack trace using dbx.
> 
> > semop(??, ??, ??) at 0xd02be73c
> > IpcSemaphoreLock(??, ??, ??), line 425 in "ipc.c"
> > LWLockAcquire(??, ??), line 270 in "lwlock.c"
> > LockAcquire(??, ??, ??, ??, ??), line 482 in "lock.c"
> 
> This process is waiting to acquire the LockMgr lock.  You need to look
> at the rest of the processes and try to figure out who's got the lock.

Strange enough, there's no other backend (of course except stats
collectors) here. I make sure this with ps and pg_stat_activity view.

BTW pg_stat_activity view shows:

16556 | test    |  197378 |        1 | postgres | update accounts set abalance = abalance + 406, filler = 'added amount to abalance is 406' where aid = 1447
--
Tatsuo Ishii

In response to

Responses

pgsql-hackers by date

Next:From: Thomas LockhartDate: 2001-10-02 01:14:00
Subject: Re: CVS changes
Previous:From: Vince VielhaberDate: 2001-10-02 00:38:52
Subject: Re: CVS changes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group