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

Reply via email to