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.
