Re: Problem on AIX with current

> > 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
toabalance is 406' where aid = 1447
 
--
Tatsuo Ishii