Bug #55539 Workbench freezes when making large replacements in the editor
Submitted: 25 Jul 2010 20:21 Modified: 27 Jul 2012 8:52
Reporter: Siol En Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S5 (Performance)
Version:5.2.25 CE OS:Windows (XP SP3)
Assigned to: CPU Architecture:Any

[25 Jul 2010 20:21] Siol En 
Description:
After the replace of word (100000 in the list), MySQL Workbench freezed.

How to repeat:
Add word 100000 times and try to replace it with other word.
[26 Jul 2010 4:16] Valeriy Kravchuk 
Please, send the results of Help > System Info menu item.
[26 Jul 2010 16:20] Siol En 
MySQL Workbench CE for Windows version 5.2.25

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 Intel(R) Core(TM)2 Duo CPU     T7500  @ 2.20GHz, 2.0 GiB RAM

Video adapter info:

Adapter type: NVIDIA Quadro NVS 140M

Chip Type: Quadro NVS 140M

BIOS String: Version 60.86.3E.00.00

Video Memory: 524288 KB
[27 Jul 2010 13:59] MySQL Verification Team 
I couldn't repeat using however the below hardware:

MySQL Workbench CE for Windows version 5.2.25

Data Directory: C:\Program Files (x86)\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: 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
[29 Jul 2010 5:19] Susanne Ebrecht 
How much byte has your script?
[29 Jul 2010 12:30] Siol En 
5169KB
[30 Jul 2010 10:10] Roel Van de Paar 
Issue is easy to reproduce using a 13.6Mb SQL file and replacing "/" (a common character in the file) with lots of "////\\\\////\\\\......" (use 50-80 fwd/bckw slashes orso).

Process hangs for quite some time and was using a lot of CPU.

Captured a minidump so devs can have a look at what WB is doing, but likely it will just need more optimization/buffering/caching/optimized code for the editor...
[30 Jul 2010 10:24] Roel Van de Paar 
backtrace_bug55539.txt

Attachment: backtrace_bug55539.txt (text/plain), 51.37 KiB.
[27 Jul 2012 8:52] Philip Olson 
Fixed as of Workbench 5.2.41, and here's the changelog entry:

MySQL Workbench would freeze while attempting to search and replace
with a large number of strings, such as over 100,000.