MySQL Bugs: #55490: MySQL Workbench Administration tab doesn't display or update properly

Bug #55490	MySQL Workbench Administration tab doesn't display or update properly
Submitted:	22 Jul 2010 21:31	Modified:	3 Nov 2010 17:09
Reporter:	Tony Freixas	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: Administration	Severity:	S2 (Serious)
Version:	5.2.25 CE	OS:	Windows (XP SP3)
Assigned to:	Maksym Yehorov	CPU Architecture:	Any
Tags:	administration display

Description:
When I open an Administration tab, nothing draws properly on that tab until I move the window a few pixels.

The same is true for any redraws or updates to the display. So after doing anything, I have to move the window a few pixels to see what happened. In some (but not all) cases, the display might eventually update on its own, but it takes a while—moving the window updates everything instantly.

None of the other tabs shows the same problem.

How to repeat:
Not sure how you would repeat it. I don't see a lot of complaints about this, so it may be specific to some hardware on my PC.

On my PC, simply opening an Administration tab is all it takes.

Suggested fix:
Make the Administration tab work like all the others.

Thank you for the bug report. Are you able to provide a screen-shot which shows that issue?. Thanks in advance.

I have attached an image but I'm not sure how it will help you.

Basically, what appears to be happening is a very slow, CPU-intensive rendering of the screen areas. The load goes way up and the window eventually finishes rendering (eventually could mean 30 seconds and up—sometimes I got tired of waiting.

The key here is that the Home tab, the SQL development tab and the Data Modeling tabs all work properly, so it's not a video card problem (although it may be that the problem only shows itself on my video card, an NVIDIA GeForce 7600 GS, driver version 6.14.11.9621).

Please, send the results of Help > System Info menu item. I want to check if OpenGL is used.

Many thanks for all your informations. We will analyse this.

this looks like its coming from the same problem as in Bug #52949

This bug has been marked as a duplicate of a bug that is fixed and yet I continue to experience the problem with version 5.2.28 CE. I've changed the severity to S2, since the Admin functionality is seriously impaired.

The work-around appears to be to move the window a few pixels after any possible display change.

I realize not many other people are experiencing this problem or it would have been fixed by now. I don't know what's special about the Admin stuff—Data Modeling and SQL Development both work fine. It's possible that I have an unusual setup or a bad driver, but it seems that if the other two features display fine, then the Admin tools should also be able to work properly on my system.

I renamed the only global installation of Python that I have and the display problems persisted. I used Process Explorer to check which Python DLL was being used and it was the Workbench's version.

The System Info option reported:

Option verbose  skipped because of missing value

Option standalone  skipped because of missing value

Option one-thread  skipped because of missing value

Option des-key-file  skipped because of missing value

Option innodb_rollback_on_timeout  skipped because of missing value

Option slave-skip-errors  skipped because of missing value

Option large-pages  skipped because of missing value

Option bootstrap  skipped because of missing value

Exception in thread Thread-1:

Traceback (most recent call last):

  File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\python\threading.py", line 525, in __bootstrap_inner

    self.run()

  File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\python\threading.py", line 477, in run

    self.__target(*self.__args, **self.__kwargs)

  File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\modules\wba_monitor_be.py", line 443, in read_from_script

    if line[0] == 'C':

IndexError: string index out of range

MySQL Workbench CE for Windows version 5.2.28

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

Cairo Version: 1.8.8

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

OpenGL Driver Version: 2.1.2

OS: Microsoft Windows XP Professional Service Pack 3 (build 2600)

CPU: 2x AMD Athlon(tm) 64 X2 Dual Core Processor 4200+, 2.7 GiB RAM

Video adapter info:

Adapter type: NVIDIA GeForce 7600 GS

Chip Type: GeForce 7600 GS

BIOS String: Version 5.73.22.51.51

Video Memory: 524288 KB

Current user language: English (United States)

Exception in thread Thread-3:

Traceback (most recent call last):

  File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\python\threading.py", line 525, in __bootstrap_inner

    self.run()

  File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\python\threading.py", line 477, in run

    self.__target(*self.__args, **self.__kwargs)

  File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\modules\wba_monitor_be.py", line 565, in poll_sources

    cmd.poll()

  File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\modules\wba_monitor_be.py", line 405, in poll

    self.ch.stdin.write("cpu\r\n")

IOError: [Errno 22] Invalid argument

I learned that the Server Administration feature is a plugin that is written in Python, unlike the Data Modeling and SQL Development features. That explains why the bug only appears there.

I am changing the Duplicate status back to Open since the bug that this was marked as being a duplicate of has been fixed and this has not fixed the problem that I see.

The bug needs to be re-evaluated with next WB release.

Hi Tony,
can you try latest release (5.2.29) to see if the problem still persists?
thanks in advance

Looks like it's fixed. Thanks!

fixed in release 5.2.29

An entry has been added to the 5.2.29 changelog:

Screen areas in the Administrator did not redraw correctly, it was necessary to move the main window in order to force a redraw.