rspec background_migration pg14 9/10
Passed Started
by
@gitlab-bot

🤖 GitLab Bot 🤖
1Running with gitlab-runner 17.0.0~pre.88.g761ae5dd (761ae5dd)2 on green-1.private.runners-manager.gitlab.com/gitlab.com/gitlab-org 4bq1s9yM, system ID: s_9d15f3e4e7ae3 feature flags: FF_NETWORK_PER_BUILD:true4Resolving secrets6Using Docker executor with image registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bookworm-ruby-3.1.5-golang-1.22-rust-1.73-node-20.12-postgresql-14:rubygems-3.4-git-2.36-lfs-2.9-chrome-123-yarn-1.22-graphicsmagick-1.3.36 ...7Starting service registry.gitlab.com/gitlab-org/gitlab-build-images:postgres-14-pgvector-0.4.1 ...8Authenticating with credentials from job payload (GitLab Registry)9Pulling docker image registry.gitlab.com/gitlab-org/gitlab-build-images:postgres-14-pgvector-0.4.1 ...10Using docker image sha256:82f132c22567f8ce17cc132c14b2f9aa3eaf9bb5424d91c2d966912433f0257d for registry.gitlab.com/gitlab-org/gitlab-build-images:postgres-14-pgvector-0.4.1 with digest registry.gitlab.com/gitlab-org/gitlab-build-images@sha256:c55e1364ee4327b244a9cfa1750f19feea14fc774eaf792b725967d146eb45f5 ...11WARNING: Service registry.gitlab.com/gitlab-org/gitlab-build-images:redis-cluster-6.2.12 is already created. Ignoring.12WARNING: Service registry.gitlab.com/gitlab-org/gitlab-build-images:redis-cluster-6.2.12 is already created. Ignoring.13Starting service registry.gitlab.com/gitlab-org/gitlab-build-images:redis-cluster-6.2.12 ...14Authenticating with credentials from job payload (GitLab Registry)15Pulling docker image registry.gitlab.com/gitlab-org/gitlab-build-images:redis-cluster-6.2.12 ...16Using docker image sha256:5c5ba5b83d6c60cb0b225bd670b7a43be8c238cc72347d24af57e5027c3648f3 for registry.gitlab.com/gitlab-org/gitlab-build-images:redis-cluster-6.2.12 with digest registry.gitlab.com/gitlab-org/gitlab-build-images@sha256:46aceab84c42d0e819c8e7940f2f98ce9e184785cd7b22d95872024a35f52407 ...17Starting service redis:6.2-alpine ...18Pulling docker image redis:6.2-alpine ...19Using docker image sha256:36c1d3cfe18f4b12d4640576f7048068acbfc3625027b6bbb46bba0e31b11831 for redis:6.2-alpine with digest redis@sha256:e3b17ba9479deec4b7d1eeec1548a253acc5374d68d3b27937fcfe4df8d18c7e ...20Waiting for services to be up and running (timeout 30 seconds)...21Authenticating with credentials from job payload (GitLab Registry)22Pulling docker image registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bookworm-ruby-3.1.5-golang-1.22-rust-1.73-node-20.12-postgresql-14:rubygems-3.4-git-2.36-lfs-2.9-chrome-123-yarn-1.22-graphicsmagick-1.3.36 ...23Using docker image sha256:b26253b493531cada33f45ef568f38c50a310442d05c39f517656e0f7d305dc7 for registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bookworm-ruby-3.1.5-golang-1.22-rust-1.73-node-20.12-postgresql-14:rubygems-3.4-git-2.36-lfs-2.9-chrome-123-yarn-1.22-graphicsmagick-1.3.36 with digest registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bookworm-ruby-3.1.5-golang-1.22-rust-1.73-node-20.12-postgresql-14@sha256:543339542a02edc250c2c0424c5077b673f1fca2877024fdc5fb670eff44f8cf ...25Running on runner-4bq1s9ym-project-278964-concurrent-0 via runner-4bq1s9ym-private-1722413270-5a61a9cd...27Skipping Git repository setup28Skipping Git checkout29Skipping Git submodules setup31Checking cache for ruby-gems-debian-bookworm-ruby-3.1.5-17...32Downloading cache from https://storage.googleapis.com/gitlab-com-runners-cache/project/278964/ruby-gems-debian-bookworm-ruby-3.1.5-17 33Successfully extracted cache35Downloading artifacts for clone-gitlab-repo (7471344368)...36Downloading artifacts from coordinator... ok host=storage.googleapis.com id=7471344368 responseStatus=200 OK token=glcbt-6637WARNING: Part of .git directory is on the list of files to extract 38WARNING: This may introduce unexpected problems 39Downloading artifacts for compile-test-assets (7471344747)...40Downloading artifacts from coordinator... ok host=storage.googleapis.com id=7471344747 responseStatus=200 OK token=glcbt-6641Downloading artifacts for retrieve-tests-metadata (7471344898)...42Downloading artifacts from coordinator... ok host=storage.googleapis.com id=7471344898 responseStatus=200 OK token=glcbt-6643Downloading artifacts for setup-test-env (7471344810)...44Downloading artifacts from coordinator... ok host=storage.googleapis.com id=7471344810 responseStatus=200 OK token=glcbt-66 45 Executing "step_script" stage of the job script 46Using docker image sha256:b26253b493531cada33f45ef568f38c50a310442d05c39f517656e0f7d305dc7 for registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bookworm-ruby-3.1.5-golang-1.22-rust-1.73-node-20.12-postgresql-14:rubygems-3.4-git-2.36-lfs-2.9-chrome-123-yarn-1.22-graphicsmagick-1.3.36 with digest registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bookworm-ruby-3.1.5-golang-1.22-rust-1.73-node-20.12-postgresql-14@sha256:543339542a02edc250c2c0424c5077b673f1fca2877024fdc5fb670eff44f8cf ...47$ echo $FOSS_ONLY48$ [ "$FOSS_ONLY" = "1" ] && rm -rf ee/ qa/spec/ee/ qa/qa/specs/features/ee/ qa/qa/ee/ qa/qa/ee.rb49$ export GOPATH=$CI_PROJECT_DIR/.go50$ mkdir -p $GOPATH51$ source scripts/utils.sh52$ source scripts/prepare_build.sh82Using decomposed database config (config/database.yml.decomposed-postgresql)83Geo DB won't be set up.84Embedding DB won't be set up.96$ source ./scripts/rspec_helpers.sh97$ run_timed_command "gem install knapsack --no-document"98$ gem install knapsack --no-document99Successfully installed knapsack-4.0.01001 gem installed101==> 'gem install knapsack --no-document' succeeded in 2 seconds.102$ section_start "gitaly-test-spawn" "Spawning Gitaly"; scripts/gitaly-test-spawn; section_end "gitaly-test-spawn"107$ export RSPEC_SKIPPED_TESTS_REPORT_PATH="rspec/skipped_tests-${CI_JOB_ID}.txt"108$ export RSPEC_RETRIED_TESTS_REPORT_PATH="rspec/retried_tests-${CI_JOB_ID}.txt"109$ tooling/bin/create_job_metrics_file || true110[job-metrics] Creating the job metrics file for the CI/CD job.111$ rspec_section rspec_parallelized_job "--fail-fast=${RSPEC_FAIL_FAST_THRESHOLD} --tag ~quarantine --tag ~zoekt --tag ~click_house"113[10:14:28] Starting rspec_parallelized_job114RETRY_FAILED_TESTS_IN_NEW_PROCESS: true115KNAPSACK_GENERATE_REPORT: true116FLAKY_RSPEC_GENERATE_REPORT: true117KNAPSACK_TEST_FILE_PATTERN: spec/{lib/gitlab/background_migration,lib/ee/gitlab/background_migration}{,/**/}*_spec.rb118KNAPSACK_LOG_LEVEL: debug119KNAPSACK_REPORT_PATH: knapsack/rspec_background_migration_pg14_9_10_278964_report.json120FLAKY_RSPEC_SUITE_REPORT_PATH: rspec/flaky/report-suite.json121FLAKY_RSPEC_REPORT_PATH: rspec/flaky/all_rspec_background_migration_pg14_9_10_278964_report.json122NEW_FLAKY_RSPEC_REPORT_PATH: rspec/flaky/new_rspec_background_migration_pg14_9_10_278964_report.json123RSPEC_SKIPPED_TESTS_REPORT_PATH: rspec/skipped_tests-7471345492.txt124CRYSTALBALL: true125RSPEC_TESTS_MAPPING_ENABLED: 126RSPEC_TESTS_FILTER_FILE: 127Shell set options (set -o) enabled:128braceexpand on129hashall on130interactive-comments on131pipefail on132Knapsack report generator started!133warning: parser/current is loading parser/ruby31, which recognizes 3.1.6-compliant syntax, but you are running 3.1.5.135Run options: exclude {:quarantine=>true, :zoekt=>true, :click_house=>true}136# [RSpecRunTime] Starting RSpec timer...137[TEST PROF INFO] EventProf enabled (sql.active_record)138unknown OID 2249: failed to recognize type of 'pg_stat_file'. It will be treated as String.139unknown OID 2249: failed to recognize type of 'pg_stat_file'. It will be treated as String.140Test environment set up in 1.702248631 seconds141# [RSpecRunTime] Starting example group spec/lib/gitlab/background_migration/backfill_missing_ci_cd_settings_spec.rb. Expected to take 2 minutes 3.38 seconds.142Gitlab::BackgroundMigration::BackfillMissingCiCdSettings143 creates ci_cd_settings for projects without ci_cd_settings144 creates ci_cd_settings with default values145INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree146INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"147INFO: "ci_runner_machine_builds_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows148INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_101"149INFO: "ci_runner_machine_builds_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows150INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_102"151INFO: "ci_runner_machine_builds_102": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows152INFO: analyzing "public.p_ci_job_annotations" inheritance tree153INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"154INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows155INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_101"156INFO: "ci_job_annotations_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows157INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_102"158INFO: "ci_job_annotations_102": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows159INFO: analyzing "public.p_ci_builds_metadata" inheritance tree160INFO: analyzing "public.ci_builds_metadata"161INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows162INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_101"163INFO: "ci_builds_metadata_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows164INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_102"165INFO: "ci_builds_metadata_102": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows166INFO: analyzing "public.p_ci_builds" inheritance tree167INFO: analyzing "public.ci_builds"168INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows169INFO: analyzing "gitlab_partitions_dynamic.ci_builds_101"170INFO: "ci_builds_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows171INFO: analyzing "gitlab_partitions_dynamic.ci_builds_102"172INFO: "ci_builds_102": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows173I, [2024-07-31T10:18:23.276443 #326] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes174I, [2024-07-31T10:18:42.484531 #326] INFO -- : Database: 'main', Table: 'ci_job_token_group_scope_links': Lock Writes175INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree176INFO: analyzing "public.ci_pipeline_variables"177INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows178I, [2024-07-31T10:18:44.054304 #326] INFO -- : Database: 'main', Table: 'p_ci_pipeline_variables': Lock Writes179I, [2024-07-31T10:18:44.055446 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}180I, [2024-07-31T10:18:44.056263 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}181INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree182INFO: analyzing "public.ci_pipeline_variables"183INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows184INFO: analyzing "public.p_ci_job_artifacts" inheritance tree185INFO: analyzing "public.ci_job_artifacts"186INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows187I, [2024-07-31T10:18:49.943692 #326] INFO -- : Database: 'main', Table: 'p_ci_job_artifacts': Lock Writes188I, [2024-07-31T10:18:49.944901 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}189I, [2024-07-31T10:18:49.945722 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}190INFO: analyzing "public.p_ci_stages" inheritance tree191INFO: analyzing "public.ci_stages"192INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows193I, [2024-07-31T10:18:53.134694 #326] INFO -- : Database: 'main', Table: 'p_ci_stages': Lock Writes194I, [2024-07-31T10:18:53.135892 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}195I, [2024-07-31T10:18:53.137213 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}196I, [2024-07-31T10:18:54.270926 #326] INFO -- : Database: 'main', Table: 'p_ci_build_names': Lock Writes197I, [2024-07-31T10:19:00.496535 #326] INFO -- : Database: 'main', Table: 'p_ci_builds_execution_configs': Lock Writes198I, [2024-07-31T10:19:13.449069 #326] INFO -- : Database: 'main', Table: 'p_ci_build_sources': Lock Writes199I, [2024-07-31T10:19:13.450630 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}200I, [2024-07-31T10:19:13.451394 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}201I, [2024-07-31T10:19:24.591904 #326] INFO -- : Database: 'main', Table: 'p_ci_finished_pipeline_ch_sync_events': Lock Writes202I, [2024-07-31T10:19:30.958388 #326] INFO -- : Database: 'main', Table: 'p_ci_build_tags': Lock Writes203# [RSpecRunTime] Finishing example group spec/lib/gitlab/background_migration/backfill_missing_ci_cd_settings_spec.rb. It took 3 minutes 21.19 seconds. Expected to take 2 minutes 3.38 seconds.204# [RSpecRunTime] Starting example group spec/lib/gitlab/background_migration/legacy_upload_mover_spec.rb. Expected to take 1 minute 53.8 seconds.205Gitlab::BackgroundMigration::LegacyUploadMover206 when no note found for the upload207 behaves like legacy upload deletion208WARNING: All log messages before absl::InitializeLog() is called are written to STDERR209I0000 00:00:1722421183.716403 326 rb_grpc.c:331] GRPC_RUBY: grpc_ruby_init_threads g_bg_thread_init_done=0210 removes the upload record211# [RSpecRunTime] RSpec elapsed time: 3 minutes 34.11 seconds. Current RSS: ~1423M. Threads: 4. load average: 0.90 1.13 1.25 1/281 416212.213 when upload does not belong to a note214 does not remove the upload215# [RSpecRunTime] RSpec elapsed time: 3 minutes 40.1 seconds. Current RSS: ~1481M. Threads: 4. load average: 0.91 1.12 1.25 1/281 417216.217 when the upload move fails218 behaves like move error219 does not remove the upload file220# [RSpecRunTime] RSpec elapsed time: 3 minutes 46.92 seconds. Current RSS: ~1451M. Threads: 4. load average: 0.92 1.12 1.25 1/281 418221.222 when the upload is in local storage223 when the upload file does not exist on the filesystem224 behaves like legacy upload deletion225 removes the upload record226# [RSpecRunTime] RSpec elapsed time: 3 minutes 52.74 seconds. Current RSS: ~1444M. Threads: 4. load average: 1.01 1.13 1.25 1/281 419227.228 when an upload belongs to a legacy_diff_note229 when the file does not exist for the upload230 behaves like move error231 does not remove the upload file232# [RSpecRunTime] RSpec elapsed time: 3 minutes 58.84 seconds. Current RSS: ~1473M. Threads: 4. load average: 1.01 1.13 1.25 1/281 420233.234 when the file does not exist on expected path235 behaves like move error236 does not remove the upload file237# [RSpecRunTime] RSpec elapsed time: 4 minutes 4.7 seconds. Current RSS: ~1454M. Threads: 4. load average: 1.09 1.14 1.26 1/281 421238.239 when the file path does not include system/note/attachment240 behaves like move error241 does not remove the upload file242# [RSpecRunTime] RSpec elapsed time: 4 minutes 10.46 seconds. Current RSS: ~1443M. Threads: 4. load average: 0.99 1.12 1.25 1/281 422243.244 when the file move raises an error245 behaves like move error246 does not remove the upload file247# [RSpecRunTime] RSpec elapsed time: 4 minutes 16.24 seconds. Current RSS: ~1472M. Threads: 4. load average: 0.91 1.10 1.24 1/281 423248.249 when upload has mount_point nil250 behaves like migrates the file correctly251 creates a new upload record correctly, updates the legacy upload note so that it references the file in the markdown, removes the attachment from the note model, removes the file, moves legacy uploads to the correct location, removes the upload record252# [RSpecRunTime] RSpec elapsed time: 4 minutes 22.13 seconds. Current RSS: ~1446M. Threads: 4. load average: 1.00 1.12 1.25 1/281 424253.254 when the file can be handled correctly255 behaves like migrates the file correctly256 creates a new upload record correctly, updates the legacy upload note so that it references the file in the markdown, removes the attachment from the note model, removes the file, moves legacy uploads to the correct location, removes the upload record257# [RSpecRunTime] RSpec elapsed time: 4 minutes 28.2 seconds. Current RSS: ~1468M. Threads: 4. load average: 1.00 1.12 1.24 1/281 425258.259 when object storage is disabled for FileUploader260 when the file belongs to a legacy project261 behaves like migrates the file correctly262 creates a new upload record correctly, updates the legacy upload note so that it references the file in the markdown, removes the attachment from the note model, removes the file, moves legacy uploads to the correct location, removes the upload record263# [RSpecRunTime] RSpec elapsed time: 4 minutes 33.86 seconds. Current RSS: ~1447M. Threads: 4. load average: 1.00 1.12 1.24 1/281 426264.265 when the file belongs to a hashed project266 behaves like migrates the file correctly267 creates a new upload record correctly, updates the legacy upload note so that it references the file in the markdown, removes the attachment from the note model, removes the file, moves legacy uploads to the correct location, removes the upload record268# [RSpecRunTime] RSpec elapsed time: 4 minutes 39.7 seconds. Current RSS: ~1469M. Threads: 4. load average: 1.00 1.11 1.24 1/281 427269.270 when object storage is enabled for FileUploader271 when the file belongs to a legacy project272 behaves like migrates the file correctly273 creates a new upload record correctly, updates the legacy upload note so that it references the file in the markdown, removes the attachment from the note model, removes the file, moves legacy uploads to the correct location, removes the upload record274# [RSpecRunTime] RSpec elapsed time: 4 minutes 45.66 seconds. Current RSS: ~1441M. Threads: 4. load average: 1.00 1.11 1.24 1/281 428275.276 when the file belongs to a hashed project277 behaves like migrates the file correctly278 creates a new upload record correctly, updates the legacy upload note so that it references the file in the markdown, removes the attachment from the note model, removes the file, moves legacy uploads to the correct location, removes the upload record279# [RSpecRunTime] RSpec elapsed time: 4 minutes 51.39 seconds. Current RSS: ~1447M. Threads: 4. load average: 1.00 1.11 1.24 1/281 429280.281 when legacy uploads are stored in object storage282 when the upload file does not exist on the filesystem283 behaves like legacy upload deletion284 removes the upload record285# [RSpecRunTime] RSpec elapsed time: 4 minutes 57.14 seconds. Current RSS: ~1428M. Threads: 4. load average: 1.00 1.11 1.23 1/281 430286.287 when the file belongs to a legacy project288 behaves like migrates the file correctly289 creates a new upload record correctly, updates the legacy upload note so that it references the file in the markdown, removes the attachment from the note model, removes the file, moves legacy uploads to the correct location, removes the upload record290# [RSpecRunTime] RSpec elapsed time: 5 minutes 4.94 seconds. Current RSS: ~1425M. Threads: 4. load average: 1.00 1.10 1.23 1/281 431291.292 when the file belongs to a hashed project293 behaves like migrates the file correctly294 creates a new upload record correctly, updates the legacy upload note so that it references the file in the markdown, removes the attachment from the note model, removes the file, moves legacy uploads to the correct location, removes the upload record295# [RSpecRunTime] RSpec elapsed time: 5 minutes 10.64 seconds. Current RSS: ~1459M. Threads: 4. load average: 1.08 1.12 1.24 2/281 432296.297# [RSpecRunTime] Finishing example group spec/lib/gitlab/background_migration/legacy_upload_mover_spec.rb. It took 1 minute 53.04 seconds. Expected to take 1 minute 53.8 seconds.298# [RSpecRunTime] RSpec elapsed time: 5 minutes 19.15 seconds. Current RSS: ~1403M. Threads: 4. load average: 1.07 1.11 1.23 1/280 433299.300# [RSpecRunTime] Starting example group spec/lib/gitlab/background_migration/backfill_has_merge_request_of_vulnerability_reads_spec.rb. Expected to take 1 minute 32.72 seconds.301Gitlab::BackgroundMigration::BackfillHasMergeRequestOfVulnerabilityReads302 sets the has_merge_request of existing record303 does not modify has_merge_request of other vulnerabilities which do not have merge request304INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree305INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"306INFO: "ci_runner_machine_builds_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows307INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_101"308INFO: "ci_runner_machine_builds_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows309INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_102"310INFO: "ci_runner_machine_builds_102": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows311INFO: analyzing "public.p_ci_job_annotations" inheritance tree312INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"313INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows314INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_101"315INFO: "ci_job_annotations_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows316INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_102"317INFO: "ci_job_annotations_102": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows318INFO: analyzing "public.p_ci_builds_metadata" inheritance tree319INFO: analyzing "public.ci_builds_metadata"320INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows321INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_101"322INFO: "ci_builds_metadata_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows323INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_102"324INFO: "ci_builds_metadata_102": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows325INFO: analyzing "public.p_ci_builds" inheritance tree326INFO: analyzing "public.ci_builds"327INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows328INFO: analyzing "gitlab_partitions_dynamic.ci_builds_101"329INFO: "ci_builds_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows330INFO: analyzing "gitlab_partitions_dynamic.ci_builds_102"331INFO: "ci_builds_102": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows332I, [2024-07-31T10:23:00.116194 #326] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes333I, [2024-07-31T10:23:19.574226 #326] INFO -- : Database: 'main', Table: 'ci_job_token_group_scope_links': Lock Writes334INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree335INFO: analyzing "public.ci_pipeline_variables"336INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows337I, [2024-07-31T10:23:21.162448 #326] INFO -- : Database: 'main', Table: 'p_ci_pipeline_variables': Lock Writes338I, [2024-07-31T10:23:21.163632 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}339I, [2024-07-31T10:23:21.164354 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}340INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree341INFO: analyzing "public.ci_pipeline_variables"342INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows343INFO: analyzing "public.p_ci_job_artifacts" inheritance tree344INFO: analyzing "public.ci_job_artifacts"345INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows346I, [2024-07-31T10:23:26.886585 #326] INFO -- : Database: 'main', Table: 'p_ci_job_artifacts': Lock Writes347I, [2024-07-31T10:23:26.887747 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}348I, [2024-07-31T10:23:26.888557 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}349INFO: analyzing "public.p_ci_stages" inheritance tree350INFO: analyzing "public.ci_stages"351INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows352I, [2024-07-31T10:23:30.103745 #326] INFO -- : Database: 'main', Table: 'p_ci_stages': Lock Writes353I, [2024-07-31T10:23:30.104812 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}354I, [2024-07-31T10:23:30.105581 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}355I, [2024-07-31T10:23:31.213874 #326] INFO -- : Database: 'main', Table: 'p_ci_build_names': Lock Writes356I, [2024-07-31T10:23:37.299814 #326] INFO -- : Database: 'main', Table: 'p_ci_builds_execution_configs': Lock Writes357I, [2024-07-31T10:23:50.332634 #326] INFO -- : Database: 'main', Table: 'p_ci_build_sources': Lock Writes358I, [2024-07-31T10:23:50.333748 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}359I, [2024-07-31T10:23:50.334497 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}360I, [2024-07-31T10:24:01.494515 #326] INFO -- : Database: 'main', Table: 'p_ci_finished_pipeline_ch_sync_events': Lock Writes361I, [2024-07-31T10:24:08.217679 #326] INFO -- : Database: 'main', Table: 'p_ci_build_tags': Lock Writes362# [RSpecRunTime] Finishing example group spec/lib/gitlab/background_migration/backfill_has_merge_request_of_vulnerability_reads_spec.rb. It took 2 minutes 44.24 seconds. Expected to take 1 minute 32.72 seconds.363# [RSpecRunTime] RSpec elapsed time: 8 minutes 3.45 seconds. Current RSS: ~1411M. Threads: 4. load average: 1.01 1.08 1.20 1/280 434364.365# [RSpecRunTime] Starting example group spec/lib/gitlab/background_migration/backfill_packages_tags_project_id_spec.rb. Expected to take 1 minute 15.86 seconds.366Gitlab::BackgroundMigration::BackfillPackagesTagsProjectId367 backfills the missing project_id for the batch368I, [2024-07-31T10:25:42.191383 #326] INFO -- : Database: 'main', Table: 'ci_job_token_group_scope_links': Lock Writes369INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree370INFO: analyzing "public.ci_pipeline_variables"371INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows372I, [2024-07-31T10:25:43.827467 #326] INFO -- : Database: 'main', Table: 'p_ci_pipeline_variables': Lock Writes373I, [2024-07-31T10:25:43.828534 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}374I, [2024-07-31T10:25:43.829282 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}375INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree376INFO: analyzing "public.ci_pipeline_variables"377INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows378INFO: analyzing "public.p_ci_job_artifacts" inheritance tree379INFO: analyzing "public.ci_job_artifacts"380INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows381I, [2024-07-31T10:25:49.548074 #326] INFO -- : Database: 'main', Table: 'p_ci_job_artifacts': Lock Writes382I, [2024-07-31T10:25:49.549456 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}383I, [2024-07-31T10:25:49.550224 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}384INFO: analyzing "public.p_ci_stages" inheritance tree385INFO: analyzing "public.ci_stages"386INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows387I, [2024-07-31T10:25:52.815503 #326] INFO -- : Database: 'main', Table: 'p_ci_stages': Lock Writes388I, [2024-07-31T10:25:52.817448 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}389I, [2024-07-31T10:25:52.818247 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}390I, [2024-07-31T10:25:53.918575 #326] INFO -- : Database: 'main', Table: 'p_ci_build_names': Lock Writes391I, [2024-07-31T10:25:59.899551 #326] INFO -- : Database: 'main', Table: 'p_ci_builds_execution_configs': Lock Writes392I, [2024-07-31T10:26:12.724599 #326] INFO -- : Database: 'main', Table: 'p_ci_build_sources': Lock Writes393I, [2024-07-31T10:26:12.726140 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}394I, [2024-07-31T10:26:12.726885 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}395I, [2024-07-31T10:26:23.867480 #326] INFO -- : Database: 'main', Table: 'p_ci_finished_pipeline_ch_sync_events': Lock Writes396I, [2024-07-31T10:26:30.247372 #326] INFO -- : Database: 'main', Table: 'p_ci_build_tags': Lock Writes397# [RSpecRunTime] Finishing example group spec/lib/gitlab/background_migration/backfill_packages_tags_project_id_spec.rb. It took 2 minutes 21.92 seconds. Expected to take 1 minute 15.86 seconds.398# [RSpecRunTime] RSpec elapsed time: 10 minutes 25.43 seconds. Current RSS: ~1394M. Threads: 4. load average: 1.06 1.08 1.18 1/280 435399.400# [RSpecRunTime] Starting example group spec/lib/gitlab/background_migration/delete_invalid_protected_tag_create_access_levels_spec.rb. Expected to take 1 minute 0.26 second.401Gitlab::BackgroundMigration::DeleteInvalidProtectedTagCreateAccessLevels402 when there are push access levels403 deletes push access levels with groups that do not have project_group_links to the project404# [RSpecRunTime] RSpec elapsed time: 11 minutes 22.11 seconds. Current RSS: ~1446M. Threads: 4. load average: 1.15 1.10 1.18 1/280 436405.406I, [2024-07-31T10:27:39.611590 #326] INFO -- : Database: 'main', Table: 'ci_job_token_group_scope_links': Lock Writes407INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree408INFO: analyzing "public.ci_pipeline_variables"409INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows410I, [2024-07-31T10:27:41.321399 #326] INFO -- : Database: 'main', Table: 'p_ci_pipeline_variables': Lock Writes411I, [2024-07-31T10:27:41.322523 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}412I, [2024-07-31T10:27:41.323338 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}413INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree414INFO: analyzing "public.ci_pipeline_variables"415INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows416INFO: analyzing "public.p_ci_job_artifacts" inheritance tree417INFO: analyzing "public.ci_job_artifacts"418INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows419I, [2024-07-31T10:27:47.064892 #326] INFO -- : Database: 'main', Table: 'p_ci_job_artifacts': Lock Writes420I, [2024-07-31T10:27:47.066092 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}421I, [2024-07-31T10:27:47.067955 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}422INFO: analyzing "public.p_ci_stages" inheritance tree423INFO: analyzing "public.ci_stages"424INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows425I, [2024-07-31T10:27:50.375069 #326] INFO -- : Database: 'main', Table: 'p_ci_stages': Lock Writes426I, [2024-07-31T10:27:50.376171 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}427I, [2024-07-31T10:27:50.377034 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}428I, [2024-07-31T10:27:51.547647 #326] INFO -- : Database: 'main', Table: 'p_ci_build_names': Lock Writes429I, [2024-07-31T10:27:57.581123 #326] INFO -- : Database: 'main', Table: 'p_ci_builds_execution_configs': Lock Writes430I, [2024-07-31T10:28:10.524951 #326] INFO -- : Database: 'main', Table: 'p_ci_build_sources': Lock Writes431I, [2024-07-31T10:28:10.526553 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}432I, [2024-07-31T10:28:10.527318 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}433I, [2024-07-31T10:28:21.754489 #326] INFO -- : Database: 'main', Table: 'p_ci_finished_pipeline_ch_sync_events': Lock Writes434I, [2024-07-31T10:28:28.171437 #326] INFO -- : Database: 'main', Table: 'p_ci_build_tags': Lock Writes435# [RSpecRunTime] Finishing example group spec/lib/gitlab/background_migration/delete_invalid_protected_tag_create_access_levels_spec.rb. It took 1 minute 58.03 seconds. Expected to take 1 minute 0.26 second.436# [RSpecRunTime] RSpec elapsed time: 12 minutes 23.53 seconds. Current RSS: ~1395M. Threads: 4. load average: 1.10 1.09 1.17 1/280 437437.438# [RSpecRunTime] Starting example group spec/lib/gitlab/background_migration/backfill_approval_merge_request_rule_sources_project_id_spec.rb. Expected to take 49.45 seconds.439Gitlab::BackgroundMigration::BackfillApprovalMergeRequestRuleSourcesProjectId440 constructs a valid query441 performs without error442I, [2024-07-31T10:29:34.957358 #326] INFO -- : Database: 'main', Table: 'p_ci_build_sources': Lock Writes443I, [2024-07-31T10:29:34.958406 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}444I, [2024-07-31T10:29:34.959166 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}445I, [2024-07-31T10:29:45.692962 #326] INFO -- : Database: 'main', Table: 'p_ci_finished_pipeline_ch_sync_events': Lock Writes446I, [2024-07-31T10:29:52.043335 #326] INFO -- : Database: 'main', Table: 'p_ci_build_tags': Lock Writes447# [RSpecRunTime] Finishing example group spec/lib/gitlab/background_migration/backfill_approval_merge_request_rule_sources_project_id_spec.rb. It took 1 minute 23.65 seconds. Expected to take 49.45 seconds.448# [RSpecRunTime] RSpec elapsed time: 13 minutes 47.24 seconds. Current RSS: ~1384M. Threads: 4. load average: 1.01 1.08 1.16 1/280 438449.450# [RSpecRunTime] Starting example group spec/lib/gitlab/background_migration/backfill_has_remediations_of_vulnerability_reads_spec.rb. Expected to take 36.23 seconds.451Gitlab::BackgroundMigration::BackfillHasRemediationsOfVulnerabilityReads452 does not modify has_remediations of vulnerabilities which do not have remediations453 when finding_remediation record exists454 updates vulnerability_reads records which has remediations455# [RSpecRunTime] RSpec elapsed time: 14 minutes 20.82 seconds. Current RSS: ~1446M. Threads: 4. load average: 1.16 1.10 1.17 3/283 439456.457I, [2024-07-31T10:30:40.829850 #326] INFO -- : Database: 'main', Table: 'p_ci_build_sources': Lock Writes458I, [2024-07-31T10:30:40.830991 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}459I, [2024-07-31T10:30:40.831831 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}460I, [2024-07-31T10:30:52.954847 #326] INFO -- : Database: 'main', Table: 'p_ci_finished_pipeline_ch_sync_events': Lock Writes461I, [2024-07-31T10:30:59.211610 #326] INFO -- : Database: 'main', Table: 'p_ci_build_tags': Lock Writes462# [RSpecRunTime] Finishing example group spec/lib/gitlab/background_migration/backfill_has_remediations_of_vulnerability_reads_spec.rb. It took 1 minute 7.16 seconds. Expected to take 36.23 seconds.463# [RSpecRunTime] RSpec elapsed time: 14 minutes 54.47 seconds. Current RSS: ~1381M. Threads: 4. load average: 0.92 1.05 1.15 1/282 440464.465# [RSpecRunTime] Starting example group spec/lib/gitlab/background_migration/backfill_audit_events_streaming_headers_group_id_spec.rb. Expected to take 31.57 seconds.466Gitlab::BackgroundMigration::BackfillAuditEventsStreamingHeadersGroupId467 performs without error468 constructs a valid query469I, [2024-07-31T10:31:40.282203 #326] INFO -- : Database: 'main', Table: 'p_ci_build_sources': Lock Writes470I, [2024-07-31T10:31:40.283401 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}471I, [2024-07-31T10:31:40.284207 #326] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}472I, [2024-07-31T10:31:50.830664 #326] INFO -- : Database: 'main', Table: 'p_ci_finished_pipeline_ch_sync_events': Lock Writes473I, [2024-07-31T10:31:57.160142 #326] INFO -- : Database: 'main', Table: 'p_ci_build_tags': Lock Writes474# [RSpecRunTime] Finishing example group spec/lib/gitlab/background_migration/backfill_audit_events_streaming_headers_group_id_spec.rb. It took 57.7 seconds. Expected to take 31.57 seconds.475# [RSpecRunTime] RSpec elapsed time: 15 minutes 52.23 seconds. Current RSS: ~1379M. Threads: 4. load average: 0.99 1.05 1.14 1/282 441476.477# [RSpecRunTime] Starting example group spec/lib/gitlab/background_migration/backfill_status_check_responses_project_id_spec.rb. Expected to take 30.89 seconds.478Gitlab::BackgroundMigration::BackfillStatusCheckResponsesProjectId479 performs without error480 constructs a valid query481I, [2024-07-31T10:32:46.025812 #326] INFO -- : Database: 'main', Table: 'p_ci_finished_pipeline_ch_sync_events': Lock Writes482I, [2024-07-31T10:32:52.411016 #326] INFO -- : Database: 'main', Table: 'p_ci_build_tags': Lock Writes483# [RSpecRunTime] Finishing example group spec/lib/gitlab/background_migration/backfill_status_check_responses_project_id_spec.rb. It took 55.24 seconds. Expected to take 30.89 seconds.484# [RSpecRunTime] RSpec elapsed time: 16 minutes 47.53 seconds. Current RSS: ~1369M. Threads: 4. load average: 0.95 1.03 1.13 1/282 442485.486# [RSpecRunTime] Starting example group spec/lib/gitlab/background_migration/backfill_dast_site_profile_secret_variables_project_id_spec.rb. Expected to take 30.19 seconds.487Gitlab::BackgroundMigration::BackfillDastSiteProfileSecretVariablesProjectId488 performs without error489 constructs a valid query490I, [2024-07-31T10:33:43.396270 #326] INFO -- : Database: 'main', Table: 'p_ci_finished_pipeline_ch_sync_events': Lock Writes491I, [2024-07-31T10:33:49.788308 #326] INFO -- : Database: 'main', Table: 'p_ci_build_tags': Lock Writes492# [RSpecRunTime] Finishing example group spec/lib/gitlab/background_migration/backfill_dast_site_profile_secret_variables_project_id_spec.rb. It took 57.24 seconds. Expected to take 30.19 seconds.493# [RSpecRunTime] RSpec elapsed time: 17 minutes 44.83 seconds. Current RSS: ~1383M. Threads: 4. load average: 1.04 1.04 1.12 1/282 443494.495# [RSpecRunTime] Starting example group spec/lib/gitlab/background_migration/backfill_merge_request_assignees_project_id_spec.rb. Expected to take 29.36 seconds.496Gitlab::BackgroundMigration::BackfillMergeRequestAssigneesProjectId497 constructs a valid query498 performs without error499I, [2024-07-31T10:34:41.026323 #326] INFO -- : Database: 'main', Table: 'p_ci_finished_pipeline_ch_sync_events': Lock Writes500I, [2024-07-31T10:34:47.417844 #326] INFO -- : Database: 'main', Table: 'p_ci_build_tags': Lock Writes501# [RSpecRunTime] Finishing example group spec/lib/gitlab/background_migration/backfill_merge_request_assignees_project_id_spec.rb. It took 57.5 seconds. Expected to take 29.36 seconds.502# [RSpecRunTime] RSpec elapsed time: 18 minutes 42.39 seconds. Current RSS: ~1377M. Threads: 4. load average: 1.09 1.06 1.12 1/282 444503.504# [RSpecRunTime] Starting example group spec/lib/gitlab/background_migration/backfill_vulnerability_findings_remediations_project_id_spec.rb. Expected to take 19.26 seconds.505Gitlab::BackgroundMigration::BackfillVulnerabilityFindingsRemediationsProjectId506 constructs a valid query507 performs without error508I, [2024-07-31T10:35:15.803530 #326] INFO -- : Database: 'main', Table: 'p_ci_finished_pipeline_ch_sync_events': Lock Writes509I, [2024-07-31T10:35:23.495634 #326] INFO -- : Database: 'main', Table: 'p_ci_build_tags': Lock Writes510# [RSpecRunTime] Finishing example group spec/lib/gitlab/background_migration/backfill_vulnerability_findings_remediations_project_id_spec.rb. It took 36.03 seconds. Expected to take 19.26 seconds.511# [RSpecRunTime] RSpec elapsed time: 19 minutes 18.48 seconds. Current RSS: ~1386M. Threads: 4. load average: 1.04 1.05 1.11 1/282 445512.513# [RSpecRunTime] Starting example group spec/lib/gitlab/background_migration/backfill_packages_maven_metadata_project_id_spec.rb. Expected to take 18.31 seconds.514Gitlab::BackgroundMigration::BackfillPackagesMavenMetadataProjectId515 constructs a valid query516 performs without error517I, [2024-07-31T10:35:51.504345 #326] INFO -- : Database: 'main', Table: 'p_ci_finished_pipeline_ch_sync_events': Lock Writes518I, [2024-07-31T10:35:57.815410 #326] INFO -- : Database: 'main', Table: 'p_ci_build_tags': Lock Writes519# [RSpecRunTime] Finishing example group spec/lib/gitlab/background_migration/backfill_packages_maven_metadata_project_id_spec.rb. It took 34.42 seconds. Expected to take 18.31 seconds.520# [RSpecRunTime] RSpec elapsed time: 19 minutes 52.96 seconds. Current RSS: ~1379M. Threads: 4. load average: 1.24 1.09 1.13 1/282 446521.522# [RSpecRunTime] Starting example group spec/lib/gitlab/background_migration/backfill_partition_id_ci_pipeline_message_spec.rb. Expected to take 17.61 seconds.523Gitlab::BackgroundMigration::BackfillPartitionIdCiPipelineMessage524 #perform525 when there are no invalid records526 does not execute the migration527# [RSpecRunTime] RSpec elapsed time: 20 minutes 5.86 seconds. Current RSS: ~1446M. Threads: 4. load average: 1.10 1.07 1.12 1/282 447528.529 when second partition exists530 fixes invalid records in the wrong the partition531# [RSpecRunTime] RSpec elapsed time: 20 minutes 9.84 seconds. Current RSS: ~1488M. Threads: 4. load average: 1.10 1.07 1.12 1/282 448532.533I, [2024-07-31T10:36:33.276508 #326] INFO -- : Database: 'main', Table: 'p_ci_build_tags': Lock Writes534# [RSpecRunTime] Finishing example group spec/lib/gitlab/background_migration/backfill_partition_id_ci_pipeline_message_spec.rb. It took 35.35 seconds. Expected to take 17.61 seconds.535# [RSpecRunTime] RSpec elapsed time: 20 minutes 28.37 seconds. Current RSS: ~1382M. Threads: 4. load average: 1.07 1.06 1.11 1/282 449536.537# [RSpecRunTime] Starting example group spec/lib/gitlab/background_migration/remove_namespace_from_os_type_sbom_components_spec.rb. Expected to take 13.58 seconds.538Gitlab::BackgroundMigration::RemoveNamespaceFromOsTypeSbomComponents539 #perform540 successfully removes the os namespace prefix541 with existing record in regards to name, purl_type and component_type542 rescues valid ActiveRecord::RecordNotUnique errors543# [RSpecRunTime] RSpec elapsed time: 20 minutes 36.71 seconds. Current RSS: ~1477M. Threads: 4. load average: 1.22 1.09 1.12 1/282 450544.545 with unexpected ActiveRecord::RecordNotUnique error546 raises unknown ActiveRecord::RecordNotUnique errors547# [RSpecRunTime] RSpec elapsed time: 20 minutes 40.78 seconds. Current RSS: ~1508M. Threads: 4. load average: 1.12 1.08 1.12 1/282 451548.549# [RSpecRunTime] Finishing example group spec/lib/gitlab/background_migration/remove_namespace_from_os_type_sbom_components_spec.rb. It took 20.89 seconds. Expected to take 13.58 seconds.550# [RSpecRunTime] RSpec elapsed time: 20 minutes 49.32 seconds. Current RSS: ~1421M. Threads: 4. load average: 1.11 1.07 1.12 1/282 452551.552# [RSpecRunTime] Starting example group spec/lib/gitlab/background_migration/backfill_evidences_project_id_spec.rb. Expected to take 11.4 seconds.553Gitlab::BackgroundMigration::BackfillEvidencesProjectId554 constructs a valid query555 performs without error556# [RSpecRunTime] Finishing example group spec/lib/gitlab/background_migration/backfill_evidences_project_id_spec.rb. It took 21.17 seconds. Expected to take 11.4 seconds.557# [RSpecRunTime] RSpec elapsed time: 21 minutes 10.55 seconds. Current RSS: ~1396M. Threads: 4. load average: 1.06 1.07 1.11 1/282 453558.559# [RSpecRunTime] Starting example group spec/lib/gitlab/background_migration/create_jira_cloud_app_integration_for_jira_connect_subscription_spec.rb. Expected to take 6.32 seconds.560Gitlab::BackgroundMigration::CreateJiraCloudAppIntegrationForJiraConnectSubscription561 creates jira_cloud_app integration for the groups and descendant projects562# [RSpecRunTime] Finishing example group spec/lib/gitlab/background_migration/create_jira_cloud_app_integration_for_jira_connect_subscription_spec.rb. It took 12.51 seconds. Expected to take 6.32 seconds.563# [RSpecRunTime] RSpec elapsed time: 21 minutes 23.12 seconds. Current RSS: ~1421M. Threads: 4. load average: 1.05 1.06 1.11 1/282 454564.565# [RSpecRunTime] Starting example group spec/lib/gitlab/background_migration/update_jira_tracker_data_deployment_type_based_on_url_spec.rb. Expected to take 4.73 seconds.566Gitlab::BackgroundMigration::UpdateJiraTrackerDataDeploymentTypeBasedOnUrl567 changes unknown deployment_types based on URL568# [RSpecRunTime] Finishing example group spec/lib/gitlab/background_migration/update_jira_tracker_data_deployment_type_based_on_url_spec.rb. It took 11.38 seconds. Expected to take 4.73 seconds.569# [RSpecRunTime] RSpec elapsed time: 21 minutes 34.56 seconds. Current RSS: ~1421M. Threads: 4. load average: 1.12 1.08 1.11 1/282 455570.571auto_explain log contains 1071 entries for main, writing to /builds/gitlab-org/gitlab/auto_explain/rspec-background-migration-pg14-9-10.326.main.ndjson.gz572took 28.336202611573auto_explain log contains 1072 entries for ci, writing to /builds/gitlab-org/gitlab/auto_explain/rspec-background-migration-pg14-9-10.326.ci.ndjson.gz574took 26.886442013575[TEST PROF INFO] EventProf results for sql.active_record576Total time: 13:55.697 of 21:29.660 (64.8%)577Total events: 678131578Top 5 slowest suites (by time):579Gitlab::Backg...ngCiCdSettings (./spec/lib/gitlab/background_migration/backfill_missing_ci_cd_settings_spec.rb:5) – 02:19.942 (96877 / 2) of 03:21.163 (69.57%)580Gitlab::Backg...erabilityReads (./spec/lib/gitlab/background_migration/backfill_has_merge_request_of_vulnerability_reads_spec.rb:5) – 01:53.790 (88229 / 2) of 02:44.302 (69.26%)581Gitlab::Backg...sTagsProjectId (./spec/lib/gitlab/background_migration/backfill_packages_tags_project_id_spec.rb:5) – 01:41.828 (79647 / 1) of 02:21.978 (71.72%)582Gitlab::Backg...teAccessLevels (./spec/lib/gitlab/background_migration/delete_invalid_protected_tag_create_access_levels_spec.rb:5) – 01:24.992 (67698 / 1) of 01:58.098 (71.97%)583Gitlab::Backg...urcesProjectId (./spec/lib/gitlab/background_migration/backfill_approval_merge_request_rule_sources_project_id_spec.rb:5) – 00:57.985 (48724 / 2) of 01:23.714 (69.27%)584Knapsack report was generated. Preview:585{586 "spec/lib/gitlab/background_migration/backfill_missing_ci_cd_settings_spec.rb": 104.32912755699999,587 "spec/lib/gitlab/background_migration/legacy_upload_mover_spec.rb": 104.72973517799983,588 "spec/lib/gitlab/background_migration/backfill_has_merge_request_of_vulnerability_reads_spec.rb": 84.43927961400004,589 "spec/lib/gitlab/background_migration/backfill_packages_tags_project_id_spec.rb": 69.92276588800087,590 "spec/lib/gitlab/background_migration/delete_invalid_protected_tag_create_access_levels_spec.rb": 56.806458106999344,591 "spec/lib/gitlab/background_migration/backfill_approval_merge_request_rule_sources_project_id_spec.rb": 43.20961361500122,592 "spec/lib/gitlab/background_migration/backfill_has_remediations_of_vulnerability_reads_spec.rb": 33.73340022100092,593 "spec/lib/gitlab/background_migration/backfill_audit_events_streaming_headers_group_id_spec.rb": 29.300894641000923,594 "spec/lib/gitlab/background_migration/backfill_status_check_responses_project_id_spec.rb": 27.660169992999727,595 "spec/lib/gitlab/background_migration/backfill_dast_site_profile_secret_variables_project_id_spec.rb": 28.118303462999393,596 "spec/lib/gitlab/background_migration/backfill_merge_request_assignees_project_id_spec.rb": 28.417251237999153,597 "spec/lib/gitlab/background_migration/backfill_vulnerability_findings_remediations_project_id_spec.rb": 17.004843868000535,598 "spec/lib/gitlab/background_migration/backfill_packages_maven_metadata_project_id_spec.rb": 16.77731188799953,599 "spec/lib/gitlab/background_migration/backfill_partition_id_ci_pipeline_message_spec.rb": 17.0087544779999,600 "spec/lib/gitlab/background_migration/remove_namespace_from_os_type_sbom_components_spec.rb": 12.545744151999315,601 "spec/lib/gitlab/background_migration/backfill_evidences_project_id_spec.rb": 10.662802364000527,602 "spec/lib/gitlab/background_migration/create_jira_cloud_app_integration_for_jira_connect_subscription_spec.rb": 5.361725009999645,603 "spec/lib/gitlab/background_migration/update_jira_tracker_data_deployment_type_based_on_url_spec.rb": 4.378676252999867604}605Knapsack global time execution for tests: 11m 34s606Finished in 22 minutes 30 seconds (files took 1 minute 43.7 seconds to load)60748 examples, 0 failures608Randomized with seed 20557609[TEST PROF INFO] Time spent in factories: 00:34.312 (2.46% of total time)610RSpec exited with 0.611No examples to retry, congrats!613Running after script...614$ source scripts/utils.sh615$ bundle exec gem list gitlab_quality-test_tooling616gitlab_quality-test_tooling (1.33.0)617$ section_start "failed-test-issues" "Report test failures" # collapsed multi-line command621$ section_start "flaky-test-issues" "Report test flakiness" # collapsed multi-line command624$ section_start "slow-test-issues" "Report test slowness" # collapsed multi-line command628$ section_start "slow-test-merge-request-report-note" "Report test slowness in MR note" # collapsed multi-line command631$ section_start "knapsack-report-issues" "Report test files close to timing out" # collapsed multi-line command635$ tooling/bin/push_job_metrics || true636[job-metrics] Pushing job metrics file for the CI/CD job.637[job-metrics] Pushed 4 CI job metric entries to InfluxDB.639Not uploading cache ruby-gems-debian-bookworm-ruby-3.1.5-17 due to policy641Uploading artifacts...642auto_explain/: found 3 matching artifact files and directories 643coverage/: found 5 matching artifact files and directories 644crystalball/: found 5 matching artifact files and directories 645WARNING: deprecations/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab) 646knapsack/: found 4 matching artifact files and directories 647rspec/: found 12 matching artifact files and directories 648WARNING: tmp/capybara/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab) 649log/*.log: found 13 matching artifact files and directories 650WARNING: Upload request redirected location=https://gitlab.com/api/v4/jobs/7471345492/artifacts?artifact_format=zip&artifact_type=archive&expire_in=31d new-url=https://gitlab.com651WARNING: Retrying... context=artifacts-uploader error=request redirected652Uploading artifacts as "archive" to coordinator... 201 Created id=7471345492 responseStatus=201 Created token=glcbt-66653Uploading artifacts...654rspec/rspec-*.xml: found 1 matching artifact files and directories 655WARNING: Upload request redirected location=https://gitlab.com/api/v4/jobs/7471345492/artifacts?artifact_format=gzip&artifact_type=junit&expire_in=31d new-url=https://gitlab.com656WARNING: Retrying... context=artifacts-uploader error=request redirected657Uploading artifacts as "junit" to coordinator... 201 Created id=7471345492 responseStatus=201 Created token=glcbt-66659Job succeeded