pgsql: Retry after buffer locking failure during SPGiST index creation.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема pgsql: Retry after buffer locking failure during SPGiST index creation.
Дата
Msg-id E1Vci5e-0008S7-3N@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Retry after buffer locking failure during SPGiST index creation.

The original coding thought this case was impossible, but it can happen
if the bgwriter or checkpointer processes decide to write out an index
page while creation is still proceeding, leading to a bogus "unexpected
spgdoinsert() failure" error.  Problem reported by Jonathan S. Katz.

Teodor Sigaev

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/24ace4053d42e2c48af8c15d598622e488fb9502

Modified Files
--------------
src/backend/access/spgist/spgdoinsert.c |    9 ++++++---
src/backend/access/spgist/spginsert.c   |   15 +++++++++++----
2 files changed, 17 insertions(+), 7 deletions(-)


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: pgsql: Ensure all files created for a single BufFile have the same reso
Следующее
От: Tom Lane
Дата:
Сообщение: pgsql: Retry after buffer locking failure during SPGiST index creation.