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