MySQL Bugs: #65049: server status fields: no data

Bug #65049	server status fields: no data
Submitted:	20 Apr 2012 7:25	Modified:	7 Sep 2012 16:22
Reporter:	L Kooi	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Workbench: Administration	Severity:	S3 (Non-critical)
Version:	5.2.40	OS:	Windows (Microsoft Windows Server 2003, Standard Edition Service Pack 2 (build 3790))
Assigned to:		CPU Architecture:	Any
Tags:	WBBugReporter

Description:
The server monitor fields in server administration (cpu/server health etc.) display 'no data'. Viewing output shows this error:
WMIShell: Set filters for local windows cli

Exception in thread Thread-9:
Traceback (most recent call last):
  File "G:\sysapp\mysqlbench\Python\Lib\threading.py", line 530, in __bootstrap_inner
    self.run()
  File "G:\sysapp\mysqlbench\Python\Lib\threading.py", line 483, in run
    self.__target(*self.__args, **self.__kwargs)
  File "G:\sysapp\mysqlbench\modules\wba_monitor_be.py", line 666, in poll_sources
    cmd.poll()
  File "G:\sysapp\mysqlbench\modules\wba_monitor_be.py", line 554, in poll
    value = self.query(wmi_session, 'PercentProcessorTime', "SELECT PercentProcessorTime FROM Win32_PerfFormattedData_PerfOS_Processor WHERE Name = '_Total'")
  File "G:\sysapp\mysqlbench\modules\wba_monitor_be.py", line 536, in query
    res = self.wmi.wmiQuery(session, query)
SystemError: Workbench.wmiQuery(): WMI query execution failed.
Invalid class

How to repeat:
don't know

I couldn't repeat on the below VirtualBox environment:

WMIShell: start command set to 'sc start MySQL'

WMIShell: stop command set to 'sc stop MySQL'

WMIShell: status command set to 'sc query MySQL | wba_filter(RUNNING)'

WMIShell: Set filters for local windows cli

MySQL Workbench CE for Windows version 5.2.39  revision 8757

Configuration Directory: C:\Documents and Settings\Administrator\Application Data\MySQL\Workbench

Data Directory: C:\Program Files\MySQL\MySQL Workbench 5.2 CE

Cairo Version: 1.8.8

OS: Microsoft Windows Server 2003, Standard Edition Service Pack 2 (build 3790)

CPU: Intel(R) Core(TM) i7-2670QM CPU @ 2.20GHz, 2.0 GiB RAM

Active video adapter (0): VirtualBox Graphics Adapter

Installed video RAM: 16 MB

Current video mode: 1210 x 655 x 4294967296 colors

Used bit depth: 32

Driver version: 4.1.12.r77218

Installed display drivers: VBoxDisp.dll

Current user language: Portuguese (Brazil)

After Miguel Solorzanos report, I took a look at the WMI state of my server and repaired everything that seemed broken. Still the same, no server status fields and the same python error trace in the output.

Please provide a screen-shoot. Thanks.

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

screenshot of the situation

Attachment: mysqlwbscreen1.jpg (image/jpeg, text), 141.41 KiB.

screenshot of the output

Attachment: mysqlwbscreen2.jpg (image/jpeg, text), 73.33 KiB.

Hi Miguel, sorry for the late response. I've added 2 screenshots to this report.

Please, check if the same problem still happens with a newer version, 5.2.40.

Hi Valeriy, I'm sorry to have to report that the problem persists in v5.2.40

Hello.
Can you please provide more information about the MySQL server that you are connecting to (version) along with the output of: "Help->System Info"                                                               
Thanks.

You can find the version info in this webpage: http://testbed.nicon.nl/v8test/testjson.html

I'll upload a text file containing all info about the server (retrieved with MySQL WB ;-):

Please try version 5.2.41. Thanks.

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