From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: Hariraman Jayaraj <hariraman.ocp@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: unexpected EOF on client connection / could not send data to client: Broken pipe
Date: Wed, 02 May 2012 12:26:39 -0500
Message-ID: <4FA127FF0200002500047700@gw.wicourts.gov> (raw)
In-Reply-To: <CAGy0TffVKV-vN1d+w24RrwjxSj3wuOuhBDpJvimJPC5eyzi06A@mail.gmail.com>
References: <CAGy0TffVKV-vN1d+w24RrwjxSj3wuOuhBDpJvimJPC5eyzi06A@mail.gmail.com>
Hariraman Jayaraj <hariraman.ocp@gmail.com> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Kevin.Grittner@wicourts.gov, hariraman.ocp@gmail.com
Subject: Re: unexpected EOF on client connection / could not send data to client: Broken pipe
In-Reply-To: <4FA127FF0200002500047700@gw.wicourts.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox