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/