How to get info about deadlocks?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема How to get info about deadlocks?
Дата
Msg-id 12617.943849909@sss.pgh.pa.us
обсуждение исходный текст
Ответы Re: [HACKERS] How to get info about deadlocks?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список 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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Vince Vielhaber
Дата:
Сообщение: Re: BOUNCE pgsql-ports@postgreSQL.org: Non-member submission from [Joe Brenner ] (fwd)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] VACUUM as a denial-of-service attack