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-003oJR-W8@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_15_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/4df767cf906d4406306f5853fea0e8133803c0f1

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)

Message-ID: <E1sOJmR-003oJR-W8@gemulon.postgresql.org>
Permalink:  ../E1sOJmR-003oJR-W8@gemulon.postgresql.org/
Also on:    postgresql.org/message-id/E1sOJmR-003oJR-W8@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-003oJR-W8@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