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

2012-05-02 Thread Kevin Grittner 
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

-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

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

2012-05-02 Thread 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.

-- 
Regards,
Hariraman Jayaraj