Bug #109855 Select Statements on Tables Cause Crash to Desktop
Submitted: 31 Jan 4:34 Modified: 31 Jan 14:32
Reporter: Jon Zamboni Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:8.0 OS:MacOS
Assigned to: CPU Architecture:ARM

[31 Jan 4:34] Jon Zamboni 
Description:
Hi all--just installed Mysql + workbench and am trying to get a test schema up and running, however workbench crashes whenever I attempt to select any rows from the tables (this happens both when attempting to select them from the sidebar or when manually running a SELECT query from the prompter.) Other prompts (creating tables, insert rows, etc.) seem to be working fine. 

Note this doesn't appear to be an issue with the specific tables I've created, it also occurs when attempting to SELECT rows from the sys_config table on the server's sys schema.

I'm running Workbench 8.0 and MySQL 8.0.32-arm64 on a 2021 iMac Apple M1.

How to repeat:
Either a SELECT statement in the prompt or the sidebar shortcuts will trigger a crash to desktop.
[31 Jan 4:36] Jon Zamboni 
Unfortunately the log files don't appear to be of much use. The following is recorded on connecting to the server:

[23:19:56 [INF][      Workbench]: Starting up Workbench
23:19:56 [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/jonathan/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
23:19:56 [INF][      WBContext]: WbContext::init
23:19:56 [INF][            WBA]: Looking for extension modules for WBA...
23:19:56 [INF][            WBA]: 0 extension modules found
23:19:56 [WRN][            grt]: Duplicate plugin name wb.tools.cmdlineClient There is more than one plugin with the name wb.tools.cmdlineClient (in PyWbUtils and PyWbUtils).
23:19:56 [WRN][            grt]: /Users/jonathan/Library/Application Support/MySQL/Workbench/connections.xml:18: link 'D1E64E4E-2D22-4642-BF07-FD31AC2537DD' <object GrtObject> key=owner could not be resolved
23:19:56 [WRN][            grt]: Duplicate plugin name wb.tools.cmdlineClient There is more than one plugin with the name wb.tools.cmdlineClient (in PyWbUtils and PyWbUtils).
23:19:56 [INF][      WBContext]: System info:
  MySQL Workbench Community (GPL) for macOS version 8.0.32 CE build 2612062 (64 bit)
Configuration Directory: /Users/jonathan/Library/Application Support/MySQL/Workbench
Data Directory: /Applications/MySQLWorkbench.app/Contents/Resources
Cairo Version: 1.17.6
OS: macOS 12.x Monterey x86_64
CPU: 8x Apple M1 - 16.00GiB RAM
No video adapter info available

23:19:57 [WRN][         mforms]: Resource file not found: wb_tile_sakila_dark@2x.png
23:19:57 [WRN][         mforms]: Resource file not found: wb_tile_manage_dark@2x.png
23:19:57 [WRN][         mforms]: Resource file not found: wb_tile_folder@2x.png
23:19:57 [WRN][         mforms]: Resource file not found: wb_tile_network_dark@2x.png
23:19:57 [WRN][         mforms]: Resource file not found: wb_tile_plus_dark@2x.png
23:19:57 [WRN][         mforms]: Resource file not found: wb_tile_user_dark@2x.png
23:19:57 [WRN][         mforms]: Resource file not found: wb_tile_plus_dark@2x.png
23:19:57 [WRN][         mforms]: Resource file not found: wb_doc_sql@2x.png
23:19:57 [WRN][         mforms]: Resource file not found: wb_tile_number_dark@2x.png
23:19:57 [WRN][         mforms]: Resource file not found: wb_close@2x.png
23:19:57 [WRN][         mforms]: Resource file not found: wb_tile_open_dark@2x.png
23:19:57 [WRN][         mforms]: Resource file not found: wb_tile_more_dark@2x.png
23:19:57 [WRN][         mforms]: Resource file not found: wb_tile_sakila_dark@2x.png
23:19:57 [WRN][         mforms]: Resource file not found: wb_tile_manage_dark@2x.png
23:19:57 [WRN][         mforms]: Resource file not found: wb_tile_folder@2x.png
23:19:57 [WRN][         mforms]: Resource file not found: wb_tile_network_dark@2x.png
23:19:57 [WRN][         mforms]: Resource file not found: wb_tile_plus_dark@2x.png
23:19:57 [WRN][         mforms]: Resource file not found: wb_tile_user_dark@2x.png
23:19:57 [WRN][         mforms]: Resource file not found: wb_tile_plus_dark@2x.png
23:19:57 [WRN][         mforms]: Resource file not found: wb_doc_sql@2x.png
23:19:57 [WRN][         mforms]: Resource file not found: wb_tile_number_dark@2x.png
23:19:57 [WRN][         mforms]: Resource file not found: wb_close@2x.png
23:19:57 [WRN][         mforms]: Resource file not found: wb_tile_open_dark@2x.png
23:19:57 [WRN][         mforms]: Resource file not found: wb_tile_more_dark@2x.png
23:19:58 [ERR][  GRTDispatcher]: exception in grt execute_task, continuing: Exception: Access denied for user 'root'@'localhost' (using password: NO)
23:19:58 [ERR][  GRTDispatcher]: worker: task 'execute sql queries' has failed with error:.Access denied for user 'root'@'localhost' (using password: NO)
23:20:02 [INF][SQL Editor Form]: Opened connection 'Local instance 3306' to MySQL Community Server - GPL version 8.0.32
23:20:02 [WRN][         mforms]: Resource file not found: snippet_sql@2x.png
23:20:02 [WRN][         mforms]: Resource file not found: busy_sidebar_mac@2x.png
23:20:02 [WRN][         mforms]: Resource file not found: busy_sidebar_mac@2x.png
23:20:02 [WRN][         mforms]: Resource file not found: busy_sidebar_mac@2x.png
23:20:02 [WRN][         mforms]: Resource file not found: wb_perform_config@2x.png
23:20:02 [WRN][         mforms]: Resource file not found: busy_sidebar_mac@2x.png
23:20:02 [WRN][         mforms]: Resource file not found: editor_statement@2x.png
23:20:02 [WRN][         mforms]: Resource file not found: editor_error@2x.png
23:20:02 [WRN][         mforms]: Resource file not found: editor_breakpoint@2x.png
23:20:02 [WRN][         mforms]: Resource file not found: editor_breakpoint_hit@2x.png
23:20:02 [WRN][         mforms]: Resource file not found: editor_current_pos@2x.png
23:20:02 [WRN][         mforms]: Resource file not found: editor_continue_on_error@2x.png
23:20:02 [WRN][         mforms]: Resource file not found: ac_keyword@2x.png
23:20:02 [WRN][         mforms]: Resource file not found: ac_schema@2x.png
23:20:02 [WRN][         mforms]: Resource file not found: ac_table@2x.png
23:20:02 [WRN][         mforms]: Resource file not found: ac_routine@2x.png
23:20:02 [WRN][         mforms]: Resource file not found: ac_function@2x.png
23:20:02 [WRN][         mforms]: Resource file not found: ac_view@2x.png
23:20:02 [WRN][         mforms]: Resource file not found: ac_column@2x.png
23:20:02 [WRN][         mforms]: Resource file not found: ac_operator@2x.png
23:20:02 [WRN][         mforms]: Resource file not found: ac_engine@2x.png
23:20:02 [WRN][         mforms]: Resource file not found: ac_trigger@2x.png
23:20:02 [WRN][         mforms]: Resource file not found: ac_logfilegroup@2x.png
23:20:02 [WRN][         mforms]: Resource file not found: ac_uservar@2x.png
23:20:02 [WRN][         mforms]: Resource file not found: ac_sysvar@2x.png
23:20:02 [WRN][         mforms]: Resource file not found: ac_tablespace@2x.png
23:20:02 [WRN][         mforms]: Resource file not found: ac_event@2x.png
23:20:02 [WRN][         mforms]: Resource file not found: ac_index@2x.png
23:20:02 [WRN][         mforms]: Resource file not found: ac_user@2x.png
23:20:02 [WRN][         mforms]: Resource file not found: ac_charset@2x.png
23:20:02 [WRN][         mforms]: Resource file not found: ac_collation@2x.png
]

But nothing is added at time of crash. The log files do seem to successfully record the queries despite the crash, however:

[[1, 23:21:19] SELECT * FROM sys.sys_config
LIMIT 0, 1000
: Running...
[1, 23:21:19] SELECT * FROM sys.sys_config
LIMIT 0, 1000
: Fetching...
[1, 23:21:19] SELECT * FROM sys.sys_config
LIMIT 0, 1000
: 6 row(s) returned]
[31 Jan 5:46] MySQL Verification Team 
Hello Jon Zamboni,

Thank you for the bug report.
Imho this is duplicate of Bug #109671, please see Bug #109671.

Regards,
Ashwini Patil
[31 Jan 14:32] Jon Zamboni 
Thanks very much, I bumped Workbench back to the 8.0.31 build as per the previous bug reports and it's working as intended.