I am working on exporting a full Octopus cluster using these instructions: Data migration - Octopus Deploy
I have not been able to do it without the error below. The goal is to move it to a new Octopus cluster within our organization that is full HA. We have 400-500GB of data on the D drive and 40GB for the DB.
Error below:
FROM [dbo].[Event]
ORDER BY [Id]
Error: ===============================================================================
Error: SQL Error -2 - Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Error: Microsoft.Data.SqlClient.SqlException
Error: at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
Error: at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
Error: at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
Error: at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
Error: at Microsoft.Data.SqlClient.SqlDataReader.TryCloseInternal(Boolean closeReader)
Error: at Microsoft.Data.SqlClient.SqlDataReader.Close()
Error: at Microsoft.Data.SqlClient.SqlDataReader.Dispose(Boolean disposing)
Error: at Nevermore.Advanced.ReadTransaction.Stream[TRecord](PreparedCommand command)+System.IDisposable.Dispose()
Error: at Octopus.Migrator.Core.ExportProcess.ExportController.WriteDocuments(String singularNoun, IEnumerable`1 documents, ExportFileNameOption fileNameOption)+<>m__Finally1()
Error: at Octopus.Migrator.Core.ExportProcess.ExportController.WriteDocuments(String singularNoun, IEnumerable`1 documents, ExportFileNameOption fileNameOption)+System.IDisposable.Dispose()
Error: at Octopus.Migrator.Core.ExportProcess.ExportController.WriteDocuments(String singularNoun, IEnumerable`1 documents, ExportFileNameOption fileNameOption)+MoveNext() in ExportController.cs:line 816
Error: at Octopus.Migrator.Core.ExportProcess.ExportController.Write(String singularNoun, IEnumerable`1 documents, ExportFileNameOption fileNameOption) in ExportController.cs:line 577
Error: at Octopus.Migrator.Core.ExportProcess.ExportController.Export() in ExportController.cs:line 107
Error: at Octopus.Migrator.Cli.Commands.ExportCommand.Start() in ExportCommand.cs:line 90
Error: at Octopus.Shared.Startup.AbstractCommand.Start(String[] commandLineArguments, ICommandRuntime commandRuntime, OptionSet commonOptions)
Error: at Octopus.Shared.Startup.OctopusProgram.Start(ICommandRuntime commandRuntime)
Error: at Octopus.Shared.Startup.ConsoleHost.Run(Action`1 start, Action shutdown)
Error: at Octopus.Shared.Startup.OctopusProgram.RunHost(ICommandHost host)
Error: at Octopus.Shared.Startup.OctopusProgram.Run()
Error:
Error: --Inner Exception--
Error: The wait operation timed out.
Error: System.ComponentModel.Win32Exception
Error: -------------------------------------------------------------------------------
Error: Terminating process with exit code 100
Error: Full error details are available in the log files at:
Error: C:\Users\Administrator\AppData\Local\Octopus\Logs
Error: D:\Octopus\Logs
Error: If you need help, please send these log files to https://octopus.com/support
Error: -------------------------------------------------------------------------------
Error:
Error: The previous command returned a non-zero exit code of: 100
Error: The command that failed was: "D:\Program Files\Octopus Deploy\Octopus\Octopus.Migrator.exe" export --instance "OctopusServer" --directory "D:\OctopusExport" --password "theta" --include-tasklogs