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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Retry after buffer locking failure during SPGiST index creation.
Date: 2013-11-02 20:46:38
Message-ID: E1Vci5e-0008S9-5I@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
------
REL9_3_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/86dab9c8addd2898abc0feddc4e7f1ef0cd786f4

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

Browse pgsql-committers by date

  From Date Subject
Next Message Kevin Grittner 2013-11-02 23:40:42 pgsql: Fix subquery reference to non-populated MV in CMV.
Previous Message Tom Lane 2013-11-01 20:10:41 pgsql: Ensure all files created for a single BufFile have the same reso