Hi Team,
My name is Ankit, I am reaching out to you to resolve an issue we are seeing on our self-hosted octopus instance.
Since last couple of days, we have observed that auto-deployment is not happening and this issue has been observed in all life-cycles where auto deployment is configured.
Things were working fine up to 5th July and also we have not made any changes in Lifecyle hooks since then.
Phase 1 is optional and phase 2 should pass if deployed in any of environment from given multiple environments then phase 3 should trigger auto-deployment which is not happening.
I am getting below error -
2019-07-15 00:14:58.7609 5480 12 ERROR Error when running scheduled task: Octopus.Server.Schedules.RunOnAScheduleAdapter
1[Octopus.Server.Schedules.ProcessAutoDeployments]
System.Exception: Exception occurred while executing a reader for EventSourceDeployments
—> System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. —> System.ComponentModel.Win32Exception: The wait operation timed out
— End of inner exception stack trace —
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) 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, TaskCompletionSource
1 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 Nevermore.Transient.IDbCommandExtensions.<>c__DisplayClass5_0.b__0()
at Nevermore.Transient.RetryPolicy.ExecuteAction[TResult](Func1 func) at Nevermore.Transient.IDbCommandExtensions.ExecuteReaderWithRetry(IDbCommand command, RetryPolicy commandRetryPolicy, RetryPolicy connectionRetryPolicy, String operationName) --- End of inner exception stack trace --- at Nevermore.Transient.IDbCommandExtensions.ExecuteReaderWithRetry(IDbCommand command, RetryPolicy commandRetryPolicy, RetryPolicy connectionRetryPolicy, String operationName) at Nevermore.Transient.IDbCommandExtensions.ExecuteReaderWithRetry(IDbCommand command, String operationName) at Nevermore.RelationalTransaction.<Stream>d__46
1.MoveNext()
at System.Collections.Generic.List1..ctor(IEnumerable
1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable1 source) at Octopus.Server.Schedules.AutoDeployments.AutoDeployMachineFinder.GetDeploymentsThatHaveCompleted(IQueryExecutor queryExecutor, Int64 fromAutoId, Int64 toAutoId) at Octopus.Server.Schedules.AutoDeployments.AutoDeployMachineFinder.GetDeploymentTargetsThatTriggeredWhileDeploymentsInProgress(IQueryExecutor queryExecutor, Int64 fromAutoId, Int64 toAutoId) at Octopus.Server.Schedules.AutoDeployments.AutoDeployTriggerProcessor.ProcessEvents(Nullable
1 lastPassEventAutoId, Int64 upToEventAutoId)
at Octopus.Server.Schedules.ProcessAutoDeployments.Trigger()
at Octopus.Server.Schedules.Scheduler.RunTask(IRunOnASchedule schedule)`