pg.ddx.io  pgsql-committers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Daniel Gustafsson <daniel@yesql.se>
To: Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Cc: pgsql-committers@lists.postgresql.org
Subject: Re: pgsql: psql: Add test for query canceling
Date: Fri, 20 Aug 2021 13:00:38 +0200
Message-ID: <DD279DFC-DD59-458E-B469-75DC941765A4@yesql.se> (raw)
In-Reply-To: <E1mH14Q-0002gh-HS@gemulon.postgresql.org>
References: <E1mH14Q-0002gh-HS@gemulon.postgresql.org>

> 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 (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=[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/






view thread (20+ messages)  latest in thread

Message-ID: <DD279DFC-DD59-458E-B469-75DC941765A4@yesql.se>
Permalink:  ../DD279DFC-DD59-458E-B469-75DC941765A4@yesql.se/
Also on:    postgresql.org/message-id/DD279DFC-DD59-458E-B469-75DC941765A4@yesql.se

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-committers@postgresql.org
  Cc: daniel@yesql.se, peter.eisentraut@enterprisedb.com
  Subject: Re: pgsql: psql: Add test for query canceling
  In-Reply-To: <DD279DFC-DD59-458E-B469-75DC941765A4@yesql.se>
  References: <E1mH14Q-0002gh-HS@gemulon.postgresql.org> <DD279DFC-DD59-458E-B469-75DC941765A4@yesql.se>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox