public inbox for [email protected]
help / color / mirror / Atom feedFrom: Mukesh Tanuku <[email protected]>
To: [email protected]
Subject: PG-15.6: timeout parameters erroring out
Date: Mon, 10 Feb 2025 10:04:17 +0530
Message-ID: <CAJzgB-Fjr0VkswdA=zytN1PXU4=hMFaK0RoR9MX4x+FNc6QCWw@mail.gmail.com> (raw)
Hello team,
We unabled the postgres timeout parameters in the postgresql.conf file
*idle_in_transaction_session_timeout = '1min'idle_session_timeout = '5min'*
other way also, like below
*idle_in_transaction_session_timeout = 60000idle_session_timeout = 300000*
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
...
...
...
2025-02-10 04:22:00.823 GMT [2468337] ERROR: trailing junk after numeric
literal at or near "5m" at character 28
2025-02-10 04:22:00.823 GMT [2468337] STATEMENT: SET idle_session_timeout
= 5min
2025-02-10 04:22:03.487 GMT [2468342] ERROR: trailing junk after numeric
literal at or near "5m" at character 28
2025-02-10 04:22:03.487 GMT [2468342] STATEMENT: SET idle_session_timeout
= 5min
2025-02-10 04:22:04.470 GMT [2468345] ERROR: trailing junk after numeric
literal at or near "5m" at character 28
Is there any know issue/bug with these paramters, can someone help me to
get this worked since our app idle connections are getting pilled up and
reaching max connections.
I really appreciate your help. Thank you.
Regards
Mukesh Tanuku
view thread (4+ messages) latest in thread
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]
Subject: Re: PG-15.6: timeout parameters erroring out
In-Reply-To: <CAJzgB-Fjr0VkswdA=zytN1PXU4=hMFaK0RoR9MX4x+FNc6QCWw@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