pgsql: Avoid deadlock between concurrent CREATE INDEX CONCURRENTLY comm
pgsql: Avoid deadlock between concurrent CREATE INDEX CONCURRENTLY comm
От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
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. Branch ------ REL9_1_STABLE Details ------- http://git.postgresql.org/pg/commitdiff/32ad1d696a0e7b50074d57b25708ffd1dc82600f Modified Files -------------- src/backend/commands/indexcmds.c | 23 +++++++++++++++-------- 1 files changed, 15 insertions(+), 8 deletions(-)