Re: idle_in_transaction_session_timeout not getting log in PG v12.2 - Mailing list pgsql-general

From Adrian Klaver
Subject Re: idle_in_transaction_session_timeout not getting log in PG v12.2
Date
Msg-id bd30cd2e-98fd-f9c5-1c1e-20127339dafc@aklaver.com
Whole thread Raw
In response to idle_in_transaction_session_timeout not getting log in PG v12.2  (Ishan Joshi <Ishan.Joshi@amdocs.com>)
Responses RE: idle_in_transaction_session_timeout not getting log in PG v12.2  (Ishan Joshi <Ishan.Joshi@amdocs.com>)
List pgsql-general
On 5/19/20 2:08 AM, Ishan Joshi wrote:
> Hi Team,
> 
> I have set idle_in_transaction_session_timeout on user level and it is 
> set for 5 min. I can see after 5 min the session with “idle in 
> transaction” state got killed and it log the details in postgresql log 
> file with “FATAL: terminating connection due to idle-in-transaction 
> timeout” in v11.5
> 
> But I have testing the same in v12.2, The session getting killed with 
> state “idle in transaction”  but the log is not generated in postgresql 
> log file.
> 
> Is there any specific changes related to this for v12.2 or any 
> additional parameters need to set for generating logs.

Looking at code in ~/backend/tcop/postgres.c it has not changed.

Are you reusing the same *.conf in 12 as you did in 11?

What are your logging settings?

> 
> Thanks & Regards,
> 
> Ishan Joshi
> 
> *This email and the information contained herein is proprietary and 
> confidential and subject to the Amdocs Email Terms of Service, which you 
> may review at**https://www.amdocs.com/about/email-terms-of-service*
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Huge tables, trying to delete OID's taking 6+hours per table
Next
From: Ishan Joshi
Date:
Subject: RE: idle_in_transaction_session_timeout not getting log in PG v12.2