Search Postgresql Archives

PG-15.6: timeout parameters erroring out

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 = 60000
idle_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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux