We are running Octopus Deploy Server 3.2.10.
We are currently unable to deploy due to this error. I have attempted to restart the octopus service and it will not start, showing this in the event log:
2015-12-22 13:35:54.0148 14 FATAL Unhandled AppDomain exception occurred: Error while executing SQL command: The transaction log for database ‘octopus’ is full due to ‘LOG_BACKUP’.
The command being executed was:
UPDATE dbo.[ServerTask] SET [Name] = @Name, [Description] = @Description, [QueueTime] = @QueueTime, [StartTime] = @StartTime, [CompletedTime] = @CompletedTime, [ErrorMessage] = @ErrorMessage, [ConcurrencyTag] = @ConcurrencyTag, [State] = @State, [HasPendingInterruptions] = @HasPendingInterruptions, [HasWarningsOrErrors] = @HasWarningsOrErrors, [ServerNode] = @ServerNode, [ProjectId] = @ProjectId, [EnvironmentId] = @EnvironmentId, Json = @Json WHERE Id = @Id
System.Exception: Error while executing SQL command: The transaction log for database ‘octopus’ is full due to ‘LOG_BACKUP’.
The command being executed was:
UPDATE dbo.[ServerTask] SET [Name] = @Name, [Description] = @Description, [QueueTime] = @QueueTime, [StartTime] = @StartTime, [CompletedTime] = @CompletedTime, [ErrorMessage] = @ErrorMessage, [ConcurrencyTag] = @ConcurrencyTag, [State] = @State, [HasPendingInterruptions] = @HasPendingInterruptions, [HasWarningsOrErrors] = @HasWarningsOrErrors, [ServerNode] = @ServerNode, [ProjectId] = @ProjectId, [EnvironmentId] = @EnvironmentId, Json = @Json WHERE Id = @Id —> System.Data.SqlClient.SqlException: The transaction log for database ‘octopus’ is full due to ‘LOG_BACKUP’.
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.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) 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.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Octopus.Core.RelationalStorage.TransientFaultHandling.IDbCommandExtensions.<>c__DisplayClass2_0.<ExecuteNonQueryWithRetry>b__0() in Y:\work\refs\tags\3.2.10\source\Octopus.Core\RelationalStorage\TransientFaultHandling\IDbCommandExtensions.cs:line 30 at Octopus.Shared.TransientFaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 func) in Y:\work\refs\tags\3.2.10\source\Octopus.Shared\TransientFaultHandling\RetryPolicy.cs:line 215
at Octopus.Core.RelationalStorage.RelationalTransaction.Update[TDocument](TDocument instance) in Y:\work\refs\tags\3.2.10\source\Octopus.Core\RelationalStorage\RelationalTransaction.cs:line 174
— End of inner exception stack trace —
at Octopus.Core.RelationalStorage.RelationalTransaction.Update[TDocument](TDocument instance) in Y:\work\refs\tags\3.2.10\source\Octopus.Core\RelationalStorage\RelationalTransaction.cs:line 181
at Octopus.Server.Orchestration.TaskQueue.CancelOldTasks(String serverNodeName) in Y:\work\refs\tags\3.2.10\source\Octopus.Server\Orchestration\TaskQueue.cs:line 98
at Octopus.Server.Orchestration.TaskQueue.PollForMoreWorkOnBackgroundThread(Object state) in Y:\work\refs\tags\3.2.10\source\Octopus.Server\Orchestration\TaskQueue.cs:line 51
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart(Object obj)
It looks like the internal database got stuck in backup somehow. Can anyone please assist me in fixing the problem?