Re: idle in transaction, why

Rob Sargent <robjsargent@xxxxxxxxx> · Mon, 6 Nov 2017 13:18:47 -0700



    On 11/06/2017 01:09 PM, David G.
      Johnston wrote:

    
        On Mon, Nov 6, 2017 at
            12:32 PM, Rob Sargent <robjsargent@xxxxxxxxx> wrote:

        
                Using postgres 10-beta3 (hopefully 10.0 this
                    week) on virtual CentOS7 and this JDBC driver
                    postgresql:42.1.4

                  
                The postgresql.conf file has 

                  
                  #idle_in_transaction_session_timeout =
                      0        # in milliseconds, 0 is disabled
                
              
            There are
              numerous places where default settings can be configured.
            

            https://www.postgresql.org/docs/10/static/config-setting.html

            
            You should probably login as your
                application user and do "show
                idle_in_transaction_session_timeout" to see what a clean
                session has for a value and then figure out from there
                where that value is coming from.
            

            David J.
            

    From logging in with the application role I get

    
    coon=> show idle_in_transaction_session_timeout;

       idle_in_transaction_session_timeout 

      -------------------------------------

       0

      (1 row)