pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: rekgrpth@gmail.com
Subject: BUG #17303: statement_timeout does not work always
Date: Mon, 29 Nov 2021 03:58:32 +0000
Message-ID: <17303-b5932dfa7e8355be@postgresql.org> (raw)

The following bug has been logged on the website:

Bug reference:      17303
Logged by:          RekGRpth
Email address:      rekgrpth@gmail.com
PostgreSQL version: 10.19
Operating system:   ubuntu
Description:        

in postgres 10.19
psql -c "SET statement_timeout = 1000;select pg_sleep(2);"
 pg_sleep 
----------
 
(1 row)

but
psql
psql (14.1 (Ubuntu 14.1-1.pgdg21.10+1), server 10.19 (Ubuntu
10.19-1.pgdg21.10+1))
Type "help" for help.

postgres=# SET statement_timeout = 1000;select pg_sleep(2);
SET
ERROR:  canceling statement due to statement timeout

and in postgres 14.1
psql -c "SET statement_timeout = 1000;select pg_sleep(2);"
ERROR:  canceling statement due to statement timeout

Why statement_timeout does not work always in postgres 10.19?



view thread (4+ messages)  latest in thread

Message-ID: <17303-b5932dfa7e8355be@postgresql.org>
Permalink:  ../17303-b5932dfa7e8355be@postgresql.org/
Also on:    postgresql.org/message-id/17303-b5932dfa7e8355be@postgresql.org

 · 

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 using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, rekgrpth@gmail.com
  Subject: Re: BUG #17303: statement_timeout does not work always
  In-Reply-To: <17303-b5932dfa7e8355be@postgresql.org>

* 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