Received: from localhost (maia-3.hub.org [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id 6EEE79FB885
	for <pgsql-hackers-postgresql.org@postgresql.org>;
	Wed, 14 Feb 2007 00:19:59 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024)
	with ESMTP id 70420-10 for
	<pgsql-hackers-postgresql.org@postgresql.org>;
	Wed, 14 Feb 2007 00:19:55 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from momjian.us (momjian.us [70.90.9.53])
	by postgresql.org (Postfix) with ESMTP id 2F6799FB86E
	for <pgsql-hackers@postgresql.org>;
	Wed, 14 Feb 2007 00:19:55 -0400 (AST)
Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id
 l1E4Jq213737;
	Tue, 13 Feb 2007 23:19:52 -0500 (EST)
From: Bruce Momjian <bruce@momjian.us>
Message-Id: <200702140419.l1E4Jq213737@momjian.us>
Subject: Re: "recovering prepared transaction" after server
 restart message
In-Reply-To: <e3b306b71615a24e1be5e713ad3df048@>
To: joe@mcknight.de
Date: Tue, 13 Feb 2007 23:19:52 -0500 (EST)
CC: pgsql-hackers@postgresql.org
X-Mailer: ELM [version 2.4ME+ PL123]
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset="US-ASCII"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.051 tagged_above=0 required=5 tests=AWL, BAYES_50,
	SPF_HELO_PASS, SPF_PASS
X-Spam-Level: 
X-Archive-Number: 200702/776
X-Sequence-Number: 98329


Added to TODO:

	* Improve logging of prepared statements recovered during startup
	
	  http://archives.postgresql.org/pgsql-hackers/2006-11/msg00092.php



---------------------------------------------------------------------------

Joachim Wieland wrote:
> 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
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
> 
>                http://archives.postgresql.org

-- 
  Bruce Momjian  <bruce@momjian.us>          http://momjian.us
  EnterpriseDB                               http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +