Consultor Eletrônico



Kbase P179611: Appserver agents stay in sending state forever when MS TOE is not turned off
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   27/12/2010
Status: Unverified

SYMPTOM(s):

Appserver agents stay in sending state forever when MS TOE is not turned off

The Appserver agents need to be manually terminated

Communication link failure when the SPID is manually killed from MS SQL server

Unable to communicate with the databases. (Disconnecting database due to server communication failure).

The AppServer agents will become available when SPID is killed off from MS SQL server and communication link failure reported

FACT(s) (Environment):

AppServer agents connect to MS SQL server database through DataServer
No obvious load increase observed
No obvious application change implemented
User Dump on the agent processes shows random appplication pattern / state
The version 10.1B0333 already has the DataServer and application fix for issue discribed in P135365
Windows Server 2003
OpenEdge 10.1B03 Service Pack

CAUSE:

Microsoft TOE (TCP Chimney) is not properly turned off. Dataserver AppServer process are waiting on network resources that are blocked by TOE.

FIX:

The TOE features are enabled in Windows when either the earlier Scalable Networking Pack (kb 912222) or Service Pack 2 for Win2003 or are installed on a Windows 2003 server. The TOE features are disabled whenever update 948496 is applied. Here are three things you might consider checking:
(1) If the file version of %windir%\system32\netsh.exe is 5.2.3790.2670 or higher it is possible that TOE is enabled. If the version number is 5.2.3790.1860 (SP1) or lower the TOE features need not be worried about.
(2) Open the registry editor, navigate to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters and focus on the following values: EnableTCPChimney, EnableTCPA, and EnableRSS. If all three are set to a value of Zero, consider TOE disabled. If they?re all set to 1, I?d recommend you consider disabling them during troubleshooting.
(3) Try running ?netstat ?t? from the command prompt to attempt to see if any client connections are in the offloaded state

TWO METHODS of DISABLING
One of the three TOE features can be disabled ?on the fly? and may be the first place to start. Disabling the TCPChimney (but not RSS or TCPA) is often sufficient to deal with problems related to TOE. But not always. To disable the TCPChimney, open a command prompt and run the following command on the server:
C:\>Netsh int ip set chimney DISABLED
No reboot is needed. No IISRESET is needed either.
A more thorough (and much more preferable) alternative to using the netsh command would be to open the registry, navigate to. . .
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters
? and change the dword values to zero for the following three keys from 1 to 0:
o "EnableTCPChimney"=dword:00000000
o "EnableTCPA"=dword:00000000
o "EnableRSS"=dword:00000000
A reboot is needed for these registry value changes to take effect.