idle_in_transaction_session_timeout not getting log in PG v12.2

From: Ishan Joshi <Ishan(dot)Joshi(at)amdocs(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: idle_in_transaction_session_timeout not getting log in PG v12.2
Date: 2020-05-19 09:08:32
Message-ID: AM6PR0602MB33981FBE061CD537172D4D2C86B90@AM6PR0602MB3398.eurprd06.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

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 <https://www.amdocs.com/about/email-terms-of-service>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2020-05-19 13:40:43 Re: Huge tables, trying to delete OID's taking 6+hours per table
Previous Message Andrus 2020-05-19 08:26:51 Re: Hot and PITR backups in same server