From: Bruce Momjian <bruce@momjian.us>
To: Guo, Yun <YGuo@cvent.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: pg_upgrade from 9.3 to 9.4 fails
Date: Mon, 5 Oct 2015 13:24:18 -0400
Message-ID: <20151005172418.GA6784@momjian.us> (raw)
In-Reply-To: <D2381B7B.48445%yguo@cvent.com>
References: <D2381B50.48442%yguo@cvent.com>
<D2381B7B.48445%yguo@cvent.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
On Mon, Oct 5, 2015 at 05:05:46PM +0000, Guo, Yun wrote:
> -bash-4.1$ /usr/pgsql-9.3/bin/pg_ctl stop -D /data/pg.old
> waiting for server to shut down.... done
> server stopped
> -bash-4.1$ pg_upgrade -b /usr/pgsql-9.3/bin -B /usr/pgsql-9.4/bin -d /data/
> pg.old -D /data/pg --check
> Performing Consistency Checks
> -----------------------------
> Checking cluster versions ok
> SQL command failed
> CREATE TEMPORARY TABLE info_rels (reloid) AS SELECT c.oid FROM
> pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON c.relnamespace =
> n.oid LEFT OUTER JOIN pg_catalog.pg_index i ON c.oid = i.indexrelid WHERE
> relkind IN ('r', 'm', 'i', 'S') AND i.indisvalid IS DISTINCT FROM false AND
> i.indisready IS DISTINCT FROM false AND ((n.nspname !~ '^pg_temp_' AND
> n.nspname !~ '^pg_toast_temp_' AND n.nspname NOT IN ('pg_catalog',
> 'information_schema', 'binary_upgrade', 'pg_toast') AND c.oid >= 16384) OR
> (n.nspname = 'pg_catalog' AND relname IN ('pg_largeobject',
> 'pg_largeobject_loid_pn_index', 'pg_largeobject_metadata',
> 'pg_largeobject_metadata_oid_index') ));
> ERROR: cache lookup failed for type 1670699
Wow, that is weird. Can you run this query on the old cluster and show
us the output?
SELECT * FROM pg_type WHERE oid = 1670699;
This query doesn't even query pg_type, so it must be some internal use
of pg_type.
The reason check doesn't show the failure is that only a non-check run
collects pg_class.oid values, but we never expect that to fail so we
don't test it in check mode.
My guess is that something is messed up in your system catalogs. Can
you try running this query in each old database and see if it fails.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Roman grave inscription +
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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-admin@postgresql.org
Cc: bruce@momjian.us, YGuo@cvent.com
Subject: Re: pg_upgrade from 9.3 to 9.4 fails
In-Reply-To: <20151005172418.GA6784@momjian.us>
* 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