Horton

Re: 2PC-induced lockup

Heikki Linnakangas <heikki@enterprisedb.com>

View thread View on postgr.es
From: Heikki Linnakangas <heikki@enterprisedb.com>
To: Chris Browne <cbbrowne@acm.org>
Cc: pgsql-hackers@postgresql.org
Date: 2007-07-11T15:44:12Z
Lists: pgsql-hackers 
Chris Browne wrote:
> If one locks certain vital system resources, as part of that PREPAREd
> transaction, that evidently causes some problems, alas...
> 
> The right resolution to this is not, a priori, evident yet.

It's not? I agree with Tom here; this is just one of the numerous things 
you can do to screw up your database as a superuser. Why would you LOCK 
the pg_auth table, or any other system table for that matter, in the 
first place? Let alone in a distributed transaction.

FWIW, deleting the files from pg_twophase is safe when the system is 
shut down.

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