Re: Connection unexpectedly terminated - Guy Platt - com.mysql.lists.dotnet

10 messages in com.mysql.lists.dotnetRe: Connection unexpectedly terminated

From	Sent On	Attachments
Widita Nugraha	03 Oct 2005 21:48
Jorge Bastos	04 Oct 2005 00:59
Darren Compton	04 Oct 2005 02:50
SGr...@unimin.com	04 Oct 2005 07:00
Lynn Eriksen	04 Oct 2005 07:57
Reggie Burnett	05 Oct 2005 06:48
Darren Compton	05 Oct 2005 07:00
Widita Nugraha	06 Oct 2005 22:48
Guy Platt	13 Oct 2005 01:15
Darren Compton	13 Oct 2005 03:28

Subject:	Re: Connection unexpectedly terminated
From:	Guy Platt (guy....@nordicadvice.se)
Date:	10/13/2005 01:15:08 AM
List:	com.mysql.lists.dotnet

We have had this problem for some time (since the first connector.net became available), but only in an application where we connect to the database several hundred times in short succession. We tried everything but eventually had to use the ODBC connector to solve this (if the problems were in MySql then the ODBC connector would obviously have them as well).

For our regular web applications we use the Connector.Net without any problems.

We currently use MySql 4.1.8 planning on upgrading to the latest version pretty soon.

thanks Guy

<callto://guyplatt>

Darren Compton said the following wise words on 2005-10-05 4:01 PM:

Hi Reggie,

Version 4.1.12a and the other server we use is 4.0.15. both have the problem, at roughly the same time usually though this may be to do with web server going into overload.

Cheers

From: "Reggie Burnett" <reg...@mysql.com> To: "'Darren Compton'" <darr...@hotmail.com>, <dot...@lists.mysql.com> Subject: RE: Connection unexpectedly terminated Date: Wed, 5 Oct 2005 08:49:06 -0500

What version of MySQL are you running? I ask because shared memory connections had major problems that have only recently been fixed. The problems with shared memory were in the server, not in the connector.

-----Original Message----- From: Darren Compton [mailto:darr...@hotmail.com] Sent: Tuesday, October 04, 2005 4:51 AM To: dot...@lists.mysql.com Subject: RE: Connection unexpectedly terminated

Im having this same problem. Only started since I updated to 1.06. But even downgrading back to 1.05 doesnt fix it now. We have our own servers. We've rebooted both the web server and the mysql server and still this happens. Only semi fix i've found so far is to turn off pooling and use tcp socket instead of memory. Problem still occurs but only a handful a day compared to thousands every few hours.

From: "Jorge Bastos" <mysq...@decimal.pt> To: <dot...@lists.mysql.com> Subject: Fw: Connection unexpectedly terminated Date: Tue, 4 Oct 2005 09:00:14 +0100

Could be the server that have reached the maximun connections

----- Original Message ----- From: "Widita Nugraha" <widi...@alds.net> To: <dot...@lists.mysql.com> Sent: Tuesday, October 04, 2005 5:48 AM Subject: Connection unexpectedly terminated

Hi all, I have a problem with my ASP.net application being hosted by a shared hosting in the net, i usually runs fine but lately it often gives me this error message, Please inform me how to avoid this error message...

regards, Widita Nugraha, Indonesia

Server Error in '/' Application.

---------------------------------------------------------------------

---

/Connection unexpectedly terminated/

* 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: *MySql.Data.MySqlClient.MySqlException: Connection unexpectedly terminated

*Source Error:*

|An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.|

*Stack Trace:*

[MySqlException: Connection unexpectedly terminated] MySql.Data.MySqlClient.PacketReader.ReadHeader() +272 MySql.Data.MySqlClient.PacketReader.OpenPacket() +107 MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId) +17 MySql.Data.MySqlClient.CommandResult.ReadNextResult(Boolean isFirst) +62 MySql.Data.MySqlClient.NativeDriver.SendQuery(Byte[] bytes, Int32 length, Boolean consume) +123

MySql.Data.MySqlClient.MySqlCommand.GetNextResultSet(MySqlDataReader reader) +320 MySql.Data.MySqlClient.MySqlDataReader.NextResult() +108 MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) +143 MySql.Data.MySqlClient.MySqlCommand.ExecuteReader() +7 SPALib.TLibrary.genquery(MySqlConnection& conn, String a) lasttrans.formLastTrans.Page_Load(Object sender, EventArgs e) System.Web.UI.Control.OnLoad(EventArgs e) +67 System.Web.UI.Control.LoadRecursive() +35 System.Web.UI.Page.ProcessRequestMain() +750

------------------------------------------------------------

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