Bug #59608 Workbench crash when exporting data to local file from remote server
Submitted: 19 Jan 2011 10:15 Modified: 17 Mar 2011 9:54
Reporter: Tony Walker Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: Administration Severity:S2 (Serious)
Version:5.2.31a OS:Windows (XP sp3)
Assigned to: CPU Architecture:Any

[19 Jan 2011 10:15] Tony Walker
Description:
Running Workbench v5.2.31a, I connected to a remote server over a WAN, using a Server Instance with NO remote management option enabled (neither SSH nor Windows Native). The MySQL database version is 5.1.43 sp1 enterprise.
When I click on Data Dump I get the following error in the Log box:

Error updating DB: DbMySQLQuery.resultFieldStringValueByName(): MySQL_ResultSet::getString: invalid value of columnIndex.

Ignoring this, I continued with a database structure export to disk (single file, no_data). 
At this point, Workbench vrashes out - this crash is captured by Windows, not workbench ("MySQL Workbench has encountered a problem and needs to close")

The details from the Windows report are:
AppName: mysqlworkbench.exe      AppVer: 5.2.31.7115     AppStamp:4d04ebea
ModName: libmysql.dll      ModVer: 0.0.0.0      ModStamp:4b8c387c
fDebug: 0       Offset: 0003794c

How to repeat:
As above.

I can also repeat this error by simply connecting to the same remote server and waiting a minute in the form.
[19 Jan 2011 10:47] Tony Walker
Correction to last post:
I can replicate the crash by opening the remote server administration connection, clicking on Data Dump tab and waiting. Sometimes this crashes when clicking on the tab. 

I've also had this without the initial error displayed in the log display box on the Data Dump tab. What is consistent is that the system crashes completely and it's caught by Windows.

More information from the Help option:
MySQL Workbench CE for Windows version 5.2.31
Configuration Directory: C:\Documents and Settings\walkert\Application Data\MySQL\Workbench
Data Directory: C:\Program Files\MySQL\MySQL Workbench 5.2 CE
Cairo Version: 1.8.8
Rendering Mode: OpenGL is available on this system, but GDI was requested. Using GDI for rendering.
OS: Microsoft Windows XP Professional Service Pack 3 (build 2600)
CPU: 2x Intel(R) Core(TM)2 Duo CPU     T5670  @ 1.80GHz, 2.0 GiB RAM
Active video adapter: Mobile Intel(R) 965 Express Chipset Family
Installed video RAM: 384 MB
Current video mode: 1280 x 800 x 65536 colors
Used bit depth: 16
Driver version: 6.14.10.4873
Installed display drivers: igxprd32.dll
Current user language: English (United Kingdom)
[25 Jan 2011 17:38] Valeriy Kravchuk
What exact version, x.y.z, the remote MySQL server is?
[26 Jan 2011 9:05] Tony Walker
The MySQL database version is 5.1.43 sp1 enterprise.
[16 Feb 2011 10:52] Valeriy Kravchuk
Do you see anything unusual in the error log of remote MySQL server for the periods when you get this problem in Workbench?
[16 Feb 2011 11:30] Tony Walker
Give me a clue what I'm looking for - I wouldn't know unusual if it bit me. But you should know that this happens every time for every remote server I look after - it's not a one-time thing, so I wouldn't expect to see anything specific.
Those servers are also across a couple of versions of the enterprise database, so again I wouldn't expect that this is server-side.

Are there enough details for you to try to replicate the problem, or so you need anything more from me? I will provide it but I will need specific instructions.

Thanks.
[17 Feb 2011 7:54] Valeriy Kravchuk
I am on XP SP3, and I do not see any problems trying to use DataDump for remote 5.1.56 on Linux, suing instance without remote management. I wish I know why...
[17 Feb 2011 8:53] Tony Walker
Turns out I didn't put enough information on this call after all! What I neglected to mention is that all the servers I'm connecting to are Windows servers. The remote admin connection is not configured to use SSH or native Windows remote management, just set to DB Only. 
The windows servers vary, but in general are Windows 2003 Servers and capably-powered. I'm connecting to them over a managed network VPN (always on from our network to our client's network). The VPN and firewalls do not allow SSH or Windows Native Remote Management, or believe me I'd enable one of them!
[17 Mar 2011 9:53] Tony Walker
I downloaded 5.2.33 and this problem seems to no longer affect Workbench. I think that this can be closed now. Thanks very much for your time!
[17 Mar 2011 9:54] Tony Walker
Fixed in 5.2.33
[11 Aug 2011 11:47] Kumar Vikram Dev
Hi,
I am facing this crash problem very frequently in Version 5.2.34. I have Windows XP professional (SP 3) on my machine. It crashes everytime I try to take a dump in a local file on my PC from a remote machine.