Add migration to fix vulnerabilities transitioned from dismissed to resolved

Brian Williamsrequested to merge
bwill/migration-to-fix-vulnerabilities-transitioned-from-dismissed-to-resolved into master

What does this MR do and why?

This MR adds a migration to correct vulnerabilities that were incorrectly auto-resolved due to a bug. This migration is enqueued via a rake task because we don't want to migrate customer's data unless we have their permission. The job arguments can be used to migrate either a single namespace or the entire instance. On GitLab.com this migration may be enqueued multiple times as we migrate several customers. This migration will never be finalized since we can't be sure when it was enqueued.

References

SQL

Select sub batch: https://console.postgres.ai/gitlab/gitlab-production-sec/sessions/39687/commands/122243

Select vulnerabilities with at least one state transition: https://console.postgres.ai/gitlab/gitlab-production-sec/sessions/39687/commands/122246

Select state transitions: https://console.postgres.ai/gitlab/gitlab-production-sec/sessions/39687/commands/122247

Update state to dismissed: https://console.postgres.ai/gitlab/gitlab-production-sec/sessions/39687/commands/122248

Insert state transitions:

Click to expand 
INSERT INTO vulnerability_state_transitions ( project_id, author_id, from_state, to_state, dismissal_reason, vulnerability_id, comment, created_at, updated_at )
    VALUES
        ( 278964, 14, 3, 2, 1, 1, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 2, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 3, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 4, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 5, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 6, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 7, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 8, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 12, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 23, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 24, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 25, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 26, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 27, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 47, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 48, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 49, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 50, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 53, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 60, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 62, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 63, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 65, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 67, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 68, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 69, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 70, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 71, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 72, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 73, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 74, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 75, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 76, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 77, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 90, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 91, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 92, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 93, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 95, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 101, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 102, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 105, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 106, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 107, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 108, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 119, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 120, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 122, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 125, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 126, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 127, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 128, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 128, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 129, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 130, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 131, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 132, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 133, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 134, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 135, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 136, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 137, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 138, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 139, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 140, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 141, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 142, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 143, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 144, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 145, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 146, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 147, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 148, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 170, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 171, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 175, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 177, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 178, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 180, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 181, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 182, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 183, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 184, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 185, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 186, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 188, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 189, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 190, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 191, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 192, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 200, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 205, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 208, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 210, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 212, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 213, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 214, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 215, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 216, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 217, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 218, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' ),
        ( 278964, 14, 3, 2, 1, 219, 'Status changed to dismissed. Reverts a bug that incorrectly set this vulnerability to resolved.For details, see [issue 523433](https://gitlab.com/gitlab-org/gitlab/-/issues/523433)', '2025-05-23 21:26:16.205180', '2025-05-23 21:26:16.205180' )
    ON CONFLICT DO NOTHING
    RETURNING id;

Insert notes: https://console.postgres.ai/gitlab/gitlab-production-main/sessions/39690/commands/122249

Screenshots or screen recordings

Screenshot_2025-05-19_at_4.35.45_PM

How to set up and validate locally

  1. Run bundle exec rake 'gitlab:vulnerabilities:fix_auto_resolved_vulnerabilities[instance]'
  2. Go to <gdk_url>/admin/background_migrations and observe that the migration has been enqueued
  3. Run bundle exec rake 'gitlab:vulnerabilities:fix_auto_resolved_vulnerabilities:revert[instance]'
  4. Refresh the background migrations page and the migration should be gone

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 Brian Williams

Merge request reports