pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: dastapov@gmail.com
To: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17698: On SIGTERM, psql terminates, but leaves the statement running
Date: Mon, 16 Jan 2023 16:14:59 +0100
Message-ID: <20230116151459.fzg6mlegkcrzch4i@alvherre.pgsql> (raw)
In-Reply-To: <17698-58a6ab8caec496b0@postgresql.org>

On 2022-Nov-25, PG Bug reporting form wrote:

> Reproduction: start psql, launch a query that will take a while (I
> used 'select pg_sleep(1234)'), then from another terminal do
> "kill -TERM <pid of psql>".  Psql would be terminated, but query would
> not be, and will keep running until TCP timeout kicks in and kills the
> stale connection.
> 
> SIGINT, on the other hand, will cause psql will terminate the current
> statement.
> 
> Perhaps psql could have a SIGTERM handler that does roughly what
> SIGINT handler does before terminating the whole process, and would
> cancel the current statement (if any)?

Sure.  I doubt we want to wait until a reply to the cancel request is
obtained, but we could have the sigterm handler at least send it before
terminating.

Why do you send SIGTERM to psql anyway?

-- 
Álvaro Herrera         PostgreSQL Developer  —  https://www.EnterpriseDB.com/
"Thou shalt not follow the NULL pointer, for chaos and madness await
thee at its end." (2nd Commandment for C programmers)





view thread (5+ messages)  latest in thread

Message-ID: <20230116151459.fzg6mlegkcrzch4i@alvherre.pgsql>
Permalink:  ../20230116151459.fzg6mlegkcrzch4i@alvherre.pgsql/
Also on:    postgresql.org/message-id/20230116151459.fzg6mlegkcrzch4i@alvherre.pgsql

 · 

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-bugs@postgresql.org
  Cc: alvherre@alvh.no-ip.org, dastapov@gmail.com
  Subject: Re: BUG #17698: On SIGTERM, psql terminates, but leaves the statement running
  In-Reply-To: <20230116151459.fzg6mlegkcrzch4i@alvherre.pgsql>
  References: <17698-58a6ab8caec496b0@postgresql.org> <20230116151459.fzg6mlegkcrzch4i@alvherre.pgsql>

* 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