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

Started by Tom Laneover 12 years ago1 messagescomitters
Jump to latest
#1Tom Lane
tgl@sss.pgh.pa.us

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
------
REL9_2_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/a1c3d54fb6b9fd974fa4d0166bfd1fde30c8d8c2

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

--
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers