MySQL Bugs: #54372: Screen Flash when Query Executes

Bug #54372	Screen Flash when Query Executes
Submitted:	9 Jun 2010 16:24	Modified:	18 Jul 2010 16:00
Reporter:	Kim Upper	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S2 (Serious)
Version:	5.2.22 OSS RC	OS:	Windows (Windows 7, 64 Bit)
Assigned to:		CPU Architecture:	Any

Description:
When I execute a query, I get screen flashing on the entire screen. I believe workbench is causing a screen re-draw of the entire monitor (in my case both monitors) rather than just the workbench window. The flicker/redraw is most severe the text editor Edit Pad Pro, but appears in other windows.

I have noted instability in Edit Pad Pro since upgrading from 5.2.21 to 5.2.22. I have no idea if this is related to 5.2.22 or to this particular issue. In general, my system seems less stable while using 5.2.22 than it did with 5.2.21.

How to repeat:
1) Use a large monitor or dual monitors
2) Make the Workbench SQL editor window as small so you can see other windows
3) Open several windows. Firefox works, issue is most evident in a text editor called Edit Pad Pro (www.editpadpro.com). If using Edit Pad Pro, open a bunch of windows and the file panel.
4) Write several select statements. One will work, but the problem is more evident with multiple statements.
5) Hit execute and observe windows other than the Workbench Window. You should notice screen flicker and/or redraw in the other windows. If you are testing with EditPadPro, look particularly at the file panel.

Suggested fix:
Redraw ought to be confined to the Workbench window.

Given the system instability issues I am experiencing, particularly with EditPadPro (and I've never had this sort of problem with EditPadPro before), I would look at memory issues as well as redraw.

Please, send the results from Help > System Info menu item.

MySQL Workbench OSS for Windows version 5.2.22

Cairo Version: 1.8.8

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

OpenGL Driver Version: 3.2.0

OS: Microsoft Windows 7 Home Premium Edition (build 7600), 64-bit

CPU: 4x Intel(R) Core(TM) i5 CPU         650  @ 3.20GHz, 7.9 GiB RAM

Video adapter info:

Adapter type: NVIDIA GeForce GTS 250

Chip Type: GeForce GTS 250

BIOS String: Version 62.92.79.0.90

Video Memory: 1048576 KB

I was able to repeat with dual monitor 1920 by 1080 pixels:

MySQL Workbench OSS for Windows version 5.2.22

Cairo Version: 1.8.8

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

OpenGL Driver Version: 3.3.9836 Compatibility Profile Context

OS: Microsoft Windows Vista Ultimate Edition Service Pack 2 (build 6002), 64-bit

CPU: 4x AMD Phenom(tm) 9650 Quad-Core Processor, 8.0 GiB RAM

Video adapter info:

Adapter type: ATI Radeon HD 4650

Chip Type: ATI display adapter (0x9498)

BIOS String: 113-465XZDFS4    

Video Memory: 1048576 KB

To me this issue looks very much like a hardware problem or something with certain software like the editor you mentioned. I cannot reproduce this behavior on my machines.

Can you try on other boxes, maybe even one with the same graphics board? Does the flickering appear for all your boxes? Can you give us more info like if you see differences in behavior depending on what windows are on screen (and their state, like maximized, normal, maybe even some minimized windows). Is there any service running in the background that could come up with a window (like messengers, virus scanners etc.)? Any info that could help me reproducing the problem is appreciated.

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