Skip site navigation (1) Skip section navigation (2)

"recovering prepared transaction" after server restart message

From: "Joachim Wieland" <joe(at)mcknight(dot)de>
To: pgsql-hackers(at)postgresql(dot)org
Subject: "recovering prepared transaction" after server restart message
Date: 2006-11-03 04:30:16
Message-ID: e3b306b71615a24e1be5e713ad3df048@ (view raw or flat)
Thread:
Lists: pgsql-docspgsql-hackers
There have been several reports that people could not vacuum any more or
observed strange locks even after server restart. The reason was that they
still had uncommitted prepared transactions around.


I wonder if it could help to change the log level from

    ereport(LOG,
            (errmsg("recovering prepared transaction %u", xid)));

to WARNING maybe in order to make that message more striking within the
normal startup messages.



Joachim

Responses

pgsql-docs by date

Next:From: Tom LaneDate: 2006-11-03 06:48:05
Subject: Re: "recovering prepared transaction" after server restart message
Previous:From: Chris BrowneDate: 2006-10-30 17:23:18
Subject: Re: [HACKERS] Replication documentation addition

pgsql-hackers by date

Next:From: Joshua D. DrakeDate: 2006-11-03 04:34:14
Subject: Re: [HACKERS] bug in timestamp and out of range values
Previous:From: Joshua D. DrakeDate: 2006-11-03 04:27:46
Subject: Re: [HACKERS] bug in timestamp and out of range values

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group