pg.ddx.io  pgsql-committers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: Preserve CurrentMemoryContext across notify and sinval interrupt
Date: Mon, 01 Jul 2024 16:21:28 +0000
Message-ID: <E1sOJmR-003oJO-Vd@gemulon.postgresql.org> (raw)

Preserve CurrentMemoryContext across notify and sinval interrupts.

ProcessIncomingNotify is called from the main processing loop that
normally runs in MessageContext.  That outer-loop code assumes that
whatever it allocates will be cleaned up when we're done processing
the current client message --- but if we service a notify interrupt,
then whatever gets allocated before the next switch into
MessageContext will be permanently leaked in TopMemoryContext,
because CommitTransactionCommand sets CurrentMemoryContext to
TopMemoryContext.  There are observable leaks associated with
(at least) encoding conversion of incoming queries and parameters
attached to Bind messages.

sinval catchup interrupts have a similar problem.  There might be
others, but I've not identified any other clear cases.

To fix, take care to save and restore CurrentMemoryContext across
the Start/CommitTransactionCommand calls in these functions.

Per bug #18512 from wizardbrony.  Commit to back branches only;
in HEAD, this was dealt with by the riskier but more thoroughgoing
approach in commit 1afe31f03.

Discussion: https://postgr.es/m/3478884.1718656625@sss.pgh.pa.us

Branch
------
REL_16_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/54a7b21b3a9dc4c8be5f7fec47e435ce5b1772bb

Modified Files
--------------
src/backend/commands/async.c     | 11 ++++++++++-
src/backend/storage/ipc/sinval.c |  7 +++++++
2 files changed, 17 insertions(+), 1 deletion(-)



view thread (7+ messages)  latest in thread

Message-ID: <E1sOJmR-003oJO-Vd@gemulon.postgresql.org>
Permalink:  ../E1sOJmR-003oJO-Vd@gemulon.postgresql.org/
Also on:    postgresql.org/message-id/E1sOJmR-003oJO-Vd@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: tgl@sss.pgh.pa.us, pgsql-committers@lists.postgresql.org
  Subject: Re: pgsql: Preserve CurrentMemoryContext across notify and sinval interrupt
  In-Reply-To: <E1sOJmR-003oJO-Vd@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