Re: [GENERAL] idle in transaction, why

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: [GENERAL] idle in transaction, why
Дата
Msg-id CAKFQuwaOZPo6ArqXrJ=E1jVYxV-F9=YuY8uypyY+OymuZAKKsA@mail.gmail.com
обсуждение исходный текст
Ответ на [GENERAL] idle in transaction, why  (Rob Sargent <robjsargent@gmail.com>)
Ответы Re: [GENERAL] idle in transaction, why
Re: [GENERAL] idle in transaction, why
Список pgsql-general
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: David Pacheco
Дата:
Сообщение: [GENERAL] postmaster deadlock while logging after syslogger exited
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] idle in transaction, why