MIME-Version: 1.0
References: <CAJzgB-Fjr0VkswdA=zytN1PXU4=hMFaK0RoR9MX4x+FNc6QCWw@mail.gmail.com>
 <2106557.1739163733@sss.pgh.pa.us> <CAKFQuwY6VqAAHxHK73oymxwg=nRpEnTnQQNBq+fTtjR+Fecp=A@mail.gmail.com>
In-Reply-To: <CAKFQuwY6VqAAHxHK73oymxwg=nRpEnTnQQNBq+fTtjR+Fecp=A@mail.gmail.com>
From: Mukesh Tanuku <mukesh.postgres@gmail.com>
Date: Mon, 10 Feb 2025 16:06:36 +0530
Message-ID: <CAJzgB-FjAsqANqVM8gxdo1aYqeZVvoHrW25c84y2711aca47Sg@mail.gmail.com>
Subject: Re: PG-15.6: timeout parameters erroring out
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, 
	"pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000000c370b062dc74920"
Archived-At: <https://www.postgresql.org/message-id/CAJzgB-FjAsqANqVM8gxdo1aYqeZVvoHrW25c84y2711aca47Sg%40mail.gmail.com>
Precedence: bulk

--0000000000000c370b062dc74920
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Thanks for your quick responses.

I have just added the session related timeout parameters in the
postgresql.conf file also tried tweaking with different values/patterns
like ('1min', '1 min', 80000, 10s, '10s', '10 s')

but i get an immediate error after reloading the configuration file.

*postgres.log file*
2025-02-10 10:27:10.748 GMT [934108] LOG:  received SIGHUP, reloading
configuration files
2025-02-10 10:27:10.749 GMT [934108] LOG:  parameter
"idle_in_transaction_session_timeout" changed to "80000"
2025-02-10 10:27:16.117 GMT [2531150] ERROR:  trailing junk after numeric
literal at or near "80s" at character 43
2025-02-10 10:27:16.117 GMT [2531150] STATEMENT:  SET
idle_in_transaction_session_timeout =3D 80s

though we are not firing any SQL statements explicitly we see this error.

i guess something else is the issue other than spacing.

Regards
Mukesh Tanuku


On Mon, Feb 10, 2025 at 10:38=E2=80=AFAM David G. Johnston <
david.g.johnston@gmail.com> wrote:

> On Sunday, February 9, 2025, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
>> Mukesh Tanuku <mukesh.postgres@gmail.com> writes:
>> > We unabled the postgres timeout parameters in the postgresql.conf file
>>
>> > *idle_in_transaction_session_timeout =3D '1min'idle_session_timeout =
=3D
>> '5min'*
>>
> Did you actually run them together on one line like that?
>
>
>>
> I think that is an email client artifact, dealing with RTF or something.
>
> I do agree too much is missing here.  The only known errors involve SET
> which configuration file settings don=E2=80=99t use.  And those errors ar=
e indeed
> the lack of quoting.
>
> The lack of space I mentioned earlier, in the config text literal, is fin=
e.
>
> David J.
>
>

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

<div dir=3D"ltr">Thanks for your quick=C2=A0responses.<div><br></div><div>I=
 have just added the session related timeout parameters in the postgresql.c=
onf file also tried tweaking with different values/patterns like (&#39;1min=
&#39;, &#39;1 min&#39;, 80000, 10s, &#39;10s&#39;, &#39;10 s&#39;)</div><di=
v><br></div><div>but i get an immediate error after reloading the configura=
tion file.=C2=A0</div><div><br></div><div><b><u>postgres.log file</u></b><b=
r>2025-02-10 10:27:10.748 GMT [934108] LOG: =C2=A0received SIGHUP, reloadin=
g configuration files<br>2025-02-10 10:27:10.749 GMT [934108] LOG: =C2=A0pa=
rameter &quot;idle_in_transaction_session_timeout&quot; changed to &quot;80=
000&quot;<br>2025-02-10 10:27:16.117 GMT [2531150] ERROR: =C2=A0trailing ju=
nk after numeric literal at or near &quot;80s&quot; at character 43<br>2025=
-02-10 10:27:16.117 GMT [2531150] STATEMENT: =C2=A0SET idle_in_transaction_=
session_timeout =3D 80s<br></div><div><br></div><div>though we are not firi=
ng any SQL statements explicitly=C2=A0we see this error.</div><div><br></di=
v><div>i guess something else is the issue other than spacing.</div><div><b=
r></div><div>Regards</div><div>Mukesh Tanuku</div><div><br></div></div><br>=
<div class=3D"gmail_quote gmail_quote_container"><div dir=3D"ltr" class=3D"=
gmail_attr">On Mon, Feb 10, 2025 at 10:38=E2=80=AFAM David G. Johnston &lt;=
<a href=3D"mailto:david.g.johnston@gmail.com">david.g.johnston@gmail.com</a=
>&gt; wrote:<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">On =
Sunday, February 9, 2025, Tom Lane &lt;<a href=3D"mailto:tgl@sss.pgh.pa.us"=
 target=3D"_blank">tgl@sss.pgh.pa.us</a>&gt; wrote:<br><blockquote class=3D=
"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(2=
04,204,204);padding-left:1ex">Mukesh Tanuku &lt;<a href=3D"mailto:mukesh.po=
stgres@gmail.com" target=3D"_blank">mukesh.postgres@gmail.com</a>&gt; write=
s:<br>
&gt; We unabled the postgres timeout parameters in the postgresql.conf file=
<br>
<br>
&gt; *idle_in_transaction_session_timeout =3D &#39;1min&#39;idle_session_ti=
meout =3D &#39;5min&#39;*=C2=A0<br></blockquote><blockquote class=3D"gmail_=
quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,=
204);padding-left:1ex">
Did you actually run them together on one line like that?</blockquote><bloc=
kquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:=
1px solid rgb(204,204,204);padding-left:1ex"><br></blockquote><div><br></di=
v><div>I think that is an email client artifact, dealing with RTF or someth=
ing.</div><div><br></div><div>I do agree too much is missing here.=C2=A0 Th=
e only known errors involve SET which configuration file settings don=E2=80=
=99t use.=C2=A0 And those errors are indeed the lack of quoting.</div><div>=
<br></div><div>The lack of space I mentioned earlier, in the config text li=
teral, is fine.</div><div><br></div><div>David J.</div><div><br></div>
</blockquote></div>

--0000000000000c370b062dc74920--