How to get info about deadlocks?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-hackers(at)postgreSQL(dot)org
Subject: How to get info about deadlocks?
Date: 1999-11-29 04:31:49
Message-ID: 12617.943849909@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 1999-11-29 04:49:15 Re: [HACKERS] VACUUM as a denial-of-service attack
Previous Message Vince Vielhaber 1999-11-29 03:05:28 Re: BOUNCE pgsql-ports@postgreSQL.org: Non-member submission from [Joe Brenner <doom@kzsu.stanford.edu>] (fwd)