Skip to content
Snippets Groups Projects

Initialize conversion of vulnerability_user_mentions.note_id to bigint

Merged Initialize conversion of vulnerability_user_mentions.note_id to bigint
389306/vulnerability_user_mentions/initialize into master
Merged Krasimir Angelov requested to merge 389306/vulnerability_user_mentions/initialize into master

What does this MR do and why?

Initialize the conversion of vulnerability_user_mentions.note_id from integer to bigint, as it references notes.id.

This MR creates the new bigint column, installs the trigger to keep it in sync for new records, and queues batched background migration to back-fill the existing records.

#389306 (closed)

How to set up and validate locally

Numbered steps to set up and validate the change are strongly suggested.

MR acceptance checklist

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

Merge request reports

Merged results pipeline #780190687 passed

Stage: sync
Stage: preflight
Stage: prepare
Stage: build-images
Stage: fixtures
Stage: lint
Stage: test
Stage: post-test
Stage: review
Stage: qa
Pipeline: GitLab

#780198443

    Merged results pipeline passed for ac34f5ed

    Test coverage 82.42% from 2 jobs
    Approved by
    Simon Tomlinson Terri Chu

    Merged by Simon TomlinsonSimon Tomlinson 2 years ago (Feb 16, 2023 8:28pm UTC)

    Merge details

    • Changes merged into master with 1e5d15b5 (commits were squashed).
    • Deleted the source branch.

    • Mentions issue #389306 (closed)

    • Auto-merge enabled

    Pipeline #780302116 passed

    Stage: sync
    Stage: preflight
    Stage: prepare
    Stage: build-images
    Stage: fixtures
    Stage: lint
    Stage: test
    Stage: post-test
    Stage: notify

    Pipeline passed for 1e5d15b5 on master

    Test coverage 66.73% from 2 jobs
    10 environments impacted.

    Activity

    Filter activity
    • Approvals
    • Assignees & reviewers
    • Comments (from bots)
    • Comments (from users)
    • Commits & branches
    • Edits
    • Labels
    • Lock status
    • Mentions
    • Merge request status
    • Tracking
    • Krasimir Angelov changed milestone to %15.9

      changed milestone to %15.9

    • Krasimir Angelov added Category:Database ~20757942 backend database database-testing-automation databasereview pending devopsdata stores groupdatabase maintenancescalability sectioncore platform typemaintenance workflowin dev labels

      added Category:Database ~20757942 backend database database-testing-automation databasereview pending devopsdata stores groupdatabase maintenancescalability sectioncore platform typemaintenance workflowin dev labels

    • Krasimir Angelov assigned to @krasio

      assigned to @krasio

    • Ghost User
      Ghost User @ghost1
      Contributor
      1 Warning
      :warning: You've made some app changes, but didn't add any tests.
      That's OK as long as you're refactoring existing code,
      but please consider adding any of the maintenancepipelines, maintenancerefactor, maintenanceworkflow, documentation, QA labels.

      Reviewer roulette

      Changes that require review have been detected!

      Please refer to the table below for assigning reviewers and maintainers suggested by Danger in the specified category:

      Category Reviewer Maintainer
      backend Michał Wielich current availability (@michold) (UTC+1, 12 hours behind @krasio) Mark Chao current availability (@lulalala) (UTC+8, 5 hours behind @krasio)
      database Max Woolf current availability (@mwoolf) (UTC+0, 13 hours behind @krasio) Adam Hegyi current availability (@ahegyi) (UTC+1, 12 hours behind @krasio)
      ~"migration" No reviewer available No maintainer available

      To spread load more evenly across eligible reviewers, Danger has picked a candidate for each review slot, based on their timezone. Feel free to override these selections if you think someone else would be better-suited or use the GitLab Review Workload Dashboard to find other available reviewers.

      To read more on how to use the reviewer roulette, please take a look at the Engineering workflow and code review guidelines. Please consider assigning a reviewer or maintainer who is a domain expert in the area of the merge request.

      Once you've decided who will review this merge request, assign them as a reviewer! Danger does not automatically notify them for you.

      If needed, you can retry the :repeat: danger-review job that generated this comment.

      Generated by :no_entry_sign: Danger

      Edited by Ghost User
    • Ghost User
      Ghost User @ghost1
      Contributor

      Database migrations (on the main database)

      Migrations included in this change have been executed on gitlab.com data for testing purposes. For details, please see the migration testing pipeline (limited access).

      Migration Type Total runtime Result DB size change
      20230207012217 - InitializeConversionOfVulnerabilityUserMentionsNoteIdToBigint Regular 2.5 s :white_check_mark: +0.00 B
      20230207012238 - BackfillVulnerabilityUserMentionsNoteIdForBigintConversion Post deploy 1.9 s :white_check_mark: +24.00 KiB
      Runtime Histogram for all migrations
      Query Runtime Count
      0 seconds - 0.01 seconds 0
      0.01 seconds - 0.1 seconds 10
      0.1 seconds - 1 second 0
      1 second - 5 seconds 0
      5 seconds - 15 seconds 0
      15 seconds - 5 minutes 0
      5 minutes + 0

      Migration: 20230207012217 - InitializeConversionOfVulnerabilityUserMentionsNoteIdToBigint

      • Type: Regular
      • Duration: 2.5 s
      • Database size change: +0.00 B
      Calls Total Time Max Time Mean Time Rows Query
      1 16.5 ms 16.5 ms 16.5 ms 0 
      CREATE OR REPLACE FUNCTION trigger_0e214b8a14f2() RETURNS trigger AS $1 LANGUAGE $2 VOLATILE /*application:test,db_config_name:main,line:/lib/gitlab/database/unidirectional_copy_trigger.rb:22:in `create'*/
      1 10.5 ms 10.5 ms 10.5 ms 0 
      CREATE TRIGGER trigger_0e214b8a14f2 BEFORE INSERT OR UPDATE ON "vulnerability_user_mentions" FOR EACH ROW EXECUTE FUNCTION trigger_0e214b8a14f2() /*application:test,db_config_name:main,line:/lib/gitlab/database/unidirectional_copy_trigger.rb:40:in `create'*/
      1 6.1 ms 6.1 ms 6.1 ms 0 
      ALTER TABLE "vulnerability_user_mentions" ADD "note_id_convert_to_bigint" bigint DEFAULT NULL /*application:test,db_config_name:main,line:/lib/gitlab/database/migration_helpers.rb:1217:in `block (2 levels) in create_temporary_columns_and_triggers'*/
      1 0.1 ms 0.1 ms 0.1 ms 0 
      DROP TRIGGER IF EXISTS trigger_0e214b8a14f2 ON "vulnerability_user_mentions" /*application:test,db_config_name:main,line:/lib/gitlab/database/unidirectional_copy_trigger.rb:35:in `create'*/
      1 0.0 ms 0.0 ms 0.0 ms 1 
      SELECT has_table_privilege($1, $2) /*application:test,db_config_name:main,line:/lib/gitlab/database/grant.rb:17:in `create_and_execute_trigger?'*/
      1 0.0 ms 0.0 ms 0.0 ms 1 
      SELECT $1::regtype::oid
      Histogram for InitializeConversionOfVulnerabilityUserMentionsNoteIdToBigint
      Query Runtime Count
      0 seconds - 0.01 seconds 0
      0.01 seconds - 0.1 seconds 6
      0.1 seconds - 1 second 0
      1 second - 5 seconds 0
      5 seconds - 15 seconds 0
      15 seconds - 5 minutes 0
      5 minutes + 0

      Migration: 20230207012238 - BackfillVulnerabilityUserMentionsNoteIdForBigintConversion

      • Type: Post deploy
      • Duration: 1.9 s
      • Database size change: +24.00 KiB
      Calls Total Time Max Time Mean Time Rows Query
      1 2.7 ms 2.7 ms 2.7 ms 1 
      SELECT MAX("id")
        FROM "vulnerability_user_mentions" /*application:test,db_config_name:main,line:/lib/gitlab/database/migrations/batched_background_migration_helpers.rb:88:in `queue_batched_background_migration'*/
      1 1.2 ms 1.2 ms 1.2 ms 1 
      INSERT INTO "batched_background_migrations" ("created_at", "updated_at", "max_value", "batch_size", "sub_batch_size", "interval", "status", "job_class_name", "table_name", "column_name", "job_arguments", "total_tuple_count", "started_at", "gitlab_schema") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) RETURNING "id" /*application:test,db_config_name:main,line:/lib/gitlab/database.rb:342:in `block in transaction'*/
      1 0.0 ms 0.0 ms 0.0 ms 0 
      SELECT $1 AS one
        FROM "batched_background_migrations"  WHERE "batched_background_migrations"."job_class_name" = $2 AND "batched_background_migrations"."table_name" = $3 AND "batched_background_migrations"."column_name" = $4 AND (job_arguments = $5) AND "batched_background_migrations"."gitlab_schema" = $6
        LIMIT $7 /*application:test,db_config_name:main,line:/lib/gitlab/database/migrations/batched_background_migration_helpers.rb:79:in `queue_batched_background_migration'*/
      1 0.0 ms 0.0 ms 0.0 ms 0 
      SELECT $1 AS one
        FROM "batched_background_migrations"  WHERE "batched_background_migrations"."job_arguments" = $2 AND "batched_background_migrations"."job_class_name" = $3 AND "batched_background_migrations"."table_name" = $4 AND "batched_background_migrations"."column_name" = $5
        LIMIT $6 /*application:test,db_config_name:main,line:/lib/gitlab/database.rb:342:in `block in transaction'*/
      Histogram for BackfillVulnerabilityUserMentionsNoteIdForBigintConversion
      Query Runtime Count
      0 seconds - 0.01 seconds 0
      0.01 seconds - 0.1 seconds 4
      0.1 seconds - 1 second 0
      1 second - 5 seconds 0
      5 seconds - 15 seconds 0
      15 seconds - 5 minutes 0
      5 minutes + 0

      Background migrations

      Background Migration: MigrateVulnerabilitiesFeedbackToVulnerabilitiesStateTransition

      Sampled 102 batches

      Calls Total Time Max Time Mean Time Rows Query
      85 130645.7 ms 5075.4 ms 1537.0 ms 50 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50) AND (EXISTS (
          SELECT $51
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.uuid = vulnerability_feedback.finding_uuid::varchar
        ) OR EXISTS (
          SELECT $52
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.project_fingerprint = vulnerability_feedback.project_fingerprint::bytea
        ) OR EXISTS (
          SELECT $53
          FROM security_findings
          WHERE security_findings.uuid = vulnerability_feedback.finding_uuid
        )) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:120:in `block in perform'*/
      5 110.3 ms 44.9 ms 22.1 ms 1 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" = $1 AND (EXISTS (
          SELECT $2
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.uuid = vulnerability_feedback.finding_uuid::varchar
        ) OR EXISTS (
          SELECT $3
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.project_fingerprint = vulnerability_feedback.project_fingerprint::bytea
        ) OR EXISTS (
          SELECT $4
          FROM security_findings
          WHERE security_findings.uuid = vulnerability_feedback.finding_uuid
        )) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:120:in `block in perform'*/
      4925 1594.6 ms 15.8 ms 0.3 ms 71 
      SELECT "security_findings"."id", "security_findings"."scan_id", "security_findings"."scanner_id", "security_findings"."severity", "security_findings"."confidence", "security_findings"."project_fingerprint", "security_findings"."deduplicated", "security_findings"."uuid", "security_findings"."overridden_uuid", "security_findings"."finding_data"  FROM "security_findings"  WHERE "security_findings"."uuid" = $1
        LIMIT $2 /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:126:in `block (2 levels) in perform'*/
      102 91.7 ms 7.7 ms 0.9 ms 53 
      SELECT "vulnerability_feedback"."id"  FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" BETWEEN $1 AND $2 AND "vulnerability_feedback"."feedback_type" = $3 AND "vulnerability_feedback"."migrated_to_state_transition" = $4
        ORDER BY "vulnerability_feedback"."id" ASC
        LIMIT $5 /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/app/models/concerns/each_batch.rb:62:in `each_batch'*/
      85 26.4 ms 0.5 ms 0.3 ms 4250 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:126:in `block in perform'*/
      204 33.2 ms 7.2 ms 0.2 ms 204 
      INSERT INTO "batched_background_migration_job_transition_logs" ("batched_background_migration_job_id", "created_at", "updated_at", "previous_status", "next_status") VALUES ($1, $2, $3, $4, $5) RETURNING "id" /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/lib/gitlab/database.rb:342:in `block in transaction'*/
      102 13.7 ms 1.4 ms 0.1 ms 102 
      UPDATE "batched_background_migration_jobs"  SET "updated_at" = $1, "finished_at" = $2, "status" = $3, "metrics" = $4
        WHERE "batched_background_migration_jobs"."id" = $5 /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/lib/gitlab/database.rb:342:in `block in transaction'*/
      130 28.7 ms 4.1 ms 0.2 ms 77 
      SELECT "vulnerability_feedback"."id"  FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" BETWEEN $1 AND $2 AND "vulnerability_feedback"."feedback_type" = $3 AND "vulnerability_feedback"."migrated_to_state_transition" = $4 AND "vulnerability_feedback"."id" >= $5
        ORDER BY "vulnerability_feedback"."id" ASC
        LIMIT $6
        OFFSET $7 /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
      102 11.0 ms 0.8 ms 0.1 ms 102 
      UPDATE "batched_background_migration_jobs"  SET "updated_at" = $1, "started_at" = $2, "status" = $3, "attempts" = $4
        WHERE "batched_background_migration_jobs"."id" = $5 /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/lib/gitlab/database.rb:342:in `block in transaction'*/
      204 7.5 ms 0.1 ms 0.0 ms 204 
      SELECT "batched_background_migration_jobs".*
        FROM "batched_background_migration_jobs"  WHERE "batched_background_migration_jobs"."id" = $1
        LIMIT $2 /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/lib/gitlab/database.rb:342:in `block in transaction'*/
      77 3.1 ms 0.2 ms 0.0 ms 3850 
      SELECT "vulnerability_feedback"."id"  FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" BETWEEN $1 AND $2 AND "vulnerability_feedback"."feedback_type" = $3 AND "vulnerability_feedback"."migrated_to_state_transition" = $4 AND "vulnerability_feedback"."id" >= $5 AND "vulnerability_feedback"."id" < $6 /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:115:in `block in perform'*/
      102 9.9 ms 0.2 ms 0.1 ms 102 
      SELECT SUM("batched_background_migration_jobs"."batch_size")
        FROM "batched_background_migration_jobs"  WHERE "batched_background_migration_jobs"."batched_background_migration_id" = $1 AND ("batched_background_migration_jobs"."status" IN ($2)) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/lib/gitlab/database/background_migration/batched_migration.rb:189:in `migrated_tuple_count'*/
      5 0.2 ms 0.0 ms 0.0 ms 5 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" = $1 /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:126:in `block in perform'*/
      53 1.5 ms 0.1 ms 0.0 ms 1277 
      SELECT "vulnerability_feedback"."id"  FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" BETWEEN $1 AND $2 AND "vulnerability_feedback"."feedback_type" = $3 AND "vulnerability_feedback"."migrated_to_state_transition" = $4 AND "vulnerability_feedback"."id" >= $5 /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:115:in `block in perform'*/
      1 236.1 ms 236.1 ms 236.1 ms 0 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) AND (EXISTS (
          SELECT $11
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.uuid = vulnerability_feedback.finding_uuid::varchar
        ) OR EXISTS (
          SELECT $12
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.project_fingerprint = vulnerability_feedback.project_fingerprint::bytea
        ) OR EXISTS (
          SELECT $13
          FROM security_findings
          WHERE security_findings.uuid = vulnerability_feedback.finding_uuid
        )) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:120:in `block in perform'*/
      1 0.1 ms 0.1 ms 0.1 ms 10 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:126:in `block in perform'*/
      1 10.8 ms 10.8 ms 10.8 ms 0 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8) AND (EXISTS (
          SELECT $9
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.uuid = vulnerability_feedback.finding_uuid::varchar
        ) OR EXISTS (
          SELECT $10
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.project_fingerprint = vulnerability_feedback.project_fingerprint::bytea
        ) OR EXISTS (
          SELECT $11
          FROM security_findings
          WHERE security_findings.uuid = vulnerability_feedback.finding_uuid
        )) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:120:in `block in perform'*/
      1 0.1 ms 0.1 ms 0.1 ms 8 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:126:in `block in perform'*/
      1 4.4 ms 4.4 ms 4.4 ms 0 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20) AND (EXISTS (
          SELECT $21
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.uuid = vulnerability_feedback.finding_uuid::varchar
        ) OR EXISTS (
          SELECT $22
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.project_fingerprint = vulnerability_feedback.project_fingerprint::bytea
        ) OR EXISTS (
          SELECT $23
          FROM security_findings
          WHERE security_findings.uuid = vulnerability_feedback.finding_uuid
        )) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:120:in `block in perform'*/
      1 0.1 ms 0.1 ms 0.1 ms 20 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:126:in `block in perform'*/
      3 557.5 ms 235.9 ms 185.8 ms 0 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" IN ($1, $2, $3, $4, $5, $6) AND (EXISTS (
          SELECT $7
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.uuid = vulnerability_feedback.finding_uuid::varchar
        ) OR EXISTS (
          SELECT $8
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.project_fingerprint = vulnerability_feedback.project_fingerprint::bytea
        ) OR EXISTS (
          SELECT $9
          FROM security_findings
          WHERE security_findings.uuid = vulnerability_feedback.finding_uuid
        )) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:120:in `block in perform'*/
      3 0.2 ms 0.1 ms 0.1 ms 18 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" IN ($1, $2, $3, $4, $5, $6) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:126:in `block in perform'*/
      1 956.2 ms 956.2 ms 956.2 ms 0 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41) AND (EXISTS (
          SELECT $42
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.uuid = vulnerability_feedback.finding_uuid::varchar
        ) OR EXISTS (
          SELECT $43
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.project_fingerprint = vulnerability_feedback.project_fingerprint::bytea
        ) OR EXISTS (
          SELECT $44
          FROM security_findings
          WHERE security_findings.uuid = vulnerability_feedback.finding_uuid
        )) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:120:in `block in perform'*/
      1 0.3 ms 0.3 ms 0.3 ms 41 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:126:in `block in perform'*/
      2 11.9 ms 6.0 ms 5.9 ms 0 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" IN ($1, $2, $3, $4) AND (EXISTS (
          SELECT $5
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.uuid = vulnerability_feedback.finding_uuid::varchar
        ) OR EXISTS (
          SELECT $6
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.project_fingerprint = vulnerability_feedback.project_fingerprint::bytea
        ) OR EXISTS (
          SELECT $7
          FROM security_findings
          WHERE security_findings.uuid = vulnerability_feedback.finding_uuid
        )) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:120:in `block in perform'*/
      2 0.1 ms 0.1 ms 0.0 ms 8 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" IN ($1, $2, $3, $4) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:126:in `block in perform'*/
      2 120.8 ms 70.9 ms 60.4 ms 0 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" IN ($1, $2) AND (EXISTS (
          SELECT $3
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.uuid = vulnerability_feedback.finding_uuid::varchar
        ) OR EXISTS (
          SELECT $4
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.project_fingerprint = vulnerability_feedback.project_fingerprint::bytea
        ) OR EXISTS (
          SELECT $5
          FROM security_findings
          WHERE security_findings.uuid = vulnerability_feedback.finding_uuid
        )) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:120:in `block in perform'*/
      2 0.1 ms 0.0 ms 0.0 ms 4 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" IN ($1, $2) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:126:in `block in perform'*/
      3 4009.8 ms 1578.0 ms 1336.6 ms 0 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49) AND (EXISTS (
          SELECT $50
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.uuid = vulnerability_feedback.finding_uuid::varchar
        ) OR EXISTS (
          SELECT $51
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.project_fingerprint = vulnerability_feedback.project_fingerprint::bytea
        ) OR EXISTS (
          SELECT $52
          FROM security_findings
          WHERE security_findings.uuid = vulnerability_feedback.finding_uuid
        )) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:120:in `block in perform'*/
      3 0.9 ms 0.3 ms 0.3 ms 147 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:126:in `block in perform'*/
      1 3108.3 ms 3108.3 ms 3108.3 ms 1455 
      SELECT "security_findings"."id", "security_findings"."scan_id", "security_findings"."scanner_id", "security_findings"."severity", "security_findings"."confidence", "security_findings"."project_fingerprint", "security_findings"."deduplicated", "security_findings"."uuid", "security_findings"."overridden_uuid", "security_findings"."finding_data"  FROM "security_findings"  WHERE "security_findings"."uuid" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:120:in `block in perform'*/
      65 316.1 ms 83.0 ms 4.9 ms 65 
      UPDATE "vulnerability_feedback"  SET "updated_at" = $1, "migrated_to_state_transition" = $2
        WHERE "vulnerability_feedback"."id" = $3 /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:228:in `save_state_transition'*/
      48 169.7 ms 95.9 ms 3.5 ms 48 
      INSERT INTO "vulnerability_state_transitions" ("vulnerability_id", "to_state", "from_state", "created_at", "updated_at", "author_id", "comment") VALUES ($1, $2, $3, $4, $5, $6, $7) RETURNING "id" /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:227:in `save_state_transition'*/
      3 92.9 ms 53.6 ms 31.0 ms 15 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15) AND (EXISTS (
          SELECT $16
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.uuid = vulnerability_feedback.finding_uuid::varchar
        ) OR EXISTS (
          SELECT $17
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.project_fingerprint = vulnerability_feedback.project_fingerprint::bytea
        ) OR EXISTS (
          SELECT $18
          FROM security_findings
          WHERE security_findings.uuid = vulnerability_feedback.finding_uuid
        )) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:120:in `block in perform'*/
      1 43.6 ms 43.6 ms 43.6 ms 15 
      SELECT "vulnerabilities".*
        FROM "vulnerabilities"  WHERE "vulnerabilities"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:120:in `block in perform'*/
      17 54.0 ms 13.8 ms 3.2 ms 17 
      INSERT INTO "vulnerability_state_transitions" ("vulnerability_id", "to_state", "from_state", "created_at", "updated_at", "author_id") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:227:in `save_state_transition'*/
      1 32.0 ms 32.0 ms 32.0 ms 15 
      SELECT "vulnerability_occurrences".*
        FROM "vulnerability_occurrences"  WHERE "vulnerability_occurrences"."uuid" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:120:in `block in perform'*/
      65 62.1 ms 18.3 ms 1.0 ms 65 
      SELECT "vulnerability_occurrences".*
        FROM "vulnerability_occurrences"  WHERE "vulnerability_occurrences"."id" = $1
        LIMIT $2 FOR SHARE /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:139:in `block (2 levels) in handle_vulnerability_present_scenario'*/
      71 4.3 ms 0.1 ms 0.1 ms 65 
      SELECT "vulnerability_occurrences".*
        FROM "vulnerability_occurrences"  WHERE "vulnerability_occurrences"."uuid" = $1
        LIMIT $2 /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:126:in `block (2 levels) in perform'*/
      65 2.5 ms 0.1 ms 0.0 ms 65 
      SELECT "vulnerabilities".*
        FROM "vulnerabilities"  WHERE "vulnerabilities"."id" = $1
        LIMIT $2 /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:143:in `block (2 levels) in handle_vulnerability_present_scenario'*/
      3 0.3 ms 0.1 ms 0.1 ms 45 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:126:in `block in perform'*/
      3 827.5 ms 794.3 ms 275.8 ms 0 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13) AND (EXISTS (
          SELECT $14
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.uuid = vulnerability_feedback.finding_uuid::varchar
        ) OR EXISTS (
          SELECT $15
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.project_fingerprint = vulnerability_feedback.project_fingerprint::bytea
        ) OR EXISTS (
          SELECT $16
          FROM security_findings
          WHERE security_findings.uuid = vulnerability_feedback.finding_uuid
        )) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:120:in `block in perform'*/
      3 0.3 ms 0.1 ms 0.1 ms 39 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:126:in `block in perform'*/
      1 1625.6 ms 1625.6 ms 1625.6 ms 0 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40) AND (EXISTS (
          SELECT $41
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.uuid = vulnerability_feedback.finding_uuid::varchar
        ) OR EXISTS (
          SELECT $42
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.project_fingerprint = vulnerability_feedback.project_fingerprint::bytea
        ) OR EXISTS (
          SELECT $43
          FROM security_findings
          WHERE security_findings.uuid = vulnerability_feedback.finding_uuid
        )) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:120:in `block in perform'*/
      1 0.2 ms 0.2 ms 0.2 ms 40 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:126:in `block in perform'*/
      3 121.8 ms 95.5 ms 40.6 ms 5 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" IN ($1, $2, $3, $4, $5) AND (EXISTS (
          SELECT $6
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.uuid = vulnerability_feedback.finding_uuid::varchar
        ) OR EXISTS (
          SELECT $7
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.project_fingerprint = vulnerability_feedback.project_fingerprint::bytea
        ) OR EXISTS (
          SELECT $8
          FROM security_findings
          WHERE security_findings.uuid = vulnerability_feedback.finding_uuid
        )) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:120:in `block in perform'*/
      3 0.1 ms 0.0 ms 0.0 ms 15 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" IN ($1, $2, $3, $4, $5) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:126:in `block in perform'*/
      2 587.5 ms 562.2 ms 293.8 ms 0 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18) AND (EXISTS (
          SELECT $19
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.uuid = vulnerability_feedback.finding_uuid::varchar
        ) OR EXISTS (
          SELECT $20
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.project_fingerprint = vulnerability_feedback.project_fingerprint::bytea
        ) OR EXISTS (
          SELECT $21
          FROM security_findings
          WHERE security_findings.uuid = vulnerability_feedback.finding_uuid
        )) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:120:in `block in perform'*/
      2 0.2 ms 0.1 ms 0.1 ms 36 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:126:in `block in perform'*/
      1 826.6 ms 826.6 ms 826.6 ms 0 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) AND (EXISTS (
          SELECT $26
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.uuid = vulnerability_feedback.finding_uuid::varchar
        ) OR EXISTS (
          SELECT $27
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.project_fingerprint = vulnerability_feedback.project_fingerprint::bytea
        ) OR EXISTS (
          SELECT $28
          FROM security_findings
          WHERE security_findings.uuid = vulnerability_feedback.finding_uuid
        )) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:120:in `block in perform'*/
      1 0.2 ms 0.2 ms 0.2 ms 25 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:126:in `block in perform'*/
      2 3245.7 ms 2380.7 ms 1622.8 ms 0 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39) AND (EXISTS (
          SELECT $40
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.uuid = vulnerability_feedback.finding_uuid::varchar
        ) OR EXISTS (
          SELECT $41
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.project_fingerprint = vulnerability_feedback.project_fingerprint::bytea
        ) OR EXISTS (
          SELECT $42
          FROM security_findings
          WHERE security_findings.uuid = vulnerability_feedback.finding_uuid
        )) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:120:in `block in perform'*/
      2 0.5 ms 0.3 ms 0.2 ms 78 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:126:in `block in perform'*/
      1 3472.5 ms 3472.5 ms 3472.5 ms 420 
      SELECT "security_findings"."id", "security_findings"."scan_id", "security_findings"."scanner_id", "security_findings"."severity", "security_findings"."confidence", "security_findings"."project_fingerprint", "security_findings"."deduplicated", "security_findings"."uuid", "security_findings"."overridden_uuid", "security_findings"."finding_data"  FROM "security_findings"  WHERE "security_findings"."uuid" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:120:in `block in perform'*/
      1 111.9 ms 111.9 ms 111.9 ms 50 
      SELECT "vulnerabilities".*
        FROM "vulnerabilities"  WHERE "vulnerabilities"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:120:in `block in perform'*/
      1 70.9 ms 70.9 ms 70.9 ms 50 
      SELECT "vulnerability_occurrences".*
        FROM "vulnerability_occurrences"  WHERE "vulnerability_occurrences"."uuid" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:120:in `block in perform'*/
      2 1521.2 ms 781.1 ms 760.6 ms 0 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34) AND (EXISTS (
          SELECT $35
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.uuid = vulnerability_feedback.finding_uuid::varchar
        ) OR EXISTS (
          SELECT $36
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.project_fingerprint = vulnerability_feedback.project_fingerprint::bytea
        ) OR EXISTS (
          SELECT $37
          FROM security_findings
          WHERE security_findings.uuid = vulnerability_feedback.finding_uuid
        )) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:120:in `block in perform'*/
      2 0.4 ms 0.2 ms 0.2 ms 68 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:126:in `block in perform'*/
      2 2453.5 ms 1273.0 ms 1226.7 ms 0 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47) AND (EXISTS (
          SELECT $48
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.uuid = vulnerability_feedback.finding_uuid::varchar
        ) OR EXISTS (
          SELECT $49
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.project_fingerprint = vulnerability_feedback.project_fingerprint::bytea
        ) OR EXISTS (
          SELECT $50
          FROM security_findings
          WHERE security_findings.uuid = vulnerability_feedback.finding_uuid
        )) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:120:in `block in perform'*/
      2 0.6 ms 0.3 ms 0.3 ms 94 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:126:in `block in perform'*/
      1 20.6 ms 20.6 ms 20.6 ms 8 
      SELECT "security_findings"."id", "security_findings"."scan_id", "security_findings"."scanner_id", "security_findings"."severity", "security_findings"."confidence", "security_findings"."project_fingerprint", "security_findings"."deduplicated", "security_findings"."uuid", "security_findings"."overridden_uuid", "security_findings"."finding_data"  FROM "security_findings"  WHERE "security_findings"."uuid" = $1 /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:120:in `block in perform'*/
      6 12.6 ms 4.6 ms 2.1 ms 6 
      SELECT "security_scans".*
        FROM "security_scans"  WHERE "security_scans"."id" = $1 /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/app/models/security/finding.rb:129:in `latest_by_uuid'*/
      6 5.9 ms 2.8 ms 1.0 ms 6 
      SELECT "projects".*
        FROM "projects"  WHERE "projects"."id" = $1
        LIMIT $2 /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:189:in `block (2 levels) in handle_security_findings_only_scenario'*/
      6 3.7 ms 2.1 ms 0.6 ms 6 
      SELECT "users"."id", "users"."email", "users"."encrypted_password", "users"."reset_password_token", "users"."reset_password_sent_at", "users"."remember_created_at", "users"."sign_in_count", "users"."current_sign_in_at", "users"."last_sign_in_at", "users"."current_sign_in_ip", "users"."last_sign_in_ip", "users"."created_at", "users"."updated_at", "users"."name", "users"."admin", "users"."projects_limit", "users"."failed_attempts", "users"."locked_at", "users"."username", "users"."can_create_group", "users"."can_create_team", "users"."state", "users"."color_scheme_id", "users"."password_expires_at", "users"."created_by_id", "users"."avatar", "users"."confirmation_token", "users"."confirmed_at", "users"."confirmation_sent_at", "users"."unconfirmed_email", "users"."hide_no_ssh_key", "users"."last_credential_check_at", "users"."admin_email_unsubscribed_at", "users"."notification_email", "users"."hide_no_password", "users"."password_automatically_set", "users"."public_email", "users"."encrypted_otp_secret", "users"."encrypted_otp_secret_iv", "users"."encrypted_otp_secret_salt", "users"."otp_required_for_login", "users"."otp_backup_codes", "users"."dashboard", "users"."project_view", "users"."consumed_timestep", "users"."layout", "users"."hide_project_limit", "users"."unlock_token", "users"."note", "users"."otp_grace_period_started_at", "users"."external", "users"."incoming_email_token", "users"."auditor", "users"."require_two_factor_authentication_from_group", "users"."two_factor_grace_period", "users"."notified_of_own_activity", "users"."last_activity_on", "users"."preferred_language", "users"."email_opted_in", "users"."email_opted_in_ip", "users"."email_opted_in_source_id", "users"."email_opted_in_at", "users"."theme_id", "users"."accepted_term_id", "users"."feed_token", "users"."private_profile", "users"."roadmap_layout", "users"."include_private_contributions", "users"."commit_email", "users"."group_view", "users"."managing_group_id", "users"."first_name", "users"."last_name", "users"."static_object_token", "users"."role", "users"."user_type", "users"."static_object_token_encrypted", "users"."otp_secret_expires_at", "users"."onboarding_in_progress"  FROM "users"  WHERE "users"."id" = $1
        LIMIT $2 /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:190:in `block (2 levels) in handle_security_findings_only_scenario'*/
      6 2.9 ms 1.0 ms 0.5 ms 6 
      SELECT "security_findings".*
        FROM "security_findings"  WHERE "security_findings"."uuid" = $1
        ORDER BY "security_findings"."scan_id" DESC
        LIMIT $2 /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/app/models/security/finding.rb:129:in `latest_by_uuid'*/
      1 0.0 ms 0.0 ms 0.0 ms 0 
      SELECT "vulnerability_occurrences".*
        FROM "vulnerability_occurrences"  WHERE "vulnerability_occurrences"."uuid" = $1 /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:120:in `block in perform'*/
      1 323.7 ms 323.7 ms 323.7 ms 0 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) AND (EXISTS (
          SELECT $15
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.uuid = vulnerability_feedback.finding_uuid::varchar
        ) OR EXISTS (
          SELECT $16
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.project_fingerprint = vulnerability_feedback.project_fingerprint::bytea
        ) OR EXISTS (
          SELECT $17
          FROM security_findings
          WHERE security_findings.uuid = vulnerability_feedback.finding_uuid
        )) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:120:in `block in perform'*/
      1 0.1 ms 0.1 ms 0.1 ms 14 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:126:in `block in perform'*/
      1 170.2 ms 170.2 ms 170.2 ms 34 
      SELECT "security_findings"."id", "security_findings"."scan_id", "security_findings"."scanner_id", "security_findings"."severity", "security_findings"."confidence", "security_findings"."project_fingerprint", "security_findings"."deduplicated", "security_findings"."uuid", "security_findings"."overridden_uuid", "security_findings"."finding_data"  FROM "security_findings"  WHERE "security_findings"."uuid" IN ($1, $2, $3, $4, $5) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:120:in `block in perform'*/
      1 0.1 ms 0.1 ms 0.1 ms 0 
      SELECT "vulnerability_occurrences".*
        FROM "vulnerability_occurrences"  WHERE "vulnerability_occurrences"."uuid" IN ($1, $2, $3, $4, $5) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:120:in `block in perform'*/
      1 743.1 ms 743.1 ms 743.1 ms 0 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19) AND (EXISTS (
          SELECT $20
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.uuid = vulnerability_feedback.finding_uuid::varchar
        ) OR EXISTS (
          SELECT $21
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.project_fingerprint = vulnerability_feedback.project_fingerprint::bytea
        ) OR EXISTS (
          SELECT $22
          FROM security_findings
          WHERE security_findings.uuid = vulnerability_feedback.finding_uuid
        )) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:120:in `block in perform'*/
      1 0.1 ms 0.1 ms 0.1 ms 19 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:126:in `block in perform'*/
      1 733.2 ms 733.2 ms 733.2 ms 0 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32) AND (EXISTS (
          SELECT $33
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.uuid = vulnerability_feedback.finding_uuid::varchar
        ) OR EXISTS (
          SELECT $34
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.project_fingerprint = vulnerability_feedback.project_fingerprint::bytea
        ) OR EXISTS (
          SELECT $35
          FROM security_findings
          WHERE security_findings.uuid = vulnerability_feedback.finding_uuid
        )) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:120:in `block in perform'*/
      1 0.2 ms 0.2 ms 0.2 ms 32 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:126:in `block in perform'*/
      1 388.4 ms 388.4 ms 388.4 ms 0 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16) AND (EXISTS (
          SELECT $17
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.uuid = vulnerability_feedback.finding_uuid::varchar
        ) OR EXISTS (
          SELECT $18
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.project_fingerprint = vulnerability_feedback.project_fingerprint::bytea
        ) OR EXISTS (
          SELECT $19
          FROM security_findings
          WHERE security_findings.uuid = vulnerability_feedback.finding_uuid
        )) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:120:in `block in perform'*/
      1 0.1 ms 0.1 ms 0.1 ms 16 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:126:in `block in perform'*/
      1 1852.9 ms 1852.9 ms 1852.9 ms 0 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48) AND (EXISTS (
          SELECT $49
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.uuid = vulnerability_feedback.finding_uuid::varchar
        ) OR EXISTS (
          SELECT $50
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.project_fingerprint = vulnerability_feedback.project_fingerprint::bytea
        ) OR EXISTS (
          SELECT $51
          FROM security_findings
          WHERE security_findings.uuid = vulnerability_feedback.finding_uuid
        )) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:120:in `block in perform'*/
      1 0.3 ms 0.3 ms 0.3 ms 48 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:126:in `block in perform'*/
      1 18.6 ms 18.6 ms 18.6 ms 0 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44) AND (EXISTS (
          SELECT $45
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.uuid = vulnerability_feedback.finding_uuid::varchar
        ) OR EXISTS (
          SELECT $46
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.project_fingerprint = vulnerability_feedback.project_fingerprint::bytea
        ) OR EXISTS (
          SELECT $47
          FROM security_findings
          WHERE security_findings.uuid = vulnerability_feedback.finding_uuid
        )) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:120:in `block in perform'*/
      1 0.2 ms 0.2 ms 0.2 ms 44 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:126:in `block in perform'*/
      1 60.7 ms 60.7 ms 60.7 ms 0 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" IN ($1, $2, $3) AND (EXISTS (
          SELECT $4
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.uuid = vulnerability_feedback.finding_uuid::varchar
        ) OR EXISTS (
          SELECT $5
          FROM vulnerability_occurrences
          WHERE vulnerability_occurrences.project_fingerprint = vulnerability_feedback.project_fingerprint::bytea
        ) OR EXISTS (
          SELECT $6
          FROM security_findings
          WHERE security_findings.uuid = vulnerability_feedback.finding_uuid
        )) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:120:in `block in perform'*/
      1 0.0 ms 0.0 ms 0.0 ms 3 
      SELECT "vulnerability_feedback".*
        FROM "vulnerability_feedback"  WHERE "vulnerability_feedback"."id" IN ($1, $2, $3) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/ee/lib/ee/gitlab/background_migration/migrate_vulnerabilities_feedback_to_vulnerabilities_state_transition.rb:126:in `block in perform'*/
      Histogram of batch runtimes for MigrateVulnerabilitiesFeedbackToVulnerabilitiesStateTransition
      Batch Runtime Count
      0 seconds - 10 seconds 82
      10 seconds - 1 minute 20
      1 minute - 2 minutes 0
      2 minutes - 3 minutes 0
      3 minutes - 5 minutes 0
      5 minutes + 0
      Histogram across all sampled batches of MigrateVulnerabilitiesFeedbackToVulnerabilitiesStateTransition
      Query Runtime Count
      0 seconds - 0.1 seconds 6479
      0.1 seconds - 0.5 seconds 64
      0.5 seconds - 1 second 8
      1 second - 2 seconds 75
      2 seconds - 5 seconds 17
      5 seconds + 1

      Background Migration: NullifyCreatorIdColumnOfOrphanedProjects

      Sampled 204 batches

      Calls Total Time Max Time Mean Time Rows Query
      126 67114.8 ms 2668.4 ms 532.7 ms 380 
      UPDATE "projects"  SET "creator_id" = $1
        WHERE "projects"."id" IN (
          SELECT "projects"."id"    FROM "projects"    LEFT OUTER JOIN users ON users.id = projects.creator_id
          WHERE "projects"."id" BETWEEN $2 AND $3 AND "projects"."creator_id" IS NOT NULL AND "users"."id" IS NULL AND "projects"."id" >= $4
        ) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/lib/gitlab/background_migration/nullify_creator_id_column_of_orphaned_projects.rb:19:in `block in perform'*/
      204 126481.5 ms 2518.3 ms 620.0 ms 126 
      SELECT "projects"."id"  FROM "projects"  LEFT OUTER JOIN users ON users.id = projects.creator_id
        WHERE "projects"."id" BETWEEN $1 AND $2 AND "projects"."creator_id" IS NOT NULL AND "users"."id" IS NULL
        ORDER BY "projects"."id" ASC
        LIMIT $3 /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/app/models/concerns/each_batch.rb:62:in `each_batch'*/
      126 64742.7 ms 2253.4 ms 513.8 ms 0 
      SELECT "projects"."id"  FROM "projects"  LEFT OUTER JOIN users ON users.id = projects.creator_id
        WHERE "projects"."id" BETWEEN $1 AND $2 AND "projects"."creator_id" IS NOT NULL AND "users"."id" IS NULL AND "projects"."id" >= $3
        ORDER BY "projects"."id" ASC
        LIMIT $4
        OFFSET $5 /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
      406 51.5 ms 1.0 ms 0.1 ms 406 
      INSERT INTO "batched_background_migration_job_transition_logs" ("batched_background_migration_job_id", "created_at", "updated_at", "previous_status", "next_status") VALUES ($1, $2, $3, $4, $5) RETURNING "id" /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/lib/gitlab/database.rb:342:in `block in transaction'*/
      204 28.8 ms 3.1 ms 0.1 ms 204 
      UPDATE "batched_background_migration_jobs"  SET "updated_at" = $1, "finished_at" = $2, "status" = $3, "metrics" = $4
        WHERE "batched_background_migration_jobs"."id" = $5 /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/lib/gitlab/database.rb:342:in `block in transaction'*/
      204 33.4 ms 1.5 ms 0.2 ms 204 
      SELECT SUM("batched_background_migration_jobs"."batch_size")
        FROM "batched_background_migration_jobs"  WHERE "batched_background_migration_jobs"."batched_background_migration_id" = $1 AND ("batched_background_migration_jobs"."status" IN ($2)) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/lib/gitlab/database/background_migration/batched_migration.rb:189:in `migrated_tuple_count'*/
      406 19.0 ms 2.1 ms 0.0 ms 406 
      SELECT "batched_background_migration_jobs".*
        FROM "batched_background_migration_jobs"  WHERE "batched_background_migration_jobs"."id" = $1
        LIMIT $2 /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/lib/gitlab/database.rb:342:in `block in transaction'*/
      203 55.3 ms 12.6 ms 0.3 ms 203 
      UPDATE "batched_background_migration_jobs"  SET "updated_at" = $1, "started_at" = $2, "status" = $3, "attempts" = $4
        WHERE "batched_background_migration_jobs"."id" = $5 /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/lib/gitlab/database.rb:342:in `block in transaction'*/
      2 3.0 ms 2.8 ms 1.5 ms 2 
      INSERT INTO "batched_background_migration_job_transition_logs" ("batched_background_migration_job_id", "created_at", "updated_at", "previous_status", "next_status") VALUES ($1, $2, $3, $4, $5) RETURNING "id" /*application:test,db_config_name:main,line:/lib/gitlab/database.rb:342:in `block in transaction'*/
      1 1.0 ms 1.0 ms 1.0 ms 1 
      UPDATE "batched_background_migration_jobs"  SET "updated_at" = $1, "started_at" = $2, "status" = $3, "attempts" = $4
        WHERE "batched_background_migration_jobs"."id" = $5 /*application:test,db_config_name:main,line:/lib/gitlab/database.rb:342:in `block in transaction'*/
      2 0.1 ms 0.0 ms 0.0 ms 2 
      SELECT "batched_background_migration_jobs".*
        FROM "batched_background_migration_jobs"  WHERE "batched_background_migration_jobs"."id" = $1
        LIMIT $2 /*application:test,db_config_name:main,line:/lib/gitlab/database.rb:342:in `block in transaction'*/
      Histogram of batch runtimes for NullifyCreatorIdColumnOfOrphanedProjects
      Batch Runtime Count
      0 seconds - 10 seconds 204
      10 seconds - 1 minute 0
      1 minute - 2 minutes 0
      2 minutes - 3 minutes 0
      3 minutes - 5 minutes 0
      5 minutes + 0
      Histogram across all sampled batches of NullifyCreatorIdColumnOfOrphanedProjects
      Query Runtime Count
      0 seconds - 0.1 seconds 1473
      0.1 seconds - 0.5 seconds 168
      0.5 seconds - 1 second 164
      1 second - 2 seconds 64
      2 seconds - 5 seconds 15
      5 seconds + 0

      Background Migration: CopyColumnUsingBackgroundMigrationJob

      Sampled 380 batches

      Calls Total Time Max Time Mean Time Rows Query
      380 259.5 ms 31.9 ms 0.7 ms 32300 
      UPDATE "vulnerability_user_mentions"  SET "note_id_convert_to_bigint" = "note_id"  WHERE "vulnerability_user_mentions"."id" BETWEEN $1 AND $2 AND "vulnerability_user_mentions"."id" >= $3 /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/lib/gitlab/background_migration/copy_column_using_background_migration_job.rb:25:in `block in perform'*/
      760 96.9 ms 1.5 ms 0.1 ms 760 
      INSERT INTO "batched_background_migration_job_transition_logs" ("batched_background_migration_job_id", "created_at", "updated_at", "previous_status", "next_status") VALUES ($1, $2, $3, $4, $5) RETURNING "id" /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/lib/gitlab/database.rb:342:in `block in transaction'*/
      380 72.3 ms 0.4 ms 0.2 ms 380 
      SELECT SUM("batched_background_migration_jobs"."batch_size")
        FROM "batched_background_migration_jobs"  WHERE "batched_background_migration_jobs"."batched_background_migration_id" = $1 AND ("batched_background_migration_jobs"."status" IN ($2)) /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/lib/gitlab/database/background_migration/batched_migration.rb:189:in `migrated_tuple_count'*/
      380 38.8 ms 0.8 ms 0.1 ms 380 
      UPDATE "batched_background_migration_jobs"  SET "updated_at" = $1, "finished_at" = $2, "status" = $3, "metrics" = $4
        WHERE "batched_background_migration_jobs"."id" = $5 /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/lib/gitlab/database.rb:342:in `block in transaction'*/
      380 60.2 ms 2.2 ms 0.2 ms 380 
      UPDATE "batched_background_migration_jobs"  SET "updated_at" = $1, "started_at" = $2, "status" = $3, "attempts" = $4
        WHERE "batched_background_migration_jobs"."id" = $5 /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/lib/gitlab/database.rb:342:in `block in transaction'*/
      760 30.1 ms 0.1 ms 0.0 ms 760 
      SELECT "batched_background_migration_jobs".*
        FROM "batched_background_migration_jobs"  WHERE "batched_background_migration_jobs"."id" = $1
        LIMIT $2 /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/lib/gitlab/database.rb:342:in `block in transaction'*/
      380 24.6 ms 0.6 ms 0.1 ms 0 
      SELECT "vulnerability_user_mentions"."id"  FROM "vulnerability_user_mentions"  WHERE "vulnerability_user_mentions"."id" BETWEEN $1 AND $2 AND "vulnerability_user_mentions"."id" >= $3
        ORDER BY "vulnerability_user_mentions"."id" ASC
        LIMIT $4
        OFFSET $5 /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/app/models/concerns/each_batch.rb:81:in `block in each_batch'*/
      380 6.0 ms 0.0 ms 0.0 ms 380 
      SELECT "vulnerability_user_mentions"."id"  FROM "vulnerability_user_mentions"  WHERE "vulnerability_user_mentions"."id" BETWEEN $1 AND $2
        ORDER BY "vulnerability_user_mentions"."id" ASC
        LIMIT $3 /*application:test,correlation_id:50252527810f702b3e791c2bd52190b4,db_config_name:main,line:/app/models/concerns/each_batch.rb:62:in `each_batch'*/
      Histogram of batch runtimes for CopyColumnUsingBackgroundMigrationJob
      Batch Runtime Count
      0 seconds - 10 seconds 380
      10 seconds - 1 minute 0
      1 minute - 2 minutes 0
      2 minutes - 3 minutes 0
      3 minutes - 5 minutes 0
      5 minutes + 0
      Histogram across all sampled batches of CopyColumnUsingBackgroundMigrationJob
      Query Runtime Count
      0 seconds - 0.1 seconds 3787
      0.1 seconds - 0.5 seconds 13
      0.5 seconds - 1 second 0
      1 second - 2 seconds 0
      2 seconds - 5 seconds 0
      5 seconds + 0
      Other migrations pending on GitLab.com
      Migration Type Total runtime Result DB size change
      20230119123256 - AddFkIndexToCiResourcesOnPartitionIdAndBuildId Post deploy 2.0 s :white_check_mark: +8.00 KiB
      20230119123257 - AddFkToCiResourcesOnPartitionIdAndBuildId Post deploy 1.8 s :white_check_mark: +0.00 B
      20230119123258 - ValidateFkOnCiResourcesPartitionIdAndBuildId Post deploy 1.6 s :white_check_mark: +0.00 B
      20230119123259 - RemoveFkToCiBuildsCiResourcesOnBuildId Post deploy 1.8 s :white_check_mark: +0.00 B
      20230130073109 - NullifyCreatorIdOfOrphanedProjects Post deploy 2.0 s :white_check_mark: +0.00 B
      20230130103957 - AddFkIndexToCiBuildNeedsOnPartitionIdAndBuildId Post deploy 1.7 s :white_check_mark: +0.00 B
      20230130103958 - AddFkToCiBuildNeedsOnPartitionIdAndBuildId Post deploy 1.7 s :white_check_mark: +0.00 B
      20230201171450 - FinalizeBackfillEnvironmentTierMigration Post deploy 1.5 s :white_check_mark: +0.00 B
      20230203122602 - ScheduleVulnerabilitiesFeedbackMigration3 Post deploy 2.6 s :warning: +0.00 B

      Clone Details

      Clone ID Clone Created At Clone Data Timestamp Expected Removal Time
      database-testing-1714316-9191662-main 2023-02-07T01:35:27Z 2023-02-07T00:10:36Z 2023-02-07 14:10:27 +0000
      database-testing-1714316-9191662-ci 2023-02-07T01:35:27Z 2023-02-07T00:45:03Z 2023-02-07 14:10:27 +0000

      Artifacts

      Brought to you by gitlab-org/database-team/gitlab-com-database-testing. Epic

      Database migrations (on the ci database)

      Migrations included in this change have been executed on gitlab.com data for testing purposes. For details, please see the migration testing pipeline (limited access).

      Migration Type Total runtime Result DB size change
      20230207012217 - InitializeConversionOfVulnerabilityUserMentionsNoteIdToBigint Regular 3.0 s :white_check_mark: +0.00 B
      20230207012238 - BackfillVulnerabilityUserMentionsNoteIdForBigintConversion Post deploy 1.9 s :white_check_mark: +0.00 B
      Runtime Histogram for all migrations
      Query Runtime Count
      0 seconds - 0.01 seconds 0
      0.01 seconds - 0.1 seconds 6
      0.1 seconds - 1 second 0
      1 second - 5 seconds 0
      5 seconds - 15 seconds 0
      15 seconds - 5 minutes 0
      5 minutes + 0

      Migration: 20230207012217 - InitializeConversionOfVulnerabilityUserMentionsNoteIdToBigint

      • Type: Regular
      • Duration: 3.0 s
      • Database size change: +0.00 B
      Calls Total Time Max Time Mean Time Rows Query
      1 35.3 ms 35.3 ms 35.3 ms 0 
      CREATE OR REPLACE FUNCTION trigger_0e214b8a14f2() RETURNS trigger AS $1 LANGUAGE $2 VOLATILE /*application:test,db_config_name:ci,line:/lib/gitlab/database/unidirectional_copy_trigger.rb:22:in `create'*/
      1 35.2 ms 35.2 ms 35.2 ms 0 
      CREATE TRIGGER trigger_0e214b8a14f2 BEFORE INSERT OR UPDATE ON "vulnerability_user_mentions" FOR EACH ROW EXECUTE FUNCTION trigger_0e214b8a14f2() /*application:test,db_config_name:ci,line:/lib/gitlab/database/unidirectional_copy_trigger.rb:40:in `create'*/
      1 6.8 ms 6.8 ms 6.8 ms 0 
      ALTER TABLE "vulnerability_user_mentions" ADD "note_id_convert_to_bigint" bigint DEFAULT NULL /*application:test,db_config_name:ci,line:/lib/gitlab/database/migration_helpers.rb:1217:in `block (2 levels) in create_temporary_columns_and_triggers'*/
      1 0.1 ms 0.1 ms 0.1 ms 0 
      DROP TRIGGER IF EXISTS trigger_0e214b8a14f2 ON "vulnerability_user_mentions" /*application:test,db_config_name:ci,line:/lib/gitlab/database/unidirectional_copy_trigger.rb:35:in `create'*/
      1 0.0 ms 0.0 ms 0.0 ms 1 
      SELECT has_table_privilege($1, $2) /*application:test,db_config_name:ci,line:/lib/gitlab/database/grant.rb:17:in `create_and_execute_trigger?'*/
      1 0.0 ms 0.0 ms 0.0 ms 1 
      SELECT $1::regtype::oid
      Histogram for InitializeConversionOfVulnerabilityUserMentionsNoteIdToBigint
      Query Runtime Count
      0 seconds - 0.01 seconds 0
      0.01 seconds - 0.1 seconds 6
      0.1 seconds - 1 second 0
      1 second - 5 seconds 0
      5 seconds - 15 seconds 0
      15 seconds - 5 minutes 0
      5 minutes + 0

      Migration: 20230207012238 - BackfillVulnerabilityUserMentionsNoteIdForBigintConversion

      • Type: Post deploy
      • Duration: 1.9 s
      • Database size change: +0.00 B

      No histogram available for visualization

      Background migrations

      Other migrations pending on GitLab.com
      Migration Type Total runtime Result DB size change
      20230119123256 - AddFkIndexToCiResourcesOnPartitionIdAndBuildId Post deploy 7.3 s :white_check_mark: +53.99 MiB
      20230119123257 - AddFkToCiResourcesOnPartitionIdAndBuildId Post deploy 2.5 s :white_check_mark: +0.00 B
      20230119123258 - ValidateFkOnCiResourcesPartitionIdAndBuildId Post deploy 4.3 s :warning: +0.00 B
      20230119123259 - RemoveFkToCiBuildsCiResourcesOnBuildId Post deploy 2.4 s :white_check_mark: +0.00 B
      20230130073109 - NullifyCreatorIdOfOrphanedProjects Post deploy 1.9 s :white_check_mark: +0.00 B
      20230130103957 - AddFkIndexToCiBuildNeedsOnPartitionIdAndBuildId Post deploy 2.2 s :white_check_mark: +0.00 B
      20230130103958 - AddFkToCiBuildNeedsOnPartitionIdAndBuildId Post deploy 2.3 s :white_check_mark: +0.00 B
      20230201171450 - FinalizeBackfillEnvironmentTierMigration Post deploy 1.9 s :white_check_mark: +0.00 B
      20230203122602 - ScheduleVulnerabilitiesFeedbackMigration3 Post deploy 1.9 s :white_check_mark: +0.00 B

      Clone Details

      Clone ID Clone Created At Clone Data Timestamp Expected Removal Time
      database-testing-1714316-9191662-main 2023-02-07T01:35:27Z 2023-02-07T00:10:36Z 2023-02-07 14:10:27 +0000
      database-testing-1714316-9191662-ci 2023-02-07T01:35:27Z 2023-02-07T00:45:03Z 2023-02-07 14:10:27 +0000

      Artifacts

      Brought to you by gitlab-org/database-team/gitlab-com-database-testing. Epic

      Edited by Ghost User
    • Krasimir Angelov mentioned in issue #389306 (closed)

      mentioned in issue #389306 (closed)

    • Krasimir Angelov
  • Krasimir Angelov added workflowin review label and removed workflowin dev label

    added workflowin review label and removed workflowin dev label

  • Krasimir Angelov requested review from @terrichu

    requested review from @terrichu

  • Krasimir Angelov requested review from @stomlinson

    requested review from @stomlinson

  • Terri Chu approved this merge request

    approved this merge request

  • Terri Chu removed review request for @terrichu

    removed review request for @terrichu

  • 🤖 GitLab Bot 🤖
    🤖 GitLab Bot 🤖 @gitlab-bot
    Maintainer

    :wave: @terrichu, thanks for approving this merge request.

    This is the first time the merge request is approved. To ensure full test coverage, a new pipeline will be started shortly.

    For more info, please refer to the following links:

  • 🤖 GitLab Bot 🤖 added pipeline:mr-approved label

    added pipeline:mr-approved label

  • Krasimir Angelov added 493 commits

    added 493 commits

    • 2c964d89...f71ca83e - 492 commits from branch master
    • f9544f8f - Initialize conversion of vulnerability_user_mentions.note_id to bigint

    Compare with previous version

  • Krasimir Angelov added 183 commits

    added 183 commits

    • f9544f8f...35659396 - 182 commits from branch master
    • b08dda71 - Initialize conversion of vulnerability_user_mentions.note_id to bigint

    Compare with previous version

  • Krasimir Angelov added 408 commits

    added 408 commits

    • b08dda71...f5e7ed27 - 407 commits from branch master
    • ddd46d7c - Initialize conversion of vulnerability_user_mentions.note_id to bigint

    Compare with previous version

  • Loading
  • Loading
  • Loading
  • Loading
  • Loading
  • Loading
  • Loading
  • Loading
  • Loading
  • Loading
    • Please register or sign in to reply