Postgres Pro
Downloads
Home   >   mailing lists

Re: MultiXact member wraparound protections are disabled - Mailing list pgsql-general

From AnandKumar, Karthik
Subject Re: MultiXact member wraparound protections are disabled
Date
Msg-id 292A3584-86CE-4CF3-8B4F-9703439BBB64@classmates.com
Whole thread Raw
In response to Re: MultiXact member wraparound protections are disabled  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-general
Tree view 
Thank you for your help Alvaro - we really appreciate it.
The error in fact stopped this morning - we took downtime and ran a vacuum across all of our tables, and saw increased
autovacuum activity as well.
 

It looks like it bumped up the oldest multitxid to something other than 1 now:

postgres@site-db01a:~ $ /usr/pgsql-9.4/bin/pg_controldata /var/lib/pgsql/cmates/data | grep -i multi 
Latest checkpoint's NextMultiXactId: 785051 
Latest checkpoint's NextMultiOffset: 1446371 
Latest checkpoint's oldestMultiXid: 575211 
Latest checkpoint's oldestMulti's DB: 12998

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Issue with installation of postgresql server
Next
From: "Jaisingkar, Piyush"
Date:
Subject: Re: Passing of where clause to remote table in FDW