Re: PG-15.6: timeout parameters erroring out
| От | David G. Johnston |
|---|---|
| Тема | Re: PG-15.6: timeout parameters erroring out |
| Дата | |
| Msg-id | CAKFQuwZhcbB+HKSW=U-8zBKtjgyi6YfUd6CRVov_z_44OaFCwQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | PG-15.6: timeout parameters erroring out (Mukesh Tanuku <mukesh.postgres@gmail.com>) |
| Список | pgsql-general |
On Sunday, February 9, 2025, Mukesh Tanuku <mukesh.postgres@gmail.com> wrote:
idle_in_transaction_session_timeout = '1min'
idle_session_timeout = '5min'
I suspect our docs may need an update. They say you may include white space before the unit; it probably needs to be changed to “must”. I believe we’ve recently tightened up the parsing of literals in this area.
other way also, like belowidle_in_transaction_session_timeout = 60000
idle_session_timeout = 300000
If those give error messages regarding trailing junk something else must be going on.
we see these errors reporting in the logs after we enabled those parameterslog: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 ...
David J.
В списке pgsql-general по дате отправления: