Horton

2PC-induced lockup

Peter Eisentraut <peter_e@gmx.net>

View thread View on postgr.es
From: Peter Eisentraut <peter_e@gmx.net>
To: pgsql-hackers@postgresql.org
Date: 2007-07-10T13:14:59Z
Lists: pgsql-hackers 
The following command sequence appears to lock up the database system:

BEGIN;
LOCK pg_authid;
PREPARE TRANSACTION 'foo';
\q

After that you can't connect anymore, even in single-user mode.  The only way 
I could find is to clear out the pg_twophase directory, but I'm not sure 
whether it is safe to do that.

Should this be prevented somehow, and is there a better recovery path?

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/