Bug #63032 Data export and Restore, very unstable

• Submitted: 31 Oct 2011 10:35
• Modified: 16 Jul 2014 3:31
• Reporter: Bengt Walther
• Status: Can't repeat
• Category: MySQL Workbench: Administration
• Severity: S2 (Serious)
• Version: 5.3.35.7915
• OS: Any
• CPU Architecture: Any

[31 Oct 2011 10:35] Bengt Walther

Description:
Data Export and Restore section/functions are in general unstable and unreliable. Ill try to make one report per perceived problem.

Starting the administrator, and quickly switching to "Data Export and Restore" quite often invokes a fatal crash. 
On other occasions it works beautifully, no apparent pattern is emerging. 

General info:
I'm connected to remote databases using a stable 10/2Mbit DSL connection. 
The servers has 15 different Database Objects (about 100mb of data each) with about 40 tables each. 
I try to do regular data dumping as a sort of version control for the current project, i have switched to mysqldump since this just isnt working. 

 
Sysinfo:

MySQL Workbench CE for Windows version 5.2.35

Configuration Directory: C:\Users\<removed>\AppData\Roaming\MySQL\Workbench

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

OS: Microsoft Windows 7 Ultimate Edition Service Pack 1 (build 7601), 64-bit

CPU: 2x Intel(R) Core(TM)2 Duo CPU     P8800  @ 2.66GHz, 4.0 GiB RAM

Active video adapter: NVIDIA GeForce GTX 260M

Installed video RAM: 1024 MB

Current video mode: 1920 x 1200 x 4294967296 colors

Used bit depth: 32

Driver version: 8.17.12.6089

Installed display drivers: nvd3dumx.dll,nvwgf2umx.dll,nvwgf2umx.dll,nvd3dum,nvwgf2um,nvwgf2um

Current user language: Svenska (Sverige)

How to repeat:
Use Data Export and Restore continuously for a while.
Go back and forth between different items in the left menu. 
Do several data dumps.

[31 Oct 2011 13:04] Valeriy Kravchuk

What exact server version, 5.x.y, are you working with? Do you have any other, concurrent activity on this server when you try to export data? I wonder if this is just some lock wait related problem.

[31 Oct 2011 13:47] Bengt Walther

Same problem various servers, but these two running now. 
5.1.58-1ubuntu
5.0.51a-3ubuntu5.5

Nothing running on the servers except MySQL and various OS related processes (no apache etc) no one else is working on the data. 
The application using the data only does simple Selects towards what is largely myism tables (some inno). 
But, even so, it still fails sometimes when no other clients are connected to the database, and on multiple systems.

[31 Oct 2011 15:18] Alfredo Kojima

How much data is in the tables, how long does it take to perform the dump (when it's able to finish) and how slow is the connection?

[1 Nov 2011 8:34] Bengt Walther

119 Mb
9 Minutes
Measured to 10 Mbit/s

[1 Nov 2011 11:43] Alfredo Kojima

I was able to repeat this crash as described, although only once out of several tries.

[26 Jun 2013 0:51] Alfredo Kojima

Does this still happen with WB 6.0.2?

[16 Jul 2014 3:31] Alfredo Kojima

Closing as can't repeat, as this is an old bug and there's no evidence of it still being around