From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Andres Freund <andres@anarazel.de>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Marko Tiikkaja <marko@joh.to>
Cc: Andres Freund <andres@2ndquadrant.com>
Cc: hackers <pgsql-hackers@postgresql.org>
Subject: Re: ERROR: cannot GetMultiXactIdMembers() during recovery
Date: Mon, 18 May 2015 14:36:23 -0300
Message-ID: <20150518173623.GS2523@alvh.no-ip.org> (raw)
In-Reply-To: <20150518172147.GX9584@alap3.anarazel.de>
References: <54EB3283.2080305@joh.to>
<20150223141300.GB30784@awork2.anarazel.de>
<5555F1E2.5080104@joh.to>
<20150518164803.GP2523@alvh.no-ip.org>
<22166.1431968387@sss.pgh.pa.us>
<20150518171351.GR2523@alvh.no-ip.org>
<20150518172147.GX9584@alap3.anarazel.de>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>
Andres Freund wrote:
> On 2015-05-18 14:13:51 -0300, Alvaro Herrera wrote:
> > Hmm, AFAICS the problematic check was introduced by this commit:
> >
> > commit 9f1e051adefb2f29e757cf426b03db20d3f8a26d
> > Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
> > Date: Fri Nov 29 11:26:41 2013 -0300
> >
> > so it isn't hot off the oven, but it is a regression.
>
> Hasn't that just changed the symptoms? I don't recall exactly, but my
> recollection is that the multixact code isn't ready at that point and
> hasn't initialized a bunch of important variables yet. Leading to errors
> in the SLRU etc.
Not sure about that. The page limits etc aren't set yet so you can't
create new multis, nor truncate appropriately, but just reading one
should have worked.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
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: alvherre@2ndquadrant.com, andres@anarazel.de, tgl@sss.pgh.pa.us, marko@joh.to, andres@2ndquadrant.com
Subject: Re: ERROR: cannot GetMultiXactIdMembers() during recovery
In-Reply-To: <20150518173623.GS2523@alvh.no-ip.org>
* 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