pg.ddx.io  pgsql-committers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Michael Paquier <michael@paquier.xyz>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: Fix corruption of local buffer state during extend of temp relat
Date: Fri, 05 Jan 2024 11:11:43 +0000
Message-ID: <E1rLi75-00DdOp-Jn@gemulon.postgresql.org> (raw)

Fix corruption of local buffer state during extend of temp relation

A typo has been introduced by 31966b151e6a when updating the state of a
local buffer when a temporary relation is extended, for the case of a
block included in the relation range extended, when it is already found
in the hash table holding the local buffers.  In this case, BM_VALID
should be cleared, but the buffer state was changed so as BM_VALID
remained while clearing the other flags.

As reported on the thread, it was possible to corrupt the state of the
local buffers on ENOSPC, but the states would be corrupted on any kind
of ERROR during the relation extend (like partial writes or some other
errno).

Reported-by: Alexander Lakhin
Author: Tender Wang
Reviewed-by: Richard Guo, Alexander Lakhin, Michael Paquier
Discussion: https://postgr.es/m/18259-6e256429825dd435@postgresql.org
Backpatch-through: 16

Branch
------
REL_16_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/37c5516633c833de6bdb57a1752a2f8e8f0d5420

Modified Files
--------------
src/backend/storage/buffer/localbuf.c | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)



view thread (2+ messages)

Message-ID: <E1rLi75-00DdOp-Jn@gemulon.postgresql.org>
Permalink:  ../E1rLi75-00DdOp-Jn@gemulon.postgresql.org/
Also on:    postgresql.org/message-id/E1rLi75-00DdOp-Jn@gemulon.postgresql.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-committers@postgresql.org
  Cc: michael@paquier.xyz, pgsql-committers@lists.postgresql.org
  Subject: Re: pgsql: Fix corruption of local buffer state during extend of temp relat
  In-Reply-To: <E1rLi75-00DdOp-Jn@gemulon.postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox