Description:
----[For better reports, please attach the log file after submitting. You can find it in /Users/Mac/Library/Application Support/MySQL/Workbench/log/wb.log]
MySQL Workbench sporadically crashes every 3rd or 4th time I run a simple "SELECT * FROM <table>" query. When I reopen MySQL Workbench, then magically, the same query will run fine. Then I try to modify the query slightly (changing the WHERE clause) and suddenly Workbench crashes and shuts down again, and I have to open the application back up. When it comes back up, I'm able to run the exact same query I had just attempted, and this time it will work fine.
See log file below:
====================================================
14:53:15 [INF][ Workbench]: Starting up Workbench
14:53:15 [INF][ WBContext]: Parsing application arguments.
14:53:15 [INF][ WBContext]: /Applications/MySQLWorkbench.app/Contents/MacOS/MySQLWorkbench
14:53:15 [INF][ WBContext]: -psn_0_23627399
14:53:15 [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/Mac/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
14:53:15 [INF][ WBContext]: WbContext::init
14:53:15 [INF][ WBA]: Looking for extension modules for WBA...
14:53:15 [INF][ WBA]: 0 extension modules found
14:53:15 [WRN][ grt]: /Applications/MySQLWorkbench.app/Contents/Resources/data/table_templates.xml:21: link 'com.mysql.rdbms.mysql.datatype.timestamp' <object db.SimpleDatatype> key=simpleType could not be resolved
14:53:15 [WRN][ grt]: /Applications/MySQLWorkbench.app/Contents/Resources/data/table_templates.xml:106: link 'com.mysql.rdbms.mysql.datatype.varchar' <object db.SimpleDatatype> key=simpleType could not be resolved
14:53:15 [WRN][ grt]: /Applications/MySQLWorkbench.app/Contents/Resources/data/table_templates.xml:229: link 'com.mysql.rdbms.mysql.datatype.int' <object db.SimpleDatatype> key=simpleType could not be resolved
14:53:15 [WRN][ grt]: /Users/Mac/Library/Application Support/MySQL/Workbench/connections.xml:26: link 'EB8B1244-B42A-470E-8EDF-1B918A746689' <object GrtObject> key=owner could not be resolved
14:53:15 [INF][ WBContext]: System info:
MySQL Workbench Community (GPL) for Mac OS X version 6.3.7 CE build 1199 (64 bit)
Configuration Directory: /Users/Mac/Library/Application Support/MySQL/Workbench
Data Directory: /Applications/MySQLWorkbench.app/Contents/Resources
Cairo Version: 1.10.2
OS: OS X 10.11.x El Capitan
CPU: 4x Intel(R) Core(TM) i5-3427U CPU @ 1.80GHz - 4.00GiB RAM
14:53:15 [INF][ WQE backend]: Found auto-save workspace /Users/Mac/Library/Application Support/MySQL/Workbench/sql_workspaces/Prod-1.autosave
14:53:15 [INF][ WQE backend]: Found auto-save workspace /Users/Mac/Library/Application Support/MySQL/Workbench/sql_workspaces/QA-DB-1.autosave
14:53:24 [INF][ SqlEditor]: Opened connection 'Prod' to Percona XtraDB Cluster (GPL), Release rel76.3, Revision aa929cb, WSREP version 25.16, wsrep_25.16 version 5.6.30-76.3-56-log
14:53:25 [INF][ AutoCCache]: Initializing autocompletion cache for Prod
14:53:28 [ERR][SqlEditorSchemaTree]: Exception querying metadata from mysql.proc, will fallback to SHOW PROCEDURE: Exception: SELECT command denied to user 'administrator'@'98.183.167.146' for table 'proc'
14:58:32 [ERR][ SqlEditor]: Error querying performance_schema.events_statements_current
: Exception: SELECT command denied to user 'administrator'@'98.183.167.146' for table 'events_statements_current'
14:58:32 [ERR][ SqlEditor]: Error querying performance_schema.event_stages_history
: Exception: SELECT command denied to user 'administrator'@'98.183.167.146' for table 'events_stages_history_long'
14:58:32 [ERR][ SqlEditor]: Error querying performance_schema.event_waits_history
: Exception: SELECT command denied to user 'administrator'@'98.183.167.146' for table 'events_waits_history_long'
15:10:24 [ERR][ SqlEditor]: Error querying performance_schema.events_statements_current
: Exception: SELECT command denied to user 'administrator'@'98.183.167.146' for table 'events_statements_current'
15:10:24 [ERR][ SqlEditor]: Error querying performance_schema.event_stages_history
: Exception: SELECT command denied to user 'administrator'@'98.183.167.146' for table 'events_stages_history_long'
15:10:24 [ERR][ SqlEditor]: Error querying performance_schema.event_waits_history
: Exception: SELECT command denied to user 'administrator'@'98.183.167.146' for table 'events_waits_history_long'
15:10:29 [ERR][ SqlEditor]: Error querying performance_schema.events_statements_current
: Exception: SELECT command denied to user 'administrator'@'98.183.167.146' for table 'events_statements_current'
15:10:29 [ERR][ SqlEditor]: Error querying performance_schema.event_stages_history
: Exception: SELECT command denied to user 'administrator'@'98.183.167.146' for table 'events_stages_history_long'
15:10:29 [ERR][ SqlEditor]: Error querying performance_schema.event_waits_history
: Exception: SELECT command denied to user 'administrator'@'98.183.167.146' for table 'events_waits_history_long'
How to repeat:
- Open MySQL Workbench on a MacBook Air running OS X 10.11
- Run a "SELECT * FROM <table> WHERE <column> = <value>" query. Success.
- Now, run the same query again, several times if necessary, with reasonable pauses in between. At least one of these subsequent executions will immediately cause Workbench to shut down.
- Re-open MySQL Workbench. Run the same query as above. Success.
