public inbox for [email protected]  

help / color / mirror / Atom feed

From: David Rowley <[email protected]>
To: Mukesh Tanuku <[email protected]>
Cc: [email protected]
Subject: Re: PG-15.6: timeout parameters erroring out
Date: Mon, 10 Feb 2025 17:54:06 +1300
Message-ID: <CAApHDvqjCs+1rXOnerj003xww3Sowh09R_LX8uPOodPB2xPb2Q@mail.gmail.com> (raw)
In-Reply-To: <CAJzgB-Fjr0VkswdA=zytN1PXU4=hMFaK0RoR9MX4x+FNc6QCWw@mail.gmail.com>
References: <CAJzgB-Fjr0VkswdA=zytN1PXU4=hMFaK0RoR9MX4x+FNc6QCWw@mail.gmail.com>

On Mon, 10 Feb 2025 at 17:34, Mukesh Tanuku <[email protected]> wrote:
> 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 don't see any issues with the postgresql.conf, but it looks like
you're just missing single quotes in your SET statements. See [1],
where it says:

"New value of parameter. Values can be specified as string constants,
identifiers, numbers, or comma-separated lists of these, as
appropriate for the particular parameter."

String constants [2] require single quotes or the dollar quoting
format and 5min isn't a valid number.

David

[1] https://www.postgresql.org/docs/17/sql-set.html
[2] https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-STRINGS

view thread (4+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: PG-15.6: timeout parameters erroring out
  In-Reply-To: <CAApHDvqjCs+1rXOnerj003xww3Sowh09R_LX8uPOodPB2xPb2Q@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox