Message-ID: <788aca1329878b3fbc93da929bd54b758ec5e4b4.camel@tpg.com.au>
Subject: Re: PG-15.6: timeout parameters erroring out
From: rob stone <floriparob@tpg.com.au>
To: Mukesh Tanuku <mukesh.postgres@gmail.com>, 
	pgsql-general@lists.postgresql.org
Date: Mon, 10 Feb 2025 23:39:12 +1100
In-Reply-To: <CAJzgB-FjAsqANqVM8gxdo1aYqeZVvoHrW25c84y2711aca47Sg@mail.gmail.com>
References: 
	<CAJzgB-Fjr0VkswdA=zytN1PXU4=hMFaK0RoR9MX4x+FNc6QCWw@mail.gmail.com>
	 <2106557.1739163733@sss.pgh.pa.us>
	 <CAKFQuwY6VqAAHxHK73oymxwg=nRpEnTnQQNBq+fTtjR+Fecp=A@mail.gmail.com>
	 <CAJzgB-FjAsqANqVM8gxdo1aYqeZVvoHrW25c84y2711aca47Sg@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.54.3-2 
MIME-Version: 1.0
Archived-At: <https://www.postgresql.org/message-id/788aca1329878b3fbc93da929bd54b758ec5e4b4.camel%40tpg.com.au>
Precedence: bulk


On Mon, 2025-02-10 at 16:06 +0530, Mukesh Tanuku wrote:
> Thanks for your quick=C2=A0responses.
>=20
> 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')
>=20
> but i get an immediate error after reloading the configuration file.=C2=
=A0
>=20
> postgres.log file
> 2025-02-10 10:27:10.748 GMT [934108] LOG: =C2=A0received SIGHUP, reloadin=
g
> configuration files
> 2025-02-10 10:27:10.749 GMT [934108] LOG: =C2=A0parameter
> "idle_in_transaction_session_timeout" changed to "80000"
> 2025-02-10 10:27:16.117 GMT [2531150] ERROR: =C2=A0trailing junk after
> numeric literal at or near "80s" at character 43
> 2025-02-10 10:27:16.117 GMT [2531150] STATEMENT: =C2=A0SET
> idle_in_transaction_session_timeout =3D 80s
>=20
> though we are not firing any SQL statements explicitly=C2=A0we see this
> error.
>=20
> i guess something else is the issue other than spacing.
>=20
>=20

I'd say that 934108 is the config file reload and that 2531150 is from
somebody running psql from a shell or SQL code coming out from an
application.


>=20