Request a Demo
Home   >   mailing lists

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

From Nikhil Shetty
Subject Startup process stuck on WAL replay
Date
Msg-id CAFpL5Vwm75OSfexSJk4QRAY5KadfGAWtMEgL2kHShMhKsLobKg@mail.gmail.com
Whole thread Raw
Responses Re: Startup process stuck on WAL replay
List pgsql-admin
Tree view
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: Laurenz Albe
Date:
Subject: Re: Postgres Load Profile
Next
From: Sam Stearns
Date:
Subject: Re: Postgres Load Profile