Horton

Re: 2PC-induced lockup

Heikki Linnakangas <heikki@enterprisedb.com>

View thread View on postgr.es
From: Heikki Linnakangas <heikki@enterprisedb.com>
To: Andrew Sullivan <ajs@crankycanuck.ca>
Cc: pgsql-hackers@postgresql.org
Date: 2007-07-11T17:15:12Z
Lists: pgsql-hackers 
Andrew Sullivan wrote:
> On Wed, Jul 11, 2007 at 04:44:12PM +0100, Heikki Linnakangas wrote:
>> FWIW, deleting the files from pg_twophase is safe when the system is 
>> shut down.
> 
> Is it safe for the PREPAREd TRANSACTIONs?  I assume not.  That is, in
> Peter's presumably experimental case, it might be ok to delete the
> files, but on a production system, you'd violate the semantics of 2PC
> by doing this?

It's effectively the same as manually issuing a ROLLBACK PREPARED. It 
will brake the atomicity of the global transaction, if some branches of 
that global transaction in other resource managers have already been 
committed.

-- 
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com