Re: Apparent Wraparound? - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Apparent Wraparound?
Date
Msg-id 20070618204441.GJ13688@alvh.no-ip.org
Whole thread Raw
In response to Re: Apparent Wraparound?  (g.hintermayer@inode.at)
Responses Re: Apparent Wraparound?
List pgsql-general
g.hintermayer@inode.at wrote:
> Aha, google thinks it's wise to make the last postings (probably if
> more than n ?) show only the poster name and make the name clickable.
> Not  very userfriendly :-( but now i know it ;-)

I don't very much understand what you mean.  I do see that you said "I
noticed the same message" that Gunther Meyer was reporting but you
weren't very explicit.  I feared that the directory mentioned was
different.

> Sorry if that wasn't clear. I'm getting the same log entry as the
> original
> poster, i.e.: LOG:  could not truncate directory "pg_subtrans":
> apparent
> wraparound.

Ok.

> I'm just running an analysis of the "daily transaction id consumption"
> on my databases to see, if the uptime of the server matches with the
> time the wraparound was logged.

Please check "MultiXact" id consumption.  Do you mean that your server
has crashed?

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-general by date:

Previous
From: "Simon Riggs"
Date:
Subject: Re: Pg_standby and shutting down the warm standby
Next
From: developer@wexwarez.com
Date:
Subject: Re: unexpected shutdown