Lost connection to MySQL server during query

kellyaa · Post by **kellyaa** » Fri 29 Dec 2006 18:58

I have a server running MySql 5.0.27 with a 10gb database and a 2gb database. Both databases use the MyISAM engine. Most queries against these databases take 2-3 minutes to complete, and work as expected in the MySQL Query Browser.

Any query I try to run using MySql Developer Studio 1.51.33 errors out with the message "Lost connection to MySQL server during query" after about 30 seconds. This happens even if I run from localhost. How can i fix this, is there a timeout setting that needs to be adjusted?

Duke · Post by **Duke** » Tue 02 Jan 2007 07:34

Unfortunately, current version does not allow to adjust timeout settings. Right now we are working over the new version that will include timeout settings.

cesarvegamx · Post by **cesarvegamx** » Wed 31 Jan 2007 07:33

Same problem here.

When is this version coming up ?

kellyaa · Post by **kellyaa** » Tue 26 Jun 2007 16:37

I have the latest build and have my Execute Timeout set to "0" in the advanced connection properties. I'm still having exactly the same problem. If a query takes longer than a 60 seconds to run I receive the "Lost Connection to MySQL server during query" error, and the query stops.

I do not have any problems with long-running queries using the free MySQL GUI tools.

Duke · Post by **Duke** » Mon 02 Jul 2007 06:42

I have the latest build and have my Execute Timeout set to "0" in the advanced connection properties. I'm still having exactly the same problem.

The problem should not appear in this case. We'll check this out.

Duke · Post by **Duke** » Wed 04 Jul 2007 12:18

We've check this again. The problem does not appear. But let me give you a clue.
60 seconds is the value for net_write_timeout server parameter. This parameter is the number of seconds to wait for a block to be written to a connection before aborting the write. Actually, it's the server who cuts off the connection.
In MySQL Developer we increase this parameter for the session to 2 hours. Server version should be higher than 4.0.21.
To see actual value of net_write_timeout parameter perform
show local variables query.

kellyaa · Post by **kellyaa** » Wed 18 Jul 2007 21:04

My net_write_timeout is set to 72000 and I'm using MySql Server v5.0.41 (MyISAM tables), I'm still having the "lost connection to server during query" problem on any large query or script batch, when using MySql Developer Studio v2.0.49 (I don't use the vs integrated dev tools).

I can run the exact same script batch from the same client computer against the same server/database using MySql Query Browser without problem.

slobbering_dog · Post by **slobbering_dog** » Thu 06 Sep 2007 07:32

I have just downloaded the SQL Development studio - it looks good.

however, I hjave the exact same issue. Stored procedures won't run in CrLabs Dev Studio (version 2.xx something), but will run using MySQL browser and Navicat MySQL 8.0.

I like the CRLabs software better, but I can't run a single stored procedure.

Has there been an answer to this previous post ?

I am connecting from my laptop (Vista Business) using Developer Studio to my RH5_64bit server, MySQL 5.0.22 - 1gb network.

Best regards,

slobbering_dog

Duke · Post by **Duke** » Fri 07 Sep 2007 12:26

Finally, we have located the problem and fixed it. In a week we'll release the new version with this fix.

slobbering_dog · Post by **slobbering_dog** » Mon 17 Sep 2007 00:57

I was just wondering if there has been any progres son the updated release as my trial period is running out and I would like to give this software a good trial before deciding whether or not to buy it.

Cheers,

Slobbering Dog

slobbering_dog · Post by **slobbering_dog** » Wed 10 Oct 2007 04:25

New version of Developer (2.10.68) seems to have cured the problem and I have bought the software.

Looks great so far !!

regards,

slobbering_dog

prashanthan · Post by **prashanthan** » Wed 23 Apr 2008 14:48

I am using MyDeveloper studio version 2.10.78 and still getting this issue.

Duke · Post by **Duke** » Mon 05 May 2008 07:17

Please, check timeout settings of your connection.

robertnzana · Post by **robertnzana** » Mon 06 Jul 2009 03:05

How do you set the timeout in the web.config?

Shalex · Post by **Shalex** » Mon 06 Jul 2009 13:37

Here is an example that shows how the connection string with the Connection Timeout and Default Command Timeout parameters can be set in web.config.

Code: Select all

Devart Forums