Re: BUG #18985: fast shutdown does not close connections from qlik data gateway data movement aka. replicate

David G. Johnston <david.g.johnston@gmail.com>

From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Erik Dobák <erik.dobak@gmail.com>, "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Date: 2025-07-15T16:27:36Z
Lists: pgsql-bugs
On Tuesday, July 15, 2025, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> =?UTF-8?Q?Erik_Dob=C3=A1k?= <erik.dobak@gmail.com> writes:
> > On Tue, 15 Jul 2025, 16:35 David G. Johnston, <
> david.g.johnston@gmail.com>
> > wrote:
> >> Can you replicate this on a supported version of PostgreSQL?
>
> > 14.18 is afaik supported. it is runn:ng on 14.8. so yes i could replicate
> > this on a supported version.
>
> I think what David is actually wondering about is "Qlik Data Gateway
> Data Movement".  That is not our code, and if it's using a custom
> logical-replication plugin then the plugin seems like the likely
> thing to blame.  We have not heard reports of this happening with
> our stock replication code.
>
>
>

No, I meant the reported 14.8 PG version.

The observed behavior of the server seems like a bug no matter how
well-coded or not the software trying to make the connecting is.  The
server should be able to close and disallow clients no matter what they are
doing.

David J.