]> granicus.if.org Git - postgresql/commit
Avoid deadlock between concurrent CREATE INDEX CONCURRENTLY commands.
authorTom Lane <tgl@sss.pgh.pa.us>
Thu, 25 Apr 2013 20:58:10 +0000 (16:58 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Thu, 25 Apr 2013 20:58:10 +0000 (16:58 -0400)
commit9e859a9150cabd44e91ed80a90d45223b1e3986e
treeaf2f8a9a653a1d92ad43e516c1a8f6af8853c17f
parent719845b5a76477ab28ee12633c7ea07f777649d9
Avoid deadlock between concurrent CREATE INDEX CONCURRENTLY commands.

There was a high probability of two or more concurrent C.I.C. commands
deadlocking just before completion, because each would wait for the others
to release their reference snapshots.  Fix by releasing the snapshot
before waiting for other snapshots to go away.

Per report from Paul Hinze.  Back-patch to all active branches.
src/backend/commands/indexcmds.c