MIME-Version: 1.0
In-Reply-To: <CAJzgB-Fjr0VkswdA=zytN1PXU4=hMFaK0RoR9MX4x+FNc6QCWw@mail.gmail.com>
References: <CAJzgB-Fjr0VkswdA=zytN1PXU4=hMFaK0RoR9MX4x+FNc6QCWw@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Sun, 9 Feb 2025 21:47:20 -0700
Message-ID: <CAKFQuwZhcbB+HKSW=U-8zBKtjgyi6YfUd6CRVov_z_44OaFCwQ@mail.gmail.com>
Subject: Re: PG-15.6: timeout parameters erroring out
To: Mukesh Tanuku <mukesh.postgres@gmail.com>
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000005a2c39062dc267aa"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwZhcbB%2BHKSW%3DU-8zBKtjgyi6YfUd6CRVov_z_44OaFCwQ%40mail.gmail.com>
Precedence: bulk

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

On Sunday, February 9, 2025, Mukesh Tanuku <mukesh.postgres@gmail.com>
wrote:
>
>
>
> *idle_in_transaction_session_timeout =3D '1min'idle_session_timeout =3D '=
5min'*
>

I suspect our docs may need an update.  They say you may include white
space before the unit; it probably needs to be changed to =E2=80=9Cmust=E2=
=80=9D.  I
believe we=E2=80=99ve recently tightened up the parsing of literals in this=
 area.


>
> other way also, like below
>
> *idle_in_transaction_session_timeout =3D 60000idle_session_timeout =3D 30=
0000*
>

If those give error messages regarding trailing junk something else must be
going on.


>
> we see these errors reporting in the logs after we enabled those paramete=
rs
> *log:*
> 2025-02-10 04:17:19.156 GMT [2467573] ERROR:  trailing junk after numeric
> literal at or near "1m" at character 43
> 2025-02-10 04:17:19.156 GMT [2467573] STATEMENT:  SET
> idle_in_transaction_session_timeout =3D 1min
> 2025-02-10 04:17:19.845 GMT [2467575] ERROR:  trailing junk after numeric
> literal at or near "1m" at character 43
> 2025-02-10 04:17:19.845 GMT [2467575] STATEMENT:  SET
> idle_in_transaction_session_timeout =3D 1min
> ...
>

David J.

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

On Sunday, February 9, 2025, Mukesh Tanuku &lt;<a href=3D"mailto:mukesh.pos=
tgres@gmail.com">mukesh.postgres@gmail.com</a>&gt; wrote:<blockquote class=
=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padd=
ing-left:1ex"><div dir=3D"ltr"><div><br></div><div><i><b>idle_in_transactio=
n_session_<wbr>timeout =3D &#39;1min&#39;<br>idle_session_timeout =3D &#39;=
5min&#39;</b></i><br></div><div><i></i></div></div></blockquote><div><br></=
div><div>I suspect our docs may need an update.=C2=A0 They say you may incl=
ude white space before the unit; it probably needs to be changed to =E2=80=
=9Cmust=E2=80=9D.=C2=A0 I believe we=E2=80=99ve recently tightened up the p=
arsing of literals in this area.</div><div><br></div><div>=C2=A0</div><bloc=
kquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #cc=
c solid;padding-left:1ex"><div dir=3D"ltr"><div><i></i></div><div><br></div=
><div>other way also, like below=C2=A0</div><div><i><b>idle_in_transaction_=
session_<wbr>timeout =3D 60000<br>idle_session_timeout =3D 300000</b></i></=
div><div><i></i></div></div></blockquote><div><br></div><div>If those give =
error messages regarding trailing junk something else must be going on.</di=
v><div>=C2=A0</div><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 =
.8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir=3D"ltr"><div><i>=
</i></div><div><i><br></i></div><div>we see these errors reporting in the l=
ogs after we enabled those parameters</div><div><b>log:</b></div><div>2025-=
02-10 04:17:19.156 GMT [2467573] ERROR: =C2=A0trailing junk after numeric l=
iteral at or near &quot;1m&quot; at character 43<br>2025-02-10 04:17:19.156=
 GMT [2467573] STATEMENT: =C2=A0SET idle_in_transaction_session_<wbr>timeou=
t =3D 1min<br>2025-02-10 04:17:19.845 GMT [2467575] ERROR: =C2=A0trailing j=
unk after numeric literal at or near &quot;1m&quot; at character 43<br>2025=
-02-10 04:17:19.845 GMT [2467575] STATEMENT: =C2=A0SET idle_in_transaction_=
session_<wbr>timeout =3D 1min<br></div><div>...</div></div></blockquote><di=
v><br></div><div>David J.</div><div>=C2=A0</div>

--0000000000005a2c39062dc267aa--