List:MySQL and .NET« Previous MessageNext Message »
From:Jure ┼ápik Date:November 21 2004 8:41pm
Subject:Re: An established connection was aborted by the software in your
host machine
View as plain text  
------
In your stack trace, is the exception being thrown by the
MySqlConnection object? Can you mail your stack trace to the list for
more detail? It sounds like a connection timeout setting issue to me.
----

I have simmilar problems... with gamma. Sometimes the mentioned error, on certain cases
the error is :
*Error: Unable to write data to the transport connection.

*It is also weird, that it occurs after a certain time only.

Heh, read this:
Right now, what I did to repair this problem was:
delete ByteFX.MySqlClient.dll (I had this file in the same folder as MySql.Data.dll).
Dunno why this helped though.. :)


Here is my stack trace:



  Server Error in '/' Application.
  ------------------------------------------------------------------------


    /An established connection was aborted by the software in your host
    machine/

* Description: *An unhandled exception occurred during the execution of 
the current web request. Please review the stack trace for more 
information about the error and where it originated in the code.

* Exception Details: *System.Net.Sockets.SocketException: An established 
connection was aborted by the software in your host machine

*Source Error:*

||

Line 108:    var adapter : MySqlDataAdapter = new MySqlDataAdapter();
Line 109:    adapter.SelectCommand = new MySqlCommand(query, mycon);
Line 110:    adapter.Fill(ds);
Line 111:    dl.DataSource = ds
Line 112:    dl.DataBind();


* Source File: * D:\***\a.js*    Line: * 110

*Stack Trace:*

||

[SocketException (0x2745): An established connection was aborted by the software in your
host machine]
   System.Net.Sockets.Socket.Send(Byte[] buffer, Int32 offset, Int32 size, SocketFlags
socketFlags) +421
   System.Net.Sockets.NetworkStream.Write(Byte[] buffer, Int32 offset, Int32 size) +102

[IOException: Unable to write data to the transport connection.]
   MySql.Data.MySqlClient.MySqlConnection.Open() +148
   System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection,
ConnectionState& originalState) +44
   System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32
maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32
maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38
   a.m.Page_Load(Object sender, EventArgs e) in D:\***\a.js:110
   System.Web.UI.Control.OnLoad(EventArgs e) +67
   System.Web.UI.Control.LoadRecursive() +35
   System.Web.UI.Page.ProcessRequestMain() +744
      


------------------------------------------------------------------------
*Version Information:* Microsoft .NET Framework Version:1.1.4322.2032; 
ASP.NET Version:1.1.4322.2032


      *Request Details*

Session Id: 	ni2bh0fjzioflg3dey2rghzi 	Request Type: 	GET
Time of Request: 	21.11.2004 21:22:11 	Status Code: 	500
Request Encoding: 	Unicode (UTF-8) 	Response Encoding: 	Unicode (UTF-8)


      *Trace Information*

Category 	Message 	From First(s) 	From Last(s)
aspx.page 	Begin Init 	
	
aspx.page 	End Init 	0,000031 	0,000031
Unhandled Execution Error 	
Unable to write data to the transport connection.
  at MySql.Data.MySqlClient.MySqlConnection.Open()
  at System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection 
connection, ConnectionState& originalState)
  at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 
startRecord, Int32 maxRecords, String srcTable, IDbCommand command, 
CommandBehavior behavior)
  at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 
startRecord, Int32 maxRecords, String srcTable, IDbCommand command, 
CommandBehavior behavior)
  at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
  at a.m.Page_Load(Object sender, EventArgs e) in 
D:\inetpub\gostje\Ljubljana\libres\libres\a.js:line 110
  at System.Web.UI.Control.OnLoad(EventArgs e)
  at System.Web.UI.Control.LoadRecursive()
  at System.Web.UI.Page.ProcessRequestMain() 	0,000738 	0,000707


      *Control Tree*

Control Id 	Type 	Render Size Bytes (including children) 	Viewstate Size 
Bytes (excluding children)


      *Cookies Collection*

Name 	Value 	Size
ASP.NET_SessionId 	ni2bh0fjzioflg3dey2rghzi 	42


      *Headers Collection*

Name 	Value
Connection 	keep-alive
Keep-Alive 	300
Accept 
text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5


Accept-Charset 	ISO-8859-1,utf-8;q=0.7,*;q=0.7
Accept-Encoding 	gzip,deflate
Host 	www.***.si
User-Agent 	Mozilla/5.0 (Windows; U; Windows NT 5.2; en-US; rv:1.7.5) 
Gecko/20041107 Firefox/1.0


      *Server Variables*

Name 	Value
ALL_HTTP 	HTTP_CONNECTION:keep-alive HTTP_KEEP_ALIVE:300 
HTTP_ACCEPT:text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5

HTTP_ACCEPT_CHARSET:ISO-8859-1,utf-8;q=0.7,*;q=0.7 
HTTP_ACCEPT_ENCODING:gzip,deflate HTTP_HOST:www.***.si 
HTTP_USER_AGENT:Mozilla/5.0 (Windows; U; Windows NT 5.2; en-US; 
rv:1.7.5) Gecko/20041107 Firefox/1.0
ALL_RAW 	Connection: keep-alive Keep-Alive: 300 Accept: 
text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5

Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7 Accept-Encoding: 
gzip,deflate Host: www.***.si User-Agent: Mozilla/5.0 (Windows; U; 
Windows NT 5.2; en-US; rv:1.7.5) Gecko/20041107 Firefox/1.0
APPL_MD_PATH 	/LM/W3SVC/95/Root
APPL_PHYSICAL_PATH 	D:***\
AUTH_TYPE 	 
AUTH_USER 	 
AUTH_PASSWORD 	 
LOGON_USER 	 
REMOTE_USER 	 
CERT_COOKIE 	 
CERT_FLAGS 	 
CERT_ISSUER 	 
CERT_KEYSIZE 	 
CERT_SECRETKEYSIZE 	 
CERT_SERIALNUMBER 	 
CERT_SERVER_ISSUER 	 
CERT_SERVER_SUBJECT 	 
CERT_SUBJECT 	 
CONTENT_LENGTH 	0
CONTENT_TYPE 	 
GATEWAY_INTERFACE 	CGI/1.1
HTTPS 	off
HTTPS_KEYSIZE 	 
HTTPS_SECRETKEYSIZE 	 
HTTPS_SERVER_ISSUER 	 
HTTPS_SERVER_SUBJECT 	 
INSTANCE_ID 	95
INSTANCE_META_PATH 	/LM/W3SVC/95
LOCAL_ADDR 	10.12.0.6
PATH_INFO 	/testdb.aspx
PATH_TRANSLATED 	D:\***\testdb.aspx
QUERY_STRING 	 
REMOTE_ADDR 	193.77.*
REMOTE_HOST 	193.77.*
REMOTE_PORT 	3545
REQUEST_METHOD 	GET
SCRIPT_NAME 	/testdb.aspx
SERVER_NAME 	www.***.si
SERVER_PORT 	80
SERVER_PORT_SECURE 	0
SERVER_PROTOCOL 	HTTP/1.1
SERVER_SOFTWARE 	Microsoft-IIS/5.0
URL 	/testdb.aspx
HTTP_CONNECTION 	keep-alive
HTTP_KEEP_ALIVE 	300
HTTP_ACCEPT 
text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5


HTTP_ACCEPT_CHARSET 	ISO-8859-1,utf-8;q=0.7,*;q=0.7
HTTP_ACCEPT_ENCODING 	gzip,deflate
HTTP_HOST 	www.***.si
HTTP_USER_AGENT 	Mozilla/5.0 (Windows; U; Windows NT 5.2; en-US; 
rv:1.7.5) Gecko/20041107 Firefox/1.0


Thread
An established connection was aborted by the software in your hostmachineborer richard18 Nov
  • Re: An established connection was aborted by the software in your host machineLuke Venediger18 Nov
Re: An established connection was aborted by the software in your host machineLuke Venediger18 Nov
Re: An established connection was aborted by the software in yourhost machineJure ┼ápik21 Nov