Skip to content

Remove duplicated index from alert_management_http_integrations

Leonardo da Rosa requested to merge remove-duplicated-indexes-alert_management_http_integrations into master

What does this MR do and why?

Remove duplicated index from alert_management_http_integrations table.

It removes:

Drop index_alert_management_http_integrations_on_project_id as it's already covered by:

Index Columns
index_http_integrations_on_project_and_endpoint project_id asc, endpoint_identifier asc

It is possible that this MR will still need some changes to drop the index from the database. Currently, the gitlab-housekeeper is not always capable of removing all references, so you must check the diff and pipeline failures to confirm if there are any issues. Ensure that the index exists in the production database by checking Joe Bot trough https://console.postgres.ai/gitlab. If the index was already removed or if the index it's being removed in another merge request, consider closing this merge request.

This change was generated by gitlab-housekeeper using the Keeps::RemoveDuplicatedIndexes keep.

To provide feedback on your experience with gitlab-housekeeper please comment in gitlab-org/gitlab#442003.

Merge request reports