On 5/19/20 8:07 AM, Ishan Joshi wrote:
Hi Adrian,
1) What OS and version and did it change between 11 and 12? --> it is
cent os 7 an both v11.5 and v12.2 are on same server.
2) How are you starting the server and did that change? --> through
systemctl start postgresql-12
3) When did you copy the 11 *.conf files over and did you restart the 12
server after? --> copy and restart the server 12
4) What is being logged to the file e.g. connections/disconnects, etc?
--> yes these are getting logged
Hmm, I'm at a loss for an explanation. All I have left is:
1) Do you see anything relevant in the logs when the session is killed?
2) Is the transaction actually being killed? In other words does it
still show up in?:
https://www.postgresql.org/docs/12/monitoring-stats.html#PG-STAT-ACTIVITY-VIEW
Thanks & Regards,
Ishan Joshi
-----Original Message-----
From: Adrian Klaver <adrian.klaver@xxxxxxxxxxx>
Sent: Tuesday, May 19, 2020 8:28 PM
To: Ishan Joshi <Ishan.Joshi@xxxxxxxxxx>; pgsql-general@xxxxxxxxxxxxxx
Subject: Re: idle_in_transaction_session_timeout not getting log in PG v12.2
On 5/19/20 7:40 AM, Ishan Joshi wrote:
> Yes Adrian...!!!
Well then:
1) What OS and version and did it change between 11 and 12?
2) How are you starting the server and did that change?
3) When did you copy the 11 *.conf files over and did you restart the 12
server after?
4) What is being logged to the file e.g. connections/disconnects, etc?
>
> Thanks & Regards,
> Ishan Joshi
>
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>
*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
