Date: Wed, 18 Jun 2014 21:52:05 -0400
From: Bruce Momjian <bruce@momjian.us>
To: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: Andres Freund <andres@2ndquadrant.com>,
 PostgreSQL Bugs <pgsql-bugs@postgresql.org>
Subject: Re: pg_upgrade < 9.3 -> >=9.3 misses a step around
 multixacts
Message-ID: <20140619015205.GD3806@momjian.us>
References: <20140530121631.GE25431@alap3.anarazel.de>
 <20140530132916.GM28490@momjian.us>
 <20140618225131.GN18688@eldon.alvh.no-ip.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <20140618225131.GN18688@eldon.alvh.no-ip.org>
User-Agent: Mutt/1.5.20 (2009-06-14)
Precedence: bulk
Sender: pgsql-bugs-owner@postgresql.org

On Wed, Jun 18, 2014 at 06:51:31PM -0400, Alvaro Herrera wrote:
> > This is a bug in 9.3 pg_upgrade as well?  Why has no one reported it
> > before?
> 
> I think one reason is that not all upgrades see an issue here; for old
> clusters that haven't gone beyond the 0000 offset file, there is no
> problem.  For clusters that have gone beyond 0000 but not by much, the
> file will be deleted during the first truncation.  It only becomes a
> problem if the cluster is close enough to 2^31.  Another thing to keep
> in consideration is that initdb initializes all databases' datminmxid to
> 1.  If the old cluster was past the 2^31 point, it means the datminmxid
> doesn't move from 1 until the actual wraparound.

OK, so the xid has to be beyond 2^31 during pg_upgrade to trigger a
problem?  That might explain the rare reporting of this bug.  What would
the test query look like so we can tell people when to remove the '0000'
files?  Would we need to see the existence of '0000' and high-numbered
files?  How high?  What does a 2^31 file look like?

Also, is there a reason you didn't remove the 'members/0000' file in your
patch?  I have removed it in my version.

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs