Request a Demo
Home   >   mailing lists

Re: Startup process stuck on WAL replay - Mailing list pgsql-admin

From Fabrice Chapuis
Subject Re: Startup process stuck on WAL replay
Date
Msg-id CAA5-nLCpxE8Sr-FDq0bk2MO1PgTbrsy3KusP912Vw4TOncSUfw@mail.gmail.com
Whole thread Raw
In response to Startup process stuck on WAL replay  (Nikhil Shetty <nikhil.dba04@gmail.com>)
List pgsql-admin
Tree view
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 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 




pgsql-admin by date:

Previous
From: Sam Stearns
Date:
Subject: Re: Postgres Load Profile
Next
From: lejeczek
Date:
Subject: could not find a valid record after in barman's backups