Re: PG-15.6: timeout parameters erroring out

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Sunday, February 9, 2025, Mukesh Tanuku <mukesh.postgres@xxxxxxxxx> 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 below 

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

...

David J.