Kbase P137793: SQL Server dies after error "Connection failure, accept() failed. Error: 10093"
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/11/2009 |
|
Status: Verified
SYMPTOM(s):
SQL Server dies after error "Connection failure, accept() failed. Error: 10093"
SQLSRV2 30: (-----) Connection failure, accept() failed. Error: 10093
Disconnecting dead server <number>. (2525)
FACT(s) (Environment):
SQL engine is experiencing a rapid series of connect disconnect sessions.
OpenEdge 10.1x
Windows
CHANGE:
Upgraded to OpenEdge 10.1B0308 or later
CAUSE:
Bug# OE00169728
CAUSE:
There is resource issue that should have been caught when opening the socket. Because this resource issue was not caught when the client tries to use that socket the SQL Server hangs or crashes and also write "Connection failure, accept() failed. Error: 10093" to the database log file. The fix captures any failure to open a socket and writes a message to the database .lg file describing the failure.
From the Microsoft support site:
http://support.microsoft.com/kb/819124/en-us
WSANOTINITIALISED (10093)
o Translation: Successful WSAStartup not yet performed.
o Description: Either the program has not called WSAStartup (Wsapiref_1v8y.asp) or WSAStartup (Wsapiref_1v8y.asp) failed. The program may be accessing a socket that the current active task does not own (that is, it is trying to share a socket
between tasks), or WSACleanup has been called too many times.
FIX:
Upgrade to 10.1C03 or higher.
Upgrade to 10.2A01 or higher.