Re: MultiXactId error after upgrade to 9.3.4

Bruce Momjian wrote:
> 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?

You're right, it does.  I am not sure I would apply it.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services