X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 9E098D1D1A4 for ; Fri, 30 Jan 2004 01:00:59 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 93310-09 for ; Thu, 29 Jan 2004 21:00:31 -0400 (AST) Received: from busybox.pixar.com (busybox.pixar.com [138.72.18.213]) by svr1.postgresql.org (Postfix) with ESMTP id 35C4DD1D137 for ; Thu, 29 Jan 2004 21:00:26 -0400 (AST) Received: from pixar.com (dreadnok.pixar.com [138.72.16.110]) by busybox.pixar.com (8.12.8/8.12.8) with ESMTP id i0U10RHw025076 for ; Thu, 29 Jan 2004 17:00:27 -0800 Message-ID: <4019ACAB.4010600@pixar.com> Date: Thu, 29 Jan 2004 17:00:27 -0800 From: Mark Harrison User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.0) Gecko/20020529 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: hung postmaster when client machine dies? Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/286 X-Sequence-Number: 12149 We recently had an incident where a linux box went down with a kernel error. A process on the box had an open connection to a postgres session, and was in a transaction. This situation was noticed when other processes connected to postgres would not respond. We observed that there was postmaster connected to the ip address of the downed machine with an "in transaction" status. Killing that processes unblocked the other processes. Is this expected behavior? Was postgres simply waiting for a failure from the TCP/IP layer? We're now running a watchdog process that pings machines for which a postmaster is running and killing that process if the machine is not contactable for a certain period of time. Thanks to whoever made the status information show up in ps output! Unfortunately, we didn't capture the process data... if this would help we can attempt to reproduce the situation. Many TIA, Mark -- Mark Harrison Pixar Animation Studios Emeryville, CA