Re: BUG #13523: Unexplained deadlocks (possible race condition)

Поиск
Список
Период
Сортировка
От Jack Douglas
Тема Re: BUG #13523: Unexplained deadlocks (possible race condition)
Дата
Msg-id 01ae01d0caa5$a9c774a0$fd565de0$@douglastechnology.co.uk
обсуждение исходный текст
Ответ на Re: BUG #13523: Unexplained deadlocks (possible race condition)  (Andres Freund <andres@anarazel.de>)
Список 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 по дате отправления:

Предыдущее
От: marko@joh.to
Дата:
Сообщение: BUG #13528: LATERAL vs. correlated scalar subquery
Следующее
От: "Jack Douglas"
Дата:
Сообщение: Re: BUG #13523: Unexplained deadlocks (possible race condition)