Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lUXXn-0002dE-9g for pgsql-hackers@arkaria.postgresql.org; Thu, 08 Apr 2021 16:30:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lUXXm-0001pU-7j for pgsql-hackers@arkaria.postgresql.org; Thu, 08 Apr 2021 16:30:10 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lUXXl-0001pN-V3 for pgsql-hackers@lists.postgresql.org; Thu, 08 Apr 2021 16:30:10 +0000 Received: from mail-pg1-x52a.google.com ([2607:f8b0:4864:20::52a]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lUXXj-0006e8-SO for pgsql-hackers@lists.postgresql.org; Thu, 08 Apr 2021 16:30:08 +0000 Received: by mail-pg1-x52a.google.com with SMTP id w10so1778289pgh.5 for ; Thu, 08 Apr 2021 09:30:07 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to; bh=M/munfvh2Y8hLabhMyZZcfsoNg27M6f2Jol1T5LGz5g=; b=hJOA5dzDeyb9/JAwFgKcQXqzCyX5nzCflldrYPjleSsGVd1X5J+8Biu8l+i5pY+dE1 yQ13a/htwGYQgemlleWoGQ8itsl0uoVaMRwnEdPH8wDoXz1gJ28zBqcCNV6AGyjYGEf/ HmN/ES8Mn9gPZMgJ6BrWYVSlyW4PJIrjwha7SjID5hfEzPCnlt37cSWF/ZjD5JLk6mez HaqIg6V2Rsehjozp+0VX3icIVI0lECfaD8U1Vx4Dt3Vvgu07KJ5gUEPxrt5eok6XS+DW hv+wazx3KVb+b3020RnhfOD1lK7yCtA5J0tnD+lAHyboN/Ov6IL+0LBfnZiV9Eb8qaGC gsaQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to; bh=M/munfvh2Y8hLabhMyZZcfsoNg27M6f2Jol1T5LGz5g=; b=nIKa2ogeLKHe1Ia+9p58gRtFCRuLZkiev3i0gwwe9EN4ogvTST39q6IsIDy1xADPip /CPj6uFul+TCz+l6a6cu3mv3PesB9ZFZTWQue5mT5w7Sk5EvkcTj5eqFbrQ6wwjspJjR bKDExpnhp7VVIoBESptqBjeJ/WgtWiL98mw69+GTr2UIO7gnI3sDNxnPVtllljLVA0lT g3Em4bMgwHpbX/o2dn2fkj2d6b1BZCic1fvoPgrnRmXc+c1L+Ah3JsLesyPyKPanKrjs mQnBU/fi/7PHapmUHY2+QrnCjoNETSXoRdx1JV8ReArhBsZpJ3qQ6t1nyL89MG9lfpLi jDIQ== X-Gm-Message-State: AOAM532PUj9Oat7w3SclMyLFl1xM95eGZRrWA0lkXR9YYzs/L1EhOtIp 8GEVBMO10DzTTE//4QpLcb8= X-Google-Smtp-Source: ABdhPJzIiVFYflzVYigqtKMr8LbnRExzqAvHgOHdCbCLuVAPwi1n9jZg8xusD8+X3kX3mdG8syGlSw== X-Received: by 2002:a05:6a00:2345:b029:20b:c007:f9a4 with SMTP id j5-20020a056a002345b029020bc007f9a4mr8230605pfj.42.1617899406571; Thu, 08 Apr 2021 09:30:06 -0700 (PDT) Received: from nol (2001-b011-0008-9647-4c71-2a6f-a895-f450.dynamic-ip6.hinet.net. [2001:b011:8:9647:4c71:2a6f:a895:f450]) by smtp.gmail.com with ESMTPSA id gd12sm8723203pjb.48.2021.04.08.09.30.05 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 08 Apr 2021 09:30:06 -0700 (PDT) Date: Fri, 9 Apr 2021 00:30:50 +0800 From: Julien Rouhaud To: "shiy.fnst@fujitsu.com" Cc: Fabien COELHO , "pgsql-hackers@lists.postgresql.org" Subject: Re: psql - add SHOW_ALL_RESULTS option Message-ID: <20210408163050.fca7dwb37zszbsmm@nol> References: <20200930062105.GE1996@paquier.xyz> <1ec5ef49-b5c8-4129-e680-fe42f8d0670b@2ndquadrant.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Apr 08, 2021 at 01:32:12AM +0000, shiy.fnst@fujitsu.com wrote: > > Attached a patch which attempts to fix this by moving the cancellation > > cancelling request after processing results. > > Thank you for your fixing. I tested and the problem has been solved after applying your patch. Thanks for the patch Fabien. I've hit this issue multiple time and this is indeed unwelcome. Should we add it as an open item?