MySQL Bugs: #67936: I try to copy 130k rows in Excel 2010 and the program stops responding for about

Bug #67936	I try to copy 130k rows in Excel 2010 and the program stops responding for about
Submitted:	18 Dec 2012 10:38	Modified:	13 Jun 2013 19:57
Reporter:	John Ericson	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	5.2.44	OS:	Windows (Microsoft Windows 8 Pro (build 9200), 64-bit)
Assigned to:		CPU Architecture:	Any
Tags:	WBBugReporter

Description:
After Excel hadn't responded in about 2 minutes I decided to terminate the process in the task manager. After that I find this error in the Workbench. The MySQL Workbench program was active in the background while I worked in Excel.

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

MySQL Workbench CE for Windows version 5.2.44  revision 9933
Configuration Directory: C:\Users\John\AppData\Roaming\MySQL\Workbench
Data Directory: C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE
Cairo Version: 1.8.8
OS: Microsoft  (build 9200), 64-bit
CPU: 8x Intel(R) Core(TM) i7-2630QM CPU @ 2.00GHz, 16.0 GiB RAM
Current user language: Swedish (Sweden)

Exception = System.Runtime.InteropServices.ExternalException
Message = Requested Clipboard operation did not succeed.
FullText = System.Runtime.InteropServices.ExternalException (0x800401D0): Requested Clipboard operation did not succeed.
   at System.Windows.Forms.Clipboard.ThrowIfFailed(Int32 hr)
   at System.Windows.Forms.Clipboard.GetDataObject(Int32 retryTimes, Int32 retryDelay)
   at System.Windows.Forms.Clipboard.GetDataObject()
   at System.Windows.Forms.Clipboard.ContainsText(TextDataFormat format)
   at System.Windows.Forms.Clipboard.ContainsText()
   at MySQL.Forms.ScintillaControl.get_CanPaste()
   at MySQL.GUI.Workbench.MainForm.EditCanPaste()
   at MySQL.Grt.RunWrappedDelegate0<bool\,bool\,MySQL::Grt::DelegateSlot0<bool\,bool>::ManagedDelegate>.native_callback()
   at boost.detail.function.function_invoker0<bool (__cdecl*)(void),bool>.invoke(function_buffer* function_ptr)
   at base.NotificationCenter.send(NotificationCenter* , basic_string<char\,std::char_traits<char>\,std::allocator<char> >* , Void* )
   at MySQL.Workbench.ManagedNotificationCenter.Send(String notification, IntPtr sender)
   at MySQL.GUI.Workbench.MainForm.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

How to repeat:
1) Have Workbench running in the background.
2) Copy extrem large amount of data in Excel 2010.
3) Excel should now stop responding because of the amount of data to process.
4) Workbench should show this error.

Thank you for the bug report. I can't repeat on Windows 7 which version are you using? Please elaborate your step item 2) . Thanks.

I'm using Windows 8 Pro x64. The data I'm copying in Excel is about 130k cells + conditional formatting on each cell. That might fill up the clipboard quite bad.

Fixed as of the upcoming MySQL Workbench 6.0.2 public beta release, and here's the changelog entry:

Under certain circumstances, cutting and pasting a large amount of data
from an external application (such as Excel) could cause MySQL Workbench to
throw an exception.

Thank you for the bug report.