From: Bruce Momjian <bruce@momjian.us>
To: John Scalia <jayknowsunix@gmail.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: pg_upgrade hangs
Date: Thu, 14 Aug 2014 12:57:55 -0400
Message-ID: <20140814165755.GC7858@momjian.us> (raw)
In-Reply-To: <53ECB9E5.6000004@gmail.com>
References: <53EBE4B6.5030904@gmail.com>
<20140814024821.GB7858@momjian.us>
<53ECB9E5.6000004@gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
On Thu, Aug 14, 2014 at 09:30:13AM -0400, John Scalia wrote:
> Well, it's now gotten much worse, and I really do not understand how
> this is failing. I started off this morning trying to run pg_grade
> with strace in the hope that I could find something hanging up, but
> pg-upgrade is now failing and exiting very early. Almost immediately
> after reporting "Checking cluster versions ok", it throws a SQL
> command failed where it tried to create the temporary table
> 'info_rels'. The error is that type "info_rels" already exists.
>
> My first thought was that a previous attempt had partially succeeded
> and left some garbage in the new 9.3 instance. So, I deleted
> everything in the 9.3 data directory and did a new initdb there, but
> the problem continues to reoccur. I have since checked the old 9.2
> database, including the template1 portion, but I don't see an
> info_rels table in any of these. (I checked using "select * from
> pg_tables;") I'd really like to know why it's failing here. Where is
> it finding this info_rels table and why can't I find it? Is it
> deleting it after it spits out this error? And is this table
> something that gets repeatedly created and dropped during a
> pg_upgrade?
Well, you managed to show me nothing, so I can't really help you
further. info_rels is an internal C struture so I can't guess what is
failing. I suggest you show the error, and read the message and then
look in the log file it recommends, if any.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their own god. +
--
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, jayknowsunix@gmail.com
Subject: Re: pg_upgrade hangs
In-Reply-To: <20140814165755.GC7858@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