> > 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