Devart Forums

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?

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

Same problem here.

When is this version coming up ?

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.

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.

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.

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.

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

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

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

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

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

Please, check timeout settings of your connection.

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

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.