Solved

Lost connection to MySQL server during query

Posted on 2009-06-30
5
669 Views
Last Modified: 2012-05-07
Creating an asp.net web app against mysql database (with webhost4life hosting).

Locally the data pages work great.  I can add, edit and delete data fine.

After I deploy it, using the production mysql db I keep getting this error when trying to add data:

Lost connection to MySQL server during query

It is a simple add record!  How can I fix this?  Is a timeout happening?  Again, a SIMPLE SQL INSERT!  (Using xsd dataset in VS 2008 with a business class accessing the xsd query.)
0
Comment
Question by:RobertNZana
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 

Expert Comment

by:nrazon
ID: 24749952
Sometimes when a table or index corruption can give same results (lost connection to mysql query).

My suggestion is to optimize, repair or recreate table again.
(Backup if you have data in tables or create new copy of tables and change your application to use new tables to test)
0
 
LVL 33

Expert Comment

by:snoyes_jw
ID: 24751486
Before doing all that, check MySQL's error log and see if the server crashed and restarted right about then. It might be a known bug.
0
 
LVL 9

Author Comment

by:RobertNZana
ID: 24751665
I am using webhost4life hosting.  Do you know how I can check their logs?
0
 
LVL 33

Expert Comment

by:snoyes_jw
ID: 24754340
Usually you must email or open a trouble ticket and ask.
0
 
LVL 9

Accepted Solution

by:
RobertNZana earned 0 total points
ID: 24800636
I upgraded my connector to the latest at devart.com and it seems to have fixed it.  Plus I added a timeout in the web.config.
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question