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 1mH2Gj-0005rh-Dm for pgsql-committers@arkaria.postgresql.org; Fri, 20 Aug 2021 11:01:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mH2Gh-00014r-Rr for pgsql-committers@arkaria.postgresql.org; Fri, 20 Aug 2021 11:00:59 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mH2Gh-00014a-Lg for pgsql-committers@lists.postgresql.org; Fri, 20 Aug 2021 11:00:59 +0000 Received: from smtp.outgoing.loopia.se ([93.188.3.37]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mH2Gf-0004qq-7O for pgsql-committers@lists.postgresql.org; Fri, 20 Aug 2021 11:00:59 +0000 Received: from s807.loopia.se (localhost [127.0.0.1]) by s807.loopia.se (Postfix) with ESMTP id 797DF2E9E315 for ; Fri, 20 Aug 2021 13:00:39 +0200 (CEST) Received: from s630.loopia.se (unknown [172.22.191.5]) by s807.loopia.se (Postfix) with ESMTP id 6A3E62E280AC; Fri, 20 Aug 2021 13:00:39 +0200 (CEST) Received: from s470.loopia.se (unknown [172.22.191.6]) by s630.loopia.se (Postfix) with ESMTP id 3C8A513B94CE; Fri, 20 Aug 2021 13:00:39 +0200 (CEST) X-Virus-Scanned: amavisd-new at amavis.loopia.se X-Spam-Flag: NO X-Spam-Score: -1 X-Spam-Level: X-Spam-Status: No, score=-1 tagged_above=-999 required=6.2 tests=[ALL_TRUSTED=-1] autolearn=disabled Received: from s934.loopia.se ([172.22.191.5]) by s470.loopia.se (s470.loopia.se [172.22.190.10]) (amavisd-new, port 10024) with UTF8LMTP id tWh2pbgYsA46; Fri, 20 Aug 2021 13:00:38 +0200 (CEST) X-Loopia-Auth: user X-Loopia-User: daniel@yesql.se X-Loopia-Originating-IP: 89.255.232.193 Received: from [192.168.72.144] (customer-89-255-232-193.stosn.net [89.255.232.193]) (Authenticated sender: daniel@yesql.se) by s934.loopia.se (Postfix) with ESMTPSA id CC2927CEA3D; Fri, 20 Aug 2021 13:00:38 +0200 (CEST) Content-Type: text/plain; charset=utf-8 Mime-Version: 1.0 (Mac OS X Mail 13.4 \(3608.120.23.2.7\)) Subject: Re: pgsql: psql: Add test for query canceling From: Daniel Gustafsson In-Reply-To: Date: Fri, 20 Aug 2021 13:00:38 +0200 Cc: pgsql-committers@lists.postgresql.org Content-Transfer-Encoding: quoted-printable Message-Id: References: To: Peter Eisentraut X-Mailer: Apple Mail (2.3608.120.23.2.7) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On 20 Aug 2021, at 11:44, Peter Eisentraut = wrote: >=20 > psql: Add test for query canceling Seems sidewinder didn=E2=80=99t quite like this: =3D=3D~_~=3D=3D=3D-=3D-=3D=3D=3D~_~=3D=3D = pgsql.build/src/bin/psql/tmp_check/log/020_cancel_main.log = =3D=3D~_~=3D=3D=3D-=3D-=3D=3D=3D~_~=3D=3D 2021-08-20 12:52:29.992 CEST [9820:1] LOG: starting PostgreSQL 15devel = on x86_64-unknown-netbsd7.0, compiled by gcc (nb2 20150115) 4.8.4, = 64-bit 2021-08-20 12:52:29.992 CEST [9820:2] LOG: listening on Unix socket = "/tmp/V5NA0EWHUl/.s.PGSQL.62222" 2021-08-20 12:52:29.994 CEST [9023:1] LOG: database system was shut = down at 2021-08-20 12:52:29 CEST 2021-08-20 12:52:29.995 CEST [9820:3] LOG: database system is ready to = accept connections 2021-08-20 12:52:30.093 CEST [656:1] [unknown] LOG: connection = received: host=3D[local] 2021-08-20 12:52:30.093 CEST [656:2] [unknown] LOG: connection = authorized: user=3Dpgbf database=3Dpostgres = application_name=3D020_cancel.pl 2021-08-20 12:52:30.098 CEST [656:3] 020_cancel.pl LOG: statement: = select pg_sleep(3); 2021-08-20 12:52:31.121 CEST [9820:4] LOG: received immediate shutdown = request 2021-08-20 12:52:31.121 CEST [656:4] 020_cancel.pl LOG: could not send = data to client: Broken pipe 2021-08-20 12:52:31.121 CEST [656:5] 020_cancel.pl STATEMENT: select = pg_sleep(3); 2021-08-20 12:52:31.125 CEST [9820:5] LOG: database system is shut down Nothing obvious sticks out, could it be timing related? = https://brekka.postgresql.org/cgi-bin/show_log.pl?nm=3Dsidewinder&dt=3D202= 1-08-20%2010%3A45%3A24 -- Daniel Gustafsson https://vmware.com/