MySQL Bugs: #56667: MySQL Workbench

Bug #56667	MySQL Workbench
Submitted:	8 Sep 2010 22:52	Modified:	15 Jun 2011 11:58
Reporter:	Ross Whitehead	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Workbench: Administration	Severity:	S3 (Non-critical)
Version:	5.2.26, 5.2.27, 5.2.31a	OS:	Windows
Assigned to:		CPU Architecture:	Any

Description:
Received an unhandled GDI+ error when going to the Logs tab in MySQL Workbench.

We are sorry for the inconvenience but an unexpected exception has been raised by one of the MySQL Workbench modules. In order to fix this issue we would kindly ask you to file a bug report. You can do that by pressing the [Report Bug] button below. 

Please make sure to include a detailed description of your actions that lead to this problem.

Thanks a lot for taking the time to help us improve MySQL Workbench!

The MySQL Workbench Team

How to repeat:
Open workbench and go to logs tab.

Thank you for the bug report. Could you please provide the output of Help->System Info. Thanks in advance.

MySQL Workbench CE for Windows version 5.2.26

Data Directory: C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE

Cairo Version: 1.8.8

Rendering Mode: OpenGL is not available on this system, so GDI is used for rendering.

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

CPU: 4x Dual Core AMD Opteron(tm) Processor 280, 7.9 GiB RAM

Video adapter info:

Adapter type: RAGE XL  PCI (Microsoft Corporation)

Chip Type: ATI RAGE XL PCI (B41)

BIOS String: GR-xlacrs3p.003-4.328

Video Memory: 8192 KB

I also realized that it is when I open the Slow Query Log, the General Log opens fine.

Thank you for the feedback. Please try version 5.5.27. Thanks in advance.

I upgraded and rebooted.

Now when I go to the Logs tab I get the following:

Unhandled exception: Error executing 'SELECT count(*) as count from mysql.slow_log;
2013. Error 2013

I only get the error on the 1'st time I go to the tab then it is fine till I hit refresh.

Here is my info again:
x32 on x64

get_server_version: parsed (5, 1, 50)

Traceback (most recent call last):

  File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\modules\wb_admin_configuration.py", line 206, in tab_changed

    panel.page_activated()

  File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\modules\wb_admin_logs.py", line 294, in page_activated

    self.refresh()

  File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\modules\wb_admin_logs.py", line 302, in refresh

    self.slow_log.refresh()

  File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\modules\wb_admin_logs.py", line 186, in refresh

    result = self.owner.dbconn.executeQuery("SELECT count(*) AS count FROM mysql.slow_log")

  File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\modules\wb_admin_utils.py", line 250, in executeQuery

    raise QueryError("Error executing '%s':\n%s"%(query, error), error)

wb_admin_utils.QueryError: Error executing 'SELECT count(*) AS count FROM mysql.slow_log':

2013. Error:2013

Traceback (most recent call last):

  File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\modules\wb_admin_logs.py", line 124, in refresh

    raise Exception("Error fetching log contents: %s" % e)

Exception: Error fetching log contents: Error executing 'SELECT count(*) AS count FROM mysql.general_log':

2006. Error:2006

MySQL Workbench CE for Windows version 5.2.27

Data Directory: C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE

Cairo Version: 1.8.8

Rendering Mode: OpenGL is not available on this system, so GDI is used for rendering.

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

CPU: 4x Dual Core AMD Opteron(tm) Processor 280, 7.9 GiB RAM

Video adapter info:

Adapter type: RAGE XL  PCI (Microsoft Corporation)

Chip Type: ATI RAGE XL PCI (B41)

BIOS String: GR-xlacrs3p.003-4.328

Video Memory: 8192 KB

Thank you for the feedback.

Error "Error executing 'SELECT count(*) AS count FROM mysql.slow_log': 2013. Error:2013" looks like server error. Please send us full MySQL server error log file.

When I run the following query, 'SELECT count(*) AS count FROM mysql.slow_log;' it executes successfully and returns 106 as the count.

Here is the most recent porting of the MySQL log since the last shutdown:

100908 20:03:14 [Note] C:\MySQL\bin\mysqld: Normal shutdown

100908 20:03:14 [Note] Event Scheduler: Purging the queue. 0 events
100908 20:03:15  InnoDB: Starting shutdown...
100908 20:03:18  InnoDB: Shutdown completed; log sequence number 14 377287758
100908 20:03:18 [Note] C:\MySQL\bin\mysqld: Shutdown complete

100908 20:07:09 [Note] Plugin 'FEDERATED' is disabled.
100908 20:07:13  InnoDB: Started; log sequence number 14 377287758
100908 20:07:13 [Note] Event Scheduler: Loaded 0 events
100908 20:07:13 [Note] C:\MySQL\bin\mysqld: ready for connections.
Version: '5.1.50-community-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
100908 20:10:11 [Warning] Aborted connection 4 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
100908 20:14:07 [Warning] Aborted connection 3 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
100908 20:14:07 [Warning] Aborted connection 2 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)

The GDI error you get, does it happen every time you go to the Logs tab?
If so, can you right-click on the exception dialog and copy/paste the Stack Trace to this bug?
Thanks

I recieve the following error everytime I go to the tab:
Error "Error executing 'SELECT count(*) AS count FROM mysql.slow_log':
2013. Error:2013" looks like server error. Please send us full MySQL server error log file.

I tried right-clicking on the windows error dialog but did not have any options to copy/paste the Stack Trace

What happens when you execute that query from a command line client to the same server with same account?

hm sorry, someone else already asked you that... in this case, can you enable general-log in the server and see what is being sent around the time (all queries from the connection from WB) you try to select the Logs tab?

Also, please try Workbench 5.2.31a, there's a chance that a bug fix from that version could fix mysterious bugs like this.

I downloaded the 5.2.31a and am now receiving the following error:

Unhandled Exception: 'NoneType' object has no attribute 'nextRow'

When this unhandled exception will appeat again, please, right click somewhere in the error dialog box with no text and use Copy stack trace to clipboard menu item to get a stack trace. Send stack trace to this report.

I must be doing something wrong as I can't get the right click copy stack trace to work no matter where I click.

Could You please try with the newest Version?

Thanks in advance!

I tried that on the 18'th but could not get Workbench to start up.  I had to revert to an older version :-(

I even tried uninstall all versions of WorkBench, deleting the folder in Program Files and reinstalling the new version.

Here are the messages I was receiving:

EventType clr20r3, P1 mysqlworkbench.exe, P2 5.2.33.7506, P3 4d795bbb,
P4 base.windows, P5 1.0.0.0, P6 4d79587d, P7 f, P8 9, P9 system.dllnotfoundexception, P10 NIL.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Application: MySQLWorkbench.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.DllNotFoundException
Stack:
   at MySQL.Utilities.SysUtils.Win32.DwmIsCompositionEnabled()
   at MySQL.Utilities.ControlUtilities.IsCompositionEnabled()
   at MySQL.GUI.Workbench.MainForm.AdjustGlassFrame(Int32)
   at MySQL.GUI.Workbench.MainForm.DockDocument(MySQL.Controls.ITabDocument,
Boolean, Boolean)
   at MySQL.GUI.Workbench.MainForm.ApplicationCommand(MySQL.Forms.AppCommand,
MySQL.Forms.AppViewImpl, System.String)
   at MySQL.Forms.AppImpl.app_command_wrapper(std.basic_string<char,std::char_traits<char>,std::allocator<char>
>*, MySQL.Forms.AppCommand, mforms.AppView*,
std.basic_string<char,std::char_traits<char>,std::allocator<char> >*)
   at MySQL.Forms.AppImpl.dock_view(mforms.App*, mforms.AppView*, std.basic_string<char,std::char_traits<char>,std::allocator<char> >*)
   at MySQL.MCallback3<void\,mforms::App \*\,mforms::AppView \*\,std::basic_string<char\,std::char_traits<char>\,std::allocator<char>
> const \&>.cpp_callback(mforms.App*, mforms.AppView*,
std.basic_string<char,std::char_traits<char>,std::allocator<char> >*)
   at <Module>.wb.WBContextUI.init(wb.WBContextUI*,
wb.WBFrontendCallbacks*, wb.WBOptions*)
   at MySQL.Workbench.WbContext.init(MySQL.Forms.AppImpl,
MySQL.Workbench.WbOptions, VoidStrUIFormDelegate)
   at MySQL.GUI.Workbench.Program.Main(System.String[])

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Ross,

Are you trying to see the log of your local machine? what MySQL server version you have installed? are you working on a remote server?

Thanks in advance.

I am just trying to open Workbench.  It crashes when starting.

I am running 5.1.50

I am RDP'd into the server which has MySQL installed.

I recognize the crashes of the application are not directly related to the inability to view log files.  Since I can't even run the latest version, I suggest we close this case.

Hi Ross,

May you please install the newest version of the WB?, try to reproduce the error and if you can, get the screenshot of the error and include it on the report, besides that please right-click on the error message to get a popup menu with the menu item "copy stack to clipboard" and also include the stacktrace on the report.

Thanks in advance.

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

MySQL Workbench 5.2.34

When I click on logs immediately the following is displayed:

Unhandled exception: Error fetching log contents: Error executing 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-50, 50' at line 1'
SELECT * FROM mysql.general_log ORDER BY event_time DESC LIMIT -50, 50.
SQL Error: 1064

Hello Ross.
Can you please provide your my.ini file?
(C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.x\my.ini)
Thanks.

We have since upgraded and are no longer experiencing the problem.

Does not happen with current version.

I'm having it on 5.2.44 Revision 9933

exactly this statement: Unhandled Exception: 'NoneType' object has no attribute 'nextRow'

I'm Users and Privileges, in the Server Access Management / Login screen, having added an account
 - the account was already present but with a different host associated
 - the new account/host was working until I only had left privileges for localhost
 - as I added account/host details at the Schema Privileges level, I pressed Apply, and got back on the Server Access Management screen

clicking on the old user/host pair, or any other one apart from the new one, I got such exception

and the privileges do not get saved on the database... 
I keep getting back and reinserting at the schema level

p.s. I'm on OsX 10.7.5

Unhandled Exception: 'NoneType' object has no attribute 'nextRow'

Attachment: exception.png (image/png, text), 23.18 KiB.

p.s. (again) it seems a duplicate of #56608, #54288, #56035 
... and they all have been automatically closed for missing informations :(