public inbox for [email protected]  

help / color / mirror / Atom feed

From: Dominique Devienne <[email protected]>
To: [email protected]
Subject: Unexpected Backend PID reported by Notification
Date: Tue, 11 Jun 2024 17:05:57 +0200
Message-ID: <CAFCRh-8cwTFBeTS2_7n97e5C42i-pTVw5o+vyqnwxesQFLbp_A@mail.gmail.com> (raw)

Hi. I have a unit test using a single connection, that simulates a
client interacting with a server via a PostgreSQL "queue", i.e. a
non-writable table with SECURITY DEFINER procedures to mediate writes
to that table, with those PROC-initiated updates triggering
pg_notify() messages (via an UPDATE trigger).

The test is passing, I get all the side-effects and notifications I
expect. BUT...
For some reason, the backend_pid reported on the notification object
itself (i.e. PGnotify::be_pid),
is different from the one reported for the (sole) connection the unit
test is using (PQbackendPID()).

How can that be?
Are Stored PROCs running in a different backend?
Are Triggers running in a different backend?

Any doc pointers to explain this behavior?

Thanks. --DD

PS: v14 server on RedHat; v16 libpq on Windows
PPS: Below's a snippet of my test code, which shows actual PID values:

    auto perreq_notif = c.notification();
    BOOST_REQUIRE(perreq_notif);
    BOOST_CHECK_EQUAL(perreq_notif.channel(), req.channel());
    /*
    ** In fact I get perreq_notif.backend_pid() == N + c.backend_pid() !!!
    ** Is the fact the pg_notify() is done from a trigger the reason???
    ** e.g. [4053957 != 4053955]
    BOOST_CHECK_EQUAL(perreq_notif.backend_pid(), c.backend_pid());
    */
    BOOST_CHECK_EQUAL(perreq_notif.payload(), "...");

view thread (3+ messages)  latest in thread

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: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Unexpected Backend PID reported by Notification
  In-Reply-To: <CAFCRh-8cwTFBeTS2_7n97e5C42i-pTVw5o+vyqnwxesQFLbp_A@mail.gmail.com>

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

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