From: | Franklin Haut <franklin(dot)haut(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Unknown winsock error 10061 |
Date: | 2009-07-15 13:55:59 |
Message-ID: | a71fab580907150655g50efc47fk3d3500704c837413@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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´s
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
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2009-07-15 14:02:09 | Re: BUG #4919: CREATE USER command slows down system performance |
Previous Message | Alvaro Herrera | 2009-07-15 13:47:53 | Re: BUG #4922: Segmentation fault on high-loaded server (+coredump backtrace) |