public inbox for [email protected]  

help / color / mirror / Atom feed

From: Fabrice Chapuis <[email protected]>
To: Nikhil Shetty <[email protected]>
Cc: Pgsql-admin <[email protected]>
Subject: Re: Startup process stuck on WAL replay
Date: Wed, 5 Nov 2025 10:19:50 +0100
Message-ID: <CAA5-nLCpxE8Sr-FDq0bk2MO1PgTbrsy3KusP912Vw4TOncSUfw@mail.gmail.com> (raw)
In-Reply-To: <CAFpL5Vwm75OSfexSJk4QRAY5KadfGAWtMEgL2kHShMhKsLobKg@mail.gmail.com>
References: <CAFpL5Vwm75OSfexSJk4QRAY5KadfGAWtMEgL2kHShMhKsLobKg@mail.gmail.com>

Hi Nikhil,

Did you try to use this query to see if kind of wait event exists?

SELECT pid, usename, wait_event_type, wait_event, query
FROM pg_stat_activity
WHERE backend_type = 'startup';

Regards,

Fabrice

On Tue, Nov 4, 2025 at 5:43 PM Nikhil Shetty <[email protected]> wrote:

> Hi All,
>
> The startup process on a replica is stuck on a WAL for a long time
> LSN - F46/FB4FCF88
>
> We verified this from pg_stat_replication output
>
> We did a WAL dump to see the xact for this LSN and it shows as below
>
> rmgr: Heap2       len (rec/tot):     56/    56, tx:          0, lsn:
> F46/FB4FCF88, prev F46/FB4FCF40, desc: PRUNE latestRemovedXid 884637333
> nredirected 0 ndead 1, blkref #0: rel 1663/16402/72663 blk 0
> Would such a xact cause WAL replay to get stuck ? Or is it some other
> issue? Is there any way to check where it is stuck , strace was not helpful
>
> Thanks,
> Nikhil
>
>
>
>
>

view thread (2+ messages)

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]
  Subject: Re: Startup process stuck on WAL replay
  In-Reply-To: <CAA5-nLCpxE8Sr-FDq0bk2MO1PgTbrsy3KusP912Vw4TOncSUfw@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