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
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 |