MIME-Version: 1.0
From: Nikhil Shetty <nikhil.dba04@gmail.com>
Date: Tue, 4 Nov 2025 22:12:38 +0530
Message-ID: 
 <CAFpL5Vwm75OSfexSJk4QRAY5KadfGAWtMEgL2kHShMhKsLobKg@mail.gmail.com>
Subject: Startup process stuck on WAL replay
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000c6f88a0642c785ad"
Archived-At: 
 <https://www.postgresql.org/message-id/CAFpL5Vwm75OSfexSJk4QRAY5KadfGAWtMEgL2kHShMhKsLobKg%40mail.gmail.com>
Precedence: bulk

--000000000000c6f88a0642c785ad
Content-Type: text/plain; charset="UTF-8"

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

--000000000000c6f88a0642c785ad
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div>Hi All,<div dir=3D"auto"><br></div><div dir=3D"auto">The startup proce=
ss on a replica is stuck on a WAL for a long time=C2=A0</div><div dir=3D"au=
to">LSN - F46/FB4FCF88</div><div dir=3D"auto"><br></div><div dir=3D"auto">W=
e verified=C2=A0this from pg_stat_replication output</div><div dir=3D"auto"=
><br></div><div dir=3D"auto">We did a WAL dump to see the xact for this LSN=
 and it shows as below</div><div dir=3D"auto"><br></div><div dir=3D"auto"><=
div>
<div>
<p>rmgr: Heap2 =C2=A0 =C2=A0 =C2=A0 len (rec/tot): =C2=A0 =C2=A0 56/=C2=A0 =
=C2=A0 56, tx:=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 0, lsn: F46/FB4FCF88, prev=
 F46/FB4FCF40, desc: PRUNE latestRemovedXid 884637333 nredirected 0 ndead 1=
, blkref #0: rel 1663/16402/72663 blk 0</p>
</div>
</div>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 helpfu=
l=C2=A0</div><div dir=3D"auto"><br></div><div dir=3D"auto">Thanks,</div><di=
v dir=3D"auto">Nikhil=C2=A0</div><div dir=3D"auto"><br></div><div dir=3D"au=
to"><br></div><div dir=3D"auto"><br></div><div dir=3D"auto"><br></div>
</div>

--000000000000c6f88a0642c785ad--