rspec migration pg14 single-db-ci-connection 2/8
Passed Started
by
@vshushlin
Vladimir Shushlin
1Running with gitlab-runner 16.3.0~beta.108.g2b6048b4 (2b6048b4)2 on blue-2.private.runners-manager.gitlab.com/gitlab.com/gitlab-org QvBVRoXM, system ID: s_49b872f8ccf63 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-qvbvroxm-project-278964-concurrent-0 via runner-qvbvroxm-private-1697786257-75c9db3a...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.98 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...43Downloading cache from https://storage.googleapis.com/gitlab-com-runners-cache/project/278964/ruby-gems-debian-bullseye-ruby-3.0-16 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_sF3Rt48Downloading artifacts for detect-tests (5336650454)...49Downloading artifacts from coordinator... ok host=storage.googleapis.com id=5336650454 responseStatus=200 OK token=64_sF3Rt50Downloading artifacts for retrieve-tests-metadata (5336650473)...51Downloading artifacts from coordinator... ok host=storage.googleapis.com id=5336650473 responseStatus=200 OK token=64_sF3Rt52Downloading artifacts for setup-test-env (5336650424)...53Downloading artifacts from coordinator... ok host=storage.googleapis.com id=5336650424 responseStatus=200 OK token=64_sF3Rt55Using 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_2_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_2_8_report.json140NEW_FLAKY_RSPEC_REPORT_PATH: rspec/flaky/new_rspec_migration_pg14_single-db-ci-connection_2_8_report.json141RSPEC_SKIPPED_TESTS_REPORT_PATH: rspec/skipped_tests-5336650729.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.654457808 seconds206SyncNewAmountUsedForCiNamespaceMonthlyUsages207 # order random208ci: == [advisory_lock_connection] object_id: 10312120, pg_backend_pid: 125209ci: == 20221107184758 SyncNewAmountUsedForCiNamespaceMonthlyUsages: migrating =====210ci: == 20221107184758 SyncNewAmountUsedForCiNamespaceMonthlyUsages: migrated (0.0100s) 211ci: == [advisory_lock_connection] object_id: 10312120, pg_backend_pid: 125212 updates `new_amount_used` with values from `amount_used`213INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree214INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"215INFO: "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 rows216INFO: analyzing "public.p_ci_job_annotations" inheritance tree217INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"218INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows219INFO: analyzing "public.p_ci_builds_metadata" inheritance tree220INFO: analyzing "public.ci_builds_metadata"221INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows222INFO: analyzing "public.p_ci_builds" inheritance tree223INFO: analyzing "public.ci_builds"224INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows225FinalizeInvalidMemberCleanup226 # order random227 #up228 when migration is missing229main: == [advisory_lock_connection] object_id: 36951220, pg_backend_pid: 139230main: == 20221006070927 FinalizeInvalidMemberCleanup: migrating =====================231main: == 20221006070927 FinalizeInvalidMemberCleanup: migrated (0.0090s) ============232main: == [advisory_lock_connection] object_id: 36951220, pg_backend_pid: 139233 warns migration not found234 with migration present235 when migration finished successfully236main: == [advisory_lock_connection] object_id: 37851820, pg_backend_pid: 141237main: == 20221006070927 FinalizeInvalidMemberCleanup: migrating =====================238main: == 20221006070927 FinalizeInvalidMemberCleanup: migrated (0.0151s) ============239main: == [advisory_lock_connection] object_id: 37851820, pg_backend_pid: 141240 does not raise exception241 with different migration statuses242 status: 0, description: "paused"243 behaves like finalizes the migration244 finalizes the migration245 status: 1, description: "active"246 behaves like finalizes the migration247 finalizes the migration248 status: 4, description: "failed"249 behaves like finalizes the migration250 finalizes the migration251 status: 5, description: "finalizing"252 behaves like finalizes the migration253 finalizes the migration254INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree255INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"256INFO: "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 rows257INFO: analyzing "public.p_ci_job_annotations" inheritance tree258INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"259INFO: "ci_job_annotations_100": 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_metadata" inheritance tree261INFO: analyzing "public.ci_builds_metadata"262INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows263INFO: analyzing "public.p_ci_builds" inheritance tree264INFO: analyzing "public.ci_builds"265INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows266FinalizeIssuesNamespaceIdBackfilling267 # order random268 #up269 when routes backfilling migration is missing270main: == [advisory_lock_connection] object_id: 65265540, pg_backend_pid: 158271main: == 20221118103152 FinalizeIssuesNamespaceIdBackfilling: migrating =============272main: == 20221118103152 FinalizeIssuesNamespaceIdBackfilling: migrated (0.0089s) ====273main: == [advisory_lock_connection] object_id: 65265540, pg_backend_pid: 158274 warns migration not found275 with backfilling migration present276 when backfilling migration finished successfully277main: == [advisory_lock_connection] object_id: 65959380, pg_backend_pid: 160278main: == 20221118103152 FinalizeIssuesNamespaceIdBackfilling: migrating =============279main: == 20221118103152 FinalizeIssuesNamespaceIdBackfilling: migrated (0.0110s) ====280main: == [advisory_lock_connection] object_id: 65959380, pg_backend_pid: 160281 does not raise exception282 with different backfilling migration statuses283 status: 0, description: "paused"284 behaves like finalizes the migration285 finalizes the migration286 status: 1, description: "active"287 behaves like finalizes the migration288 finalizes the migration289 status: 4, description: "failed"290 behaves like finalizes the migration291 finalizes the migration292 status: 5, description: "finalizing"293 behaves like finalizes the migration294 finalizes the migration295INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree296INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"297INFO: "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 rows298INFO: analyzing "public.p_ci_job_annotations" inheritance tree299INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"300INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows301INFO: analyzing "public.p_ci_builds_metadata" inheritance tree302INFO: analyzing "public.ci_builds_metadata"303INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows304INFO: analyzing "public.p_ci_builds" inheritance tree305INFO: analyzing "public.ci_builds"306INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows307ScheduleBackfillReleasesAuthorId308 # order random309 when there are releases without author310main: == [advisory_lock_connection] object_id: 91552840, pg_backend_pid: 178311main: == 20221215151822 ScheduleBackfillReleasesAuthorId: migrating =================312main: == 20221215151822 ScheduleBackfillReleasesAuthorId: migrated (0.0837s) ========313main: == [advisory_lock_connection] object_id: 91552840, pg_backend_pid: 178314 schedules a new batched migration315 when there are no releases without author316main: -- There are no releases with empty author_id, so skipping migration ScheduleBackfillReleasesAuthorId317 does not schedule batched migration318INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree319INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"320INFO: "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 rows321INFO: analyzing "public.p_ci_job_annotations" inheritance tree322INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"323INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows324INFO: analyzing "public.p_ci_builds_metadata" inheritance tree325INFO: analyzing "public.ci_builds_metadata"326INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows327INFO: analyzing "public.p_ci_builds" inheritance tree328INFO: analyzing "public.ci_builds"329INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows330SecondRecountEpicCacheCounts331 # order random332 #down333main: == [advisory_lock_connection] object_id: 115947340, pg_backend_pid: 193334main: == 20221214095129 SecondRecountEpicCacheCounts: migrating =====================335main: == 20221214095129 SecondRecountEpicCacheCounts: migrated (0.0550s) ============336main: == [advisory_lock_connection] object_id: 115947340, pg_backend_pid: 193337 deletes all batched migration records338 #up339main: == [advisory_lock_connection] object_id: 116524120, pg_backend_pid: 196340main: == 20221214095129 SecondRecountEpicCacheCounts: migrating =====================341main: == 20221214095129 SecondRecountEpicCacheCounts: migrated (0.0790s) ============342main: == [advisory_lock_connection] object_id: 116524120, pg_backend_pid: 196343 schedules a batched background migration344INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree345INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"346INFO: "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 rows347INFO: analyzing "public.p_ci_job_annotations" inheritance tree348INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"349INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows350INFO: analyzing "public.p_ci_builds_metadata" inheritance tree351INFO: analyzing "public.ci_builds_metadata"352INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows353INFO: analyzing "public.p_ci_builds" inheritance tree354INFO: analyzing "public.ci_builds"355INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows356ScheduleRemoveProjectGroupLinkWithMissingGroups357 # order random358 #down359main: == [advisory_lock_connection] object_id: 139061720, pg_backend_pid: 209360main: == 20230209222452 ScheduleRemoveProjectGroupLinkWithMissingGroups: migrating ==361main: == 20230209222452 ScheduleRemoveProjectGroupLinkWithMissingGroups: migrated (0.0767s) 362main: == [advisory_lock_connection] object_id: 139061720, pg_backend_pid: 209363 removes scheduled background migrations364 #up365main: == [advisory_lock_connection] object_id: 139584360, pg_backend_pid: 212366main: == 20230209222452 ScheduleRemoveProjectGroupLinkWithMissingGroups: migrating ==367main: == 20230209222452 ScheduleRemoveProjectGroupLinkWithMissingGroups: migrated (0.0469s) 368main: == [advisory_lock_connection] object_id: 139584360, pg_backend_pid: 212369 schedules background migration370The application_settings (main) table has 1243 columns.371Recreating the database372Dropped database 'gitlabhq_test'373Created database 'gitlabhq_test'374main: == [advisory_lock_connection] object_id: 139842200, pg_backend_pid: 219375main: == [advisory_lock_connection] object_id: 139842200, pg_backend_pid: 219376ci: == [advisory_lock_connection] object_id: 139844740, pg_backend_pid: 221377ci: == [advisory_lock_connection] object_id: 139844740, pg_backend_pid: 221378Databases re-creation done in 6.195870412999284379NullifyCreatorIdOfOrphanedProjects380 # order random381 #up382main: == [advisory_lock_connection] object_id: 148278840, pg_backend_pid: 227383main: == 20230130073109 NullifyCreatorIdOfOrphanedProjects: migrating ===============384main: == 20230130073109 NullifyCreatorIdOfOrphanedProjects: migrated (0.0561s) ======385main: == [advisory_lock_connection] object_id: 148278840, pg_backend_pid: 227386 schedules background migration387 #down388main: == [advisory_lock_connection] object_id: 148676600, pg_backend_pid: 229389main: == 20230130073109 NullifyCreatorIdOfOrphanedProjects: migrating ===============390main: == 20230130073109 NullifyCreatorIdOfOrphanedProjects: migrated (0.0516s) ======391main: == [advisory_lock_connection] object_id: 148676600, pg_backend_pid: 229392 removes scheduled background migrations393INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree394INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"395INFO: "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 rows396INFO: analyzing "public.p_ci_job_annotations" inheritance tree397INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"398INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows399INFO: analyzing "public.p_ci_builds_metadata" inheritance tree400INFO: analyzing "public.ci_builds_metadata"401INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows402INFO: analyzing "public.p_ci_builds" inheritance tree403INFO: analyzing "public.ci_builds"404INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows405FinalizeIssuesIidScopingToNamespace406 # order random407 #up408 when migration is missing409main: == [advisory_lock_connection] object_id: 168801180, pg_backend_pid: 243410main: == 20230315084704 FinalizeIssuesIidScopingToNamespace: migrating ==============411main: == 20230315084704 FinalizeIssuesIidScopingToNamespace: migrated (0.0140s) =====412main: == [advisory_lock_connection] object_id: 168801180, pg_backend_pid: 243413 warns migration not found414 with migration present415 when migration finished successfully416main: == [advisory_lock_connection] object_id: 169335180, pg_backend_pid: 245417main: == 20230315084704 FinalizeIssuesIidScopingToNamespace: migrating ==============418main: == 20230315084704 FinalizeIssuesIidScopingToNamespace: migrated (0.0161s) =====419main: == [advisory_lock_connection] object_id: 169335180, pg_backend_pid: 245420 does not raise exception421 with different migration statuses422 status: 0, description: "paused"423 behaves like finalizes the migration424 finalizes the migration425 status: 1, description: "active"426 behaves like finalizes the migration427 finalizes the migration428 status: 4, description: "failed"429 behaves like finalizes the migration430 finalizes the migration431 status: 5, description: "finalizing"432 behaves like finalizes the migration433 finalizes the migration434INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree435INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"436INFO: "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 rows437INFO: analyzing "public.p_ci_job_annotations" inheritance tree438INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"439INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows440INFO: analyzing "public.p_ci_builds_metadata" inheritance tree441INFO: analyzing "public.ci_builds_metadata"442INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows443INFO: analyzing "public.p_ci_builds" inheritance tree444INFO: analyzing "public.ci_builds"445INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows446ClearDuplicateJobsCookies447 # order random448main: == [advisory_lock_connection] object_id: 190287560, pg_backend_pid: 262449main: == 20230117114739 ClearDuplicateJobsCookies: migrating ========================450main: == 20230117114739 ClearDuplicateJobsCookies: migrated (0.0180s) ===============451main: == [advisory_lock_connection] object_id: 190287560, pg_backend_pid: 262452 deletes duplicate jobs cookies453INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree454INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"455INFO: "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 rows456INFO: analyzing "public.p_ci_job_annotations" inheritance tree457INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"458INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows459INFO: analyzing "public.p_ci_builds_metadata" inheritance tree460INFO: analyzing "public.ci_builds_metadata"461INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows462INFO: analyzing "public.p_ci_builds" inheritance tree463INFO: analyzing "public.ci_builds"464INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows465SwapTimelogsNoteIdToBigintForGitlabDotCom466 # order random467 #up468 swaps the integer and bigint columns for GitLab.com, dev, or test469 is a no-op for other instances470INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree471INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"472INFO: "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 rows473INFO: analyzing "public.p_ci_job_annotations" inheritance tree474INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"475INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows476INFO: analyzing "public.p_ci_builds_metadata" inheritance tree477INFO: analyzing "public.ci_builds_metadata"478INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows479INFO: analyzing "public.p_ci_builds" inheritance tree480INFO: analyzing "public.ci_builds"481INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows482MigrateEvidencesFromRawMetadata483 # order random484 #down485main: == [advisory_lock_connection] object_id: 231765720, pg_backend_pid: 291486main: == 20230224144233 MigrateEvidencesFromRawMetadata: migrating ==================487main: == 20230224144233 MigrateEvidencesFromRawMetadata: migrated (0.0076s) =========488main: == [advisory_lock_connection] object_id: 231765720, pg_backend_pid: 291489 deletes all batched migration records490 #up491main: == [advisory_lock_connection] object_id: 232404860, pg_backend_pid: 294492main: == 20230224144233 MigrateEvidencesFromRawMetadata: migrating ==================493main: == 20230224144233 MigrateEvidencesFromRawMetadata: migrated (0.0074s) =========494main: == [advisory_lock_connection] object_id: 232404860, pg_backend_pid: 294495 schedules a batched background migration496INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree497INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"498INFO: "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 rows499INFO: analyzing "public.p_ci_job_annotations" inheritance tree500INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"501INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows502INFO: analyzing "public.p_ci_builds_metadata" inheritance tree503INFO: analyzing "public.ci_builds_metadata"504INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows505INFO: analyzing "public.p_ci_builds" inheritance tree506INFO: analyzing "public.ci_builds"507INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows508AddProjectIdNameIdVersionIndexToInstallableNpmPackages509 # order random510main: == [advisory_lock_connection] object_id: 252543180, pg_backend_pid: 307511main: == 20230131125844 AddProjectIdNameIdVersionIndexToInstallableNpmPackages: migrating 512main: -- view_exists?(:postgres_partitions)513main: -> 0.0016s514main: -- index_exists?(:packages_packages, [:project_id, :name, :id, :version], {:name=>"idx_packages_on_project_id_name_id_version_when_installable_npm", :where=>"package_type = 2 AND status IN (0, 1)", :algorithm=>:concurrently})515main: -> 0.0208s516main: -- add_index(:packages_packages, [:project_id, :name, :id, :version], {:name=>"idx_packages_on_project_id_name_id_version_when_installable_npm", :where=>"package_type = 2 AND status IN (0, 1)", :algorithm=>:concurrently})517main: -> 0.0022s518main: == 20230131125844 AddProjectIdNameIdVersionIndexToInstallableNpmPackages: migrated (0.0496s) 519main: == [advisory_lock_connection] object_id: 252543180, pg_backend_pid: 307520 schedules an index creation521INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree522INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"523INFO: "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 rows524INFO: analyzing "public.p_ci_job_annotations" inheritance tree525INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"526INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows527INFO: analyzing "public.p_ci_builds_metadata" inheritance tree528INFO: analyzing "public.ci_builds_metadata"529INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows530INFO: analyzing "public.p_ci_builds" inheritance tree531INFO: analyzing "public.ci_builds"532INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows533SwapNoteDiffFilesNoteIdToBigintForGitlabDotCom534 # order random535 #up536 swaps the integer and bigint columns for GitLab.com, dev, or test537 is a no-op for other instances538The application_settings (main) table has 1254 columns.539Recreating the database540Dropped database 'gitlabhq_test'541Created database 'gitlabhq_test'542main: == [advisory_lock_connection] object_id: 273212060, pg_backend_pid: 330543main: == [advisory_lock_connection] object_id: 273212060, pg_backend_pid: 330544ci: == [advisory_lock_connection] object_id: 273226860, pg_backend_pid: 332545ci: == [advisory_lock_connection] object_id: 273226860, pg_backend_pid: 332546Databases re-creation done in 5.759950560000107547SwapEpicUserMentionsNoteIdToBigintForGitlabDotCom548 # order random549 #up550 swaps the integer and bigint columns for GitLab.com, dev, or test551 is a no-op for other instances552INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree553INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"554INFO: "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 rows555INFO: analyzing "public.p_ci_job_annotations" inheritance tree556INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"557INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows558INFO: analyzing "public.p_ci_builds_metadata" inheritance tree559INFO: analyzing "public.ci_builds_metadata"560INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows561INFO: analyzing "public.p_ci_builds" inheritance tree562INFO: analyzing "public.ci_builds"563INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows564ReMigrateRedisSlotKeys565 # order random566 #up567main: == [advisory_lock_connection] object_id: 297301120, pg_backend_pid: 354568main: == 20230328111013 ReMigrateRedisSlotKeys: migrating ===========================569main: == 20230328111013 ReMigrateRedisSlotKeys: migrated (0.0249s) ==================570main: == [advisory_lock_connection] object_id: 297301120, pg_backend_pid: 354571 rename keys572main: == [advisory_lock_connection] object_id: 297680500, pg_backend_pid: 356573main: == 20230328111013 ReMigrateRedisSlotKeys: migrating ===========================574main: == 20230328111013 ReMigrateRedisSlotKeys: migrated (1.8884s) ==================575main: == [advisory_lock_connection] object_id: 297680500, pg_backend_pid: 356576 runs without errors577INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree578INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"579INFO: "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 rows580INFO: analyzing "public.p_ci_job_annotations" inheritance tree581INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"582INFO: "ci_job_annotations_100": 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_metadata" inheritance tree584INFO: analyzing "public.ci_builds_metadata"585INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows586INFO: analyzing "public.p_ci_builds" inheritance tree587INFO: analyzing "public.ci_builds"588INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows589RescheduleMigrationForLinks590 # order random591 #up592main: == [advisory_lock_connection] object_id: 315267160, pg_backend_pid: 368593main: == 20230314144640 RescheduleMigrationForLinks: migrating ======================594main: == 20230314144640 RescheduleMigrationForLinks: migrated (0.0070s) =============595main: == [advisory_lock_connection] object_id: 315267160, pg_backend_pid: 368596 schedules a batched background migration597 #down598main: == [advisory_lock_connection] object_id: 315785100, pg_backend_pid: 371599main: == 20230314144640 RescheduleMigrationForLinks: migrating ======================600main: == 20230314144640 RescheduleMigrationForLinks: migrated (0.0066s) =============601main: == [advisory_lock_connection] object_id: 315785100, pg_backend_pid: 371602 deletes all batched migration records603INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree604INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"605INFO: "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 rows606INFO: analyzing "public.p_ci_job_annotations" inheritance tree607INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"608INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows609INFO: analyzing "public.p_ci_builds_metadata" inheritance tree610INFO: analyzing "public.ci_builds_metadata"611INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows612INFO: analyzing "public.p_ci_builds" inheritance tree613INFO: analyzing "public.ci_builds"614INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows615SwapSystemNoteMetadataNoteIdToBigintForGitlabDotCom616 # order random617 #up618 swaps the integer and bigint columns for GitLab.com, dev, or test619 is a no-op for other instances620INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree621INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"622INFO: "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 rows623INFO: analyzing "public.p_ci_job_annotations" inheritance tree624INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"625INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows626INFO: analyzing "public.p_ci_builds_metadata" inheritance tree627INFO: analyzing "public.ci_builds_metadata"628INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows629INFO: analyzing "public.p_ci_builds" inheritance tree630INFO: analyzing "public.ci_builds"631INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows632QueueDeleteOrphanedPackagesDependencies633 # order random634main: == [advisory_lock_connection] object_id: 350327080, pg_backend_pid: 400635main: == 20230303105806 QueueDeleteOrphanedPackagesDependencies: migrating ==========636main: == 20230303105806 QueueDeleteOrphanedPackagesDependencies: migrated (0.0563s) =637main: == [advisory_lock_connection] object_id: 350327080, pg_backend_pid: 400638 schedules a new batched migration639INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree640INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"641INFO: "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 rows642INFO: analyzing "public.p_ci_job_annotations" inheritance tree643INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"644INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows645INFO: analyzing "public.p_ci_builds_metadata" inheritance tree646INFO: analyzing "public.ci_builds_metadata"647INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows648INFO: analyzing "public.p_ci_builds" inheritance tree649INFO: analyzing "public.ci_builds"650INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows651RemoveShimoZentaoIntegrationRecords652 # order random653 with JiHu env654main: == [advisory_lock_connection] object_id: 367903100, pg_backend_pid: 413655main: == 20230428085332 RemoveShimoZentaoIntegrationRecords: migrating ==============656main: == 20230428085332 RemoveShimoZentaoIntegrationRecords: migrated (0.0071s) =====657main: == [advisory_lock_connection] object_id: 367903100, pg_backend_pid: 413658 keeps shimo and zentao integrations659 with CE/EE env660main: == [advisory_lock_connection] object_id: 368433980, pg_backend_pid: 415661main: == 20230428085332 RemoveShimoZentaoIntegrationRecords: migrating ==============662main: == 20230428085332 RemoveShimoZentaoIntegrationRecords: migrated (0.0222s) =====663main: == [advisory_lock_connection] object_id: 368433980, pg_backend_pid: 415664 destroys all shimo and zentao integrations665INFO: 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 rows677RemoveGitlabImportSource678 # order random679 #up680main: == [advisory_lock_connection] object_id: 383349360, pg_backend_pid: 427681main: == 20230504084524 RemoveGitlabImportSource: migrating =========================682main: == 20230504084524 RemoveGitlabImportSource: migrated (0.1651s) ================683main: == [advisory_lock_connection] object_id: 383349360, pg_backend_pid: 427684 removes gitlab and preserves existing valid import sources685INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree686INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"687INFO: "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 rows688INFO: analyzing "public.p_ci_job_annotations" inheritance tree689INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"690INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows691INFO: analyzing "public.p_ci_builds_metadata" inheritance tree692INFO: analyzing "public.ci_builds_metadata"693INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows694INFO: analyzing "public.p_ci_builds" inheritance tree695INFO: analyzing "public.ci_builds"696INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows697RemovePhabricatorFromApplicationSettings698 # order random699 #up700main: == [advisory_lock_connection] object_id: 398810800, pg_backend_pid: 439701main: == 20230419105225 RemovePhabricatorFromApplicationSettings: migrating =========702main: == 20230419105225 RemovePhabricatorFromApplicationSettings: migrated (0.1588s) 703main: == [advisory_lock_connection] object_id: 398810800, pg_backend_pid: 439704 removes phabricator and preserves existing valid import sources705The application_settings (main) table has 1234 columns.706Recreating the database707Dropped database 'gitlabhq_test'708Created database 'gitlabhq_test'709main: == [advisory_lock_connection] object_id: 399030340, pg_backend_pid: 445710main: == [advisory_lock_connection] object_id: 399030340, pg_backend_pid: 445711ci: == [advisory_lock_connection] object_id: 399104480, pg_backend_pid: 447712ci: == [advisory_lock_connection] object_id: 399104480, pg_backend_pid: 447713Databases re-creation done in 5.967996093000693714RedoRemoveCreateLearnGitlabWorkerJobInstances715 # order random716 #up717main: == [advisory_lock_connection] object_id: 402352500, pg_backend_pid: 453718main: == 20230608195429 RedoRemoveCreateLearnGitlabWorkerJobInstances: migrating ====719main: == 20230608195429 RedoRemoveCreateLearnGitlabWorkerJobInstances: migrated (0.0067s) 720main: == [advisory_lock_connection] object_id: 402352500, pg_backend_pid: 453721 calls sidekiq_remove_jobs with correct argument722INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree723INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"724INFO: "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 rows725INFO: analyzing "public.p_ci_job_annotations" inheritance tree726INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"727INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows728INFO: analyzing "public.p_ci_builds_metadata" inheritance tree729INFO: analyzing "public.ci_builds_metadata"730INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows731INFO: analyzing "public.p_ci_builds" inheritance tree732INFO: analyzing "public.ci_builds"733INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows734SwapTodosNoteIdToBigintForSelfManaged735 # order random736 #up737 when GitLab.com, dev, or test738 does not swap the columns739 when self-managed instance with the columns already swapped740main: == [advisory_lock_connection] object_id: 411362240, pg_backend_pid: 467741main: == 20230710024903 SwapTodosNoteIdToBigintForSelfManaged: migrating ============742main: -- column_exists?("todos", "note_id_convert_to_bigint")743main: -> 0.0037s744main: -- columns("todos")745main: -> 0.0028s746main: == 20230710024903 SwapTodosNoteIdToBigintForSelfManaged: migrated (0.0141s) ===747main: == [advisory_lock_connection] object_id: 411362240, pg_backend_pid: 467748 does not swap the columns749 when self-managed instance with the `note_id_convert_to_bigint` column already dropped750 does not swap the columns751 when self-managed instance752 swaps the columns753INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree754INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"755INFO: "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 rows756INFO: analyzing "public.p_ci_job_annotations" inheritance tree757INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"758INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows759INFO: analyzing "public.p_ci_builds_metadata" inheritance tree760INFO: analyzing "public.ci_builds_metadata"761INFO: "ci_builds_metadata": 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_builds" inheritance tree763INFO: analyzing "public.ci_builds"764INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows765SwapEventsTargetIdToBigintForGitlabDotCom766 # order random767 #up768 swaps the integer and bigint columns for GitLab.com, dev, or test769 is a no-op for other instances770INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree771INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"772INFO: "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 rows773INFO: analyzing "public.p_ci_job_annotations" inheritance tree774INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"775INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows776INFO: analyzing "public.p_ci_builds_metadata" inheritance tree777INFO: analyzing "public.ci_builds_metadata"778INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows779INFO: analyzing "public.p_ci_builds" inheritance tree780INFO: analyzing "public.ci_builds"781INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows782AddHasMergeRequestOnVulnerabilityReadsTrigger783 # order random784 #down785main: -- execute("CREATE OR REPLACE FUNCTION set_has_merge_request_on_vulnerability_reads()\nRETURNS TRIGGER AS\n$$\nBEGIN\nUPDATE\n vulnerability_reads\nSET\n has_merge_request = true\nWHERE\n vulnerability_id = NEW.vulnerability_id AND has_merge_request IS FALSE;\nRETURN NULL;\n\nEND\n$$ LANGUAGE PLPGSQL\n")786main: -> 0.0013s787main: -- execute("CREATE OR REPLACE FUNCTION unset_has_merge_request_on_vulnerability_reads()\nRETURNS TRIGGER\nLANGUAGE plpgsql\nAS $$\nDECLARE\n has_merge_request_links integer;\nBEGIN\n PERFORM 1\n FROM\n vulnerability_reads\n WHERE\n vulnerability_id = OLD.vulnerability_id\n FOR UPDATE;\n\n SELECT 1 INTO has_merge_request_links FROM vulnerability_merge_request_links WHERE vulnerability_id = OLD.vulnerability_id LIMIT 1;\n\n IF (has_merge_request_links = 1) THEN\n RETURN NULL;\n END IF;\n\n UPDATE\n vulnerability_reads\n SET\n has_merge_request = false\n WHERE\n vulnerability_id = OLD.vulnerability_id;\n\n RETURN NULL;\nEND\n$$;\n")788main: -> 0.0011s789main: -- execute("CREATE TRIGGER trigger_update_has_merge_request_on_vulnerability_mr_links_update\nAFTER INSERT ON vulnerability_merge_request_links\nFOR EACH ROW\nEXECUTE FUNCTION set_has_merge_request_on_vulnerability_reads();\n")790main: -> 0.0010s791main: -- execute("CREATE TRIGGER trigger_update_has_merge_request_on_vulnerability_mr_links_delete\nAFTER DELETE ON vulnerability_merge_request_links\nFOR EACH ROW\nEXECUTE FUNCTION unset_has_merge_request_on_vulnerability_reads();\n")792main: -> 0.0010s793main: -- execute("DROP TRIGGER IF EXISTS trigger_update_has_merge_request_on_vulnerability_mr_links_update ON vulnerability_merge_request_links")794main: -> 0.0012s795main: -- execute("DROP FUNCTION IF EXISTS set_has_merge_request_on_vulnerability_reads()")796main: -> 0.0009s797main: -- execute("DROP TRIGGER IF EXISTS trigger_update_has_merge_request_on_vulnerability_mr_links_delete ON vulnerability_merge_request_links")798main: -> 0.0010s799main: -- execute("DROP FUNCTION IF EXISTS unset_has_merge_request_on_vulnerability_reads()")800main: -> 0.0009s801 drops the trigger802 #up803 INSERT trigger804main: == [advisory_lock_connection] object_id: 424983800, pg_backend_pid: 499805main: == 20230803125434 AddHasMergeRequestOnVulnerabilityReadsTrigger: migrating ====806main: -- execute("CREATE OR REPLACE FUNCTION set_has_merge_request_on_vulnerability_reads()\nRETURNS TRIGGER AS\n$$\nBEGIN\nUPDATE\n vulnerability_reads\nSET\n has_merge_request = true\nWHERE\n vulnerability_id = NEW.vulnerability_id AND has_merge_request IS FALSE;\nRETURN NULL;\n\nEND\n$$ LANGUAGE PLPGSQL\n")807main: -> 0.0016s808main: -- execute("CREATE OR REPLACE FUNCTION unset_has_merge_request_on_vulnerability_reads()\nRETURNS TRIGGER\nLANGUAGE plpgsql\nAS $$\nDECLARE\n has_merge_request_links integer;\nBEGIN\n PERFORM 1\n FROM\n vulnerability_reads\n WHERE\n vulnerability_id = OLD.vulnerability_id\n FOR UPDATE;\n\n SELECT 1 INTO has_merge_request_links FROM vulnerability_merge_request_links WHERE vulnerability_id = OLD.vulnerability_id LIMIT 1;\n\n IF (has_merge_request_links = 1) THEN\n RETURN NULL;\n END IF;\n\n UPDATE\n vulnerability_reads\n SET\n has_merge_request = false\n WHERE\n vulnerability_id = OLD.vulnerability_id;\n\n RETURN NULL;\nEND\n$$;\n")809main: -> 0.0010s810main: -- execute("CREATE TRIGGER trigger_update_has_merge_request_on_vulnerability_mr_links_update\nAFTER INSERT ON vulnerability_merge_request_links\nFOR EACH ROW\nEXECUTE FUNCTION set_has_merge_request_on_vulnerability_reads();\n")811main: -> 0.0010s812main: -- execute("CREATE TRIGGER trigger_update_has_merge_request_on_vulnerability_mr_links_delete\nAFTER DELETE ON vulnerability_merge_request_links\nFOR EACH ROW\nEXECUTE FUNCTION unset_has_merge_request_on_vulnerability_reads();\n")813main: -> 0.0009s814main: == 20230803125434 AddHasMergeRequestOnVulnerabilityReadsTrigger: migrated (0.0118s) 815main: == [advisory_lock_connection] object_id: 424983800, pg_backend_pid: 499816 updates has_merge_request in vulnerability_reads817 DELETE trigger818main: == [advisory_lock_connection] object_id: 425394280, pg_backend_pid: 501819main: == 20230803125434 AddHasMergeRequestOnVulnerabilityReadsTrigger: migrating ====820main: -- execute("CREATE OR REPLACE FUNCTION set_has_merge_request_on_vulnerability_reads()\nRETURNS TRIGGER AS\n$$\nBEGIN\nUPDATE\n vulnerability_reads\nSET\n has_merge_request = true\nWHERE\n vulnerability_id = NEW.vulnerability_id AND has_merge_request IS FALSE;\nRETURN NULL;\n\nEND\n$$ LANGUAGE PLPGSQL\n")821main: -> 0.0011s822main: -- execute("CREATE OR REPLACE FUNCTION unset_has_merge_request_on_vulnerability_reads()\nRETURNS TRIGGER\nLANGUAGE plpgsql\nAS $$\nDECLARE\n has_merge_request_links integer;\nBEGIN\n PERFORM 1\n FROM\n vulnerability_reads\n WHERE\n vulnerability_id = OLD.vulnerability_id\n FOR UPDATE;\n\n SELECT 1 INTO has_merge_request_links FROM vulnerability_merge_request_links WHERE vulnerability_id = OLD.vulnerability_id LIMIT 1;\n\n IF (has_merge_request_links = 1) THEN\n RETURN NULL;\n END IF;\n\n UPDATE\n vulnerability_reads\n SET\n has_merge_request = false\n WHERE\n vulnerability_id = OLD.vulnerability_id;\n\n RETURN NULL;\nEND\n$$;\n")823main: -> 0.0016s824main: -- execute("CREATE TRIGGER trigger_update_has_merge_request_on_vulnerability_mr_links_update\nAFTER INSERT ON vulnerability_merge_request_links\nFOR EACH ROW\nEXECUTE FUNCTION set_has_merge_request_on_vulnerability_reads();\n")825main: -> 0.0011s826main: -- execute("CREATE TRIGGER trigger_update_has_merge_request_on_vulnerability_mr_links_delete\nAFTER DELETE ON vulnerability_merge_request_links\nFOR EACH ROW\nEXECUTE FUNCTION unset_has_merge_request_on_vulnerability_reads();\n")827main: -> 0.0010s828main: == 20230803125434 AddHasMergeRequestOnVulnerabilityReadsTrigger: migrated (0.0120s) 829main: == [advisory_lock_connection] object_id: 425394280, pg_backend_pid: 501830 does not change has_merge_request when there exists another merge_request831main: == [advisory_lock_connection] object_id: 425785180, pg_backend_pid: 503832main: == 20230803125434 AddHasMergeRequestOnVulnerabilityReadsTrigger: migrating ====833main: -- execute("CREATE OR REPLACE FUNCTION set_has_merge_request_on_vulnerability_reads()\nRETURNS TRIGGER AS\n$$\nBEGIN\nUPDATE\n vulnerability_reads\nSET\n has_merge_request = true\nWHERE\n vulnerability_id = NEW.vulnerability_id AND has_merge_request IS FALSE;\nRETURN NULL;\n\nEND\n$$ LANGUAGE PLPGSQL\n")834main: -> 0.0014s835main: -- execute("CREATE OR REPLACE FUNCTION unset_has_merge_request_on_vulnerability_reads()\nRETURNS TRIGGER\nLANGUAGE plpgsql\nAS $$\nDECLARE\n has_merge_request_links integer;\nBEGIN\n PERFORM 1\n FROM\n vulnerability_reads\n WHERE\n vulnerability_id = OLD.vulnerability_id\n FOR UPDATE;\n\n SELECT 1 INTO has_merge_request_links FROM vulnerability_merge_request_links WHERE vulnerability_id = OLD.vulnerability_id LIMIT 1;\n\n IF (has_merge_request_links = 1) THEN\n RETURN NULL;\n END IF;\n\n UPDATE\n vulnerability_reads\n SET\n has_merge_request = false\n WHERE\n vulnerability_id = OLD.vulnerability_id;\n\n RETURN NULL;\nEND\n$$;\n")836main: -> 0.0011s837main: -- execute("CREATE TRIGGER trigger_update_has_merge_request_on_vulnerability_mr_links_update\nAFTER INSERT ON vulnerability_merge_request_links\nFOR EACH ROW\nEXECUTE FUNCTION set_has_merge_request_on_vulnerability_reads();\n")838main: -> 0.0010s839main: -- execute("CREATE TRIGGER trigger_update_has_merge_request_on_vulnerability_mr_links_delete\nAFTER DELETE ON vulnerability_merge_request_links\nFOR EACH ROW\nEXECUTE FUNCTION unset_has_merge_request_on_vulnerability_reads();\n")840main: -> 0.0010s841main: == 20230803125434 AddHasMergeRequestOnVulnerabilityReadsTrigger: migrated (0.0116s) 842main: == [advisory_lock_connection] object_id: 425785180, pg_backend_pid: 503843 unsets has_merge_request when all merge_requests are deleted844INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree845INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"846INFO: "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 rows847INFO: analyzing "public.p_ci_job_annotations" inheritance tree848INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"849INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows850INFO: analyzing "public.p_ci_builds_metadata" inheritance tree851INFO: analyzing "public.ci_builds_metadata"852INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows853INFO: analyzing "public.p_ci_builds" inheritance tree854INFO: analyzing "public.ci_builds"855INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows856ChangeEpicsHierarchyRestrictions857 # order random858 down859 behaves like migration that updates cross_hierarchy_enabled column860main: == [advisory_lock_connection] object_id: 428881420, pg_backend_pid: 512861main: == 20230920154302 ChangeEpicsHierarchyRestrictions: migrating =================862main: == 20230920154302 ChangeEpicsHierarchyRestrictions: migrated (0.0419s) ========863main: == [advisory_lock_connection] object_id: 428881420, pg_backend_pid: 512864 updates column value865 behaves like logs an error if type is missing866main: == [advisory_lock_connection] object_id: 429348880, pg_backend_pid: 515867main: == 20230920154302 ChangeEpicsHierarchyRestrictions: migrating =================868main: == 20230920154302 ChangeEpicsHierarchyRestrictions: migrated (0.0193s) ========869main: == [advisory_lock_connection] object_id: 429348880, pg_backend_pid: 515870 logs a warning871 behaves like logs an error if type is missing872main: == [advisory_lock_connection] object_id: 429647920, pg_backend_pid: 518873main: == 20230920154302 ChangeEpicsHierarchyRestrictions: migrating =================874main: == 20230920154302 ChangeEpicsHierarchyRestrictions: migrated (0.0189s) ========875main: == [advisory_lock_connection] object_id: 429647920, pg_backend_pid: 518876 logs a warning877 up878 behaves like migration that updates cross_hierarchy_enabled column879main: == [advisory_lock_connection] object_id: 429963500, pg_backend_pid: 520880main: == 20230920154302 ChangeEpicsHierarchyRestrictions: migrating =================881main: == 20230920154302 ChangeEpicsHierarchyRestrictions: migrated (0.0388s) ========882main: == [advisory_lock_connection] object_id: 429963500, pg_backend_pid: 520883 updates column value884 behaves like logs an error if type is missing885main: == [advisory_lock_connection] object_id: 430306600, pg_backend_pid: 522886main: == 20230920154302 ChangeEpicsHierarchyRestrictions: migrating =================887main: == 20230920154302 ChangeEpicsHierarchyRestrictions: migrated (0.0205s) ========888main: == [advisory_lock_connection] object_id: 430306600, pg_backend_pid: 522889 logs a warning890 behaves like logs an error if type is missing891main: == [advisory_lock_connection] object_id: 430629140, pg_backend_pid: 524892main: == 20230920154302 ChangeEpicsHierarchyRestrictions: migrating =================893main: == 20230920154302 ChangeEpicsHierarchyRestrictions: migrated (0.0195s) ========894main: == [advisory_lock_connection] object_id: 430629140, pg_backend_pid: 524895 logs a warning896SwapMergeRequestUserMentionsNoteIdToBigintForSelfManaged897 # order random898 #up899 when GitLab.com, dev, or test900 behaves like column `note_id_convert_to_bigint` is already dropped901 does not swaps the columns902 when self-managed instance with the `note_id_convert_to_bigint` column already dropped903 behaves like column `note_id_convert_to_bigint` is already dropped904 does not swaps the columns905 when self-managed instance columns already swapped906 does not swaps the columns907 when self-managed instance908 swaps the columns909INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree910INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"911INFO: "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 rows912INFO: analyzing "public.p_ci_job_annotations" inheritance tree913INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"914INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows915INFO: analyzing "public.p_ci_builds_metadata" inheritance tree916INFO: analyzing "public.ci_builds_metadata"917INFO: "ci_builds_metadata": 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 rows921RestartSelfHostedSentNotificationsBackfill922 # order random923 #up924 when is self-hosted925 when id is integer926 when a backfill has never been done927 when there is a record of an incomplete backfill928 calls delete_batched_background_migration and does not raise an error929 when there is no previous record of a backfill930 begins a backfill931 when a backfill has previously been done932 does not start a backfill933 when id is a bigint934 does not start a backfill935 when is not self-hosted936 does not start a backfill937INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree938INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"939INFO: "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 rows940INFO: analyzing "public.p_ci_job_annotations" inheritance tree941INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"942INFO: "ci_job_annotations_100": 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_metadata" inheritance tree944INFO: analyzing "public.ci_builds_metadata"945INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows946INFO: analyzing "public.p_ci_builds" inheritance tree947INFO: analyzing "public.ci_builds"948INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows949ScheduleFixingNamespaceIdsOfVulnerabilityReads950 # order random951main: == [advisory_lock_connection] object_id: 441389880, pg_backend_pid: 570952main: == 20230810124545 ScheduleFixingNamespaceIdsOfVulnerabilityReads: migrating ===953main: == 20230810124545 ScheduleFixingNamespaceIdsOfVulnerabilityReads: migrated (0.0498s) 954main: == [advisory_lock_connection] object_id: 441389880, pg_backend_pid: 570955 schedules a new batched migration956INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree957INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"958INFO: "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 rows959INFO: analyzing "public.p_ci_job_annotations" inheritance tree960INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"961INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows962INFO: analyzing "public.p_ci_builds_metadata" inheritance tree963INFO: analyzing "public.ci_builds_metadata"964INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows965INFO: analyzing "public.p_ci_builds" inheritance tree966INFO: analyzing "public.ci_builds"967INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows968QueueConvertCreditCardValidationDataToHashes969 # order random970main: == [advisory_lock_connection] object_id: 444636860, pg_backend_pid: 581971main: == 20230821081603 QueueConvertCreditCardValidationDataToHashes: migrating =====972main: == 20230821081603 QueueConvertCreditCardValidationDataToHashes: migrated (0.0535s) 973main: == [advisory_lock_connection] object_id: 444636860, pg_backend_pid: 581974 schedules a new batched migration975INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree976INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"977INFO: "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 rows978INFO: analyzing "public.p_ci_job_annotations" inheritance tree979INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"980INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows981INFO: analyzing "public.p_ci_builds_metadata" inheritance tree982INFO: analyzing "public.ci_builds_metadata"983INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows984INFO: analyzing "public.p_ci_builds" inheritance tree985INFO: analyzing "public.ci_builds"986INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows987QueueUpdateUsersSetExternalIfServiceAccount988 # order random989main: == [advisory_lock_connection] object_id: 447970860, pg_backend_pid: 591990main: == 20230830121830 QueueUpdateUsersSetExternalIfServiceAccount: migrating ======991main: == 20230830121830 QueueUpdateUsersSetExternalIfServiceAccount: migrated (0.0551s) 992main: == [advisory_lock_connection] object_id: 447970860, pg_backend_pid: 591993 schedules a new batched migration994INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree995INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"996INFO: "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 rows997INFO: analyzing "public.p_ci_job_annotations" inheritance tree998INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"999INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1000INFO: analyzing "public.p_ci_builds_metadata" inheritance tree1001INFO: analyzing "public.ci_builds_metadata"1002INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1003INFO: analyzing "public.p_ci_builds" inheritance tree1004INFO: analyzing "public.ci_builds"1005INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1006SwapColumnsForCiPipelineVariablesPipelineIdBigint1007 # order random1008 behaves like swap conversion columns1009main: == [advisory_lock_connection] object_id: 450292020, pg_backend_pid: 6021010main: == 20231017064317 SwapColumnsForCiPipelineVariablesPipelineIdBigint: migrating 1011main: -- execute("LOCK TABLE ci_pipelines, ci_pipeline_variables IN ACCESS EXCLUSIVE MODE")1012main: -> 0.0013s1013main: -- clear_cache!(nil)1014main: -> 0.0000s1015main: -- quote_table_name(:ci_pipeline_variables)1016main: -> 0.0000s1017main: -- quote_column_name(:pipeline_id)1018main: -> 0.0000s1019main: -- quote_column_name(:temp_name_for_renaming)1020main: -> 0.0000s1021main: -- execute("ALTER TABLE \"ci_pipeline_variables\"\n RENAME COLUMN \"pipeline_id\" TO \"temp_name_for_renaming\"\n")1022main: -> 0.0010s1023main: -- clear_cache!(nil)1024main: -> 0.0000s1025main: -- quote_table_name(:ci_pipeline_variables)1026main: -> 0.0000s1027main: -- quote_column_name(:pipeline_id_convert_to_bigint)1028main: -> 0.0000s1029main: -- quote_column_name(:pipeline_id)1030main: -> 0.0000s1031main: -- execute("ALTER TABLE \"ci_pipeline_variables\"\n RENAME COLUMN \"pipeline_id_convert_to_bigint\" TO \"pipeline_id\"\n")1032main: -> 0.0010s1033main: -- clear_cache!(nil)1034main: -> 0.0000s1035main: -- quote_table_name(:ci_pipeline_variables)1036main: -> 0.0000s1037main: -- quote_column_name(:temp_name_for_renaming)1038main: -> 0.0000s1039main: -- quote_column_name(:pipeline_id_convert_to_bigint)1040main: -> 0.0000s1041main: -- execute("ALTER TABLE \"ci_pipeline_variables\"\n RENAME COLUMN \"temp_name_for_renaming\" TO \"pipeline_id_convert_to_bigint\"\n")1042main: -> 0.0011s1043main: -- quote_table_name(:trigger_7f3d66a7d7f5)1044main: -> 0.0000s1045main: -- execute("ALTER FUNCTION \"trigger_7f3d66a7d7f5\" RESET ALL")1046main: -> 0.0009s1047main: -- columns(:ci_pipeline_variables)1048main: -> 0.0034s1049main: -- columns(:ci_pipeline_variables)1050main: -> 0.0029s1051main: -- change_column_default(:ci_pipeline_variables, :pipeline_id, nil)1052main: -> 0.0043s1053main: -- change_column_default(:ci_pipeline_variables, :pipeline_id_convert_to_bigint, "0")1054main: -> 0.0045s1055main: -- quote_table_name(:ci_pipeline_variables)1056main: -> 0.0000s1057main: -- quote_column_name(:fk_f29c5f4380)1058main: -> 0.0000s1059main: -- quote_column_name(:temp_name_for_renaming)1060main: -> 0.0000s1061main: -- execute("ALTER TABLE \"ci_pipeline_variables\"\nRENAME CONSTRAINT \"fk_f29c5f4380\" TO \"temp_name_for_renaming\"\n")1062main: -> 0.0012s1063main: -- quote_table_name(:ci_pipeline_variables)1064main: -> 0.0000s1065main: -- quote_column_name(:temp_fk_rails_8d3b04e3e1)1066main: -> 0.0000s1067main: -- quote_column_name(:fk_f29c5f4380)1068main: -> 0.0000s1069main: -- execute("ALTER TABLE \"ci_pipeline_variables\"\nRENAME CONSTRAINT \"temp_fk_rails_8d3b04e3e1\" TO \"fk_f29c5f4380\"\n")1070main: -> 0.0011s1071main: -- quote_table_name(:ci_pipeline_variables)1072main: -> 0.0000s1073main: -- quote_column_name(:temp_name_for_renaming)1074main: -> 0.0000s1075main: -- quote_column_name(:temp_fk_rails_8d3b04e3e1)1076main: -> 0.0000s1077main: -- execute("ALTER TABLE \"ci_pipeline_variables\"\nRENAME CONSTRAINT \"temp_name_for_renaming\" TO \"temp_fk_rails_8d3b04e3e1\"\n")1078main: -> 0.0011s1079main: -- rename_index(:ci_pipeline_variables, :index_ci_pipeline_variables_on_pipeline_id_and_key, "temp_08b4f3fae3")1080main: -> 0.0010s1081main: -- rename_index(:ci_pipeline_variables, :index_ci_pipeline_variables_on_pipeline_id_bigint_and_key, :index_ci_pipeline_variables_on_pipeline_id_and_key)1082main: -> 0.0010s1083main: -- rename_index(:ci_pipeline_variables, "temp_08b4f3fae3", :index_ci_pipeline_variables_on_pipeline_id_bigint_and_key)1084main: -> 0.0010s1085main: == 20231017064317 SwapColumnsForCiPipelineVariablesPipelineIdBigint: migrated (0.0418s) 1086main: == [advisory_lock_connection] object_id: 450292020, pg_backend_pid: 6021087 correctly swaps conversion columns1088auto_explain log contains 916 entries for main, writing to /builds/gitlab-org/gitlab/auto_explain/rspec-migration-pg14-single-db-ci-connection-2-8.328.main.ndjson.gz1089took 15.0323056631090auto_explain log contains 916 entries for ci, writing to /builds/gitlab-org/gitlab/auto_explain/rspec-migration-pg14-single-db-ci-connection-2-8.328.ci.ndjson.gz1091took 12.8590462651092Knapsack report was generated. Preview:1093{1094 "spec/migrations/sync_new_amount_used_for_ci_namespace_monthly_usages_spec.rb": 54.02402077499937,1095 "spec/migrations/finalize_invalid_member_cleanup_spec.rb": 63.92294567099998,1096 "spec/migrations/finalize_issues_namespace_id_backfilling_spec.rb": 65.2071967490001,1097 "spec/migrations/20221215151822_schedule_backfill_releases_author_id_spec.rb": 55.83227210599944,1098 "spec/migrations/second_recount_epic_cache_counts_spec.rb": 60.113457114000084,1099 "spec/migrations/20230209222452_schedule_remove_project_group_link_with_missing_groups_spec.rb": 52.251200787000016,1100 "spec/migrations/20230130073109_nullify_creator_id_of_orphaned_projects_spec.rb": 49.12264630699974,1101 "spec/migrations/finalize_issues_iid_scoping_to_namespace_spec.rb": 50.071516660999805,1102 "spec/migrations/20230117114739_clear_duplicate_jobs_cookies_spec.rb": 49.160863493999386,1103 "spec/migrations/swap_timelogs_note_id_to_bigint_for_gitlab_dot_com_spec.rb": 48.882355865000136,1104 "spec/migrations/20230224144233_migrate_evidences_from_raw_metadata_spec.rb": 49.541761887000575,1105 "spec/migrations/20230131125844_add_project_id_name_id_version_index_to_installable_npm_packages_spec.rb": 49.40469198700066,1106 "spec/migrations/swap_note_diff_files_note_id_to_bigint_for_gitlab_dot_com_spec.rb": 43.945860073000404,1107 "spec/migrations/swap_epic_user_mentions_note_id_to_bigint_for_gitlab_dot_com_spec.rb": 38.46509617999982,1108 "spec/migrations/20230302811133_re_migrate_redis_slot_keys_spec.rb": 40.749711780000325,1109 "spec/migrations/20230314144640_reschedule_migration_for_links_spec.rb": 42.153226430999894,1110 "spec/migrations/swap_system_note_metadata_note_id_to_bigint_for_gitlab_dot_com_spec.rb": 38.862639531999775,1111 "spec/migrations/20230303105806_queue_delete_orphaned_packages_dependencies_spec.rb": 42.649807881000015,1112 "spec/migrations/20230428085332_remove_shimo_zentao_integration_records_spec.rb": 38.90537254599985,1113 "spec/migrations/20230504084524_remove_gitlab_import_source_spec.rb": 38.99884102999931,1114 "spec/migrations/20230419105225_remove_phabricator_from_application_settings_spec.rb": 41.96251337800004,1115 "spec/migrations/20230608195429_redo_remove_create_learn_gitlab_worker_job_instances_spec.rb": 24.14396094299991,1116 "spec/migrations/swap_todos_note_id_to_bigint_for_self_managed_spec.rb": 24.6192655800005,1117 "spec/migrations/swap_events_target_id_to_bigint_for_gitlab_dot_com_spec.rb": 19.943542519999937,1118 "spec/migrations/20230803125434_add_has_merge_request_on_vulnerability_reads_trigger_spec.rb": 16.489295254999888,1119 "spec/migrations/20230920154302_change_epics_hierarchy_restrictions_spec.rb": 14.576100244999907,1120 "spec/migrations/swap_merge_request_user_mentions_note_id_to_bigint_for_self_managed_spec.rb": 13.683900998000354,1121 "spec/migrations/20230906204935_restart_self_hosted_sent_notifications_backfill_spec.rb": 14.022264637000262,1122 "spec/migrations/20230810124545_schedule_fixing_namespace_ids_of_vulnerability_reads_spec.rb": 9.857378344000608,1123 "spec/migrations/20230821081603_queue_convert_credit_card_validation_data_to_hashes_spec.rb": 8.301021418000346,1124 "spec/migrations/20230830121830_queue_update_users_set_external_if_service_account_spec.rb": 8.036264143000153,1125 "spec/migrations/20230905064317_swap_columns_for_ci_pipeline_variables_pipeline_id_bigint_spec.rb": 2.6149784969993561126}1127Knapsack global time execution for tests: 19m 30s1128Finished in 41 minutes 46 seconds (files took 41.66 seconds to load)112978 examples, 0 failures1130Randomized with seed 130621131[TEST PROF INFO] Time spent in factories: 00:00.439 (0.02% of total time)1132RSpec exited with 0.1133No examples to retry, congrats!1135Running after script...1136$ echo -e "\e[0Ksection_start:`date +%s`:report_results_section[collapsed=true]\r\e[0KReport results"1140$ tooling/bin/push_job_metrics || true1141[job-metrics] Pushing job metrics file for the CI/CD job.1142[job-metrics] Pushed 4 CI job metric entries to InfluxDB.1144Not uploading cache ruby-gems-debian-bullseye-ruby-3.0-16 due to policy1146Uploading artifacts...1147auto_explain/: found 3 matching artifact files and directories 1148coverage/: found 5 matching artifact files and directories 1149crystalball/: found 2 matching artifact files and directories 1150WARNING: deprecations/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab) 1151knapsack/: found 4 matching artifact files and directories 1152rspec/: found 16 matching artifact files and directories 1153WARNING: tmp/capybara/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab) 1154log/*.log: found 13 matching artifact files and directories 1155WARNING: Upload request redirected location=https://gitlab.com/api/v4/jobs/5336650729/artifacts?artifact_format=zip&artifact_type=archive&expire_in=31d new-url=https://gitlab.com1156WARNING: Retrying... context=artifacts-uploader error=request redirected1157Uploading artifacts as "archive" to coordinator... 201 Created id=5336650729 responseStatus=201 Created token=64_sF3Rt1158Uploading artifacts...1159rspec/rspec-*.xml: found 1 matching artifact files and directories 1160WARNING: Upload request redirected location=https://gitlab.com/api/v4/jobs/5336650729/artifacts?artifact_format=gzip&artifact_type=junit&expire_in=31d new-url=https://gitlab.com1161WARNING: Retrying... context=artifacts-uploader error=request redirected1162Uploading artifacts as "junit" to coordinator... 201 Created id=5336650729 responseStatus=201 Created token=64_sF3Rt1164Job succeeded