Could not receive data from client: Unknown winsock error 10061

2010/2/24 Patrick Weimer <Patrick.Weimer@dreger.de>:

Hi,

the error message of the subject is my big problem, log entrys:

2010-02-24 12:22:25 LOG:  XX000: could not receive data from client:
Unknown winsock error 10061
2010-02-24 12:22:25 LOCATION:  pq_recvbuf, pqcomm.c:738
2010-02-24 12:22:25 LOG:  08P01: unexpected EOF on client connection
2010-02-24 12:22:25 LOCATION:  SocketBackend, postgres.c:307

After this messages our WebSphere Application Server 6.1.0.9 crashs, with
Database Timeout.

I spend many time on google and the postgre manual and found some possible
problem causes, but no one helped me.

10061 is "connection refused". Windows will give this when the client
hangs up the connection. So from the perspective of PostgreSQL, your
appserver closed the connection. Most likely, your appserver crashed
*first*, and that caused the message with postgresql.

If not, my best bet would be some firewall or antivirus software, on
either the db server or the appserver. Do yo uhave any of those
running?

The following link describes my problem and including a patch, but the
link seems to be down.
Post http://archives.postgresql.org/pgsql-bugs/2009-07/msg00179.php
Patch http://archives.postgresql.org/pgsql-bugs/2009-07/msg00078.php

A different verison of the shared memory patch has been applied and is
in the current releases of 8.3 and 8.4. If you are sure you are
experiencing that problem, I would suggest you upgrade.

However, that's just the shared memory problem. Which is a secondary
problem to the connection closed one, that prevents the system from
properly restarting after a failure.

--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/