Re: pg_upgrade < 9.3 -> >=9.3 misses a step around multixacts - Mailing list pgsql-bugs

From Stuart Bishop
Subject Re: pg_upgrade < 9.3 -> >=9.3 misses a step around multixacts
Date
Msg-id CADmi=6Pu8snwG6vS4Lw8MojX4e0-hp9pkT1B1iq0DH8snR6Agw@mail.gmail.com
Whole thread Raw
In response to Re: pg_upgrade < 9.3 -> >=9.3 misses a step around multixacts  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pg_upgrade < 9.3 -> >=9.3 misses a step around multixacts
List pgsql-bugs
On 21 July 2014 00:37, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> I'm a bit inclined to not say anything about fix procedures in the release
> notes, because I'm not sure that this is a problem in the field.  If
> anybody did have a wraparound they'd be getting bleats from VACUUM, and no
> one has reported any such thing that I've heard.

I hit the issue, but Andres helped on IRC (and so started this
thread). Yes, VACUUM failing on a production server after the 9.1->9.3
upgrade was the problem. I'd assumed there was database corruption and
I had some unreadable blocks, and probably would have just rebuilt the
table if #postgresql hadn't been so helpful.


--
Stuart Bishop <stuart@stuartbishop.net>
http://www.stuartbishop.net/

pgsql-bugs by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: BUG #10972: string_agg function incorrectly concatenating varying delimiter
Next
From: Andres Freund
Date:
Subject: Re: pg_upgrade < 9.3 -> >=9.3 misses a step around multixacts