Обсуждение: Startup process stuck on WAL replay
Hi All,
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
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
Thanks,
Nikhil
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 <nikhil.dba04@gmail.com> wrote:
Hi All,The startup process on a replica is stuck on a WAL for a long timeLSN - F46/FB4FCF88We verified this from pg_stat_replication outputWe did a WAL dump to see the xact for this LSN and it shows as belowWould 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 helpfulrmgr: 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
Thanks,Nikhil