Bug #26751 Connection unexpectedly terminated

• Submitted: 1 Mar 2007 16:21
• Modified: 8 Mar 2007 13:58
• Reporter: Bob Harrod
• Status: Not a Bug
• Category: Connector / NET
• Severity: S2 (Serious)
• Version: 1.0.8
• OS: Linux (Linux)
• CPU Architecture: Any

[1 Mar 2007 16:21] Bob Harrod

Description:

I'm getting the same error, but only when I run my code on my web host (godaddy). Everything works fine locally. Of course, locally there is only 1 user hitting the db. Using MySql Server 5.0.27, with connector 1.0.8 in both environments.
The difference in the two environments: locally, all is on Windows, but hosted, web server is Windows and db server is Linux.

Have tried the following connection strings:

(pooling off)
Database=myDatabase;Data Source=h50mysql11.secureserver.net;User Id=myRoot;Password=myPassword;Pooling=false

(pooling on)
Database=myDatabase;Data Source=h50mysql11.secureserver.net;User Id=myRoot;Password=myPassword

Error happens on and off, may occur the first time a query is made, may occur after 20 queries are made.

Last few errors have occurred in MySql.Data.MySqlClient.PacketReader.ReadHeader().

I'm considering switching to MS SQL because up until this point I have not found any good support online. Any help would be appreciated.

- Bob

How to repeat:
Unfortunately, I cannot give solid instructions on how to repeat.  My guess would be to use the settings in my description.  I can provide a url to my site if necessary.

[1 Mar 2007 16:25] Bob Harrod

html showing error output

Attachment: error.htm (text/html), 5.04 KiB.

[4 Mar 2007 2:31] Bob Harrod

It has been suggested that since the database is shared (hosted solution), the "max connections" limit may be helping to cause this error.  In the hosted environment, this is set to 1,000.  According to tests in a dedicated environment, 200 simultaneous users only use 7 connections, so this translates to a load of 28,500 users necessary to max out the 1,000 connection threshold.

Please advise.

[8 Mar 2007 13:58] Bob Harrod

Developer error, this has been resolved.

[13 Mar 2007 12:31] Tonci Grgin

Hi Bob. Thank you for taking the time to write to us and for your interest in MySQL.