Feedback-ID: i0fe9450f:Fastmail
Date: Fri, 7 Mar 2025 16:40:17 +0900
From: Michael Paquier <michael@paquier.xyz>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-committers@lists.postgresql.org
Subject: Re: pgsql: Make postgres_fdw's query_cancel test less flaky.
Message-ID: <Z8qi4VASbb9aT4MA@paquier.xyz>
References: <E1sk8X3-002Ai0-WC@gemulon.postgresql.org>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha256;
	protocol="application/pgp-signature"; boundary="XmnOgcY9uIqLaL6b"
Content-Disposition: inline
In-Reply-To: <E1sk8X3-002Ai0-WC@gemulon.postgresql.org>
Archived-At: 
 <https://www.postgresql.org/message-id/Z8qi4VASbb9aT4MA%40paquier.xyz>
Precedence: bulk


--XmnOgcY9uIqLaL6b
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

Hi Tom,

On Fri, Aug 30, 2024 at 08:47:46PM +0000, Tom Lane wrote:
> Make postgres_fdw's query_cancel test less flaky.
>=20
> This test occasionally shows
>=20
> +WARNING:  could not get result of cancel request due to timeout
>=20
> which appears to be because the cancel request is sometimes unluckily
> sent to the remote session between queries, and then it's ignored.
>=20
> Back-patch to v17 where this test was introduced.

Based on this recent report from the buildfarm, there is still
something happening here:
https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=3Ddrongo&dt=3D2025-=
03-07%2004%3A31%3A37

In details:
 -- This would take very long if not canceled:
 SELECT count(*) FROM ft1 a CROSS JOIN ft1 b CROSS JOIN ft1 c CROSS JOIN ft=
1 d;
 ERROR:  canceling statement due to statement timeout
+WARNING:  could not send cancel request: cancel request timed out
 COMMIT;
--
Michael

--XmnOgcY9uIqLaL6b
Content-Type: application/pgp-signature; name="signature.asc"

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

iQIzBAEBCAAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmfKouEACgkQnvQgOdby
QH0YXQ//beomQqqv7qP0sHx4iOzbNis+yQF9l6A7orAinMIBtBfAFks8bOnqB3hW
y9ZeQ5CZvMuXjRR40HQfY7oNhh7g2FrKPEZ04z5T/jRR2Jz+AqFB3riN7cJe3WHU
5SEtS79eUIshwotfAiSJ+pi8j1AjYhaEUmVJWGlUniLT7Jj93BAqJkzlqe/7bXag
x4V30aHJ04/CuO1WpaKw+YpIfXNM0QDJ2/CO4faMqptddw0sWjEGsVjBwdmCNdAW
eEU8GaFf5hrVO2EZSms2OeXutVik1eCeyHDJDOskZCeeneAd3Lawsp6kDcyuo78v
iqFFTmI9nVLQO4Zno3M3bNwj+FXpIXcMJk8RSpy4GUvQ0h4rPmYH1V6SI6lwIcSD
KmBQSn427YuFvFY799i6mVmc40REoomvqzex86h+th0731bgw1/h/FbqFbHCgEhs
vxhCCz466hL0QLVWBlqLZHO8f0nD01QHDmuVGAsxNr6vOhTMaNoRHoXIBaDTN23i
fi+I4ptP+wjUqmdC4RqrIdhO9c23mZjtXs50HTfRc7FK1c8kKVlqLKZ/S5VhDGDn
e6oEekFJBQPST4AB152Zpk6MlyKjO8tVZINXt1AA2Zi9W+RSwwmLXbzgozPQcl5a
hLGT4sd/utc1aFeN0vu8eqM1XT/Huldb8uup9hdWcYnp1Ddt534=
=czk6
-----END PGP SIGNATURE-----

--XmnOgcY9uIqLaL6b--