diff --git a/db/docs/batched_background_migrations/backfill_archived_and_traversal_ids_to_vulnerability_statistics.yml b/db/docs/batched_background_migrations/backfill_archived_and_traversal_ids_to_vulnerability_statistics.yml index 12bfcf1f4107c38d4bb24b0eed6a86ae6a489f45..981c82c30c0387009aec3501c8771a4c4c69e28c 100644 --- a/db/docs/batched_background_migrations/backfill_archived_and_traversal_ids_to_vulnerability_statistics.yml +++ b/db/docs/batched_background_migrations/backfill_archived_and_traversal_ids_to_vulnerability_statistics.yml @@ -1,8 +1,9 @@ --- migration_job_name: BackfillArchivedAndTraversalIdsToVulnerabilityStatistics -description: Backfill project.archived and project.namespace.traversal_ids values to the denormalized columns of the same name on vulnerability_statistics +description: Backfill project.archived and project.namespace.traversal_ids values + to the denormalized columns of the same name on vulnerability_statistics feature_category: vulnerability_management introduced_by_url: https://gitlab.com/gitlab-org/gitlab/-/merge_requests/177993 milestone: '18.2' queued_migration_version: 20250630065826 -finalized_by: # version of the migration that finalized this BBM +finalized_by: '20251214233315' diff --git a/db/post_migrate/20251214233315_finalize_hk_backfill_archived_and_traversal_ids_to_vulnerability_statistic.rb b/db/post_migrate/20251214233315_finalize_hk_backfill_archived_and_traversal_ids_to_vulnerability_statistic.rb new file mode 100644 index 0000000000000000000000000000000000000000..9f83dc3f5fd774bff815b4c94b61ca1b932cf2ce --- /dev/null +++ b/db/post_migrate/20251214233315_finalize_hk_backfill_archived_and_traversal_ids_to_vulnerability_statistic.rb @@ -0,0 +1,21 @@ +# frozen_string_literal: true + +class FinalizeHkBackfillArchivedAndTraversalIdsToVulnerabilityStatistic < Gitlab::Database::Migration[2.3] + milestone '18.7' + + disable_ddl_transaction! + + restrict_gitlab_migration gitlab_schema: :gitlab_sec + + def up + ensure_batched_background_migration_is_finished( + job_class_name: 'BackfillArchivedAndTraversalIdsToVulnerabilityStatistics', + table_name: :vulnerability_statistics, + column_name: :id, + job_arguments: [], + finalize: true + ) + end + + def down; end +end diff --git a/db/schema_migrations/20251214233315 b/db/schema_migrations/20251214233315 new file mode 100644 index 0000000000000000000000000000000000000000..981e6123a33606d296a0d86733f01c67c6e3038a --- /dev/null +++ b/db/schema_migrations/20251214233315 @@ -0,0 +1 @@ +30a0c1b34a1e4adc83bc48212fb335aac6ee79a598b572fd841e30bd0cbcaa59 \ No newline at end of file