System.OutOfMemoryException

System.OutOfMemoryException

Postby crazypit » Thu 08 Apr 2010 12:18

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.
crazypit
 
Posts: 163
Joined: Wed 15 Apr 2009 08:43

Postby crazypit » Mon 12 Apr 2010 07:26

Hello,

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

Sorry for the inconvenience.
crazypit
 
Posts: 163
Joined: Wed 15 Apr 2009 08:43

Postby AndreyR » Mon 12 Apr 2010 09:17

Glad to hear that the issue is resolved.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16


Return to LinqConnect (LINQ to SQL support)