Devart Forums

Hello,

Using version 5.35.54 of dotConnect for Oracle, i randomly get 'System.OutOfMemoryException' errors when executing the same query initiated from the same function. Nevertheless, the rest of the call stack is different in each case but still in the Devart components context. I attach 4 of these stacks for your convenience:

System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
at System.String.CtorCharArray(Char[] value)
at Devart.Common.z.b(Byte[] A_0, Int32 A_1, Int32 A_2, Encoding A_3)
at Devart.Common.z.aa(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Common.z.v(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Data.Oracle.ad.v(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Data.Oracle.OracleDataReader.GetString(Int32 i)
at lambda_method(ExecutionScope , IDataRecord )
at Devart.Data.Linq.Provider.ObjectReader`1.f()
at Devart.Data.Linq.Provider.EntityReader`3.a()
at Devart.Data.Linq.Provider.ObjectReader`1.MoveNext()
at System.Linq.Lookup`2.CreateForJoin(IEnumerable`1 source, Func`2 keySelector, IEqualityComparer`1 comparer)
at System.Linq.Enumerable.d__67`4.MoveNext()
at System.Linq.Enumerable.d__67`4.MoveNext()
at System.Linq.Buffer`1..ctor(IEnumerable`1 source)
at System.Linq.OrderedEnumerable`1.d__0.MoveNext()
at System.Linq.Enumerable.d__d`2.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at CRMClient.AllTasksModel.LoadJobs()
at CRMClient.AllTasksForm.LoadJobs()


System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
at lambda_method(ExecutionScope , IDataRecord )
at Devart.Data.Linq.Provider.ObjectReader`1.f()
at Devart.Data.Linq.Provider.EntityReader`3.a()
at Devart.Data.Linq.Provider.ObjectReader`1.MoveNext()
at System.Linq.Lookup`2.CreateForJoin(IEnumerable`1 source, Func`2 keySelector, IEqualityComparer`1 comparer)
at System.Linq.Enumerable.d__67`4.MoveNext()
at System.Linq.Enumerable.d__67`4.MoveNext()
at System.Linq.Buffer`1..ctor(IEnumerable`1 source)
at System.Linq.OrderedEnumerable`1.d__0.MoveNext()
at System.Linq.Enumerable.d__d`2.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at CRMClient.AllTasksModel.LoadJobs()
at CRMClient.AllTasksForm.LoadJobs()


System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
at System.Text.Encoding.GetChars(Byte[] bytes, Int32 index, Int32 count)
at Devart.Common.z.ac(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Data.Oracle.ad.v(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Data.Oracle.OracleDataReader.GetString(Int32 i)
at lambda_method(ExecutionScope , IDataRecord )
at Devart.Data.Linq.Provider.ObjectReader`1.f()
at Devart.Data.Linq.Provider.EntityReader`3.a()
at Devart.Data.Linq.Provider.ObjectReader`1.MoveNext()
at System.Linq.Lookup`2.CreateForJoin(IEnumerable`1 source, Func`2 keySelector, IEqualityComparer`1 comparer)
at System.Linq.Enumerable.d__67`4.MoveNext()
at System.Linq.Enumerable.d__67`4.MoveNext()
at System.Linq.Buffer`1..ctor(IEnumerable`1 source)
at System.Linq.OrderedEnumerable`1.d__0.MoveNext()
at System.Linq.Enumerable.d__d`2.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at CRMClient.AllTasksModel.LoadJobs()
at CRMClient.AllTasksForm.LoadJobs()


System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
at lambda_method(ExecutionScope , IDataRecord )
at Devart.Data.Linq.Provider.ObjectReader`1.f()
at Devart.Data.Linq.Provider.EntityReader`3.a()
at Devart.Data.Linq.Provider.ObjectReader`1.MoveNext()
at System.Linq.Lookup`2.CreateForJoin(IEnumerable`1 source, Func`2 keySelector, IEqualityComparer`1 comparer)
at System.Linq.Enumerable.d__61`4.MoveNext()
at System.Linq.Enumerable.d__61`4.MoveNext()
at System.Linq.Buffer`1..ctor(IEnumerable`1 source)
at System.Linq.OrderedEnumerable`1.d__0.MoveNext()
at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at CRMClient.AllTasksModel.LoadJobs()
at CRMClient.AllTasksForm.LoadJobs()

I know that you'll probably tell me to test using the latest stable version, but the relevant version of our software is currently unsupported and we would prefer to be perfectly sure that an update will solve the issue before proceeding with it.

Hello,

After more investigation, we came to the conclusion that memory is normally exhausted due to a bad query.

Sorry for the inconvenience.

Glad to hear that the issue is resolved.