Bug #67129 Migrating from SQL Server 2008 to MySql, a 5GB database. I get an insufficient
Submitted: 8 Oct 2012 7:09 Modified: 20 Mar 2013 15:41
Reporter: larry lubman Email Updates:
Status: Verified Impact on me:
Category:MySQL Workbench: Migration Severity:S1 (Critical)
Version:5.2.44 OS:Windows (Microsoft Windows 7 Service Pack 1 (build 7601), 64-bit)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[8 Oct 2012 7:09] larry lubman
Simply migrating from SQL Server 2008 to MySql.  All steps seem to be OK, no errors or issues or warnings about compatibility.  Everything is created, but then, during data transfer, it takes a very long time and finally crashes with error, Program can't continue, insufficient memory, or something like that.  

----- Developer Notes -----

MySQL Workbench CE for Windows version 5.2.44  revision 9933
Configuration Directory: C:\Users\Larry\AppData\Roaming\MySQL\Workbench
Data Directory: C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE
Cairo Version: 1.8.8
OS: Microsoft Windows 7  Service Pack 1 (build 7601), 64-bit
CPU: 8x Intel(R) Core(TM) i7-2600 CPU @ 3.40GHz, 16.0 GiB RAM
Active video adapter (0): mv video hook driver2
Installed video RAM: 0 MB
Current video mode: 1920 x 1200 x 4294967296 colors
Used bit depth: 32
Driver version:
Installed display drivers: NULL
Active video adapter (1): NVIDIA GeForce GT 420
Installed video RAM: 1024 MB
Current video mode: 1600 x 1200 x 4294967296 colors
Used bit depth: 32
Driver version:
Installed display drivers: nvd3dumx.dll,nvwgf2umx.dll,nvwgf2umx.dll,nvd3dum,nvwgf2um,nvwgf2um
Current user language: English (United States)

Exception = System.OutOfMemoryException
Message = Insufficient memory to continue the execution of the program.
FullText = System.OutOfMemoryException: Insufficient memory to continue the execution of the program.
   at System.Runtime.InteropServices.Marshal.AllocCoTaskMem(Int32 cb)
   at System.Windows.Forms.UnsafeNativeMethods.GetWindowText(HandleRef hWnd, StringBuilder lpString, Int32 nMaxCount)
   at System.Windows.Forms.Control.get_WindowText()
   at System.Windows.Forms.TextBoxBase.get_WindowText()
   at System.Windows.Forms.TextBoxBase.ScrollToCaret()
   at MySQL.Forms.TextBoxImpl.append_text(TextBox* self, basic_string<char\,std::char_traits<char>\,std::allocator<char> >* text, Boolean scroll_to_end)
   at MySQL.MCallback3<void\,mforms::TextBox \*\,std::basic_string<char\,std::char_traits<char>\,std::allocator<char> > const \&\,bool>.cpp_callback(TextBox* a1, basic_string<char\,std::char_traits<char>\,std::allocator<char> >* a2, Boolean a3)
   at boost.function0<bool>.()(function0<bool>* )
   at TimerHandler.timer_tick(Object sender, EventArgs e)
   at System.Windows.Forms.Timer.OnTick(EventArgs e)
   at System.Windows.Forms.Timer.TimerNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

How to repeat:
I was migrating 5GB database, schema, functions/view/stored procedured, and data.
[8 Oct 2012 13:32] MySQL Verification Team
Thank you for the bug report. Please check if related or duplicate of http://bugs.mysql.com/bug.php?id=66516 . Thanks.
[8 Oct 2012 23:19] larry lubman
This does look like it could be related to Bug #66516 but it is a bit hard to follow that since the errors are in Spanish/Portugese?  I can't see specifically if they are getting the out of memory error.  

I can duplicate this, I've run it twice.  Is there something I can provide to help prove this?
[9 Oct 2012 18:37] MySQL Verification Team
Thank you for the feedback. Please describe the steps you did and which point the crash happens. Thanks.
[9 Oct 2012 21:09] larry lubman
Hmmm, thought I did describe the steps in the original description.  I set up a migration using the wizard, SQL Server 2008 to MySql, migrating schemata, views, stored procedures, fuctions, and data.  Used all of the default settings.  Every stepped passed with no issues including the conversion report, no error or compatibility issues and all tables seemed to be created correctly.  The actual data migration started and was taking a very long time.  It eventually failed giving an out of memory error as described in the original report.
[18 Oct 2012 20:21] larry lubman
Any progress on this?  I'd really like to begin testing on our migrated database from MS SQL but I can't migrate because of this.
[20 Mar 2013 15:41] Armando Lopez Valencia
Thanks a lot to your report.
Our dev team its working on it.
[4 Apr 2014 12:08] MySQL Verification Team
http://bugs.mysql.com/bug.php?id=72231 marked as duplicate of this one.
[20 Feb 2017 9:54] MySQL Verification Team
https://bugs.mysql.com/bug.php?id=85055 marked as duplicate of this one.