MIME-Version: 1.0
References: <18985-64431d78bcabae95@postgresql.org> <CAKFQuwb4en2gPyGep4TghVeqitxBPsgiQAG5AZJ4yikBgUzooQ@mail.gmail.com>
 <CAH7-e5tbkVLKeaCEqv-_eL9D9Ppikvq-bmjviKVG6-ukkU7pXQ@mail.gmail.com>
 <923969.1752595701@sss.pgh.pa.us> <CAKFQuwbENYBRre_Yo+jhtx+56b0W--AANjgJp1j-Ax9xUfAMxQ@mail.gmail.com>
 <936089.1752602421@sss.pgh.pa.us>
In-Reply-To: <936089.1752602421@sss.pgh.pa.us>
From: =?UTF-8?Q?Erik_Dob=C3=A1k?= <erik.dobak@gmail.com>
Date: Tue, 15 Jul 2025 20:32:53 +0200
Message-ID: <CAH7-e5vFAX+-EkjT20uMUw3kA8pNv53aD_jKR8+QBB+1hse9pg@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: "David G. Johnston" <david.g.johnston@gmail.com>, pgsql-bugs@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000eae52d0639fc0191"
Archived-At: <https://www.postgresql.org/message-id/CAH7-e5vFAX%2B-EkjT20uMUw3kA8pNv53aD_jKR8%2BQBB%2B1hse9pg%40mail.gmail.com>
Precedence: bulk

--000000000000eae52d0639fc0191
Content-Type: text/plain; charset="UTF-8"

On Tue, 15 Jul 2025, 20:00 Tom Lane, <tgl@sss.pgh.pa.us> wrote:

> "David G. Johnston" <david.g.johnston@gmail.com> writes:
> > 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.
>
> We will SIGKILL recalcitrant children during an "immediate" shutdown.
> "Fast" shutdown is not defined to do that, and should not do so
> because it'd imply having to do an unclean restart later.
>
> I just tested logical replication both ways between current master and
> v14 branch tip, and in either case the publishing server stops pretty
> much instantaneously after "pg_ctl stop -m fast".  So I don't see
> anything broken about our code, and I remain of the opinion that Qlik
> is probably at fault.
>
>                         regards, tom lane
>
thank you Tom,

based on the documentation mentioned in my initial post i was thinking that
the connections are closed during " fast" shutdown immediately.

i will forward this to Qlik then.

is there a better documentation that would explain the process of shutdown
than the link i posted above?

regards

E

>

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

<div dir=3D"auto"><div><br><br><div class=3D"gmail_quote gmail_quote_contai=
ner"><div dir=3D"ltr" class=3D"gmail_attr">On Tue, 15 Jul 2025, 20:00 Tom L=
ane, &lt;<a href=3D"mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us</a>&gt; wro=
te:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px =
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">&quot;David =
G. Johnston&quot; &lt;<a href=3D"mailto:david.g.johnston@gmail.com" target=
=3D"_blank" rel=3D"noreferrer">david.g.johnston@gmail.com</a>&gt; writes:<b=
r>
&gt; The observed behavior of the server seems like a bug no matter how<br>
&gt; well-coded or not the software trying to make the connecting is.=C2=A0=
 The<br>
&gt; server should be able to close and disallow clients no matter what the=
y are<br>
&gt; doing.<br>
<br>
We will SIGKILL recalcitrant children during an &quot;immediate&quot; shutd=
own.<br>
&quot;Fast&quot; shutdown is not defined to do that, and should not do so<b=
r>
because it&#39;d imply having to do an unclean restart later.<br>
<br>
I just tested logical replication both ways between current master and<br>
v14 branch tip, and in either case the publishing server stops pretty<br>
much instantaneously after &quot;pg_ctl stop -m fast&quot;.=C2=A0 So I don&=
#39;t see<br>
anything broken about our code, and I remain of the opinion that Qlik<br>
is probably at fault.<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 regards, tom lane<br></blockquote></div></div><div dir=3D"auto">=
thank you Tom,</div><div dir=3D"auto"><br></div><div dir=3D"auto">based on =
the documentation mentioned in my initial post i was thinking that the conn=
ections are closed during &quot; fast&quot; shutdown immediately.</div><div=
 dir=3D"auto"><br></div><div dir=3D"auto">i will forward this to Qlik then.=
</div><div dir=3D"auto"><br></div><div dir=3D"auto">is there a better docum=
entation that would explain the process of shutdown than the link i posted =
above?</div><div dir=3D"auto"><br></div><div dir=3D"auto">regards</div><div=
 dir=3D"auto"><br></div><div dir=3D"auto">E</div><div dir=3D"auto"><div cla=
ss=3D"gmail_quote gmail_quote_container"><blockquote class=3D"gmail_quote" =
style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);pa=
dding-left:1ex">
</blockquote></div></div></div>

--000000000000eae52d0639fc0191--