Postgres Pro
Downloads
Home   >   mailing lists

Re: WaitOnLock error - what does this mean? - Mailing list pgsql-general

From Tom Lane
Subject Re: WaitOnLock error - what does this mean?
Date
Msg-id 15266.964410393@sss.pgh.pa.us
Whole thread Raw
In response to WaitOnLock error - what does this mean?  ("Robert B. Easter" <reaster@comptechnews.com>)
Responses Re: WaitOnLock error - what does this mean?  ("Robert B. Easter" <reaster@comptechnews.com>)
Re: WaitOnLock error - what does this mean?  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
Tree view 
"Robert B. Easter" <reaster@comptechnews.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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Migrating from Sybase
Next
From: "anuj"
Date:
Subject: RE: how connect visual basic to pgsql?