pgsql: Avoid deadlock between concurrent CREATE INDEX CONCURRENTLY comm

Поиск
Список
Период
Сортировка
От Tom Lane
Тема pgsql: Avoid deadlock between concurrent CREATE INDEX CONCURRENTLY comm
Дата
Msg-id E1UVTFj-00079q-66@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
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(-)


В списке pgsql-committers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: pgsql: Avoid deadlock between concurrent CREATE INDEX CONCURRENTLY comm
Следующее
От: Tom Lane
Дата:
Сообщение: pgsql: Avoid deadlock between concurrent CREATE INDEX CONCURRENTLY comm