Ticket Hash: | 768ee11d7dcdc95025fb106972410b7acd14101e | |||
Title: | Execution of CREATE INDEX generates System.OutOfMemoryException | |||
Status: | Closed | Type: | Incident | |
Severity: | Important | Priority: | Medium | |
Subsystem: | Integration_Via_PInvoke | Resolution: | Not_A_Bug | |
Last Modified: | 2011-12-12 11:04:04 | |||
Version Found In: | 1.0.77.0 | |||
Description: | ||||
When executing the CREATE INDEX NonQuery in a table with almost 60 million records, system increases the memory and after some seconds the next error issues:
System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown. at System.RuntimeMethodHandle._InvokeConstructor(IRuntimeMethodInfo method, O bject[] args, SignatureStruct& signature, RuntimeType declaringType) at System.RuntimeMethodHandle.InvokeConstructor(IRuntimeMethodInfo method, Ob ject[] args, SignatureStruct signature, RuntimeType declaringType) at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, B inder binder, Object[] parameters, CultureInfo culture) at System.SecurityUtils.ConstructorInfoInvoke(ConstructorInfo ctor, Object[] args) at System.Diagnostics.TraceUtils.GetRuntimeObject(String className, Type base Type, String initializeData) at System.Diagnostics.TypedElement.BaseGetRuntimeObject() at System.Diagnostics.ListenerElement.GetRuntimeObject() at System.Diagnostics.ListenerElementsCollection.GetRuntimeObject() at System.Diagnostics.TraceInternal.get_Listeners() at System.Diagnostics.TraceInternal.WriteLine(String message) at System.Data.SQLite.SQLiteLog.LogEventHandler(Object sender, LogEventArgs e ) at System.Data.SQLite.SQLiteLog.LogCallback(IntPtr pUserData, Int32 errorCode , IntPtr pMessage) at System.Data.SQLite.UnsafeNativeMethods.sqlite3_step(IntPtr stmt) at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt) at System.Data.SQLite.SQLiteDataReader.NextResult() at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavi or behave) at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery() at Facilities.DB.LibSQLite.ExecNonQuery(String qry, Object[] args) at ttbsap.CmpExistenc.SetIndexesTTB() The code is: using (LibSQLite db = new LibSQLite(@"Data Source=inv.db3;")) { using (SQLiteTransaction transac = db.BeginTransaction()) { try { res = db.ExecNonQuery("CREATE INDEX ttb_1 on ttb(sts);"); db.Commit(); } catch (Exception ex) { System.Console.WriteLine("error"); } finally { db.Dispose(); } } } mistachkin added on 2011-12-12 03:01:01 UTC: anonymous added on 2011-12-12 06:25:47 UTC: Some minutes ago, I replaced it by sqlite-netFx40-binary-X64-2010-1.0.77.0 and I compiled with processor "Any CPU". I executed the program and this time, no error was issued. DO you have any explanation about this, before considering the ticked as fixed? My best regards. Vizcayno. mistachkin added on 2011-12-12 07:52:05 UTC: anonymous added on 2011-12-12 11:04:04 UTC: |