Bug #88489 Not showing Result Grid on MySQL WorkBench
Submitted: 14 Nov 2017 20:43 Modified: 14 Nov 2017 22:03
Reporter: Lin Chen Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:6.3.9 OS:MacOS (HIgh Sierra Version 10.31.1)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[14 Nov 2017 20:43] Lin Chen
Description:
----[For better reports, please attach the log file after submitting. You can find it in /Users/linchen/Library/Application Support/MySQL/Workbench/log/wb.log]

After successfully running queries, the result grip is not showing 

Log is there: 

15:19:47 [INF][      Workbench]: Starting up Workbench
15:19:47 [INF][   WBContext UI]: Initializing workbench context UI with these values:
	base dir: /Applications/MySQLWorkbench.app/Contents/Resources
	plugin path: /Applications/MySQLWorkbench.app/Contents/PlugIns
	struct path: /Applications/MySQLWorkbench.app/Contents/Resources/grt
	module path: /Applications/MySQLWorkbench.app/Contents/PlugIns:/Applications/MySQLWorkbench.app/Contents/Resources/plugins
	library path: /Applications/MySQLWorkbench.app/Contents/Resources/libraries
	user data dir: /Users/linchen/Library/Application Support/MySQL/Workbench
	open at start: 
	open type: 
	run at startup: 
	run type: 
	Force SW rendering: No
	Force OpenGL: No
	quit when done: No
15:19:47 [INF][      WBContext]: WbContext::init
15:19:47 [INF][            WBA]: Looking for extension modules for WBA...
15:19:47 [INF][            WBA]: 0 extension modules found
15:19:47 [WRN][            grt]: /Users/linchen/Library/Application Support/MySQL/Workbench/connections.xml:30: link '626EDB63-13CE-458B-8D5F-2701A480D6B9' <object GrtObject> key=owner could not be resolved
15:19:47 [INF][      WBContext]: System info:
 	MySQL Workbench Community (GPL) for Mac OS X version 6.3.9 CE build 10690321 (64 bit)
	Configuration Directory: /Users/linchen/Library/Application Support/MySQL/Workbench
	Data Directory: /Applications/MySQLWorkbench.app/Contents/Resources
	Cairo Version: 1.10.2
	OS: unknown
	CPU: 8x Intel(R) Core(TM) i7-4870HQ CPU @ 2.50GHz - 16.00GiB RAM
No video adapter info available

15:19:47 [INF][    WQE backend]: Found auto-save workspace /Users/linchen/Library/Application Support/MySQL/Workbench/sql_workspaces/LinLocal-1.autosave
15:19:47 [INF][    WQE backend]: Found auto-save workspace /Users/linchen/Library/Application Support/MySQL/Workbench/sql_workspaces/Pubmatic_Raw_DB-2.autosave
15:19:47 [INF][    WQE backend]: Found auto-save workspace /Users/linchen/Library/Application Support/MySQL/Workbench/sql_workspaces/-1.autosave
15:19:47 [INF][    WQE backend]: Found auto-save workspace /Users/linchen/Library/Application Support/MySQL/Workbench/sql_workspaces/-2.autosave
15:19:48 [WRN][       WBModule]: OS detection failed, skipping OS support check.  OS string: 'unknown'
15:19:52 [INF][     SSH tunnel]: Starting tunnel
15:19:52 [INF][     SSH tunnel]: Existing SSH tunnel not found, opening new one
15:19:52 [INF][     SSH tunnel]: Opening SSH tunnel to 10.100.152.36
15:19:53 [INF][     SSH tunnel]: TunnelManager.wait_connection returned OK
15:19:53 [INF][     SSH tunnel]: SSH tunnel connect executed OK
15:19:55 [INF][SQL Editor Form]: Opened connection 'Pubmatic Raw DB' to MySQL Community Server (GPL) version 5.6.22-log
15:19:57 [ERR][MySQL Name Cache]: Exception while running refresh task: SELECT command denied to user 'lin.chen'@'10.100.152.36' for table 'func'
15:19:57 [ERR][SqlEditorSchemaTree]: Exception querying metadata from mysql.proc, will fallback to SHOW PROCEDURE: Exception: SELECT command denied to user 'lin.chen'@'10.100.152.36' for table 'proc'
15:20:56 [ERR][SQL Editor Form]: Error querying performance_schema.events_statements_current
: Exception: SELECT command denied to user 'lin.chen'@'10.100.152.36' for table 'events_statements_current'
15:20:57 [ERR][SQL Editor Form]: Error querying performance_schema.event_stages_history
: Exception: SELECT command denied to user 'lin.chen'@'10.100.152.36' for table 'events_stages_history_long'
15:20:57 [ERR][SQL Editor Form]: Error querying performance_schema.event_waits_history
: Exception: SELECT command denied to user 'lin.chen'@'10.100.152.36' for table 'events_waits_history_long'
15:26:32 [INF][     SSH tunnel]: Existing SSH tunnel found, connecting
15:26:33 [INF][wb_admin_control.py:query_server_info:725]: WbAdminControl.connect_sql(): The server version stored in the server instance profile was "None". Changed to the version reported by the server: "5.6.22-log"
15:26:33 [INF][     SSH tunnel]: Existing SSH tunnel found, connecting
15:26:34 [INF][wb_admin_control.py:server_polling_thread:569]: Monitoring thread running...
15:26:37 [ERR][wb_admin_main.py:shutdown:219]: shutting down admn
15:26:40 [INF][wb_admin_control.py:server_polling_thread:585]: Monitoring thread done.
15:31:12 [ERR][SQL Editor Form]: Error querying performance_schema.events_statements_current
: Exception: SELECT command denied to user 'lin.chen'@'10.100.152.36' for table 'events_statements_current'
15:31:12 [ERR][SQL Editor Form]: Error querying performance_schema.event_stages_history
: Exception: SELECT command denied to user 'lin.chen'@'10.100.152.36' for table 'events_stages_history_long'
15:31:12 [ERR][SQL Editor Form]: Error querying performance_schema.event_waits_history
: Exception: SELECT command denied to user 'lin.chen'@'10.100.152.36' for table 'events_waits_history_long'

How to repeat:
Tried different ways the result is not showing 

see this 

https://stackoverflow.com/questions/24739198/mysql-workbench-not-displaying-query-results/...

the comment is "This was still happening to me on version 6.3.9 on OSX. I downloaded 6.1.7 again to actually see the result grid again.

What a pain in the butt!"

Multiple people still experiencing this and it's not fixed.
[14 Nov 2017 20:44] Lin Chen
MySQL Workbench Log file

Attachment: wb.log.txt (text/plain), 4.73 KiB.

[14 Nov 2017 20:44] Lin Chen
Showing no result screenshot

Attachment: Screen Shot 2017-11-14 at 3.43.54 PM.png (image/png, text), 259.13 KiB.

[14 Nov 2017 21:16] Joe Polcari
6.2.5 has the same results in case it helps. Had to downgrade to 6.1.7
[14 Nov 2017 22:03] MySQL Verification Team
Thank you for the bug report. Duplicate of https://bugs.mysql.com/bug.php?id=87714.