[ADMIN] unexpected EOF on client connection / could not send data to client: Broken pipe

[Hariraman Jayaraj]

Hi,

We are using postgres 8.3 in Open Suse 11 server.
Front end - Java, struts
Middle ware - Jboss
Backend - Postgres 8.3 DB.

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.

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

Suggest me about this. Thanks in advance.

[Kevin Grittner]

Post by Hariraman Jayaraj
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

Post by Hariraman Jayaraj
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`?

Post by Hariraman Jayaraj
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
Broken pipe

Those messages mean that the TCP connection from the client was
broken by something other than the PostgreSQL server.

-Kevin