]> 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:19 +0000 (16:58 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Thu, 25 Apr 2013 20:58:19 +0000 (16:58 -0400)
commit0dcff7560a2f6c70313447b948c35f94193bc656
tree78c8c0a0475496b81457b173cb4ad573e5b6a95f
parentfe1d8c1fe705a8a881bc98feeca1b52a26e9475b
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