Bug #76594 MySQL workbench freezes

• Submitted: 4 Apr 2015 14:42
• Modified: 16 Feb 2018 22:56
• Reporter: Tomas Krejci
• Status: Closed
• Category: MySQL Workbench
• Severity: S3 (Non-critical)
• Version: 6.2.5
• OS: MacOS (OS X 10.10.x Yosemite)
• 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.