Description:
I am inserting +30,000 rows in a table whith a PHP script and i tried to select the top 1000 rows in the same table with MySql Workbench. MySql Workbench crached when i tried to execute the select request.
----- Developer Notes -----
MySQL Workbench CE for Windows version 5.2.43 revision 9869
Configuration Directory: C:\Users\Alexandre\AppData\Roaming\MySQL\Workbench
Data Directory: C:\Program Files\MySQL\MySQL Workbench 5.2 CE
Cairo Version: 1.8.8
OS: Microsoft Windows 7 Home Premium Edition (build 7600), 32-bit
CPU: 2x Intel(R) Core(TM)2 Duo CPU T7700 @ 2.40GHz, 3.5 GiB RAM
Active video adapter (0): NVIDIA GeForce 8600M GT
Installed video RAM: 256 MB
Current video mode: 1920 x 1080 x 4294967296 couleurs
Used bit depth: 32
Driver version: 8.15.11.8621
Installed display drivers: nvd3dum.dll,nvwgf2um.dll,nvwgf2um.dll
Current user language: Français (France)
Exception = System.InvalidOperationException
Message = Collection was modified; enumeration operation may not execute.
FullText = System.InvalidOperationException: Collection was modified; enumeration operation may not execute.
at System.ThrowHelper.ThrowInvalidOperationException(ExceptionResource resource)
at System.Collections.Generic.List`1.Enumerator.MoveNextRare()
at System.Collections.Generic.List`1.Enumerator.MoveNext()
at MySQL.Controls.FlatTabControl.BusyAnimationStep(Object sender, EventArgs args)
at System.Drawing.ImageAnimator.ImageInfo.OnFrameChanged(EventArgs e)
at System.Drawing.ImageAnimator.ImageInfo.set_Frame(Int32 value)
at System.Drawing.ImageAnimator.AnimateImages50ms()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean ignoreSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()
How to repeat:
insert a lot of rows and select in the same table
