Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id CFF2F16137F4 for ; Wed, 2 May 2012 14:26:58 -0300 (ADT) Received: from gwmta.wicourts.gov ([165.219.244.99] helo=gw.wicourts.gov) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SPdKL-0000PD-V4 for pgsql-admin@postgresql.org; Wed, 02 May 2012 17:26:58 +0000 Received: from Courts-MTA by gw.wicourts.gov with Novell_GroupWise; Wed, 02 May 2012 12:26:45 -0500 Message-Id: <4FA127FF0200002500047700@gw.wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 8.0.2 Date: Wed, 02 May 2012 12:26:39 -0500 From: "Kevin Grittner" To: "Hariraman Jayaraj" , Subject: Re: unexpected EOF on client connection / could not send data to client: Broken pipe References: In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Pg-Spam-Score: -4.2 (----) X-Archive-Number: 201205/5 X-Sequence-Number: 39494 Hariraman Jayaraj wrote: > We are using postgres 8.3 in Open Suse 11 server. > Front end - Java, struts > Middle ware - Jboss > Backend - Postgres 8.3 DB. It helps to know the exact version number and PostgreSQL configuration settings. http://wiki.postgresql.org/wiki/Server_Configuration > Recently I am encoutering below mentioned error. Also by the time > this error occuring, Linux server / Postgres Server is too slow > and at times it is not responding at all. Can you run `vmstat 1` while things are slow? It sounds like you might be getting into heavy swapping due to memory over-commit. Can you show us the result of running `free -m`? > 2012-05-02 12:14:09 IST LOG: unexpected EOF on client connection > 2012-05-02 12:14:09 IST LOG: unexpected EOF on client connection > 2012-05-02 12:14:09 IST LOG: unexpected EOF on client connection > 2012-05-02 12:14:10 IST LOG: unexpected EOF on client connection > 2012-05-02 12:14:11 IST LOG: unexpected EOF on client connection > 2012-05-02 12:14:11 IST LOG: unexpected EOF on client connection > 2012-05-02 12:14:12 IST LOG: unexpected EOF on client connection > 2012-05-02 12:14:12 IST LOG: unexpected EOF on client connection > 2012-05-02 12:14:13 IST LOG: could not send data to client: > Broken pipe Those messages mean that the TCP connection from the client was broken by something other than the PostgreSQL server. -Kevin