darcy@druid.net (D'Arcy J.M. Cain) writes:
> WaitOnLock: error on wakeup - Aborting this transaction
What happens to NOTICEs in your application?
For some odd reason, deadlock reports come out as a NOTICE followed by
this error message; if you are bit-bucketing NOTICEs then you may well
be confused.
Window 1:
regression=# begin;
BEGIN
regression=# lock int4_tbl;
LOCK TABLE
Window 2:
regression=# begin;
BEGIN
regression=# lock int8_tbl;
LOCK TABLE
regression=# lock int4_tbl;
<< waits >>
Window 1:
regression=# lock int8_tbl;
NOTICE: Deadlock detected -- See the lock(l) manual page for a possible cause.
ERROR: WaitOnLock: error on wakeup - Aborting this transaction
regards, tom lane