Re: How to reset a server error '25P02 in_failed_sql_transaction' - Mailing list pgsql-general

From Ron
Subject Re: How to reset a server error '25P02 in_failed_sql_transaction'
Date
Msg-id 08a584b3-938d-1d74-36f3-c1cdefb9b75c@gmail.com
Whole thread Raw
In response to Re: How to reset a server error '25P02 in_failed_sql_transaction'  ("David G. Johnston" <david.g.johnston@gmail.com>)
List 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 by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: How to reset a server error '25P02 in_failed_sql_transaction'
Next
From: Mike Lissner
Date:
Subject: How to shorten a chain of logically replicated servers