MySQL Bugs: #62869: Workbench dies in Ubuntu when importing and exporting

Bug #62869	Workbench dies in Ubuntu when importing and exporting
Submitted:	21 Oct 2011 16:58	Modified:	4 Feb 2012 19:30
Reporter:	Mike Bates	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Workbench: Administration	Severity:	S2 (Serious)
Version:	5.2.35	OS:	Linux (Ubuntu 64bit)
Assigned to:		CPU Architecture:	Any
Tags:	import export crash

Description:
I am using Workbench to manage Amazon RDS databases. When I try to import or export databases that are over 20MB (that being the size of the exported sql file) workbench will often die before the import /export has completed.

It doesn't happen every time, and if I try the import or export again a few times I'll eventually 'get lucky' and it will complete.

When it dies, the application just disappears, rather than freezing. It's as though I used the kill command to shut it down. I don't get any error messages, and I can't find any log files in /var/log/ for workbench so I don't know where to get more information on what is going wrong.

This was a problem in 5.2.34 as well.

How to repeat:
Open Workbench
Click on Manage Import / Export
Select a remote Server that has a large enough database

Export:
Check the checkbox for the large database
Select either the folder you want to export to or the file you want to export to
Click Start Export
Wait for a few minutes.

Import:
Click on the Import from Disk tab
Select the folder or file to import from 
Click Start Import
wait for a few minutes

Suggested fix:
I have no suggestions as I can't find any log files that could indicate what the underlying issue is.

Can you try repeating the crash after starting WB from a terminal and when it crashes, copy/paste the output here?

I can confirm that this bug is also present on Windows 7 and Mac Snow Leopard - last two releases crash.

Terminal dispays nothing when the application terminates, Windows displays a generic Windows error stating that the program has stopped working.

Here is a suggestion:  install WB yourself on either Windows 7 or Mac - I guarantee it will crash when you try and export a large db.

Believe me, we tried and it doesn't crash. Windows7, XP, Vista, OSX 10.5, 10.6, 10.7 all flavours of Linux etc. You name it, it doesn't crash. There's some specific thing that causes the crash that nobody can 
tell us what it is and that we can't find out either.

Please, check if the same problem still happens with a newer version, 5.2.36. If it does, we still need the output form the terminal that Workbenhc is started from...

This is still happening on the new version in Ubuntu.

I ran workbench from the Terminal:
/usr/bin/mysql-workbench

Then clicked Manage Import / Export and selected a reasonably large remote database. (The database creates export files around 20MB when it works)

Then I Selected the database schema to export, chose an export location (into a dump project folder, not a self-contained file) and ran the export. I got about half the tables before mysql died.

Attached is the output from the Terminal

2012-12-29 Terminal Output

Attachment: terminal output.txt (text/plain), 66.31 KiB.

Please try version 5.2.37. Thanks.

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