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 6768F52BD4 for ; Fri, 15 Jul 2005 19:05:04 -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 53721-05 for ; Fri, 15 Jul 2005 22:05:00 +0000 (GMT) Received: from mail.travelamericas.com (unknown [206.130.134.147]) by svr1.postgresql.org (Postfix) with SMTP id A832B52BC7 for ; Fri, 15 Jul 2005 19:04:54 -0300 (ADT) Received: (qmail 12064 invoked from network); 15 Jul 2005 22:04:55 -0000 Received: from unknown (HELO ?10.0.0.253?) (10.0.0.253) by verkiel.travelamericas.com with SMTP; 15 Jul 2005 22:04:55 -0000 Message-ID: <42D83306.5020604@travelamericas.com> Date: Fri, 15 Jul 2005 15:04:54 -0700 From: Chris Travers User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Gopal Srinivasa , pgsql-admin@postgresql.org Subject: Re: pg_restore hangs on 'some' HP-UX machines References: <200507141633.WAA06096@redsea.india.hp.com> In-Reply-To: <200507141633.WAA06096@redsea.india.hp.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.037 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200507/111 X-Sequence-Number: 18167 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