Posgresql-13 Bug (idle_in_transaction_session_timeout)

Hi,

On Wed, May 11, 2022 at 4:52 PM Ram Pratap Maurya
<ram.maurya@lavainternational.in> wrote:

Hi Team,

I have enable parameter “idle_in_transaction_session_timeout” in Postgresql-13 conf file.

But still Ideal connection exist in system more the defined ideal time.

I have defined ideal time 28800000 milliseconds. second (8Hrs) .

Can you please check and suggest , screen shot attached for reference.

idle_in_transaction_session_timeout is a timeout for sessions that
have been idle within an open transaction. But looking at the
screenshot you shared, the processes are in an idle state, not an
idle-in-transaction state. idle_session_timeout sets a timeout for
sessions that are in an idle state but it's available in PostgreSQL 14
or later.

Regards,

--
Masahiko Sawada
EDB: https://www.enterprisedb.com/

Hi Team,

As per in screen shot in each process occupies a scission that why our server unable to new request in postgres.

Please susggest what is solution of idel query.

[cid:image001.jpg@01D86545.FDA18740]

Regards,

Ram Pratap.

-----Original Message-----
From: Masahiko Sawada [mailto:sawada.mshk@gmail.com]
Sent: 11 May 2022 14:06
To: Ram Pratap Maurya <ram.maurya@lavainternational.in>
Cc: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Subject: Re: Posgresql-13 Bug (idle_in_transaction_session_timeout)

Hi,

On Wed, May 11, 2022 at 4:52 PM Ram Pratap Maurya <ram.maurya@lavainternational.in<mailto:ram.maurya@lavainternational.in>> wrote:

Hi Team,

I have enable parameter “idle_in_transaction_session_timeout” in Postgresql-13 conf file.

But still Ideal connection exist in system more the defined ideal time.

I have defined ideal time 28800000 milliseconds. second (8Hrs) .

Can you please check and suggest , screen shot attached for reference.

idle_in_transaction_session_timeout is a timeout for sessions that have been idle within an open transaction. But looking at the screenshot you shared, the processes are in an idle state, not an idle-in-transaction state. idle_session_timeout sets a timeout for sessions that are in an idle state but it's available in PostgreSQL 14 or later.

Regards,

--

Masahiko Sawada

EDB: https://www.enterprisedb.com/

Hi,

On Wed, May 11, 2022 at 6:19 PM Ram Pratap Maurya
<ram.maurya@lavainternational.in> wrote:

Hi Team,

As per in screen shot in each process occupies a scission that why our server unable to new request in postgres.

Please susggest what is solution of idel query.

You need to either terminate unused sessions or increase
max_connections[1]https://www.postgresql.org/docs/13/runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS to accept new connections.

This list is for bug reports and it's not a bug. Please ask questions
on pgsql-general mailing list.

[1]: https://www.postgresql.org/docs/13/runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS

--
Masahiko Sawada
EDB: https://www.enterprisedb.com/