Deadlock in multiple CIC. - Mailing list pgsql-hackers

From Jeff Janes
Subject Deadlock in multiple CIC.
Date
Msg-id CAMkU=1ztk3TpQdcUNbxq93pc80FrXUjpDWLGMeVBDx71GHNwZQ@mail.gmail.com
Whole thread Raw
Responses Re: Deadlock in multiple CIC.  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Re: Deadlock in multiple CIC.  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List 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
Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Getting rid of "tuple concurrently updated" elog()s with concurrentDDLs (at least ALTER TABLE)
Next
From: Lelisa Diriba
Date:
Subject: Ethiopian calendar year(DATE TYPE) are different from the Gregoriancalendar year