pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Gopal Srinivasa <srinivgo@india.hp.com>
To: pgsql-admin@postgresql.org
Subject: pg_restore hangs on 'some' HP-UX machines
Date: Thu, 14 Jul 2005 22:05:24 +0530
Message-ID: <200507141633.WAA06096@redsea.india.hp.com> (raw)

Hi,

I am using PostgreSQL 7.4.2 on HP-UX systems. I am trying to pg_restore a
dump created using pg_dump with the following command-line:
 pg_dump -Fc -fcerdump -Uemt -p10864 cer

The dump only has one table "emt_str", with integers and strings as its
attributes. Essentially, the table stores some strings used by our
application. It has around 250+ records.

When I run pg_restore (this is on a different machine), pg_restore creates
the schema, but hangs while inserting data. The command-line I am using is:
 pg_restore -d cer -Uemt -p10864 cerdump

The 'funny' thing is that it works perfectly on some HP-UX systems and hangs
on some others. I've seen it happen on both IA and PA architectures. Also,
sometimes deleting some strings and restoring works, but the process is not
repeatable.

I attached gdb to the pg_restore process and here is the output of "bt":

(gdb) attach 9249
Attaching to program: /opt/iexpress/postgresql/bin/pg_restore, process 9249
0x60000000c058d890:0 in _poll_sys+0x30 () from /usr/lib/hpux32/libc.so.1
(gdb) bt
#0  0x60000000c058d890:0 in _poll_sys+0x30 () from /usr/lib/hpux32/libc.so.1
#1  0x60000000c05a2860:0 in poll+0x120 () from /usr/lib/hpux32/libc.so.1
#2  0x60000000c189ee90:0 in pqSocketPoll+0x120 ()
   from /usr/lib/hpux32/libpq.so.3
#3  0x60000000c189ec10:0 in pqSocketCheck+0xb0 ()
   from /usr/lib/hpux32/libpq.so.3
#4  0x60000000c189ea60:0 in pqWaitTimed+0x40 () from
/usr/lib/hpux32/libpq.so.3
#5  0x60000000c189ea00:0 in pqWait+0x40 () from /usr/lib/hpux32/libpq.so.3
#6  0x60000000c189e6f0:0 in pqSendSome+0x150 () from
/usr/lib/hpux32/libpq.so.3
#7  0x60000000c18ab5a0:0 in pqEndcopy3+0x60 () from
/usr/lib/hpux32/libpq.so.3
#8  0x60000000c189a620:0 in PQendcopy+0x70 () from
/usr/lib/hpux32/libpq.so.3
#9  0x4019ef0:0 in _sendCopyLine+0x230 ()
#10 0x401a620:0 in ExecuteSqlCommandBuf+0x80 ()
#11 0x4013740:0 in ahwrite+0x2f0 ()
#12 0x401cdf0:0 in _PrintData+0x260 ()
#13 0x401c940:0 in _PrintTocData+0x2a0 ()
#14 0x4010540:0 in RestoreArchive+0xb30 ()
#15 0x400e960:0 in main+0xa80 ()

Another thing that happens is that postmaster always (well, almost always)
starts up saying 
FATAL:  the database system is starting up

I looked in the source code and saw that the canAcceptConnections function
in postmaster.c is returning CAC_STARTUP. Now, I don't have any applications
trying to connect when postmaster starts, so I am lost trying to figure out
why this is happening.

We are using PostgreSQL 7.4.2 throughout.

Any help will be greatly appreciated!  

Thanks!
Gopal.










view thread (3+ messages)  latest in thread

Message-ID: <200507141633.WAA06096@redsea.india.hp.com>
Permalink:  ../200507141633.WAA06096@redsea.india.hp.com/
Also on:    postgresql.org/message-id/200507141633.WAA06096@redsea.india.hp.com

 · 

reply

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: srinivgo@india.hp.com
  Subject: Re: pg_restore hangs on 'some' HP-UX machines
  In-Reply-To: <200507141633.WAA06096@redsea.india.hp.com>
  References: <200507141633.WAA06096@redsea.india.hp.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