Hello,
I create a backup of Octopus prior to upgrading, but it’s been taking longer and longer to complete. Even though we’ve drastically reduced our retention policies in an effort to keep Octo lean and cut the time for the backups, they are taking longer and longer each time. I’ve included the final results logged below. Please let me know what additional information I can provide.
Is something wrong? Could it be database slowness? How can I further troubleshoot?
Thank you!
2020-10-26 23:09:57.8306 4384 1 INFO Results of export
2020-10-26 23:09:57.8306 4384 1 INFO Created…856237
Account…5
ActionTemplate…51
ActionTemplateVersion…298
ApiKey…38
AzureADConfiguration…1
AzureDevOpsConfiguration…1
Certificate…9
CertificateConfiguration…1
Channel…1000
CommunityActionStepTemplate…434
Deployment…30330
DeploymentProcess…41432
DeploymentSnapshot…30330
Project…236
ReleaseSnapshot…10866
DeploymentRelatedMachine…72382
DirectoryServicesConfiguration…1
Environment…13
Event…592333
FeaturesConfiguration…1
Feed…3
GitHubConfiguration…1
GoogleAppsConfiguration…1
GuestConfiguration…1
JiraConfiguration…1
LibraryVariableSet…65
License…1
Lifecycle…11
Machine…663
MachinePolicy…6
OctopusIDConfiguration…1
OktaConfiguration…1
Project…236
ProjectGroup…6
Release…10866
RunbookProcess…271
Runbook…26
RunbookRun…141
RunbookSnapshot…104
RunbookRun…141
Runbooks…26
Project…26
RunbookSnapshot…104
ScopedUserRole…33
Script…1662
ServerConfiguration…1
ServerTask…51167
SmtpConfiguration…1
Space…1
Subscriptions…3
Team…15
User…123
UsernamePasswordConfiguration…1
UserRole…25
VariableSet…52461
DeploymentSnapshot…1937
Library…65
LibraryReleaseSnapshot…38528
Project…236
ProjectReleaseSnapshot…10866
RunbookRun…141
RunbookSnapshot…102
RunbookSnapshotFromLibrary…586
WebPortalConfiguration…1
Worker…6
WorkerPool…2
Error…649
Could not write VariableSetSnapshot for Release649
Skipped (null)…2
VariableSet…2
RunbookSnapshot…2
Unchanged…266741
VariableSet…266741
LibraryReleaseSnapshot…265150
RunbookSnapshotFromLibrary…1591
Updated…12
VariableSet…12
LibraryReleaseSnapshot…12