public inbox for [email protected]  

help / color / mirror / Atom feed

Startup process stuck on WAL replay
2+ messages / 2 participants
[nested] [flat]

* Startup process stuck on WAL replay
@ 2025-11-04 16:42 Nikhil Shetty <[email protected]>
  2025-11-05 09:19 ` Re: Startup process stuck on WAL replay Fabrice Chapuis <[email protected]>
  0 siblings, 1 reply; 2+ messages in thread

From: Nikhil Shetty @ 2025-11-04 16:42 UTC (permalink / raw)
  To: Pgsql-admin <[email protected]>

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


^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Startup process stuck on WAL replay
  2025-11-04 16:42 Startup process stuck on WAL replay Nikhil Shetty <[email protected]>
@ 2025-11-05 09:19 ` Fabrice Chapuis <[email protected]>
  0 siblings, 0 replies; 2+ messages in thread

From: Fabrice Chapuis @ 2025-11-05 09:19 UTC (permalink / raw)
  To: Nikhil Shetty <[email protected]>; +Cc: Pgsql-admin <[email protected]>

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 <[email protected]> wrote:

> 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
>
>
>
>
>


^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2025-11-05 09:19 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-11-04 16:42 Startup process stuck on WAL replay Nikhil Shetty <[email protected]>
2025-11-05 09:19 ` Fabrice Chapuis <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox