Hi
reading google.. i come to here... maybe i can help more about this issue.
on server pglog:
2009-07-15 09:40:27 BRTLOG: could not receive data from client: Unknown
winsock error 10061
2009-07-15 09:40:27 BRTLOG: unexpected EOF on client connection
2009-07-15 09:41:35 BRTLOG: could not receive data from client: Unknown
winsock error 10061
2009-07-15 09:41:35 BRTLOG: unexpected EOF on client connection
2009-07-15 09:44:05 BRTLOG: could not receive data from client: Unknown
winsock error 10061
2009-07-15 09:44:05 BRTLOG: unexpected EOF on client connection
2009-07-15 09:45:09 BRTLOG: could not receive data from client: Unknown
winsock error 10061
2009-07-15 09:45:09 BRTLOG: unexpected EOF on client connection
2009-07-15 09:45:14 BRTLOG: could not receive data from client: Unknown
winsock error 10061
2009-07-15 09:45:14 BRTLOG: could not receive data from client: Unknown
winsock error 10061
2009-07-15 09:45:14 BRTLOG: unexpected EOF on client connection
2009-07-15 09:45:14 BRTLOG: unexpected EOF on client connection
2009-07-15 09:50:30 BRTLOG: could not receive data from client: Unknown
winsock error 10061
2009-07-15 09:50:30 BRTLOG: unexpected EOF on client connection
2009-07-15 09:51:34 BRTLOG: could not receive data from client: Unknown
winsock error 10061
2009-07-15 09:51:34 BRTLOG: unexpected EOF on client connection
2009-07-15 09:51:34 BRTLOG: could not receive data from client: Unknown
winsock error 10061
2009-07-15 09:51:34 BRTLOG: unexpected EOF on client connection
Enviroment:
The server running W2003 R2 with Intel Quad Core Q6600 @ 2,4Ghz - 4Gb RAM
PostgreSQL 8.4.0
before was used PG 8.3 and happens too.
Notes:
* 40 to 60 simultaneus conection to database
* use libpq.dll to conect to server.
* use Zeos 7 / Delphi 2009 application. this application makes 2
connection to a same database (for transaction isolation)
* error dont happen in server and 20 machines winXP
* error happen only in 5 machines with winXP
* in this 5 machines: Removed Antivirus, Firewall and windows update
activated.
* changed hub port cables to prevent hardware fails.
then i decided format 1 machine, instaled winxp and the problems not
happend! very stange...
i thinking format these other machines... but i want detect what dll of
windows is outdated or with problem...
another strange error in same 5 clients, i think that has relation... let=
=B4s
go..
before i received message in client "could not receive data from server
WSAStartup not yet called (0x0000276D10093)" and the server log register
"winsock error 10061".
this message occours only if a client database connection is stand by for
a time (1 minute or more)
to resolve this is added a timer to make the stupid query "select now()"
every 20 seconds, only to simulate activity on connection, and not happend
more...
if necessary i can make any test to try resolve this...
any idea is welcome.
Franklin Haut