BUG #6313: Deadlock reporting contains not enought details

From: dmigowski(at)ikoffice(dot)de
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6313: Deadlock reporting contains not enought details
Date: 2011-12-01 16:00:46
Message-ID: E1RW942-000531-06@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 6313
Logged by: Daniel Migowski
Email address: dmigowski(at)ikoffice(dot)de
PostgreSQL version: 8.3.16
Operating system: Linux
Description:

In my application I receive deadlocks from time to time, reported by an
error message like this:

ERROR: deadlock detected
SQL Status:40P01
Detail:Process 30812 waits for ShareLock on transaction 278158200; blocked
by process 2852.
Process 2852 waits for ShareLock on transaction 278158159; blocked by
process 30812.

This is absolutely useless for me for the following reasons. I know which
processes have participated in the deadlock, and one of them returns an
error, abd I know which statement does the deadlock, but my "statement"
contains of 20 single sql statements and I don't know which lock the
processes where fighting over. Could you please add information about which
lock could not be granted, and what other locks have already been in place
(or at least, what other locks have participated in this deadlock
detection)?

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2011-12-01 16:54:28 Re: BUG #6313: Deadlock reporting contains not enought details
Previous Message magnus 2011-12-01 14:39:31 BUG #6312: Test bug