A transport-level error occurred while sending a request to the server. (PROVIDER:TCP provider, error:0-

As the head Office IT department, naturally bear the operation and maintenance of various branches of technical support work, due to the nature of the company, Branch is often responsible for maintaining the official master of the server, and these servers as well as the official master data connection between ... 10,000 words are omitted here.

Today, the branch has a person responsible for sending over a server error message, roughly the following "

FIREF|Y゛2016/5/23 15:36:19
Journal name: Application
Source: XXXXX

Date: 2016/5/23 11:47:30
Event id:0
Task Category: None
Level: Error
Keywords: classic
User: N/A
Computer: Win-h48v8mb5taa
Description
TIMESTAMP:2016/5/23 3:47:30
message:  get message Write  SQLSERVER  database from mq:.\private$\dsddataexport   : abnormal &nbsp occurs XXXXX; The specific exception information is: A transport-level error occurred while sending the request to the server.   (provider: tcp  provider, error: 0 -  a remote host forced to close an existing connection. The service thread has stopped!  configuration information is: <?xml version= "1.0"? ><rule xmlns:xsi= "650) this.width=650; src=/e/ U261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/images/localimage.png") No-repeat center;border:1px solid #ddd; "alt=" Spacer.gif "/>http://www.w3.org/2001/xmlschema-instance"   xmlns:xsd= "650) this.width=650;" src= "/e/u261/themes/default/images/spacer.gif" style= "Background:url ("/e/u261/ Lang/zh-cn/images/localimage.png ") no-repeat center;border:1px solid #ddd;" alt= "Spacer.gif"/>http://www.w3.org/ 2001/xmlschema "><MQPath>.\private$\dsddataexport</MQPath><Enabled>true</Enabled> <model>update</model><dbtype>sqlserver</dbtype><ip>650) this.width=650; "Src="/e/ U261/thEmes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd; "alt=" Spacer.gif "/>10.xx. Xx. x </ip><username>pdc_user</username><password>pdc_user</password>< Databasename>xxxxx </databasename></rule>
Category:general
Priority:5
eventid:0
Severity:error
Title:
machine:win-h48v
Application domain:xxxxx. exe
Process id:21216
Process name:e:\xxxxx \dsd\dsd\xxxxx \xxxxx. exe
Win32 Thread id:20052
Thread Name:
Extended Properties:
Event Xml:
<event xmlns= "650) this.width=650; src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/ U261/lang/zh-cn/images/localimage.png ") no-repeat center;border:1px solid #ddd;" alt= "Spacer.gif"/>http:// Schemas.microsoft.com/win/2004/08/events/event ">
<System>
<provider name= "XXXXX"/>
<eventid qualifiers= "0" >0</EventID>
<Level>2</Level>
<Task>0</Task>
<Keywords>0x80000000000000</Keywords>
<timecreated systemtime= "2016-05-23t03:47:30.000z"/>
<EventRecordID>99</EventRecordID>
<Channel>Application</Channel>
<Computer>WIN-H48V</Computer>
<security/>
</System>
<EventData>
&LT;DATA&GT;TIMESTAMP:2016/5/23 3:47:30
message:  get message Write  SQLSERVER  database from mq:.\private$\dsddataexport   :xxxxx   The exception is &nbsp: A transport-level error occurred while sending the request to the server.   (provider: tcp  provider, error: 0 -  a remote host forced to close an existing connection. The service thread has stopped!  configuration information for: &AMP;LT;? Xml version= "1.0"?&gt;&lt; rule xmlns:xsi= "650) this.width=650;" src= "/e/u261/themes/default/images/spacer.gif" style= "Background:url (" /e/u261/lang/zh-cn/images/localimage.png ") no-repeat center;border:1px solid #ddd;" alt= "Spacer.gif"/>http:// Www.w3.org/2001/XMLSchema-instance " xmlns:xsd=" 650) this.width=650; src=/e/u261/themes/default/images/ Spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid # DDD; "alt=" Spacer.gif "/>http://www.w3.org/2001/xmlschema" &gt;&lt; mqpath&gt;. \private$\dsddataexport&lt;/mqpath&gt;&lt; enabled&gt;true&lt;/enabled&gt;&lt; Model&gt; Update&lt;/model&gt;&lt;dbType&gt; sqlserver&lt;/dbtype&gt;&lt;ip&gt;650) this.width=650; "Src="/e/u261/themes/default/images/ Spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid # DDD; "alt=" Spacer.gif "/>10.74.230.75&lt;/ip&gt;&lt; Username&gt; pdc_user&lt;/username&gt;&lt; Password&gt; Pdc_user&lt;/password&gt;&lt;databasename&gt; Xxxxx &lt;/databasename&gt;&lt;/rule&gt;
Category:general
Priority:5
eventid:0
Severity:error
Title:
machine:win-h48v
Application domain:xxxxx. exe
Process id:21216
Process name:e:\xxxxx \dsd\dsd\xxxxx \xxxxx. exe
Win32 Thread id:20052
Thread Name:
Extended Properties: </Data>
</EventData>
</Event>

”

A simple look at the error message, this thought is the problem of transmission, but check the network to check the message queue, did not find any exceptions, and any error message, it seems that the transmission should have no relationship,

After a closer look at the service, the service is not a Windows self-service, but the company for the transmission of data through the message queue into the sql2005 database, but also check the relevant SQL information, no errors found, carefully review the error message found: "The remote host forced to shut down an existing connection." The service thread has stopped! ”

This is the point, and we can also understand that when the connection is established, the connection is not established, the application actively shuts down a connection,

Since the service was written in. NET, the concept of the next. NET data connection pool was carefully reviewed, and the. NET default maximum number of connections was 100, and the default is Ture state, so if the connection pool was not defined at the time of writing the code, the connection pool was not released after a long period of use, which caused the problem.

Need to include in the code

Pooling=false

the value of the or Max Pool size,

The next thing is to let the branch staff to find the corresponding developers, modify their code to define, ok!

This article is from the "low-key IT worker" blog, make sure to keep this source http://vicent.blog.51cto.com/287372/1782559

A transport-level error occurred while sending a request to the server. (PROVIDER:TCP provider, error:0-