From: Stephen Frost <sfrost@snowman.net>
To: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: Andres Freund <andres@2ndquadrant.com>
Cc: pgsql-hackers@postgresql.org
Subject: Re: MultiXactId error after upgrade to 9.3.4
Date: Mon, 31 Mar 2014 09:09:08 -0400
Message-ID: <20140331130908.GO4582@tamriel.snowman.net> (raw)
In-Reply-To: <20140331130215.GV9567@eldon.alvh.no-ip.org>
References: <20140330040029.GY4582@tamriel.snowman.net>
<20140330141135.GA4582@tamriel.snowman.net>
<20140330185349.GD4582@tamriel.snowman.net>
<20140331115452.GT9567@eldon.alvh.no-ip.org>
<20140331115713.GA18358@alap3.anarazel.de>
<20140331121912.GU9567@eldon.alvh.no-ip.org>
<20140331123030.GB18358@alap3.anarazel.de>
<20140331130215.GV9567@eldon.alvh.no-ip.org>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>
* Alvaro Herrera (alvherre@2ndquadrant.com) wrote:
> I guess I wasn't expecting that too-old values would last longer than a
> full wraparound cycle. Maybe the right fix is just to have the second
> check also conditional on allow_old.
I don't believe this was a wraparound case.
> Anyway, it's not clear to me why this database has a multixact value of
> 6 million when the next multixact value is barely above one million.
> Stephen said a wraparound here is not likely.
I don't think the xmax value is a multixact at all- I think it's
actually a regular xid, but everyone is expected to ignore it because
XMAX_IS_INVALID, yet somehow the MULTIXACT bit was also set and the new
code expects to be able to look at the xmax field even though it's
marked as invalid..
I'm going through the upgrade process again from 9.2 and will get a
stack trace.
Thanks,
Stephen
Attachments:
[application/pgp-signature] signature.asc (835B, ../20140331130908.GO4582@tamriel.snowman.net/2-signature.asc)
download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: sfrost@snowman.net, alvherre@2ndquadrant.com, andres@2ndquadrant.com
Subject: Re: MultiXactId error after upgrade to 9.3.4
In-Reply-To: <20140331130908.GO4582@tamriel.snowman.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox