Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id A168B9F9611 for ; Fri, 9 Nov 2007 18:11:55 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 05812-08 for ; Fri, 9 Nov 2007 18:11:38 -0400 (AST) Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.229]) by postgresql.org (Postfix) with ESMTP id F1EFC9F925E for ; Fri, 9 Nov 2007 18:11:51 -0400 (AST) Received: by wr-out-0506.google.com with SMTP id 68so423802wri for ; Fri, 09 Nov 2007 14:11:48 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=BnvoK9z+6bow5JYx0BSsg8OQwokY+nOCEOP5LIm+/sk=; b=UxKk2lrPqRHBHJY/crw35cvtnUmkFuZssOs3WdIR4sHoNlXFexT1wR+MdgB7OFTYMPfBnX212gXY2Yec+e1qABvT3YfcGGR8+ICSwAiLq5y52WTPVEVFfb3YBKGfo6NM9Lt9XN+tDoortbo7fjiPHfyWgk1QyohKzap5LjnnOp8= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=SW0Dx8VxopuzlI+go976xGyyufj7EKhSVDLzpZib9P19SOKs4dEXvO5JR1I+YQAf03FnoETgbTMSjcQ1HhBh6HxOZHGbRClGCiGBPYOuFtQBroSOGanyTdYaYmFRqmstZ6+HmPC1VE0gCcrY0LjC6VjXnwcb4WIuy0F0nw/G7DA= Received: by 10.66.221.5 with SMTP id t5mr46351ugg.1194646306655; Fri, 09 Nov 2007 14:11:46 -0800 (PST) Received: by 10.67.95.18 with HTTP; Fri, 9 Nov 2007 14:11:46 -0800 (PST) Message-ID: Date: Fri, 9 Nov 2007 16:11:46 -0600 From: "Scott Marlowe" To: "Tena Sakai" Subject: Re: idle in transaction...unexpected EOF on client connection Cc: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/80 X-Sequence-Number: 27323 On Nov 9, 2007 3:58 PM, Tena Sakai wrote: > > Hi Everybody, > > I see in serverlog many entries that read: > LOG: unexpected EOF on > client connection > LOG: unexpected EOF on > client connection > LOG: unexpected EOF on > client connection > LOG: unexpected EOF on > client connection > > This occurs regularly and frequently and I am > wondering if it is indicative of any underlying > issue(s). Would you please let me know what > you know? Most likely what is happening is that you have a firewall between your app and your db server that is closing idle connections after x minutes. Could be other things, like crashing clients, etc... Hard to say without more evidence.