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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

"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: Fri, 03 Nov 2006 05:30:16 +0100
  • Message-id: <e3b306b71615a24e1be5e713ad3df048@> <text/plain>

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



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group