Bug #76594 MySQL workbench freezes
Submitted: 4 Apr 2015 14:42 Modified: 16 Feb 2018 22:56
Reporter: Tomas Krejci Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:6.2.5 OS:MacOS (OS X 10.10.x Yosemite)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[4 Apr 2015 14:42] Tomas Krejci
Description:
MySQL workbench freezes under conditions described below.

How to repeat:
I have long running query that creates a table and locks it's metadata for a long time. If I refresh SCHEMAS panel at left hand side of the screen it freezes MySQL Workbench until query is completed/

Suggested fix:
Asynchronous loading of metadata or timeout for it.
[6 Apr 2015 10:25] MySQL Verification Team
Thank you for the bug report. Are you able to provide (private if you wish) the long query create table?. Thanks.
[6 Apr 2015 11:15] Tomas Krejci
SET @csv_id = '';
SET @num = 1;
CREATE TABLE 100tick_data AS
SELECT
    `csv_id`,
    CONVERT(`datetime`, datetime) AS `datetime`,
    CAST(GROUP_FIRST(`open`) AS DECIMAL(32, 16)) AS `open`,
    MAX(`high`) AS `high`,
    MIN(`low`) AS `low`,
    CAST(GROUP_LAST(`close`) AS DECIMAL(32, 16)) AS `close`,
    SUM(`volume`) AS `volume`,
    SUM(`number_of_trades`) AS `number_of_trades`,
    SUM(`bid_volume`) AS `bid_volume`,
    SUM(`ask_volume`) AS `ask_volume`
FROM (
        SELECT
            d1.*,
            @num := IF(@csv_id = `csv_id`, @num + 1, 1) AS `dummy_1`,
            @csv_id := csv_id AS `dummy_2`,
            @num AS `row_number`
        FROM data d1
            ORDER BY `csv_id`, `datetime`) d
GROUP BY
    `csv_id`, d.`row_number` DIV 100;
[16 Apr 2015 15:13] MySQL Verification Team
Thank you for the feedback.
[16 Feb 2018 22:56] Christine Cole
Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 8.0.0 release, and here's the changelog entry:

If the SCHEMAS tree was refreshed during a long query, MySQL Workbench
became unresponsive until the query finished.

Thank you for the bug report.