Check System Integrity failed


#1

Hello! Our Check System Integrity step failed. What can we do to fix this issue or we can just ignore it?

Here is the log:
Task ID: ServerTasks-639692
Task status: Failed
Task queued: Wednesday, January 9, 2019 9:45 AM
Task started: Wednesday, January 9, 2019 9:45 AM
Task duration: 17 seconds
Server version: 3.17.13+Branch.master.Sha.a73f7668ba7e7ffc058fa6d3171d1f2f916d169e
Server node: OCTOPUS

                | Failed: Check System Integrity

09:45:35 Info | Unexpected related document id format… [ Passed ]
09:45:35 Error | Schema… [ Failed ]
09:45:35 Info | Release channel belongs to the appropriate project… [ Passed ]
09:45:35 Info | Orphaned tenanted deployments… [ Passed ]
09:45:35 Info | Orphaned channels… [ Passed ]
09:45:35 Info | Only one unfrozen deployment process per project… [ Passed ]
09:45:35 Fatal | One or more data errors were found.
|
| Failed: Schema
09:45:35 Error | Unexpected item: IDX dbo.IX_Interruption_TaskId NONCLUSTERED 0
| Unexpected item: IDX dbo.IX_Interruption_TaskId TaskId
| Unexpected item: IDX dbo.IX_Release_ProjectVariableSetSnapshotId_Id Id
| Unexpected item: IDX dbo.IX_Release_ProjectVariableSetSnapshotId_Id NONCLUSTERED 0
| Unexpected item: IDX dbo.IX_Release_ProjectVariableSetSnapshotId_Id ProjectVariableSetSnapshotId
| Unexpected item: IDX dbo.IX_ServerTask_Name_ConcurrencyTag_Id_State CompletedTime
| Unexpected item: IDX dbo.IX_ServerTask_Name_ConcurrencyTag_Id_State ConcurrencyTag
| Unexpected item: IDX dbo.IX_ServerTask_Name_ConcurrencyTag_Id_State Description
| Unexpected item: IDX dbo.IX_ServerTask_Name_ConcurrencyTag_Id_State DurationSeconds
| Unexpected item: IDX dbo.IX_ServerTask_Name_ConcurrencyTag_Id_State EnvironmentId
| Unexpected item: IDX dbo.IX_ServerTask_Name_ConcurrencyTag_Id_State ErrorMessage
| Unexpected item: IDX dbo.IX_ServerTask_Name_ConcurrencyTag_Id_State HasPendingInterruptions
| Unexpected item: IDX dbo.IX_ServerTask_Name_ConcurrencyTag_Id_State HasWarningsOrErrors
| Unexpected item: IDX dbo.IX_ServerTask_Name_ConcurrencyTag_Id_State Id
| Unexpected item: IDX dbo.IX_ServerTask_Name_ConcurrencyTag_Id_State JSON
| Unexpected item: IDX dbo.IX_ServerTask_Name_ConcurrencyTag_Id_State Name
| Unexpected item: IDX dbo.IX_ServerTask_Name_ConcurrencyTag_Id_State NONCLUSTERED 0
| Unexpected item: IDX dbo.IX_ServerTask_Name_ConcurrencyTag_Id_State ProjectId
| Unexpected item: IDX dbo.IX_ServerTask_Name_ConcurrencyTag_Id_State QueueTime
| Unexpected item: IDX dbo.IX_ServerTask_Name_ConcurrencyTag_Id_State ServerNodeId
| Unexpected item: IDX dbo.IX_ServerTask_Name_ConcurrencyTag_Id_State StartTime
| Unexpected item: IDX dbo.IX_ServerTask_Name_ConcurrencyTag_Id_State State
| Unexpected item: IDX dbo.IX_ServerTask_Name_ConcurrencyTag_Id_State TenantId
|


#5

Hi @SayreX,

Thanks for getting in touch!

What you are seeing there is that your System Integrity Check is reporting extra indexes on tables/columns in your Octopus database that aren’t there by default. While we have not had an instance where this has caused any issues, we do recommend not adding extra indexes unless there is an underlying reason why they are required in your environment.

As these aren’t enabled by default they may be removed as part of a normal Octopus upgrade, so keep that in mind when you are doing your upgrades that these indexes might need to be re-applied.

They can also be safely removed from your database if they aren’t providing any performance gain or if you would prefer to have standard Octopus install.

Please let me know if there is anything else that we can assist with,

Regards,
Alex


#6

ok, thank you, I think that we will just upgrade Octopus