From: jayknowsunix@gmail.com
To: Bruce Momjian <bruce@momjian.us>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: pg_upgrade hangs
Date: Thu, 14 Aug 2014 13:30:05 -0400
Message-ID: <F5304C38-D3DF-4999-B1AC-5B688730F7DF@gmail.com> (raw)
In-Reply-To: <20140814165755.GC7858@momjian.us>
References: <53EBE4B6.5030904@gmail.com>
<20140814024821.GB7858@momjian.us>
<53ECB9E5.6000004@gmail.com>
<20140814165755.GC7858@momjian.us>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Well, I'd pull the log for you, but the team has taken the VM offline and is trying to replace it. I'll see when they get the new one built if any of this starts to repeat.
Sent from my iPad
> On Aug 14, 2014, at 12:57 PM, Bruce Momjian <bruce@momjian.us> wrote:
>
>> 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: jayknowsunix@gmail.com, bruce@momjian.us
Subject: Re: pg_upgrade hangs
In-Reply-To: <F5304C38-D3DF-4999-B1AC-5B688730F7DF@gmail.com>
* 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