rspec migration pg14 7/12
Passed Started
by
@vshushlin

Vladimir Shushlin
1Running with gitlab-runner 16.3.0~beta.108.g2b6048b4 (2b6048b4)2 on blue-1.private.runners-manager.gitlab.com/gitlab.com/gitlab-org 1zzGUpzq, system ID: s_fc31da7ae46e3 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-1zzgupzq-project-278964-concurrent-0 via runner-1zzgupzq-private-1697786053-aa80c214...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.78 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_iopUr48Downloading artifacts for detect-tests (5336650454)...49Downloading artifacts from coordinator... ok host=storage.googleapis.com id=5336650454 responseStatus=200 OK token=64_iopUr50Downloading artifacts for retrieve-tests-metadata (5336650473)...51Downloading artifacts from coordinator... ok host=storage.googleapis.com id=5336650473 responseStatus=200 OK token=64_iopUr52Downloading artifacts for setup-test-env (5336650424)...53Downloading artifacts from coordinator... ok host=storage.googleapis.com id=5336650424 responseStatus=200 OK token=64_iopUr55Using 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 decomposed database config (config/database.yml.decomposed-postgresql)94Geo DB won't be set up.95Embedding DB won't be set up.125$ source ./scripts/rspec_helpers.sh126$ run_timed_command "gem install knapsack --no-document"127$ gem install knapsack --no-document128Successfully installed knapsack-4.0.01291 gem installed130==> 'gem install knapsack --no-document' succeeded in 1 seconds.131$ section_start "gitaly-test-spawn" "Spawning Gitaly"; scripts/gitaly-test-spawn; section_end "gitaly-test-spawn"136$ export RSPEC_SKIPPED_TESTS_REPORT_PATH="rspec/skipped_tests-${CI_JOB_ID}.txt"137$ export RSPEC_RETRIED_TESTS_REPORT_PATH="rspec/retried_tests-${CI_JOB_ID}.txt"138$ tooling/bin/create_job_metrics_file || true139[job-metrics] Creating the job metrics file for the CI/CD job.140$ rspec_paralellized_job "--fail-fast=${RSPEC_FAIL_FAST_THRESHOLD} --tag ~quarantine --tag ~zoekt --tag ~click_house"141RETRY_FAILED_TESTS_IN_NEW_PROCESS: true142KNAPSACK_GENERATE_REPORT: true143FLAKY_RSPEC_GENERATE_REPORT: true144KNAPSACK_TEST_FILE_PATTERN: spec/{migrations}{,/**/}*_spec.rb145KNAPSACK_LOG_LEVEL: debug146KNAPSACK_REPORT_PATH: knapsack/rspec_migration_pg14_7_12_report.json147FLAKY_RSPEC_SUITE_REPORT_PATH: rspec/flaky/report-suite.json148FLAKY_RSPEC_REPORT_PATH: rspec/flaky/all_rspec_migration_pg14_7_12_report.json149NEW_FLAKY_RSPEC_REPORT_PATH: rspec/flaky/new_rspec_migration_pg14_7_12_report.json150RSPEC_SKIPPED_TESTS_REPORT_PATH: rspec/skipped_tests-5336650667.txt151CRYSTALBALL: 152RSPEC_TESTS_MAPPING_ENABLED: 153RSPEC_TESTS_FILTER_FILE: 154Shell set options (set -o) enabled:155braceexpand on156hashall on157interactive-comments on158pipefail on159Knapsack report generator started!160/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!161/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!162/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!163/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!164/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!165/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!166/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!167/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!168/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!169/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!170/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!171/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!172/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!173/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!174/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!175/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!176/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!177/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!178/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!179/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!180/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!181/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!182/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!183/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!184/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!185/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!186/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!187/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!188/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!189/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!190/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!191/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!192/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!193/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!194/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!195/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!196/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!197/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!198/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!199/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!200/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!201/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!202/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!203/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!204/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!205/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!206/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!207/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!208/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!209/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!210/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!211/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!212/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!213Run options: exclude {:quarantine=>true, :zoekt=>true, :click_house=>true}214Test environment set up in 0.773738193 seconds215EncryptCiTriggerToken216 # order random217 #up218 with migration present219 when migration finished successfully220ci: == [advisory_lock_connection] object_id: 34704880, pg_backend_pid: 1433221ci: == 20230202131928 EncryptCiTriggerToken: migrating ============================222ci: == 20230202131928 EncryptCiTriggerToken: migrated (0.1252s) ===================223ci: == [advisory_lock_connection] object_id: 34704880, pg_backend_pid: 1433224 does not raise exception225ci: == [advisory_lock_connection] object_id: 35828760, pg_backend_pid: 1439226ci: == 20230202131928 EncryptCiTriggerToken: migrating ============================227ci: == 20230202131928 EncryptCiTriggerToken: migrated (0.0633s) ===================228ci: == [advisory_lock_connection] object_id: 35828760, pg_backend_pid: 1439229 schedules background jobs for each batch of ci_triggers230 #down231ci: == [advisory_lock_connection] object_id: 36307580, pg_backend_pid: 1445232ci: == 20230202131928 EncryptCiTriggerToken: migrating ============================233ci: == 20230202131928 EncryptCiTriggerToken: migrated (0.0640s) ===================234ci: == [advisory_lock_connection] object_id: 36307580, pg_backend_pid: 1445235 deletes all batched migration records236I, [2023-10-20T08:30:17.559016 #328] INFO -- : Database: 'main', Table: 'p_ci_runner_machine_builds': Lock Writes237I, [2023-10-20T08:30:17.779934 #328] INFO -- : Database: 'main', Table: 'ci_cost_settings': Lock Writes238I, [2023-10-20T08:30:28.435289 #328] INFO -- : Database: 'main', Table: 'ci_editor_ai_conversation_messages': Lock Writes239I, [2023-10-20T08:30:31.238934 #328] INFO -- : Database: 'main', Table: 'p_ci_builds': Lock Writes240I, [2023-10-20T08:30:31.239875 #328] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}241I, [2023-10-20T08:30:31.240542 #328] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}242I, [2023-10-20T08:30:44.070803 #328] INFO -- : Database: 'main', Table: 'p_ci_job_annotations': Lock Writes243INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree244INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"245INFO: "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 rows246INFO: analyzing "public.p_ci_job_annotations" inheritance tree247INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"248INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows249INFO: analyzing "public.p_ci_builds_metadata" inheritance tree250INFO: analyzing "public.ci_builds_metadata"251INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows252INFO: analyzing "public.p_ci_builds" inheritance tree253INFO: analyzing "public.ci_builds"254INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows255I, [2023-10-20T08:31:05.432481 #328] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes256I, [2023-10-20T08:31:11.827897 #328] INFO -- : Database: 'ci', Table: 'automation_rules': Lock Writes257I, [2023-10-20T08:31:12.996171 #328] INFO -- : Database: 'ci', Table: 'bulk_import_export_batches': Lock Writes258I, [2023-10-20T08:31:13.103436 #328] INFO -- : Database: 'ci', Table: 'bulk_import_batch_trackers': Lock Writes259I, [2023-10-20T08:31:14.523708 #328] INFO -- : Database: 'ci', Table: 'catalog_resources': Lock Writes260I, [2023-10-20T08:31:16.453138 #328] INFO -- : Database: 'ci', Table: 'design_management_repositories': Lock Writes261I, [2023-10-20T08:31:16.931923 #328] INFO -- : Database: 'ci', Table: 'container_registry_data_repair_details': Lock Writes262I, [2023-10-20T08:31:17.362484 #328] INFO -- : Database: 'ci', Table: 'search_indices': Lock Writes263I, [2023-10-20T08:31:17.391114 #328] INFO -- : Database: 'ci', Table: 'search_namespace_index_assignments': Lock Writes264I, [2023-10-20T08:31:17.454924 #328] INFO -- : Database: 'ci', Table: 'resource_link_events': Lock Writes265I, [2023-10-20T08:31:17.717202 #328] INFO -- : Database: 'ci', Table: 'packages_npm_metadata_caches': Lock Writes266I, [2023-10-20T08:31:18.098953 #328] INFO -- : Database: 'ci', Table: 'service_desk_custom_email_credentials': Lock Writes267I, [2023-10-20T08:31:19.860972 #328] INFO -- : Database: 'ci', Table: 'design_management_repository_states': Lock Writes268I, [2023-10-20T08:31:20.274103 #328] INFO -- : Database: 'ci', Table: 'dora_performance_scores': Lock Writes269I, [2023-10-20T08:31:24.613266 #328] INFO -- : Database: 'ci', Table: 'audit_events_instance_external_audit_event_destinations': Lock Writes270I, [2023-10-20T08:31:24.765135 #328] INFO -- : Database: 'ci', Table: 'agent_user_access_project_authorizations': Lock Writes271I, [2023-10-20T08:31:24.789876 #328] INFO -- : Database: 'ci', Table: 'agent_user_access_group_authorizations': Lock Writes272I, [2023-10-20T08:31:25.095131 #328] INFO -- : Database: 'ci', Table: 'abuse_trust_scores': Lock Writes273I, [2023-10-20T08:31:25.125307 #328] INFO -- : Database: 'ci', Table: 'pm_advisories': Lock Writes274I, [2023-10-20T08:31:25.127119 #328] INFO -- : Database: 'ci', Table: 'pm_affected_packages': Lock Writes275I, [2023-10-20T08:31:25.174024 #328] INFO -- : Database: 'ci', Table: 'issue_assignment_events': Lock Writes276I, [2023-10-20T08:31:26.621085 #328] INFO -- : Database: 'ci', Table: 'merge_request_assignment_events': Lock Writes277I, [2023-10-20T08:31:27.447228 #328] INFO -- : Database: 'ci', Table: 'project_states': Lock Writes278I, [2023-10-20T08:31:27.994896 #328] INFO -- : Database: 'ci', Table: 'organizations': Lock Writes279I, [2023-10-20T08:31:28.268610 #328] INFO -- : Database: 'ci', Table: 'value_stream_dashboard_counts': Lock Writes280I, [2023-10-20T08:31:28.364842 #328] INFO -- : Database: 'ci', Table: 'note_metadata': Lock Writes281I, [2023-10-20T08:31:28.692014 #328] INFO -- : Database: 'ci', Table: 'merge_request_diff_llm_summaries': Lock Writes282I, [2023-10-20T08:31:29.044659 #328] INFO -- : Database: 'ci', Table: 'value_stream_dashboard_aggregations': Lock Writes283I, [2023-10-20T08:31:29.199303 #328] INFO -- : Database: 'ci', Table: 'abuse_report_events': Lock Writes284I, [2023-10-20T08:31:30.102384 #328] INFO -- : Database: 'ci', Table: 'audit_events_google_cloud_logging_configurations': Lock Writes285I, [2023-10-20T08:31:33.412651 #328] INFO -- : Database: 'ci', Table: 'dependency_proxy_packages_settings': Lock Writes286I, [2023-10-20T08:31:33.413836 #328] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}287I, [2023-10-20T08:31:33.414584 #328] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}288I, [2023-10-20T08:31:33.500295 #328] INFO -- : Database: 'ci', Table: 'instance_audit_events_streaming_headers': Lock Writes289I, [2023-10-20T08:31:34.633710 #328] INFO -- : Database: 'ci', Table: 'abuse_events': Lock Writes290I, [2023-10-20T08:31:45.237783 #328] INFO -- : Database: 'ci', Table: 'subscription_add_ons': Lock Writes291I, [2023-10-20T08:31:45.263711 #328] INFO -- : Database: 'ci', Table: 'subscription_add_on_purchases': Lock Writes292I, [2023-10-20T08:31:45.533718 #328] INFO -- : Database: 'ci', Table: 'project_compliance_standards_adherence': Lock Writes293I, [2023-10-20T08:31:47.321616 #328] INFO -- : Database: 'ci', Table: 'organization_settings': Lock Writes294I, [2023-10-20T08:31:47.561473 #328] INFO -- : Database: 'ci', Table: 'organization_users': Lock Writes295I, [2023-10-20T08:31:48.081948 #328] INFO -- : Database: 'ci', Table: 'audit_events_streaming_instance_event_type_filters': Lock Writes296I, [2023-10-20T08:31:50.076205 #328] INFO -- : Database: 'ci', Table: 'subscription_user_add_on_assignments': Lock Writes297I, [2023-10-20T08:31:50.180960 #328] INFO -- : Database: 'ci', Table: 'system_access_microsoft_applications': Lock Writes298I, [2023-10-20T08:31:50.206092 #328] INFO -- : Database: 'ci', Table: 'system_access_microsoft_graph_access_tokens': Lock Writes299I, [2023-10-20T08:31:51.399693 #328] INFO -- : Database: 'ci', Table: 'merge_request_review_llm_summaries': Lock Writes300I, [2023-10-20T08:31:52.063268 #328] INFO -- : Database: 'ci', Table: 'catalog_resource_versions': Lock Writes301I, [2023-10-20T08:31:53.205274 #328] INFO -- : Database: 'ci', Table: 'p_batched_git_ref_updates_deletions': Lock Writes302I, [2023-10-20T08:31:53.227688 #328] INFO -- : Database: 'ci', Table: 'service_access_tokens': Lock Writes303I, [2023-10-20T08:31:53.254937 #328] INFO -- : Database: 'ci', Table: 'ml_models': Lock Writes304I, [2023-10-20T08:31:53.706334 #328] INFO -- : Database: 'ci', Table: 'ml_model_versions': Lock Writes305I, [2023-10-20T08:31:55.734906 #328] INFO -- : Database: 'ci', Table: 'group_ssh_certificates': Lock Writes306I, [2023-10-20T08:31:55.885710 #328] INFO -- : Database: 'ci', Table: 'group_wiki_repository_states': Lock Writes307I, [2023-10-20T08:31:56.156760 #328] INFO -- : Database: 'ci', Table: 'target_branch_rules': Lock Writes308I, [2023-10-20T08:31:59.646611 #328] INFO -- : Database: 'ci', Table: 'catalog_resource_components': Lock Writes309I, [2023-10-20T08:32:10.569834 #328] INFO -- : Database: 'ci', Table: 'workspace_variables': Lock Writes310I, [2023-10-20T08:32:10.730399 #328] INFO -- : Database: 'ci', Table: 'packages_nuget_symbols': Lock Writes311I, [2023-10-20T08:32:11.097304 #328] INFO -- : Database: 'ci', Table: 'audit_events_instance_google_cloud_logging_configurations': Lock Writes312I, [2023-10-20T08:32:12.503041 #328] INFO -- : Database: 'ci', Table: 'packages_protection_rules': Lock Writes313I, [2023-10-20T08:32:12.848717 #328] INFO -- : Database: 'ci', Table: 'projects_visits': Lock Writes314I, [2023-10-20T08:32:12.871302 #328] INFO -- : Database: 'ci', Table: 'groups_visits': Lock Writes315I, [2023-10-20T08:32:12.915169 #328] INFO -- : Database: 'ci', Table: 'audit_events_amazon_s3_configurations': Lock Writes316INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree317INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"318INFO: "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 rows319INFO: analyzing "public.p_ci_job_annotations" inheritance tree320INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"321INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows322INFO: analyzing "public.p_ci_builds_metadata" inheritance tree323INFO: analyzing "public.ci_builds_metadata"324INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows325INFO: analyzing "public.p_ci_builds" inheritance tree326INFO: analyzing "public.ci_builds"327INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows328I, [2023-10-20T08:32:13.735680 #328] INFO -- : Database: 'ci', Table: 'vs_code_settings': Lock Writes329I, [2023-10-20T08:32:14.252986 #328] INFO -- : Database: 'ci', Table: 'scan_result_policy_violations': Lock Writes330I, [2023-10-20T08:32:15.404286 #328] INFO -- : Database: 'ci', Table: 'analytics_cycle_analytics_value_stream_settings': Lock Writes331I, [2023-10-20T08:32:17.657064 #328] INFO -- : Database: 'ci', Table: 'work_item_related_link_restrictions': Lock Writes332I, [2023-10-20T08:32:17.806920 #328] INFO -- : Database: 'ci', Table: 'abuse_report_user_mentions': Lock Writes333I, [2023-10-20T08:32:18.192529 #328] INFO -- : Database: 'ci', Table: 'container_registry_protection_rules': Lock Writes334I, [2023-10-20T08:32:19.394802 #328] INFO -- : Database: 'ci', Table: 'activity_pub_releases_subscriptions': Lock Writes335SwapColumnsCiBuildNeedsBigIntConversion336 # order random337 #up338 dot_com: true, dev_or_test: true, jh: true, swap: false339 swaps the integer and bigint columns for GitLab.com, dev, or test340 dot_com: true, dev_or_test: false, jh: true, swap: false341 swaps the integer and bigint columns for GitLab.com, dev, or test342 dot_com: false, dev_or_test: true, jh: true, swap: false343 swaps the integer and bigint columns for GitLab.com, dev, or test344 dot_com: false, dev_or_test: false, jh: true, swap: false345 swaps the integer and bigint columns for GitLab.com, dev, or test346 dot_com: true, dev_or_test: true, jh: false, swap: true347 swaps the integer and bigint columns for GitLab.com, dev, or test348 dot_com: true, dev_or_test: false, jh: false, swap: true349 swaps the integer and bigint columns for GitLab.com, dev, or test350 dot_com: false, dev_or_test: true, jh: false, swap: true351 swaps the integer and bigint columns for GitLab.com, dev, or test352 dot_com: false, dev_or_test: false, jh: false, swap: false353 swaps the integer and bigint columns for GitLab.com, dev, or test354I, [2023-10-20T08:33:31.946829 #328] INFO -- : Database: 'main', Table: 'ci_editor_ai_conversation_messages': Lock Writes355I, [2023-10-20T08:33:34.809991 #328] INFO -- : Database: 'main', Table: 'p_ci_builds': Lock Writes356I, [2023-10-20T08:33:34.811147 #328] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}357I, [2023-10-20T08:33:34.812035 #328] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}358I, [2023-10-20T08:33:48.261655 #328] INFO -- : Database: 'main', Table: 'p_ci_job_annotations': Lock Writes359INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree360INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"361INFO: "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 rows362INFO: analyzing "public.p_ci_job_annotations" inheritance tree363INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"364INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows365INFO: analyzing "public.p_ci_builds_metadata" inheritance tree366INFO: analyzing "public.ci_builds_metadata"367INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows368INFO: analyzing "public.p_ci_builds" inheritance tree369INFO: analyzing "public.ci_builds"370INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows371I, [2023-10-20T08:34:10.328669 #328] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes372ScheduleBackfillReleasesAuthorId373 # order random374 when there are no releases without author375main: -- There are no releases with empty author_id, so skipping migration ScheduleBackfillReleasesAuthorId376 does not schedule batched migration377 when there are releases without author378main: == [advisory_lock_connection] object_id: 92750140, pg_backend_pid: 2799379main: == 20221215151822 ScheduleBackfillReleasesAuthorId: migrating =================380main: == 20221215151822 ScheduleBackfillReleasesAuthorId: migrated (0.0822s) ========381main: == [advisory_lock_connection] object_id: 92750140, pg_backend_pid: 2799382 schedules a new batched migration383I, [2023-10-20T08:35:12.808204 #328] INFO -- : Database: 'main', Table: 'ci_runner_machines': Lock Writes384I, [2023-10-20T08:35:18.554462 #328] INFO -- : Database: 'main', Table: 'p_ci_runner_machine_builds': Lock Writes385I, [2023-10-20T08:35:18.758742 #328] INFO -- : Database: 'main', Table: 'ci_cost_settings': Lock Writes386I, [2023-10-20T08:35:29.914978 #328] INFO -- : Database: 'main', Table: 'ci_editor_ai_conversation_messages': Lock Writes387I, [2023-10-20T08:35:32.948106 #328] INFO -- : Database: 'main', Table: 'p_ci_builds': Lock Writes388I, [2023-10-20T08:35:32.949316 #328] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}389I, [2023-10-20T08:35:32.950127 #328] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}390I, [2023-10-20T08:35:46.912084 #328] INFO -- : Database: 'main', Table: 'p_ci_job_annotations': Lock Writes391INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree392INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"393INFO: "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 rows394INFO: analyzing "public.p_ci_job_annotations" inheritance tree395INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"396INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows397INFO: analyzing "public.p_ci_builds_metadata" inheritance tree398INFO: analyzing "public.ci_builds_metadata"399INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows400INFO: analyzing "public.p_ci_builds" inheritance tree401INFO: analyzing "public.ci_builds"402INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows403I, [2023-10-20T08:36:09.721545 #328] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes404BackfillProjectStatisticsStorageSizeWithoutUploadsSize405 # order random406main: == [advisory_lock_connection] object_id: 116694240, pg_backend_pid: 2815407main: == 20221104115712 BackfillProjectStatisticsStorageSizeWithoutUploadsSize: migrating 408main: == 20221104115712 BackfillProjectStatisticsStorageSizeWithoutUploadsSize: migrated (0.0003s) 409main: == [advisory_lock_connection] object_id: 116694240, pg_backend_pid: 2815410 does not schedule background jobs when Gitlab.org_or_com? is false411main: == [advisory_lock_connection] object_id: 117697640, pg_backend_pid: 2818412main: == 20221104115712 BackfillProjectStatisticsStorageSizeWithoutUploadsSize: migrating 413main: == 20221104115712 BackfillProjectStatisticsStorageSizeWithoutUploadsSize: migrated (0.0415s) 414main: == [advisory_lock_connection] object_id: 117697640, pg_backend_pid: 2818415 schedules background jobs for each batch of project_statistics416I, [2023-10-20T08:37:19.971200 #328] INFO -- : Database: 'main', Table: 'ci_runner_machines': Lock Writes417I, [2023-10-20T08:37:25.914965 #328] INFO -- : Database: 'main', Table: 'p_ci_runner_machine_builds': Lock Writes418I, [2023-10-20T08:37:26.131324 #328] INFO -- : Database: 'main', Table: 'ci_cost_settings': Lock Writes419I, [2023-10-20T08:37:36.669734 #328] INFO -- : Database: 'main', Table: 'ci_editor_ai_conversation_messages': Lock Writes420I, [2023-10-20T08:37:39.680664 #328] INFO -- : Database: 'main', Table: 'p_ci_builds': Lock Writes421I, [2023-10-20T08:37:39.681702 #328] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}422I, [2023-10-20T08:37:39.682373 #328] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}423I, [2023-10-20T08:37:53.979713 #328] INFO -- : Database: 'main', Table: 'p_ci_job_annotations': Lock Writes424INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree425INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"426INFO: "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 rows427INFO: analyzing "public.p_ci_job_annotations" inheritance tree428INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"429INFO: "ci_job_annotations_100": 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_metadata" inheritance tree431INFO: analyzing "public.ci_builds_metadata"432INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows433INFO: analyzing "public.p_ci_builds" inheritance tree434INFO: analyzing "public.ci_builds"435INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows436I, [2023-10-20T08:38:17.741761 #328] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes437NullifyCreatorIdOfOrphanedProjects438 # order random439 #down440main: == [advisory_lock_connection] object_id: 141304540, pg_backend_pid: 2833441main: == 20230130073109 NullifyCreatorIdOfOrphanedProjects: migrating ===============442main: == 20230130073109 NullifyCreatorIdOfOrphanedProjects: migrated (0.0468s) ======443main: == [advisory_lock_connection] object_id: 141304540, pg_backend_pid: 2833444 removes scheduled background migrations445 #up446main: == [advisory_lock_connection] object_id: 141974560, pg_backend_pid: 2836447main: == 20230130073109 NullifyCreatorIdOfOrphanedProjects: migrating ===============448main: == 20230130073109 NullifyCreatorIdOfOrphanedProjects: migrated (0.0529s) ======449main: == [advisory_lock_connection] object_id: 141974560, pg_backend_pid: 2836450 schedules background migration451I, [2023-10-20T08:39:20.946533 #328] INFO -- : Database: 'main', Table: 'p_ci_runner_machine_builds': Lock Writes452I, [2023-10-20T08:39:21.193676 #328] INFO -- : Database: 'main', Table: 'ci_cost_settings': Lock Writes453I, [2023-10-20T08:39:31.747783 #328] INFO -- : Database: 'main', Table: 'ci_editor_ai_conversation_messages': Lock Writes454I, [2023-10-20T08:39:35.679524 #328] INFO -- : Database: 'main', Table: 'p_ci_builds': Lock Writes455I, [2023-10-20T08:39:35.680543 #328] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}456I, [2023-10-20T08:39:35.681247 #328] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}457I, [2023-10-20T08:39:49.435653 #328] INFO -- : Database: 'main', Table: 'p_ci_job_annotations': Lock Writes458INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree459INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"460INFO: "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 rows461INFO: analyzing "public.p_ci_job_annotations" inheritance tree462INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"463INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows464INFO: analyzing "public.p_ci_builds_metadata" inheritance tree465INFO: analyzing "public.ci_builds_metadata"466INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows467INFO: analyzing "public.p_ci_builds" inheritance tree468INFO: analyzing "public.ci_builds"469INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows470I, [2023-10-20T08:40:13.517028 #328] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes471DeleteQueuedJobsForVulnerabilitiesFeedbackMigration472 # order random473 #up474 deletes all batched migration records475I, [2023-10-20T08:41:16.187673 #328] INFO -- : Database: 'main', Table: 'ci_runner_machines': Lock Writes476I, [2023-10-20T08:41:21.937622 #328] INFO -- : Database: 'main', Table: 'p_ci_runner_machine_builds': Lock Writes477I, [2023-10-20T08:41:22.162819 #328] INFO -- : Database: 'main', Table: 'ci_cost_settings': Lock Writes478I, [2023-10-20T08:41:32.662709 #328] INFO -- : Database: 'main', Table: 'ci_editor_ai_conversation_messages': Lock Writes479I, [2023-10-20T08:41:35.556483 #328] INFO -- : Database: 'main', Table: 'p_ci_builds': Lock Writes480I, [2023-10-20T08:41:35.557458 #328] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}481I, [2023-10-20T08:41:35.558141 #328] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}482I, [2023-10-20T08:41:50.492457 #328] INFO -- : Database: 'main', Table: 'p_ci_job_annotations': Lock Writes483INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree484INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"485INFO: "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 rows486INFO: analyzing "public.p_ci_job_annotations" inheritance tree487INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"488INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows489INFO: analyzing "public.p_ci_builds_metadata" inheritance tree490INFO: analyzing "public.ci_builds_metadata"491INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows492INFO: analyzing "public.p_ci_builds" inheritance tree493INFO: analyzing "public.ci_builds"494INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows495I, [2023-10-20T08:42:14.779279 #328] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes496ScheduleMigrateSharedVulnerabilityIdentifiers497 # order random498 #down499 deletes500 #up501main: == [advisory_lock_connection] object_id: 186480220, pg_backend_pid: 2867502main: == 20230221093536 ScheduleMigrateSharedVulnerabilityIdentifiers: migrating ====503main: == 20230221093536 ScheduleMigrateSharedVulnerabilityIdentifiers: migrated (0.0476s) 504main: == [advisory_lock_connection] object_id: 186480220, pg_backend_pid: 2867505 schedules506The application_settings (main) table has 1306 columns.507Recreating the database508Dropped database 'gitlabhq_test'509Dropped database 'gitlabhq_test_ci'510Created database 'gitlabhq_test'511Created database 'gitlabhq_test_ci'512main: == [advisory_lock_connection] object_id: 186601400, pg_backend_pid: 2878513main: == [advisory_lock_connection] object_id: 186601400, pg_backend_pid: 2878514ci: == [advisory_lock_connection] object_id: 186678620, pg_backend_pid: 2880515ci: == [advisory_lock_connection] object_id: 186678620, pg_backend_pid: 2880516Databases re-creation done in 11.177540720999787517RescheduleMigrationForRemediation518 # order random519 #down520main: == [advisory_lock_connection] object_id: 193462420, pg_backend_pid: 2886521main: == 20230313150531 RescheduleMigrationForRemediation: migrating ================522main: == 20230313150531 RescheduleMigrationForRemediation: migrated (0.0522s) =======523main: == [advisory_lock_connection] object_id: 193462420, pg_backend_pid: 2886524 deletes all batched migration records525 #up526main: == [advisory_lock_connection] object_id: 194244820, pg_backend_pid: 2889527main: == 20230313150531 RescheduleMigrationForRemediation: migrating ================528main: == 20230313150531 RescheduleMigrationForRemediation: migrated (0.0541s) =======529main: == [advisory_lock_connection] object_id: 194244820, pg_backend_pid: 2889530 schedules a batched background migration531I, [2023-10-20T08:44:14.952866 #328] INFO -- : Database: 'main', Table: 'ci_editor_ai_conversation_messages': Lock Writes532I, [2023-10-20T08:44:17.865200 #328] INFO -- : Database: 'main', Table: 'p_ci_builds': Lock Writes533I, [2023-10-20T08:44:17.866160 #328] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}534I, [2023-10-20T08:44:17.866838 #328] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}535I, [2023-10-20T08:44:31.053171 #328] INFO -- : Database: 'main', Table: 'p_ci_job_annotations': Lock Writes536INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree537INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"538INFO: "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 rows539INFO: analyzing "public.p_ci_job_annotations" inheritance tree540INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"541INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows542INFO: analyzing "public.p_ci_builds_metadata" inheritance tree543INFO: analyzing "public.ci_builds_metadata"544INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows545INFO: analyzing "public.p_ci_builds" inheritance tree546INFO: analyzing "public.ci_builds"547INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows548I, [2023-10-20T08:44:52.774732 #328] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes549SwapIssueUserMentionsNoteIdToBigintForGitlabDotCom2550 # order random551 #up552 swaps the integer and bigint columns for GitLab.com, dev, or test553 is a no-op for other instances554main: == [advisory_lock_connection] object_id: 212354480, pg_backend_pid: 2909555main: == 20230413041917 SwapIssueUserMentionsNoteIdToBigintForGitlabDotCom2: migrating 556main: -- columns("issue_user_mentions")557main: -> 0.0028s558main: == 20230413041917 SwapIssueUserMentionsNoteIdToBigintForGitlabDotCom2: migrated (0.0094s) 559main: == [advisory_lock_connection] object_id: 212354480, pg_backend_pid: 2909560 is a no-op if columns are already swapped561I, [2023-10-20T08:45:42.735005 #328] INFO -- : Database: 'main', Table: 'ci_editor_ai_conversation_messages': Lock Writes562I, [2023-10-20T08:45:45.760418 #328] INFO -- : Database: 'main', Table: 'p_ci_builds': Lock Writes563I, [2023-10-20T08:45:45.761621 #328] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}564I, [2023-10-20T08:45:45.762429 #328] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}565I, [2023-10-20T08:45:58.464606 #328] INFO -- : Database: 'main', Table: 'p_ci_job_annotations': Lock Writes566INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree567INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"568INFO: "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 rows569INFO: analyzing "public.p_ci_job_annotations" inheritance tree570INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"571INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows572INFO: analyzing "public.p_ci_builds_metadata" inheritance tree573INFO: analyzing "public.ci_builds_metadata"574INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows575INFO: analyzing "public.p_ci_builds" inheritance tree576INFO: analyzing "public.ci_builds"577INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows578I, [2023-10-20T08:46:20.809633 #328] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes579RescheduleMigrateEvidences580 # order random581 #up582main: == [advisory_lock_connection] object_id: 228223320, pg_backend_pid: 2922583main: == 20230330103104 RescheduleMigrateEvidences: migrating =======================584main: == 20230330103104 RescheduleMigrateEvidences: migrated (0.0072s) ==============585main: == [advisory_lock_connection] object_id: 228223320, pg_backend_pid: 2922586 does not schedule a batched background migration587 #down588main: == [advisory_lock_connection] object_id: 228931080, pg_backend_pid: 2925589main: == 20230330103104 RescheduleMigrateEvidences: migrating =======================590main: == 20230330103104 RescheduleMigrateEvidences: migrated (0.0065s) ==============591main: == [advisory_lock_connection] object_id: 228931080, pg_backend_pid: 2925592 deletes all batched migration records593I, [2023-10-20T08:47:13.596094 #328] INFO -- : Database: 'main', Table: 'ci_editor_ai_conversation_messages': Lock Writes594I, [2023-10-20T08:47:16.697553 #328] INFO -- : Database: 'main', Table: 'p_ci_builds': Lock Writes595I, [2023-10-20T08:47:16.698712 #328] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}596I, [2023-10-20T08:47:16.699405 #328] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}597I, [2023-10-20T08:47:29.831937 #328] INFO -- : Database: 'main', Table: 'p_ci_job_annotations': Lock Writes598INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree599INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"600INFO: "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 rows601INFO: analyzing "public.p_ci_job_annotations" inheritance tree602INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"603INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows604INFO: analyzing "public.p_ci_builds_metadata" inheritance tree605INFO: analyzing "public.ci_builds_metadata"606INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows607INFO: analyzing "public.p_ci_builds" inheritance tree608INFO: analyzing "public.ci_builds"609INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows610I, [2023-10-20T08:47:53.027547 #328] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes611EnsureDesignUserMentionsNoteIdBigintBackfillIsFinishedForGitlabDotCom612 # order random613 #up614main: == [advisory_lock_connection] object_id: 245961820, pg_backend_pid: 2939615main: == 20230321024333 EnsureDesignUserMentionsNoteIdBigintBackfillIsFinishedForGitlabDotCom: migrating 616main: == 20230321024333 EnsureDesignUserMentionsNoteIdBigintBackfillIsFinishedForGitlabDotCom: migrated (0.0061s) 617main: == [advisory_lock_connection] object_id: 245961820, pg_backend_pid: 2939618 ensures the migration is completed for GitLab.com, dev, or test619main: == [advisory_lock_connection] object_id: 246576160, pg_backend_pid: 2941620main: == 20230321024333 EnsureDesignUserMentionsNoteIdBigintBackfillIsFinishedForGitlabDotCom: migrating 621main: == 20230321024333 EnsureDesignUserMentionsNoteIdBigintBackfillIsFinishedForGitlabDotCom: migrated (0.0065s) 622main: == [advisory_lock_connection] object_id: 246576160, pg_backend_pid: 2941623 skips the check for other instances624I, [2023-10-20T08:48:50.905709 #328] INFO -- : Database: 'main', Table: 'ci_editor_ai_conversation_messages': Lock Writes625I, [2023-10-20T08:48:54.876681 #328] INFO -- : Database: 'main', Table: 'p_ci_builds': Lock Writes626I, [2023-10-20T08:48:54.878078 #328] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}627I, [2023-10-20T08:48:54.878780 #328] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}628I, [2023-10-20T08:49:08.028312 #328] INFO -- : Database: 'main', Table: 'p_ci_job_annotations': Lock Writes629INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree630INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"631INFO: "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 rows632INFO: analyzing "public.p_ci_job_annotations" inheritance tree633INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"634INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows635INFO: analyzing "public.p_ci_builds_metadata" inheritance tree636INFO: analyzing "public.ci_builds_metadata"637INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows638INFO: analyzing "public.p_ci_builds" inheritance tree639INFO: analyzing "public.ci_builds"640INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows641I, [2023-10-20T08:49:31.404791 #328] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes642EnsureMergeRequestMetricsIdBigintBackfillIsFinishedForSelfHosts643 # order random644 #up645main: == [advisory_lock_connection] object_id: 262905940, pg_backend_pid: 2955646main: == 20230419094535 EnsureMergeRequestMetricsIdBigintBackfillIsFinishedForSelfHosts: migrating 647main: == 20230419094535 EnsureMergeRequestMetricsIdBigintBackfillIsFinishedForSelfHosts: migrated (0.0061s) 648main: == [advisory_lock_connection] object_id: 262905940, pg_backend_pid: 2955649 ensures the migration is completed650I, [2023-10-20T08:50:19.137288 #328] INFO -- : Database: 'main', Table: 'ci_editor_ai_conversation_messages': Lock Writes651I, [2023-10-20T08:50:22.178342 #328] INFO -- : Database: 'main', Table: 'p_ci_builds': Lock Writes652I, [2023-10-20T08:50:22.179383 #328] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}653I, [2023-10-20T08:50:22.180092 #328] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}654I, [2023-10-20T08:50:35.654023 #328] INFO -- : Database: 'main', Table: 'p_ci_job_annotations': Lock Writes655INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree656INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"657INFO: "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 rows658INFO: analyzing "public.p_ci_job_annotations" inheritance tree659INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"660INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows661INFO: analyzing "public.p_ci_builds_metadata" inheritance tree662INFO: analyzing "public.ci_builds_metadata"663INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows664INFO: analyzing "public.p_ci_builds" inheritance tree665INFO: analyzing "public.ci_builds"666INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows667I, [2023-10-20T08:50:59.240820 #328] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes668DropSoftwareLicensesTempIndex669 # order random670main: == [advisory_lock_connection] object_id: 279104340, pg_backend_pid: 2968671main: == 20230329100222 DropSoftwareLicensesTempIndex: migrating ====================672main: -- view_exists?(:postgres_partitions)673main: -> 0.0031s674main: -- indexes(:software_licenses)675main: -> 0.0083s676main: -- remove_index(:software_licenses, {:algorithm=>:concurrently, :name=>"tmp_index_for_software_licenses_spdx_identifier_cleanup"})677main: -> 0.0013s678main: == 20230329100222 DropSoftwareLicensesTempIndex: migrated (0.0341s) ===========679main: == [advisory_lock_connection] object_id: 279104340, pg_backend_pid: 2968680 correctly migrates up and down681I, [2023-10-20T08:51:53.343796 #328] INFO -- : Database: 'main', Table: 'ci_editor_ai_conversation_messages': Lock Writes682I, [2023-10-20T08:51:56.305984 #328] INFO -- : Database: 'main', Table: 'p_ci_builds': Lock Writes683I, [2023-10-20T08:51:56.307076 #328] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}684I, [2023-10-20T08:51:56.307793 #328] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}685I, [2023-10-20T08:52:10.322081 #328] INFO -- : Database: 'main', Table: 'p_ci_job_annotations': Lock Writes686INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree687INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"688INFO: "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 rows689INFO: analyzing "public.p_ci_job_annotations" inheritance tree690INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"691INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows692INFO: analyzing "public.p_ci_builds_metadata" inheritance tree693INFO: analyzing "public.ci_builds_metadata"694INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows695INFO: analyzing "public.p_ci_builds" inheritance tree696INFO: analyzing "public.ci_builds"697INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows698I, [2023-10-20T08:52:34.718068 #328] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes699EnsureNotesBigintBackfillIsFinishedForGitlabDotCom700 # order random701 #up702main: == [advisory_lock_connection] object_id: 295253300, pg_backend_pid: 2983703main: == 20230504010535 EnsureNotesBigintBackfillIsFinishedForGitlabDotCom: migrating 704main: == 20230504010535 EnsureNotesBigintBackfillIsFinishedForGitlabDotCom: migrated (0.0070s) 705main: == [advisory_lock_connection] object_id: 295253300, pg_backend_pid: 2983706 ensures the migration is completed for GitLab.com, dev, or test707main: == [advisory_lock_connection] object_id: 295914740, pg_backend_pid: 2985708main: == 20230504010535 EnsureNotesBigintBackfillIsFinishedForGitlabDotCom: migrating 709main: == 20230504010535 EnsureNotesBigintBackfillIsFinishedForGitlabDotCom: migrated (0.0062s) 710main: == [advisory_lock_connection] object_id: 295914740, pg_backend_pid: 2985711 skips the check for other instances712I, [2023-10-20T08:53:26.203465 #328] INFO -- : Database: 'main', Table: 'p_ci_builds': Lock Writes713I, [2023-10-20T08:53:26.204571 #328] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}714I, [2023-10-20T08:53:26.205300 #328] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}715I, [2023-10-20T08:53:40.361541 #328] INFO -- : Database: 'main', Table: 'p_ci_job_annotations': Lock Writes716INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree717INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"718INFO: "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 rows719INFO: analyzing "public.p_ci_job_annotations" inheritance tree720INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"721INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows722INFO: analyzing "public.p_ci_builds_metadata" inheritance tree723INFO: analyzing "public.ci_builds_metadata"724INFO: "ci_builds_metadata": 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_builds" inheritance tree726INFO: analyzing "public.ci_builds"727INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows728I, [2023-10-20T08:54:05.313568 #328] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes729SwapNotesIdToBigintForSelfManaged730 # order random731 #up732 when GitLab.com, dev, or test733 behaves like column `id_convert_to_bigint` is already dropped734 does not swaps the columns735 when self-managed instance with the `id_convert_to_bigint` column already dropped736 behaves like column `id_convert_to_bigint` is already dropped737 does not swaps the columns738 when self-managed instance columns already swapped739 does not swaps the columns740 when self-managed instance741 swaps the columns742 when having different naming for fk_d83a918cb1 foreign key743 swaps the columns744The application_settings (main) table has 1233 columns.745Recreating the database746Dropped database 'gitlabhq_test'747Dropped database 'gitlabhq_test_ci'748Created database 'gitlabhq_test'749Created database 'gitlabhq_test_ci'750main: == [advisory_lock_connection] object_id: 310743160, pg_backend_pid: 3020751main: == [advisory_lock_connection] object_id: 310743160, pg_backend_pid: 3020752ci: == [advisory_lock_connection] object_id: 310743260, pg_backend_pid: 3022753ci: == [advisory_lock_connection] object_id: 310743260, pg_backend_pid: 3022754Databases re-creation done in 11.133581908999986755AddExpiryNotifiedAtToMember756 # order random757main: == [advisory_lock_connection] object_id: 313684840, pg_backend_pid: 3028758main: == 20230707003301 AddExpiryNotifiedAtToMember: migrating ======================759main: -- add_column("members", "expiry_notified_at", :datetime_with_timezone)760main: -> 0.0014s761main: == 20230707003301 AddExpiryNotifiedAtToMember: migrated (0.0419s) =============762main: == [advisory_lock_connection] object_id: 313684840, pg_backend_pid: 3028763 correctly migrates up and down764INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree765INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"766INFO: "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 rows767INFO: analyzing "public.p_ci_job_annotations" inheritance tree768INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"769INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows770INFO: analyzing "public.p_ci_builds_metadata" inheritance tree771INFO: analyzing "public.ci_builds_metadata"772INFO: "ci_builds_metadata": 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_builds" inheritance tree774INFO: analyzing "public.ci_builds"775INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows776I, [2023-10-20T08:55:25.044711 #328] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes777QueueDeleteOrphanedTransferredProjectApprovalRules778 # order random779main: == [advisory_lock_connection] object_id: 320283200, pg_backend_pid: 3041780main: == 20230724164745 QueueDeleteOrphanedTransferredProjectApprovalRules: migrating 781main: == 20230724164745 QueueDeleteOrphanedTransferredProjectApprovalRules: migrated (0.0512s) 782main: == [advisory_lock_connection] object_id: 320283200, pg_backend_pid: 3041783 schedules a new batched migration784INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree785INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"786INFO: "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 rows787INFO: analyzing "public.p_ci_job_annotations" inheritance tree788INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"789INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows790INFO: analyzing "public.p_ci_builds_metadata" inheritance tree791INFO: analyzing "public.ci_builds_metadata"792INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows793INFO: analyzing "public.p_ci_builds" inheritance tree794INFO: analyzing "public.ci_builds"795INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows796I, [2023-10-20T08:56:05.960216 #328] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes797SwapSuggestionsNoteIdToBigintForSelfHosts798 # order random799 #up800 when GitLab.com, dev, or test801 does not swap the columns802 when self-managed instance with the columns already swapped803main: == [advisory_lock_connection] object_id: 325694620, pg_backend_pid: 3055804main: == 20230810103534 SwapSuggestionsNoteIdToBigintForSelfHosts: migrating ========805main: -- column_exists?("suggestions", "note_id_convert_to_bigint")806main: -> 0.0032s807main: -- columns("suggestions")808main: -> 0.0032s809main: == 20230810103534 SwapSuggestionsNoteIdToBigintForSelfHosts: migrated (0.0140s) 810main: == [advisory_lock_connection] object_id: 325694620, pg_backend_pid: 3055811 does not swap the columns812 when self-managed instance with the `note_id_convert_to_bigint` column already dropped813 does not swap the columns814 when self-managed instance815 swaps the columns816INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree817INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"818INFO: "ci_runner_machine_builds_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows819INFO: analyzing "public.p_ci_job_annotations" inheritance tree820INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"821INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows822INFO: analyzing "public.p_ci_builds_metadata" inheritance tree823INFO: analyzing "public.ci_builds_metadata"824INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows825INFO: analyzing "public.p_ci_builds" inheritance tree826INFO: analyzing "public.ci_builds"827INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows828I, [2023-10-20T08:56:32.300953 #328] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes829BackfillAlertManagementPrometheusIntegrations830 # order random831main: == [advisory_lock_connection] object_id: 329539900, pg_backend_pid: 3072832main: == 20230811211544 BackfillAlertManagementPrometheusIntegrations: migrating ====833main: -- execute("INSERT INTO alert_management_http_integrations (\n project_id,\n encrypted_token,\n encrypted_token_iv,\n active,\n name,\n endpoint_identifier,\n type_identifier,\n created_at,\n updated_at\n) SELECT\n project_alerting_settings.project_id,\n project_alerting_settings.encrypted_token,\n project_alerting_settings.encrypted_token_iv,\n COALESCE(integrations.active, FALSE),\n 'Prometheus',\n 'legacy-prometheus',\n 1, --type_identifiers { http: 0, prometheus: 1 }\n CURRENT_TIMESTAMP,\n CURRENT_TIMESTAMP\nFROM project_alerting_settings\nLEFT JOIN integrations\nON project_alerting_settings.project_id = integrations.project_id\nAND integrations.type_new = 'Integrations::Prometheus'\nWHERE project_alerting_settings.project_id BETWEEN 1 AND 1\nON CONFLICT DO NOTHING\n")834main: -> 0.0039s835main: -- execute("INSERT INTO alert_management_http_integrations (\n project_id,\n encrypted_token,\n encrypted_token_iv,\n active,\n name,\n endpoint_identifier,\n type_identifier,\n created_at,\n updated_at\n) SELECT\n project_alerting_settings.project_id,\n project_alerting_settings.encrypted_token,\n project_alerting_settings.encrypted_token_iv,\n COALESCE(integrations.active, FALSE),\n 'Prometheus',\n 'legacy-prometheus',\n 1, --type_identifiers { http: 0, prometheus: 1 }\n CURRENT_TIMESTAMP,\n CURRENT_TIMESTAMP\nFROM project_alerting_settings\nLEFT JOIN integrations\nON project_alerting_settings.project_id = integrations.project_id\nAND integrations.type_new = 'Integrations::Prometheus'\nWHERE project_alerting_settings.project_id BETWEEN 2 AND 2\nON CONFLICT DO NOTHING\n")836main: -> 0.0031s837main: -- execute("INSERT INTO alert_management_http_integrations (\n project_id,\n encrypted_token,\n encrypted_token_iv,\n active,\n name,\n endpoint_identifier,\n type_identifier,\n created_at,\n updated_at\n) SELECT\n project_alerting_settings.project_id,\n project_alerting_settings.encrypted_token,\n project_alerting_settings.encrypted_token_iv,\n COALESCE(integrations.active, FALSE),\n 'Prometheus',\n 'legacy-prometheus',\n 1, --type_identifiers { http: 0, prometheus: 1 }\n CURRENT_TIMESTAMP,\n CURRENT_TIMESTAMP\nFROM project_alerting_settings\nLEFT JOIN integrations\nON project_alerting_settings.project_id = integrations.project_id\nAND integrations.type_new = 'Integrations::Prometheus'\nWHERE project_alerting_settings.project_id BETWEEN 3 AND 3\nON CONFLICT DO NOTHING\n")838main: -> 0.0031s839main: == 20230811211544 BackfillAlertManagementPrometheusIntegrations: migrated (0.0403s) 840main: == [advisory_lock_connection] object_id: 329539900, pg_backend_pid: 3072841 correctly migrates up and down842 with existing synced http integrations843main: == [advisory_lock_connection] object_id: 330356300, pg_backend_pid: 3075844main: == 20230811211544 BackfillAlertManagementPrometheusIntegrations: migrating ====845main: -- execute("INSERT INTO alert_management_http_integrations (\n project_id,\n encrypted_token,\n encrypted_token_iv,\n active,\n name,\n endpoint_identifier,\n type_identifier,\n created_at,\n updated_at\n) SELECT\n project_alerting_settings.project_id,\n project_alerting_settings.encrypted_token,\n project_alerting_settings.encrypted_token_iv,\n COALESCE(integrations.active, FALSE),\n 'Prometheus',\n 'legacy-prometheus',\n 1, --type_identifiers { http: 0, prometheus: 1 }\n CURRENT_TIMESTAMP,\n CURRENT_TIMESTAMP\nFROM project_alerting_settings\nLEFT JOIN integrations\nON project_alerting_settings.project_id = integrations.project_id\nAND integrations.type_new = 'Integrations::Prometheus'\nWHERE project_alerting_settings.project_id BETWEEN 4 AND 4\nON CONFLICT DO NOTHING\n")846main: -> 0.0024s847main: -- execute("INSERT INTO alert_management_http_integrations (\n project_id,\n encrypted_token,\n encrypted_token_iv,\n active,\n name,\n endpoint_identifier,\n type_identifier,\n created_at,\n updated_at\n) SELECT\n project_alerting_settings.project_id,\n project_alerting_settings.encrypted_token,\n project_alerting_settings.encrypted_token_iv,\n COALESCE(integrations.active, FALSE),\n 'Prometheus',\n 'legacy-prometheus',\n 1, --type_identifiers { http: 0, prometheus: 1 }\n CURRENT_TIMESTAMP,\n CURRENT_TIMESTAMP\nFROM project_alerting_settings\nLEFT JOIN integrations\nON project_alerting_settings.project_id = integrations.project_id\nAND integrations.type_new = 'Integrations::Prometheus'\nWHERE project_alerting_settings.project_id BETWEEN 5 AND 5\nON CONFLICT DO NOTHING\n")848main: -> 0.0020s849main: -- execute("INSERT INTO alert_management_http_integrations (\n project_id,\n encrypted_token,\n encrypted_token_iv,\n active,\n name,\n endpoint_identifier,\n type_identifier,\n created_at,\n updated_at\n) SELECT\n project_alerting_settings.project_id,\n project_alerting_settings.encrypted_token,\n project_alerting_settings.encrypted_token_iv,\n COALESCE(integrations.active, FALSE),\n 'Prometheus',\n 'legacy-prometheus',\n 1, --type_identifiers { http: 0, prometheus: 1 }\n CURRENT_TIMESTAMP,\n CURRENT_TIMESTAMP\nFROM project_alerting_settings\nLEFT JOIN integrations\nON project_alerting_settings.project_id = integrations.project_id\nAND integrations.type_new = 'Integrations::Prometheus'\nWHERE project_alerting_settings.project_id BETWEEN 6 AND 6\nON CONFLICT DO NOTHING\n")850main: -> 0.0022s851main: == 20230811211544 BackfillAlertManagementPrometheusIntegrations: migrated (0.0260s) 852main: == [advisory_lock_connection] object_id: 330356300, pg_backend_pid: 3075853 does not overwrite synced attributes854INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree855INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"856INFO: "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 rows857INFO: analyzing "public.p_ci_job_annotations" inheritance tree858INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"859INFO: "ci_job_annotations_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_builds_metadata" inheritance tree861INFO: analyzing "public.ci_builds_metadata"862INFO: "ci_builds_metadata": 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" inheritance tree864INFO: analyzing "public.ci_builds"865INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows866I, [2023-10-20T08:56:55.762059 #328] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes867RenamePlansTitlesWithLegacyPlanNames868 # order random869 #up870main: == [advisory_lock_connection] object_id: 333457000, pg_backend_pid: 3085871main: == 20230815160428 RenamePlansTitlesWithLegacyPlanNames: migrating =============872main: -- execute("UPDATE plans SET title = 'Premium' WHERE name = 'premium'")873main: -> 0.0014s874main: -- execute("UPDATE plans SET title = 'Ultimate' WHERE name = 'ultimate'")875main: -> 0.0012s876main: == 20230815160428 RenamePlansTitlesWithLegacyPlanNames: migrated (0.0099s) ====877main: == [advisory_lock_connection] object_id: 333457000, pg_backend_pid: 3085878 updates the plan titles879INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree880INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"881INFO: "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 rows882INFO: analyzing "public.p_ci_job_annotations" inheritance tree883INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"884INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows885INFO: analyzing "public.p_ci_builds_metadata" inheritance tree886INFO: analyzing "public.ci_builds_metadata"887INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows888INFO: analyzing "public.p_ci_builds" inheritance tree889INFO: analyzing "public.ci_builds"890INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows891I, [2023-10-20T08:57:15.638751 #328] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes892AddWorkItemsRelatedLinkRestrictions893 # order random894main: == [advisory_lock_connection] object_id: 336374360, pg_backend_pid: 3094895main: == 20231005131445 AddWorkItemsRelatedLinkRestrictions: migrating ==============896main: == 20231005131445 AddWorkItemsRelatedLinkRestrictions: migrated (0.0339s) =====897main: == [advisory_lock_connection] object_id: 336374360, pg_backend_pid: 3094898 creates default restrictions899 when work item types are missing900main: == [advisory_lock_connection] object_id: 336678540, pg_backend_pid: 3097901main: == 20231005131445 AddWorkItemsRelatedLinkRestrictions: migrating ==============902main: == 20231005131445 AddWorkItemsRelatedLinkRestrictions: migrated (0.0211s) =====903main: == [advisory_lock_connection] object_id: 336678540, pg_backend_pid: 3097904 does not add restrictions905auto_explain log contains 1096 entries for main, writing to /builds/gitlab-org/gitlab/auto_explain/rspec-migration-pg14-7-12.328.main.ndjson.gz906took 13.875016976907auto_explain log contains 1096 entries for ci, writing to /builds/gitlab-org/gitlab/auto_explain/rspec-migration-pg14-7-12.328.ci.ndjson.gz908took 13.445244108909Knapsack report was generated. Preview:910{911 "spec/migrations/20230202131928_encrypt_ci_trigger_token_spec.rb": 115.681312746,912 "spec/migrations/20230220102212_swap_columns_ci_build_needs_big_int_conversion_spec.rb": 59.752867543999855,913 "spec/migrations/20221215151822_schedule_backfill_releases_author_id_spec.rb": 52.80344658100057,914 "spec/migrations/20221104115712_backfill_project_statistics_storage_size_without_uploads_size_spec.rb": 57.02387121099946,915 "spec/migrations/20230130073109_nullify_creator_id_of_orphaned_projects_spec.rb": 51.83265984699938,916 "spec/migrations/20221223123019_delete_queued_jobs_for_vulnerabilities_feedback_migration_spec.rb": 53.291027407,917 "spec/migrations/schedule_migrate_shared_vulnerability_identifiers_spec.rb": 51.06956840299972,918 "spec/migrations/20230313150531_reschedule_migration_for_remediation_spec.rb": 41.122927964000155,919 "spec/migrations/swap_issue_user_mentions_note_id_to_bigint_for_gitlab_dot_com_2_spec.rb": 40.210244936999516,920 "spec/migrations/20230330103104_reschedule_migrate_evidences_spec.rb": 40.60020616800011,921 "spec/migrations/ensure_design_user_mentions_note_id_bigint_backfill_is_finished_for_gitlab_dot_com_spec.rb": 42.08711984900037,922 "spec/migrations/ensure_merge_request_metrics_id_bigint_backfill_is_finished_for_self_hosts_spec.rb": 38.355414634000226,923 "spec/migrations/20230329100222_drop_software_licenses_temp_index_spec.rb": 41.61623117599993,924 "spec/migrations/ensure_notes_bigint_backfill_is_finished_for_gitlab_dot_com_spec.rb": 40.02105633000065,925 "spec/migrations/20230726144458_swap_notes_id_to_bigint_for_self_managed_spec.rb": 22.234992829000475,926 "spec/migrations/add_expiry_notified_at_to_member_spec.rb": 19.258602224000242,927 "spec/migrations/20230724164745_queue_delete_orphaned_transferred_project_approval_rules_spec.rb": 17.30284419600048,928 "spec/migrations/20230810103534_swap_suggestions_note_id_to_bigint_for_self_hosts_spec.rb": 14.115253491999283,929 "spec/migrations/backfill_alert_management_prometheus_integrations_spec.rb": 11.3639005670002,930 "spec/migrations/20230815160428_rename_plans_titles_with_legacy_plan_names_spec.rb": 7.9255391959995904,931 "spec/migrations/add_work_items_related_link_restrictions_spec.rb": 4.734131762999823932}933Knapsack global time execution for tests: 13m 42s934Finished in 29 minutes 44 seconds (files took 38.45 seconds to load)93549 examples, 0 failures936Randomized with seed 11648937[TEST PROF INFO] Time spent in factories: 00:00.280 (0.02% of total time)938RSpec exited with 0.939No examples to retry, congrats!941Running after script...942$ echo -e "\e[0Ksection_start:`date +%s`:report_results_section[collapsed=true]\r\e[0KReport results"946$ tooling/bin/push_job_metrics || true947[job-metrics] Pushing job metrics file for the CI/CD job.948[job-metrics] Pushed 4 CI job metric entries to InfluxDB.950Not uploading cache ruby-gems-debian-bullseye-ruby-3.0-16 due to policy952Uploading artifacts...953auto_explain/: found 3 matching artifact files and directories 954coverage/: found 5 matching artifact files and directories 955crystalball/: found 2 matching artifact files and directories 956WARNING: deprecations/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab) 957knapsack/: found 4 matching artifact files and directories 958rspec/: found 16 matching artifact files and directories 959WARNING: tmp/capybara/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab) 960log/*.log: found 13 matching artifact files and directories 961WARNING: Upload request redirected location=https://gitlab.com/api/v4/jobs/5336650667/artifacts?artifact_format=zip&artifact_type=archive&expire_in=31d new-url=https://gitlab.com962WARNING: Retrying... context=artifacts-uploader error=request redirected963Uploading artifacts as "archive" to coordinator... 201 Created id=5336650667 responseStatus=201 Created token=64_iopUr964Uploading artifacts...965rspec/rspec-*.xml: found 1 matching artifact files and directories 966WARNING: Upload request redirected location=https://gitlab.com/api/v4/jobs/5336650667/artifacts?artifact_format=gzip&artifact_type=junit&expire_in=31d new-url=https://gitlab.com967WARNING: Retrying... context=artifacts-uploader error=request redirected968Uploading artifacts as "junit" to coordinator... 201 Created id=5336650667 responseStatus=201 Created token=64_iopUr970Job succeeded