Re: MultiXactId error after upgrade to 9.3.4

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Cc: Andres Freund <andres(at)2ndquadrant(dot)com>, Stephen Frost <sfrost(at)snowman(dot)net>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: MultiXactId error after upgrade to 9.3.4
Date: 2014-04-23 18:47:16
Message-ID: 20140423184716.GA22722@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Apr 23, 2014 at 03:42:14PM -0300, Alvaro Herrera wrote:
> > > I still don't know under what circumstances this situation could arise.
> > > This seems most strange to me. I would wonder about this to be just
> > > papering over a different bug elsewhere, except that we know this tuple
> > > comes from a pg_upgraded table and so I think the only real solution is
> > > to cope.
> >
> > Shouldn't we log something at least if we are unsure of the cause?
>
> I don't know. Is it possible that XMAX_IS_MULTI got set because of
> cosmic rays? At this point that's the only explanation that makes sense
> to me. And I'm not sure what to do about this until we know more --
> more user reports of this problem, for instance.
>
> I don't see any reasonable way to distinguish this particular kind of
> multixact-out-of-bounds situation from any other, so not sure what else
> to log either (you can see that we already emit an error message.)

I guess I am lost then. I thought it supressed the error. What does
the patch do?

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ Everyone has their own god. +

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2014-04-23 18:51:21 Re: MultiXactId error after upgrade to 9.3.4
Previous Message Alvaro Herrera 2014-04-23 18:42:14 Re: MultiXactId error after upgrade to 9.3.4