Re: pgsql: Fix a couple of bugs in MultiXactId freezing

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Cc: Noah Misch <noah(at)leadboat(dot)com>, Andres Freund <andres(at)2ndquadrant(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: pgsql: Fix a couple of bugs in MultiXactId freezing
Date: 2013-12-03 22:04:48
Message-ID: 30220.1386108288@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> writes:
> Tom Lane wrote:
>> After some discussion, the core committee has concluded that we should go
>> ahead with the already-wrapped releases. 9.2.6 and below are good anyway,
>> and despite this issue 9.3.2 is an improvement over 9.3.1. We'll plan to
>> do a 9.3.3 as soon as the multixact situation can be straightened out;
>> but let's learn from experience and not try to fix it in a panic.

> I would suggest we include this one fix in 9.3.2a. This bug is more
> serious than the others because it happens because of checking HTSU on a
> tuple containing running locker-only transactions and an aborted update.

The effect is just that the lockers could lose their locks early, right?
While that's annoying, it's not *directly* a data corruption problem.
And I've lost any enthusiasm I might've had for quick fixes in this area.
I think it'd be better to wait a few days, think this over, and get the
other problem fixed as well.

In any case, I think we're already past the point where we could re-wrap
9.3.2; the tarballs have been in the hands of packagers for > 24 hours.
We'd have to call it 9.3.3.

regards, tom lane

In response to

Browse pgsql-committers by date

  From Date Subject
Next Message Heikki Linnakangas 2013-12-03 22:16:11 pgsql: Don't include unused space in LOG_NEWPAGE records.
Previous Message Heikki Linnakangas 2013-12-03 21:33:32 pgsql: Fix full-page writes of internal GIN pages.

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2013-12-03 22:35:29 Re: [bug fix] "pg_ctl stop" times out when it should respond quickly
Previous Message Joshua D. Drake 2013-12-03 21:42:01 Re: Why we are going to have to go DirectIO