rspec migration pg14-as-if-foss single-db 1/8
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-1697780850-0a5ab13c...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.32 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 as-if-foss (5336650415)...47Downloading artifacts from coordinator... ok host=storage.googleapis.com id=5336650415 responseStatus=200 OK token=64_4sygM48Downloading artifacts for detect-tests (5336650454)...49Downloading artifacts from coordinator... ok host=storage.googleapis.com id=5336650454 responseStatus=200 OK token=64_4sygM50Downloading artifacts for retrieve-tests-metadata (5336650473)...51Downloading artifacts from coordinator... ok host=storage.googleapis.com id=5336650473 responseStatus=200 OK token=64_4sygM52Downloading artifacts for setup-test-env (5336650424)...53Downloading artifacts from coordinator... ok host=storage.googleapis.com id=5336650424 responseStatus=200 OK token=64_4sygM55Using 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_ONLY57158$ [ "$FOSS_ONLY" = "1" ] && rm -rf ee/ qa/spec/ee/ qa/qa/specs/features/ee/ qa/qa/ee/ qa/qa/ee.rb59$ export GOPATH=$CI_PROJECT_DIR/.go60$ mkdir -p $GOPATH61$ source scripts/utils.sh62$ source scripts/prepare_build.sh94Using two connections, single database config (config/database.yml.postgresql)95Disabling ci connection in config/database.yml96Geo DB won't be set up.97Embedding DB won't be set up.129$ source ./scripts/rspec_helpers.sh130$ run_timed_command "gem install knapsack --no-document"131$ gem install knapsack --no-document132Successfully installed knapsack-4.0.01331 gem installed134==> 'gem install knapsack --no-document' succeeded in 1 seconds.135$ section_start "gitaly-test-spawn" "Spawning Gitaly"; scripts/gitaly-test-spawn; section_end "gitaly-test-spawn"140$ export RSPEC_SKIPPED_TESTS_REPORT_PATH="rspec/skipped_tests-${CI_JOB_ID}.txt"141$ export RSPEC_RETRIED_TESTS_REPORT_PATH="rspec/retried_tests-${CI_JOB_ID}.txt"142$ tooling/bin/create_job_metrics_file || true143[job-metrics] Creating the job metrics file for the CI/CD job.144$ rspec_paralellized_job "--fail-fast=${RSPEC_FAIL_FAST_THRESHOLD} --tag ~quarantine --tag ~zoekt --tag ~click_house"145RETRY_FAILED_TESTS_IN_NEW_PROCESS: true146KNAPSACK_GENERATE_REPORT: 147FLAKY_RSPEC_GENERATE_REPORT: 148KNAPSACK_TEST_FILE_PATTERN: spec/{migrations}{,/**/}*_spec.rb149KNAPSACK_LOG_LEVEL: debug150KNAPSACK_REPORT_PATH: knapsack/rspec_migration_pg14-as-if-foss_single-db_1_8_report.json151FLAKY_RSPEC_SUITE_REPORT_PATH: rspec/flaky/report-suite.json152FLAKY_RSPEC_REPORT_PATH: rspec/flaky/all_rspec_migration_pg14-as-if-foss_single-db_1_8_report.json153NEW_FLAKY_RSPEC_REPORT_PATH: rspec/flaky/new_rspec_migration_pg14-as-if-foss_single-db_1_8_report.json154RSPEC_SKIPPED_TESTS_REPORT_PATH: rspec/skipped_tests-5336651324.txt155CRYSTALBALL: 156RSPEC_TESTS_MAPPING_ENABLED: 157RSPEC_TESTS_FILTER_FILE: 158Shell set options (set -o) enabled:159braceexpand on160hashall on161interactive-comments on162pipefail on163 ██ ██ █████ ██████ ███ ██ ██ ███ ██ ██████ 164 ██ ██ ██ ██ ██ ██ ████ ██ ██ ████ ██ ██ 165 ██ █ ██ ███████ ██████ ██ ██ ██ ██ ██ ██ ██ ██ ███ 166 ██ ███ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ 167 ███ ███ ██ ██ ██ ██ ██ ████ ██ ██ ████ ██████ 168******************************************************************************169 Your database has a single connection, and single connections were170 deprecated in GitLab 15.9 https://docs.gitlab.com/ee/update/deprecations.html#single-database-connection-is-deprecated.171 Please add a :ci section to your database, following these instructions:173******************************************************************************174 ██ ██ █████ ██████ ███ ██ ██ ███ ██ ██████ 175 ██ ██ ██ ██ ██ ██ ████ ██ ██ ████ ██ ██ 176 ██ █ ██ ███████ ██████ ██ ██ ██ ██ ██ ██ ██ ██ ███ 177 ██ ███ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ 178 ███ ███ ██ ██ ██ ██ ██ ████ ██ ██ ████ ██████ 179******************************************************************************180 Your database has a single connection, and single connections were181 deprecated in GitLab 15.9 https://docs.gitlab.com/ee/update/deprecations.html#single-database-connection-is-deprecated.182 Please add a :ci section to your database, following these instructions:184******************************************************************************185INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree186INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"187INFO: "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 rows188INFO: analyzing "public.p_ci_job_annotations" inheritance tree189INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"190INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows191INFO: analyzing "public.p_ci_builds_metadata" inheritance tree192INFO: analyzing "public.ci_builds_metadata"193INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows194Run options: exclude {:quarantine=>true, :zoekt=>true, :click_house=>true}195Test environment set up in 0.374297142 seconds196CreateNextCiPartitionsRecord197 # order random198 #up199 when on sass200main: == [advisory_lock_connection] object_id: 10047440, pg_backend_pid: 121201main: == 20221102090940 CreateNextCiPartitionsRecord: migrating =====================202main: -- execute("INSERT INTO \"ci_partitions\" (\"id\", \"created_at\", \"updated_at\")\n VALUES (101, now(), now())\n ON CONFLICT DO NOTHING;\n")203main: -> 0.0015s204main: -- reset_pk_sequence!("ci_partitions")205main: -> 0.0053s206main: -> 101 rows207main: == 20221102090940 CreateNextCiPartitionsRecord: migrated (0.0072s) ============208main: == [advisory_lock_connection] object_id: 10047440, pg_backend_pid: 121209 creates next partitions record and resets the sequence210 when self-managed211main: == [advisory_lock_connection] object_id: 10894960, pg_backend_pid: 123212main: == 20221102090940 CreateNextCiPartitionsRecord: migrating =====================213main: == 20221102090940 CreateNextCiPartitionsRecord: migrated (0.0003s) ============214main: == [advisory_lock_connection] object_id: 10894960, pg_backend_pid: 123215 does not create records216 #down217 when on sass218main: == [advisory_lock_connection] object_id: 11121700, pg_backend_pid: 126219main: == 20221102090940 CreateNextCiPartitionsRecord: migrating =====================220main: -- execute("INSERT INTO \"ci_partitions\" (\"id\", \"created_at\", \"updated_at\")\n VALUES (101, now(), now())\n ON CONFLICT DO NOTHING;\n")221main: -> 0.0017s222main: -- reset_pk_sequence!("ci_partitions")223main: -> 0.0057s224main: -> 101 rows225main: == 20221102090940 CreateNextCiPartitionsRecord: migrated (0.0079s) ============226main: == [advisory_lock_connection] object_id: 11121700, pg_backend_pid: 126227main: -- execute("DELETE FROM \"ci_partitions\"\n WHERE \"ci_partitions\".\"id\" = 101;\n")228main: -> 0.0015s229 removes the record230 when self-managed231main: == [advisory_lock_connection] object_id: 11235840, pg_backend_pid: 128232main: == 20221102090940 CreateNextCiPartitionsRecord: migrating =====================233main: -- execute("INSERT INTO \"ci_partitions\" (\"id\", \"created_at\", \"updated_at\")\n VALUES (101, now(), now())\n ON CONFLICT DO NOTHING;\n")234main: -> 0.0014s235main: -- reset_pk_sequence!("ci_partitions")236main: -> 0.0053s237main: -> 101 rows238main: == 20221102090940 CreateNextCiPartitionsRecord: migrated (0.0070s) ============239main: == [advisory_lock_connection] object_id: 11235840, pg_backend_pid: 128240 does not remove the record241INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree242INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"243INFO: "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 rows244INFO: analyzing "public.p_ci_job_annotations" inheritance tree245INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"246INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows247INFO: analyzing "public.p_ci_builds_metadata" inheritance tree248INFO: analyzing "public.ci_builds_metadata"249INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows250INFO: analyzing "public.p_ci_builds" inheritance tree251INFO: analyzing "public.ci_builds"252INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows253AddDefaultPreferredLanguageToApplicationSettings254 # order random255 #down256main: == [advisory_lock_connection] object_id: 36796300, pg_backend_pid: 137257main: == 20221101032521 AddDefaultPreferredLanguageToApplicationSettings: migrating =258main: -- add_column(:application_settings, :default_preferred_language, :text, {:default=>"en", :null=>false})259main: -> 0.0048s260main: == 20221101032521 AddDefaultPreferredLanguageToApplicationSettings: migrated (0.0051s) 261main: == [advisory_lock_connection] object_id: 36796300, pg_backend_pid: 137262 deletes default_preferred_language field263 #up264main: == [advisory_lock_connection] object_id: 37832220, pg_backend_pid: 140265main: == 20221101032521 AddDefaultPreferredLanguageToApplicationSettings: migrating =266main: -- add_column(:application_settings, :default_preferred_language, :text, {:default=>"en", :null=>false})267main: -> 0.0055s268main: == 20221101032521 AddDefaultPreferredLanguageToApplicationSettings: migrated (0.0058s) 269main: == [advisory_lock_connection] object_id: 37832220, pg_backend_pid: 140270 allows to read default_preferred_language field271INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree272INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"273INFO: "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 rows274INFO: analyzing "public.p_ci_job_annotations" inheritance tree275INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"276INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows277INFO: analyzing "public.p_ci_builds_metadata" inheritance tree278INFO: analyzing "public.ci_builds_metadata"279INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows280INFO: analyzing "public.p_ci_builds" inheritance tree281INFO: analyzing "public.ci_builds"282INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows283CleanupVulnerabilityStateTransitionsWithSameFromStateToState284 # order random285main: == [advisory_lock_connection] object_id: 63941200, pg_backend_pid: 149286main: == 20221013215832 CleanupVulnerabilityStateTransitionsWithSameFromStateToState: migrating 287main: == 20221013215832 CleanupVulnerabilityStateTransitionsWithSameFromStateToState: migrated (0.0026s) 288main: == [advisory_lock_connection] object_id: 63941200, pg_backend_pid: 149289 deletes state transitions with no state change290INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree291INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"292INFO: "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 rows293INFO: analyzing "public.p_ci_job_annotations" inheritance tree294INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"295INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows296INFO: analyzing "public.p_ci_builds_metadata" inheritance tree297INFO: analyzing "public.ci_builds_metadata"298INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows299INFO: analyzing "public.p_ci_builds" inheritance tree300INFO: analyzing "public.ci_builds"301INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows302BumpDefaultPartitionIdValueForCiTables303 # order random304 when on sass305main: == [advisory_lock_connection] object_id: 90032320, pg_backend_pid: 159306main: == 20221220131020 BumpDefaultPartitionIdValueForCiTables: migrating ===========307main: -- change_column_default(:ci_build_needs, :partition_id, {:from=>100, :to=>101})308main: -> 0.0047s309main: -- change_column_default(:ci_build_pending_states, :partition_id, {:from=>100, :to=>101})310main: -> 0.0044s311main: -- change_column_default(:ci_build_report_results, :partition_id, {:from=>100, :to=>101})312main: -> 0.0045s313main: -- change_column_default(:ci_build_trace_chunks, :partition_id, {:from=>100, :to=>101})314main: -> 0.0046s315main: -- change_column_default(:ci_build_trace_metadata, :partition_id, {:from=>100, :to=>101})316main: -> 0.0045s317main: -- change_column_default(:ci_builds, :partition_id, {:from=>100, :to=>101})318main: -> 0.0062s319main: -- change_column_default(:ci_builds_runner_session, :partition_id, {:from=>100, :to=>101})320main: -> 0.0044s321main: -- change_column_default(:ci_job_artifacts, :partition_id, {:from=>100, :to=>101})322main: -> 0.0048s323main: -- change_column_default(:ci_job_variables, :partition_id, {:from=>100, :to=>101})324main: -> 0.0046s325main: -- change_column_default(:ci_pending_builds, :partition_id, {:from=>100, :to=>101})326main: -> 0.0042s327main: -- change_column_default(:ci_pipeline_variables, :partition_id, {:from=>100, :to=>101})328main: -> 0.0042s329main: -- change_column_default(:ci_pipelines, :partition_id, {:from=>100, :to=>101})330main: -> 0.0077s331main: -- change_column_default(:ci_running_builds, :partition_id, {:from=>100, :to=>101})332main: -> 0.0053s333main: -- change_column_default(:ci_sources_pipelines, :partition_id, {:from=>100, :to=>101})334main: -> 0.0051s335main: -- change_column_default(:ci_sources_pipelines, :source_partition_id, {:from=>100, :to=>101})336main: -> 0.0045s337main: -- change_column_default(:ci_stages, :partition_id, {:from=>100, :to=>101})338main: -> 0.0051s339main: -- change_column_default(:ci_unit_test_failures, :partition_id, {:from=>100, :to=>101})340main: -> 0.0040s341main: -- change_column_default(:p_ci_builds_metadata, :partition_id, {:from=>100, :to=>101})342main: -> 0.0047s343main: == 20221220131020 BumpDefaultPartitionIdValueForCiTables: migrated (0.2551s) ==344main: == [advisory_lock_connection] object_id: 90032320, pg_backend_pid: 159345 changes default values346 with tables already changed347main: == [advisory_lock_connection] object_id: 90866600, pg_backend_pid: 162348main: == 20221220131020 BumpDefaultPartitionIdValueForCiTables: migrating ===========349main: -- change_column_default(:ci_build_needs, :partition_id, {:from=>100, :to=>101})350main: -> 0.0043s351main: -- change_column_default(:ci_build_pending_states, :partition_id, {:from=>100, :to=>101})352main: -> 0.0044s353main: -- change_column_default(:ci_build_report_results, :partition_id, {:from=>100, :to=>101})354main: -> 0.0046s355main: -- change_column_default(:ci_build_trace_chunks, :partition_id, {:from=>100, :to=>101})356main: -> 0.0043s357main: -- change_column_default(:ci_build_trace_metadata, :partition_id, {:from=>100, :to=>101})358main: -> 0.0044s359main: -- change_column_default(:ci_builds_runner_session, :partition_id, {:from=>100, :to=>101})360main: -> 0.0042s361main: -- change_column_default(:ci_job_artifacts, :partition_id, {:from=>100, :to=>101})362main: -> 0.0050s363main: -- change_column_default(:ci_job_variables, :partition_id, {:from=>100, :to=>101})364main: -> 0.0050s365main: -- change_column_default(:ci_pending_builds, :partition_id, {:from=>100, :to=>101})366main: -> 0.0052s367main: -- change_column_default(:ci_pipeline_variables, :partition_id, {:from=>100, :to=>101})368main: -> 0.0048s369main: -- change_column_default(:ci_pipelines, :partition_id, {:from=>100, :to=>101})370main: -> 0.0057s371main: -- change_column_default(:ci_running_builds, :partition_id, {:from=>100, :to=>101})372main: -> 0.0052s373main: -- change_column_default(:ci_sources_pipelines, :partition_id, {:from=>100, :to=>101})374main: -> 0.0056s375main: -- change_column_default(:ci_sources_pipelines, :source_partition_id, {:from=>100, :to=>101})376main: -> 0.0046s377main: -- change_column_default(:ci_stages, :partition_id, {:from=>100, :to=>101})378main: -> 0.0052s379main: -- change_column_default(:ci_unit_test_failures, :partition_id, {:from=>100, :to=>101})380main: -> 0.0050s381main: -- change_column_default(:p_ci_builds_metadata, :partition_id, {:from=>100, :to=>101})382main: -> 0.0059s383main: == 20221220131020 BumpDefaultPartitionIdValueForCiTables: migrated (0.2251s) ==384main: == [advisory_lock_connection] object_id: 90866600, pg_backend_pid: 162385 skips updating already changed tables386 when self-managed387main: == [advisory_lock_connection] object_id: 91574960, pg_backend_pid: 165388main: == 20221220131020 BumpDefaultPartitionIdValueForCiTables: migrating ===========389main: == 20221220131020 BumpDefaultPartitionIdValueForCiTables: migrated (0.0076s) ==390main: == [advisory_lock_connection] object_id: 91574960, pg_backend_pid: 165391 does not change default values392INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree393INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"394INFO: "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 rows395INFO: analyzing "public.p_ci_job_annotations" inheritance tree396INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"397INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows398INFO: analyzing "public.p_ci_builds_metadata" inheritance tree399INFO: analyzing "public.ci_builds_metadata"400INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows401INFO: analyzing "public.p_ci_builds" inheritance tree402INFO: analyzing "public.ci_builds"403INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows404QueueBackfillUserDetailsFields405 # order random406main: == [advisory_lock_connection] object_id: 116446220, pg_backend_pid: 175407main: == 20221019002459 QueueBackfillUserDetailsFields: migrating ===================408main: == 20221019002459 QueueBackfillUserDetailsFields: migrated (0.0546s) ==========409main: == [advisory_lock_connection] object_id: 116446220, pg_backend_pid: 175410 schedules a new batched migration411INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree412INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"413INFO: "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 rows414INFO: analyzing "public.p_ci_job_annotations" inheritance tree415INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"416INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows417INFO: analyzing "public.p_ci_builds_metadata" inheritance tree418INFO: analyzing "public.ci_builds_metadata"419INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows420INFO: analyzing "public.p_ci_builds" inheritance tree421INFO: analyzing "public.ci_builds"422INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows423AddObjectiveAndKeyresultToWorkItemTypes424 # order random425main: == [advisory_lock_connection] object_id: 143709860, pg_backend_pid: 186426main: == 20221018050323 AddObjectiveAndKeyresultToWorkItemTypes: migrating ==========427main: -- execute("INSERT INTO work_item_types (base_type, icon_name, name, created_at, updated_at) VALUES(\n 5, 'issue-type-objective', 'Objective', NOW(), NOW()\n ) ON CONFLICT DO NOTHING;\n")428main: -> 0.0015s429main: -- execute("INSERT INTO work_item_types (base_type, icon_name, name, created_at, updated_at) VALUES(\n 6, 'issue-type-keyresult', 'Key Result', NOW(), NOW()\n ) ON CONFLICT DO NOTHING;\n")430main: -> 0.0015s431main: == 20221018050323 AddObjectiveAndKeyresultToWorkItemTypes: migrated (0.0090s) =432main: == [advisory_lock_connection] object_id: 143709860, pg_backend_pid: 186433 adds both objective & keyresult to base work item types434main: == [advisory_lock_connection] object_id: 144876060, pg_backend_pid: 188435main: == 20221018050323 AddObjectiveAndKeyresultToWorkItemTypes: migrating ==========436main: -- Objective item record exist, skipping creation437main: -- Keyresult item record exist, skipping creation438main: == 20221018050323 AddObjectiveAndKeyresultToWorkItemTypes: migrated (0.0089s) =439main: == [advisory_lock_connection] object_id: 144876060, pg_backend_pid: 188440 skips creating both objective & keyresult type record if it already exists441The application_settings (main) table has 1252 columns.442Recreating the database443Dropped database 'gitlabhq_test'444Created database 'gitlabhq_test'445main: == [advisory_lock_connection] object_id: 144900300, pg_backend_pid: 194446main: == [advisory_lock_connection] object_id: 144900300, pg_backend_pid: 194447Databases re-creation done in 5.804377173999455448ScheduleMigrationForLinks449 # order random450 #down451main: == [advisory_lock_connection] object_id: 152817060, pg_backend_pid: 200452main: == 20230208125736 ScheduleMigrationForLinks: migrating ========================453main: == 20230208125736 ScheduleMigrationForLinks: migrated (0.0095s) ===============454main: == [advisory_lock_connection] object_id: 152817060, pg_backend_pid: 200455 deletes all batched migration records456 #up457main: == [advisory_lock_connection] object_id: 153469120, pg_backend_pid: 203458main: == 20230208125736 ScheduleMigrationForLinks: migrating ========================459main: == 20230208125736 ScheduleMigrationForLinks: migrated (0.0069s) ===============460main: == [advisory_lock_connection] object_id: 153469120, pg_backend_pid: 203461 schedules a batched background migration462INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree463INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"464INFO: "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 rows465INFO: analyzing "public.p_ci_job_annotations" inheritance tree466INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"467INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows468INFO: analyzing "public.p_ci_builds_metadata" inheritance tree469INFO: analyzing "public.ci_builds_metadata"470INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows471INFO: analyzing "public.p_ci_builds" inheritance tree472INFO: analyzing "public.ci_builds"473INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows474NullifyLastErrorFromProjectMirrorData475 # order random476 #up477main: == [advisory_lock_connection] object_id: 173634240, pg_backend_pid: 211478main: == 20230208131808 NullifyLastErrorFromProjectMirrorData: migrating ============479main: == 20230208131808 NullifyLastErrorFromProjectMirrorData: migrated (0.0647s) ===480main: == [advisory_lock_connection] object_id: 173634240, pg_backend_pid: 211481 schedules background jobs for each batch of projects482 #down483main: == [advisory_lock_connection] object_id: 174204160, pg_backend_pid: 213484main: == 20230208131808 NullifyLastErrorFromProjectMirrorData: migrating ============485main: == 20230208131808 NullifyLastErrorFromProjectMirrorData: migrated (0.0476s) ===486main: == [advisory_lock_connection] object_id: 174204160, pg_backend_pid: 213487 deletes all batched migration records488INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree489INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"490INFO: "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 rows491INFO: analyzing "public.p_ci_job_annotations" inheritance tree492INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"493INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows494INFO: analyzing "public.p_ci_builds_metadata" inheritance tree495INFO: analyzing "public.ci_builds_metadata"496INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows497INFO: analyzing "public.p_ci_builds" inheritance tree498INFO: analyzing "public.ci_builds"499INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows500AddNotificationsWorkItemWidget501 # order random502 behaves like migration that adds widget to work items definitions503 #up504main: == [advisory_lock_connection] object_id: 193954500, pg_backend_pid: 223505main: == 20230228142350 AddNotificationsWorkItemWidget: migrating ===================506main: == 20230228142350 AddNotificationsWorkItemWidget: migrated (0.0359s) ==========507main: == [advisory_lock_connection] object_id: 193954500, pg_backend_pid: 223508 creates widget definition in all types509main: == [advisory_lock_connection] object_id: 194572580, pg_backend_pid: 225510main: == 20230228142350 AddNotificationsWorkItemWidget: migrating ===================511main: == 20230228142350 AddNotificationsWorkItemWidget: migrated (0.0500s) ==========512main: == [advisory_lock_connection] object_id: 194572580, pg_backend_pid: 225513 logs a warning if the type is missing514 #down515main: == [advisory_lock_connection] object_id: 194750100, pg_backend_pid: 227516main: == 20230228142350 AddNotificationsWorkItemWidget: migrating ===================517main: == 20230228142350 AddNotificationsWorkItemWidget: migrated (0.0505s) ==========518main: == [advisory_lock_connection] object_id: 194750100, pg_backend_pid: 227519 removes definitions for widget520INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree521INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"522INFO: "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 rows523INFO: analyzing "public.p_ci_job_annotations" inheritance tree524INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"525INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows526INFO: analyzing "public.p_ci_builds_metadata" inheritance tree527INFO: analyzing "public.ci_builds_metadata"528INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows529INFO: analyzing "public.p_ci_builds" inheritance tree530INFO: analyzing "public.ci_builds"531INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows532ScheduleMigrateSharedVulnerabilityIdentifiers533 # order random534 #down535 deletes536 #up537main: == [advisory_lock_connection] object_id: 214564260, pg_backend_pid: 237538main: == 20230221093536 ScheduleMigrateSharedVulnerabilityIdentifiers: migrating ====539main: == 20230221093536 ScheduleMigrateSharedVulnerabilityIdentifiers: migrated (0.0539s) 540main: == [advisory_lock_connection] object_id: 214564260, pg_backend_pid: 237541 schedules542INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree543INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"544INFO: "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 rows545INFO: analyzing "public.p_ci_job_annotations" inheritance tree546INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"547INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows548INFO: analyzing "public.p_ci_builds_metadata" inheritance tree549INFO: analyzing "public.ci_builds_metadata"550INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows551INFO: analyzing "public.p_ci_builds" inheritance tree552INFO: analyzing "public.ci_builds"553INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows554RemoveIncorrectlyOnboardedNamespacesFromOnboardingProgress555 # order random556 #up557main: == [advisory_lock_connection] object_id: 233799460, pg_backend_pid: 246558main: == 20230221214519 RemoveIncorrectlyOnboardedNamespacesFromOnboardingProgress: migrating 559main: == 20230221214519 RemoveIncorrectlyOnboardedNamespacesFromOnboardingProgress: migrated (0.0307s) 560main: == [advisory_lock_connection] object_id: 233799460, pg_backend_pid: 246561 deletes the onboarding for namespaces without learn gitlab562INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree563INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"564INFO: "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 rows565INFO: analyzing "public.p_ci_job_annotations" inheritance tree566INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"567INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows568INFO: analyzing "public.p_ci_builds_metadata" inheritance tree569INFO: analyzing "public.ci_builds_metadata"570INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows571INFO: analyzing "public.p_ci_builds" inheritance tree572INFO: analyzing "public.ci_builds"573INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows574EnsureNoteDiffFilesBigintBackfillIsFinishedForGitlabDotCom575 # order random576 #up577main: == [advisory_lock_connection] object_id: 252612580, pg_backend_pid: 255578main: == 20230322023442 EnsureNoteDiffFilesBigintBackfillIsFinishedForGitlabDotCom: migrating 579main: == 20230322023442 EnsureNoteDiffFilesBigintBackfillIsFinishedForGitlabDotCom: migrated (0.0073s) 580main: == [advisory_lock_connection] object_id: 252612580, pg_backend_pid: 255581 ensures the migration is completed for GitLab.com, dev, or test582main: == [advisory_lock_connection] object_id: 253158360, pg_backend_pid: 257583main: == 20230322023442 EnsureNoteDiffFilesBigintBackfillIsFinishedForGitlabDotCom: migrating 584main: == 20230322023442 EnsureNoteDiffFilesBigintBackfillIsFinishedForGitlabDotCom: migrated (0.0072s) 585main: == [advisory_lock_connection] object_id: 253158360, pg_backend_pid: 257586 skips the check for other instances587INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree588INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"589INFO: "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 rows590INFO: analyzing "public.p_ci_job_annotations" inheritance tree591INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"592INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows593INFO: analyzing "public.p_ci_builds_metadata" inheritance tree594INFO: analyzing "public.ci_builds_metadata"595INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows596INFO: analyzing "public.p_ci_builds" inheritance tree597INFO: analyzing "public.ci_builds"598INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows599QueueMigrateHumanUserType600 # order random601main: == [advisory_lock_connection] object_id: 270131080, pg_backend_pid: 265602main: == 20230327103401 QueueMigrateHumanUserType: migrating ========================603main: == 20230327103401 QueueMigrateHumanUserType: migrated (0.0515s) ===============604main: == [advisory_lock_connection] object_id: 270131080, pg_backend_pid: 265605 schedules a new batched migration606The application_settings (main) table has 1239 columns.607Recreating the database608Dropped database 'gitlabhq_test'609Created database 'gitlabhq_test'610main: == [advisory_lock_connection] object_id: 270777840, pg_backend_pid: 272611main: == [advisory_lock_connection] object_id: 270777840, pg_backend_pid: 272612Databases re-creation done in 5.578222086000096613EnsureSystemNoteMetadataBigintBackfillIsFinishedForGitlabDotCom614 # order random615 #up616main: == [advisory_lock_connection] object_id: 276695600, pg_backend_pid: 278617main: == 20230412013251 EnsureSystemNoteMetadataBigintBackfillIsFinishedForGitlabDotCom: migrating 618main: == 20230412013251 EnsureSystemNoteMetadataBigintBackfillIsFinishedForGitlabDotCom: migrated (0.0077s) 619main: == [advisory_lock_connection] object_id: 276695600, pg_backend_pid: 278620 ensures the migration is completed for GitLab.com, dev, or test621main: == [advisory_lock_connection] object_id: 277330680, pg_backend_pid: 280622main: == 20230412013251 EnsureSystemNoteMetadataBigintBackfillIsFinishedForGitlabDotCom: migrating 623main: == 20230412013251 EnsureSystemNoteMetadataBigintBackfillIsFinishedForGitlabDotCom: migrated (0.0077s) 624main: == [advisory_lock_connection] object_id: 277330680, pg_backend_pid: 280625 skips the check for other instances626INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree627INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"628INFO: "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 rows629INFO: analyzing "public.p_ci_job_annotations" inheritance tree630INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"631INFO: "ci_job_annotations_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_builds_metadata" inheritance tree633INFO: analyzing "public.ci_builds_metadata"634INFO: "ci_builds_metadata": 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" inheritance tree636INFO: analyzing "public.ci_builds"637INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows638EnsureEpicUserMentionsBigintBackfillIsFinishedForGitlabDotCom639 # order random640 #up641main: == [advisory_lock_connection] object_id: 293331400, pg_backend_pid: 287642main: == 20230404030757 EnsureEpicUserMentionsBigintBackfillIsFinishedForGitlabDotCom: migrating 643main: == 20230404030757 EnsureEpicUserMentionsBigintBackfillIsFinishedForGitlabDotCom: migrated (0.0085s) 644main: == [advisory_lock_connection] object_id: 293331400, pg_backend_pid: 287645 ensures the migration is completed for GitLab.com, dev, or test646main: == [advisory_lock_connection] object_id: 293962320, pg_backend_pid: 290647main: == 20230404030757 EnsureEpicUserMentionsBigintBackfillIsFinishedForGitlabDotCom: migrating 648main: == 20230404030757 EnsureEpicUserMentionsBigintBackfillIsFinishedForGitlabDotCom: migrated (0.0076s) 649main: == [advisory_lock_connection] object_id: 293962320, pg_backend_pid: 290650 skips the check for other instances651INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree652INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"653INFO: "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 rows654INFO: analyzing "public.p_ci_job_annotations" inheritance tree655INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"656INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows657INFO: analyzing "public.p_ci_builds_metadata" inheritance tree658INFO: analyzing "public.ci_builds_metadata"659INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows660INFO: analyzing "public.p_ci_builds" inheritance tree661INFO: analyzing "public.ci_builds"662INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows663EnsureVumBigintBackfillIsFinishedForGlDotCom664 # order random665 #up666main: == [advisory_lock_connection] object_id: 310934860, pg_backend_pid: 298667main: == 20230321011529 EnsureVumBigintBackfillIsFinishedForGlDotCom: migrating =====668main: == 20230321011529 EnsureVumBigintBackfillIsFinishedForGlDotCom: migrated (0.0085s) 669main: == [advisory_lock_connection] object_id: 310934860, pg_backend_pid: 298670 ensures the migration is completed for GitLab.com, dev, or test671main: == [advisory_lock_connection] object_id: 311436000, pg_backend_pid: 300672main: == 20230321011529 EnsureVumBigintBackfillIsFinishedForGlDotCom: migrating =====673main: == 20230321011529 EnsureVumBigintBackfillIsFinishedForGlDotCom: migrated (0.0061s) 674main: == [advisory_lock_connection] object_id: 311436000, pg_backend_pid: 300675 skips the check for other instances676INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree677INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"678INFO: "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 rows679INFO: analyzing "public.p_ci_job_annotations" inheritance tree680INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"681INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows682INFO: analyzing "public.p_ci_builds_metadata" inheritance tree683INFO: analyzing "public.ci_builds_metadata"684INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows685INFO: analyzing "public.p_ci_builds" inheritance tree686INFO: analyzing "public.ci_builds"687INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows688DeleteSecurityPolicyBotUsers689 # order random690 #up691main: == [advisory_lock_connection] object_id: 329226520, pg_backend_pid: 308692main: == 20230309071242 DeleteSecurityPolicyBotUsers: migrating =====================693main: == 20230309071242 DeleteSecurityPolicyBotUsers: migrated (0.0354s) ============694main: == [advisory_lock_connection] object_id: 329226520, pg_backend_pid: 308695 deletes security_policy_bot users696INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree697INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"698INFO: "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 rows699INFO: analyzing "public.p_ci_job_annotations" inheritance tree700INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"701INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows702INFO: analyzing "public.p_ci_builds_metadata" inheritance tree703INFO: analyzing "public.ci_builds_metadata"704INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows705INFO: analyzing "public.p_ci_builds" inheritance tree706INFO: analyzing "public.ci_builds"707INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows708BackfillMlCandidatesProjectId709 # order random710 #up711main: -- execute(" UPDATE ml_candidates\n SET project_id = temp.project_id\n FROM (\n SELECT ml_candidates.id AS id, ml_experiments.project_id AS project_id\n FROM ml_candidates INNER JOIN ml_experiments ON ml_candidates.experiment_id = ml_experiments.id\n ) AS temp\n WHERE ml_candidates.id = temp.id\n")712main: -> 0.0023s713main: -- execute(" UPDATE ml_candidates\n SET project_id = temp.project_id\n FROM (\n SELECT ml_candidates.id AS id, ml_experiments.project_id AS project_id\n FROM ml_candidates INNER JOIN ml_experiments ON ml_candidates.experiment_id = ml_experiments.id\n ) AS temp\n WHERE ml_candidates.id = temp.id\n")714main: -> 0.0018s715 sets the correct project_id with idempotency716INFO: 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 rows728RemovePackagesEventsPackageIdFk729 # order random730main: -- foreign_keys(:packages_events)731main: -> 0.0052s732main: == [advisory_lock_connection] object_id: 365488040, pg_backend_pid: 323733main: == 20230316164917 RemovePackagesEventsPackageIdFk: migrating ==================734main: -- execute("LOCK TABLE packages_packages, packages_events IN ACCESS EXCLUSIVE MODE")735main: -> 0.0011s736main: -- remove_foreign_key(:packages_events, :packages_packages, {:name=>"fk_rails_c6c20d0094"})737main: -> 0.0055s738main: == 20230316164917 RemovePackagesEventsPackageIdFk: migrated (0.0313s) =========739main: == [advisory_lock_connection] object_id: 365488040, pg_backend_pid: 323740main: -- foreign_keys(:packages_events)741main: -> 0.0045s742main: -- foreign_keys(:packages_events)743main: -> 0.0053s744 drops and creates the foreign key745INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree746INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"747INFO: "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 rows748INFO: analyzing "public.p_ci_job_annotations" inheritance tree749INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"750INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows751INFO: analyzing "public.p_ci_builds_metadata" inheritance tree752INFO: analyzing "public.ci_builds_metadata"753INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows754INFO: analyzing "public.p_ci_builds" inheritance tree755INFO: analyzing "public.ci_builds"756INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows757ScheduleIndexToMembersOnSourceAndTypeAndAccessLevel758 # order random759main: == [advisory_lock_connection] object_id: 382243480, pg_backend_pid: 333760main: == 20230502102832 ScheduleIndexToMembersOnSourceAndTypeAndAccessLevel: migrating 761main: -- index_exists?(:members, [:source_id, :source_type, :type, :access_level], {:name=>"index_members_on_source_and_type_and_access_level", :algorithm=>:concurrently})762main: -> 0.0196s763main: -- add_index_options(:members, [:source_id, :source_type, :type, :access_level], {:name=>"index_members_on_source_and_type_and_access_level", :algorithm=>:concurrently})764main: -> 0.0001s765main: == 20230502102832 ScheduleIndexToMembersOnSourceAndTypeAndAccessLevel: migrated (0.0419s) 766main: == [advisory_lock_connection] object_id: 382243480, pg_backend_pid: 333767 schedules the index768INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree769INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"770INFO: "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 rows771INFO: analyzing "public.p_ci_job_annotations" inheritance tree772INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"773INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows774INFO: analyzing "public.p_ci_builds_metadata" inheritance tree775INFO: analyzing "public.ci_builds_metadata"776INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows777INFO: analyzing "public.p_ci_builds" inheritance tree778INFO: analyzing "public.ci_builds"779INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows780RemoveOldAsyncIndexTableNameLengthConstraint781 # order random782 .down783main: -- transaction_open?(nil)784main: -> 0.0001s785main: -- execute("ALTER TABLE postgres_async_indexes VALIDATE CONSTRAINT check_e64ff4359e;")786main: -> 0.0011s787 disallows inserting longer table names788main: -- transaction_open?(nil)789main: -> 0.0001s790main: -- transaction_open?(nil)791main: -> 0.0001s792main: -- execute(" ALTER TABLE postgres_async_indexes\n DROP CONSTRAINT IF EXISTS check_e64ff4359e\n")793main: -> 0.0013s794main: -- transaction_open?(nil)795main: -> 0.0001s796main: -- transaction_open?(nil)797main: -> 0.0001s798main: -- execute("ALTER TABLE postgres_async_indexes\nADD CONSTRAINT check_e64ff4359e\nCHECK ( char_length(table_name) <= 63 )\nNOT VALID;\n")799main: -> 0.0013s800main: -- execute("ALTER TABLE postgres_async_indexes VALIDATE CONSTRAINT check_e64ff4359e;")801main: -> 0.0012s802 cleans up records with too long table_name803 .up804main: -- transaction_open?(nil)805main: -> 0.0002s806main: -- transaction_open?(nil)807main: -> 0.0001s808main: -- execute(" ALTER TABLE postgres_async_indexes\n DROP CONSTRAINT IF EXISTS check_e64ff4359e\n")809main: -> 0.0015s810 allows inserting longer table names811The application_settings (main) table has 1267 columns.812Recreating the database813Dropped database 'gitlabhq_test'814Created database 'gitlabhq_test'815main: == [advisory_lock_connection] object_id: 397294840, pg_backend_pid: 349816main: == [advisory_lock_connection] object_id: 397294840, pg_backend_pid: 349817Databases re-creation done in 5.683322021001004818EnsureDefaultOrganization819 # order random820main: == [advisory_lock_connection] object_id: 400684020, pg_backend_pid: 354821main: == 20230605095810 EnsureDefaultOrganization: migrating ========================822main: == 20230605095810 EnsureDefaultOrganization: migrated (0.0236s) ===============823main: == [advisory_lock_connection] object_id: 400684020, pg_backend_pid: 354824 creates default organization if needed825 when the path is in use by another organization826main: == [advisory_lock_connection] object_id: 401430900, pg_backend_pid: 357827main: == 20230605095810 EnsureDefaultOrganization: migrating ========================828main: == 20230605095810 EnsureDefaultOrganization: migrated (0.0189s) ===============829main: == [advisory_lock_connection] object_id: 401430900, pg_backend_pid: 357830 adds a random hash to the path831 when default organization already exists832main: == [advisory_lock_connection] object_id: 401612980, pg_backend_pid: 360833main: == 20230605095810 EnsureDefaultOrganization: migrating ========================834main: == 20230605095810 EnsureDefaultOrganization: migrated (0.0105s) ===============835main: == [advisory_lock_connection] object_id: 401612980, pg_backend_pid: 360836 does not creates default organization if needed837INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree838INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"839INFO: "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 rows840INFO: analyzing "public.p_ci_job_annotations" inheritance tree841INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"842INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows843INFO: analyzing "public.p_ci_builds_metadata" inheritance tree844INFO: analyzing "public.ci_builds_metadata"845INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows846INFO: analyzing "public.p_ci_builds" inheritance tree847INFO: analyzing "public.ci_builds"848INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows849SwapNotesIdToBigintForSelfManaged850 # order random851 #up852 when GitLab.com, dev, or test853 behaves like column `id_convert_to_bigint` is already dropped854 does not swaps the columns855 when self-managed instance with the `id_convert_to_bigint` column already dropped856 behaves like column `id_convert_to_bigint` is already dropped857 does not swaps the columns858 when self-managed instance columns already swapped859 does not swaps the columns860 when self-managed instance861 swaps the columns862 when having different naming for fk_d83a918cb1 foreign key863 swaps the columns864INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree865INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"866INFO: "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 rows867INFO: analyzing "public.p_ci_job_annotations" inheritance tree868INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"869INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows870INFO: analyzing "public.p_ci_builds_metadata" inheritance tree871INFO: analyzing "public.ci_builds_metadata"872INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows873INFO: analyzing "public.p_ci_builds" inheritance tree874INFO: analyzing "public.ci_builds"875INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows876BackfillDefaultBranchProtectionApplicationSetting877 # order random878main: == [advisory_lock_connection] object_id: 417112900, pg_backend_pid: 385879main: == 20230723203612 BackfillDefaultBranchProtectionApplicationSetting: migrating 880main: == 20230723203612 BackfillDefaultBranchProtectionApplicationSetting: migrated (0.4623s) 881main: == [advisory_lock_connection] object_id: 417112900, pg_backend_pid: 385882 schedules a new batched migration883INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree884INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"885INFO: "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 rows886INFO: analyzing "public.p_ci_job_annotations" inheritance tree887INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"888INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows889INFO: analyzing "public.p_ci_builds_metadata" inheritance tree890INFO: analyzing "public.ci_builds_metadata"891INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows892INFO: analyzing "public.p_ci_builds" inheritance tree893INFO: analyzing "public.ci_builds"894INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows895AddIndexForMemberExpiringQuery896 # order random897main: -- indexes(:members)898main: -> 0.0225s899main: -- current_schema(nil)900main: -> 0.0007s901main: == [advisory_lock_connection] object_id: 422666280, pg_backend_pid: 393902main: == 20230714015909 AddIndexForMemberExpiringQuery: migrating ===================903main: -- view_exists?(:postgres_partitions)904main: -> 0.0015s905main: -- index_exists?(:members, [:expires_at, :access_level, :id], {:where=>"requested_at IS NULL AND expiry_notified_at IS NULL", :name=>"index_members_on_expiring_at_access_level_id", :algorithm=>:concurrently})906main: -> 0.0201s907main: -- add_index(:members, [:expires_at, :access_level, :id], {:where=>"requested_at IS NULL AND expiry_notified_at IS NULL", :name=>"index_members_on_expiring_at_access_level_id", :algorithm=>:concurrently})908main: -> 0.0020s909main: == 20230714015909 AddIndexForMemberExpiringQuery: migrated (0.0487s) ==========910main: == [advisory_lock_connection] object_id: 422666280, pg_backend_pid: 393911main: -- indexes(:members)912main: -> 0.0246s913 correctly migrates up and down914INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree915INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"916INFO: "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 rows917INFO: analyzing "public.p_ci_job_annotations" inheritance tree918INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"919INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows920INFO: analyzing "public.p_ci_builds_metadata" inheritance tree921INFO: analyzing "public.ci_builds_metadata"922INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows923INFO: analyzing "public.p_ci_builds" inheritance tree924INFO: analyzing "public.ci_builds"925INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows926AddCurrentUserTodosWidgetToEpicWorkItemType927 # order random928 behaves like migration that adds a widget to a work item type929 #up930main: == [advisory_lock_connection] object_id: 428653360, pg_backend_pid: 399931main: == 20230802212443 AddCurrentUserTodosWidgetToEpicWorkItemType: migrating ======932main: == 20230802212443 AddCurrentUserTodosWidgetToEpicWorkItemType: migrated (0.0149s) 933main: == [advisory_lock_connection] object_id: 428653360, pg_backend_pid: 399934 adds widget to work item type935 when type does not exist936main: == [advisory_lock_connection] object_id: 428963240, pg_backend_pid: 401937main: == 20230802212443 AddCurrentUserTodosWidgetToEpicWorkItemType: migrating ======938main: -- Epic work item type does not exist, skipping widget creation939main: == 20230802212443 AddCurrentUserTodosWidgetToEpicWorkItemType: migrated (0.0092s) 940main: == [advisory_lock_connection] object_id: 428963240, pg_backend_pid: 401941 skips creating the new widget definition942 #down943main: == [advisory_lock_connection] object_id: 429154080, pg_backend_pid: 403944main: == 20230802212443 AddCurrentUserTodosWidgetToEpicWorkItemType: migrating ======945main: == 20230802212443 AddCurrentUserTodosWidgetToEpicWorkItemType: migrated (0.0167s) 946main: == [advisory_lock_connection] object_id: 429154080, pg_backend_pid: 403947 removes widget from work item type948INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree949INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"950INFO: "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 rows951INFO: analyzing "public.p_ci_job_annotations" inheritance tree952INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"953INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows954INFO: analyzing "public.p_ci_builds_metadata" inheritance tree955INFO: analyzing "public.ci_builds_metadata"956INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows957INFO: analyzing "public.p_ci_builds" inheritance tree958INFO: analyzing "public.ci_builds"959INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows960SwapSuggestionsNoteIdToBigintForSelfHosts961 # order random962 #up963 when GitLab.com, dev, or test964 does not swap the columns965 when self-managed instance with the columns already swapped966main: == [advisory_lock_connection] object_id: 433095400, pg_backend_pid: 413967main: == 20230810103534 SwapSuggestionsNoteIdToBigintForSelfHosts: migrating ========968main: -- column_exists?("suggestions", "note_id_convert_to_bigint")969main: -> 0.0045s970main: -- columns("suggestions")971main: -> 0.0032s972main: == 20230810103534 SwapSuggestionsNoteIdToBigintForSelfHosts: migrated (0.0164s) 973main: == [advisory_lock_connection] object_id: 433095400, pg_backend_pid: 413974 does not swap the columns975 when self-managed instance with the `note_id_convert_to_bigint` column already dropped976 does not swap the columns977 when self-managed instance978 swaps the columns979INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree980INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"981INFO: "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 rows982INFO: analyzing "public.p_ci_job_annotations" inheritance tree983INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"984INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows985INFO: analyzing "public.p_ci_builds_metadata" inheritance tree986INFO: analyzing "public.ci_builds_metadata"987INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows988INFO: analyzing "public.p_ci_builds" inheritance tree989INFO: analyzing "public.ci_builds"990INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows991QueueFixAllowDescendantsOverrideDisabledSharedRunners992 # order random993main: == [advisory_lock_connection] object_id: 437187820, pg_backend_pid: 425994main: == 20230802085923 QueueFixAllowDescendantsOverrideDisabledSharedRunners: migrating 995main: == 20230802085923 QueueFixAllowDescendantsOverrideDisabledSharedRunners: migrated (0.0482s) 996main: == [advisory_lock_connection] object_id: 437187820, pg_backend_pid: 425997 schedules a new batched migration998INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree999INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"1000INFO: "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 rows1001INFO: analyzing "public.p_ci_job_annotations" inheritance tree1002INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"1003INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1004INFO: analyzing "public.p_ci_builds_metadata" inheritance tree1005INFO: analyzing "public.ci_builds_metadata"1006INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1007INFO: analyzing "public.p_ci_builds" inheritance tree1008INFO: analyzing "public.ci_builds"1009INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1010EnsureCommitUserMentionsNoteIdBigintBackfillIsFinishedForSelfManaged1011 # order random1012 #up1013main: == [advisory_lock_connection] object_id: 440597460, pg_backend_pid: 4311014main: == 20230811145848 EnsureCommitUserMentionsNoteIdBigintBackfillIsFinishedForSelfManaged: migrating 1015main: == 20230811145848 EnsureCommitUserMentionsNoteIdBigintBackfillIsFinishedForSelfManaged: migrated (0.0072s) 1016main: == [advisory_lock_connection] object_id: 440597460, pg_backend_pid: 4311017 ensures the migration is completed for self-managed instances1018main: == [advisory_lock_connection] object_id: 441133280, pg_backend_pid: 4331019main: == 20230811145848 EnsureCommitUserMentionsNoteIdBigintBackfillIsFinishedForSelfManaged: migrating 1020main: == 20230811145848 EnsureCommitUserMentionsNoteIdBigintBackfillIsFinishedForSelfManaged: migrated (0.0068s) 1021main: == [advisory_lock_connection] object_id: 441133280, pg_backend_pid: 4331022 skips the check for GitLab.com, dev, or test1023INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree1024INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"1025INFO: "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 rows1026INFO: analyzing "public.p_ci_job_annotations" inheritance tree1027INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"1028INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1029INFO: analyzing "public.p_ci_builds_metadata" inheritance tree1030INFO: analyzing "public.ci_builds_metadata"1031INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1032INFO: analyzing "public.p_ci_builds" inheritance tree1033INFO: analyzing "public.ci_builds"1034INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1035RenamePlansTitlesWithLegacyPlanNames1036 # order random1037 #up1038main: == [advisory_lock_connection] object_id: 444127740, pg_backend_pid: 4391039main: == 20230815160428 RenamePlansTitlesWithLegacyPlanNames: migrating =============1040main: -- execute("UPDATE plans SET title = 'Premium' WHERE name = 'premium'")1041main: -> 0.0011s1042main: -- execute("UPDATE plans SET title = 'Ultimate' WHERE name = 'ultimate'")1043main: -> 0.0011s1044main: == 20230815160428 RenamePlansTitlesWithLegacyPlanNames: migrated (0.0082s) ====1045main: == [advisory_lock_connection] object_id: 444127740, pg_backend_pid: 4391046 updates the plan titles1047INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree1048INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"1049INFO: "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 rows1050INFO: analyzing "public.p_ci_job_annotations" inheritance tree1051INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"1052INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1053INFO: analyzing "public.p_ci_builds_metadata" inheritance tree1054INFO: analyzing "public.ci_builds_metadata"1055INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1056INFO: analyzing "public.p_ci_builds" inheritance tree1057INFO: analyzing "public.ci_builds"1058INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1059QueueBackfillProjectStatisticsStorageSizeWithRecentSize1060 # order random1061main: == [advisory_lock_connection] object_id: 447379700, pg_backend_pid: 4451062main: == 20230823090001 QueueBackfillProjectStatisticsStorageSizeWithRecentSize: migrating 1063main: == 20230823090001 QueueBackfillProjectStatisticsStorageSizeWithRecentSize: migrated (0.0536s) 1064main: == [advisory_lock_connection] object_id: 447379700, pg_backend_pid: 4451065 schedules a new batched migration1066INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree1067INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"1068INFO: "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 rows1069INFO: analyzing "public.p_ci_job_annotations" inheritance tree1070INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"1071INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1072INFO: analyzing "public.p_ci_builds_metadata" inheritance tree1073INFO: analyzing "public.ci_builds_metadata"1074INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1075INFO: analyzing "public.p_ci_builds" inheritance tree1076INFO: analyzing "public.ci_builds"1077INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows1078auto_explain log contains 895 entries for main, writing to /builds/gitlab-org/gitlab/auto_explain/rspec-migration-pg14-as-if-foss-single-db-1-8.328.main.ndjson.gz1079took 13.0456584651080Finished in 40 minutes 55 seconds (files took 49.86 seconds to load)108161 examples, 0 failures1082Randomized with seed 140301083RSpec exited with 0.1084No examples to retry, congrats!1086Running after script...1087$ echo -e "\e[0Ksection_start:`date +%s`:report_results_section[collapsed=true]\r\e[0KReport results"1091$ tooling/bin/push_job_metrics || true1092[job-metrics] Pushing job metrics file for the CI/CD job.1093[job-metrics] Pushed 4 CI job metric entries to InfluxDB.1095Not uploading cache ruby-gems-debian-bullseye-ruby-3.0-16 due to policy1097Uploading artifacts...1098auto_explain/: found 2 matching artifact files and directories 1099coverage/: found 5 matching artifact files and directories 1100crystalball/: found 2 matching artifact files and directories 1101WARNING: deprecations/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab) 1102knapsack/: found 4 matching artifact files and directories 1103rspec/: found 14 matching artifact files and directories 1104WARNING: tmp/capybara/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab) 1105log/*.log: found 13 matching artifact files and directories 1106WARNING: Upload request redirected location=https://gitlab.com/api/v4/jobs/5336651324/artifacts?artifact_format=zip&artifact_type=archive&expire_in=31d new-url=https://gitlab.com1107WARNING: Retrying... context=artifacts-uploader error=request redirected1108Uploading artifacts as "archive" to coordinator... 201 Created id=5336651324 responseStatus=201 Created token=64_4sygM1109Uploading artifacts...1110rspec/rspec-*.xml: found 1 matching artifact files and directories 1111WARNING: Upload request redirected location=https://gitlab.com/api/v4/jobs/5336651324/artifacts?artifact_format=gzip&artifact_type=junit&expire_in=31d new-url=https://gitlab.com1112WARNING: Retrying... context=artifacts-uploader error=request redirected1113Uploading artifacts as "junit" to coordinator... 201 Created id=5336651324 responseStatus=201 Created token=64_4sygM1115Job succeeded