Skip to content

Prepare index_issues_on_work_item_type_id index in Gitlab.com

Mario Celi requested to merge 410225-prepare-index into master

What does this MR do and why?

Prepare index_issues_on_work_item_type_id_project_id_created_at_state index index creation in Gitlab.com. Migration is a no-op in other instances. Sync migration will be introduced in a follow-up MR

Migration output

UP

bin/rails db:migrate
main: == [advisory_lock_connection] object_id: 275900, pg_backend_pid: 53990
main: == 20230516172446 PrepareIssuesWorkItemTypeIdProjectIdIndex: migrating ========
main: -- index_exists?(:issues, [:work_item_type_id, :project_id, :created_at, :state_id], {:name=>"index_issues_on_work_item_type_id_project_id_created_at_state", :algorithm=>:concurrently})
main:    -> 0.0230s
main: == 20230516172446 PrepareIssuesWorkItemTypeIdProjectIdIndex: migrated (0.2690s)

main: == [advisory_lock_connection] object_id: 275900, pg_backend_pid: 53990
ci: == [advisory_lock_connection] object_id: 276100, pg_backend_pid: 53992
ci: == 20230516172446 PrepareIssuesWorkItemTypeIdProjectIdIndex: migrating ========
ci: -- index_exists?(:issues, [:work_item_type_id, :project_id, :created_at, :state_id], {:name=>"index_issues_on_work_item_type_id_project_id_created_at_state", :algorithm=>:concurrently})
ci:    -> 0.0271s
ci: == 20230516172446 PrepareIssuesWorkItemTypeIdProjectIdIndex: migrated (0.0459s)

ci: == [advisory_lock_connection] object_id: 276100, pg_backend_pid: 53992

DOWN

bin/rails db:migrate:down:main db:migrate:down:ci VERSION=20230516172446
main: == [advisory_lock_connection] object_id: 275620, pg_backend_pid: 56912
main: == 20230516172446 PrepareIssuesWorkItemTypeIdProjectIdIndex: reverting ========
main: == 20230516172446 PrepareIssuesWorkItemTypeIdProjectIdIndex: reverted (0.2536s)

main: == [advisory_lock_connection] object_id: 275620, pg_backend_pid: 56912
ci: == [advisory_lock_connection] object_id: 281200, pg_backend_pid: 57157
ci: == 20230516172446 PrepareIssuesWorkItemTypeIdProjectIdIndex: reverting ========
ci: == 20230516172446 PrepareIssuesWorkItemTypeIdProjectIdIndex: reverted (0.0259s)

ci: == [advisory_lock_connection] object_id: 281200, pg_backend_pid: 57157

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

Related to #410225 (closed)

Merge request reports