Advantage Developer Zone

 
 
 

Advantage Knowledgebase Item




Ref No:
081204-2102
Last Modified:
Monday, December 08, 2008
Product:
Advantage Database Server ( General )
Category:
Performance
Title:
10054 Error: An Existing Connection Was Forcibly Closed by the Remote Host
Problem Description:
1.) The 10054 error is an OS (Operating System) level error with the following description: "An existing connection was forcibly closed by the remote host."

2.) The 10054 error is being logged hundreds of times and being associated with slow performance.
Solution:
1.)
The 10054 error is a Winsock error and may be related to a network device. You can check to see if any new routers have been introduced or other network changes have been made.

A 10054 error can get logged if a client application is closed unexpectedly (doesn't shutdown nicely) and is currently sending or waiting for a reply from the server. In this case the server should log a 7020 error. Also it is possible that a 10054 error can be caused by any process sending Advantage an ICMP error packet with the "port not available" error code.

In the case of a network related issue it may be helpful to perform a network sniff to further diagnose the problem.

2.)
If 10054 errors being logged are associated with slowdown it is likely that the 10054 errors are a symptom rather than the cause. The following are some things to look at that may be causing the slow performance:
a.) Is the server running out of Worker Threads or is the Max Used equal to the Configured amount?
b.) Using sp_EnableQueryLogging or by looking at Active Queries in Remote Server Info are their queries that are taking an unusually long amount of time to run? If this is the case an index may be missing, or a Table may have a lot of deleted records at the beginning. You can refer to this Knowledge Base Item for more information: Slow Queries or Table Opens on Tables That Have Not Been Packed
Was This Item Helpful?