Bug #62330 Execute more than one long query
Submitted: 2 Sep 2011 11:52 Modified: 26 Sep 2011 7:13
Reporter: Katja Kahl Email Updates:
Status: Not a Bug Impact on me:
Category:MySQL Workbench: SQL Editor Severity:S1 (Critical)
Version:5.2.34 CE Rev. 7780 OS:Microsoft Windows (Windows XP Prof.)
Assigned to: CPU Architecture:Any
Tags: execute query

[2 Sep 2011 11:52] Katja Kahl
while executing a long query, i can't start another query in a second query-tab on the connected server. The buttons "Execute SQL Script.." and "Execute current SQL Statement.." are disabled.

I tried to open a new connection tab and execute the second query there. On Click "Execute" an "unexpected error" occurs.

Workbench: 5.2.34 CE Revision 7780
OS: Windows XP Professional SP3
MySQL: 5,5,8 on Linux x86_64

How to repeat:
Start a long query. While this query is executing, try to start a second query on the same server in a second Query-Tab oder second connection.
[2 Sep 2011 12:08] Miguel Solorzano
Thank you for the bug report. Could you please provide the output of Help->System Info. It is a remote host connection?. It's expected a big dataset return from that query?. Thanks.
[2 Sep 2011 13:47] Katja Kahl
>>Could you please provide the output of Help->System Info.<<
It's still empty

>>It is a remote host connection?.<<

>>It's expected a big dataset return from that query?.<<
The dataset size is irrelevant.
I tried it again on two different machines: when i open 2 connections on the same server, execute simple querys on both pages, the second started query occurs the error. It occurs when the query from the first page is still running oder finished.
[9 Sep 2011 17:56] Alfredo Kojima
Each connection to a MySQL server can only be used to execute a single query. If you need to execute multiple queries in parallel, you need to open new connections. To do that, you can use Query -> New Tab to Current Server, or dbl-click the connection you want at the Home tab.
[26 Sep 2011 7:13] Katja Kahl
Always when i start a second connection and try to execute a query, the following error window appears: 
MySQL Workbench has encountered a problem
Eine externe Komponente hat eine Ausnahme ausgelöst ...

I can't execute a query in a second connection tab on the same server.