Bug #73446 MySQL Workbench Server Management Failure
Submitted: 31 Jul 2014 13:23 Modified: 28 Oct 2015 19:28
Reporter: Daniel Cole Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Workbench: Administration Severity:S2 (Serious)
Version:6.1.7.11891 build 1788 OS:MacOS (10.9.4)
Assigned to: CPU Architecture:Any

[31 Jul 2014 13:23] Daniel Cole
Description:
Unable to interact with management tools. Application is unresponsive or crashes.

Traced error:

Traceback (most recent call last):
  File "/Applications/MySQLWorkbench.app/Contents/Resources/libraries/workbench/notifications.py", line 34, in _the_observer
    obs(name, sender, args)
  File "/Applications/MySQLWorkbench.app/Contents/PlugIns/wb_admin_grt.py", line 379, in attachToSQLEditor
    context = AdministratorContext(sender)
  File "/Applications/MySQLWorkbench.app/Contents/PlugIns/wb_admin_grt.py", line 117, in __init__
    self._check_instance_profile()
  File "/Applications/MySQLWorkbench.app/Contents/PlugIns/wb_admin_grt.py", line 154, in _check_instance_profile
    if autoDetectLocalInstance(self.connection):
  File "/Applications/MySQLWorkbench.app/Contents/PlugIns/wb_admin_grt.py", line 455, in autoDetectLocalInstance
    profiles = get_profiles_for("MacOS X", version)
  File "/Applications/MySQLWorkbench.app/Contents/PlugIns/wb_admin_grt.py", line 433, in get_profiles_for
    if data.has_key("sys.system") and data["sys.system"] == system:
AttributeError: 'NoneType' object has no attribute 'has_key'
/Applications/MySQLWorkbench.app/Contents/Resources/mysql.profiles/CMakeLists.txt:1: parser error : Start tag expected, '<' not found
set(DATA_FILES 

How to repeat:
1. Launch App
2. Connect to localhost
3. Go to 'Server,' 'Management Access Settings' -- this consistently got the app to crash, though there were errors and unresponsiveness in other areas as well.

Suggested fix:
in Contents/PlugIns/wb_admin_gr.py, the autoDetectLocalInstance function is erroring out at line 433 because it's trying to parse a text file (Contents/Resources/mysql.profiles/CMakeList.txt) as XML. To address this, i added a regular expression match to the 'for f in files' loop to make sure it's an xml extension before trying to call the 'has_key' method on the object.
[3 Aug 2014 15:34] MySQL Verification Team
Thank you for the bug report. I couldn't repeat on the below environment, is there another condition besides the steps provided?:

MySQL Workbench Community (GPL) for Mac OS X version 6.1.7  revision 11891 build 1788
Configuration Directory: /Users/miguel/Library/Application Support/MySQL/Workbench
Data Directory: /Applications/MySQLWorkbench.app/Contents/Resources
Cairo Version: 1.10.2
OS: OS X 10.9.x Mavericks
CPU: 4x Intel(R) Core(TM) i5-3210M CPU @ 2.50GHz - 16.00GiB RAM
[5 Aug 2014 13:47] Daniel Cole
I'm not sure there were any other preconditions...

I first installed the MySQL fresh from the DMG
then ran $./scripts/mysql_install_db

$ mysql --version
mysql  Ver 14.14 Distrib 5.6.19, for osx10.7 (x86_64) using  EditLine wrapper

And here is my python version. 
$ python --version
Python 2.7.5

Please let me know if there's any other information that might be useful.

Thanks
Daniel
[22 Aug 2014 20:42] Alfredo Kojima
Could you try version 6.2.1 beta whether you can still repeat this with it?
[23 Sep 2014 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[28 Oct 2015 19:14] Denis Petrov
Resources/mysql.profiles/CMakeList.txt should just be deleted from distribution.
[28 Oct 2015 19:28] MySQL Verification Team
Also tested with 6.3.5.
[28 Oct 2015 19:46] Denis Petrov
Appears to have been resolved in 6.3.5, thanks!