Skip to content

Rename misnamed CI indexes

Stan Hurequested to merge
sh-fix-misnamed-ci-indexes into master

What does this MR do and why?

The database diagnostics page flagged a number of indexes that were not consistent with db/structure.sql due to the bigint conversion.

This commit renames 14 CI indexes from and to the following names:

  1. p_ci_builds_metadata_build_id_convert_to_bigint_id_convert__idx -> p_ci_builds_metadata_build_id_id_idx
  2. p_ci_builds_metadata_build_id_convert_to_bigint_idx -> p_ci_builds_metadata_build_id_idx
  3. p_ci_pipelines_ci_ref_id_id_convert_to_bigint_idx -> p_ci_pipelines_ci_ref_id_id_idx
  4. p_ci_pipelines_ci_ref_id_id_convert_to_bigint_source_status_idx -> p_ci_pipelines_ci_ref_id_id_source_status_idx
  5. p_ci_pipelines_id_convert_to_bigint_idx -> p_ci_pipelines_id_idx
  6. p_ci_pipelines_pipeline_schedule_id_id_convert_to_bigint_idx ->p_ci_pipelines_pipeline_schedule_id_id_idx
  7. p_ci_pipelines_project_id_id_convert_to_bigint_idx -> p_ci_pipelines_project_id_id_idx
  8. p_ci_pipelines_project_id_ref_id_convert_to_bigint_idx ->p_ci_pipelines_project_id_ref_id_idx
  9. p_ci_pipelines_project_id_ref_status_id_convert_to_bigint_idx ->p_ci_pipelines_project_id_ref_status_id_idx
  10. p_ci_pipelines_status_id_convert_to_bigint_idx -> p_ci_pipelines_status_id_idx
  11. p_ci_pipelines_user_id_id_convert_to_bigint_idx -> p_ci_pipelines_user_id_id_idx
  12. p_ci_pipelines_user_id_id_convert_to_bigint_idx1 -> p_ci_pipelines_user_id_id_idx1
  13. p_ci_stages_pipeline_id_convert_to_bigint_id_idx -> p_ci_stages_pipeline_id_id_idx
  14. p_ci_stages_pipeline_id_convert_to_bigint_position_idx -> p_ci_stages_pipeline_id_position_idx

References

Relates to https://gitlab.com/gitlab-com/request-for-help/-/issues/3342

MR acceptance checklist

Evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

Edited by Stan Hu

Merge request reports