Re: pgsql: psql: Add test for query canceling - Mailing list pgsql-committers

From Daniel Gustafsson
Subject Re: pgsql: psql: Add test for query canceling
Date
Msg-id DD279DFC-DD59-458E-B469-75DC941765A4@yesql.se
Whole thread Raw
In response to pgsql: psql: Add test for query canceling  (Peter Eisentraut <peter@eisentraut.org>)
Responses Re: pgsql: psql: Add test for query canceling  (Fabien COELHO <coelho@cri.ensmp.fr>)
List pgsql-committers
> On 20 Aug 2021, at 11:44, Peter Eisentraut <peter@eisentraut.org> wrote:
>
> psql: Add test for query canceling

Seems sidewinder didn’t quite like this:

==~_~===-=-===~_~== pgsql.build/src/bin/psql/tmp_check/log/020_cancel_main.log ==~_~===-=-===~_~==
2021-08-20 12:52:29.992 CEST [9820:1] LOG:  starting PostgreSQL 15devel on x86_64-unknown-netbsd7.0, compiled by gcc
(nb220150115) 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=[local]
2021-08-20 12:52:30.093 CEST [656:2] [unknown] LOG:  connection authorized: user=pgbf database=postgres
application_name=020_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=sidewinder&dt=2021-08-20%2010%3A45%3A24

--
Daniel Gustafsson        https://vmware.com/




pgsql-committers by date:

Previous
From: Daniel Gustafsson
Date:
Subject: pgsql: Remove --quiet option from pg_amcheck
Next
From: Fabien COELHO
Date:
Subject: Re: pgsql: psql: Add test for query canceling