RE: Posgresql-13 Bug (idle_in_transaction_session_timeout)

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.

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