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@xxxxxxxxxxx
