Re: Apparent Wraparound?

g(dot)hintermayer(at)inode(dot)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