public inbox for [email protected]  

help / color / mirror / Atom feed

From: Michael Paquier <[email protected]>
To: Tom Lane <[email protected]>
Cc: [email protected]
Subject: Re: pgsql: Make postgres_fdw's query_cancel test less flaky.
Date: Fri, 7 Mar 2025 16:40:17 +0900
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

Hi Tom,

On Fri, Aug 30, 2024 at 08:47:46PM +0000, Tom Lane wrote:
> Make postgres_fdw's query_cancel test less flaky.
> 
> This test occasionally shows
> 
> +WARNING:  could not get result of cancel request due to timeout
> 
> which appears to be because the cancel request is sometimes unluckily
> sent to the remote session between queries, and then it's ignored.
> 
> 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=drongo&dt=2025-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 ft1 d;
 ERROR:  canceling statement due to statement timeout
+WARNING:  could not send cancel request: cancel request timed out
 COMMIT;
--
Michael


Attachments:

  [application/pgp-signature] signature.asc (833B, 2-signature.asc)
  download

view thread (3+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: pgsql: Make postgres_fdw's query_cancel test less flaky.
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox