Обсуждение: Reg: unexpected EOF on client connection

Поиск
Список
Период
Сортировка

Reg: unexpected EOF on client connection

От
Hariraman Jayaraj
Дата:
Dear Friends,

I am new to Postgres Administration. I am getting this below mentioned error in my pg_log and server looks in hanged state whenever this error is getting logged.
OS - Suse Linux Enterprise Edition 11, DB - Postgres 8.3, Application Server - Jboss.

2011-11-22 16:57:55 IST LOG:  unexpected EOF on client connection
2011-11-22 16:57:55 IST LOG:  unexpected EOF on client connection
2011-11-22 16:58:58 IST LOG:  unexpected EOF on client connection
2011-11-22 16:58:58 IST LOG:  unexpected EOF on client connection
2011-11-22 16:58:58 IST LOG:  unexpected EOF on client connection
2011-11-22 16:58:58 IST LOG:  unexpected EOF on client connection
2011-11-22 16:58:58 IST LOG:  unexpected EOF on client connection
2011-11-22 16:58:58 IST LOG:  unexpected EOF on client connection
2011-11-22 16:58:58 IST LOG:  unexpected EOF on client connection
2011-11-22 16:58:58 IST LOG:  unexpected EOF on client connection
2011-11-22 16:58:58 IST LOG:  unexpected EOF on client connection
2011-11-22 16:58:58 IST LOG:  unexpected EOF on client connection
2011-11-22 16:58:58 IST LOG:  unexpected EOF on client connection

Kindly suggest me about how to overcome this. Suggestion are welcome whole heartedly.
Thanks in advance.



--
Regards,
Hariraman Jayaraj
Mobile - 9786228845


Re: Reg: unexpected EOF on client connection

От
Ian Lea
Дата:
> I am new to Postgres Administration. I am getting this below mentioned error
> in my pg_log and server looks in hanged state whenever this error is getting
> logged.
> OS - Suse Linux Enterprise Edition 11, DB - Postgres 8.3, Application Server
> - Jboss.
>
> 2011-11-22 16:57:55 IST LOG:  unexpected EOF on client connection
> 2011-11-22 16:57:55 IST LOG:  unexpected EOF on client connection

These generally mean that the client has gone away without closing
database connections.  You should check your client code.

It is highly unlikely these errors would cause your server to hang.


--
Ian.

Re: Reg: unexpected EOF on client connection

От
"white.heron white"
Дата:
Dear All,

Since you have postgres database server. You may need to check at client desktop PCs which is connected to Postgres database.
Especially the physical ethernet connection from clients Desktop PCs to ethernet connection. (if its works within company local area network)
You have option:

1) ping remote client Desktop PCs (which is, you suspect the Desktop PCs down).
2) check physical ethernet connection of the Desktop PC.
3) ping localhost to check if the network interface connection is working.  

Regards,

MOHAMMAD ADLI BIN MT TAJUDIN
A8-2-7, DESA PANDAN APARTMENTS,
OFF JALAN KG. PANDAN,
55100 KUALA LUMPUR,
WEST MALAYSIA.


H/p number:  (017) 362 3661
Email: white.heron@yahoo.com
From: Ian Lea <ian.lea@gmail.com>
To: Hariraman Jayaraj <hariraman.ocp@gmail.com>
Cc: pgsql-admin@postgresql.org
Sent: Wednesday, November 23, 2011 5:42 PM
Subject: Re: [ADMIN] Reg: unexpected EOF on client connection

> I am new to Postgres Administration. I am getting this below mentioned error
> in my pg_log and server looks in hanged state whenever this error is getting
> logged.
> OS - Suse Linux Enterprise Edition 11, DB - Postgres 8.3, Application Server
> - Jboss.
>
> 2011-11-22 16:57:55 IST LOG:  unexpected EOF on client connection
> 2011-11-22 16:57:55 IST LOG:  unexpected EOF on client connection

These generally mean that the client has gone away without closing
database connections.  You should check your client code.

It is highly unlikely these errors would cause your server to hang.


--
Ian.

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