Re: Max connections reached without max connections reached

Поиск
Список
Период
Сортировка
От Rob Sargent
Тема Re: Max connections reached without max connections reached
Дата
Msg-id 5c97384a-4481-74bf-94c7-145e0c3f1d5b@gmail.com
обсуждение исходный текст
Ответ на Re: Max connections reached without max connections reached  (Michael Lewis <mlewis@entrata.com>)
Ответы Re: Max connections reached without max connections reached  (Michael Lewis <mlewis@entrata.com>)
Список pgsql-general
Дерево обсуждения
On 12/1/21 7:08 PM, Michael Lewis wrote:
On Wed, Dec 1, 2021 at 3:52 PM Rob Sargent <robjsargent@gmail.com> wrote:
Also be on the look-out for begin trans; begin trans; etc  I read Kumar's report as nested transactions.  If your gang is doing a transaction per row, they need a kick in the rear.  Anyone not closing those needs a pink slip. 

I have seen the second attempt at calling begin seem to be ignored with "WARNING:  there is already a transaction in progress" similar to calling rollback without a transaction open. Are you stating or suggesting that calling begin a second time actually is more similar to creating a savepoint? That would be rather unexpected from the messaging, at least for me.
No.  Hard to know what the devs are up to here (what stack they're using, etc), but I'm suggesting one transaction is getting started and not closed. Warnings have been know to be ignored.  I admit I am not familiar with Kumar's term of "sub-transaction" and how those might be created but it sounds to me like a transaction is begun early in the processing and more work happens unaware of the transaction.  And possible not committed.

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

Предыдущее
От: Yi Sun
Дата:
Сообщение: Re: ssl_crl_file Certificate Revocation List doesn't work for postgresql 11
Следующее
От: Dilip Kumar
Дата:
Сообщение: Re: Max connections reached without max connections reached