Re: assertion failure 9.3.4 - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: assertion failure 9.3.4
Date
Msg-id 20140424202114.GC25695@eldon.alvh.no-ip.org
Whole thread Raw
In response to Re: assertion failure 9.3.4  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
Alvaro Herrera wrote:
> Alvaro Herrera wrote:
> 
> > I'm thinking about the comparison of full infomask as you propose
> > instead of just the bits that we actually care about.   I think the only
> > thing that could cause a spurious failure (causing an extra execution of
> > the HeapTupleSatisfiesUpdate call and the stuff below) is somebody
> > setting HEAP_XMIN_COMMITTED concurrently; but that seems infrequent
> > enough that it should pretty harmless.  However, should we worry about
> > possible future infomask bit changes that could negatively affect this
> > behavior?
> 
> Here's a complete patch illustrating what I mean.  This is slightly more
> expensive than straight infomask comparison in terms of machine
> instructions, but that seems okay to me.

I have pushed a slightly tweaked version of this, after verifying that
it solves the problem in Andrew's test environment.

Josh, if you could verify that it solves the problem for you too, it'd
be great.

Thanks for the report and test case.

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



pgsql-hackers by date:

Previous
From: Christopher Browne
Date:
Subject: Re: UUIDs in core WAS: 9.4 Proposal: Initdb creates a single table
Next
From: Andres Freund
Date:
Subject: Re: slow startup due to LWLockAssign() spinlock