> > 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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
