PG-15.6: timeout parameters erroring out

From: Mukesh Tanuku <mukesh(dot)postgres(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: PG-15.6: timeout parameters erroring out
Date: 2025-02-10 04:34:17
Message-ID: CAJzgB-Fjr0VkswdA=zytN1PXU4=hMFaK0RoR9MX4x+FNc6QCWw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2025-02-10 04:47:20 Re: PG-15.6: timeout parameters erroring out
Previous Message Adrian Klaver 2025-02-09 21:56:52 Re: Passwordcheck Extension Not Installing