MySQL Bugs: #52383: MySQL Workbench has encountered a problem

Bug #52383	MySQL Workbench has encountered a problem
Submitted:	26 Mar 2010 1:22	Modified:	17 Jun 2010 14:35
Reporter:	Thomas Ferraro	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: Administration	Severity:	S2 (Serious)
Version:	5.2.16 OSS, 5.2.22 build 5918	OS:	Windows
Assigned to:	Maksym Yehorov	CPU Architecture:	Any
Tags:	external component has thrown an exception

Description:
External Component has thrown an exception

How to repeat:
Open Server Administration to tcp/ip connection on server and viola!

Exception = System.Runtime.InteropServices.SEHException
Message = External component has thrown an exception.
FullText = System.Runtime.InteropServices.SEHException: External component has thrown an exception.
   at MySQL.Forms.DrawBoxImpl.drawbox_mouse_click(Object sender, MouseEventArgs e)
   at System.Windows.Forms.Control.OnMouseClick(MouseEventArgs e)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

What exact version of MySQL server, x.y.z, local or remote, you tried to work with?

5.1.19-beta-community-nt-debug accessed via tcp/ip connection remotely

MySQL 5.1.19 wasn't GA version.

Please try actual GA version of mysql server (5.1.45).

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".

Upgrade to MySql 5.1.45 was a failure... all backups were invalid.  Rolled back to 5.1.19 Beta until problem can be solved.

Leaving server problems aside, can you, please, try to use MySQL Workbench 5.2.20 with your current server version and check if original problem is still repeatable?

Testing to repeat problems cause new set of problems.

First attempt to start MySQL Workbench causes a forced reboot of machine similar in appearance to that of a power failure.  But there was no power failure.

This problem is repeatable.

I have attached screen shots (limited due to size) that I have attached.

Limited screen shots with output error messages

Attachment: 20100428 MySql WorkBench Gui 5.22 Forced Reboot Error Document2.zip (application/x-zip-compressed, text), 151.14 KiB.

Please, check with a newer version, 5.2.21, and inform about the results.

Well it doesn't throw and exception and doesn't cause a forced reboot.

But the same errors on Server Administration, Import/Export, Manage Security still exist.

Copied from output.

x32 on x32Traceback (most recent call last):

  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_grt.py", line 274, in openExportImport

    tab = do_open_administrator(server)

  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_grt.py", line 144, in do_open_administrator

    adminTab = AdministratorTab(server_instance)

  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_grt.py", line 90, in __init__

    self.ctrl_be = wb_admin_control_be.MyCtrl(server_instance_settings)

  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_control_be.py", line 614, in __init__

    if connect_sql and self.server_is_stopped_for_sure():

  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_control_be.py", line 866, in server_is_stopped_for_sure

    return self.is_running()

  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_control_be.py", line 905, in is_running

    result = self.exec_cmd(script, usesudo, password)

  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_control_be.py", line 990, in exec_cmd

    result = run_cmd(self.wrap_command(script, sudo), sudo, password)

  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_control_be.py", line 858, in wrap_command

    wcmd = "cmd.exe /C \"" + cmd + "\""

TypeError: cannot concatenate 'str' and 'NoneType' objects

x32 on x32Traceback (most recent call last):

  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_grt.py", line 288, in openSecurityManager

    tab = do_open_administrator(server)

  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_grt.py", line 144, in do_open_administrator

    adminTab = AdministratorTab(server_instance)

  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_grt.py", line 90, in __init__

    self.ctrl_be = wb_admin_control_be.MyCtrl(server_instance_settings)

  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_control_be.py", line 614, in __init__

    if connect_sql and self.server_is_stopped_for_sure():

  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_control_be.py", line 866, in server_is_stopped_for_sure

    return self.is_running()

  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_control_be.py", line 905, in is_running

    result = self.exec_cmd(script, usesudo, password)

  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_control_be.py", line 990, in exec_cmd

    result = run_cmd(self.wrap_command(script, sudo), sudo, password)

  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_control_be.py", line 858, in wrap_command

    wcmd = "cmd.exe /C \"" + cmd + "\""

TypeError: cannot concatenate 'str' and 'NoneType' objects

x32 on x32Traceback (most recent call last):

  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_grt.py", line 300, in tmpAdministratorShortcut

    tab = do_open_administrator(server)

  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_grt.py", line 144, in do_open_administrator

    adminTab = AdministratorTab(server_instance)

  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_grt.py", line 90, in __init__

    self.ctrl_be = wb_admin_control_be.MyCtrl(server_instance_settings)

  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_control_be.py", line 614, in __init__

    if connect_sql and self.server_is_stopped_for_sure():

  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_control_be.py", line 866, in server_is_stopped_for_sure

    return self.is_running()

  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_control_be.py", line 905, in is_running

    result = self.exec_cmd(script, usesudo, password)

  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_control_be.py", line 990, in exec_cmd

    result = run_cmd(self.wrap_command(script, sudo), sudo, password)

  File "C:\Program Files\MySQL\MySQL Workbench 5.2 OSS/modules\wb_admin_control_be.py", line 858, in wrap_command

    wcmd = "cmd.exe /C \"" + cmd + "\""

TypeError: cannot concatenate 'str' and 'NoneType' objects

Bug http://bugs.mysql.com/53001 was set as a duplicate of this one.

Thomas,
From the output you pasted I can assume that the server instance profile may not be valid. Please ensure that "Check MySQL status" command in the the server instance profile editor is not empty. It is on 'System Profile' tab.

New Server Instance Profile allows usage of Server Administration Features

Thomas, does this mean your problem is solved?

Creation of New Server Instance Profile solved the issue.

Issue is now closed.