X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 7FB049DC9BC for ; Thu, 2 Feb 2006 13:18:32 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 16157-02 for ; Thu, 2 Feb 2006 13:18:30 -0400 (AST) X-Greylist: delayed 00:06:41.135185 by SQLgrey- Received: from bubka.webhack.com (bubka.webhack.com [64.34.168.26]) by postgresql.org (Postfix) with ESMTP id D98B59DC9D4 for ; Thu, 2 Feb 2006 13:18:28 -0400 (AST) Received: (qmail 14722 invoked by uid 89); 2 Feb 2006 17:11:47 -0000 Received: by simscan 1.1.0 ppid: 14713, pid: 14718, t: 1.4833s scanners: clamav: 0.87.1/m:34/d:1162 spam: 3.1.0 Received: from unknown (HELO ?192.168.0.237?) (ashcraft@13monkeys.com@64.91.109.105) by bubka.webhack.com with SMTP; 2 Feb 2006 17:11:45 -0000 Message-ID: <43E23D4B.7060101@edgate.com> Date: Thu, 02 Feb 2006 09:11:39 -0800 From: Jeremy Ashcraft User-Agent: Mozilla Thunderbird 1.0.6 (X11/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: strange hung processes 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, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200602/21 X-Sequence-Number: 20442 We're running 7.4.9 and have run into something strange. A group of processes seem to have hung and cannot be killed. netstat showed that there were no active TCP connections at the time. Sending SIGTERM to the parent process caused PG to begin its shutdown, but it never finished. We then kill -9 the postmaster, which caused it to die, but these child procs remain, even after a clean restart. Our next step is to reboot the box, but before we do, I'm just curious anyone else has seen this, why this happened, and if anyone know ways to prevent this from happening again..... thanks -- jeremy ashcraft operations/development EDucation GATEways jashcraft@edgate.com