From: | Tim Holloway <mtsinc(at)southeast(dot)net> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] How to get info about deadlocks? |
Date: | 1999-11-30 01:46:30 |
Message-ID: | 38432C76.5D645DD2@southeast.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Well, you have a bit table that indicates what locks are already held and
it's being AND'ed one indicating with the locks you hold. If they overlap,
you're in trouble.
Have you turned on LOCK_MGR_DEBUG? I'd print out the masks if the lock dump
routine doesn't already.
Tom Lane wrote:
>
> 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
>
> ************
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1999-11-30 01:49:52 | Re: indexable and locale |
Previous Message | Bruce Momjian | 1999-11-30 01:31:46 | Re: [DOCS] Re: [HACKERS] Outline for PostgreSQL book |