Bug #67148 Reporte haciendo una migracion desde access
Submitted: 9 Oct 2012 16:15 Modified: 11 Nov 2012 0:14
Reporter: Janner Mauricio Giraldo Daza Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.2.44 OS:Windows (Microsoft Windows 7 Service Pack 1 (build 7601), 32-bit)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[9 Oct 2012 16:15] Janner Mauricio Giraldo Daza
Description:
Reporte haciendo una migracion desde access

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

MySQL Workbench CE for Windows version 5.2.44  revision 9933
Configuration Directory: C:\Users\Soporte\AppData\Roaming\MySQL\Workbench
Data Directory: C:\Program Files\MySQL\MySQL Workbench CE 5.2.44
Cairo Version: 1.8.8
OS: Microsoft Windows 7  Service Pack 1 (build 7601), 32-bit
CPU: 4x Intel(R) Core(TM) i3 CPU         550  @ 3.20GHz, 1.9 GiB RAM
Active video adapter (0): Intel(R) HD Graphics
Installed video RAM: 731 MB
Current video mode: 1440 x 900 x 4294967296 colores
Used bit depth: 32
Driver version: 8.15.10.2622
Installed display drivers: igdumdx32.dll,igd10umd32.dll
Current user language: Español (Colombia)

Exception = System.OutOfMemoryException
Message = Exception of type 'System.OutOfMemoryException' was thrown.
FullText = System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
   at System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object[] args, Boolean synchronous)
   at System.Windows.Forms.Control.Invoke(Delegate method, Object[] args)
   at System.Windows.Forms.Control.Invoke(Delegate method)
   at MySQL.GUI.Workbench.SqlIdeForm.RecordsetListChanged(Int32 editor_index, Int64 key, Boolean added)
   at MySQL.Grt.RunWrappedDelegate3<void\,void\,int\,int\,boost::shared_ptr<Recordset>\,__int64\,bool\,bool\,MySQL::Grt::DelegateSlot3<void\,void\,int\,int\,boost::shared_ptr<Recordset>\,__int64\,bool\,bool>::ManagedDelegate>.native_callback(Int32* a1, shared_ptr<Recordset>* a2, Boolean* a3)
   at boost.detail.function.void_function_invoker3<void (__cdecl*)(int const &,boost::shared_ptr<Recordset> const &,bool const &),void,int const &,boost::shared_ptr<Recordset> const &,bool const &>.invoke(function_buffer* function_ptr, Int32* a0, shared_ptr<Recordset>* a1, Boolean* a2)
   at boost.function3<void,int const &,boost::shared_ptr<Recordset> const &,bool const &>.()(function3<void\,int const \&\,boost::shared_ptr<Recordset> const \&\,bool const \&>* , Int32* a0, shared_ptr<Recordset>* a1, Boolean* a2)
   at boost.detail.function.void_function_obj_invoker3<boost::function<void __cdecl(int const &,boost::shared_ptr<Recordset> const &,bool const &)>,void,int,boost::shared_ptr<Recordset>,bool>.invoke(function_buffer* function_obj_ptr, Int32 a0, shared_ptr<Recordset>* a1, Boolean a2)

How to repeat:
Reporte haciendo una migracion desde access
[9 Oct 2012 18:30] MySQL Verification Team
Thank you for the bug report. Please elaborate the description of Access (version), size and kind of tables and destination MySQL server. Thanks.
[10 Oct 2012 13:27] Janner Mauricio Giraldo Daza
Buen Dia

La version de access que estoy trabajando es con oficce 2010, el tamaño de la base de datos total es de 1.2Gb y estoy usando como destino mysql workbench 5.3 CE, la base de datos en access contiene 4 tablas, pero solo importe a mysql la tabla mas grande que contiene 22077532 registros en ella, en el momento de hacer la consulta del total de los registros en ella me genra ese error, el query que estoy utilizando para dicha consulta es :
SELECT * FROM MIGRACION.CENSO LIMIT 0,23000000

Muchas gracias por la atención prestada.
[11 Oct 2012 0:14] MySQL Verification Team
Thank you for the feedback. Lo que yo entiendo de tu problema no es la migración sino cuando ejecutas: SELECT * FROM MIGRACION.CENSO LIMIT 0,23000000 ?. Cual server tu estás usando 5.5.27?. Thanks.
[11 Nov 2012 1:00] Bugs System
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".