public inbox for [email protected]  

help / color / mirror / Atom feed

From: Nikhil Shetty <[email protected]>
To: Pgsql-admin <[email protected]>
Subject: Startup process stuck on WAL replay
Date: Tue, 4 Nov 2025 22:12:38 +0530
Message-ID: <CAFpL5Vwm75OSfexSJk4QRAY5KadfGAWtMEgL2kHShMhKsLobKg@mail.gmail.com> (raw)

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)  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: Startup process stuck on WAL replay
  In-Reply-To: <CAFpL5Vwm75OSfexSJk4QRAY5KadfGAWtMEgL2kHShMhKsLobKg@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