From: Tom Lane <tgl@sss.pgh.pa.us>
To: Vincent Lau <vincent.lau@rentrakmail.com>
cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: 0-byte 2PC File
In-reply-to: 
 <CAF_O_rm3fxuYzRx8=kg0RUGjw+=PaZ0+p1V2=5PSYu9wLrZtQQ@mail.gmail.com>
References: 
 <CAF_O_rm3fxuYzRx8=kg0RUGjw+=PaZ0+p1V2=5PSYu9wLrZtQQ@mail.gmail.com>
Comments: In-reply-to Vincent Lau <vincent.lau@rentrakmail.com>
 message dated "Sat, 13 Jul 2013 16:41:23 -0700"
Date: Sun, 14 Jul 2013 12:19:34 -0400
Message-ID: <16424.1373818774@sss.pgh.pa.us>
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Vincent Lau <vincent.lau@rentrakmail.com> writes:
> We are running 8.4.13 on this particular database and recently we have been
> getting empty two phase commit state files inside the pg_twophase
> directory. These prepared transactions can't be rolled back due to the
> empty state file. Here is an example of the error message.

> ERROR:  two-phase state file for transaction 121421120 is corrupt

> The only way to get rid of this is to restart the database, which is just a
> bandaid solution at this point.

Is there a waiting transaction corresponding to that file?  If not you
could just manually remove the file, I think.  Not that that isn't a
band-aid, but it'd be less painful than a restart.

Do you see any error messages logged at the time the transaction PREPARE
is attempted?

			regards, tom lane


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin