We are not able to open a particular octopus release . It fails with the below error. However, we can navigate to the deployments of this release on a tenant directly from the overview page.
The other releases for SVR and the other projects works fine. We have not seen similar issues in other releases so far.
“variableset-Projects-55-s-139-ZRTG8 ” is the project variable snapshot id for the release 4.9.330.1.
Thank you for contacting Octopus support. We are sorry you are experiencing this issue.
Was this project cloned, by any chance? We suspect it might be an issue with the duplicate varset ids in the database.
Also, can you try to run a “System Integrity Check” in the Configuration/Diagnostics:
It is possible to create another release(4.9.330.2 ) with the same package. But it is not very straightforward. Because now the release (4.9.330.1) has been reached the last environment in the life cycle. As per the process, we need to deploy the new release (4.9.330.2 ) in all other environments in the life cycle before we deploy the new release (4.9.330.2) in the last environment.
We cannot update the variable snapshot through UI because we are not able to open the release.
I see only one row for the below query on Octopus database. select * from dbo.Release r where r.ProjectVariableSetSnapshotId = ‘variableset-Projects-55-s-139-ZRTG8’
So I assume there are no duplicate varset ids.
Moreover, we are trying to find the root cause of this issue to avoid this issue in the future.
We tried this script using 2 accounts (one was a space manager and the other one was an Octopus administrator).
Unfortunately it failed with below error.
Invoke-RestMethod : The remote server returned an error: (405) Method Not Allowed. At line:23 char:1 + Invoke-RestMethod -Method Post -Uri "$octopusURL/api/$($space.Id)/rel …
*+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~*
This above error was due to the api paging and the api was not pulling all the releases.
I tried updating the script and I get the below error. Invoke-RestMethod : The remote server returned an error: (500) Internal Server Error.
I tried with some other release which does not show any issue in the UI and it is working fine. But the POST call fails with an error for the release “4.9.330.1” .
At this point, the easiest option we have is to ask you for the Octopus DB backup. We understand if that option is not acceptable for you due to privacy/security reasons.
But if that is acceptable, Here is the link for the secure upload.
Please do not send us a Master Key. We will scrub all the sensitive data from the DB before trying to reproduce the issue.