Postgres Pro
Downloads
Home   >   mailing lists

How to get info about deadlocks? - Mailing list pgsql-hackers

From Tom Lane
Subject How to get info about deadlocks?
Date
Msg-id 12617.943849909@sss.pgh.pa.us
Whole thread Raw
Responses Re: [HACKERS] How to get info about deadlocks?  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Tree view 
I've been experimenting with concurrent VACUUMs and getting occasional
instances of

NOTICE:  Deadlock detected -- See the lock(l) manual page for a possible cause.
ERROR:  WaitOnLock: error on wakeup - Aborting this transaction

It would be really nice if I could find out the particular locks that
are causing this conflict --- but the code that emits these messages
isn't very transparent :-(.  Can anyone explain how to determine just
what the deadlock is?
        regards, tom lane

pgsql-hackers by date:

Previous
From: Vince Vielhaber
Date:
Subject: Re: BOUNCE pgsql-ports@postgreSQL.org: Non-member submission from [Joe Brenner ] (fwd)
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] VACUUM as a denial-of-service attack