Re: pg_upgrade hangs

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxx> 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@xxxxxxxxxx>        http://momjian.us
>  EnterpriseDB                             http://enterprisedb.com
> 
>  + Everyone has their own god. +


-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin





[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux