Re: "recovering prepared transaction" after serverrestart message - Mailing list pgsql-hackers

From Tom Lane
Subject Re: "recovering prepared transaction" after serverrestart message
Date
Msg-id 1886.1162564922@sss.pgh.pa.us
Whole thread Raw
In response to Re: "recovering prepared transaction" after serverrestart message  ("Simon Riggs" <simon@2ndquadrant.com>)
Responses Re: "recovering prepared transaction" after serverrestart
Re: "recovering prepared transaction" after serverrestart message
List pgsql-hackers
"Simon Riggs" <simon@2ndquadrant.com> writes:
> We only care when they break, otherwise its just situation normal, yes?

No, the trouble case is where the XA manager that owns the transaction
has forgotten about it.

> Is there a way to see prepared transactions where the original session
> that prepared then has died? Perhaps the message at startup should be
> "you have at least one prepared transaction that needs resolution".

I am completely baffled by this focus on database startup time.  That's
not where the problem is.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: [PATCHES] WAL logging freezing
Next
From: Richard Troy
Date:
Subject: Re: "recovering prepared transaction" after serverrestart