From: John Scalia <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 09:30:13 -0400
Message-ID: <53ECB9E5.6000004@gmail.com> (raw)
In-Reply-To: <20140814024821.GB7858@momjian.us>
References: <53EBE4B6.5030904@gmail.com>
<20140814024821.GB7858@momjian.us>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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?
Very confusing,
Jay
On 8/13/2014 10:48 PM, Bruce Momjian wrote:
> On Wed, Aug 13, 2014 at 06:20:38PM -0400, John Scalia wrote:
>> Hi all,
>>
>> My QA folks are doing an upgrade test, migrating a database from 9.2.2 to 9.3.3. By default on CentOS, the databases live at:
>>
>> /var/lib/pgsql/9.2/data & /var/lib/pgsql/9.3/data
>>
>> But, they've decided to move these to /data/postgres-9.2/data and
>> /data/postgres-9.3/data and use symlinks back to the original
>> locations, so they don't have to modify the /etc/init.d scripts.
>> Now, pg_upgrade is just hangs regardless of whether I use the actual
>> physical locations or the symlinked ones. I haven't yet tried
>> attaching "strace" to the process, but is there any reason to
>> believe that the symlinks might be causing the problem? Or do I need
>> to look at something else?
> I have no idea. I have never heard of that, but I suggest you figure
> out why the hang is happening independent of pg_upgrade.
>
--
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: <53ECB9E5.6000004@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