rspec migration pg14-as-if-foss single-db 3/8
Passed Started
by
@vshushlin
Vladimir Shushlin
1Running with gitlab-runner 16.3.0~beta.108.g2b6048b4 (2b6048b4)2 on blue-6.private.runners-manager.gitlab.com/gitlab.com/gitlab-org mKJTFBei, system ID: s_90a66139ec063 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-mkjtfbei-project-278964-concurrent-0 via runner-mkjtfbei-private-1697780650-2a50f1d2...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.74 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_aNii248Downloading artifacts for detect-tests (5336650454)...49Downloading artifacts from coordinator... ok host=storage.googleapis.com id=5336650454 responseStatus=200 OK token=64_aNii250Downloading artifacts for retrieve-tests-metadata (5336650473)...51Downloading artifacts from coordinator... ok host=storage.googleapis.com id=5336650473 responseStatus=200 OK token=64_aNii252Downloading artifacts for setup-test-env (5336650424)...53Downloading artifacts from coordinator... ok host=storage.googleapis.com id=5336650424 responseStatus=200 OK token=64_aNii255Using 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_3_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_3_8_report.json153NEW_FLAKY_RSPEC_REPORT_PATH: rspec/flaky/new_rspec_migration_pg14-as-if-foss_single-db_3_8_report.json154RSPEC_SKIPPED_TESTS_REPORT_PATH: rspec/skipped_tests-5336651327.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.468896419 seconds196SyncNewAmountUsedForCiProjectMonthlyUsages197 # order random198main: == [advisory_lock_connection] object_id: 10269520, pg_backend_pid: 123199main: == 20221011062254 SyncNewAmountUsedForCiProjectMonthlyUsages: migrating =======200main: == 20221011062254 SyncNewAmountUsedForCiProjectMonthlyUsages: migrated (0.0118s) 201main: == [advisory_lock_connection] object_id: 10269520, pg_backend_pid: 123202 updates `new_amount_used` with values from `amount_used`203INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree204INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"205INFO: "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 rows206INFO: analyzing "public.p_ci_job_annotations" inheritance tree207INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"208INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows209INFO: analyzing "public.p_ci_builds_metadata" inheritance tree210INFO: analyzing "public.ci_builds_metadata"211INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows212INFO: analyzing "public.p_ci_builds" inheritance tree213INFO: analyzing "public.ci_builds"214INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows215FinalizeGroupMemberNamespaceIdMigration216 # order random217 #up218 when migration is missing219main: == [advisory_lock_connection] object_id: 37779020, pg_backend_pid: 132220main: == 20221002234454 FinalizeGroupMemberNamespaceIdMigration: migrating ==========221main: == 20221002234454 FinalizeGroupMemberNamespaceIdMigration: migrated (0.0104s) =222main: == [advisory_lock_connection] object_id: 37779020, pg_backend_pid: 132223 warns migration not found224 with migration present225 when migration finished successfully226main: == [advisory_lock_connection] object_id: 38935700, pg_backend_pid: 134227main: == 20221002234454 FinalizeGroupMemberNamespaceIdMigration: migrating ==========228main: == 20221002234454 FinalizeGroupMemberNamespaceIdMigration: migrated (0.0187s) =229main: == [advisory_lock_connection] object_id: 38935700, pg_backend_pid: 134230 does not raise exception231 with different migration statuses232 status: 0, description: "paused"233 behaves like finalizes the migration234 finalizes the migration235 status: 1, description: "active"236 behaves like finalizes the migration237 finalizes the migration238 status: 4, description: "failed"239 behaves like finalizes the migration240 finalizes the migration241 status: 5, description: "finalizing"242 behaves like finalizes the migration243 finalizes the migration244INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree245INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"246INFO: "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 rows247INFO: analyzing "public.p_ci_job_annotations" inheritance tree248INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"249INFO: "ci_job_annotations_100": 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_metadata" inheritance tree251INFO: analyzing "public.ci_builds_metadata"252INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows253INFO: analyzing "public.p_ci_builds" inheritance tree254INFO: analyzing "public.ci_builds"255INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows256FinalizeBackfillEnvironmentTierMigration257 # order random258 #up259 when migration is missing260main: == [advisory_lock_connection] object_id: 64249160, pg_backend_pid: 147261main: == 20230201171450 FinalizeBackfillEnvironmentTierMigration: migrating =========262main: == 20230201171450 FinalizeBackfillEnvironmentTierMigration: migrated (0.0192s) 263main: == [advisory_lock_connection] object_id: 64249160, pg_backend_pid: 147264 warns migration not found265 with migration present266 when migration finished successfully267main: == [advisory_lock_connection] object_id: 64898580, pg_backend_pid: 149268main: == 20230201171450 FinalizeBackfillEnvironmentTierMigration: migrating =========269main: == 20230201171450 FinalizeBackfillEnvironmentTierMigration: migrated (0.0279s) 270main: == [advisory_lock_connection] object_id: 64898580, pg_backend_pid: 149271 does not raise exception272 with different migration statuses273 status: 0, description: "paused"274 behaves like finalizes the migration275 finalizes the migration276 status: 1, description: "active"277 behaves like finalizes the migration278 finalizes the migration279 status: 4, description: "failed"280 behaves like finalizes the migration281 finalizes the migration282 status: 5, description: "finalizing"283 behaves like finalizes the migration284 finalizes the migration285INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree286INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"287INFO: "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 rows288INFO: analyzing "public.p_ci_job_annotations" inheritance tree289INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"290INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows291INFO: analyzing "public.p_ci_builds_metadata" inheritance tree292INFO: analyzing "public.ci_builds_metadata"293INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows294INFO: analyzing "public.p_ci_builds" inheritance tree295INFO: analyzing "public.ci_builds"296INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows297QueuePopulateProjectsStarCount298 # order random299main: == [advisory_lock_connection] object_id: 87996620, pg_backend_pid: 163300main: == 20221019105041 QueuePopulateProjectsStarCount: migrating ===================301main: == 20221019105041 QueuePopulateProjectsStarCount: migrated (0.0452s) ==========302main: == [advisory_lock_connection] object_id: 87996620, pg_backend_pid: 163303 schedules a new batched migration304INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree305INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"306INFO: "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 rows307INFO: analyzing "public.p_ci_job_annotations" inheritance tree308INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"309INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows310INFO: analyzing "public.p_ci_builds_metadata" inheritance tree311INFO: analyzing "public.ci_builds_metadata"312INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows313INFO: analyzing "public.p_ci_builds" inheritance tree314INFO: analyzing "public.ci_builds"315INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows316CreateRoutingTableForBuildsMetadataV2317 # order random318 #up319 when the table is already partitioned320main: -- execute("CREATE TABLE IF NOT EXISTS \"p_ci_builds_metadata\" (\n LIKE \"ci_builds_metadata\" INCLUDING ALL\n) PARTITION BY LIST(\"partition_id\")\n")321main: -> 0.0033s322main: -- current_schema(nil)323main: -> 0.0007s324main: -- execute("ALTER TABLE \"p_ci_builds_metadata\"\nATTACH PARTITION ci_builds_metadata\nFOR VALUES IN (100)\n;\n\nALTER SEQUENCE \"ci_builds_metadata_id_seq\" OWNED BY \"p_ci_builds_metadata\".\"id\";\n\nALTER TABLE \"p_ci_builds_metadata\"\nDROP CONSTRAINT \"partitioning_constraint\"\n")325main: -> 0.0038s326main: -- foreign_keys(:ci_builds_metadata)327main: -> 0.0050s328main: -- foreign_keys(:p_ci_builds_metadata)329main: -> 0.0051s330main: -- add_foreign_key(:p_ci_builds_metadata, "ci_builds", {:column=>"build_id", :name=>"fk_e20479742e", :primary_key=>"id", :on_delete=>:cascade, :on_update=>nil, :deferrable=>false, :validate=>true})331main: -> 0.0026s332main: == [advisory_lock_connection] object_id: 115231300, pg_backend_pid: 173333main: == 20221021145820 CreateRoutingTableForBuildsMetadataV2: migrating ============334main: == 20221021145820 CreateRoutingTableForBuildsMetadataV2: migrated (0.0044s) ===335main: == [advisory_lock_connection] object_id: 115231300, pg_backend_pid: 173336 skips the migration337INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree338INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"339INFO: "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 rows340INFO: analyzing "public.p_ci_job_annotations" inheritance tree341INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"342INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows343INFO: analyzing "public.p_ci_builds_metadata" inheritance tree344INFO: analyzing "public.ci_builds_metadata"345INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows346INFO: analyzing "public.p_ci_builds" inheritance tree347INFO: analyzing "public.ci_builds"348INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows349SchedulePruneStaleProjectExportJobs350 # order random351main: == [advisory_lock_connection] object_id: 141629200, pg_backend_pid: 183352main: == 20221122132812 SchedulePruneStaleProjectExportJobs: migrating ==============353main: == 20221122132812 SchedulePruneStaleProjectExportJobs: migrated (0.0453s) =====354main: == [advisory_lock_connection] object_id: 141629200, pg_backend_pid: 183355 schedules a new batched migration356The application_settings (main) table has 1248 columns.357Recreating the database358Dropped database 'gitlabhq_test'359Created database 'gitlabhq_test'360main: == [advisory_lock_connection] object_id: 142433780, pg_backend_pid: 190361main: == [advisory_lock_connection] object_id: 142433780, pg_backend_pid: 190362Databases re-creation done in 5.612993576000008363QueueFixIncoherentPackagesSizeOnProjectStatistics364 # order random365 with some packages366main: == [advisory_lock_connection] object_id: 150951100, pg_backend_pid: 195367main: == 20230119123937 QueueFixIncoherentPackagesSizeOnProjectStatistics: migrating 368main: == 20230119123937 QueueFixIncoherentPackagesSizeOnProjectStatistics: migrated (0.0493s) 369main: == [advisory_lock_connection] object_id: 150951100, pg_backend_pid: 195370 schedules a new batched migration371 with no packages372main: == [advisory_lock_connection] object_id: 151391480, pg_backend_pid: 198373main: == 20230119123937 QueueFixIncoherentPackagesSizeOnProjectStatistics: migrating 374main: == 20230119123937 QueueFixIncoherentPackagesSizeOnProjectStatistics: migrated (0.0134s) 375main: == [advisory_lock_connection] object_id: 151391480, pg_backend_pid: 198376 does not schedule a new batched migration377INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree378INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"379INFO: "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 rows380INFO: analyzing "public.p_ci_job_annotations" inheritance tree381INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"382INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows383INFO: analyzing "public.p_ci_builds_metadata" inheritance tree384INFO: analyzing "public.ci_builds_metadata"385INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows386INFO: analyzing "public.p_ci_builds" inheritance tree387INFO: analyzing "public.ci_builds"388INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows389SwapMergeRequestUserMentionsNoteIdToBigint2390 # order random391 #up392 swaps the integer and bigint columns for GitLab.com, dev, or test393 is a no-op for other instances394main: == [advisory_lock_connection] object_id: 172814880, pg_backend_pid: 214395main: == 20230310020356 SwapMergeRequestUserMentionsNoteIdToBigint2: migrating ======396main: == 20230310020356 SwapMergeRequestUserMentionsNoteIdToBigint2: migrated (0.0086s) 397main: == [advisory_lock_connection] object_id: 172814880, pg_backend_pid: 214398 is a no-op if columns are already swapped399INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree400INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"401INFO: "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 rows402INFO: analyzing "public.p_ci_job_annotations" inheritance tree403INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"404INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows405INFO: analyzing "public.p_ci_builds_metadata" inheritance tree406INFO: analyzing "public.ci_builds_metadata"407INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows408INFO: analyzing "public.p_ci_builds" inheritance tree409INFO: analyzing "public.ci_builds"410INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows411SetEmailConfirmationSettingFromSoftEmailConfirmationFf412 # order random413 #down414 updates 'email_confirmation_setting' to default value: '0' (off)415 #up416 when feature gate for `soft_email_confirmation` does not exist417 does not update `email_confirmation_setting`418 when feature gate for `soft_email_confirmation` does exist419 when feature gate value is `false`420 does not update `email_confirmation_setting`421 when feature gate value is `true`422 updates `email_confirmation_setting` to '1' (soft)423INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree424INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"425INFO: "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 rows426INFO: analyzing "public.p_ci_job_annotations" inheritance tree427INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"428INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows429INFO: analyzing "public.p_ci_builds_metadata" inheritance tree430INFO: analyzing "public.ci_builds_metadata"431INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows432INFO: analyzing "public.p_ci_builds" inheritance tree433INFO: analyzing "public.ci_builds"434INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows435DropPackagesEventsTable436 # order random437main: -- table_exists?(:packages_events)438main: -> 0.0025s439main: == [advisory_lock_connection] object_id: 209588500, pg_backend_pid: 232440main: == 20230316185746 DropPackagesEventsTable: migrating ==========================441main: -- drop_table(:packages_events, {:if_exists=>true})442main: -> 0.0020s443main: == 20230316185746 DropPackagesEventsTable: migrated (0.0106s) =================444main: == [advisory_lock_connection] object_id: 209588500, pg_backend_pid: 232445main: -- table_exists?(:packages_events)446main: -> 0.0029s447main: -- table_exists?(:packages_events)448main: -> 0.0028s449 drops and creates the packages_events table450INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree451INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"452INFO: "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 rows453INFO: analyzing "public.p_ci_job_annotations" inheritance tree454INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"455INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows456INFO: analyzing "public.p_ci_builds_metadata" inheritance tree457INFO: analyzing "public.ci_builds_metadata"458INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows459INFO: analyzing "public.p_ci_builds" inheritance tree460INFO: analyzing "public.ci_builds"461INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows462SwapMergeRequestMetricsIdToBigintForSelfHosts463 # order random464 #up465 when is GitLab.com, dev, or test466 does not swap the columns467 when is a self-host customer with the swapped already completed468main: == [advisory_lock_connection] object_id: 227299600, pg_backend_pid: 245469main: == 20230419094939 SwapMergeRequestMetricsIdToBigintForSelfHosts: migrating ====470main: -- columns("merge_request_metrics")471main: -> 0.0040s472main: -- columns("merge_request_metrics")473main: -> 0.0033s474main: == 20230419094939 SwapMergeRequestMetricsIdToBigintForSelfHosts: migrated (0.0163s) 475main: == [advisory_lock_connection] object_id: 227299600, pg_backend_pid: 245476 does not swap the columns477 when is a self-host customer with the `id_convert_to_bigint` column already dropped478 does not swap the columns479 when is a self-host customer480 swaps the columns481INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree482INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"483INFO: "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 rows484INFO: analyzing "public.p_ci_job_annotations" inheritance tree485INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"486INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows487INFO: analyzing "public.p_ci_builds_metadata" inheritance tree488INFO: analyzing "public.ci_builds_metadata"489INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows490INFO: analyzing "public.p_ci_builds" inheritance tree491INFO: analyzing "public.ci_builds"492INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows493EnsureMrUserMentionsNoteIdBigintBackfillIsFinishedForGitlabDotCom494 # order random495 #up496main: == [advisory_lock_connection] object_id: 244438960, pg_backend_pid: 259497main: == 20230301020246 EnsureMrUserMentionsNoteIdBigintBackfillIsFinishedForGitlabDotCom: migrating 498main: == 20230301020246 EnsureMrUserMentionsNoteIdBigintBackfillIsFinishedForGitlabDotCom: migrated (0.0075s) 499main: == [advisory_lock_connection] object_id: 244438960, pg_backend_pid: 259500 ensures the migration is completed for GitLab.com, dev, or test501main: == [advisory_lock_connection] object_id: 245204500, pg_backend_pid: 261502main: == 20230301020246 EnsureMrUserMentionsNoteIdBigintBackfillIsFinishedForGitlabDotCom: migrating 503main: == 20230301020246 EnsureMrUserMentionsNoteIdBigintBackfillIsFinishedForGitlabDotCom: migrated (0.0068s) 504main: == [advisory_lock_connection] object_id: 245204500, pg_backend_pid: 261505 skips the check for other instances506INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree507INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"508INFO: "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 rows509INFO: analyzing "public.p_ci_job_annotations" inheritance tree510INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"511INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows512INFO: analyzing "public.p_ci_builds_metadata" inheritance tree513INFO: analyzing "public.ci_builds_metadata"514INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows515INFO: analyzing "public.p_ci_builds" inheritance tree516INFO: analyzing "public.ci_builds"517INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows518SwapSnippetUserMentionsNoteIdToBigintForGitlabDotCom519 # order random520 #up521 swaps the integer and bigint columns for GitLab.com, dev, or test522 is a no-op for other instances523The application_settings (main) table has 1223 columns.524Recreating the database525Dropped database 'gitlabhq_test'526Created database 'gitlabhq_test'527main: == [advisory_lock_connection] object_id: 264285340, pg_backend_pid: 280528main: == [advisory_lock_connection] object_id: 264285340, pg_backend_pid: 280529Databases re-creation done in 5.535336089000339530AddAwardEmojiWorkItemWidget531 # order random532 behaves like migration that adds widget to work items definitions533 #up534main: == [advisory_lock_connection] object_id: 270747320, pg_backend_pid: 285535main: == 20230323101138 AddAwardEmojiWorkItemWidget: migrating ======================536main: == 20230323101138 AddAwardEmojiWorkItemWidget: migrated (0.0400s) =============537main: == [advisory_lock_connection] object_id: 270747320, pg_backend_pid: 285538 creates widget definition in all types539main: == [advisory_lock_connection] object_id: 271297320, pg_backend_pid: 287540main: == 20230323101138 AddAwardEmojiWorkItemWidget: migrating ======================541main: == 20230323101138 AddAwardEmojiWorkItemWidget: migrated (0.0439s) =============542main: == [advisory_lock_connection] object_id: 271297320, pg_backend_pid: 287543 logs a warning if the type is missing544 #down545main: == [advisory_lock_connection] object_id: 271449460, pg_backend_pid: 289546main: == 20230323101138 AddAwardEmojiWorkItemWidget: migrating ======================547main: == 20230323101138 AddAwardEmojiWorkItemWidget: migrated (0.0465s) =============548main: == [advisory_lock_connection] object_id: 271449460, pg_backend_pid: 289549 removes definitions for widget550INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree551INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"552INFO: "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 rows553INFO: analyzing "public.p_ci_job_annotations" inheritance tree554INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"555INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows556INFO: analyzing "public.p_ci_builds_metadata" inheritance tree557INFO: analyzing "public.ci_builds_metadata"558INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows559INFO: analyzing "public.p_ci_builds" inheritance tree560INFO: analyzing "public.ci_builds"561INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows562QueuePopulateVulnerabilityDismissalFields563 # order random564 #down565main: == [advisory_lock_connection] object_id: 287889720, pg_backend_pid: 297566main: == 20230412185837 QueuePopulateVulnerabilityDismissalFields: migrating ========567main: == 20230412185837 QueuePopulateVulnerabilityDismissalFields: migrated (0.0513s) 568main: == [advisory_lock_connection] object_id: 287889720, pg_backend_pid: 297569 deletes all batched migration records570 #up571main: == [advisory_lock_connection] object_id: 288641500, pg_backend_pid: 300572main: == 20230412185837 QueuePopulateVulnerabilityDismissalFields: migrating ========573main: == 20230412185837 QueuePopulateVulnerabilityDismissalFields: migrated (0.0560s) 574main: == [advisory_lock_connection] object_id: 288641500, pg_backend_pid: 300575 schedules a new batched migration576INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree577INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"578INFO: "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 rows579INFO: analyzing "public.p_ci_job_annotations" inheritance tree580INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"581INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows582INFO: analyzing "public.p_ci_builds_metadata" inheritance tree583INFO: analyzing "public.ci_builds_metadata"584INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows585INFO: analyzing "public.p_ci_builds" inheritance tree586INFO: analyzing "public.ci_builds"587INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows588EnsureSnippetUserMentionsBigintBackfillIsFinishedForGitlabDotCom589 # order random590 #up591main: == [advisory_lock_connection] object_id: 304966640, pg_backend_pid: 309592main: == 20230322011220 EnsureSnippetUserMentionsBigintBackfillIsFinishedForGitlabDotCom: migrating 593main: == 20230322011220 EnsureSnippetUserMentionsBigintBackfillIsFinishedForGitlabDotCom: migrated (0.0072s) 594main: == [advisory_lock_connection] object_id: 304966640, pg_backend_pid: 309595 ensures the migration is completed for GitLab.com, dev, or test596main: == [advisory_lock_connection] object_id: 305546940, pg_backend_pid: 311597main: == 20230322011220 EnsureSnippetUserMentionsBigintBackfillIsFinishedForGitlabDotCom: migrating 598main: == 20230322011220 EnsureSnippetUserMentionsBigintBackfillIsFinishedForGitlabDotCom: migrated (0.0080s) 599main: == [advisory_lock_connection] object_id: 305546940, pg_backend_pid: 311600 skips the check for other instances601INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree602INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"603INFO: "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 rows604INFO: analyzing "public.p_ci_job_annotations" inheritance tree605INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"606INFO: "ci_job_annotations_100": 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_metadata" inheritance tree608INFO: analyzing "public.ci_builds_metadata"609INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows610INFO: analyzing "public.p_ci_builds" inheritance tree611INFO: analyzing "public.ci_builds"612INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows613EnsureDesignUserMentionsNoteIdBigintBackfillIsFinishedForGitlabDotCom614 # order random615 #up616main: == [advisory_lock_connection] object_id: 322880080, pg_backend_pid: 319617main: == 20230321024333 EnsureDesignUserMentionsNoteIdBigintBackfillIsFinishedForGitlabDotCom: migrating 618main: == 20230321024333 EnsureDesignUserMentionsNoteIdBigintBackfillIsFinishedForGitlabDotCom: migrated (0.0071s) 619main: == [advisory_lock_connection] object_id: 322880080, pg_backend_pid: 319620 ensures the migration is completed for GitLab.com, dev, or test621main: == [advisory_lock_connection] object_id: 323473820, pg_backend_pid: 321622main: == 20230321024333 EnsureDesignUserMentionsNoteIdBigintBackfillIsFinishedForGitlabDotCom: migrating 623main: == 20230321024333 EnsureDesignUserMentionsNoteIdBigintBackfillIsFinishedForGitlabDotCom: migrated (0.0083s) 624main: == [advisory_lock_connection] object_id: 323473820, pg_backend_pid: 321625 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 rows638FixImportSourcesOnApplicationSettingsAfterPhabricatorRemoval639 # order random640 #up641 when import_sources is a String642 behaves like fixes import_sources on application_settings643main: == [advisory_lock_connection] object_id: 339748120, pg_backend_pid: 329644main: == 20230426102200 FixImportSourcesOnApplicationSettingsAfterPhabricatorRemoval: migrating 645main: == 20230426102200 FixImportSourcesOnApplicationSettingsAfterPhabricatorRemoval: migrated (0.1584s) 646main: == [advisory_lock_connection] object_id: 339748120, pg_backend_pid: 329647 ensures YAML is stored648 when import_sources is already YAML649 behaves like fixes import_sources on application_settings650main: == [advisory_lock_connection] object_id: 340421640, pg_backend_pid: 331651main: == 20230426102200 FixImportSourcesOnApplicationSettingsAfterPhabricatorRemoval: migrating 652main: == 20230426102200 FixImportSourcesOnApplicationSettingsAfterPhabricatorRemoval: migrated (0.1419s) 653main: == [advisory_lock_connection] object_id: 340421640, pg_backend_pid: 331654 ensures YAML is stored655INFO: 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 rows667AddAuthorsAndDescriptionToNugetMetadatum668 # order random669main: == [advisory_lock_connection] object_id: 354899540, pg_backend_pid: 339670main: == 20230505115558 AddAuthorsAndDescriptionToNugetMetadatum: migrating =========671main: -- add_column(:packages_nuget_metadata, :authors, :text, {:if_not_exists=>true})672main: -> 0.0048s673main: -- add_column(:packages_nuget_metadata, :description, :text, {:if_not_exists=>true})674main: -> 0.0048s675main: -- execute("ALTER TABLE packages_nuget_metadata\nADD CONSTRAINT check_e2fc129ebd\nCHECK ( char_length(authors) <= 255 )\nNOT VALID;\n")676main: -> 0.0014s677main: -- execute("ALTER TABLE packages_nuget_metadata VALIDATE CONSTRAINT check_e2fc129ebd;")678main: -> 0.0011s679main: -- execute("ALTER TABLE packages_nuget_metadata\nADD CONSTRAINT check_d39a5fe9ee\nCHECK ( char_length(description) <= 4000 )\nNOT VALID;\n")680main: -> 0.0014s681main: -- execute("ALTER TABLE packages_nuget_metadata VALIDATE CONSTRAINT check_d39a5fe9ee;")682main: -> 0.0012s683main: == 20230505115558 AddAuthorsAndDescriptionToNugetMetadatum: migrated (0.0517s) 684main: == [advisory_lock_connection] object_id: 354899540, pg_backend_pid: 339685 correctly migrates up and down686INFO: 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 rows698RescheduleEvidencesHandlingUnicode699 # order random700 #down701main: == [advisory_lock_connection] object_id: 369699220, pg_backend_pid: 348702main: == 20230508150219 RescheduleEvidencesHandlingUnicode: migrating ===============703main: == 20230508150219 RescheduleEvidencesHandlingUnicode: migrated (0.0600s) ======704main: == [advisory_lock_connection] object_id: 369699220, pg_backend_pid: 348705 deletes all batched migration records706 #up707main: == [advisory_lock_connection] object_id: 370441320, pg_backend_pid: 351708main: == 20230508150219 RescheduleEvidencesHandlingUnicode: migrating ===============709main: == 20230508150219 RescheduleEvidencesHandlingUnicode: migrated (0.0538s) ======710main: == [advisory_lock_connection] object_id: 370441320, pg_backend_pid: 351711 schedules a batched background migration712INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree713INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"714INFO: "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 rows715INFO: analyzing "public.p_ci_job_annotations" inheritance tree716INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"717INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows718INFO: analyzing "public.p_ci_builds_metadata" inheritance tree719INFO: analyzing "public.ci_builds_metadata"720INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows721INFO: analyzing "public.p_ci_builds" inheritance tree722INFO: analyzing "public.ci_builds"723INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows724QueueBackfillCodeSuggestionsNamespaceSettings725 # order random726main: == [advisory_lock_connection] object_id: 384197740, pg_backend_pid: 359727main: == 20230518071251 QueueBackfillCodeSuggestionsNamespaceSettings: migrating ====728main: == 20230518071251 QueueBackfillCodeSuggestionsNamespaceSettings: migrated (0.0817s) 729main: == [advisory_lock_connection] object_id: 384197740, pg_backend_pid: 359730 schedules a new batched migration731INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree732INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"733INFO: "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 rows734INFO: analyzing "public.p_ci_job_annotations" inheritance tree735INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"736INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows737INFO: analyzing "public.p_ci_builds_metadata" inheritance tree738INFO: analyzing "public.ci_builds_metadata"739INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows740INFO: analyzing "public.p_ci_builds" inheritance tree741INFO: analyzing "public.ci_builds"742INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows743UpdateRequeueWorkersInApplicationSettingsForGitlabCom744 # order random745 #up746main: == [advisory_lock_connection] object_id: 395662300, pg_backend_pid: 367747main: == 20230621070810 UpdateRequeueWorkersInApplicationSettingsForGitlabCom: migrating 748main: == 20230621070810 UpdateRequeueWorkersInApplicationSettingsForGitlabCom: migrated (0.0083s) 749main: == [advisory_lock_connection] object_id: 395662300, pg_backend_pid: 367750 does nothing751main: == [advisory_lock_connection] object_id: 395966300, pg_backend_pid: 369752main: == 20230621070810 UpdateRequeueWorkersInApplicationSettingsForGitlabCom: migrating 753main: -- execute("UPDATE application_settings SET elasticsearch_requeue_workers = true")754main: -> 0.0016s755main: == 20230621070810 UpdateRequeueWorkersInApplicationSettingsForGitlabCom: migrated (0.0093s) 756main: == [advisory_lock_connection] object_id: 395966300, pg_backend_pid: 369757 updates elasticsearch_requeue_workers when gitlab.com758 #down759main: == [advisory_lock_connection] object_id: 396132720, pg_backend_pid: 371760main: == 20230621070810 UpdateRequeueWorkersInApplicationSettingsForGitlabCom: migrating 761main: == 20230621070810 UpdateRequeueWorkersInApplicationSettingsForGitlabCom: migrated (0.0074s) 762main: == [advisory_lock_connection] object_id: 396132720, pg_backend_pid: 371763 does nothing764main: == [advisory_lock_connection] object_id: 396318940, pg_backend_pid: 374765main: == 20230621070810 UpdateRequeueWorkersInApplicationSettingsForGitlabCom: migrating 766main: -- execute("UPDATE application_settings SET elasticsearch_requeue_workers = true")767main: -> 0.0017s768main: == 20230621070810 UpdateRequeueWorkersInApplicationSettingsForGitlabCom: migrated (0.0096s) 769main: == [advisory_lock_connection] object_id: 396318940, pg_backend_pid: 374770 updates elasticsearch_requeue_workers when gitlab.com771The application_settings (main) table has 1265 columns.772Recreating the database773Dropped database 'gitlabhq_test'774Created database 'gitlabhq_test'775main: == [advisory_lock_connection] object_id: 396483700, pg_backend_pid: 382776main: == [advisory_lock_connection] object_id: 396483700, pg_backend_pid: 382777Databases re-creation done in 5.562651475000166778QueueBackfillDismissalReasonInVulnerabilityReads779 # order random780main: == [advisory_lock_connection] object_id: 399188420, pg_backend_pid: 386781main: == 20230612232000 QueueBackfillDismissalReasonInVulnerabilityReads: migrating =782main: == 20230612232000 QueueBackfillDismissalReasonInVulnerabilityReads: migrated (0.0557s) 783main: == [advisory_lock_connection] object_id: 399188420, pg_backend_pid: 386784 schedules a new batched migration785INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree786INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"787INFO: "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 rows788INFO: analyzing "public.p_ci_job_annotations" inheritance tree789INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"790INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows791INFO: analyzing "public.p_ci_builds_metadata" inheritance tree792INFO: analyzing "public.ci_builds_metadata"793INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows794INFO: analyzing "public.p_ci_builds" inheritance tree795INFO: analyzing "public.ci_builds"796INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows797AddExpiryNotifiedAtToMember798 # order random799main: == [advisory_lock_connection] object_id: 407324540, pg_backend_pid: 394800main: == 20230707003301 AddExpiryNotifiedAtToMember: migrating ======================801main: -- add_column("members", "expiry_notified_at", :datetime_with_timezone)802main: -> 0.0012s803main: == 20230707003301 AddExpiryNotifiedAtToMember: migrated (0.0111s) =============804main: == [advisory_lock_connection] object_id: 407324540, pg_backend_pid: 394805 correctly migrates up and down806INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree807INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"808INFO: "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 rows809INFO: analyzing "public.p_ci_job_annotations" inheritance tree810INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"811INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows812INFO: analyzing "public.p_ci_builds_metadata" inheritance tree813INFO: analyzing "public.ci_builds_metadata"814INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows815INFO: analyzing "public.p_ci_builds" inheritance tree816INFO: analyzing "public.ci_builds"817INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows818QueueDeleteOrphanedTransferredProjectApprovalRules819 # order random820main: == [advisory_lock_connection] object_id: 413939880, pg_backend_pid: 401821main: == 20230724164745 QueueDeleteOrphanedTransferredProjectApprovalRules: migrating 822main: == 20230724164745 QueueDeleteOrphanedTransferredProjectApprovalRules: migrated (0.0501s) 823main: == [advisory_lock_connection] object_id: 413939880, pg_backend_pid: 401824 schedules a new batched migration825INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree826INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"827INFO: "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 rows828INFO: analyzing "public.p_ci_job_annotations" inheritance tree829INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"830INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows831INFO: analyzing "public.p_ci_builds_metadata" inheritance tree832INFO: analyzing "public.ci_builds_metadata"833INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows834INFO: analyzing "public.p_ci_builds" inheritance tree835INFO: analyzing "public.ci_builds"836INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows837SwapIssueUserMentionsNoteIdToBigintForSelfManaged838 # order random839 #up840 when GitLab.com, dev, or test841 behaves like column `note_id_convert_to_bigint` is already dropped842 does not swaps the columns843 when self-managed instance with the `note_id_convert_to_bigint` column already dropped844 behaves like column `note_id_convert_to_bigint` is already dropped845 does not swaps the columns846 when self-managed instance columns already swapped847 does not swaps the columns848 when self-managed instance849 swaps the columns850INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree851INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"852INFO: "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 rows853INFO: analyzing "public.p_ci_job_annotations" inheritance tree854INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"855INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows856INFO: analyzing "public.p_ci_builds_metadata" inheritance tree857INFO: analyzing "public.ci_builds_metadata"858INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows859INFO: analyzing "public.p_ci_builds" inheritance tree860INFO: analyzing "public.ci_builds"861INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows862RestartSelfHostedSentNotificationsBigintConversion863 # order random864 when is not self-hosted865 #up866 is a bigint and result in no change867 when is self-hosted868 #up869 when id is already a bigint870 does nothing871 when id is an integer and id_convert_to_bigint exists872 does nothing873 when id is an integer and id_convert_to_bigint does not exist874 creates id_convert_to_bigint875 #down876 when id is an integer and id_convert_to_bigint exists877 drops id_convert_to_bigint878INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree879INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"880INFO: "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 rows881INFO: analyzing "public.p_ci_job_annotations" inheritance tree882INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"883INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows884INFO: analyzing "public.p_ci_builds_metadata" inheritance tree885INFO: analyzing "public.ci_builds_metadata"886INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows887INFO: analyzing "public.p_ci_builds" inheritance tree888INFO: analyzing "public.ci_builds"889INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows890UpdatePackageMetadataSyncSetting891 # order random892 #up893 with default value894main: == [advisory_lock_connection] object_id: 425653220, pg_backend_pid: 440895main: == 20230823160533 UpdatePackageMetadataSyncSetting: migrating =================896main: == 20230823160533 UpdatePackageMetadataSyncSetting: migrated (0.1573s) ========897main: == [advisory_lock_connection] object_id: 425653220, pg_backend_pid: 440898 updates setting899 with custom value900main: == [advisory_lock_connection] object_id: 426426040, pg_backend_pid: 442901main: == 20230823160533 UpdatePackageMetadataSyncSetting: migrating =================902main: == 20230823160533 UpdatePackageMetadataSyncSetting: migrated (0.1362s) ========903main: == [advisory_lock_connection] object_id: 426426040, pg_backend_pid: 442904 does not change setting905INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree906INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"907INFO: "ci_runner_machine_builds_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows908INFO: analyzing "public.p_ci_job_annotations" inheritance tree909INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"910INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows911INFO: analyzing "public.p_ci_builds_metadata" inheritance tree912INFO: analyzing "public.ci_builds_metadata"913INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows914INFO: analyzing "public.p_ci_builds" inheritance tree915INFO: analyzing "public.ci_builds"916INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows917EnsureIssueUserMentionsBigintBackfillIsFinishedForSelfManaged918 # order random919 #up920main: == [advisory_lock_connection] object_id: 429281380, pg_backend_pid: 447921main: == 20230809203254 EnsureIssueUserMentionsBigintBackfillIsFinishedForSelfManaged: migrating 922main: == 20230809203254 EnsureIssueUserMentionsBigintBackfillIsFinishedForSelfManaged: migrated (0.0069s) 923main: == [advisory_lock_connection] object_id: 429281380, pg_backend_pid: 447924 ensures the migration is completed for self-managed instances925main: == [advisory_lock_connection] object_id: 429914240, pg_backend_pid: 449926main: == 20230809203254 EnsureIssueUserMentionsBigintBackfillIsFinishedForSelfManaged: migrating 927main: == 20230809203254 EnsureIssueUserMentionsBigintBackfillIsFinishedForSelfManaged: migrated (0.0066s) 928main: == [advisory_lock_connection] object_id: 429914240, pg_backend_pid: 449929 skips the check for GitLab.com, dev, or test930INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree931INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"932INFO: "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 rows933INFO: analyzing "public.p_ci_job_annotations" inheritance tree934INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"935INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows936INFO: analyzing "public.p_ci_builds_metadata" inheritance tree937INFO: analyzing "public.ci_builds_metadata"938INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows939INFO: analyzing "public.p_ci_builds" inheritance tree940INFO: analyzing "public.ci_builds"941INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows942SwapColumnsForCiPipelineChatDataPipelineIdBigint943 # order random944 swaps columns945 when legacy foreign key exists946 renames the legacy foreign key fk_rails_64ebfab6b3947INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree948INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"949INFO: "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 rows950INFO: analyzing "public.p_ci_job_annotations" inheritance tree951INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"952INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows953INFO: analyzing "public.p_ci_builds_metadata" inheritance tree954INFO: analyzing "public.ci_builds_metadata"955INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows956INFO: analyzing "public.p_ci_builds" inheritance tree957INFO: analyzing "public.ci_builds"958INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows959QueueBackfillHasMergeRequestOfVulnerabilityReads960 # order random961main: == [advisory_lock_connection] object_id: 435143620, pg_backend_pid: 464962main: == 20230907155247 QueueBackfillHasMergeRequestOfVulnerabilityReads: migrating =963main: == 20230907155247 QueueBackfillHasMergeRequestOfVulnerabilityReads: migrated (0.0502s) 964main: == [advisory_lock_connection] object_id: 435143620, pg_backend_pid: 464965 schedules a new batched migration966INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree967INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"968INFO: "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 rows969INFO: analyzing "public.p_ci_job_annotations" inheritance tree970INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"971INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows972INFO: analyzing "public.p_ci_builds_metadata" inheritance tree973INFO: analyzing "public.ci_builds_metadata"974INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows975INFO: analyzing "public.p_ci_builds" inheritance tree976INFO: analyzing "public.ci_builds"977INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows978auto_explain log contains 911 entries for main, writing to /builds/gitlab-org/gitlab/auto_explain/rspec-migration-pg14-as-if-foss-single-db-3-8.328.main.ndjson.gz979took 12.250014475980Finished in 39 minutes 49 seconds (files took 50.81 seconds to load)98172 examples, 0 failures982Randomized with seed 54737983RSpec exited with 0.984No examples to retry, congrats!986Running after script...987$ echo -e "\e[0Ksection_start:`date +%s`:report_results_section[collapsed=true]\r\e[0KReport results"991$ tooling/bin/push_job_metrics || true992[job-metrics] Pushing job metrics file for the CI/CD job.993[job-metrics] Pushed 4 CI job metric entries to InfluxDB.995Not uploading cache ruby-gems-debian-bullseye-ruby-3.0-16 due to policy997Uploading artifacts...998auto_explain/: found 2 matching artifact files and directories 999coverage/: found 5 matching artifact files and directories 1000crystalball/: found 2 matching artifact files and directories 1001WARNING: deprecations/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab) 1002knapsack/: found 4 matching artifact files and directories 1003rspec/: found 14 matching artifact files and directories 1004WARNING: tmp/capybara/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab) 1005log/*.log: found 13 matching artifact files and directories 1006WARNING: Upload request redirected location=https://gitlab.com/api/v4/jobs/5336651327/artifacts?artifact_format=zip&artifact_type=archive&expire_in=31d new-url=https://gitlab.com1007WARNING: Retrying... context=artifacts-uploader error=request redirected1008Uploading artifacts as "archive" to coordinator... 201 Created id=5336651327 responseStatus=201 Created token=64_aNii21009Uploading artifacts...1010rspec/rspec-*.xml: found 1 matching artifact files and directories 1011WARNING: Upload request redirected location=https://gitlab.com/api/v4/jobs/5336651327/artifacts?artifact_format=gzip&artifact_type=junit&expire_in=31d new-url=https://gitlab.com1012WARNING: Retrying... context=artifacts-uploader error=request redirected1013Uploading artifacts as "junit" to coordinator... 201 Created id=5336651327 responseStatus=201 Created token=64_aNii21015Job succeeded