From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | joe(at)mcknight(dot)de |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: "recovering prepared transaction" after server restart message |
Date: | 2007-02-14 04:19:52 |
Message-ID: | 200702140419.l1E4Jq213737@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs pgsql-hackers |
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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2007-02-19 18:57:45 | Re: Online documentation unclear about authentication defaults |
Previous Message | Tom Lane | 2007-02-12 15:13:45 | Re: 'FOUND' keyword not found in index (pg8.2) |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2007-02-14 04:24:32 | Re: Various breakages in new contrib/isn module |
Previous Message | Bruce Momjian | 2007-02-14 04:04:34 | Re: [BUGS] BUG #2724: Could not check connection status with "ssl=on" |