timeout in console mode?

Topics: Administration, General
May 26 at 7:12 PM
Edited May 26 at 7:13 PM
Hello guys!

We created a class that inherit from DefaultOrchardCommandHandler to add new command line. Our process take 8 to 12 minutes depending of the environment. We are suspecting that we hit a timeout at 10 minutes because:

1) if we split the job in 3 parts, everything runs fine
2) when we check the log, the last operation before the error is around 9 minutes 40 seconds

Is there a way to change a setting to increase the timeout from 10 minutes to 15 minutes for orchard.exe? We are using orchard 1.5.1 .

Thank you,
Have a great day!
Sebastien

Error

The transaction associated with the current connection has completed but has not been disposed. The transaction must be disposed before the connection can be used to execute SQL statements.

Exception Details: System.InvalidOperationException: The transaction associated with the current connection has completed but has not been disposed. The transaction must be disposed before the connection can be used to execute SQL statements.

Stack Trace

[InvalidOperationException: The transaction associated with the current connection has completed but has not been disposed. The transaction must be disposed before the connection can be used to execute SQL statements.]
at System.Data.SqlClient.SqlInternalConnectionTds.CheckEnlistedTransactionBinding()
at System.Data.SqlClient.TdsParser.TdsExecuteSQLBatch(String text, Int32 timeout, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj, Boolean sync, Boolean callerHasConnectionLock)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd)
at NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, ISessionImplementor session)
at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)

[ADOException: could not execute query]
at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters)
at NHibernate.Hql.Ast.ANTLR.Loader.QueryLoader.List(ISessionImplementor session, QueryParameters queryParameters)
at NHibernate.Hql.Ast.ANTLR.QueryTranslatorImpl.List(ISessionImplementor session, QueryParameters queryParameters)
at NHibernate.Engine.Query.HQLQueryPlan.PerformList(QueryParameters queryParameters, ISessionImplementor session, IList results)
at NHibernate.Impl.SessionImpl.List(String query, QueryParameters queryParameters, IList results)
at NHibernate.Impl.SessionImpl.List[T](String query, QueryParameters parameters)
at NHibernate.Impl.QueryImpl.List[T]()
at Orchard.ContentManagement.DefaultHqlQuery.Slice(Int32 skip, Int32 count) in c:\dev\source\Edilexpert\Dev\src\Orchard\ContentManagement\DefaultHqlQuery.cs:line 170
at Orchard.ContentManagement.DefaultHqlQuery.List() in c:\dev\source\Edilexpert\Dev\src\Orchard\ContentManagement\DefaultHqlQuery.cs:line 155
at Edilex.Clauses.Services.SubClauseService.GetAllSubClauses(Int32 versionId)
at Edilex.Clauses.Services.ClauseSearchService.GenerateIndexes(IEnumerable
1 allVersions)
at Edilex.RFPs.Commands.Indexers.ClauseIndexer.GenerateIndex(IEnumerable1 contentItems)
at Edilex.RFPs.Commands.EdilexIndexingCommands.IndexItems(Indexer indexer, List
1 contentItems, Int32 take, Boolean verbose)
at Edilex.RFPs.Commands.EdilexIndexingCommands.ExecuteIndexer(Indexer indexer, Int32 take, Boolean verbose)
at Edilex.RFPs.Commands.EdilexIndexingCommands.EdilexIndexAll()
May 26 at 7:37 PM
I just discovered orchardpros.net where the UI is neat and there seem more active. So I opened a ticket there and I link both.

http://orchardpros.net/tickets/10640

Thank you!