Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] idle in transaction, why - Mailing list pgsql-general

From David G. Johnston
Subject Re: [GENERAL] idle in transaction, why
Date
Msg-id CAKFQuwaOZPo6ArqXrJ=E1jVYxV-F9=YuY8uypyY+OymuZAKKsA@mail.gmail.com
Whole thread Raw
In response to [GENERAL] idle in transaction, why  (Rob Sargent <robjsargent@gmail.com>)
Responses Re: [GENERAL] idle in transaction, why  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: [GENERAL] idle in transaction, why  (Rob Sargent <robjsargent@gmail.com>)
List pgsql-general
Tree view
On Mon, Nov 6, 2017 at 12:32 PM, Rob Sargent <robjsargent@gmail.com> 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.

pgsql-general by date:

Previous
From: David Pacheco
Date:
Subject: [GENERAL] postmaster deadlock while logging after syslogger exited
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] idle in transaction, why