Bug #71464 Error during "Visual Explain" on MySQL Workbench 6.1.1
Submitted: 24 Jan 2014 0:47 Modified: 7 Feb 2014 6:50
Reporter: Ryusuke Kajiyama Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:6.1.1 OS:MacOS (10.9.1)
Assigned to: CPU Architecture:Any

[24 Jan 2014 0:47] Ryusuke Kajiyama 
Description:
When executing visual explain, following error message pops up.
Detail version of MWB is 6.1.1.11562 build 1158.

Error during "Visual Explain"
error calling Python module function SQLIDEQueryAnalysis.visualExplain

How to repeat:
Execute visual explain of any SQL statement.

Suggested fix:
If any prerequisites, add into Installation Instructions.
[24 Jan 2014 0:47] Ryusuke Kajiyama 
screen shot

Attachment: MWB611_MacOS1091.jpg (image/jpeg, text), 301.12 KiB.
[24 Jan 2014 12:13] Alfredo Kojima 
What's the server version?
[24 Jan 2014 12:14] Alfredo Kojima 
Also, can you attach the wb.log file? You can find it via Help -> Locate Log Files
[24 Jan 2014 12:29] MySQL Verification Team 
On Mac Maverick

Attachment: explain.png (image/png, text), 233.16 KiB.
[24 Jan 2014 12:31] MySQL Verification Team 
I couldn't repeat on Maverick Mac

MySQL Workbench Community (GPL) for Mac OS X version 6.1.1  revision 11562 build 1158
Configuration Directory: /Users/miguel/Library/Application Support/MySQL/Workbench
Data Directory: /Applications/MySQLWorkbench 2.app/Contents/Resources
Cairo Version: 1.10.2
OS: unknown
CPU: 4x Intel(R) Core(TM) i5-3210M CPU @ 2.50GHz - 16.00GiB RAM
[25 Jan 2014 3:24] Ryusuke Kajiyama 
Good point.
I was testing with 5.7.3 (x86_64) and got this error.
No errors with 5.6.x.
[27 Jan 2014 22:49] MySQL Verification Team 
Thank you for the feedback. Indeed is repeatable only when connected with a 5.7.3 MySQL Server. Workbench 6.0.8 isn't affected for this bug.
[27 Jan 2014 22:53] MySQL Verification Team 
Explain against 5.7.3

Attachment: explain_573.png (image/png, text), 197.29 KiB.
[5 Feb 2014 19:44] Johannes Taxacher 
Posted by developer:
 
fix confirmed in 6.1.2.11647. visual explain now also working with server 5.7
[7 Feb 2014 6:50] Philip Olson 
Fixed as of the upcoming MySQL Workbench 6.1.2 release, and here's the changelog entry:

The "Visual Explain" feature did not function with MySQL Server 5.7.

Thank you for the bug report.