We have been getting errors with auto-deployments since July 5. We have not made any changes as far as I am aware. The error we see is:
Error when running scheduled task: Octopus.Server.Schedules.RunOnAScheduleAdapter1[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, Action
1 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, 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 Nevermore.Transient.IDbCommandExtensions.<>c__DisplayClass5_0.<ExecuteReaderWithRetry>b__0() at Nevermore.Transient.RetryPolicy.ExecuteAction[TResult](Func
1 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.d__461.MoveNext() at System.Collections.Generic.List
1…ctor(IEnumerable1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable
1 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)