Search Postgresql Archives

Re: Apparent Wraparound?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



g.hintermayer@xxxxxxxx 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux