From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: gregory@arenius.com
Subject: BUG #17181: pg_cancel_backend and pg_terminate_backend fail to work
Date: Fri, 03 Sep 2021 20:36:44 +0000
Message-ID: <17181-a35b7eaadcbaaa54@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 17181
Logged by: Gregory Arenius
Email address: gregory@arenius.com
PostgreSQL version: 11.12
Operating system: Ubuntu 20.04
Description:
There are several long running queries in my database that I have tried to
shutdown manually using the pg_cancel_backend and pg_terminate_backend
functions. The functions both return true but the queries are still
running. The client that initiated the queries is not running. The TCP
connections that the process was using are no longer open. pg_stat_activity
lists the queries as "active". The queries are all using at least on
Foreign Data Wrapper based table. When I killed the TCP connections to the
foreign server all of the queries finished. I'm not sure how but I think
there is some sort of bug that is holding the TCP connection to the foreign
server open and that is not allowing the query to terminate.
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, gregory@arenius.com
Subject: Re: BUG #17181: pg_cancel_backend and pg_terminate_backend fail to work
In-Reply-To: <17181-a35b7eaadcbaaa54@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