pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_upgrade hangs
5+ messages / 3 participants
[nested] [flat]
* pg_upgrade hangs
@ 2014-08-13 22:20 John Scalia <jayknowsunix@gmail.com>
2014-08-14 02:48 ` Re: pg_upgrade hangs Bruce Momjian <bruce@momjian.us>
0 siblings, 1 reply; 5+ messages in thread
From: John Scalia @ 2014-08-13 22:20 UTC (permalink / raw)
To: pgsql-admin
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?
--
Jay
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pg_upgrade hangs
2014-08-13 22:20 pg_upgrade hangs John Scalia <jayknowsunix@gmail.com>
@ 2014-08-14 02:48 ` Bruce Momjian <bruce@momjian.us>
2014-08-14 13:30 ` Re: pg_upgrade hangs John Scalia <jayknowsunix@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Bruce Momjian @ 2014-08-14 02:48 UTC (permalink / raw)
To: John Scalia <jayknowsunix@gmail.com>; +Cc: pgsql-admin
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.
--
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pg_upgrade hangs
2014-08-13 22:20 pg_upgrade hangs John Scalia <jayknowsunix@gmail.com>
2014-08-14 02:48 ` Re: pg_upgrade hangs Bruce Momjian <bruce@momjian.us>
@ 2014-08-14 13:30 ` John Scalia <jayknowsunix@gmail.com>
2014-08-14 16:57 ` Re: pg_upgrade hangs Bruce Momjian <bruce@momjian.us>
0 siblings, 1 reply; 5+ messages in thread
From: John Scalia @ 2014-08-14 13:30 UTC (permalink / raw)
To: Bruce Momjian <bruce@momjian.us>; +Cc: pgsql-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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pg_upgrade hangs
2014-08-13 22:20 pg_upgrade hangs John Scalia <jayknowsunix@gmail.com>
2014-08-14 02:48 ` Re: pg_upgrade hangs Bruce Momjian <bruce@momjian.us>
2014-08-14 13:30 ` Re: pg_upgrade hangs John Scalia <jayknowsunix@gmail.com>
@ 2014-08-14 16:57 ` Bruce Momjian <bruce@momjian.us>
2014-08-14 17:30 ` Re: pg_upgrade hangs jayknowsunix@gmail.com
0 siblings, 1 reply; 5+ messages in thread
From: Bruce Momjian @ 2014-08-14 16:57 UTC (permalink / raw)
To: John Scalia <jayknowsunix@gmail.com>; +Cc: pgsql-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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pg_upgrade hangs
2014-08-13 22:20 pg_upgrade hangs John Scalia <jayknowsunix@gmail.com>
2014-08-14 02:48 ` Re: pg_upgrade hangs Bruce Momjian <bruce@momjian.us>
2014-08-14 13:30 ` Re: pg_upgrade hangs John Scalia <jayknowsunix@gmail.com>
2014-08-14 16:57 ` Re: pg_upgrade hangs Bruce Momjian <bruce@momjian.us>
@ 2014-08-14 17:30 ` jayknowsunix@gmail.com
0 siblings, 0 replies; 5+ messages in thread
From: jayknowsunix@gmail.com @ 2014-08-14 17:30 UTC (permalink / raw)
To: Bruce Momjian <bruce@momjian.us>; +Cc: pgsql-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
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2014-08-14 17:30 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2014-08-13 22:20 pg_upgrade hangs John Scalia <jayknowsunix@gmail.com>
2014-08-14 02:48 ` Bruce Momjian <bruce@momjian.us>
2014-08-14 13:30 ` John Scalia <jayknowsunix@gmail.com>
2014-08-14 16:57 ` Bruce Momjian <bruce@momjian.us>
2014-08-14 17:30 ` jayknowsunix@gmail.com
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