Solved

Lost connection to MySQL server during query

Posted on 2009-06-30
5
668 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
  • 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

User art_snob (http://www.experts-exchange.com/M_6114203.html) encountered strange behavior of Android Web browser on his Mobile Web site. It took a while to find the true cause. It happens so, that the Android Web browser (at least up to OS ver. 2.…
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

790 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