From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Ishan Joshi <Ishan(dot)Joshi(at)amdocs(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: idle_in_transaction_session_timeout not getting log in PG v12.2 |
Date: | 2020-05-19 15:29:18 |
Message-ID: | 612ed802-b9b7-3ebf-a174-73f223de801d@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com>
> Sent: Tuesday, May 19, 2020 8:28 PM
> To: Ishan Joshi <Ishan(dot)Joshi(at)amdocs(dot)com>; pgsql-general(at)postgresql(dot)org
> 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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>
> *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(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Tory M Blue | 2020-05-19 16:51:29 | Re: Huge tables, trying to delete OID's taking 6+hours per table |
Previous Message | Ishan Joshi | 2020-05-19 15:07:55 | RE: idle_in_transaction_session_timeout not getting log in PG v12.2 |