public inbox for [email protected]
help / color / mirror / Atom feedFrom: David G. Johnston <[email protected]>
To: Mukesh Tanuku <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: PG-15.6: timeout parameters erroring out
Date: Sun, 9 Feb 2025 21:47:20 -0700
Message-ID: <CAKFQuwZhcbB+HKSW=U-8zBKtjgyi6YfUd6CRVov_z_44OaFCwQ@mail.gmail.com> (raw)
In-Reply-To: <CAJzgB-Fjr0VkswdA=zytN1PXU4=hMFaK0RoR9MX4x+FNc6QCWw@mail.gmail.com>
References: <CAJzgB-Fjr0VkswdA=zytN1PXU4=hMFaK0RoR9MX4x+FNc6QCWw@mail.gmail.com>
On Sunday, February 9, 2025, Mukesh Tanuku <[email protected]>
wrote:
>
>
>
> *idle_in_transaction_session_timeout = '1min'idle_session_timeout = '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 “must”. I
believe we’ve recently tightened up the parsing of literals in this area.
>
> other way also, like below
>
> *idle_in_transaction_session_timeout = 60000idle_session_timeout = 300000*
>
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 parameters
> *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 = 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 = 1min
> ...
>
David J.
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: PG-15.6: timeout parameters erroring out
In-Reply-To: <CAKFQuwZhcbB+HKSW=U-8zBKtjgyi6YfUd6CRVov_z_44OaFCwQ@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox