Bug #72216 Error during "Visual Explain" on MySQL Workbench 6.1.4

• Submitted: 3 Apr 2014 6:39
• Modified: 14 May 2014 23:24
• Reporter: Nitin Mehta
• Status: Closed
• Category: MySQL Workbench: SQL Editor
• Severity: S3 (Non-critical)
• Version: 6.1.4
• OS: Windows (Windows 7)
• CPU Architecture: Any

[3 Apr 2014 6:39] Nitin Mehta

Description:
When executing visual explain, following error message pops up.
Detail version of MWB is 6.1.4.11773 CE

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

How to repeat:
Execute visual explain on any query.

[3 Apr 2014 6:39] Nitin Mehta

Affecting MySQL 5.6.15, 16 running on Windows and Linux.

[3 Apr 2014 7:43] MySQL Verification Team

Hello Nitin,

Thank you for the bug report.
Verified as described.

Thanks,
Umesh

[3 Apr 2014 7:44] MySQL Verification Team

Screenshot..

Attachment: 72216.png (image/png, text), 227.78 KiB.

[14 May 2014 23:24] Philip Olson

Fixed as of the upcoming MySQL Workbench 6.1.6 release, and here's the changelog entry:

Executing a Visual Explain would sometimes generate an error with the text
"Error calling Python module function SQLIDEQueryAnalysis.visualExplain".

Thank you for the bug report.

[28 Nov 4:55] Bishop Josh

That's a frustrating error to encounter! I've definitely run into issues with Workbench before, usually when the query optimizer is doing something unexpected. Have you tried simplifying the query or breaking it down into smaller parts to see if you can isolate the problem area? It might also be a long shot, but sometimes a fresh start helps clear things up. Kinda like hitting the slopes and needing a run to clear your head, you know? If all else fails, maybe take a break and try out Snow Rider 3D for a bit of distraction before tackling it again. https://snowriderfree.com/