rspec migration pg14 single-db-ci-connection 5/15
Passed Started
by
@rkadam3

Rajendra Kadam
1Running with gitlab-runner 16.9.1 (782c6ecb)2 on green-4.private.runners-manager.gitlab.com/gitlab.com/gitlab-org rpvz2FF9, system ID: s_d704414ba02a3 feature flags: FF_NETWORK_PER_BUILD:true, FF_USE_IMPROVED_URL_MASKING:true6Using Docker executor with image registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bookworm-ruby-3.1.patched-golang-1.20-rust-1.73-node-18.17-postgresql-14:rubygems-3.4-git-2.36-lfs-2.9-chrome-120-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:b6c412dc298714b5c26feca1330d8f743b48caf0b1feeadfd554d7d446f985a5 for redis:6.2-alpine with digest redis@sha256:51d6c56749a4243096327e3fb964a48ed92254357108449cb6e23999c37773c5 ...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.patched-golang-1.20-rust-1.73-node-18.17-postgresql-14:rubygems-3.4-git-2.36-lfs-2.9-chrome-120-yarn-1.22-graphicsmagick-1.3.36 ...23Using docker image sha256:fc7435a87025ef82fcd7c3a7df1e52121e8a88ab05430c94ba7ad5920fecc0d0 for registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bookworm-ruby-3.1.patched-golang-1.20-rust-1.73-node-18.17-postgresql-14:rubygems-3.4-git-2.36-lfs-2.9-chrome-120-yarn-1.22-graphicsmagick-1.3.36 with digest registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bookworm-ruby-3.1.patched-golang-1.20-rust-1.73-node-18.17-postgresql-14@sha256:c129fa1214137f01be7f1412c5233ac179604d32d9d852cbe06113596fb24504 ...25Running on runner-rpvz2ff9-project-278964-concurrent-0 via runner-rpvz2ff9-private-1709558801-e094e896...27Skipping Git repository setup28Skipping Git checkout29Skipping Git submodules setup31Checking cache for ruby-gems-debian-bookworm-ruby-3.1-17...32Downloading cache from https://storage.googleapis.com/gitlab-com-runners-cache/project/278964/ruby-gems-debian-bookworm-ruby-3.1-17 33Successfully extracted cache35Downloading artifacts for clone-gitlab-repo (6311410718)...36Downloading artifacts from coordinator... ok host=storage.googleapis.com id=6311410718 responseStatus=200 OK token=glcbt-6537WARNING: Part of .git directory is on the list of files to extract 38WARNING: This may introduce unexpected problems 39Downloading artifacts for compile-test-assets (6311410765)...40Downloading artifacts from coordinator... ok host=storage.googleapis.com id=6311410765 responseStatus=200 OK token=glcbt-6541Downloading artifacts for detect-tests (6311410787)...42Downloading artifacts from coordinator... ok host=storage.googleapis.com id=6311410787 responseStatus=200 OK token=glcbt-6543Downloading artifacts for retrieve-tests-metadata (6311410799)...44Downloading artifacts from coordinator... ok host=storage.googleapis.com id=6311410799 responseStatus=200 OK token=glcbt-6545Downloading artifacts for setup-test-env (6311410773)...46Downloading artifacts from coordinator... ok host=storage.googleapis.com id=6311410773 responseStatus=200 OK token=glcbt-6548Using docker image sha256:fc7435a87025ef82fcd7c3a7df1e52121e8a88ab05430c94ba7ad5920fecc0d0 for registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bookworm-ruby-3.1.patched-golang-1.20-rust-1.73-node-18.17-postgresql-14:rubygems-3.4-git-2.36-lfs-2.9-chrome-120-yarn-1.22-graphicsmagick-1.3.36 with digest registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bookworm-ruby-3.1.patched-golang-1.20-rust-1.73-node-18.17-postgresql-14@sha256:c129fa1214137f01be7f1412c5233ac179604d32d9d852cbe06113596fb24504 ...49$ echo $FOSS_ONLY50$ [ "$FOSS_ONLY" = "1" ] && rm -rf ee/ qa/spec/ee/ qa/qa/specs/features/ee/ qa/qa/ee/ qa/qa/ee.rb51$ export GOPATH=$CI_PROJECT_DIR/.go52$ mkdir -p $GOPATH53$ source scripts/utils.sh54$ source scripts/prepare_build.sh732Using two connections, single database config (config/database.yml.postgresql)733Geo DB won't be set up.734Embedding DB won't be set up.746$ source ./scripts/rspec_helpers.sh747$ run_timed_command "gem install knapsack --no-document"748$ gem install knapsack --no-document749Successfully installed knapsack-4.0.07501 gem installed751==> 'gem install knapsack --no-document' succeeded in 0 seconds.752$ section_start "gitaly-test-spawn" "Spawning Gitaly"; scripts/gitaly-test-spawn; section_end "gitaly-test-spawn"757$ export RSPEC_SKIPPED_TESTS_REPORT_PATH="rspec/skipped_tests-${CI_JOB_ID}.txt"758$ export RSPEC_RETRIED_TESTS_REPORT_PATH="rspec/retried_tests-${CI_JOB_ID}.txt"759$ tooling/bin/create_job_metrics_file || true760[job-metrics] Creating the job metrics file for the CI/CD job.761$ rspec_parallelized_job "--fail-fast=${RSPEC_FAIL_FAST_THRESHOLD} --tag ~quarantine --tag ~zoekt --tag ~click_house"762[13:30:45] Starting rspec_parallelized_job763RETRY_FAILED_TESTS_IN_NEW_PROCESS: true764KNAPSACK_GENERATE_REPORT: true765FLAKY_RSPEC_GENERATE_REPORT: true766KNAPSACK_TEST_FILE_PATTERN: spec/{migrations}{,/**/}*_spec.rb767KNAPSACK_LOG_LEVEL: debug768KNAPSACK_REPORT_PATH: knapsack/rspec_migration_pg14_single-db-ci-connection_5_15_278964_report.json769FLAKY_RSPEC_SUITE_REPORT_PATH: rspec/flaky/report-suite.json770FLAKY_RSPEC_REPORT_PATH: rspec/flaky/all_rspec_migration_pg14_single-db-ci-connection_5_15_278964_report.json771NEW_FLAKY_RSPEC_REPORT_PATH: rspec/flaky/new_rspec_migration_pg14_single-db-ci-connection_5_15_278964_report.json772RSPEC_SKIPPED_TESTS_REPORT_PATH: rspec/skipped_tests-6311411195.txt773CRYSTALBALL: 774RSPEC_TESTS_MAPPING_ENABLED: 775RSPEC_TESTS_FILTER_FILE: 776Shell set options (set -o) enabled:777braceexpand on778hashall on779interactive-comments on780pipefail on781Knapsack report generator started!782Run options: exclude {:quarantine=>true, :zoekt=>true, :click_house=>true}783# [RSpecRunTime] Starting RSpec timer...784[TEST PROF INFO] EventProf enabled (sql.active_record)785unknown OID 2249: failed to recognize type of 'pg_stat_file'. It will be treated as String.786Test environment set up in 2.539279889 seconds787# [RSpecRunTime] Starting example group spec/migrations/20230220102212_swap_columns_ci_build_needs_big_int_conversion_spec.rb. Expected to take 1 minute 48.83 seconds.788SwapColumnsCiBuildNeedsBigIntConversion789 #up790 dot_com: true, dev_or_test: true, jh: true, swap: false791 swaps the integer and bigint columns for GitLab.com, dev, or test792 dot_com: true, dev_or_test: false, jh: true, swap: false793 swaps the integer and bigint columns for GitLab.com, dev, or test794# [RSpecRunTime] RSpec elapsed time: 1 minute 22.56 seconds. Current RSS: ~1357M. load average: 1.17 1.16 0.61 1/258 385795 dot_com: false, dev_or_test: true, jh: true, swap: false796 swaps the integer and bigint columns for GitLab.com, dev, or test797# [RSpecRunTime] RSpec elapsed time: 1 minute 26.31 seconds. Current RSS: ~1356M. load average: 1.15 1.15 0.61 1/258 386798 dot_com: false, dev_or_test: false, jh: true, swap: false799 swaps the integer and bigint columns for GitLab.com, dev, or test800# [RSpecRunTime] RSpec elapsed time: 1 minute 29.57 seconds. Current RSS: ~1357M. load average: 1.14 1.15 0.61 1/258 387801 dot_com: true, dev_or_test: true, jh: false, swap: true802 swaps the integer and bigint columns for GitLab.com, dev, or test803# [RSpecRunTime] RSpec elapsed time: 1 minute 32.96 seconds. Current RSS: ~1361M. load average: 1.14 1.15 0.61 1/259 388804 dot_com: true, dev_or_test: false, jh: false, swap: true805 swaps the integer and bigint columns for GitLab.com, dev, or test806# [RSpecRunTime] RSpec elapsed time: 1 minute 36.24 seconds. Current RSS: ~1356M. load average: 1.13 1.15 0.62 1/259 389807 dot_com: false, dev_or_test: true, jh: false, swap: true808 swaps the integer and bigint columns for GitLab.com, dev, or test809# [RSpecRunTime] RSpec elapsed time: 1 minute 39.62 seconds. Current RSS: ~1358M. load average: 1.20 1.16 0.62 1/259 390810 dot_com: false, dev_or_test: false, jh: false, swap: false811 swaps the integer and bigint columns for GitLab.com, dev, or test812# [RSpecRunTime] RSpec elapsed time: 1 minute 42.85 seconds. Current RSS: ~1350M. load average: 1.20 1.16 0.62 1/259 391813INFO: analyzing "public.p_ci_builds" inheritance tree814INFO: analyzing "public.ci_builds"815INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows816INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree817INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"818INFO: "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 rows819INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_101"820INFO: "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 rows821INFO: analyzing "public.p_ci_job_annotations" inheritance tree822INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"823INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows824INFO: analyzing "public.p_ci_builds_metadata" inheritance tree825INFO: analyzing "public.ci_builds_metadata"826INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows827INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_101"828INFO: "ci_builds_metadata_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows829INFO: analyzing "public.p_ci_builds" inheritance tree830INFO: analyzing "public.ci_builds"831INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows832INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree833INFO: analyzing "public.ci_pipeline_variables"834INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows835INFO: analyzing "public.p_ci_job_artifacts" inheritance tree836INFO: analyzing "public.ci_job_artifacts"837INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows838INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree839INFO: analyzing "public.ci_pipeline_variables"840INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows841INFO: analyzing "public.p_ci_stages" inheritance tree842INFO: analyzing "public.ci_stages"843INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows844# [RSpecRunTime] Finishing example group spec/migrations/20230220102212_swap_columns_ci_build_needs_big_int_conversion_spec.rb. It took 3 minutes 8.69 seconds. Expected to take 1 minute 48.83 seconds.845# [RSpecRunTime] RSpec elapsed time: 3 minutes 13.83 seconds. Current RSS: ~1365M. load average: 1.04 1.11 0.66 1/258 393846# [RSpecRunTime] Starting example group spec/migrations/ensure_merge_request_metrics_id_bigint_backfill_is_finished_for_gitlab_dot_com_spec.rb. Expected to take 1 minute 19.69 seconds.847EnsureMergeRequestMetricsIdBigintBackfillIsFinishedForGitlabDotCom848 #up849main: == [advisory_lock_connection] object_id: 45578720, pg_backend_pid: 165850main: == 20230313133001 EnsureMergeRequestMetricsIdBigintBackfillIsFinishedForGitlabDotCom: migrating 851main: == 20230313133001 EnsureMergeRequestMetricsIdBigintBackfillIsFinishedForGitlabDotCom: migrated (0.0097s) 852main: == [advisory_lock_connection] object_id: 45578720, pg_backend_pid: 165853 ensures the migration is completed for GitLab.com, dev, or test854main: == [advisory_lock_connection] object_id: 46576760, pg_backend_pid: 167855main: == 20230313133001 EnsureMergeRequestMetricsIdBigintBackfillIsFinishedForGitlabDotCom: migrating 856main: == 20230313133001 EnsureMergeRequestMetricsIdBigintBackfillIsFinishedForGitlabDotCom: migrated (0.0090s) 857main: == [advisory_lock_connection] object_id: 46576760, pg_backend_pid: 167858 skips the check for other instances859# [RSpecRunTime] RSpec elapsed time: 4 minutes 28.77 seconds. Current RSS: ~1366M. load average: 0.82 1.03 0.67 1/257 394860INFO: analyzing "public.p_ci_builds" inheritance tree861INFO: analyzing "public.ci_builds"862INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows863INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree864INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"865INFO: "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 rows866INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_101"867INFO: "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 rows868INFO: analyzing "public.p_ci_job_annotations" inheritance tree869INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"870INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows871INFO: analyzing "public.p_ci_builds_metadata" inheritance tree872INFO: analyzing "public.ci_builds_metadata"873INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows874INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_101"875INFO: "ci_builds_metadata_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows876INFO: analyzing "public.p_ci_builds" inheritance tree877INFO: analyzing "public.ci_builds"878INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows879INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree880INFO: analyzing "public.ci_pipeline_variables"881INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows882INFO: analyzing "public.p_ci_job_artifacts" inheritance tree883INFO: analyzing "public.ci_job_artifacts"884INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows885INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree886INFO: analyzing "public.ci_pipeline_variables"887INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows888INFO: analyzing "public.p_ci_stages" inheritance tree889INFO: analyzing "public.ci_stages"890INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows891# [RSpecRunTime] Finishing example group spec/migrations/ensure_merge_request_metrics_id_bigint_backfill_is_finished_for_gitlab_dot_com_spec.rb. It took 2 minutes 44.31 seconds. Expected to take 1 minute 19.69 seconds.892# [RSpecRunTime] RSpec elapsed time: 5 minutes 58.18 seconds. Current RSS: ~1366M. load average: 0.94 1.02 0.70 1/258 395893# [RSpecRunTime] Starting example group spec/migrations/remove_saml_provider_and_identities_non_root_group_spec.rb. Expected to take 1 minute 17.03 seconds.894RemoveSamlProviderAndIdentitiesNonRootGroup895main: == [advisory_lock_connection] object_id: 74106180, pg_backend_pid: 182896main: == 20230405132104 RemoveSamlProviderAndIdentitiesNonRootGroup: migrating ======897main: -- execute("DELETE FROM identities\nWHERE identities.saml_provider_id\nIN\n(\n SELECT saml_providers.id FROM saml_providers\n INNER JOIN namespaces ON namespaces.id=saml_providers.group_id\n AND namespaces.type='Group' AND namespaces.parent_id IS NOT NULL\n AND saml_providers.id BETWEEN 1 AND 2\n);\n\nDELETE FROM saml_providers\nUSING namespaces\nWHERE namespaces.id=saml_providers.group_id\nAND namespaces.type='Group' AND namespaces.parent_id IS NOT NULL\nAND saml_providers.id BETWEEN 1 AND 2;\n")898main: -> 0.0036s899main: == 20230405132104 RemoveSamlProviderAndIdentitiesNonRootGroup: migrated (0.0354s) 900main: == [advisory_lock_connection] object_id: 74106180, pg_backend_pid: 182901 removes saml_providers that belong to non-root group and related identities902INFO: analyzing "public.p_ci_builds" inheritance tree903INFO: analyzing "public.ci_builds"904INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows905INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree906INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"907INFO: "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 rows908INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_101"909INFO: "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 rows910INFO: analyzing "public.p_ci_job_annotations" inheritance tree911INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"912INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows913INFO: analyzing "public.p_ci_builds_metadata" inheritance tree914INFO: analyzing "public.ci_builds_metadata"915INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows916INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_101"917INFO: "ci_builds_metadata_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows918INFO: analyzing "public.p_ci_builds" inheritance tree919INFO: analyzing "public.ci_builds"920INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows921INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree922INFO: analyzing "public.ci_pipeline_variables"923INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows924INFO: analyzing "public.p_ci_job_artifacts" inheritance tree925INFO: analyzing "public.ci_job_artifacts"926INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows927INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree928INFO: analyzing "public.ci_pipeline_variables"929INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows930INFO: analyzing "public.p_ci_stages" inheritance tree931INFO: analyzing "public.ci_stages"932INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows933# [RSpecRunTime] Finishing example group spec/migrations/remove_saml_provider_and_identities_non_root_group_spec.rb. It took 2 minutes 36.22 seconds. Expected to take 1 minute 17.03 seconds.934# [RSpecRunTime] RSpec elapsed time: 8 minutes 34.44 seconds. Current RSS: ~1349M. load average: 1.04 1.02 0.76 1/260 396935# [RSpecRunTime] Starting example group spec/migrations/swap_suggestions_note_id_to_bigint_for_gitlab_dot_com_spec.rb. Expected to take 1 minute 15.12 seconds.936SwapSuggestionsNoteIdToBigintForGitlabDotCom937 #up938 swaps the integer and bigint columns for GitLab.com, dev, or test939 is a no-op for other instances940# [RSpecRunTime] RSpec elapsed time: 9 minutes 50.05 seconds. Current RSS: ~1343M. load average: 0.86 0.98 0.77 1/260 397941INFO: analyzing "public.p_ci_builds" inheritance tree942INFO: analyzing "public.ci_builds"943INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows944INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree945INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"946INFO: "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 rows947INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_101"948INFO: "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 rows949INFO: analyzing "public.p_ci_job_annotations" inheritance tree950INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"951INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows952INFO: analyzing "public.p_ci_builds_metadata" inheritance tree953INFO: analyzing "public.ci_builds_metadata"954INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows955INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_101"956INFO: "ci_builds_metadata_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows957INFO: analyzing "public.p_ci_builds" inheritance tree958INFO: analyzing "public.ci_builds"959INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows960INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree961INFO: analyzing "public.ci_pipeline_variables"962INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows963INFO: analyzing "public.p_ci_job_artifacts" inheritance tree964INFO: analyzing "public.ci_job_artifacts"965INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows966INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree967INFO: analyzing "public.ci_pipeline_variables"968INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows969INFO: analyzing "public.p_ci_stages" inheritance tree970INFO: analyzing "public.ci_stages"971INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows972# [RSpecRunTime] Finishing example group spec/migrations/swap_suggestions_note_id_to_bigint_for_gitlab_dot_com_spec.rb. It took 2 minutes 43.9 seconds. Expected to take 1 minute 15.12 seconds.973# [RSpecRunTime] RSpec elapsed time: 11 minutes 18.38 seconds. Current RSS: ~1345M. load average: 0.97 0.99 0.80 1/261 398974# [RSpecRunTime] Starting example group spec/migrations/20230322085041_remove_user_namespace_records_from_vsa_aggregation_spec.rb. Expected to take 1 minute 12.55 seconds.975RemoveUserNamespaceRecordsFromVsaAggregation976 #down977main: == [advisory_lock_connection] object_id: 129167260, pg_backend_pid: 213978main: == 20230322085041 RemoveUserNamespaceRecordsFromVsaAggregation: migrating =====979main: == 20230322085041 RemoveUserNamespaceRecordsFromVsaAggregation: migrated (0.0474s) 980main: == [advisory_lock_connection] object_id: 129167260, pg_backend_pid: 213981 does nothing982# [RSpecRunTime] RSpec elapsed time: 12 minutes 33.06 seconds. Current RSS: ~1341M. load average: 1.03 1.02 0.82 1/261 399983 #up984main: == [advisory_lock_connection] object_id: 130189580, pg_backend_pid: 217985main: == 20230322085041 RemoveUserNamespaceRecordsFromVsaAggregation: migrating =====986main: == 20230322085041 RemoveUserNamespaceRecordsFromVsaAggregation: migrated (0.0655s) 987main: == [advisory_lock_connection] object_id: 130189580, pg_backend_pid: 217988 deletes the non-group namespace aggregation records989# [RSpecRunTime] RSpec elapsed time: 12 minutes 36.25 seconds. Current RSS: ~1351M. load average: 1.02 1.02 0.83 1/261 400990INFO: analyzing "public.p_ci_builds" inheritance tree991INFO: analyzing "public.ci_builds"992INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows993INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree994INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"995INFO: "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 rows996INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_101"997INFO: "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 rows998INFO: analyzing "public.p_ci_job_annotations" inheritance tree999INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"1000INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1001INFO: analyzing "public.p_ci_builds_metadata" inheritance tree1002INFO: analyzing "public.ci_builds_metadata"1003INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1004INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_101"1005INFO: "ci_builds_metadata_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1006INFO: analyzing "public.p_ci_builds" inheritance tree1007INFO: analyzing "public.ci_builds"1008INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1009INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree1010INFO: analyzing "public.ci_pipeline_variables"1011INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1012INFO: analyzing "public.p_ci_job_artifacts" inheritance tree1013INFO: analyzing "public.ci_job_artifacts"1014INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1015INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree1016INFO: analyzing "public.ci_pipeline_variables"1017INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1018INFO: analyzing "public.p_ci_stages" inheritance tree1019INFO: analyzing "public.ci_stages"1020INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1021# [RSpecRunTime] Finishing example group spec/migrations/20230322085041_remove_user_namespace_records_from_vsa_aggregation_spec.rb. It took 2 minutes 45.15 seconds. Expected to take 1 minute 12.55 seconds.1022# [RSpecRunTime] RSpec elapsed time: 14 minutes 3.56 seconds. Current RSS: ~1333M. load average: 0.98 1.00 0.84 1/261 4011023# [RSpecRunTime] Starting example group spec/migrations/20230406121544_queue_backfill_design_management_repositories_spec.rb. Expected to take 1 minute 8.32 seconds.1024QueueBackfillDesignManagementRepositories1025main: == [advisory_lock_connection] object_id: 157114620, pg_backend_pid: 2311026main: == 20230406121544 QueueBackfillDesignManagementRepositories: migrating ========1027main: == 20230406121544 QueueBackfillDesignManagementRepositories: migrated (0.0667s) 1028main: == [advisory_lock_connection] object_id: 157114620, pg_backend_pid: 2311029 schedules a new batched migration1030The application_settings (main) table has 1345 columns.1031Recreating the database1032Dropped database 'gitlabhq_test'1033Created database 'gitlabhq_test'1034main: == [advisory_lock_connection] object_id: 158095680, pg_backend_pid: 2381035main: == [advisory_lock_connection] object_id: 158095680, pg_backend_pid: 2381036ci: == [advisory_lock_connection] object_id: 158095760, pg_backend_pid: 2401037ci: == [advisory_lock_connection] object_id: 158095760, pg_backend_pid: 2401038Databases re-creation done in 7.1249420449998981039# [RSpecRunTime] Finishing example group spec/migrations/20230406121544_queue_backfill_design_management_repositories_spec.rb. It took 1 minute 18.81 seconds. Expected to take 1 minute 8.32 seconds.1040# [RSpecRunTime] RSpec elapsed time: 15 minutes 22.41 seconds. Current RSS: ~1327M. load average: 1.07 1.03 0.86 1/261 4031041# [RSpecRunTime] Starting example group spec/migrations/20230518071251_queue_backfill_code_suggestions_namespace_settings_spec.rb. Expected to take 1 minute 2.36 seconds.1042QueueBackfillCodeSuggestionsNamespaceSettings1043main: == [advisory_lock_connection] object_id: 167610200, pg_backend_pid: 2471044main: == 20230518071251 QueueBackfillCodeSuggestionsNamespaceSettings: migrating ====1045main: == 20230518071251 QueueBackfillCodeSuggestionsNamespaceSettings: migrated (0.0550s) 1046main: == [advisory_lock_connection] object_id: 167610200, pg_backend_pid: 2471047 schedules a new batched migration1048INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree1049INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"1050INFO: "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 rows1051INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_101"1052INFO: "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 rows1053INFO: analyzing "public.p_ci_job_annotations" inheritance tree1054INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"1055INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1056INFO: analyzing "public.p_ci_builds_metadata" inheritance tree1057INFO: analyzing "public.ci_builds_metadata"1058INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1059INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_101"1060INFO: "ci_builds_metadata_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1061INFO: analyzing "public.p_ci_builds" inheritance tree1062INFO: analyzing "public.ci_builds"1063INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1064INFO: analyzing "gitlab_partitions_dynamic.ci_builds_101"1065INFO: "ci_builds_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1066INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree1067INFO: analyzing "public.ci_pipeline_variables"1068INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1069INFO: analyzing "public.p_ci_job_artifacts" inheritance tree1070INFO: analyzing "public.ci_job_artifacts"1071INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1072INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree1073INFO: analyzing "public.ci_pipeline_variables"1074INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1075INFO: analyzing "public.p_ci_stages" inheritance tree1076INFO: analyzing "public.ci_stages"1077INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1078# [RSpecRunTime] Finishing example group spec/migrations/20230518071251_queue_backfill_code_suggestions_namespace_settings_spec.rb. It took 2 minutes 4.44 seconds. Expected to take 1 minute 2.36 seconds.1079# [RSpecRunTime] RSpec elapsed time: 17 minutes 26.89 seconds. Current RSS: ~1334M. load average: 1.02 1.03 0.89 1/261 4041080# [RSpecRunTime] Starting example group spec/migrations/20230801150214_retry_cleanup_bigint_conversion_for_events_for_gitlab_com_spec.rb. Expected to take 55.79 seconds.1081RetryCleanupBigintConversionForEventsForGitlabCom1082 #down1083 when column still exists1084 when is GitLab.com, dev, or test1085 behaves like skips the down migration1086 doesn't calls restore_conversion_of_integer_to_bigint method1087# [RSpecRunTime] RSpec elapsed time: 17 minutes 60.0 seconds. Current RSS: ~1336M. load average: 1.06 1.04 0.90 1/261 4051088 when is a self-managed instance1089 behaves like skips the down migration1090 doesn't calls restore_conversion_of_integer_to_bigint method1091# [RSpecRunTime] RSpec elapsed time: 18 minutes 2.75 seconds. Current RSS: ~1349M. load average: 1.06 1.04 0.90 1/261 4061092 when column not exists1093 when is GitLab.com, dev, or test1094 restore the temporary columns1095# [RSpecRunTime] RSpec elapsed time: 18 minutes 5.48 seconds. Current RSS: ~1351M. load average: 0.97 1.02 0.90 1/261 4071096 when is a self-managed instance1097 behaves like skips the down migration1098 doesn't calls restore_conversion_of_integer_to_bigint method1099# [RSpecRunTime] RSpec elapsed time: 18 minutes 8.23 seconds. Current RSS: ~1347M. load average: 0.97 1.02 0.90 1/261 4081100 #up1101 when column still exists1102 when is GitLab.com, dev, or test1103 drop the temporary columns1104# [RSpecRunTime] RSpec elapsed time: 18 minutes 11.43 seconds. Current RSS: ~1332M. load average: 0.97 1.02 0.90 1/261 4091105 when is a self-managed instance1106 behaves like skips the up migration1107 doesn't calls cleanup_conversion_of_integer_to_bigint method1108# [RSpecRunTime] RSpec elapsed time: 18 minutes 14.13 seconds. Current RSS: ~1343M. load average: 0.98 1.02 0.90 1/261 4101109 when column not exists1110 when is GitLab.com, dev, or test1111 behaves like skips the up migration1112 doesn't calls cleanup_conversion_of_integer_to_bigint method1113# [RSpecRunTime] RSpec elapsed time: 18 minutes 16.87 seconds. Current RSS: ~1345M. load average: 0.98 1.02 0.90 3/261 4111114 when is a self-managed instance1115 behaves like skips the up migration1116 doesn't calls cleanup_conversion_of_integer_to_bigint method1117# [RSpecRunTime] RSpec elapsed time: 18 minutes 19.68 seconds. Current RSS: ~1347M. load average: 0.90 1.00 0.90 1/261 4121118INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree1119INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"1120INFO: "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 rows1121INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_101"1122INFO: "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 rows1123INFO: analyzing "public.p_ci_job_annotations" inheritance tree1124INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"1125INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1126INFO: analyzing "public.p_ci_builds_metadata" inheritance tree1127INFO: analyzing "public.ci_builds_metadata"1128INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1129INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_101"1130INFO: "ci_builds_metadata_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1131INFO: analyzing "public.p_ci_builds" inheritance tree1132INFO: analyzing "public.ci_builds"1133INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1134INFO: analyzing "gitlab_partitions_dynamic.ci_builds_101"1135INFO: "ci_builds_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1136INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree1137INFO: analyzing "public.ci_pipeline_variables"1138INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1139INFO: analyzing "public.p_ci_job_artifacts" inheritance tree1140INFO: analyzing "public.ci_job_artifacts"1141INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1142INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree1143INFO: analyzing "public.ci_pipeline_variables"1144INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1145INFO: analyzing "public.p_ci_stages" inheritance tree1146INFO: analyzing "public.ci_stages"1147INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1148# [RSpecRunTime] Finishing example group spec/migrations/20230801150214_retry_cleanup_bigint_conversion_for_events_for_gitlab_com_spec.rb. It took 1 minute 35.58 seconds. Expected to take 55.79 seconds.1149# [RSpecRunTime] RSpec elapsed time: 19 minutes 2.5 seconds. Current RSS: ~1330M. load average: 0.92 1.00 0.90 1/261 4131150# [RSpecRunTime] Starting example group spec/migrations/20230629095819_queue_backfill_uuid_conversion_column_in_vulnerability_occurrences_spec.rb. Expected to take 47.32 seconds.1151QueueBackfillUuidConversionColumnInVulnerabilityOccurrences1152main: == [advisory_lock_connection] object_id: 208498200, pg_backend_pid: 2811153main: == 20230629095819 QueueBackfillUuidConversionColumnInVulnerabilityOccurrences: migrating 1154main: == 20230629095819 QueueBackfillUuidConversionColumnInVulnerabilityOccurrences: migrated (0.0557s) 1155main: == [advisory_lock_connection] object_id: 208498200, pg_backend_pid: 2811156 schedules a new batched migration1157INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree1158INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"1159INFO: "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 rows1160INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_101"1161INFO: "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 rows1162INFO: analyzing "public.p_ci_job_annotations" inheritance tree1163INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"1164INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1165INFO: analyzing "public.p_ci_builds_metadata" inheritance tree1166INFO: analyzing "public.ci_builds_metadata"1167INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1168INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_101"1169INFO: "ci_builds_metadata_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1170INFO: analyzing "public.p_ci_builds" inheritance tree1171INFO: analyzing "public.ci_builds"1172INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1173INFO: analyzing "gitlab_partitions_dynamic.ci_builds_101"1174INFO: "ci_builds_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1175INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree1176INFO: analyzing "public.ci_pipeline_variables"1177INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1178INFO: analyzing "public.p_ci_job_artifacts" inheritance tree1179INFO: analyzing "public.ci_job_artifacts"1180INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1181INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree1182INFO: analyzing "public.ci_pipeline_variables"1183INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1184INFO: analyzing "public.p_ci_stages" inheritance tree1185INFO: analyzing "public.ci_stages"1186INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1187# [RSpecRunTime] Finishing example group spec/migrations/20230629095819_queue_backfill_uuid_conversion_column_in_vulnerability_occurrences_spec.rb. It took 1 minute 38.26 seconds. Expected to take 47.32 seconds.1188# [RSpecRunTime] RSpec elapsed time: 20 minutes 40.8 seconds. Current RSS: ~1324M. load average: 0.96 0.99 0.91 1/262 4141189# [RSpecRunTime] Starting example group spec/migrations/20230810103534_swap_suggestions_note_id_to_bigint_for_self_hosts_spec.rb. Expected to take 43.45 seconds.1190SwapSuggestionsNoteIdToBigintForSelfHosts1191 #up1192 when GitLab.com, dev, or test1193 does not swap the columns1194# [RSpecRunTime] RSpec elapsed time: 21 minutes 11.97 seconds. Current RSS: ~1315M. load average: 1.07 1.01 0.92 1/262 4151195 when self-managed instance with the columns already swapped1196main: == [advisory_lock_connection] object_id: 226216640, pg_backend_pid: 2971197main: == 20230810103534 SwapSuggestionsNoteIdToBigintForSelfHosts: migrating ========1198main: -- column_exists?("suggestions", "note_id_convert_to_bigint")1199main: -> 0.0034s1200main: -- columns("suggestions")1201main: -> 0.0037s1202main: == 20230810103534 SwapSuggestionsNoteIdToBigintForSelfHosts: migrated (0.0163s) 1203main: == [advisory_lock_connection] object_id: 226216640, pg_backend_pid: 2971204 does not swap the columns1205# [RSpecRunTime] RSpec elapsed time: 21 minutes 14.81 seconds. Current RSS: ~1319M. load average: 1.06 1.01 0.92 1/262 4161206 when self-managed instance with the `note_id_convert_to_bigint` column already dropped1207 does not swap the columns1208# [RSpecRunTime] RSpec elapsed time: 21 minutes 17.9 seconds. Current RSS: ~1313M. load average: 1.06 1.01 0.92 1/262 4171209 when self-managed instance1210 swaps the columns1211# [RSpecRunTime] RSpec elapsed time: 21 minutes 21.23 seconds. Current RSS: ~1314M. load average: 1.06 1.01 0.92 1/262 4181212INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree1213INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"1214INFO: "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 rows1215INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_101"1216INFO: "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 rows1217INFO: analyzing "public.p_ci_job_annotations" inheritance tree1218INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"1219INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1220INFO: analyzing "public.p_ci_builds_metadata" inheritance tree1221INFO: analyzing "public.ci_builds_metadata"1222INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1223INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_101"1224INFO: "ci_builds_metadata_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1225INFO: analyzing "public.p_ci_builds" inheritance tree1226INFO: analyzing "public.ci_builds"1227INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1228INFO: analyzing "gitlab_partitions_dynamic.ci_builds_101"1229INFO: "ci_builds_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1230INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree1231INFO: analyzing "public.ci_pipeline_variables"1232INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1233INFO: analyzing "public.p_ci_job_artifacts" inheritance tree1234INFO: analyzing "public.ci_job_artifacts"1235INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1236INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree1237INFO: analyzing "public.ci_pipeline_variables"1238INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1239INFO: analyzing "public.p_ci_stages" inheritance tree1240INFO: analyzing "public.ci_stages"1241INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1242# [RSpecRunTime] Finishing example group spec/migrations/20230810103534_swap_suggestions_note_id_to_bigint_for_self_hosts_spec.rb. It took 1 minute 22.11 seconds. Expected to take 43.45 seconds.1243# [RSpecRunTime] RSpec elapsed time: 22 minutes 2.95 seconds. Current RSS: ~1331M. load average: 1.03 1.00 0.93 1/262 4191244# [RSpecRunTime] Starting example group spec/migrations/20230807083334_add_linked_items_work_item_widget_spec.rb. Expected to take 40.79 seconds.1245AddLinkedItemsWorkItemWidget1246 behaves like migration that adds widget to work items definitions1247 #up1248main: == [advisory_lock_connection] object_id: 241253680, pg_backend_pid: 3151249main: == 20230807083334 AddLinkedItemsWorkItemWidget: migrating =====================1250main: == 20230807083334 AddLinkedItemsWorkItemWidget: migrated (0.0430s) ============1251main: == [advisory_lock_connection] object_id: 241253680, pg_backend_pid: 3151252 creates widget definition in all types1253main: == [advisory_lock_connection] object_id: 242332140, pg_backend_pid: 3171254main: == 20230807083334 AddLinkedItemsWorkItemWidget: migrating =====================1255main: == 20230807083334 AddLinkedItemsWorkItemWidget: migrated (0.0519s) ============1256main: == [advisory_lock_connection] object_id: 242332140, pg_backend_pid: 3171257 logs a warning if the type is missing1258# [RSpecRunTime] RSpec elapsed time: 22 minutes 37.83 seconds. Current RSS: ~1385M. load average: 0.87 0.97 0.92 1/261 4201259 #down1260main: == [advisory_lock_connection] object_id: 242754260, pg_backend_pid: 3191261main: == 20230807083334 AddLinkedItemsWorkItemWidget: migrating =====================1262main: == 20230807083334 AddLinkedItemsWorkItemWidget: migrated (0.0604s) ============1263main: == [advisory_lock_connection] object_id: 242754260, pg_backend_pid: 3191264 removes definitions for widget1265# [RSpecRunTime] RSpec elapsed time: 22 minutes 40.62 seconds. Current RSS: ~1379M. load average: 0.88 0.97 0.92 1/261 4211266INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree1267INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"1268INFO: "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 rows1269INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_101"1270INFO: "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 rows1271INFO: analyzing "public.p_ci_job_annotations" inheritance tree1272INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"1273INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1274INFO: analyzing "public.p_ci_builds_metadata" inheritance tree1275INFO: analyzing "public.ci_builds_metadata"1276INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1277INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_101"1278INFO: "ci_builds_metadata_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1279INFO: analyzing "public.p_ci_builds" inheritance tree1280INFO: analyzing "public.ci_builds"1281INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1282INFO: analyzing "gitlab_partitions_dynamic.ci_builds_101"1283INFO: "ci_builds_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1284INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree1285INFO: analyzing "public.ci_pipeline_variables"1286INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1287INFO: analyzing "public.p_ci_job_artifacts" inheritance tree1288INFO: analyzing "public.ci_job_artifacts"1289INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1290INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree1291INFO: analyzing "public.ci_pipeline_variables"1292INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1293INFO: analyzing "public.p_ci_stages" inheritance tree1294INFO: analyzing "public.ci_stages"1295INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1296# [RSpecRunTime] Finishing example group spec/migrations/20230807083334_add_linked_items_work_item_widget_spec.rb. It took 1 minute 19.66 seconds. Expected to take 40.79 seconds.1297# [RSpecRunTime] RSpec elapsed time: 23 minutes 22.65 seconds. Current RSS: ~1363M. load average: 1.00 0.99 0.93 1/261 4221298# [RSpecRunTime] Starting example group spec/migrations/20230809170822_ensure_system_note_metadata_bigint_backfill_is_finished_for_self_managed_spec.rb. Expected to take 34.3 seconds.1299EnsureSystemNoteMetadataBigintBackfillIsFinishedForSelfManaged1300 #up1301main: == [advisory_lock_connection] object_id: 256985600, pg_backend_pid: 3301302main: == 20230809170822 EnsureSystemNoteMetadataBigintBackfillIsFinishedForSelfManaged: migrating 1303main: == 20230809170822 EnsureSystemNoteMetadataBigintBackfillIsFinishedForSelfManaged: migrated (0.0078s) 1304main: == [advisory_lock_connection] object_id: 256985600, pg_backend_pid: 3301305 ensures the migration is completed for self-managed instances1306main: == [advisory_lock_connection] object_id: 258088840, pg_backend_pid: 3321307main: == 20230809170822 EnsureSystemNoteMetadataBigintBackfillIsFinishedForSelfManaged: migrating 1308main: == 20230809170822 EnsureSystemNoteMetadataBigintBackfillIsFinishedForSelfManaged: migrated (0.0072s) 1309main: == [advisory_lock_connection] object_id: 258088840, pg_backend_pid: 3321310 skips the check for GitLab.com, dev, or test1311# [RSpecRunTime] RSpec elapsed time: 23 minutes 55.15 seconds. Current RSS: ~1376M. load average: 1.00 0.99 0.93 1/260 4231312INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree1313INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"1314INFO: "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 rows1315INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_101"1316INFO: "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 rows1317INFO: analyzing "public.p_ci_job_annotations" inheritance tree1318INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"1319INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1320INFO: analyzing "public.p_ci_builds_metadata" inheritance tree1321INFO: analyzing "public.ci_builds_metadata"1322INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1323INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_101"1324INFO: "ci_builds_metadata_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1325INFO: analyzing "public.p_ci_builds" inheritance tree1326INFO: analyzing "public.ci_builds"1327INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1328INFO: analyzing "gitlab_partitions_dynamic.ci_builds_101"1329INFO: "ci_builds_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1330INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree1331INFO: analyzing "public.ci_pipeline_variables"1332INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1333INFO: analyzing "public.p_ci_job_artifacts" inheritance tree1334INFO: analyzing "public.ci_job_artifacts"1335INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1336INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree1337INFO: analyzing "public.ci_pipeline_variables"1338INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1339INFO: analyzing "public.p_ci_stages" inheritance tree1340INFO: analyzing "public.ci_stages"1341INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1342# [RSpecRunTime] Finishing example group spec/migrations/20230809170822_ensure_system_note_metadata_bigint_backfill_is_finished_for_self_managed_spec.rb. It took 1 minute 12.45 seconds. Expected to take 34.3 seconds.1343# [RSpecRunTime] RSpec elapsed time: 24 minutes 35.14 seconds. Current RSS: ~1366M. load average: 0.90 0.98 0.93 1/261 4241344# [RSpecRunTime] Starting example group spec/migrations/20240110090352_queue_backfill_partition_id_ci_pipeline_config_spec.rb. Expected to take 32.98 seconds.1345QueueBackfillPartitionIdCiPipelineConfig1346 #up1347 with migration present1348 when migration finished successfully1349ci: == [advisory_lock_connection] object_id: 267566720, pg_backend_pid: 3451350ci: == 20240110090352 QueueBackfillPartitionIdCiPipelineConfig: migrating =========1351ci: == 20240110090352 QueueBackfillPartitionIdCiPipelineConfig: migrated (0.0719s) 1352ci: == [advisory_lock_connection] object_id: 267566720, pg_backend_pid: 3451353 does not raise exception1354ci: == [advisory_lock_connection] object_id: 268934480, pg_backend_pid: 3511355ci: == 20240110090352 QueueBackfillPartitionIdCiPipelineConfig: migrating =========1356ci: == 20240110090352 QueueBackfillPartitionIdCiPipelineConfig: migrated (0.0673s) 1357ci: == [advisory_lock_connection] object_id: 268934480, pg_backend_pid: 3511358 schedules background jobs for each batch of ci_pipelines_config1359# [RSpecRunTime] RSpec elapsed time: 24 minutes 50.11 seconds. Current RSS: ~1382M. load average: 0.93 0.98 0.93 1/261 4251360 #down1361ci: == [advisory_lock_connection] object_id: 269645040, pg_backend_pid: 3571362ci: == 20240110090352 QueueBackfillPartitionIdCiPipelineConfig: migrating =========1363ci: == 20240110090352 QueueBackfillPartitionIdCiPipelineConfig: migrated (0.0742s) 1364ci: == [advisory_lock_connection] object_id: 269645040, pg_backend_pid: 3571365 deletes all batched migration records1366# [RSpecRunTime] RSpec elapsed time: 24 minutes 53.51 seconds. Current RSS: ~1377M. load average: 0.93 0.98 0.93 1/261 4261367INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree1368INFO: analyzing "public.ci_pipeline_variables"1369INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1370INFO: analyzing "public.p_ci_job_artifacts" inheritance tree1371INFO: analyzing "public.ci_job_artifacts"1372INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1373INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree1374INFO: analyzing "public.ci_pipeline_variables"1375INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1376INFO: analyzing "public.p_ci_stages" inheritance tree1377INFO: analyzing "public.ci_stages"1378INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1379# [RSpecRunTime] Finishing example group spec/migrations/20240110090352_queue_backfill_partition_id_ci_pipeline_config_spec.rb. It took 35.5 seconds. Expected to take 32.98 seconds.1380# [RSpecRunTime] RSpec elapsed time: 25 minutes 10.67 seconds. Current RSS: ~1361M. load average: 0.87 0.96 0.93 1/261 4271381# [RSpecRunTime] Starting example group spec/migrations/add_work_items_related_link_restrictions_spec.rb. Expected to take 29.1 seconds.1382AddWorkItemsRelatedLinkRestrictions1383main: == [advisory_lock_connection] object_id: 277514540, pg_backend_pid: 3711384main: == 20231005131445 AddWorkItemsRelatedLinkRestrictions: migrating ==============1385main: == 20231005131445 AddWorkItemsRelatedLinkRestrictions: migrated (0.0385s) =====1386main: == [advisory_lock_connection] object_id: 277514540, pg_backend_pid: 3711387 creates default restrictions1388 when work item types are missing1389main: == [advisory_lock_connection] object_id: 278816120, pg_backend_pid: 3741390main: == 20231005131445 AddWorkItemsRelatedLinkRestrictions: migrating ==============1391main: == 20231005131445 AddWorkItemsRelatedLinkRestrictions: migrated (0.0186s) =====1392main: == [advisory_lock_connection] object_id: 278816120, pg_backend_pid: 3741393 does not add restrictions1394# [RSpecRunTime] RSpec elapsed time: 25 minutes 38.41 seconds. Current RSS: ~1371M. load average: 0.92 0.97 0.93 1/261 4281395INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree1396INFO: analyzing "public.ci_pipeline_variables"1397INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1398INFO: analyzing "public.p_ci_job_artifacts" inheritance tree1399INFO: analyzing "public.ci_job_artifacts"1400INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1401INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree1402INFO: analyzing "public.ci_pipeline_variables"1403INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1404INFO: analyzing "public.p_ci_stages" inheritance tree1405INFO: analyzing "public.ci_stages"1406INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1407# [RSpecRunTime] Finishing example group spec/migrations/add_work_items_related_link_restrictions_spec.rb. It took 1 minute 0.78 second. Expected to take 29.1 seconds.1408# [RSpecRunTime] RSpec elapsed time: 26 minutes 11.49 seconds. Current RSS: ~1358M. load average: 1.04 0.99 0.94 1/261 4291409# [RSpecRunTime] Starting example group spec/migrations/20230905064317_swap_columns_for_ci_pipeline_variables_pipeline_id_bigint_spec.rb. Expected to take 25.11 seconds.1410SwapColumnsForCiPipelineVariablesPipelineIdBigint1411 behaves like swap conversion columns1412main: == [advisory_lock_connection] object_id: 289499040, pg_backend_pid: 3851413main: == 20231017064317 SwapColumnsForCiPipelineVariablesPipelineIdBigint: migrating 1414main: -- execute("LOCK TABLE ci_pipelines, ci_pipeline_variables IN ACCESS EXCLUSIVE MODE")1415main: -> 0.0010s1416main: -- clear_cache!(nil)1417main: -> 0.0000s1418main: -- quote_table_name(:ci_pipeline_variables)1419main: -> 0.0000s1420main: -- quote_column_name(:pipeline_id)1421main: -> 0.0000s1422main: -- quote_column_name(:temp_name_for_renaming)1423main: -> 0.0000s1424main: -- execute("ALTER TABLE \"ci_pipeline_variables\"\n RENAME COLUMN \"pipeline_id\" TO \"temp_name_for_renaming\"\n")1425main: -> 0.0009s1426main: -- clear_cache!(nil)1427main: -> 0.0000s1428main: -- quote_table_name(:ci_pipeline_variables)1429main: -> 0.0000s1430main: -- quote_column_name(:pipeline_id_convert_to_bigint)1431main: -> 0.0000s1432main: -- quote_column_name(:pipeline_id)1433main: -> 0.0000s1434main: -- execute("ALTER TABLE \"ci_pipeline_variables\"\n RENAME COLUMN \"pipeline_id_convert_to_bigint\" TO \"pipeline_id\"\n")1435main: -> 0.0011s1436main: -- clear_cache!(nil)1437main: -> 0.0000s1438main: -- quote_table_name(:ci_pipeline_variables)1439main: -> 0.0000s1440main: -- quote_column_name(:temp_name_for_renaming)1441main: -> 0.0000s1442main: -- quote_column_name(:pipeline_id_convert_to_bigint)1443main: -> 0.0000s1444main: -- execute("ALTER TABLE \"ci_pipeline_variables\"\n RENAME COLUMN \"temp_name_for_renaming\" TO \"pipeline_id_convert_to_bigint\"\n")1445main: -> 0.0009s1446main: -- quote_table_name(:trigger_7f3d66a7d7f5)1447main: -> 0.0000s1448main: -- execute("ALTER FUNCTION \"trigger_7f3d66a7d7f5\" RESET ALL")1449main: -> 0.0009s1450main: -- columns(:ci_pipeline_variables)1451main: -> 0.0038s1452main: -- columns(:ci_pipeline_variables)1453main: -> 0.0036s1454main: -- change_column_default(:ci_pipeline_variables, :pipeline_id, nil)1455main: -> 0.0045s1456main: -- change_column_default(:ci_pipeline_variables, :pipeline_id_convert_to_bigint, "0")1457main: -> 0.0046s1458main: -- quote_table_name(:ci_pipeline_variables)1459main: -> 0.0000s1460main: -- quote_column_name(:fk_f29c5f4380)1461main: -> 0.0000s1462main: -- quote_column_name(:temp_name_for_renaming)1463main: -> 0.0000s1464main: -- execute("ALTER TABLE \"ci_pipeline_variables\"\nRENAME CONSTRAINT \"fk_f29c5f4380\" TO \"temp_name_for_renaming\"\n")1465main: -> 0.0010s1466main: -- quote_table_name(:ci_pipeline_variables)1467main: -> 0.0000s1468main: -- quote_column_name(:temp_fk_rails_8d3b04e3e1)1469main: -> 0.0000s1470main: -- quote_column_name(:fk_f29c5f4380)1471main: -> 0.0000s1472main: -- execute("ALTER TABLE \"ci_pipeline_variables\"\nRENAME CONSTRAINT \"temp_fk_rails_8d3b04e3e1\" TO \"fk_f29c5f4380\"\n")1473main: -> 0.0010s1474main: -- quote_table_name(:ci_pipeline_variables)1475main: -> 0.0000s1476main: -- quote_column_name(:temp_name_for_renaming)1477main: -> 0.0000s1478main: -- quote_column_name(:temp_fk_rails_8d3b04e3e1)1479main: -> 0.0000s1480main: -- execute("ALTER TABLE \"ci_pipeline_variables\"\nRENAME CONSTRAINT \"temp_name_for_renaming\" TO \"temp_fk_rails_8d3b04e3e1\"\n")1481main: -> 0.0009s1482main: -- quote_table_name("index_ci_pipeline_variables_on_pipeline_id_and_key")1483main: -> 0.0000s1484main: -- quote_table_name("temp_08b4f3fae3")1485main: -> 0.0000s1486main: -- execute("ALTER INDEX \"index_ci_pipeline_variables_on_pipeline_id_and_key\" RENAME TO \"temp_08b4f3fae3\"")1487main: -> 0.0012s1488main: -- quote_table_name("index_ci_pipeline_variables_on_pipeline_id_bigint_and_key")1489main: -> 0.0000s1490main: -- quote_table_name(:index_ci_pipeline_variables_on_pipeline_id_and_key)1491main: -> 0.0000s1492main: -- execute("ALTER INDEX \"index_ci_pipeline_variables_on_pipeline_id_bigint_and_key\" RENAME TO \"index_ci_pipeline_variables_on_pipeline_id_and_key\"")1493main: -> 0.0009s1494main: -- quote_table_name("temp_08b4f3fae3")1495main: -> 0.0000s1496main: -- quote_table_name(:index_ci_pipeline_variables_on_pipeline_id_bigint_and_key)1497main: -> 0.0000s1498main: -- execute("ALTER INDEX \"temp_08b4f3fae3\" RENAME TO \"index_ci_pipeline_variables_on_pipeline_id_bigint_and_key\"")1499main: -> 0.0009s1500main: == 20231017064317 SwapColumnsForCiPipelineVariablesPipelineIdBigint: migrated (0.0427s) 1501main: == [advisory_lock_connection] object_id: 289499040, pg_backend_pid: 3851502 correctly swaps conversion columns1503# [RSpecRunTime] RSpec elapsed time: 26 minutes 36.35 seconds. Current RSS: ~1353M. load average: 1.09 1.01 0.95 1/261 4301504INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree1505INFO: analyzing "public.ci_pipeline_variables"1506INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1507INFO: analyzing "public.p_ci_job_artifacts" inheritance tree1508INFO: analyzing "public.ci_job_artifacts"1509INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1510INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree1511INFO: analyzing "public.ci_pipeline_variables"1512INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1513INFO: analyzing "public.p_ci_stages" inheritance tree1514INFO: analyzing "public.ci_stages"1515INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1516# [RSpecRunTime] Finishing example group spec/migrations/20230905064317_swap_columns_for_ci_pipeline_variables_pipeline_id_bigint_spec.rb. It took 55.95 seconds. Expected to take 25.11 seconds.1517# [RSpecRunTime] RSpec elapsed time: 27 minutes 7.47 seconds. Current RSS: ~1347M. load average: 1.00 0.99 0.94 1/261 4311518# [RSpecRunTime] Starting example group spec/migrations/20231214111617_queue_backfill_owasp_top_ten_of_vulnerability_reads_spec.rb. Expected to take 14.71 seconds.1519QueueBackfillOwaspTopTenOfVulnerabilityReads1520main: == [advisory_lock_connection] object_id: 298755700, pg_backend_pid: 3961521main: == 20231214111617 QueueBackfillOwaspTopTenOfVulnerabilityReads: migrating =====1522main: == 20231214111617 QueueBackfillOwaspTopTenOfVulnerabilityReads: migrated (0.0574s) 1523main: == [advisory_lock_connection] object_id: 298755700, pg_backend_pid: 3961524 schedules a new batched migration1525INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree1526INFO: analyzing "public.ci_pipeline_variables"1527INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1528INFO: analyzing "public.p_ci_job_artifacts" inheritance tree1529INFO: analyzing "public.ci_job_artifacts"1530INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1531INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree1532INFO: analyzing "public.ci_pipeline_variables"1533INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1534INFO: analyzing "public.p_ci_stages" inheritance tree1535INFO: analyzing "public.ci_stages"1536INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1537# [RSpecRunTime] Finishing example group spec/migrations/20231214111617_queue_backfill_owasp_top_ten_of_vulnerability_reads_spec.rb. It took 36.38 seconds. Expected to take 14.71 seconds.1538# [RSpecRunTime] RSpec elapsed time: 27 minutes 43.89 seconds. Current RSS: ~1338M. load average: 1.00 1.00 0.95 1/261 4321539# [RSpecRunTime] Starting example group spec/migrations/20240113071052_queue_populate_topics_slug_column_spec.rb. Expected to take 11.5 seconds.1540QueuePopulateTopicsSlugColumn1541main: == [advisory_lock_connection] object_id: 304565720, pg_backend_pid: 4071542main: == 20240113071052 QueuePopulateTopicsSlugColumn: migrating ====================1543main: == 20240113071052 QueuePopulateTopicsSlugColumn: migrated (0.0483s) ===========1544main: == [advisory_lock_connection] object_id: 304565720, pg_backend_pid: 4071545 schedules a new batched migration1546INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree1547INFO: analyzing "public.ci_pipeline_variables"1548INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1549INFO: analyzing "public.p_ci_job_artifacts" inheritance tree1550INFO: analyzing "public.ci_job_artifacts"1551INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1552INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree1553INFO: analyzing "public.ci_pipeline_variables"1554INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1555INFO: analyzing "public.p_ci_stages" inheritance tree1556INFO: analyzing "public.ci_stages"1557INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1558# [RSpecRunTime] Finishing example group spec/migrations/20240113071052_queue_populate_topics_slug_column_spec.rb. It took 29.14 seconds. Expected to take 11.5 seconds.1559# [RSpecRunTime] RSpec elapsed time: 28 minutes 13.07 seconds. Current RSS: ~1336M. load average: 0.94 0.98 0.94 1/261 4331560auto_explain log contains 938 entries for main, writing to /builds/gitlab-org/gitlab/auto_explain/rspec-migration-pg14-single-db-ci-connection-5-15.337.main.ndjson.gz1561took 17.1045181531562auto_explain log contains 938 entries for ci, writing to /builds/gitlab-org/gitlab/auto_explain/rspec-migration-pg14-single-db-ci-connection-5-15.337.ci.ndjson.gz1563took 15.2282679551564[TEST PROF INFO] EventProf results for sql.active_record1565Total time: 20:44.440 of 28:07.953 (73.72%)1566Total events: 7634861567Top 5 slowest suites (by time):1568SwapColumnsCi...gIntConversion (./spec/migrations/20230220102212_swap_columns_ci_build_needs_big_int_conversion_spec.rb:6) – 02:10.930 (83588 / 8) of 03:08.724 (69.38%)1569RemoveUserNam...VsaAggregation (./spec/migrations/20230322085041_remove_user_namespace_records_from_vsa_aggregation_spec.rb:6) – 02:07.133 (65943 / 2) of 02:45.183 (76.96%)1570SwapSuggestio...orGitlabDotCom (./spec/migrations/swap_suggestions_note_id_to_bigint_for_gitlab_dot_com_spec.rb:6) – 02:05.805 (64291 / 2) of 02:43.938 (76.74%)1571EnsureMergeRe...orGitlabDotCom (./spec/migrations/ensure_merge_request_metrics_id_bigint_backfill_is_finished_for_gitlab_dot_com_spec.rb:6) – 02:02.920 (67784 / 2) of 02:44.349 (74.79%)1572RemoveSamlPro...esNonRootGroup (./spec/migrations/remove_saml_provider_and_identities_non_root_group_spec.rb:6) – 02:00.348 (61405 / 1) of 02:36.254 (77.02%)1573Knapsack report was generated. Preview:1574{1575 "spec/migrations/20230220102212_swap_columns_ci_build_needs_big_int_conversion_spec.rb": 98.59120186500002,1576 "spec/migrations/ensure_merge_request_metrics_id_bigint_backfill_is_finished_for_gitlab_dot_com_spec.rb": 74.99105335300004,1577 "spec/migrations/remove_saml_provider_and_identities_non_root_group_spec.rb": 70.64308034400005,1578 "spec/migrations/swap_suggestions_note_id_to_bigint_for_gitlab_dot_com_spec.rb": 75.663172669,1579 "spec/migrations/20230322085041_remove_user_namespace_records_from_vsa_aggregation_spec.rb": 77.92687923999995,1580 "spec/migrations/20230406121544_queue_backfill_design_management_repositories_spec.rb": 71.56366048299992,1581 "spec/migrations/20230518071251_queue_backfill_code_suggestions_namespace_settings_spec.rb": 53.6583861470001,1582 "spec/migrations/20230801150214_retry_cleanup_bigint_conversion_for_events_for_gitlab_com_spec.rb": 52.86622328499993,1583 "spec/migrations/20230629095819_queue_backfill_uuid_conversion_column_in_vulnerability_occurrences_spec.rb": 41.573573735999844,1584 "spec/migrations/20230810103534_swap_suggestions_note_id_to_bigint_for_self_hosts_spec.rb": 40.49614082899984,1585 "spec/migrations/20230807083334_add_linked_items_work_item_widget_spec.rb": 37.75285122300011,1586 "spec/migrations/20230809170822_ensure_system_note_metadata_bigint_backfill_is_finished_for_self_managed_spec.rb": 32.56737784400002,1587 "spec/migrations/20240110090352_queue_backfill_partition_id_ci_pipeline_config_spec.rb": 18.452860636999958,1588 "spec/migrations/add_work_items_related_link_restrictions_spec.rb": 27.81761217999997,1589 "spec/migrations/20230905064317_swap_columns_for_ci_pipeline_variables_pipeline_id_bigint_spec.rb": 24.93318701399994,1590 "spec/migrations/20231214111617_queue_backfill_owasp_top_ten_of_vulnerability_reads_spec.rb": 15.20453501499992,1591 "spec/migrations/20240113071052_queue_populate_topics_slug_column_spec.rb": 12.1697383129999251592}1593Knapsack global time execution for tests: 13m 46s1594Finished in 28 minutes 46 seconds (files took 56.43 seconds to load)159543 examples, 0 failures1596Randomized with seed 396941597[TEST PROF INFO] Time spent in factories: 00:00.270 (0.02% of total time)1598RSpec exited with 0.1599No examples to retry, congrats!1601Running after script...1602$ echo -e "\e[0Ksection_start:`date +%s`:report_results_section[collapsed=true]\r\e[0KReport results"1613$ tooling/bin/push_job_metrics || true1614[job-metrics] Pushing job metrics file for the CI/CD job.1615[job-metrics] Pushed 4 CI job metric entries to InfluxDB.1617Not uploading cache ruby-gems-debian-bookworm-ruby-3.1-17 due to policy1619Uploading artifacts...1620auto_explain/: found 3 matching artifact files and directories 1621coverage/: found 5 matching artifact files and directories 1622crystalball/: found 2 matching artifact files and directories 1623WARNING: deprecations/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab) 1624knapsack/: found 4 matching artifact files and directories 1625rspec/: found 16 matching artifact files and directories 1626WARNING: tmp/capybara/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab) 1627log/*.log: found 13 matching artifact files and directories 1628WARNING: Upload request redirected location=https://gitlab.com/api/v4/jobs/6311411195/artifacts?artifact_format=zip&artifact_type=archive&expire_in=31d new-url=https://gitlab.com1629WARNING: Retrying... context=artifacts-uploader error=request redirected1630Uploading artifacts as "archive" to coordinator... 201 Created id=6311411195 responseStatus=201 Created token=glcbt-651631Uploading artifacts...1632rspec/rspec-*.xml: found 1 matching artifact files and directories 1633WARNING: Upload request redirected location=https://gitlab.com/api/v4/jobs/6311411195/artifacts?artifact_format=gzip&artifact_type=junit&expire_in=31d new-url=https://gitlab.com1634WARNING: Retrying... context=artifacts-uploader error=request redirected1635Uploading artifacts as "junit" to coordinator... 201 Created id=6311411195 responseStatus=201 Created token=glcbt-651637Job succeeded