rspec migration pg14 single-db-ci-connection 1/8
Passed Started
by
@vshushlin
Vladimir Shushlin
1Running with gitlab-runner 16.3.0~beta.108.g2b6048b4 (2b6048b4)2 on blue-3.private.runners-manager.gitlab.com/gitlab.com/gitlab-org 6io2xoDD, system ID: s_8f94f77602233 feature flags: FF_NETWORK_PER_BUILD:true, FF_USE_FASTZIP:true, FF_USE_IMPROVED_URL_MASKING:true, FF_RESOLVE_FULL_TLS_CHAIN:false6Using Docker executor with image registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bullseye-ruby-3.0.patched-golang-1.20-rust-1.65-node-18.17-postgresql-14:rubygems-3.4-git-2.36-lfs-2.9-chrome-113-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:6c7370fd46a94d5beaed2a0304c7518e74a5759d4da3322ea9f7052507f51d80 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:1b39aac95406782d786043ec3f1772c0a3a5ce1b9ce28cf001cac9a290f366c8 ...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:f4c047edb00d9bbfcc2b002a01548fab14592940f5b3e6b3f227f690e3fa272d 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:9a1b6b68dc464f0baae914703d5b059e7773bf23c9579c44e2a1b1154a83656f ...17Starting service redis:6.2-alpine ...18Pulling docker image redis:6.2-alpine ...19Using docker image sha256:9b4dc93acb797b99419bb31d8a452680508f1bf10a8604d721c0474072417a2b for redis:6.2-alpine with digest redis@sha256:452b7655bda0e270a6376b71d22fcb30662e745dcb4728f99fa87f01287b465d ...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-bullseye-ruby-3.0.patched-golang-1.20-rust-1.65-node-18.17-postgresql-14:rubygems-3.4-git-2.36-lfs-2.9-chrome-113-yarn-1.22-graphicsmagick-1.3.36 ...23Using docker image sha256:d68252162deca904d1a0066983188b98dfe3f6fe8181458b0a55905e79ed85a1 for registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bullseye-ruby-3.0.patched-golang-1.20-rust-1.65-node-18.17-postgresql-14:rubygems-3.4-git-2.36-lfs-2.9-chrome-113-yarn-1.22-graphicsmagick-1.3.36 with digest registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bullseye-ruby-3.0.patched-golang-1.20-rust-1.65-node-18.17-postgresql-14@sha256:2113f34affc7e2ee40bac87419dcd7c65a94d4abfa9edb86192e1aa6a1e46590 ...25Running on runner-6io2xodd-project-278964-concurrent-0 via runner-6io2xodd-private-1697785803-bd62e396...27Fetching changes with git depth set to 20...28Initialized empty Git repository in /builds/gitlab-org/gitlab/.git/29Created fresh repository.30remote: Enumerating objects: 148580, done. 31remote: Counting objects: 100% (148580/148580), done. 32remote: Compressing objects: 100% (104624/104624), done. 33remote: Total 148580 (delta 64637), reused 94927 (delta 38178), pack-reused 0 34Receiving objects: 100% (148580/148580), 135.67 MiB | 31.09 MiB/s, done.35Resolving deltas: 100% (64637/64637), done.37 * [new ref] refs/pipelines/1043537122 -> refs/pipelines/104353712238Checking out 537c07c6 as detached HEAD (ref is refs/merge-requests/118829/merge)...39Skipping Git submodules setup40$ git remote set-url origin "${CI_REPOSITORY_URL}"42Checking cache for ruby-gems-debian-bullseye-ruby-3.0-16...43cache.zip is up to date 44Successfully extracted cache46Downloading artifacts for compile-test-assets (5336650410)...47Downloading artifacts from coordinator... ok host=storage.googleapis.com id=5336650410 responseStatus=200 OK token=64_XzJnF48Downloading artifacts for detect-tests (5336650454)...49Downloading artifacts from coordinator... ok host=storage.googleapis.com id=5336650454 responseStatus=200 OK token=64_XzJnF50Downloading artifacts for retrieve-tests-metadata (5336650473)...51Downloading artifacts from coordinator... ok host=storage.googleapis.com id=5336650473 responseStatus=200 OK token=64_XzJnF52Downloading artifacts for setup-test-env (5336650424)...53Downloading artifacts from coordinator... ok host=storage.googleapis.com id=5336650424 responseStatus=200 OK token=64_XzJnF55Using docker image sha256:d68252162deca904d1a0066983188b98dfe3f6fe8181458b0a55905e79ed85a1 for registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bullseye-ruby-3.0.patched-golang-1.20-rust-1.65-node-18.17-postgresql-14:rubygems-3.4-git-2.36-lfs-2.9-chrome-113-yarn-1.22-graphicsmagick-1.3.36 with digest registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bullseye-ruby-3.0.patched-golang-1.20-rust-1.65-node-18.17-postgresql-14@sha256:2113f34affc7e2ee40bac87419dcd7c65a94d4abfa9edb86192e1aa6a1e46590 ...56$ echo $FOSS_ONLY57$ [ "$FOSS_ONLY" = "1" ] && rm -rf ee/ qa/spec/ee/ qa/qa/specs/features/ee/ qa/qa/ee/ qa/qa/ee.rb58$ export GOPATH=$CI_PROJECT_DIR/.go59$ mkdir -p $GOPATH60$ source scripts/utils.sh61$ source scripts/prepare_build.sh93Using two connections, single database config (config/database.yml.postgresql)94Geo DB won't be set up.95Embedding DB won't be set up.116$ source ./scripts/rspec_helpers.sh117$ run_timed_command "gem install knapsack --no-document"118$ gem install knapsack --no-document119Successfully installed knapsack-4.0.01201 gem installed121==> 'gem install knapsack --no-document' succeeded in 1 seconds.122$ section_start "gitaly-test-spawn" "Spawning Gitaly"; scripts/gitaly-test-spawn; section_end "gitaly-test-spawn"127$ export RSPEC_SKIPPED_TESTS_REPORT_PATH="rspec/skipped_tests-${CI_JOB_ID}.txt"128$ export RSPEC_RETRIED_TESTS_REPORT_PATH="rspec/retried_tests-${CI_JOB_ID}.txt"129$ tooling/bin/create_job_metrics_file || true130[job-metrics] Creating the job metrics file for the CI/CD job.131$ rspec_paralellized_job "--fail-fast=${RSPEC_FAIL_FAST_THRESHOLD} --tag ~quarantine --tag ~zoekt --tag ~click_house"132RETRY_FAILED_TESTS_IN_NEW_PROCESS: true133KNAPSACK_GENERATE_REPORT: true134FLAKY_RSPEC_GENERATE_REPORT: true135KNAPSACK_TEST_FILE_PATTERN: spec/{migrations}{,/**/}*_spec.rb136KNAPSACK_LOG_LEVEL: debug137KNAPSACK_REPORT_PATH: knapsack/rspec_migration_pg14_single-db-ci-connection_1_8_report.json138FLAKY_RSPEC_SUITE_REPORT_PATH: rspec/flaky/report-suite.json139FLAKY_RSPEC_REPORT_PATH: rspec/flaky/all_rspec_migration_pg14_single-db-ci-connection_1_8_report.json140NEW_FLAKY_RSPEC_REPORT_PATH: rspec/flaky/new_rspec_migration_pg14_single-db-ci-connection_1_8_report.json141RSPEC_SKIPPED_TESTS_REPORT_PATH: rspec/skipped_tests-5336650726.txt142CRYSTALBALL: 143RSPEC_TESTS_MAPPING_ENABLED: 144RSPEC_TESTS_FILTER_FILE: 145Shell set options (set -o) enabled:146braceexpand on147hashall on148interactive-comments on149pipefail on150Knapsack report generator started!151/builds/gitlab-org/gitlab/ee/app/services/remote_development/service_response_factory.rb:41: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!152/builds/gitlab-org/gitlab/ee/app/services/remote_development/workspaces/create_service.rb:28: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!153/builds/gitlab-org/gitlab/ee/app/services/remote_development/workspaces/reconcile_service.rb:38: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!154/builds/gitlab-org/gitlab/ee/app/services/remote_development/workspaces/update_service.rb:28: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!155/builds/gitlab-org/gitlab/ee/lib/remote_development/agent_config/main.rb:32: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!156/builds/gitlab-org/gitlab/ee/lib/remote_development/agent_config/updater.rb:11: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!157/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/authorizer.rb:12: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!158/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/authorizer.rb:13: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!159/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/creator.rb:15: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!160/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/creator.rb:19: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!161/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/devfile_fetcher.rb:15: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!162/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/devfile_fetcher.rb:16: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!163/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/devfile_flattener.rb:12: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!164/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/editor_component_injector.rb:12: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!165/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/editor_component_injector.rb:17: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!166/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/editor_component_injector.rb:18: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!167/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/personal_access_token_creator.rb:12: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!168/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/personal_access_token_creator.rb:17: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!169/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/post_flatten_devfile_validator.rb:43: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!170/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/post_flatten_devfile_validator.rb:54: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!171/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/post_flatten_devfile_validator.rb:102: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!172/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/post_flatten_devfile_validator.rb:126: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!173/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/post_flatten_devfile_validator.rb:159: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!174/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/post_flatten_devfile_validator.rb:202: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!175/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/post_flatten_devfile_validator.rb:235: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!176/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/pre_flatten_devfile_validator.rb:24: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!177/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/pre_flatten_devfile_validator.rb:52: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!178/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/project_cloner_component_injector.rb:12: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!179/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/project_cloner_component_injector.rb:17: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!180/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/project_cloner_component_injector.rb:18: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!181/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/project_cloner_component_injector.rb:23: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!182/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/volume_component_injector.rb:12: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!183/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/volume_component_injector.rb:13: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!184/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/volume_component_injector.rb:14: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!185/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/workspace_creator.rb:15: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!186/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/workspace_creator.rb:24: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!187/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/workspace_creator.rb:25: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!188/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/workspace_creator.rb:28: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!189/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/workspace_variables_creator.rb:12: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!190/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/reconcile/main.rb:43: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!191/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/update/authorizer.rb:12: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!192/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/update/updater.rb:13: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!193/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/reconcile/input/agent_infos_observer.rb:15: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!194/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/reconcile/input/params_extractor.rb:14: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!195/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/reconcile/input/params_extractor.rb:16: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!196/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/reconcile/input/params_to_infos_converter.rb:14: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!197/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/reconcile/input/params_validator.rb:15: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!198/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/reconcile/output/rails_infos_observer.rb:11: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!199/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/reconcile/output/workspaces_to_rails_infos_converter.rb:15: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!200/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/reconcile/persistence/orphaned_workspaces_observer.rb:12: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!201/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/reconcile/persistence/workspaces_from_agent_infos_updater.rb:15: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!202/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/reconcile/persistence/workspaces_to_be_returned_finder.rb:16: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!203/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/reconcile/persistence/workspaces_to_be_returned_updater.rb:11: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!204Run options: exclude {:quarantine=>true, :zoekt=>true, :click_house=>true}205Test environment set up in 0.477162393 seconds206CreateNextCiPartitionsRecord207 # order random208 #up209 when on sass210ci: == [advisory_lock_connection] object_id: 10463040, pg_backend_pid: 124211ci: == 20221102090940 CreateNextCiPartitionsRecord: migrating =====================212ci: -- execute("INSERT INTO \"ci_partitions\" (\"id\", \"created_at\", \"updated_at\")\n VALUES (101, now(), now())\n ON CONFLICT DO NOTHING;\n")213ci: -> 0.0016s214ci: -- reset_pk_sequence!("ci_partitions")215ci: -> 0.0062s216ci: -> 101 rows217ci: == 20221102090940 CreateNextCiPartitionsRecord: migrated (0.0084s) ============218ci: == [advisory_lock_connection] object_id: 10463040, pg_backend_pid: 124219 creates next partitions record and resets the sequence220 when self-managed221ci: == [advisory_lock_connection] object_id: 11240400, pg_backend_pid: 129222ci: == 20221102090940 CreateNextCiPartitionsRecord: migrating =====================223ci: == 20221102090940 CreateNextCiPartitionsRecord: migrated (0.0003s) ============224ci: == [advisory_lock_connection] object_id: 11240400, pg_backend_pid: 129225 does not create records226 #down227 when on sass228ci: == [advisory_lock_connection] object_id: 11501260, pg_backend_pid: 133229ci: == 20221102090940 CreateNextCiPartitionsRecord: migrating =====================230ci: -- execute("INSERT INTO \"ci_partitions\" (\"id\", \"created_at\", \"updated_at\")\n VALUES (101, now(), now())\n ON CONFLICT DO NOTHING;\n")231ci: -> 0.0014s232ci: -- reset_pk_sequence!("ci_partitions")233ci: -> 0.0062s234ci: -> 101 rows235ci: == 20221102090940 CreateNextCiPartitionsRecord: migrated (0.0081s) ============236ci: == [advisory_lock_connection] object_id: 11501260, pg_backend_pid: 133237ci: -- execute("DELETE FROM \"ci_partitions\"\n WHERE \"ci_partitions\".\"id\" = 101;\n")238ci: -> 0.0013s239 removes the record240 when self-managed241ci: == [advisory_lock_connection] object_id: 11760100, pg_backend_pid: 137242ci: == 20221102090940 CreateNextCiPartitionsRecord: migrating =====================243ci: -- execute("INSERT INTO \"ci_partitions\" (\"id\", \"created_at\", \"updated_at\")\n VALUES (101, now(), now())\n ON CONFLICT DO NOTHING;\n")244ci: -> 0.0014s245ci: -- reset_pk_sequence!("ci_partitions")246ci: -> 0.0058s247ci: -> 101 rows248ci: == 20221102090940 CreateNextCiPartitionsRecord: migrated (0.0077s) ============249ci: == [advisory_lock_connection] object_id: 11760100, pg_backend_pid: 137250 does not remove the record251INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree252INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"253INFO: "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 rows254INFO: analyzing "public.p_ci_job_annotations" inheritance tree255INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"256INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows257INFO: analyzing "public.p_ci_builds_metadata" inheritance tree258INFO: analyzing "public.ci_builds_metadata"259INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows260INFO: analyzing "public.p_ci_builds" inheritance tree261INFO: analyzing "public.ci_builds"262INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows263AddDefaultPreferredLanguageToApplicationSettings264 # order random265 #up266main: == [advisory_lock_connection] object_id: 37721480, pg_backend_pid: 150267main: == 20221101032521 AddDefaultPreferredLanguageToApplicationSettings: migrating =268main: -- add_column(:application_settings, :default_preferred_language, :text, {:default=>"en", :null=>false})269main: -> 0.0097s270main: == 20221101032521 AddDefaultPreferredLanguageToApplicationSettings: migrated (0.0103s) 271main: == [advisory_lock_connection] object_id: 37721480, pg_backend_pid: 150272 allows to read default_preferred_language field273 #down274main: == [advisory_lock_connection] object_id: 38499980, pg_backend_pid: 152275main: == 20221101032521 AddDefaultPreferredLanguageToApplicationSettings: migrating =276main: -- add_column(:application_settings, :default_preferred_language, :text, {:default=>"en", :null=>false})277main: -> 0.0042s278main: == 20221101032521 AddDefaultPreferredLanguageToApplicationSettings: migrated (0.0046s) 279main: == [advisory_lock_connection] object_id: 38499980, pg_backend_pid: 152280 deletes default_preferred_language field281INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree282INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"283INFO: "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 rows284INFO: analyzing "public.p_ci_job_annotations" inheritance tree285INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"286INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows287INFO: analyzing "public.p_ci_builds_metadata" inheritance tree288INFO: analyzing "public.ci_builds_metadata"289INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows290INFO: analyzing "public.p_ci_builds" inheritance tree291INFO: analyzing "public.ci_builds"292INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows293CleanupVulnerabilityStateTransitionsWithSameFromStateToState294 # order random295main: == [advisory_lock_connection] object_id: 64997600, pg_backend_pid: 167296main: == 20221013215832 CleanupVulnerabilityStateTransitionsWithSameFromStateToState: migrating 297main: == 20221013215832 CleanupVulnerabilityStateTransitionsWithSameFromStateToState: migrated (0.0022s) 298main: == [advisory_lock_connection] object_id: 64997600, pg_backend_pid: 167299 deletes state transitions with no state change300INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree301INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"302INFO: "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 rows303INFO: analyzing "public.p_ci_job_annotations" inheritance tree304INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"305INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows306INFO: analyzing "public.p_ci_builds_metadata" inheritance tree307INFO: analyzing "public.ci_builds_metadata"308INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows309INFO: analyzing "public.p_ci_builds" inheritance tree310INFO: analyzing "public.ci_builds"311INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows312BumpDefaultPartitionIdValueForCiTables313 # order random314 when self-managed315main: == [advisory_lock_connection] object_id: 91288900, pg_backend_pid: 180316main: == 20221220131020 BumpDefaultPartitionIdValueForCiTables: migrating ===========317main: == 20221220131020 BumpDefaultPartitionIdValueForCiTables: migrated (0.0074s) ==318main: == [advisory_lock_connection] object_id: 91288900, pg_backend_pid: 180319 does not change default values320 when on sass321main: == [advisory_lock_connection] object_id: 92001760, pg_backend_pid: 183322main: == 20221220131020 BumpDefaultPartitionIdValueForCiTables: migrating ===========323main: -- change_column_default(:ci_build_needs, :partition_id, {:from=>100, :to=>101})324main: -> 0.0045s325main: -- change_column_default(:ci_build_pending_states, :partition_id, {:from=>100, :to=>101})326main: -> 0.0043s327main: -- change_column_default(:ci_build_report_results, :partition_id, {:from=>100, :to=>101})328main: -> 0.0041s329main: -- change_column_default(:ci_build_trace_chunks, :partition_id, {:from=>100, :to=>101})330main: -> 0.0041s331main: -- change_column_default(:ci_build_trace_metadata, :partition_id, {:from=>100, :to=>101})332main: -> 0.0043s333main: -- change_column_default(:ci_builds, :partition_id, {:from=>100, :to=>101})334main: -> 0.0069s335main: -- change_column_default(:ci_builds_runner_session, :partition_id, {:from=>100, :to=>101})336main: -> 0.0043s337main: -- change_column_default(:ci_job_artifacts, :partition_id, {:from=>100, :to=>101})338main: -> 0.0055s339main: -- change_column_default(:ci_job_variables, :partition_id, {:from=>100, :to=>101})340main: -> 0.0042s341main: -- change_column_default(:ci_pending_builds, :partition_id, {:from=>100, :to=>101})342main: -> 0.0044s343main: -- change_column_default(:ci_pipeline_variables, :partition_id, {:from=>100, :to=>101})344main: -> 0.0050s345main: -- change_column_default(:ci_pipelines, :partition_id, {:from=>100, :to=>101})346main: -> 0.0055s347main: -- change_column_default(:ci_running_builds, :partition_id, {:from=>100, :to=>101})348main: -> 0.0042s349main: -- change_column_default(:ci_sources_pipelines, :partition_id, {:from=>100, :to=>101})350main: -> 0.0068s351main: -- change_column_default(:ci_sources_pipelines, :source_partition_id, {:from=>100, :to=>101})352main: -> 0.0054s353main: -- change_column_default(:ci_stages, :partition_id, {:from=>100, :to=>101})354main: -> 0.0045s355main: -- change_column_default(:ci_unit_test_failures, :partition_id, {:from=>100, :to=>101})356main: -> 0.0041s357main: -- change_column_default(:p_ci_builds_metadata, :partition_id, {:from=>100, :to=>101})358main: -> 0.0059s359main: == 20221220131020 BumpDefaultPartitionIdValueForCiTables: migrated (0.2280s) ==360main: == [advisory_lock_connection] object_id: 92001760, pg_backend_pid: 183361 changes default values362 with tables already changed363main: == [advisory_lock_connection] object_id: 92713540, pg_backend_pid: 186364main: == 20221220131020 BumpDefaultPartitionIdValueForCiTables: migrating ===========365main: -- change_column_default(:ci_build_needs, :partition_id, {:from=>100, :to=>101})366main: -> 0.0046s367main: -- change_column_default(:ci_build_pending_states, :partition_id, {:from=>100, :to=>101})368main: -> 0.0045s369main: -- change_column_default(:ci_build_report_results, :partition_id, {:from=>100, :to=>101})370main: -> 0.0043s371main: -- change_column_default(:ci_build_trace_chunks, :partition_id, {:from=>100, :to=>101})372main: -> 0.0055s373main: -- change_column_default(:ci_build_trace_metadata, :partition_id, {:from=>100, :to=>101})374main: -> 0.0043s375main: -- change_column_default(:ci_builds_runner_session, :partition_id, {:from=>100, :to=>101})376main: -> 0.0048s377main: -- change_column_default(:ci_job_artifacts, :partition_id, {:from=>100, :to=>101})378main: -> 0.0048s379main: -- change_column_default(:ci_job_variables, :partition_id, {:from=>100, :to=>101})380main: -> 0.0046s381main: -- change_column_default(:ci_pending_builds, :partition_id, {:from=>100, :to=>101})382main: -> 0.0045s383main: -- change_column_default(:ci_pipeline_variables, :partition_id, {:from=>100, :to=>101})384main: -> 0.0069s385main: -- change_column_default(:ci_pipelines, :partition_id, {:from=>100, :to=>101})386main: -> 0.0066s387main: -- change_column_default(:ci_running_builds, :partition_id, {:from=>100, :to=>101})388main: -> 0.0051s389main: -- change_column_default(:ci_sources_pipelines, :partition_id, {:from=>100, :to=>101})390main: -> 0.0054s391main: -- change_column_default(:ci_sources_pipelines, :source_partition_id, {:from=>100, :to=>101})392main: -> 0.0050s393main: -- change_column_default(:ci_stages, :partition_id, {:from=>100, :to=>101})394main: -> 0.0052s395main: -- change_column_default(:ci_unit_test_failures, :partition_id, {:from=>100, :to=>101})396main: -> 0.0048s397main: -- change_column_default(:p_ci_builds_metadata, :partition_id, {:from=>100, :to=>101})398main: -> 0.0049s399main: == 20221220131020 BumpDefaultPartitionIdValueForCiTables: migrated (0.2348s) ==400main: == [advisory_lock_connection] object_id: 92713540, pg_backend_pid: 186401 skips updating already changed tables402INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree403INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"404INFO: "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 rows405INFO: analyzing "public.p_ci_job_annotations" inheritance tree406INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"407INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows408INFO: analyzing "public.p_ci_builds_metadata" inheritance tree409INFO: analyzing "public.ci_builds_metadata"410INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows411INFO: analyzing "public.p_ci_builds" inheritance tree412INFO: analyzing "public.ci_builds"413INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows414QueueBackfillUserDetailsFields415 # order random416main: == [advisory_lock_connection] object_id: 118105880, pg_backend_pid: 201417main: == 20221019002459 QueueBackfillUserDetailsFields: migrating ===================418main: == 20221019002459 QueueBackfillUserDetailsFields: migrated (0.0525s) ==========419main: == [advisory_lock_connection] object_id: 118105880, pg_backend_pid: 201420 schedules a new batched migration421INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree422INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"423INFO: "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 rows424INFO: analyzing "public.p_ci_job_annotations" inheritance tree425INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"426INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows427INFO: analyzing "public.p_ci_builds_metadata" inheritance tree428INFO: analyzing "public.ci_builds_metadata"429INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows430INFO: analyzing "public.p_ci_builds" inheritance tree431INFO: analyzing "public.ci_builds"432INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows433AddObjectiveAndKeyresultToWorkItemTypes434 # order random435main: == [advisory_lock_connection] object_id: 145541780, pg_backend_pid: 216436main: == 20221018050323 AddObjectiveAndKeyresultToWorkItemTypes: migrating ==========437main: -- execute("INSERT INTO work_item_types (base_type, icon_name, name, created_at, updated_at) VALUES(\n 5, 'issue-type-objective', 'Objective', NOW(), NOW()\n ) ON CONFLICT DO NOTHING;\n")438main: -> 0.0014s439main: -- execute("INSERT INTO work_item_types (base_type, icon_name, name, created_at, updated_at) VALUES(\n 6, 'issue-type-keyresult', 'Key Result', NOW(), NOW()\n ) ON CONFLICT DO NOTHING;\n")440main: -> 0.0013s441main: == 20221018050323 AddObjectiveAndKeyresultToWorkItemTypes: migrated (0.0086s) =442main: == [advisory_lock_connection] object_id: 145541780, pg_backend_pid: 216443 adds both objective & keyresult to base work item types444main: == [advisory_lock_connection] object_id: 146423640, pg_backend_pid: 218445main: == 20221018050323 AddObjectiveAndKeyresultToWorkItemTypes: migrating ==========446main: -- Objective item record exist, skipping creation447main: -- Keyresult item record exist, skipping creation448main: == 20221018050323 AddObjectiveAndKeyresultToWorkItemTypes: migrated (0.0088s) =449main: == [advisory_lock_connection] object_id: 146423640, pg_backend_pid: 218450 skips creating both objective & keyresult type record if it already exists451The application_settings (main) table has 1253 columns.452Recreating the database453Dropped database 'gitlabhq_test'454Created database 'gitlabhq_test'455main: == [advisory_lock_connection] object_id: 146660240, pg_backend_pid: 224456main: == [advisory_lock_connection] object_id: 146660240, pg_backend_pid: 224457ci: == [advisory_lock_connection] object_id: 146661880, pg_backend_pid: 226458ci: == [advisory_lock_connection] object_id: 146661880, pg_backend_pid: 226459Databases re-creation done in 6.330176759999631460ScheduleMigrationForLinks461 # order random462 #up463main: == [advisory_lock_connection] object_id: 154805180, pg_backend_pid: 232464main: == 20230208125736 ScheduleMigrationForLinks: migrating ========================465main: == 20230208125736 ScheduleMigrationForLinks: migrated (0.0088s) ===============466main: == [advisory_lock_connection] object_id: 154805180, pg_backend_pid: 232467 schedules a batched background migration468 #down469main: == [advisory_lock_connection] object_id: 155212840, pg_backend_pid: 234470main: == 20230208125736 ScheduleMigrationForLinks: migrating ========================471main: == 20230208125736 ScheduleMigrationForLinks: migrated (0.0073s) ===============472main: == [advisory_lock_connection] object_id: 155212840, pg_backend_pid: 234473 deletes all batched migration records474INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree475INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"476INFO: "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 rows477INFO: analyzing "public.p_ci_job_annotations" inheritance tree478INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"479INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows480INFO: analyzing "public.p_ci_builds_metadata" inheritance tree481INFO: analyzing "public.ci_builds_metadata"482INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows483INFO: analyzing "public.p_ci_builds" inheritance tree484INFO: analyzing "public.ci_builds"485INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows486NullifyLastErrorFromProjectMirrorData487 # order random488 #up489main: == [advisory_lock_connection] object_id: 175752220, pg_backend_pid: 248490main: == 20230208131808 NullifyLastErrorFromProjectMirrorData: migrating ============491main: == 20230208131808 NullifyLastErrorFromProjectMirrorData: migrated (0.0601s) ===492main: == [advisory_lock_connection] object_id: 175752220, pg_backend_pid: 248493 schedules background jobs for each batch of projects494 #down495main: == [advisory_lock_connection] object_id: 176197900, pg_backend_pid: 250496main: == 20230208131808 NullifyLastErrorFromProjectMirrorData: migrating ============497main: == 20230208131808 NullifyLastErrorFromProjectMirrorData: migrated (0.0481s) ===498main: == [advisory_lock_connection] object_id: 176197900, pg_backend_pid: 250499 deletes all batched migration records500INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree501INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"502INFO: "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 rows503INFO: analyzing "public.p_ci_job_annotations" inheritance tree504INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"505INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows506INFO: analyzing "public.p_ci_builds_metadata" inheritance tree507INFO: analyzing "public.ci_builds_metadata"508INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows509INFO: analyzing "public.p_ci_builds" inheritance tree510INFO: analyzing "public.ci_builds"511INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows512AddNotificationsWorkItemWidget513 # order random514 behaves like migration that adds widget to work items definitions515 #up516main: == [advisory_lock_connection] object_id: 196186760, pg_backend_pid: 264517main: == 20230228142350 AddNotificationsWorkItemWidget: migrating ===================518main: == 20230228142350 AddNotificationsWorkItemWidget: migrated (0.0344s) ==========519main: == [advisory_lock_connection] object_id: 196186760, pg_backend_pid: 264520 creates widget definition in all types521main: == [advisory_lock_connection] object_id: 196821340, pg_backend_pid: 266522main: == 20230228142350 AddNotificationsWorkItemWidget: migrating ===================523main: == 20230228142350 AddNotificationsWorkItemWidget: migrated (0.0577s) ==========524main: == [advisory_lock_connection] object_id: 196821340, pg_backend_pid: 266525 logs a warning if the type is missing526 #down527main: == [advisory_lock_connection] object_id: 197109140, pg_backend_pid: 268528main: == 20230228142350 AddNotificationsWorkItemWidget: migrating ===================529main: == 20230228142350 AddNotificationsWorkItemWidget: migrated (0.0551s) ==========530main: == [advisory_lock_connection] object_id: 197109140, pg_backend_pid: 268531 removes definitions for widget532INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree533INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"534INFO: "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 rows535INFO: analyzing "public.p_ci_job_annotations" inheritance tree536INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"537INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows538INFO: analyzing "public.p_ci_builds_metadata" inheritance tree539INFO: analyzing "public.ci_builds_metadata"540INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows541INFO: analyzing "public.p_ci_builds" inheritance tree542INFO: analyzing "public.ci_builds"543INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows544ScheduleMigrateSharedVulnerabilityIdentifiers545 # order random546 #up547main: == [advisory_lock_connection] object_id: 216657580, pg_backend_pid: 280548main: == 20230221093536 ScheduleMigrateSharedVulnerabilityIdentifiers: migrating ====549main: == 20230221093536 ScheduleMigrateSharedVulnerabilityIdentifiers: migrated (0.0567s) 550main: == [advisory_lock_connection] object_id: 216657580, pg_backend_pid: 280551 schedules552 #down553 deletes554INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree555INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"556INFO: "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 rows557INFO: analyzing "public.p_ci_job_annotations" inheritance tree558INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"559INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows560INFO: analyzing "public.p_ci_builds_metadata" inheritance tree561INFO: analyzing "public.ci_builds_metadata"562INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows563INFO: analyzing "public.p_ci_builds" inheritance tree564INFO: analyzing "public.ci_builds"565INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows566RemoveIncorrectlyOnboardedNamespacesFromOnboardingProgress567 # order random568 #up569main: == [advisory_lock_connection] object_id: 236890580, pg_backend_pid: 295570main: == 20230221214519 RemoveIncorrectlyOnboardedNamespacesFromOnboardingProgress: migrating 571main: == 20230221214519 RemoveIncorrectlyOnboardedNamespacesFromOnboardingProgress: migrated (0.0279s) 572main: == [advisory_lock_connection] object_id: 236890580, pg_backend_pid: 295573 deletes the onboarding for namespaces without learn gitlab574INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree575INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"576INFO: "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 rows577INFO: analyzing "public.p_ci_job_annotations" inheritance tree578INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"579INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows580INFO: analyzing "public.p_ci_builds_metadata" inheritance tree581INFO: analyzing "public.ci_builds_metadata"582INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows583INFO: analyzing "public.p_ci_builds" inheritance tree584INFO: analyzing "public.ci_builds"585INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows586EnsureNoteDiffFilesBigintBackfillIsFinishedForGitlabDotCom587 # order random588 #up589main: == [advisory_lock_connection] object_id: 255735600, pg_backend_pid: 308590main: == 20230322023442 EnsureNoteDiffFilesBigintBackfillIsFinishedForGitlabDotCom: migrating 591main: == 20230322023442 EnsureNoteDiffFilesBigintBackfillIsFinishedForGitlabDotCom: migrated (0.0083s) 592main: == [advisory_lock_connection] object_id: 255735600, pg_backend_pid: 308593 ensures the migration is completed for GitLab.com, dev, or test594main: == [advisory_lock_connection] object_id: 256182160, pg_backend_pid: 310595main: == 20230322023442 EnsureNoteDiffFilesBigintBackfillIsFinishedForGitlabDotCom: migrating 596main: == 20230322023442 EnsureNoteDiffFilesBigintBackfillIsFinishedForGitlabDotCom: migrated (0.0066s) 597main: == [advisory_lock_connection] object_id: 256182160, pg_backend_pid: 310598 skips the check for other instances599INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree600INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"601INFO: "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 rows602INFO: analyzing "public.p_ci_job_annotations" inheritance tree603INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"604INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows605INFO: analyzing "public.p_ci_builds_metadata" inheritance tree606INFO: analyzing "public.ci_builds_metadata"607INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows608INFO: analyzing "public.p_ci_builds" inheritance tree609INFO: analyzing "public.ci_builds"610INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows611QueueMigrateHumanUserType612 # order random613main: == [advisory_lock_connection] object_id: 273568720, pg_backend_pid: 322614main: == 20230327103401 QueueMigrateHumanUserType: migrating ========================615main: == 20230327103401 QueueMigrateHumanUserType: migrated (0.0527s) ===============616main: == [advisory_lock_connection] object_id: 273568720, pg_backend_pid: 322617 schedules a new batched migration618The application_settings (main) table has 1239 columns.619Recreating the database620Dropped database 'gitlabhq_test'621Created database 'gitlabhq_test'622main: == [advisory_lock_connection] object_id: 274037040, pg_backend_pid: 330623main: == [advisory_lock_connection] object_id: 274037040, pg_backend_pid: 330624ci: == [advisory_lock_connection] object_id: 274073520, pg_backend_pid: 332625ci: == [advisory_lock_connection] object_id: 274073520, pg_backend_pid: 332626Databases re-creation done in 6.13810678200025627EnsureSystemNoteMetadataBigintBackfillIsFinishedForGitlabDotCom628 # order random629 #up630main: == [advisory_lock_connection] object_id: 280220300, pg_backend_pid: 338631main: == 20230412013251 EnsureSystemNoteMetadataBigintBackfillIsFinishedForGitlabDotCom: migrating 632main: == 20230412013251 EnsureSystemNoteMetadataBigintBackfillIsFinishedForGitlabDotCom: migrated (0.0074s) 633main: == [advisory_lock_connection] object_id: 280220300, pg_backend_pid: 338634 ensures the migration is completed for GitLab.com, dev, or test635main: == [advisory_lock_connection] object_id: 280699560, pg_backend_pid: 340636main: == 20230412013251 EnsureSystemNoteMetadataBigintBackfillIsFinishedForGitlabDotCom: migrating 637main: == 20230412013251 EnsureSystemNoteMetadataBigintBackfillIsFinishedForGitlabDotCom: migrated (0.0064s) 638main: == [advisory_lock_connection] object_id: 280699560, pg_backend_pid: 340639 skips the check for other instances640INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree641INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"642INFO: "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 rows643INFO: analyzing "public.p_ci_job_annotations" inheritance tree644INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"645INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows646INFO: analyzing "public.p_ci_builds_metadata" inheritance tree647INFO: analyzing "public.ci_builds_metadata"648INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows649INFO: analyzing "public.p_ci_builds" inheritance tree650INFO: analyzing "public.ci_builds"651INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows652EnsureEpicUserMentionsBigintBackfillIsFinishedForGitlabDotCom653 # order random654 #up655main: == [advisory_lock_connection] object_id: 297177520, pg_backend_pid: 352656main: == 20230404030757 EnsureEpicUserMentionsBigintBackfillIsFinishedForGitlabDotCom: migrating 657main: == 20230404030757 EnsureEpicUserMentionsBigintBackfillIsFinishedForGitlabDotCom: migrated (0.0074s) 658main: == [advisory_lock_connection] object_id: 297177520, pg_backend_pid: 352659 ensures the migration is completed for GitLab.com, dev, or test660main: == [advisory_lock_connection] object_id: 297563960, pg_backend_pid: 354661main: == 20230404030757 EnsureEpicUserMentionsBigintBackfillIsFinishedForGitlabDotCom: migrating 662main: == 20230404030757 EnsureEpicUserMentionsBigintBackfillIsFinishedForGitlabDotCom: migrated (0.0071s) 663main: == [advisory_lock_connection] object_id: 297563960, pg_backend_pid: 354664 skips the check for other instances665INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree666INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"667INFO: "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 rows668INFO: analyzing "public.p_ci_job_annotations" inheritance tree669INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"670INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows671INFO: analyzing "public.p_ci_builds_metadata" inheritance tree672INFO: analyzing "public.ci_builds_metadata"673INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows674INFO: analyzing "public.p_ci_builds" inheritance tree675INFO: analyzing "public.ci_builds"676INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows677EnsureVumBigintBackfillIsFinishedForGlDotCom678 # order random679 #up680main: == [advisory_lock_connection] object_id: 314747500, pg_backend_pid: 366681main: == 20230321011529 EnsureVumBigintBackfillIsFinishedForGlDotCom: migrating =====682main: == 20230321011529 EnsureVumBigintBackfillIsFinishedForGlDotCom: migrated (0.0077s) 683main: == [advisory_lock_connection] object_id: 314747500, pg_backend_pid: 366684 ensures the migration is completed for GitLab.com, dev, or test685main: == [advisory_lock_connection] object_id: 315275960, pg_backend_pid: 368686main: == 20230321011529 EnsureVumBigintBackfillIsFinishedForGlDotCom: migrating =====687main: == 20230321011529 EnsureVumBigintBackfillIsFinishedForGlDotCom: migrated (0.0066s) 688main: == [advisory_lock_connection] object_id: 315275960, pg_backend_pid: 368689 skips the check for other instances690INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree691INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"692INFO: "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 rows693INFO: analyzing "public.p_ci_job_annotations" inheritance tree694INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"695INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows696INFO: analyzing "public.p_ci_builds_metadata" inheritance tree697INFO: analyzing "public.ci_builds_metadata"698INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows699INFO: analyzing "public.p_ci_builds" inheritance tree700INFO: analyzing "public.ci_builds"701INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows702DeleteSecurityPolicyBotUsers703 # order random704 #up705main: == [advisory_lock_connection] object_id: 333438260, pg_backend_pid: 381706main: == 20230309071242 DeleteSecurityPolicyBotUsers: migrating =====================707main: == 20230309071242 DeleteSecurityPolicyBotUsers: migrated (0.0336s) ============708main: == [advisory_lock_connection] object_id: 333438260, pg_backend_pid: 381709 deletes security_policy_bot users710INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree711INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"712INFO: "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 rows713INFO: analyzing "public.p_ci_job_annotations" inheritance tree714INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"715INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows716INFO: analyzing "public.p_ci_builds_metadata" inheritance tree717INFO: analyzing "public.ci_builds_metadata"718INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows719INFO: analyzing "public.p_ci_builds" inheritance tree720INFO: analyzing "public.ci_builds"721INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows722BackfillMlCandidatesProjectId723 # order random724 #up725main: -- execute(" UPDATE ml_candidates\n SET project_id = temp.project_id\n FROM (\n SELECT ml_candidates.id AS id, ml_experiments.project_id AS project_id\n FROM ml_candidates INNER JOIN ml_experiments ON ml_candidates.experiment_id = ml_experiments.id\n ) AS temp\n WHERE ml_candidates.id = temp.id\n")726main: -> 0.0022s727main: -- execute(" UPDATE ml_candidates\n SET project_id = temp.project_id\n FROM (\n SELECT ml_candidates.id AS id, ml_experiments.project_id AS project_id\n FROM ml_candidates INNER JOIN ml_experiments ON ml_candidates.experiment_id = ml_experiments.id\n ) AS temp\n WHERE ml_candidates.id = temp.id\n")728main: -> 0.0017s729 sets the correct project_id with idempotency730INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree731INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"732INFO: "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 rows733INFO: analyzing "public.p_ci_job_annotations" inheritance tree734INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"735INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows736INFO: analyzing "public.p_ci_builds_metadata" inheritance tree737INFO: analyzing "public.ci_builds_metadata"738INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows739INFO: analyzing "public.p_ci_builds" inheritance tree740INFO: analyzing "public.ci_builds"741INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows742RemovePackagesEventsPackageIdFk743 # order random744main: -- foreign_keys(:packages_events)745main: -> 0.0054s746main: == [advisory_lock_connection] object_id: 369924900, pg_backend_pid: 405747main: == 20230316164917 RemovePackagesEventsPackageIdFk: migrating ==================748main: -- execute("LOCK TABLE packages_packages, packages_events IN ACCESS EXCLUSIVE MODE")749main: -> 0.0012s750main: -- remove_foreign_key(:packages_events, :packages_packages, {:name=>"fk_rails_c6c20d0094"})751main: -> 0.0057s752main: == 20230316164917 RemovePackagesEventsPackageIdFk: migrated (0.0349s) =========753main: == [advisory_lock_connection] object_id: 369924900, pg_backend_pid: 405754main: -- foreign_keys(:packages_events)755main: -> 0.0053s756main: -- foreign_keys(:packages_events)757main: -> 0.0050s758 drops and creates the foreign key759INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree760INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"761INFO: "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 rows762INFO: analyzing "public.p_ci_job_annotations" inheritance tree763INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"764INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows765INFO: analyzing "public.p_ci_builds_metadata" inheritance tree766INFO: analyzing "public.ci_builds_metadata"767INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows768INFO: analyzing "public.p_ci_builds" inheritance tree769INFO: analyzing "public.ci_builds"770INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows771ScheduleIndexToMembersOnSourceAndTypeAndAccessLevel772 # order random773main: == [advisory_lock_connection] object_id: 386893980, pg_backend_pid: 418774main: == 20230502102832 ScheduleIndexToMembersOnSourceAndTypeAndAccessLevel: migrating 775main: -- index_exists?(:members, [:source_id, :source_type, :type, :access_level], {:name=>"index_members_on_source_and_type_and_access_level", :algorithm=>:concurrently})776main: -> 0.0206s777main: -- add_index_options(:members, [:source_id, :source_type, :type, :access_level], {:name=>"index_members_on_source_and_type_and_access_level", :algorithm=>:concurrently})778main: -> 0.0001s779main: == 20230502102832 ScheduleIndexToMembersOnSourceAndTypeAndAccessLevel: migrated (0.0453s) 780main: == [advisory_lock_connection] object_id: 386893980, pg_backend_pid: 418781 schedules the index782INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree783INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"784INFO: "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 rows785INFO: analyzing "public.p_ci_job_annotations" inheritance tree786INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"787INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows788INFO: analyzing "public.p_ci_builds_metadata" inheritance tree789INFO: analyzing "public.ci_builds_metadata"790INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows791INFO: analyzing "public.p_ci_builds" inheritance tree792INFO: analyzing "public.ci_builds"793INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows794RemoveOldAsyncIndexTableNameLengthConstraint795 # order random796 .up797main: -- transaction_open?(nil)798main: -> 0.0001s799main: -- transaction_open?(nil)800main: -> 0.0001s801main: -- execute(" ALTER TABLE postgres_async_indexes\n DROP CONSTRAINT IF EXISTS check_e64ff4359e\n")802main: -> 0.0018s803 allows inserting longer table names804 .down805main: -- transaction_open?(nil)806main: -> 0.0001s807main: -- transaction_open?(nil)808main: -> 0.0001s809main: -- execute("ALTER TABLE postgres_async_indexes\nADD CONSTRAINT check_e64ff4359e\nCHECK ( char_length(table_name) <= 63 )\nNOT VALID;\n")810main: -> 0.0013s811main: -- execute("ALTER TABLE postgres_async_indexes VALIDATE CONSTRAINT check_e64ff4359e;")812main: -> 0.0012s813 disallows inserting longer table names814main: -- transaction_open?(nil)815main: -> 0.0001s816main: -- transaction_open?(nil)817main: -> 0.0001s818main: -- execute(" ALTER TABLE postgres_async_indexes\n DROP CONSTRAINT IF EXISTS check_e64ff4359e\n")819main: -> 0.0013s820main: -- transaction_open?(nil)821main: -> 0.0001s822main: -- transaction_open?(nil)823main: -> 0.0001s824main: -- execute("ALTER TABLE postgres_async_indexes\nADD CONSTRAINT check_e64ff4359e\nCHECK ( char_length(table_name) <= 63 )\nNOT VALID;\n")825main: -> 0.0013s826main: -- execute("ALTER TABLE postgres_async_indexes VALIDATE CONSTRAINT check_e64ff4359e;")827main: -> 0.0011s828 cleans up records with too long table_name829The application_settings (main) table has 1267 columns.830Recreating the database831Dropped database 'gitlabhq_test'832Created database 'gitlabhq_test'833main: == [advisory_lock_connection] object_id: 402270080, pg_backend_pid: 439834main: == [advisory_lock_connection] object_id: 402270080, pg_backend_pid: 439835ci: == [advisory_lock_connection] object_id: 402336080, pg_backend_pid: 441836ci: == [advisory_lock_connection] object_id: 402336080, pg_backend_pid: 441837Databases re-creation done in 6.310952418999477838EnsureDefaultOrganization839 # order random840main: == [advisory_lock_connection] object_id: 405956780, pg_backend_pid: 446841main: == 20230605095810 EnsureDefaultOrganization: migrating ========================842main: == 20230605095810 EnsureDefaultOrganization: migrated (0.0226s) ===============843main: == [advisory_lock_connection] object_id: 405956780, pg_backend_pid: 446844 creates default organization if needed845 when the path is in use by another organization846main: == [advisory_lock_connection] object_id: 406412500, pg_backend_pid: 449847main: == 20230605095810 EnsureDefaultOrganization: migrating ========================848main: == 20230605095810 EnsureDefaultOrganization: migrated (0.0215s) ===============849main: == [advisory_lock_connection] object_id: 406412500, pg_backend_pid: 449850 adds a random hash to the path851 when default organization already exists852main: == [advisory_lock_connection] object_id: 406726840, pg_backend_pid: 452853main: == 20230605095810 EnsureDefaultOrganization: migrating ========================854main: == 20230605095810 EnsureDefaultOrganization: migrated (0.0127s) ===============855main: == [advisory_lock_connection] object_id: 406726840, pg_backend_pid: 452856 does not creates default organization if needed857INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree858INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"859INFO: "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 rows860INFO: analyzing "public.p_ci_job_annotations" inheritance tree861INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"862INFO: "ci_job_annotations_100": 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_builds_metadata" inheritance tree864INFO: analyzing "public.ci_builds_metadata"865INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows866INFO: analyzing "public.p_ci_builds" inheritance tree867INFO: analyzing "public.ci_builds"868INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows869SwapNotesIdToBigintForSelfManaged870 # order random871 #up872 when GitLab.com, dev, or test873 behaves like column `id_convert_to_bigint` is already dropped874 does not swaps the columns875 when self-managed instance with the `id_convert_to_bigint` column already dropped876 behaves like column `id_convert_to_bigint` is already dropped877 does not swaps the columns878 when self-managed instance columns already swapped879 does not swaps the columns880 when self-managed instance881 swaps the columns882 when having different naming for fk_d83a918cb1 foreign key883 swaps the columns884INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree885INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"886INFO: "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 rows887INFO: analyzing "public.p_ci_job_annotations" inheritance tree888INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"889INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows890INFO: analyzing "public.p_ci_builds_metadata" inheritance tree891INFO: analyzing "public.ci_builds_metadata"892INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows893INFO: analyzing "public.p_ci_builds" inheritance tree894INFO: analyzing "public.ci_builds"895INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows896BackfillDefaultBranchProtectionApplicationSetting897 # order random898main: == [advisory_lock_connection] object_id: 423043880, pg_backend_pid: 486899main: == 20230723203612 BackfillDefaultBranchProtectionApplicationSetting: migrating 900main: == 20230723203612 BackfillDefaultBranchProtectionApplicationSetting: migrated (0.4658s) 901main: == [advisory_lock_connection] object_id: 423043880, pg_backend_pid: 486902 schedules a new batched migration903INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree904INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"905INFO: "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 rows906INFO: analyzing "public.p_ci_job_annotations" inheritance tree907INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"908INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows909INFO: analyzing "public.p_ci_builds_metadata" inheritance tree910INFO: analyzing "public.ci_builds_metadata"911INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows912INFO: analyzing "public.p_ci_builds" inheritance tree913INFO: analyzing "public.ci_builds"914INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows915AddIndexForMemberExpiringQuery916 # order random917main: -- indexes(:members)918main: -> 0.0235s919main: -- current_schema(nil)920main: -> 0.0006s921main: == [advisory_lock_connection] object_id: 429006820, pg_backend_pid: 498922main: == 20230714015909 AddIndexForMemberExpiringQuery: migrating ===================923main: -- view_exists?(:postgres_partitions)924main: -> 0.0013s925main: -- index_exists?(:members, [:expires_at, :access_level, :id], {:where=>"requested_at IS NULL AND expiry_notified_at IS NULL", :name=>"index_members_on_expiring_at_access_level_id", :algorithm=>:concurrently})926main: -> 0.0214s927main: -- add_index(:members, [:expires_at, :access_level, :id], {:where=>"requested_at IS NULL AND expiry_notified_at IS NULL", :name=>"index_members_on_expiring_at_access_level_id", :algorithm=>:concurrently})928main: -> 0.0019s929main: == 20230714015909 AddIndexForMemberExpiringQuery: migrated (0.0493s) ==========930main: == [advisory_lock_connection] object_id: 429006820, pg_backend_pid: 498931main: -- indexes(:members)932main: -> 0.0235s933 correctly migrates up and down934INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree935INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"936INFO: "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 rows937INFO: analyzing "public.p_ci_job_annotations" inheritance tree938INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"939INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows940INFO: analyzing "public.p_ci_builds_metadata" inheritance tree941INFO: analyzing "public.ci_builds_metadata"942INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows943INFO: analyzing "public.p_ci_builds" inheritance tree944INFO: analyzing "public.ci_builds"945INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows946AddCurrentUserTodosWidgetToEpicWorkItemType947 # order random948 behaves like migration that adds a widget to a work item type949 #up950main: == [advisory_lock_connection] object_id: 434938780, pg_backend_pid: 508951main: == 20230802212443 AddCurrentUserTodosWidgetToEpicWorkItemType: migrating ======952main: == 20230802212443 AddCurrentUserTodosWidgetToEpicWorkItemType: migrated (0.0156s) 953main: == [advisory_lock_connection] object_id: 434938780, pg_backend_pid: 508954 adds widget to work item type955 when type does not exist956main: == [advisory_lock_connection] object_id: 435195740, pg_backend_pid: 510957main: == 20230802212443 AddCurrentUserTodosWidgetToEpicWorkItemType: migrating ======958main: -- Epic work item type does not exist, skipping widget creation959main: == 20230802212443 AddCurrentUserTodosWidgetToEpicWorkItemType: migrated (0.0106s) 960main: == [advisory_lock_connection] object_id: 435195740, pg_backend_pid: 510961 skips creating the new widget definition962 #down963main: == [advisory_lock_connection] object_id: 435516860, pg_backend_pid: 512964main: == 20230802212443 AddCurrentUserTodosWidgetToEpicWorkItemType: migrating ======965main: == 20230802212443 AddCurrentUserTodosWidgetToEpicWorkItemType: migrated (0.0151s) 966main: == [advisory_lock_connection] object_id: 435516860, pg_backend_pid: 512967 removes widget from work item type968INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree969INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"970INFO: "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 rows971INFO: analyzing "public.p_ci_job_annotations" inheritance tree972INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"973INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows974INFO: analyzing "public.p_ci_builds_metadata" inheritance tree975INFO: analyzing "public.ci_builds_metadata"976INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows977INFO: analyzing "public.p_ci_builds" inheritance tree978INFO: analyzing "public.ci_builds"979INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows980SwapSuggestionsNoteIdToBigintForSelfHosts981 # order random982 #up983 when GitLab.com, dev, or test984 does not swap the columns985 when self-managed instance with the columns already swapped986main: == [advisory_lock_connection] object_id: 439676060, pg_backend_pid: 526987main: == 20230810103534 SwapSuggestionsNoteIdToBigintForSelfHosts: migrating ========988main: -- column_exists?("suggestions", "note_id_convert_to_bigint")989main: -> 0.0033s990main: -- columns("suggestions")991main: -> 0.0029s992main: == 20230810103534 SwapSuggestionsNoteIdToBigintForSelfHosts: migrated (0.0150s) 993main: == [advisory_lock_connection] object_id: 439676060, pg_backend_pid: 526994 does not swap the columns995 when self-managed instance with the `note_id_convert_to_bigint` column already dropped996 does not swap the columns997 when self-managed instance998 swaps the columns999INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree1000INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"1001INFO: "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 rows1002INFO: analyzing "public.p_ci_job_annotations" inheritance tree1003INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"1004INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1005INFO: analyzing "public.p_ci_builds_metadata" inheritance tree1006INFO: analyzing "public.ci_builds_metadata"1007INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1008INFO: analyzing "public.p_ci_builds" inheritance tree1009INFO: analyzing "public.ci_builds"1010INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1011QueueFixAllowDescendantsOverrideDisabledSharedRunners1012 # order random1013main: == [advisory_lock_connection] object_id: 444314860, pg_backend_pid: 5421014main: == 20230802085923 QueueFixAllowDescendantsOverrideDisabledSharedRunners: migrating 1015main: == 20230802085923 QueueFixAllowDescendantsOverrideDisabledSharedRunners: migrated (0.0840s) 1016main: == [advisory_lock_connection] object_id: 444314860, pg_backend_pid: 5421017 schedules a new batched migration1018INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree1019INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"1020INFO: "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 rows1021INFO: analyzing "public.p_ci_job_annotations" inheritance tree1022INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"1023INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1024INFO: analyzing "public.p_ci_builds_metadata" inheritance tree1025INFO: analyzing "public.ci_builds_metadata"1026INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1027INFO: analyzing "public.p_ci_builds" inheritance tree1028INFO: analyzing "public.ci_builds"1029INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1030EnsureCommitUserMentionsNoteIdBigintBackfillIsFinishedForSelfManaged1031 # order random1032 #up1033main: == [advisory_lock_connection] object_id: 447967320, pg_backend_pid: 5531034main: == 20230811145848 EnsureCommitUserMentionsNoteIdBigintBackfillIsFinishedForSelfManaged: migrating 1035main: == 20230811145848 EnsureCommitUserMentionsNoteIdBigintBackfillIsFinishedForSelfManaged: migrated (0.0076s) 1036main: == [advisory_lock_connection] object_id: 447967320, pg_backend_pid: 5531037 ensures the migration is completed for self-managed instances1038main: == [advisory_lock_connection] object_id: 448363900, pg_backend_pid: 5551039main: == 20230811145848 EnsureCommitUserMentionsNoteIdBigintBackfillIsFinishedForSelfManaged: migrating 1040main: == 20230811145848 EnsureCommitUserMentionsNoteIdBigintBackfillIsFinishedForSelfManaged: migrated (0.0067s) 1041main: == [advisory_lock_connection] object_id: 448363900, pg_backend_pid: 5551042 skips the check for GitLab.com, dev, or test1043INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree1044INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"1045INFO: "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 rows1046INFO: analyzing "public.p_ci_job_annotations" inheritance tree1047INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"1048INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1049INFO: analyzing "public.p_ci_builds_metadata" inheritance tree1050INFO: analyzing "public.ci_builds_metadata"1051INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1052INFO: analyzing "public.p_ci_builds" inheritance tree1053INFO: analyzing "public.ci_builds"1054INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1055RenamePlansTitlesWithLegacyPlanNames1056 # order random1057 #up1058main: == [advisory_lock_connection] object_id: 451873980, pg_backend_pid: 5651059main: == 20230815160428 RenamePlansTitlesWithLegacyPlanNames: migrating =============1060main: -- execute("UPDATE plans SET title = 'Premium' WHERE name = 'premium'")1061main: -> 0.0013s1062main: -- execute("UPDATE plans SET title = 'Ultimate' WHERE name = 'ultimate'")1063main: -> 0.0016s1064main: == 20230815160428 RenamePlansTitlesWithLegacyPlanNames: migrated (0.0100s) ====1065main: == [advisory_lock_connection] object_id: 451873980, pg_backend_pid: 5651066 updates the plan titles1067INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree1068INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"1069INFO: "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 rows1070INFO: analyzing "public.p_ci_job_annotations" inheritance tree1071INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"1072INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1073INFO: analyzing "public.p_ci_builds_metadata" inheritance tree1074INFO: analyzing "public.ci_builds_metadata"1075INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1076INFO: analyzing "public.p_ci_builds" inheritance tree1077INFO: analyzing "public.ci_builds"1078INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1079QueueBackfillProjectStatisticsStorageSizeWithRecentSize1080 # order random1081main: == [advisory_lock_connection] object_id: 455291160, pg_backend_pid: 5751082main: == 20230823090001 QueueBackfillProjectStatisticsStorageSizeWithRecentSize: migrating 1083main: == 20230823090001 QueueBackfillProjectStatisticsStorageSizeWithRecentSize: migrated (0.0520s) 1084main: == [advisory_lock_connection] object_id: 455291160, pg_backend_pid: 5751085 schedules a new batched migration1086INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree1087INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"1088INFO: "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 rows1089INFO: analyzing "public.p_ci_job_annotations" inheritance tree1090INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"1091INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1092INFO: analyzing "public.p_ci_builds_metadata" inheritance tree1093INFO: analyzing "public.ci_builds_metadata"1094INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1095INFO: analyzing "public.p_ci_builds" inheritance tree1096INFO: analyzing "public.ci_builds"1097INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1098auto_explain log contains 895 entries for main, writing to /builds/gitlab-org/gitlab/auto_explain/rspec-migration-pg14-single-db-ci-connection-1-8.326.main.ndjson.gz1099took 14.4504121951100auto_explain log contains 895 entries for ci, writing to /builds/gitlab-org/gitlab/auto_explain/rspec-migration-pg14-single-db-ci-connection-1-8.326.ci.ndjson.gz1101took 12.8160300511102Knapsack report was generated. Preview:1103{1104 "spec/migrations/20221102090940_create_next_ci_partitions_record_spec.rb": 63.21656124299989,1105 "spec/migrations/20221101032521_add_default_preferred_language_to_application_settings_spec.rb": 61.03757684500033,1106 "spec/migrations/cleanup_vulnerability_state_transitions_with_same_from_state_to_state_spec.rb": 60.2413357129999,1107 "spec/migrations/20221220131020_bump_default_partition_id_value_for_ci_tables_spec.rb": 61.45965182500004,1108 "spec/migrations/queue_backfill_user_details_fields_spec.rb": 61.70157073700011,1109 "spec/migrations/20221018050323_add_objective_and_keyresult_to_work_item_types_spec.rb": 65.20741407700007,1110 "spec/migrations/20230208125736_schedule_migration_for_links_spec.rb": 47.36072499900001,1111 "spec/migrations/nullify_last_error_from_project_mirror_data_spec.rb": 48.090706033999595,1112 "spec/migrations/20230228142350_add_notifications_work_item_widget_spec.rb": 48.010252156000206,1113 "spec/migrations/schedule_migrate_shared_vulnerability_identifiers_spec.rb": 47.47475629500059,1114 "spec/migrations/20230221214519_remove_incorrectly_onboarded_namespaces_from_onboarding_progress_spec.rb": 46.8783807789996,1115 "spec/migrations/ensure_note_diff_files_bigint_backfill_is_finished_for_gitlab_dot_com_spec.rb": 45.8574668199999,1116 "spec/migrations/20230327103401_queue_migrate_human_user_type_spec.rb": 45.414305680000325,1117 "spec/migrations/ensure_system_note_metadata_bigint_backfill_is_finished_for_gitlab_dot_com_spec.rb": 40.37779319400033,1118 "spec/migrations/ensure_epic_user_mentions_bigint_backfill_is_finished_for_gitlab_dot_com_spec.rb": 40.88707998999962,1119 "spec/migrations/ensure_vum_bigint_backfill_is_finished_for_gl_dot_com_spec.rb": 43.99991953500012,1120 "spec/migrations/20230309071242_delete_security_policy_bot_users_spec.rb": 44.15622259800057,1121 "spec/migrations/20230321163947_backfill_ml_candidates_project_id_spec.rb": 43.69266261800021,1122 "spec/migrations/remove_packages_events_package_id_fk_spec.rb": 45.9331213559999,1123 "spec/migrations/20230502102832_schedule_index_to_members_on_source_and_type_and_access_level_spec.rb": 40.76018090399975,1124 "spec/migrations/remove_old_async_index_table_name_length_constraint_spec.rb": 41.25661759000013,1125 "spec/migrations/20230605095810_ensure_default_organization_spec.rb": 28.938173759000165,1126 "spec/migrations/20230726144458_swap_notes_id_to_bigint_for_self_managed_spec.rb": 23.23962010300056,1127 "spec/migrations/20230723203612_backfill_default_branch_protection_application_setting_spec.rb": 20.010748581999906,1128 "spec/migrations/20230714015909_add_index_for_member_expiring_query_spec.rb": 19.264297531999546,1129 "spec/migrations/20230802212443_add_current_user_todos_widget_to_epic_work_item_type_spec.rb": 15.309462039999744,1130 "spec/migrations/20230810103534_swap_suggestions_note_id_to_bigint_for_self_hosts_spec.rb": 14.84910881399992,1131 "spec/migrations/20230802085923_queue_fix_allow_descendants_override_disabled_shared_runners_spec.rb": 11.820426470999337,1132 "spec/migrations/ensure_commit_user_mentions_note_id_bigint_backfill_is_finished_for_self_managed_spec.rb": 10.280944697999985,1133 "spec/migrations/20230815160428_rename_plans_titles_with_legacy_plan_names_spec.rb": 8.421379940000406,1134 "spec/migrations/20230823090001_queue_backfill_project_statistics_storage_size_with_recent_size_spec.rb": 8.3893293640003321135}1136Knapsack global time execution for tests: 20m 03s1137Finished in 43 minutes 16 seconds (files took 43.91 seconds to load)113861 examples, 0 failures1139Randomized with seed 574861140[TEST PROF INFO] Time spent in factories: 00:00.435 (0.02% of total time)1141RSpec exited with 0.1142No examples to retry, congrats!1144Running after script...1145$ echo -e "\e[0Ksection_start:`date +%s`:report_results_section[collapsed=true]\r\e[0KReport results"1149$ tooling/bin/push_job_metrics || true1150[job-metrics] Pushing job metrics file for the CI/CD job.1151[job-metrics] Pushed 4 CI job metric entries to InfluxDB.1153Not uploading cache ruby-gems-debian-bullseye-ruby-3.0-16 due to policy1155Uploading artifacts...1156auto_explain/: found 3 matching artifact files and directories 1157coverage/: found 5 matching artifact files and directories 1158crystalball/: found 2 matching artifact files and directories 1159WARNING: deprecations/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab) 1160knapsack/: found 4 matching artifact files and directories 1161rspec/: found 16 matching artifact files and directories 1162WARNING: tmp/capybara/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab) 1163log/*.log: found 13 matching artifact files and directories 1164WARNING: Upload request redirected location=https://gitlab.com/api/v4/jobs/5336650726/artifacts?artifact_format=zip&artifact_type=archive&expire_in=31d new-url=https://gitlab.com1165WARNING: Retrying... context=artifacts-uploader error=request redirected1166Uploading artifacts as "archive" to coordinator... 201 Created id=5336650726 responseStatus=201 Created token=64_XzJnF1167Uploading artifacts...1168rspec/rspec-*.xml: found 1 matching artifact files and directories 1169WARNING: Upload request redirected location=https://gitlab.com/api/v4/jobs/5336650726/artifacts?artifact_format=gzip&artifact_type=junit&expire_in=31d new-url=https://gitlab.com1170WARNING: Retrying... context=artifacts-uploader error=request redirected1171Uploading artifacts as "junit" to coordinator... 201 Created id=5336650726 responseStatus=201 Created token=64_XzJnF1173Job succeeded