"Robert B. Easter" <reaster(at)comptechnews(dot)com> writes:
> ERROR: WaitOnLock: error on wakeup - Aborting this transaction
Is there any NOTICE coming out right before that?
For example:
psql #1:
begin;
lock table tenk1;
psql #2:
begin;
lock table tenk2;
lock table tenk1;
<waits>
psql #1:
lock table tenk2;
NOTICE: Deadlock detected -- See the lock(l) manual page for a possible cause.
ERROR: WaitOnLock: error on wakeup - Aborting this transaction
Not sure why this isn't just one ERROR, since anyone using a client that
discards NOTICEs is going to be confused...
regards, tom lane