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)
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