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 1sLyHq-00HYoF-95 for pgsql-hackers@arkaria.postgresql.org; Tue, 25 Jun 2024 05:00:10 +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 1sLyHo-00Dug9-9Q for pgsql-hackers@arkaria.postgresql.org; Tue, 25 Jun 2024 05:00:08 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sLyHn-00Dufs-Ru for pgsql-hackers@lists.postgresql.org; Tue, 25 Jun 2024 05:00:08 +0000 Received: from mail-lj1-x235.google.com ([2a00:1450:4864:20::235]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sLyHl-00303B-Bm for pgsql-hackers@lists.postgresql.org; Tue, 25 Jun 2024 05:00:06 +0000 Received: by mail-lj1-x235.google.com with SMTP id 38308e7fff4ca-2ec52fbb50bso29950651fa.2 for ; Mon, 24 Jun 2024 22:00:05 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1719291604; x=1719896404; darn=lists.postgresql.org; h=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=/KX/uObr92I0u9k1c1y1m1hd+vyqgOLuwFQXmGdqzMI=; b=FQeB69b+fvEpMFKL3zZ9bj3F+NOz8E8qKSX0MZwd/QF2Ld2hgMNCSWTjetPAA8dVYy B2ZHjbgTXX0FlPaH/WjUOnh3Mo0eFEK3uGMsNTil94utw9z8Kylhet57py2dtiEjm+2Z ZDqBnAXlceE5BkqqGpDECd9TrnhAcvgTE+penkvYvtZo1waMQdZEQMRUmSA6FnsFsL7M OOa5na21Y2ggLpNBGFTUG1u1C37RdPARxbS5Qdy9Ei4fVWEX+YKXfhiQYvRosy21+MGH Ue4Z1kgXz8a2OjjkV2THMqoFBK08DTQj+60q6aOJWCm9WifmoFGkF7hwhmWThJyi6xai EWpA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1719291604; x=1719896404; h=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=/KX/uObr92I0u9k1c1y1m1hd+vyqgOLuwFQXmGdqzMI=; b=bsLw5E9G+MixjOZI91ukX+HapCW9+Nn7uaKx4zguHkR79QQARGV6fNiUpZV/pzfQR8 Y5byUQ8annNzRGk0BNC6e9wFXWErbMgV16sAkKIhnwQ3ZobqWvR4CCXmkr8K1NcEN91t ZO/iMy6/InxM3+pdyewJKsMfBpmPD1rUqB82tZRAhD87LWuKt6L5OlXW3qMM7uCxj0Vi IdeUIGOVsZSE07IGH9S/ndcrlFm0oBs8LcMcyrKHE9WrclXXJ21GJHxRFlMX+zevkIHc tILPoWTFeoT/QiAXg7AjQRmo5wlj6HtjxE7ia2XM1g6Gkdu4gpiesYs2O17RH1oByqJ/ d2Mw== X-Forwarded-Encrypted: i=1; AJvYcCWn6KvlG2OiqbT51uhi1r15Gcyb87g1sD5H1gTSiupGFLkuSQQvq/c45OIyWXGxB1e12U8jUxl5N1E+cqz/pnwRdmOVnKobHvLpTdwfEx65cWD5 X-Gm-Message-State: AOJu0Yxd24Tb9PaQAyJPIs5nT1uU43JTz9S9+r9HLzfS9aSLasN0lVo1 4rQPS6/4PIsSEUPEnE5aKS2hShWaBD3zbapRjOXtx8DZtemkA2jn X-Google-Smtp-Source: AGHT+IFDFhEvHOUKSA8PeGUqt5Z9+IdygQ8iQ3VlonU0PStqoTSASD6n/P7X2N/uAUiS8Jgd6LPi0A== X-Received: by 2002:a05:651c:220e:b0:2ec:5e2e:39a8 with SMTP id 38308e7fff4ca-2ec5e2e3aaamr40224061fa.3.1719291603264; Mon, 24 Jun 2024 22:00:03 -0700 (PDT) Received: from [1.0.0.7] ([81.23.167.104]) by smtp.gmail.com with ESMTPSA id 38308e7fff4ca-2ec616e454dsm4261781fa.82.2024.06.24.22.00.01 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 24 Jun 2024 22:00:02 -0700 (PDT) Content-Type: multipart/mixed; boundary="------------tm3L6fw2x8sndptJRVXm2qYz" Message-ID: Date: Tue, 25 Jun 2024 08:00:00 +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: Jelte Fennema-Nio Cc: Noah Misch , Alvaro Herrera , Tom Lane , Jacob Champion , Denis Laxalde , vignesh C , Thomas Munro , Greg Stark , "Gregory Stark (as CFM)" , Jelte Fennema , Daniel Gustafsson , Peter Eisentraut , Andres Freund , Justin Pryzby , Robert Haas , pgsql-hackers@lists.postgresql.org, Etsuro Fujita References: <202403281753.ku5k2jvaw5fo@alvherre.pgsql> <3643677.1711648979@sss.pgh.pa.us> <20240329221724.03@rfd.leadboat.com> <4db099c8-4a52-3cc4-e970-14539a319466@gmail.com> From: Alexander Lakhin In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------tm3L6fw2x8sndptJRVXm2qYz Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit 24.06.2024 01:59, Jelte Fennema-Nio wrote: > On Sat, 22 Jun 2024 at 17:00, Alexander Lakhin wrote: >> @@ -2775,6 +2775,7 @@ >> SET LOCAL statement_timeout = '10ms'; >> select count(*) from ft1 CROSS JOIN ft2 CROSS JOIN ft4 CROSS JOIN ft5; -- this takes very long >> ERROR: canceling statement due to statement timeout >> +WARNING: could not get result of cancel request due to timeout >> COMMIT; > As you describe it, this problem occurs when the cancel request is > processed by the foreign server, before the query is actually > received. And postgres then (rightly) ignores the cancel request. I'm > not sure if the existing test is easily changeable to fix this. The > only thing that I can imagine works in practice is increasing the > statement_timeout, e.g. to 100ms. I'd just like to add that that one original query assumes several "remote" queries (see the attached excerpt from postmaster.log with verbose logging enabled). Best regards, Alexander --------------tm3L6fw2x8sndptJRVXm2qYz Content-Type: text/plain; charset=UTF-8; name="postmaster.log.txt" Content-Disposition: attachment; filename="postmaster.log.txt" Content-Transfer-Encoding: base64 MjAyNC0wNi0yNCAwNzoyNTozMy41MzkgVVRDIFs0Nzk1Nzo0MjZdIHBnX3JlZ3Jlc3MvcG9z dGdyZXNfZmR3IExPRzogIHN0YXRlbWVudDogU0VUIExPQ0FMIHN0YXRlbWVudF90aW1lb3V0 ID0gJzEwbXMnOwoyMDI0LTA2LTI0IDA3OjI1OjMzLjU0MCBVVEMgWzQ3OTU3OjQyN10gcGdf cmVncmVzcy9wb3N0Z3Jlc19mZHcgTE9HOiAgc3RhdGVtZW50OiBzZWxlY3QgY291bnQoKikg ZnJvbSBmdDEgQ1JPU1MgSk9JTiBmdDIgQ1JPU1MgSk9JTiBmdDQgQ1JPU1MgSk9JTiBmdDU7 CjIwMjQtMDYtMjQgMDc6MjU6MzMuNTQxIFVUQyBbNDc5NTc6NDI4XSBwZ19yZWdyZXNzL3Bv c3RncmVzX2ZkdyBERUJVRzogIHN0YXJ0aW5nIHJlbW90ZSB0cmFuc2FjdGlvbiBvbiBjb25u ZWN0aW9uIDB4NTE5MDAwMGYxNDgwCjIwMjQtMDYtMjQgMDc6MjU6MzMuNTQyIFVUQyBbNDgz OTA6MjAzXSBwZ19yZWdyZXNzIExPRzogIHN0YXRlbWVudDogU1RBUlQgVFJBTlNBQ1RJT04g SVNPTEFUSU9OIExFVkVMIFJFUEVBVEFCTEUgUkVBRAoyMDI0LTA2LTI0IDA3OjI1OjMzLjU0 MiBVVEMgWzQ4MzkwOjIwNF0gcGdfcmVncmVzcyBMT0c6ICBzdGF0ZW1lbnQ6IEVYUExBSU4g U0VMRUNUIE5VTEwgRlJPTSAiUyAxIi4iVCAxIgoyMDI0LTA2LTI0IDA3OjI1OjMzLjU0MyBV VEMgWzQ4MzkwOjIwNV0gcGdfcmVncmVzcyBMT0c6ICBzdGF0ZW1lbnQ6IEVYUExBSU4gU0VM RUNUIE5VTEwgRlJPTSAoIlMgMSIuIlQgMSIgcjEgSU5ORVIgSk9JTiAiUyAxIi4iVCAxIiBy MiBPTiAoVFJVRSkpCjIwMjQtMDYtMjQgMDc6MjU6MzMuNTQ0IFVUQyBbNDgzOTA6MjA2XSBw Z19yZWdyZXNzIExPRzogIHN0YXRlbWVudDogRVhQTEFJTiBTRUxFQ1QgTlVMTCBGUk9NICgi UyAxIi4iVCAxIiByMiBJTk5FUiBKT0lOICJTIDEiLiJUIDMiIHI0IE9OIChUUlVFKSkKMjAy NC0wNi0yNCAwNzoyNTozMy41NDUgVVRDIFs0ODM5MDoyMDddIHBnX3JlZ3Jlc3MgTE9HOiAg c3RhdGVtZW50OiBFWFBMQUlOIFNFTEVDVCBOVUxMIEZST00gKCJTIDEiLiJUIDEiIHIyIElO TkVSIEpPSU4gIlMgMSIuIlQgNCIgcjYgT04gKFRSVUUpKQoyMDI0LTA2LTI0IDA3OjI1OjMz LjU0NiBVVEMgWzQ4MzkwOjIwOF0gcGdfcmVncmVzcyBMT0c6ICBzdGF0ZW1lbnQ6IEVYUExB SU4gU0VMRUNUIE5VTEwgRlJPTSAoKCJTIDEiLiJUIDEiIHIxIElOTkVSIEpPSU4gIlMgMSIu IlQgMSIgcjIgT04gKFRSVUUpKSBJTk5FUiBKT0lOICJTIDEiLiJUIDMiIHI0IE9OIChUUlVF KSkKMjAyNC0wNi0yNCAwNzoyNTozMy41NDggVVRDIFs0ODM5MDoyMDldIHBnX3JlZ3Jlc3Mg TE9HOiAgc3RhdGVtZW50OiBFWFBMQUlOIFNFTEVDVCBOVUxMIEZST00gKCgiUyAxIi4iVCAx IiByMSBJTk5FUiBKT0lOICJTIDEiLiJUIDEiIHIyIE9OIChUUlVFKSkgSU5ORVIgSk9JTiAi UyAxIi4iVCA0IiByNiBPTiAoVFJVRSkpCjIwMjQtMDYtMjQgMDc6MjU6MzMuNTQ5IFVUQyBb NDgzOTA6MjEwXSBwZ19yZWdyZXNzIExPRzogIHN0YXRlbWVudDogRVhQTEFJTiBTRUxFQ1Qg TlVMTCBGUk9NICgoIlMgMSIuIlQgMSIgcjIgSU5ORVIgSk9JTiAiUyAxIi4iVCAzIiByNCBP TiAoVFJVRSkpIElOTkVSIEpPSU4gIlMgMSIuIlQgNCIgcjYgT04gKFRSVUUpKQoyMDI0LTA2 LTI0IDA3OjI1OjMzLjU1MCBVVEMgWzQ4MzkwOjIxMV0gcGdfcmVncmVzcyBMT0c6ICBzdGF0 ZW1lbnQ6IEVYUExBSU4gU0VMRUNUIE5VTEwgRlJPTSAoKCgiUyAxIi4iVCAxIiByMSBJTk5F UiBKT0lOICJTIDEiLiJUIDEiIHIyIE9OIChUUlVFKSkgSU5ORVIgSk9JTiAiUyAxIi4iVCAz IiByNCBPTiAoVFJVRSkpIElOTkVSIEpPSU4gIlMgMSIuIlQgNCIgcjYgT04gKFRSVUUpKQoy MDI0LTA2LTI0IDA3OjI1OjMzLjU1MSBVVEMgWzQ4MzkwOjIxMl0gcGdfcmVncmVzcyBMT0c6 ICBzdGF0ZW1lbnQ6IEVYUExBSU4gU0VMRUNUIGNvdW50KCopIEZST00gKCgoIlMgMSIuIlQg MSIgcjEgSU5ORVIgSk9JTiAiUyAxIi4iVCAxIiByMiBPTiAoVFJVRSkpIElOTkVSIEpPSU4g IlMgMSIuIlQgMyIgcjQgT04gKFRSVUUpKSBJTk5FUiBKT0lOICJTIDEiLiJUIDQiIHI2IE9O IChUUlVFKSkKMjAyNC0wNi0yNCAwNzoyNTozMy41NTMgVVRDIFs0ODM5MDoyMTNdIHBnX3Jl Z3Jlc3MgREVCVUc6ICBwYXJzZSA8dW5uYW1lZD46IERFQ0xBUkUgYzEgQ1VSU09SIEZPUgog ICAgICAgIFNFTEVDVCBjb3VudCgqKSBGUk9NICgoKCJTIDEiLiJUIDEiIHIxIElOTkVSIEpP SU4gIlMgMSIuIlQgMSIgcjIgT04gKFRSVUUpKSBJTk5FUiBKT0lOICJTIDEiLiJUIDMiIHI0 IE9OIChUUlVFKSkgSU5ORVIgSk9JTiAiUyAxIi4iVCA0IiByNiBPTiAoVFJVRSkpCjIwMjQt MDYtMjQgMDc6MjU6MzMuNTUzIFVUQyBbNDgzOTA6MjE0XSBwZ19yZWdyZXNzIERFQlVHOiAg YmluZCA8dW5uYW1lZD4gdG8gPHVubmFtZWQ+CjIwMjQtMDYtMjQgMDc6MjU6MzMuNTUzIFVU QyBbNDgzOTA6MjE1XSBwZ19yZWdyZXNzIExPRzogIGV4ZWN1dGUgPHVubmFtZWQ+OiBERUNM QVJFIGMxIENVUlNPUiBGT1IKICAgICAgICBTRUxFQ1QgY291bnQoKikgRlJPTSAoKCgiUyAx Ii4iVCAxIiByMSBJTk5FUiBKT0lOICJTIDEiLiJUIDEiIHIyIE9OIChUUlVFKSkgSU5ORVIg Sk9JTiAiUyAxIi4iVCAzIiByNCBPTiAoVFJVRSkpIElOTkVSIEpPSU4gIlMgMSIuIlQgNCIg cjYgT04gKFRSVUUpKQoyMDI0LTA2LTI0IDA3OjI1OjMzLjU1NSBVVEMgWzQ3OTU3OjQyOV0g cGdfcmVncmVzcy9wb3N0Z3Jlc19mZHcgRVJST1I6ICBjYW5jZWxpbmcgc3RhdGVtZW50IGR1 ZSB0byBzdGF0ZW1lbnQgdGltZW91dAoyMDI0LTA2LTI0IDA3OjI1OjMzLjU1NSBVVEMgWzQ3 OTU3OjQzMF0gcGdfcmVncmVzcy9wb3N0Z3Jlc19mZHcgREVCVUc6ICBjbG9zaW5nIHJlbW90 ZSB0cmFuc2FjdGlvbiBvbiBjb25uZWN0aW9uIDB4NTE5MDAwMGYxNDgwCjIwMjQtMDYtMjQg MDc6MjU6MzMuNTYxIFVUQyBbNDg0NjU6MV0gW3Vua25vd25dIExPRzogIGNvbm5lY3Rpb24g cmVjZWl2ZWQ6IGhvc3Q9W2xvY2FsXQoyMDI0LTA2LTI0IDA3OjI1OjMzLjU2MSBVVEMgWzQ4 NDY1OjJdIFt1bmtub3duXSBERUJVRzogIHByb2Nlc3NpbmcgY2FuY2VsIHJlcXVlc3Q6IHNl bmRpbmcgU0lHSU5UIHRvIHByb2Nlc3MgNDgzOTAKMjAyNC0wNi0yNCAwNzoyNTozMy41NjEg VVRDIFs0ODQ2NTozXSBbdW5rbm93bl0gREVCVUc6ICBzaG1lbV9leGl0KDApOiAwIGJlZm9y ZV9zaG1lbV9leGl0IGNhbGxiYWNrcyB0byBtYWtlCjIwMjQtMDYtMjQgMDc6MjU6MzMuNTYx IFVUQyBbNDg0NjU6NF0gW3Vua25vd25dIERFQlVHOiAgc2htZW1fZXhpdCgwKTogMCBvbl9z aG1lbV9leGl0IGNhbGxiYWNrcyB0byBtYWtlCjIwMjQtMDYtMjQgMDc6MjU6MzMuNTYxIFVU QyBbNDg0NjU6NV0gW3Vua25vd25dIERFQlVHOiAgcHJvY19leGl0KDApOiAxIGNhbGxiYWNr cyB0byBtYWtlCjIwMjQtMDYtMjQgMDc6MjU6MzMuNTYxIFVUQyBbNDg0NjU6Nl0gW3Vua25v d25dIERFQlVHOiAgZXhpdCgwKQoyMDI0LTA2LTI0IDA3OjI1OjMzLjU2MSBVVEMgWzQ4NDY1 OjddIFt1bmtub3duXSBERUJVRzogIHNobWVtX2V4aXQoLTEpOiAwIGJlZm9yZV9zaG1lbV9l eGl0IGNhbGxiYWNrcyB0byBtYWtlCjIwMjQtMDYtMjQgMDc6MjU6MzMuNTYxIFVUQyBbNDg0 NjU6OF0gW3Vua25vd25dIERFQlVHOiAgc2htZW1fZXhpdCgtMSk6IDAgb25fc2htZW1fZXhp dCBjYWxsYmFja3MgdG8gbWFrZQoyMDI0LTA2LTI0IDA3OjI1OjMzLjU2MSBVVEMgWzQ4NDY1 OjldIFt1bmtub3duXSBERUJVRzogIHByb2NfZXhpdCgtMSk6IDAgY2FsbGJhY2tzIHRvIG1h a2UKMjAyNC0wNi0yNCAwNzoyNTozMy42MzUgVVRDIFs0ODM5MDoyMTZdIHBnX3JlZ3Jlc3Mg TE9HOiAgc3RhdGVtZW50OiBGRVRDSCAxMDAgRlJPTSBjMQouLi4KMjAyNC0wNi0yNCAwNzoy NjowOS4wNDEgVVRDIFs0Nzk1Nzo0MzFdIHBnX3JlZ3Jlc3MvcG9zdGdyZXNfZmR3IFdBUk5J Tkc6ICBjb3VsZCBub3QgZ2V0IHJlc3VsdCBvZiBjYW5jZWwgcmVxdWVzdCBkdWUgdG8gdGlt ZW91dAoyMDI0LTA2LTI0IDA3OjI2OjA5LjA0MSBVVEMgWzQ3OTU3OjQzMl0gcGdfcmVncmVz cy9wb3N0Z3Jlc19mZHcgREVCVUc6ICBkaXNjYXJkaW5nIGNvbm5lY3Rpb24gMHg1MTkwMDAw ZjE0ODAK --------------tm3L6fw2x8sndptJRVXm2qYz--