X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6083E52A23 for ; Tue, 19 Jul 2005 12:35:33 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 58753-06 for ; Tue, 19 Jul 2005 15:35:26 +0000 (GMT) Received: from atlrel6.hp.com (atlrel6.hp.com [156.153.255.205]) by svr1.postgresql.org (Postfix) with ESMTP id 063E652A1B for ; Tue, 19 Jul 2005 12:35:24 -0300 (ADT) Received: from redsea.india.hp.com (redsea.india.hp.com [15.76.97.3]) by atlrel6.hp.com (Postfix) with ESMTP id 0AADAE2B5; Tue, 19 Jul 2005 11:35:22 -0400 (EDT) Received: from eb98130 (eb98130.india.hp.com [15.76.98.130]) by redsea.india.hp.com (8.9.3 (PHNE_29774)/8.9.3 SMKit7.02) with ESMTP id VAA06097; Tue, 19 Jul 2005 21:03:16 +0530 (IST) Message-Id: <200507191533.VAA06097@redsea.india.hp.com> From: "Gopal Srinivasa" To: "'Chris Travers'" , Subject: Re: pg_restore hangs on 'some' HP-UX machines Date: Tue, 19 Jul 2005 21:05:17 +0530 Organization: HP MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook, Build 11.0.6353 Thread-Index: AcWJiX4n0bOYHwNiT7WbWzWpf2kYhwC6ToZw X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 In-Reply-To: <42D83306.5020604@travelamericas.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200507/188 X-Sequence-Number: 18244 Hi Chris, > So basically it is hanging when writing to the socket. Does > this change if you use TCP/IP (say adding a -h localhost to > your commandline)? This seems to work on one of my test machines where pg_restore was failing before...still need to make sure that this will work always, but is definitely a promising start. Thanks a bunch! Gopal. > -----Original Message----- > From: Chris Travers [mailto:chris@travelamericas.com] > Sent: Saturday, July 16, 2005 3:35 AM > To: Gopal Srinivasa; pgsql-admin@postgresql.org > Subject: Re: [ADMIN] pg_restore hangs on 'some' HP-UX machines > > I don't have any experience on HP-UX so take this with a > grain of salt... > > > > Gopal Srinivasa wrote: > > >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 am assuming you are using ECC RAM, and that the hardware is > good. If there is any doubt here, you may want to look into > diagnostics on these areas. > > Just checking obvious things: Same version of libc on both > working and nonworking systems? Any updates that you know of > on working computers > that are not on nonworking systems? What about the kernel > (for socket > handling)? Any difference there? > > >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 > > > > > > So basically it is hanging when writing to the socket. Does > this change if you use TCP/IP (say adding a -h localhost to > your commandline)? > > In combination with the error about incomming connections, I > wonder if something is up with the socket handling on the > affected systems... > > Best Wishes, > Chris Travers > Metatron Technology Consulting > >