lost connection during execute

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
jkuiper
Posts: 138
Joined: Fri 04 Aug 2006 14:17

lost connection during execute

Post by jkuiper » Tue 20 Sep 2011 14:37

I have a table with a lot of data. If I want to change a default setting or add an index, DBForge Studio for MySQL 3.5 is not responding. After a while the connection is lost.

My example:

Code: Select all

ALTER TABLE nelis.bolnamen
  ADD UNIQUE INDEX btree_expnaamid (exporteur, naamid);
Error: Lost connection to MySQL server during query
Is there a setting that the query will be executed without losing a connection. In the tabform Database connection Properties -> Advanced the Execute Timeout is set to 0

jkuiper
Posts: 138
Joined: Fri 04 Aug 2006 14:17

Post by jkuiper » Tue 20 Sep 2011 14:43

If I reopen the conncetion I can see the created index. But I Don't know if the index is fully created.

.jp
Devart Team
Posts: 345
Joined: Wed 09 Sep 2009 06:55
Location: devart

Post by .jp » Wed 21 Sep 2011 07:11

You are using an old version of the tool. As far as I know, we did some fixes connected with lost connection while creating an index. So, please upgrade to the v5.0 of the tool and check whether the problem persists.

Post Reply