MIME-Version: 1.0
References: 
 <CAFpL5Vwm75OSfexSJk4QRAY5KadfGAWtMEgL2kHShMhKsLobKg@mail.gmail.com>
In-Reply-To: 
 <CAFpL5Vwm75OSfexSJk4QRAY5KadfGAWtMEgL2kHShMhKsLobKg@mail.gmail.com>
From: Fabrice Chapuis <fabrice636861@gmail.com>
Date: Wed, 5 Nov 2025 10:19:50 +0100
Message-ID: 
 <CAA5-nLCpxE8Sr-FDq0bk2MO1PgTbrsy3KusP912Vw4TOncSUfw@mail.gmail.com>
Subject: Re: Startup process stuck on WAL replay
To: Nikhil Shetty <nikhil.dba04@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000fbcdf30642d57360"
Archived-At: 
 <https://www.postgresql.org/message-id/CAA5-nLCpxE8Sr-FDq0bk2MO1PgTbrsy3KusP912Vw4TOncSUfw%40mail.gmail.com>
Precedence: bulk

--000000000000fbcdf30642d57360
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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 =3D 'startup';

Regards,

Fabrice

On Tue, Nov 4, 2025 at 5:43=E2=80=AFPM Nikhil Shetty <nikhil.dba04@gmail.co=
m> 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 helpf=
ul
>
> Thanks,
> Nikhil
>
>
>
>
>

--000000000000fbcdf30642d57360
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">Hi Nikhil,<div><br></div><div>Did you try=
 to use this query to see if kind of wait event exists?</div><div><br></div=
><div><div>SELECT pid, usename, wait_event_type, wait_event, query</div><di=
v>FROM pg_stat_activity</div><div>WHERE backend_type =3D &#39;startup&#39;;=
</div></div><div><br></div><div>Regards,</div><div><br></div><div>Fabrice</=
div></div></div><br><div class=3D"gmail_quote gmail_quote_container"><div d=
ir=3D"ltr" class=3D"gmail_attr">On Tue, Nov 4, 2025 at 5:43=E2=80=AFPM Nikh=
il Shetty &lt;<a href=3D"mailto:nikhil.dba04@gmail.com">nikhil.dba04@gmail.=
com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"marg=
in:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1e=
x"><div>Hi All,<div dir=3D"auto"><br></div><div dir=3D"auto">The startup pr=
ocess on a replica is stuck on a WAL for a long time=C2=A0</div><div dir=3D=
"auto">LSN - F46/FB4FCF88</div><div dir=3D"auto"><br></div><div dir=3D"auto=
">We verified=C2=A0this from pg_stat_replication output</div><div dir=3D"au=
to"><br></div><div dir=3D"auto">We did a WAL dump to see the xact for this =
LSN and it shows as below</div><div dir=3D"auto"><br></div><div dir=3D"auto=
"><div>
<div>
<p>rmgr: Heap2 =C2=A0 =C2=A0 =C2=A0 len (rec/tot): =C2=A0 =C2=A0 56/=C2=A0 =
=C2=A0 56, tx:=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 0, lsn: F46/FB4FCF88, prev=
 F46/FB4FCF40, desc: PRUNE latestRemovedXid 884637333 nredirected 0 ndead 1=
, blkref #0: rel 1663/16402/72663 blk 0</p>
</div>
</div>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 helpfu=
l=C2=A0</div><div dir=3D"auto"><br></div><div dir=3D"auto">Thanks,</div><di=
v dir=3D"auto">Nikhil=C2=A0</div><div dir=3D"auto"><br></div><div dir=3D"au=
to"><br></div><div dir=3D"auto"><br></div><div dir=3D"auto"><br></div>
</div>
</blockquote></div>

--000000000000fbcdf30642d57360--