Re: Posgresql-13 Bug (idle_in_transaction_session_timeout)

Поиск
Список
Период
Сортировка
От Masahiko Sawada
Тема Re: Posgresql-13 Bug (idle_in_transaction_session_timeout)
Дата
Msg-id CAD21AoCfiMz-QCrWVvgrjtOErZ0WVw9TkXBwMqmOE=2C5MfNDA@mail.gmail.com
обсуждение исходный текст
Ответ на RE: Posgresql-13 Bug (idle_in_transaction_session_timeout)  (Ram Pratap Maurya <ram.maurya@lavainternational.in>)
Список pgsql-bugs
Hi,

On Wed, May 11, 2022 at 6:19 PM Ram Pratap Maurya
<ram.maurya@lavainternational.in> wrote:
>
> Hi Team,
>
>
>
> As per in screen shot in each process occupies a scission that why our server unable to new request in postgres.
>
> Please susggest what is solution of idel query.
>

You need to either terminate unused sessions or increase
max_connections[1] to accept new connections.

This list is for bug reports and it's not a bug. Please ask questions
on pgsql-general mailing list.

[1] https://www.postgresql.org/docs/13/runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS

--
Masahiko Sawada
EDB:  https://www.enterprisedb.com/



В списке pgsql-bugs по дате отправления:

Предыдущее
От: Ram Pratap Maurya
Дата:
Сообщение: RE: Posgresql-13 Bug (idle_in_transaction_session_timeout)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #17479: "plan should not reference subplan's variable" when calling `grouping` on result of subquery