Hi everyone! I’m trying to upgrade the Octopus Server Version to latest but I have a problem.
My database is SQL Server and this is I can see in the logs:
2018-05-21 15:17:46.7778 7 ERROR Upgrade failed due to an unexpected exception:
System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint ‘PK_MachinePolicy_Id’. Cannot insert duplicate key in object ‘dbo.MachinePolicy’. The duplicate key value is (MachinePolicies-1).
The statement has been terminated.
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, TaskCompletionSource
1 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.UpgradeScripts.Script0045AddDefaultMachinePolicyToExistingTentacles.ProvideScript(Func
1 commandFactory) in Y:\Work\refs\tags\3.4.0\source\Octopus.Core\UpgradeScripts\Script0045AddDefaultMachinePolicyToExistingTentacles.cs:line 54
at DbUp.Engine.LazySqlScript.get_Contents()
at DbUp.Support.SqlServer.SqlScriptExecutor.Execute(SqlScript script, IDictionary2 variables) at DbUp.Engine.UpgradeEngine.PerformUpgrade() ClientConnectionId:32bc8b3f-876e-437e-b378-d486931c91a4 Error Number:2627,State:1,Class:14 2018-05-21 15:17:46.8158 7 FATAL Database upgrade failed: Violation of PRIMARY KEY constraint 'PK_MachinePolicy_Id'. Cannot insert duplicate key in object 'dbo.MachinePolicy'. The duplicate key value is (MachinePolicies-1). The statement has been terminated. Database upgrade logs: Beginning database upgrade Fetching list of already executed scripts. Executing SQL Server script 'Octopus.Core.UpgradeScripts.Script0045AddDefaultMachinePolicyToExistingTentacles.cs' Upgrade failed due to an unexpected exception: System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_MachinePolicy_Id'. Cannot insert duplicate key in object 'dbo.MachinePolicy'. The duplicate key value is (MachinePolicies-1). The statement has been terminated. 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.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(TaskCompletionSource
1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Octopus.Core.UpgradeScripts.Script0045AddDefaultMachinePolicyToExistingTentacles.ProvideScript(Func1 commandFactory) in Y:\Work\refs\tags\3.4.0\source\Octopus.Core\UpgradeScripts\Script0045AddDefaultMachinePolicyToExistingTentacles.cs:line 54 at DbUp.Engine.LazySqlScript.get_Contents() at DbUp.Support.SqlServer.SqlScriptExecutor.Execute(SqlScript script, IDictionary
2 variables)
at DbUp.Engine.UpgradeEngine.PerformUpgrade()
ClientConnectionId:32bc8b3f-876e-437e-b378-d486931c91a4
Error Number:2627,State:1,Class:14
System.Exception: Database upgrade failed: Violation of PRIMARY KEY constraint ‘PK_MachinePolicy_Id’. Cannot insert duplicate key in object ‘dbo.MachinePolicy’. The duplicate key value is (MachinePolicies-1).
The statement has been terminated.
Database upgrade logs:
Beginning database upgrade
Fetching list of already executed scripts.
Executing SQL Server script ‘Octopus.Core.UpgradeScripts.Script0045AddDefaultMachinePolicyToExistingTentacles.cs’
Upgrade failed due to an unexpected exception:
System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint ‘PK_MachinePolicy_Id’. Cannot insert duplicate key in object ‘dbo.MachinePolicy’. The duplicate key value is (MachinePolicies-1).
The statement has been terminated.
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, TaskCompletionSource
1 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.UpgradeScripts.Script0045AddDefaultMachinePolicyToExistingTentacles.ProvideScript(Func
1 commandFactory) in Y:\Work\refs\tags\3.4.0\source\Octopus.Core\UpgradeScripts\Script0045AddDefaultMachinePolicyToExistingTentacles.cs:line 54
at DbUp.Engine.LazySqlScript.get_Contents()
at DbUp.Support.SqlServer.SqlScriptExecutor.Execute(SqlScript script, IDictionary2 variables) at DbUp.Engine.UpgradeEngine.PerformUpgrade() ClientConnectionId:32bc8b3f-876e-437e-b378-d486931c91a4 Error Number:2627,State:1,Class:14 ---> System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_MachinePolicy_Id'. Cannot insert duplicate key in object 'dbo.MachinePolicy'. The duplicate key value is (MachinePolicies-1). The statement has been terminated. 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.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(TaskCompletionSource
1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Octopus.Core.UpgradeScripts.Script0045AddDefaultMachinePolicyToExistingTentacles.ProvideScript(Func1 commandFactory) in Y:\Work\refs\tags\3.4.0\source\Octopus.Core\UpgradeScripts\Script0045AddDefaultMachinePolicyToExistingTentacles.cs:line 54 at DbUp.Engine.LazySqlScript.get_Contents() at DbUp.Support.SqlServer.SqlScriptExecutor.Execute(SqlScript script, IDictionary
2 variables)
at DbUp.Engine.UpgradeEngine.PerformUpgrade()
— End of inner exception stack trace —
at Octopus.Core.Initialization.DatabaseUpgrader.RunScripts(IRelationalStore store, IScriptProvider scriptProvider, Boolean runEveryTime) in Y:\Work\refs\tags\3.4.0\source\Octopus.Core\Initialization\DatabaseUpgrader.cs:line 55
at Octopus.Core.Initialization.DatabaseUpgrader.Upgrade(IRelationalStore store) in Y:\Work\refs\tags\3.4.0\source\Octopus.Core\Initialization\DatabaseUpgrader.cs:line 27
at Octopus.Core.Initialization.StoreInitializer.Initialize() in Y:\Work\refs\tags\3.4.0\source\Octopus.Core\Initialization\StoreInitializer.cs:line 22
at Octopus.Server.OctopusServerEngine.Start() in Y:\Work\refs\tags\3.4.0\source\Octopus.Server\OctopusServerEngine.cs:line 59
at Octopus.Server.Commands.RunCommand.Start() in Y:\Work\refs\tags\3.4.0\source\Octopus.Server\Commands\RunCommand.cs:line 39
at Octopus.Shared.Startup.AbstractCommand.Octopus.Shared.Startup.ICommand.Start(String[] commandLineArguments, ICommandRuntime commandRuntime, OptionSet commonOptions) in Y:\Work\refs\tags\3.4.0\source\Octopus.Shared\Startup\AbstractCommand.cs:line 57
at Octopus.Shared.Startup.OctopusProgram.Start(ICommandRuntime commandRuntime) in Y:\Work\refs\tags\3.4.0\source\Octopus.Shared\Startup\OctopusProgram.cs:line 221
at Octopus.Shared.Startup.WindowsServiceHost.<>c__DisplayClass1_0.b__0() in Y:\Work\refs\tags\3.4.0\source\Octopus.Shared\Startup\WindowsServiceHost.cs:line 19
at Octopus.Shared.Startup.WindowsServiceAdapter.RunService() in Y:\Work\refs\tags\3.4.0\source\Octopus.Shared\Startup\WindowsServiceAdapter.cs:line 48
2018-05-21 15:17:46.8718 7 FATAL Unhandled AppDomain exception occurred: Database upgrade failed: Violation of PRIMARY KEY constraint ‘PK_MachinePolicy_Id’. Cannot insert duplicate key in object ‘dbo.MachinePolicy’. The duplicate key value is (MachinePolicies-1).
The statement has been terminated.
Database upgrade logs:
Beginning database upgrade
Fetching list of already executed scripts.
Executing SQL Server script ‘Octopus.Core.UpgradeScripts.Script0045AddDefaultMachinePolicyToExistingTentacles.cs’
Upgrade failed due to an unexpected exception:
System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint ‘PK_MachinePolicy_Id’. Cannot insert duplicate key in object ‘dbo.MachinePolicy’. The duplicate key value is (MachinePolicies-1).
The statement has been terminated.
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, TaskCompletionSource
1 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.UpgradeScripts.Script0045AddDefaultMachinePolicyToExistingTentacles.ProvideScript(Func
1 commandFactory) in Y:\Work\refs\tags\3.4.0\source\Octopus.Core\UpgradeScripts\Script0045AddDefaultMachinePolicyToExistingTentacles.cs:line 54
at DbUp.Engine.LazySqlScript.get_Contents()
at DbUp.Support.SqlServer.SqlScriptExecutor.Execute(SqlScript script, IDictionary`2 variables)
at DbUp.Engine.UpgradeEngine.PerformUpgrade()
ClientConnectionId:32bc8b3f-876e-437e-b378-d486931c91a4
Error Number:2627,State:1,Class:14
System.Exception: Database upgrade failed: Violation of PRIMARY KEY constraint ‘PK_MachinePolicy_Id’. Cannot insert duplicate key in object ‘dbo.MachinePolicy’. The duplicate key value is (MachinePolicies-1).
The statement has been terminated.
Database upgrade logs:
Beginning database upgrade
Fetching list of already executed scripts.
Executing SQL Server script ‘Octopus.Core.UpgradeScripts.Script0045AddDefaultMachinePolicyToExistingTentacles.cs’
Upgrade failed due to an unexpected exception:
System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint ‘PK_MachinePolicy_Id’. Cannot insert duplicate key in object ‘dbo.MachinePolicy’. The duplicate key value is (MachinePolicies-1).
The statement has been terminated.
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, TaskCompletionSource
1 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.UpgradeScripts.Script0045AddDefaultMachinePolicyToExistingTentacles.ProvideScript(Func
1 commandFactory) in Y:\Work\refs\tags\3.4.0\source\Octopus.Core\UpgradeScripts\Script0045AddDefaultMachinePolicyToExistingTentacles.cs:line 54
at DbUp.Engine.LazySqlScript.get_Contents()
at DbUp.Support.SqlServer.SqlScriptExecutor.Execute(SqlScript script, IDictionary2 variables) at DbUp.Engine.UpgradeEngine.PerformUpgrade() ClientConnectionId:32bc8b3f-876e-437e-b378-d486931c91a4 Error Number:2627,State:1,Class:14 ---> System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_MachinePolicy_Id'. Cannot insert duplicate key in object 'dbo.MachinePolicy'. The duplicate key value is (MachinePolicies-1). The statement has been terminated. 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.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(TaskCompletionSource
1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Octopus.Core.UpgradeScripts.Script0045AddDefaultMachinePolicyToExistingTentacles.ProvideScript(Func1 commandFactory) in Y:\Work\refs\tags\3.4.0\source\Octopus.Core\UpgradeScripts\Script0045AddDefaultMachinePolicyToExistingTentacles.cs:line 54 at DbUp.Engine.LazySqlScript.get_Contents() at DbUp.Support.SqlServer.SqlScriptExecutor.Execute(SqlScript script, IDictionary
2 variables)
at DbUp.Engine.UpgradeEngine.PerformUpgrade()
— End of inner exception stack trace —
at Octopus.Core.Initialization.DatabaseUpgrader.RunScripts(IRelationalStore store, IScriptProvider scriptProvider, Boolean runEveryTime) in Y:\Work\refs\tags\3.4.0\source\Octopus.Core\Initialization\DatabaseUpgrader.cs:line 55
at Octopus.Core.Initialization.DatabaseUpgrader.Upgrade(IRelationalStore store) in Y:\Work\refs\tags\3.4.0\source\Octopus.Core\Initialization\DatabaseUpgrader.cs:line 27
at Octopus.Core.Initialization.StoreInitializer.Initialize() in Y:\Work\refs\tags\3.4.0\source\Octopus.Core\Initialization\StoreInitializer.cs:line 22
at Octopus.Server.OctopusServerEngine.Start() in Y:\Work\refs\tags\3.4.0\source\Octopus.Server\OctopusServerEngine.cs:line 59
at Octopus.Server.Commands.RunCommand.Start() in Y:\Work\refs\tags\3.4.0\source\Octopus.Server\Commands\RunCommand.cs:line 39
at Octopus.Shared.Startup.AbstractCommand.Octopus.Shared.Startup.ICommand.Start(String[] commandLineArguments, ICommandRuntime commandRuntime, OptionSet commonOptions) in Y:\Work\refs\tags\3.4.0\source\Octopus.Shared\Startup\AbstractCommand.cs:line 57
at Octopus.Shared.Startup.OctopusProgram.Start(ICommandRuntime commandRuntime) in Y:\Work\refs\tags\3.4.0\source\Octopus.Shared\Startup\OctopusProgram.cs:line 221
at Octopus.Shared.Startup.WindowsServiceHost.<>c__DisplayClass1_0.b__0() in Y:\Work\refs\tags\3.4.0\source\Octopus.Shared\Startup\WindowsServiceHost.cs:line 19
at Octopus.Shared.Startup.WindowsServiceAdapter.RunService() in Y:\Work\refs\tags\3.4.0\source\Octopus.Shared\Startup\WindowsServiceAdapter.cs:line 64
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()
Any Suggestions?
Thanks in advance,
Max