MIME-Version: 1.0
In-Reply-To: <923969.1752595701@sss.pgh.pa.us>
References: <18985-64431d78bcabae95@postgresql.org> <CAKFQuwb4en2gPyGep4TghVeqitxBPsgiQAG5AZJ4yikBgUzooQ@mail.gmail.com>
 <CAH7-e5tbkVLKeaCEqv-_eL9D9Ppikvq-bmjviKVG6-ukkU7pXQ@mail.gmail.com> <923969.1752595701@sss.pgh.pa.us>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Tue, 15 Jul 2025 09:27:36 -0700
Message-ID: <CAKFQuwbENYBRre_Yo+jhtx+56b0W--AANjgJp1j-Ax9xUfAMxQ@mail.gmail.com>
Subject: Re: BUG #18985: fast shutdown does not close connections from qlik
 data gateway data movement aka. replicate
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: =?UTF-8?Q?Erik_Dob=C3=A1k?= <erik.dobak@gmail.com>, 
	"pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000002303b60639fa4184"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwbENYBRre_Yo%2Bjhtx%2B56b0W--AANjgJp1j-Ax9xUfAMxQ%40mail.gmail.com>
Precedence: bulk

--0000000000002303b60639fa4184
Content-Type: text/plain; charset="UTF-8"

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.

--0000000000002303b60639fa4184
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Tuesday, July 15, 2025, Tom Lane &lt;<a href=3D"mailto:tgl@sss.pgh.pa.us=
">tgl@sss.pgh.pa.us</a>&gt; wrote:<br><blockquote class=3D"gmail_quote" sty=
le=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">=3D?UT=
F-8?Q?Erik_Dob=3DC3=3DA1k?=3D &lt;<a href=3D"mailto:erik.dobak@gmail.com">e=
rik.dobak@gmail.com</a>&gt; writes:<br>
&gt; On Tue, 15 Jul 2025, 16:35 David G. Johnston, &lt;<a href=3D"mailto:da=
vid.g.johnston@gmail.com">david.g.johnston@gmail.com</a>&gt;<br>
&gt; wrote:<br>
&gt;&gt; Can you replicate this on a supported version of PostgreSQL?<br>
<br>
&gt; 14.18 is afaik supported. it is runn:ng on 14.8. so yes i could replic=
ate<br>
&gt; this on a supported version.<br>
<br>
I think what David is actually wondering about is &quot;Qlik Data Gateway<b=
r>
Data Movement&quot;.=C2=A0 That is not our code, and if it&#39;s using a cu=
stom<br>
logical-replication plugin then the plugin seems like the likely<br>
thing to blame.=C2=A0 We have not heard reports of this happening with<br>
our stock replication code.<br>
<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0=C2=A0<br>
</blockquote><div><br></div><div>No, I meant the reported 14.8 PG version.<=
/div><div><br></div><div>The observed behavior of the server seems like a b=
ug no matter how well-coded or not the software trying to make the connecti=
ng is.=C2=A0 The server should be able to close and disallow clients no mat=
ter what they are doing.</div><div><br></div><div>David J.</div><div><br></=
div>

--0000000000002303b60639fa4184--