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.

[cid:image001(dot)jpg(at)01D86545(dot)FDA18740]

Regards,

Ram Pratap.

-----Original Message-----
From: Masahiko Sawada [mailto:sawada(dot)mshk(at)gmail(dot)com]
Sent: 11 May 2022 14:06
To: Ram Pratap Maurya <ram(dot)maurya(at)lavainternational(dot)in>
Cc: PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)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(dot)maurya(at)lavainternational(dot)in<mailto:ram(dot)maurya(at)lavainternational(dot)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/