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