"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@
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-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

Browse pgsql-docs by date

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

Browse pgsql-hackers by date

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