Feedback-ID: i0fe9450f:Fastmail
Date: Tue, 3 Jun 2025 15:13:59 +0900
From: Michael Paquier <michael@paquier.xyz>
To: Dilip Kumar <dilipbalaut@gmail.com>
Cc: lucasmarola@hotmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18945: Standby synchronization problem
Message-ID: <aD6SpzOI765YM9E8@paquier.xyz>
References: <18945-2d88edf94ef23a74@postgresql.org>
 <CAFiTN-u0kuSwypDDChK4Po+4hAtm8HO94EoNCtDwPvBGw7R3Tg@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="OKrnpESzEMZ3+Byu"
Content-Disposition: inline
In-Reply-To: 
 <CAFiTN-u0kuSwypDDChK4Po+4hAtm8HO94EoNCtDwPvBGw7R3Tg@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/aD6SpzOI765YM9E8%40paquier.xyz>
Precedence: bulk


--OKrnpESzEMZ3+Byu
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

On Mon, Jun 02, 2025 at 06:42:08PM +0530, Dilip Kumar wrote:
> it's difficult to pinpoint the exact problem with the information
> provided. However, a common scenario involves read-only queries on a
> standby database conflicting with the WAL apply process.  And as a
> result of restarting the application it will terminate all the backend
> so you are not facing issues of conflict any more.  You can check the
> value of 'max_standby_streaming_delay' as this will control how long
> the WAL apply process should wait in case of a conflict with the
> snapshot of the local queries.

Indeed, there could be a lot going on.

A sequence of commands to pinpoint an issue, with a precise
description of what has been done, would help.  Their may be some
tools you are using, that help in the reproducibility.  If you are
seeing a process being stuck, attaching gdb to the process that
matters, be it a WAL sender or the startup process, or something else,
can also provide useful hints that could help in determining if you
have hit an actual bug or not.  Log contents could provide useful
hints, just be sure to trim any sensitive contents they may include
before posting or attaching anything here.

Three lines to describe your problem is not enough for one to
potentially understand what's going on in your system.

> If you have steps to reproduce/or more
> details on the exact scenario, then that would be helpful.

Right.
--
Michael

--OKrnpESzEMZ3+Byu
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmg+kqcACgkQnvQgOdby
QH1LcA//ZgEwOdfR/ckcARqA+0VIUx7wtFYuZfJp43UaUAtCB//N7o9cYrES9K18
NDqpTn1OTd1mwOBkSvs8Rp8w00BvnCWBCA10APl9kE9tFAfpSXooqTHxCXj477PQ
ftxDeMC2GY04YOp+YOZW+nsR9mANbfmk0gntfOBMeYOkrVJvTgslWO/L3h/Zow6D
M3l+U0PtbU60WPf9HpX3RVGrCu1/pL9TzVGHOMVDMdxKIFgsjFqtKM5EfkUmVYx+
89vto4ha2WKyJXp2vMKVE1gsE7AaBdDf/k5WHeGVjqhLY32Ynj5mNv4JfLIdFBmm
cPwfQsEKaYyC83HQdIGeqUyL9/yNfjbl3988uGTA1L+JL/+TArvgy2qDc0YCB+3y
RCKhstnAF0i5MtXaJ8urzuL9yA3GcJYVbqtI6ku2moH9wMCbBYakgd+DmEW4uJPu
VsgwamX7pmpf4g6lSV3qUA+zDxzl6ofm5Io5SmvwIbpf4dnkULDYAQVhXF+Od44F
24h/bqsjF+z2zMenftYtBzNcVJZmqPjv7kdy4ZGaaGqkOwUAc31q5Tm3TvuQVfSy
fFO5SD7RbcJtcRhfCU5ls+cUbdtmLZigg/8x0O+9Y8LtLdtHQhNIxWdcDuujXdox
V7kuHM6KVsHZt0G1J2Arbxqevurf24PfawWEtLoSRo9NwY6llWU=
=+XY7
-----END PGP SIGNATURE-----

--OKrnpESzEMZ3+Byu--