Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tCVWK-004K1A-Is for pgsql-hackers@arkaria.postgresql.org; Sun, 17 Nov 2024 03:00:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tCVWG-00GUjH-PZ for pgsql-hackers@arkaria.postgresql.org; Sun, 17 Nov 2024 03:00:13 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tCVWG-00GUj9-Ca for pgsql-hackers@lists.postgresql.org; Sun, 17 Nov 2024 03:00:13 +0000 Received: from mail-lf1-x130.google.com ([2a00:1450:4864:20::130]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tCVW9-002Lw0-3v for pgsql-hackers@lists.postgresql.org; Sun, 17 Nov 2024 03:00:12 +0000 Received: by mail-lf1-x130.google.com with SMTP id 2adb3069b0e04-53da24e9673so3396048e87.2 for ; Sat, 16 Nov 2024 19:00:05 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1731812404; x=1732417204; darn=lists.postgresql.org; h=content-transfer-encoding:in-reply-to:from:references:cc:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=Y8idFstcWGWf6UH2xvZG21YqTiwWREzDAfpO9wYsZEI=; b=hRrvO0VCD9Jwxw6Ic20aYerWyn/WVThR+kgRbrAkvVaQObvXufsBWMMWjcXFcaSdKC kbY8vvkiRIsBCfRjA5VwidsvlcvsWd3gwLsSkR1pUo27sZiXT1cGawJ0s/3HJJbmuJh3 vvLBJBq4dkDro17H57tfT/okOWHSSF7BDG1l83GR/2dVEDkxIVHsF7A4olNNrpc1sMLc ubVe6uWFq3K/UlQFGUYTlOBl3TJoPBVcUdB6RZ2an/fbMK9tUcTfO63wh/gEP9HkkF1y AFJ/n0vrwX7uMy/Vzr5t2cadBrj7RNkZW06VlTAV+GnCBEqqLredINuC4Gw0g5F4gRlJ AoAA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1731812404; x=1732417204; h=content-transfer-encoding:in-reply-to:from:references:cc:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=Y8idFstcWGWf6UH2xvZG21YqTiwWREzDAfpO9wYsZEI=; b=sDFd8NFlwxkDXiGG07+ES3UPoWIQgrXn9ZJM4xYFofAA/1Y43AjiG/1EE+bW+pqc4a KOu+eJwOXe0RxolYoDdVE9CBq7yaeOrwKpsWciBy5qLSjDYLZ5fd+HfaxuiLjgrHTtJU rlaHXGw8InZGY0m/tj9umGa9cc/uRq0j6f3os8OxKkRhvx1iYN2uDSmuE0A1K4eR9bcS txIm2ShgBtmolsRu1/2KmSQyqBTMp7EWHp+d/ZOrN8hh4wmqTWd2z/2FrSFiuWHX2Gdn /L1ae+7J1nycwM9xjBI5ioqcWAp45h1hLIhOlFlWJ4cLyToG+R+fVii7tSHPT0ENx12X tLFw== X-Forwarded-Encrypted: i=1; AJvYcCULRiYsvYAt7IwWeKU06WrLrjju/lLp6o1EmwtMahKUnl6YmzoyXp/4r98lrhRqAiXiUO8Vn5aYYh5D1rHe@lists.postgresql.org X-Gm-Message-State: AOJu0YxhyoRlbbz6zWnaRzcuv7m15qX02cOVuS43fbRrfL5zywZ4gPqi MNWcY+incC9Q63bUe1jYuciQDOSUDXZs2L/BixlsOhbnXzgTlpvj X-Google-Smtp-Source: AGHT+IHN4LNrabaje2LlH2bsEslA7phFRLMU/1CI7TNf9blIfJsSEnA4+snXAZAg+n1RWLuuRPpnjQ== X-Received: by 2002:ac2:4c4f:0:b0:539:fb6f:cb8d with SMTP id 2adb3069b0e04-53dab2a2e4amr2903458e87.27.1731812403847; Sat, 16 Nov 2024 19:00:03 -0800 (PST) Received: from [1.0.0.7] ([178.155.28.152]) by smtp.gmail.com with ESMTPSA id 2adb3069b0e04-53da6548aaasm1125434e87.244.2024.11.16.19.00.01 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sat, 16 Nov 2024 19:00:03 -0800 (PST) Message-ID: <8f280cbd-8450-87ea-f0f7-ab4932af5750@gmail.com> Date: Sun, 17 Nov 2024 06:00:01 +0300 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.4.2 Subject: Re: [EXTERNAL] Re: Add non-blocking version of PQcancel Content-Language: en-US To: Tom Lane , Andres Freund Cc: Jelte Fennema-Nio , Alvaro Herrera , Noah Misch , Jacob Champion , Denis Laxalde , vignesh C , Thomas Munro , Greg Stark , "Gregory Stark (as CFM)" , Daniel Gustafsson , Peter Eisentraut , Justin Pryzby , Robert Haas , PostgreSQL Hackers , Etsuro Fujita References: <202407221126.vyw5q3h4nyoh@alvherre.pgsql> <5ea25e4d-1ee2-b9bf-7806-119ffa658826@gmail.com> <578934.1725045685@sss.pgh.pa.us> <584811.1725048717@sss.pgh.pa.us> <591893.1725051309@sss.pgh.pa.us> <37c3bd11-7321-fe58-99ca-bc15a67c08cc@gmail.com> <2947163.1731810791@sss.pgh.pa.us> From: Alexander Lakhin In-Reply-To: <2947163.1731810791@sss.pgh.pa.us> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hello Tom and Andres, 17.11.2024 05:33, Tom Lane wrote: > Andres Freund writes: > >> Another failure in CI, that cleared up after a retry: >> +WARNING: could not get result of cancel request due to timeout > Yeah. This has been happening off-and-on in the buildfarm ever > since we added that test. I'm not sure if it's just "the test > is unstable" or if it's telling us there's a problem with the > cancel logic. Scraping the last 3 months worth of buildfarm > logs finds these instances: Yes, I counted those bf failures at [1] too and posted my explanation upthread [2]. [1] https://wiki.postgresql.org/wiki/Known_Buildfarm_Test_Failures#posgtres_fdw.2Fquery_cancel_fails_due_to_an_unexpected_warning_on_canceling_a_statement [2] https://www.postgresql.org/message-id/c68225b4-fce9-3425-1534-a21a815d5846@gmail.com Best regards, Alexander