]> granicus.if.org Git - postgresql/commit
projects / postgresql / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 447b317) | patch
Avoid deadlock between concurrent CREATE INDEX CONCURRENTLY commands.
authorTom Lane <tgl@sss.pgh.pa.us>
Thu, 25 Apr 2013 20:58:05 +0000 (16:58 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Thu, 25 Apr 2013 20:58:05 +0000 (16:58 -0400)
commitc3d09b3bd23f5f65b5eb8124a3c7592dad85a50c
treea8ae5204d40d6faea3c3a4a52ce724640a8fb5eftree | snapshot
parent447b3174f58be808e81408b2166b41d898292ab3commit | diff
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 diff | blob | history
Unnamed repository; edit this file 'description' to name the repository.