Lost Connection to MySQL server during query

Alatriste · Post by **Alatriste** » Sun 19 Oct 2008 00:33

Hello.

I am using dbForge Studio for MySql. Version 3.0.182. Professional Edition.

Everytime i try to run any large query I receive the error:
Los Connection to MySQL server during query.

I am running the same query with the MYSQL browser GUI and works fine.

LOAD DATA INFILE "C:/10182008.csv" IGNORE INTO TABLE teventos FIELDS TERMINATED BY ","

I am using WAMP with MYSQL v 5.0.51b running on top of Windows Professional XP SP3.

I read all the posts with the same error but I have a 24 hours time out configured for MySQL connections and it continue doing the same.

Is there a work around?

Thanks a lot.

A.

Duke · Post by **Duke** » Mon 20 Oct 2008 07:14

There are two timeout settings for connection: one for connect procedure and one for query execution. Please make sure that you have correctly configured the last one.

Alatriste · Post by **Alatriste** » Mon 20 Oct 2008 17:43

One question.

If I can do the query from the MySQL Browser GUI. Is dbForge Studio using other settings?

All the SELECT queries works fine. Only the INSERT ones are timing out.

what would be the parameter name to check?

Duke · Post by **Duke** » Tue 21 Oct 2008 07:10

MySQL Query Browser does not have timeout settings (maybe they are just set to infinite).

Alexz · Post by **Alexz** » Tue 21 Oct 2008 13:50

You can set execution timeout on the Advanced tab of the Database Connection Properties dialog box. You can find this dialog from popup menu of connection node in Database Explorer window.
Execution timeout is a client option, which allows to interrupt execution of query if server doesn't respond for a long time.

Alatriste · Post by **Alatriste** » Fri 24 Oct 2008 14:40

Thanks a lot. This seems to worked fine. Anyway the maximum time in second is 7200 (2 hours) that must be enough for most of the cases.

Alatriste · Post by **Alatriste** » Mon 24 Nov 2008 00:26

I set them both to 7200 (it seems to be the longest time), anyway sometimes it works some time does not.
I opted to go back to the MySQL Browser for this long queries

Alexz · Post by **Alexz** » Mon 24 Nov 2008 08:13

You can set timeout to 0 (infinite). MySQL Browser uses this value by default. After that your long query can be executed in dbForge too.

warp · Post by **warp** » Wed 17 Dec 2008 05:15

i have been having the same issues, i get that lost connection error, even though this works flawlessly with the query application that comes with mysql tools.
i even tried using a long timeout delay for both fields, and use zero too. but this doesnt work. my query uses 2 inner joins.

what can i do about it?

Duke · Post by **Duke** » Wed 17 Dec 2008 15:42

warp wrote:i have been having the same issues, i get that lost connection error, even though this works flawlessly with the query application that comes with mysql tools.
i even tried using a long timeout delay for both fields, and use zero too. but this doesnt work. my query uses 2 inner joins.

what can i do about it?

Could you please post the full version of the product?

warp · Post by **warp** » Wed 17 Dec 2008 15:55

i am using the query builder, the latest version from the site.
my sql 5.0.5b

warp · Post by **warp** » Thu 25 Dec 2008 20:33

bump!

any news regarding this issue ?

Duke · Post by **Duke** » Fri 26 Dec 2008 07:53

We couldn't reproduce the problem with Query Builder. But we have updated the product recently. You can upgrade it and try once more.
It is also possible that you are having problems with MySQL server itself, because you are using unstable version.

warp · Post by **warp** » Fri 26 Dec 2008 08:00

http://download.devart.com/dbforge/mysq ... rmysql.exe

it says 404, is it just me or the file is missing ?

Duke · Post by **Duke** » Fri 26 Dec 2008 08:09

We'll fix this as soon as possible.

Devart Forums

Lost Connection to MySQL server during query

Lost Connection to MySQL server during query

Time Out