MySQL Bugs: #90613: Workbench Results Grid does not appear when executing query.

Bug #90613	Workbench Results Grid does not appear when executing query.
Submitted:	24 Apr 2018 16:15	Modified:	27 Sep 2018 14:22
Reporter:	Mike Bennett	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	8.0	OS:	Windows (Server 2012 R2)
Assigned to:		CPU Architecture:	Any

Description:
The results grid does not appear when executing a query.

How to repeat:
Open a new query window and enter a valid SQL statement
Select Query, Execute from the menu or click the execute button

The Results Grid does not appear.

Select Query, Explain Current Statment

Visual Explain appears

You can now select Results Grid from the right side of the screen, but next time you execute the query it will disappear again.

Hello Mike Bennett,

Thank you for the bug report.
I could not repeat the issue at our end using with MySQL workbench 8.0.11 version.
Could you please provide repeatable steps (exact steps, screenshot, provide full MySQL Workbench Log file (start MySQLWorkbench.exe -log-level=debug3) etc. - please make it as private if you prefer) to confirm this issue at our end?

Thanks,
Chiranjeevi.

The issue seems to have resolved itself, the results windows is appearing this morning.

Sorry to waste your time.

Mike

Thank you for feedback, I am closing this bug

I keep getting this problem over and over. Only way is to close/reopen the workbench. It then occur again after a few queries.

Can't pin-point a way to reproduce this reliably though, but it's happening so often that I switch to a terminal and use mysql command line!

By so often I mean that once re-opened, it can occur on the very first query or after a few queries, and rarely after many queries.

Not to mention that upon reopening it'll take 2 minutes before any queries is executed, and it will crash 1 time out of 5, making the workbench unusable even before I can use it!

Hi, 

I just upgraded to Version 8.0.12 build 13312926 CE (64 bits) yesterday and this is effecting me. It's the same behavior described above: when you close and restart workbench it may work well for a short period of time, but after a bit, the results grid stops showing up at the completion of a query.

I've just suffered from this - no Results Grid in a SQL query tab once a query has been executed.

Quitting Workbench and then restarting seems to fix this, grid has failed to disappear again so far.

Bug proof with workbench version

Attachment: workbench_bug.png (image/png, text), 65.36 KiB.

It's getting more and more common for me to hit this bug. As shown on the print screen I attached, I have queries that take minutes to load, and when they finally do: NOTHING - then I have to restart workbench and re-run them.

This is duplicate of Bug #91265, please see Bug #91265

I am also getting this same issue on version 8.0.12. The results returned sub-windows is not showing. Only way to get it back is to restart Workbench but eventually it stops showing again.

Hi Sorry any update on this issue, it has been pased 2 months from the last update

I am also experiencing same issue.

Using build 8.0.12.

It is very annoying, pretty sure it happens always after a query that fails. (meaning, when it happens, it was after a failed query - not all failed queries cause this)

For example happened after this error:

15:27:05	CALL `someStoredProcedure`('123', 0, 'someMeta', null,null,null)	Error Code: 1054. Unknown column 'sjm.ref_obj_1' in 'field list'	0.312 sec

I tried to do a query, and no results are shown. The only thing that helps is restarting workbench