pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Andres Freund <andres@2ndquadrant.com>
To: Stuart Bishop <stuart@stuartbishop.net>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Bruce Momjian <bruce@momjian.us>
Cc: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: PostgreSQL Bugs <pgsql-bugs@postgresql.org>
Subject: Re: pg_upgrade < 9.3 -> >=9.3 misses a step around multixacts
Date: Tue, 22 Jul 2014 11:27:51 +0200
Message-ID: <20140722092751.GF4629@alap3.anarazel.de> (raw)
In-Reply-To: <CADmi=6Pu8snwG6vS4Lw8MojX4e0-hp9pkT1B1iq0DH8snR6Agw@mail.gmail.com>
References: <20140619220425.GQ18688@eldon.alvh.no-ip.org>
	<20140620010653.GS18688@eldon.alvh.no-ip.org>
	<20140620180725.GD29143@momjian.us>
	<20140624201346.GB17110@momjian.us>
	<20140627210520.GP7340@eldon.alvh.no-ip.org>
	<20140701161419.GA16033@momjian.us>
	<20140701190105.GA7340@eldon.alvh.no-ip.org>
	<20140701193047.GB16033@momjian.us>
	<9879.1405877821@sss.pgh.pa.us>
	<CADmi=6Pu8snwG6vS4Lw8MojX4e0-hp9pkT1B1iq0DH8snR6Agw@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-bugs>

On 2014-07-22 16:08:37 +0700, Stuart Bishop wrote:
> 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.

This is actually a second problem that came up during the investigation
of the problem you had - with different symptoms and causes... IIRC it's
not what you've experienced.

If you look at
http://www.postgresql.org/docs/devel/static/release-9-3-5.html your
problem should be described.

Greetings,

Andres Freund

-- 
 Andres Freund	                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs



view thread (78+ messages)  latest in thread

Message-ID: <20140722092751.GF4629@alap3.anarazel.de>
Permalink:  ../20140722092751.GF4629@alap3.anarazel.de/
Also on:    postgresql.org/message-id/20140722092751.GF4629@alap3.anarazel.de

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: andres@2ndquadrant.com, stuart@stuartbishop.net, tgl@sss.pgh.pa.us, bruce@momjian.us, alvherre@2ndquadrant.com
  Subject: Re: pg_upgrade < 9.3 -> >=9.3 misses a step around multixacts
  In-Reply-To: <20140722092751.GF4629@alap3.anarazel.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox