]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Better fix for deadlock hazard in CREATE INDEX CONCURRENTLY.
authorTom Lane <tgl@sss.pgh.pa.us>
Wed, 18 Apr 2018 16:07:38 +0000 (12:07 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Wed, 18 Apr 2018 16:07:38 +0000 (12:07 -0400)
commit82acf3eb7db92640f16a1197e62f2dceba77415c
tree0ba067ec86eea2a254117b54b9723aa9b555170b
parent93053aca5400a118447d408ed3e70d55d567de72
Better fix for deadlock hazard in CREATE INDEX CONCURRENTLY.

Commit 54eff5311 did not account for the possibility that we'd have
a transaction snapshot due to default_transaction_isolation being
set high enough to require one.  The transaction snapshot is enough
to hold back our advertised xmin and thus risk deadlock anyway.
The only way to get rid of that snap is to start a new transaction,
so let's do that instead.  Also throw in an assert checking that we
really have gotten to a state where no xmin is being advertised.

Back-patch to 9.4, like the previous commit.

Discussion: https://postgr.es/m/CAMkU=1ztk3TpQdcUNbxq93pc80FrXUjpDWLGMeVBDx71GHNwZQ@mail.gmail.com
src/backend/commands/indexcmds.c