Startup process stuck on WAL replay

From: Nikhil Shetty <nikhil(dot)dba04(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Startup process stuck on WAL replay
Date: 2025-11-04 16:42:38
Message-ID: CAFpL5Vwm75OSfexSJk4QRAY5KadfGAWtMEgL2kHShMhKsLobKg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Sam Stearns 2025-11-04 17:39:04 Re: Postgres Load Profile
Previous Message Laurenz Albe 2025-11-04 05:25:35 Re: Postgres Load Profile