public inbox for [email protected]
help / color / mirror / Atom feedFrom: Jeremy Schneider <[email protected]>
To: Anthonin Bonnefoy <[email protected]>
Cc: Jakub Wartak <[email protected]>
Cc: Srinath Reddy Sadipiralla <[email protected]>
Cc: PostgreSQL mailing lists <[email protected]>
Subject: Re: hang during shutdown
Date: Thu, 9 Jul 2026 22:19:55 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAO6_XqrUbM+FNMHGksmezKNPftwD41EwW6Li=iqfzr-GmcF+fg@mail.gmail.com>
References: <CA+fnDAa8Kbbx3KkqpfxutTx41RchJsT3Lykqwcedm0CVr5Tw=A@mail.gmail.com>
<CAFC+b6pQXYMks5f4XJ-QX4QpxnYnrNz9Zrkg8EiJ5-O+PxKxBQ@mail.gmail.com>
<CAO6_Xqpzj_V1gF0ikPCVkA3Q2K5YqRnAdHiV5TqpLNAZsdwWbQ@mail.gmail.com>
<CAKZiRmxxD5y2hArj3p4Ueq2jvQoTUsUr7tjeK44OnSqxAD1ZmA@mail.gmail.com>
<[email protected]>
<CAO6_XqrUbM+FNMHGksmezKNPftwD41EwW6Li=iqfzr-GmcF+fg@mail.gmail.com>
On Thu, 9 Jul 2026 09:09:25 +0200
Anthonin Bonnefoy <[email protected]> wrote:
> As you didn't have a shutdown checkpoint, the symptoms look very
> similar (though you didn't confirm whether you were using logical
> replication, so I'm gonna assume you do).
No logical replication. Are we sure this only impacts logical and not
physical? Thanks for the pointer - interesting one.
We do use physical replication. Replicas were shut down and they closed
their connections to this writer instance around 04:25 just before
pg_ctl stop was executed on the writer itself.
Something was on the writer DB's CPU before shutdown; metrics show total
CPU for that linux namespace (k8s pod) around 0.86 cores until 04:24 and
then the CPU starts dropping when the database shuts down. Bu 04:28 the
CPU is under 0.01 cores and the CPU remains effectively zero until the
processes are SIGKILL'd 30 minutes later.
-Jeremy
--
To know the thoughts and deeds that have marked man's progress is to
feel the great heart throbs of humanity through the centuries; and if
one does not feel in these pulsations a heavenward striving, one must
indeed be deaf to the harmonies of life.
Helen Keller, The Story Of My Life, 1902, 1903, 1905, introduction by
Ralph Barton Perry (Garden City, NY: Doubleday & Company, 1954), p90.
view thread (5+ 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], [email protected], [email protected]
Subject: Re: hang during shutdown
In-Reply-To: <[email protected]>
* 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