Re: How to reset a server error '25P02 in_failed_sql_transaction'

Поиск
Список
Период
Сортировка
От Ron
Тема Re: How to reset a server error '25P02 in_failed_sql_transaction'
Дата
Msg-id 08a584b3-938d-1d74-36f3-c1cdefb9b75c@gmail.com
обсуждение исходный текст
Ответ на Re: How to reset a server error '25P02 in_failed_sql_transaction'  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-general
Дерево обсуждения
On 12/31/19 11:29 AM, David G. Johnston wrote:
On Tuesday, December 31, 2019, Ron <ronljohnsonjr@gmail.com> wrote:
But how do you issue a ROLLBACK to a different pid?

You cannot.  At that point you need to start from scratch.

 pg_terminate_backend(pid int)

And let the problematic app deal with losing its database connection however it will.

David J.

That's what I thought (and privately told OP).


--
Angular momentum makes the world go 'round.

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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: How to reset a server error '25P02 in_failed_sql_transaction'
Следующее
От: Mike Lissner
Дата:
Сообщение: How to shorten a chain of logically replicated servers