Search Postgresql Archives

RE: idle_in_transaction_session_timeout not getting log in PG v12.2

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

 

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.klaver@xxxxxxxxxxx>
Sent: Tuesday, May 19, 2020 7: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 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="">

> www.amdocs.com%2Fabout%2Femail-terms-of-service*&amp;data="">

> han.Joshi%40amdocs.com%7C7d8dce6a7c7d4349a7ec08d7fbfcccd5%7Cc8eca3ca12

> 7646d59d9da0f2a028920f%7C0%7C0%7C637254935514522274&amp;sdata=Gi7j8rno

> ogMRCpaAWM0UuH%2FzorFKy9vnpeEfNfu1dLo%3D&amp;reserved=0

>

 

 

--

Adrian Klaver

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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux