Re: BUG #13523: Unexplained deadlocks (possible race condition) - Mailing list pgsql-bugs

From Jack Douglas
Subject Re: BUG #13523: Unexplained deadlocks (possible race condition)
Date
Msg-id 01ae01d0caa5$a9c774a0$fd565de0$@douglastechnology.co.uk
Whole thread Raw
In response to Re: BUG #13523: Unexplained deadlocks (possible race condition)  (Andres Freund <andres@anarazel.de>)
List pgsql-bugs
> I am wondering if the deadlock reports would be a bit easier to debug if
we didn't just say "blocked by process 9394", but also in which lockmode
it's held currently.

That would certainly help, something like this would have been a big clue in
this case:

...
relation 65605 of database 12141; blocked by RowExclusiveLock held by
process 9393.
...

is that what you mean?

pgsql-bugs by date:

Previous
From: marko@joh.to
Date:
Subject: BUG #13528: LATERAL vs. correlated scalar subquery
Next
From: "Jack Douglas"
Date:
Subject: Re: BUG #13523: Unexplained deadlocks (possible race condition)