agora inbox for pgsql-admin@postgresql.org
help / color / mirror / Atom feedFrom: Tom Lane <tgl@sss.pgh.pa.us>
To: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: Does export operation cancel SQLs?
Date: Wed, 19 Feb 2025 11:03:41 -0500
Message-ID: <2018443.1739981021@sss.pgh.pa.us> (raw)
In-Reply-To: <CANzqJaAYzSi6zW_fGF8pO_r4Cc5DL8qEvQnBRreTV1KhjY65DQ@mail.gmail.com>
References: <CAC5iy62t+KuBZJGLjDQ54w6QyELZZyPisacuKvW+KT_+UomPfw@mail.gmail.com>
<CAKFQuwbRW77=4zboZfOv3_E7ct-36gNvnEfk38GhPbCUcNR5Qw@mail.gmail.com>
<098b7dbed4aa52c97b6159b26c36129ff2f10409.camel@cybertec.at>
<CANzqJaAYzSi6zW_fGF8pO_r4Cc5DL8qEvQnBRreTV1KhjY65DQ@mail.gmail.com>
Ron Johnson <ronljohnsonjr@gmail.com> writes:
> On Wed, Feb 19, 2025 at 10:00 AM Laurenz Albe <laurenz.albe@cybertec.at>
> wrote:
>> No, that message is from a cancel request, like when you interrupt your
>> currently running query with Ctrl+C in "psql" or invoke
>> pg_cancel_backend().
>> PostgreSQL doesn't do that by itself.
> The Linux oom killer? I don't remember the exact error message that PG
> gives to the user, but ISTR that it's "user request”.
No, the OOM killer does "kill -9", which stops the PG process in
its tracks. So no message at all will be issued. You'll get
some kind of "connection lost" message from the connected client,
but for sure that is not going to claim it was a "user request".
I do seem to recall that there are some edge cases where we can't
really tell the source of a SIGINT signal, but there's no reason
to think that any of those cases are in play here. The OP should
be looking first at the other moving parts in his installation
to see what might be issuing a query cancel.
regards, tom lane
view thread (17+ messages) latest in thread
Message-ID: <2018443.1739981021@sss.pgh.pa.us>
Permalink: ../2018443.1739981021@sss.pgh.pa.us/
Also on: postgresql.org/message-id/2018443.1739981021@sss.pgh.pa.us
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-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Does export operation cancel SQLs?
In-Reply-To: <2018443.1739981021@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox