Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 251949FB207 for ; Wed, 22 Nov 2006 23:50:33 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 81601-07 for ; Thu, 23 Nov 2006 03:50:29 +0000 (UTC) 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 CE95D9FA465 for ; Wed, 22 Nov 2006 23:50:28 -0400 (AST) Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id kAN3oPL09521; Wed, 22 Nov 2006 22:50:25 -0500 (EST) From: Bruce Momjian Message-Id: <200611230350.kAN3oPL09521@momjian.us> Subject: Re: "recovering prepared transaction" after server In-Reply-To: To: joe@mcknight.de Date: Wed, 22 Nov 2006 22:50:25 -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-Archive-Number: 200611/636 X-Sequence-Number: 94098 This thread been saved for the 8.3 release: http://momjian.postgresql.org/cgi-bin/pgpatches_hold --------------------------------------------------------------------------- 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 EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +