Deadlock in multiple CIC.

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Deadlock in multiple CIC.
Дата
Msg-id CAMkU=1ztk3TpQdcUNbxq93pc80FrXUjpDWLGMeVBDx71GHNwZQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Deadlock in multiple CIC.  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Re: Deadlock in multiple CIC.  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список pgsql-hackers
Дерево обсуждения
c3d09b3bd23f5f6 fixed it so concurrent CIC would not deadlock (or at least not as reliably as before) by dropping its own snapshot before waiting for all the other ones to go away.

With commit 8aa3e47510b969354ea02a, concurrent CREATE INDEX CONCURRENTLY on different tables in the same database started deadlocking against each other again quite reliably.

I think the solution is simply to drop the catalog snapshot as well, as in the attached.



Cheers,

Jeff
Вложения

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Getting rid of "tuple concurrently updated" elog()s with concurrentDDLs (at least ALTER TABLE)
Следующее
От: Lelisa Diriba
Дата:
Сообщение: Ethiopian calendar year(DATE TYPE) are different from the Gregoriancalendar year