Backfill issues.correct_work_item_type_id with correct value
What does this MR do and why?
We need to backfill all issue records as we want to use this new column to filter by work item type temporarily
MR acceptance checklist
Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.
DB review
DB plans
https://console.postgres.ai/gitlab/gitlab-production-main/sessions/32262/commands/99684
SELECT
issues.id
FROM
issues
WHERE
issues.id BETWEEN 4
AND 14366
AND issues.id >= 4
ORDER BY
issues.id ASC
LIMIT
1 OFFSET 50
https://console.postgres.ai/gitlab/gitlab-production-main/sessions/32262/commands/99685
SELECT
min(id),
max(id)
FROM
issues
WHERE
issues.id BETWEEN 4
AND 14366
AND issues.id >= 4
AND issues.id < 108
LIMIT
1
https://console.postgres.ai/gitlab/gitlab-production-main/sessions/32262/commands/99686
UPDATE
issues
SET
correct_work_item_type_id = work_item_types.correct_id
FROM
work_item_types
WHERE
issues.work_item_type_id = work_item_types.id
AND issues.id BETWEEN 4
AND 107
Migration output
UP
main: == [advisory_lock_connection] object_id: 129180, pg_backend_pid: 71173
main: == 20241002185804 QueueBackfillIssuesCorrectWorkItemTypeId: migrating =========
main: == 20241002185804 QueueBackfillIssuesCorrectWorkItemTypeId: migrated (0.0530s)
main: == [advisory_lock_connection] object_id: 129180, pg_backend_pid: 71173
ci: == [advisory_lock_connection] object_id: 129600, pg_backend_pid: 71175
ci: == 20241002185804 QueueBackfillIssuesCorrectWorkItemTypeId: migrating =========
ci: -- The migration is skipped since it modifies the schemas: [:gitlab_main].
ci: -- This database can only apply migrations in one of the following schemas: [:gitlab_ci, :gitlab_internal, :gitlab_shared].
ci: == 20241002185804 QueueBackfillIssuesCorrectWorkItemTypeId: migrated (0.0073s)
ci: == [advisory_lock_connection] object_id: 129600, pg_backend_pid: 71175
DOWN
main: == [advisory_lock_connection] object_id: 128740, pg_backend_pid: 69358
main: == 20241002185804 QueueBackfillIssuesCorrectWorkItemTypeId: reverting =========
main: == 20241002185804 QueueBackfillIssuesCorrectWorkItemTypeId: reverted (0.0454s)
main: == [advisory_lock_connection] object_id: 128740, pg_backend_pid: 69358
ci: == [advisory_lock_connection] object_id: 138500, pg_backend_pid: 69620
ci: == 20241002185804 QueueBackfillIssuesCorrectWorkItemTypeId: reverting =========
ci: -- The migration is skipped since it modifies the schemas: [:gitlab_main].
ci: -- This database can only apply migrations in one of the following schemas: [:gitlab_ci, :gitlab_internal, :gitlab_shared].
ci: == 20241002185804 QueueBackfillIssuesCorrectWorkItemTypeId: reverted (0.0159s)
ci: == [advisory_lock_connection] object_id: 138500, pg_backend_pid: 69620
Related to #493975 (closed)
Edited by Mario Celi