From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Simon Riggs <simon@2ndQuadrant.com>
Cc: Andres Freund <andres@2ndquadrant.com>
Cc: Marko Tiikkaja <marko@joh.to>
Cc: hackers <pgsql-hackers@postgresql.org>
Subject: Re: ERROR: cannot GetMultiXactIdMembers() during recovery
Date: Mon, 18 May 2015 17:45:46 -0300
Message-ID: <20150518204546.GU2523@alvh.no-ip.org> (raw)
In-Reply-To: <CANP8+jLv=rFMCXM+V8m9WiTT+8tspmyeh2FtxC6u+3nW6shoTw@mail.gmail.com>
References: <54EB3283.2080305@joh.to>
<20150223141300.GB30784@awork2.anarazel.de>
<20150515180335.GE2523@alvh.no-ip.org>
<CANP8+jLv=rFMCXM+V8m9WiTT+8tspmyeh2FtxC6u+3nW6shoTw@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>
Simon Riggs wrote:
> On 15 May 2015 at 19:03, Alvaro Herrera <alvherre@2ndquadrant.com> wrote:
>
> > Andres Freund wrote:
> >
> > > Alternatively we could make MultiXactIdIsRunning() return false < 9.3
> > > when in recovery. I think that'd end up fixing things, but it seems
> > > awfully fragile to me.
> >
> > Hm, why fragile? It seems a pretty decent answer -- pre-9.3, it's not
> > possible for a tuple to be "locked" in recovery, is it? I mean, in the
> > standby you can't lock it nor update it; the only thing you can do is
> > read (select), and that is not affected by whether there is a multixact
> > in it.
>
> It can't return true and won't ever change for <9.3 so I don't see what the
> objection is.
Pushed.
--
Á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, simon@2ndQuadrant.com, andres@2ndquadrant.com, marko@joh.to
Subject: Re: ERROR: cannot GetMultiXactIdMembers() during recovery
In-Reply-To: <20150518204546.GU2523@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