| 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: | Whole Thread | Raw Message | 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
| 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 |