Invalid attempt to call Read when reader is closed

Vladislavs

Vote:

Hi,
After upgrade from CMS 11.20.16 to CMS 12.30.0 we ran into a problem, that for some reason, time to time, getting connection exceptions on using IContentLoader
GetChildren (IEnumerable<T> GetChildren<T>(ContentReference contentLink)) and
GetBySegment (IContent GetBySegment(ContentReference parentLink, string urlSegment, CultureInfo language))

ExecuteReader requires an open and available Connection. The connection's current state is open.
Invalid attempt to call Read when reader is closed.
ExecuteReader requires an open and available Connection. The connection's current state is closed.

Exceptions:

System.InvalidOperationException: ExecuteReader requires an open and available Connection. The connection's current state is open.

at Microsoft.Data.SqlClient.SqlConnection.GetOpenTdsConnection(String method)

at Microsoft.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, SqlCommand command)

at Microsoft.Data.SqlClient.SqlCommand.ValidateCommand(Boolean isAsync, String method)

at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry, String method)

at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

at Microsoft.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)

at Microsoft.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)

at EPiServer.DataAccess.Internal.ContentListDB.<>c__DisplayClass11_0.<ListMatchingSegments>b__0()

at EPiServer.Data.Providers.Internal.SqlDatabaseExecutor.<>c__DisplayClass26_0`1.<Execute>b__0()

at EPiServer.Data.Providers.SqlTransientErrorsRetryPolicy.Execute[TResult](Func`1 method)

at EPiServer.Data.Providers.Internal.SqlDatabaseExecutor.Execute[TResult](Func`1 action)

at EPiServer.DataAccess.Internal.ContentListDB.ListMatchingSegments(ContentReference parentLink, String urlSegment)

at EPiServer.Core.Internal.DefaultContentProviderDatabase.ListMatchingSegments(ContentReference parentLink, String urlSegment)

at EPiServer.Core.Internal.DefaultContentProvider.ListMatchingSegments(ContentReference parentLink, String urlSegment)

at EPiServer.Core.ContentProvider.<>c__DisplayClass79_0.<GetMatchingSegments>b__0()

at EPiServer.Framework.Cache.ObjectInstanceCacheExtensions.ReadThroughWithWait[T](IObjectInstanceCache cache, String cacheKey, Func`1 readValue, Func`2 evictionPolicy)

Failed to Read cacheKey = 'EPPageData:2870:en'

System.InvalidOperationException: Invalid attempt to call Read when reader is closed.

at Microsoft.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)

at Microsoft.Data.SqlClient.SqlDataReader.Read()

at EPiServer.DataAccess.Internal.ContentLoadDB.LoadContentInternal(ContentReference contentLink, Int32 languageBranchId, DbDataReader reader)

at EPiServer.DataAccess.Internal.ContentLoadDB.<>c__DisplayClass2_0.<Load>b__0()

at EPiServer.Data.Providers.Internal.SqlDatabaseExecutor.<>c__DisplayClass26_0`1.<Execute>b__0()

at EPiServer.Data.Providers.SqlTransientErrorsRetryPolicy.Execute[TResult](Func`1 method)

at EPiServer.Data.Providers.Internal.SqlDatabaseExecutor.Execute[TResult](Func`1 action)

at EPiServer.DataAccess.Internal.ContentLoadDB.Load(ContentReference contentLink, Int32 languageBranchID)

at EPiServer.Core.Internal.DefaultContentProviderDatabase.Load(ContentReference contentLink, Int32 languageBranchID)

at EPiServer.Core.Internal.DefaultContentProvider.LoadContent(ContentReference contentLink, ILanguageSelector languageSelector)

at EPiServer.Core.ContentProvider.<>c__DisplayClass123_0.<LoadContentFromCacheOrRepository>b__0()

at EPiServer.Framework.Cache.ObjectInstanceCacheExtensions.ReadThroughWithWait[T](IObjectInstanceCache cache, String cacheKey, Func`1 readValue, Func`2 evictionPolicy)

System.InvalidOperationException: ExecuteReader requires an open and available Connection. The connection's current state is closed.