Re: Startup process stuck on WAL replay
| От | Fabrice Chapuis |
|---|---|
| Тема | Re: Startup process stuck on WAL replay |
| Дата | |
| Msg-id | CAA5-nLCpxE8Sr-FDq0bk2MO1PgTbrsy3KusP912Vw4TOncSUfw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Startup process stuck on WAL replay (Nikhil Shetty <nikhil.dba04@gmail.com>) |
| Список | pgsql-admin |
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
В списке pgsql-admin по дате отправления: