pgsql: In B-tree page deletion, clean up properly after page deletion f

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: In B-tree page deletion, clean up properly after page deletion f
Date: 2016-08-06 18:28:51
Message-ID: [email protected]
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

In B-tree page deletion, clean up properly after page deletion failure.

In _bt_unlink_halfdead_page(), we might fail to find an immediate left
sibling of the target page, perhaps because of corruption of the page
sibling links. The code intends to cope with this by just abandoning
the deletion attempt; but what actually happens is that it fails outright
due to releasing the same buffer lock twice. (And error recovery masks
a second problem, which is possible leakage of a pin on another page.)
Seems to have been introduced by careless refactoring in commit efada2b8e.
Since there are multiple cases to consider, let's make releasing the buffer
lock in the failure case the responsibility of _bt_unlink_halfdead_page()
not its caller.

Also, avoid fetching the leaf page's left-link again after we've dropped
lock on the page. This is probably harmless, but it's not exactly good
coding practice.

Per report from Kyotaro Horiguchi. Back-patch to 9.4 where the faulty code
was introduced.

Discussion: <20160803(dot)173116(dot)111915228(dot)horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>

Branch
------
master

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

Modified Files
--------------
src/backend/access/nbtree/nbtpage.c | 27 +++++++++++++++++++++++----
1 file changed, 23 insertions(+), 4 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2016-08-07 02:08:38 pgsql: First-draft release notes for 9.5.4.
Previous Message Tom Lane 2016-08-05 22:58:52 pgsql: Teach libpq to decode server version correctly from future serve