RE: idle_in_transaction_session_timeout not getting log in PG v12.2

Yes Adrian...!!!

Thanks & Regards,
Ishan Joshi

-----Original Message-----
From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Sent: Tuesday, May 19, 2020 7:53 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:12 AM, Ishan Joshi wrote:
> Thank Adrian for response.
>
> Yes I have the same *.conf file as v11.5 in fact I have copied the
> same conf files in v12.2
>
> Logging parameter are as follows

I'm not seeing anything obviously wrong with below.

Are you sure you are looking at the correct log?

>
> *Parameter*
>
>
>
> *Values*
>
> log_autovacuum_min_duration
>
>
>
>  1s
>
>  log_checkpoints
>
>
>
>  on
>
>  log_connections
>
>
>
>  on
>
>  log_destination
>
>
>
>  stderr
>
>  log_directory
>
>
>
>  log
>
>  log_disconnections
>
>
>
>  on
>
>  log_duration
>
>
>
>  off
>
>  log_error_verbosity
>
>
>
>  default
>
>  log_executor_stats
>
>
>
>  off
>
>  log_file_mode
>
>
>
> 600
>
> log_filename
>
>
>
>  postgresql-%Y-%m-%d_%H%M%S.log
>
> log_hostname
>
>
>
>  off
>
>  log_line_prefix
>
>
>
>  %m %d %u %l %s pid:%p xid:%x ip:%h
>
>  log_lock_waits
>
>
>
>  on
>
>  log_min_duration_statement
>
>
>
> -1
>
> log_min_error_statement
>
>
>
>  error
>
>  log_min_messages
>
>
>
>  warning
>
>  log_parser_stats
>
>
>
>  off
>
>  log_planner_stats
>
>
>
>  off
>
>  log_replication_commands
>
>
>
>  on
>
>  log_rotation_age
>
>
>
>  1h
>
>  log_rotation_size
>
>
>
> 0
>
> log_statement
>
>
>
>  none
>
>  log_statement_stats
>
>
>
>  off
>
>  log_temp_files
>
>
>
> 0
>
> log_transaction_sample_rate
>
>
>
> 0
>
> log_truncate_on_rotation
>
>
>
>  on
>
>  logging_collector
>
>
>
>  on
>
> Thanks & Regards,
>
> Ishan Joshi
>
> -----Original Message-----
> From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
> Sent: Tuesday, May 19, 2020 7: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 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://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2F
>
> >
> https://eur01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.a
> mdocs.com%2F&amp;data=02%7C01%7CIshan.Joshi%40amdocs.com%7C17d82e5803e
> f4868071808d7fc004b39%7Cc8eca3ca127646d59d9da0f2a028920f%7C0%7C0%7C637
> 254950504363804&amp;sdata=zCV9eeGBWKtq73TxXMLg3va2bNmqjT6UbHiDQbkGL8Y%
> 3D&amp;reserved=0%2Fabout%2Femail-terms-of-service*&amp;data=02%7C01%7
> CIs
> <http://www.amdocs.com%2Fabout%2Femail-terms-of-service*&amp;data=02%7
> C01%7CIs>
>
> >
> han.Joshi%40amdocs.com%7C7d8dce6a7c7d4349a7ec08d7fbfcccd5%7Cc8eca3ca12
>
> >
> 7646d59d9da0f2a028920f%7C0%7C0%7C637254935514522274&amp;sdata=Gi7j8rno
>
> > ogMRCpaAWM0UuH%2FzorFKy9vnpeEfNfu1dLo%3D&amp;reserved=0
>
> >
>
> --
>
> 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://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2F
> www.amdocs.com%2Fabout%2Femail-terms-of-service*&amp;data=02%7C01%7CIs
> han.Joshi%40amdocs.com%7C17d82e5803ef4868071808d7fc004b39%7Cc8eca3ca12
> 7646d59d9da0f2a028920f%7C0%7C0%7C637254950504363804&amp;sdata=63uX3IKT
> vCMAYnfcoLpNy4eTRwox8EZ99ZN4F1kf4SM%3D&amp;reserved=0
>

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