rspec migration pg13 single-db 2/8
Passed Started
by
@fabiopitino
Fabio Pitino
1Running with gitlab-runner 16.1.0~beta.5.gf131a6a2 (f131a6a2)2 on blue-5.private.runners-manager.gitlab.com/gitlab.com/gitlab-org PYwgZLQB, system ID: s_4bff81aff7f73 feature flags: FF_NETWORK_PER_BUILD:true, FF_USE_FASTZIP:true, FF_USE_IMPROVED_URL_MASKING:true6Using Docker executor with image registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bullseye-ruby-3.0.patched-golang-1.19-rust-1.65-node-18.16-postgresql-13: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-13-pgvector-0.4.1 ...8Authenticating with credentials from job payload (GitLab Registry)9Pulling docker image registry.gitlab.com/gitlab-org/gitlab-build-images:postgres-13-pgvector-0.4.1 ...10Using docker image sha256:73740c557807c4bc5d692f263c0e35454270600da4b22bbe952331411426c8b5 for registry.gitlab.com/gitlab-org/gitlab-build-images:postgres-13-pgvector-0.4.1 with digest registry.gitlab.com/gitlab-org/gitlab-build-images@sha256:3174001f839c42e299ac06a42f8ded446edfcb33b0eb820874749a3f53eb799c ...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:a9a90ece30d9630d694ab1997cd103ea8ec729789451b983a75c7b58b0062d45 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:7ef36177d5d0bc554fbb63d8210ae751bcc538bea7905b51d078d9ab90a755fa ...17Starting service redis:6.2-alpine ...18Pulling docker image redis:6.2-alpine ...19Using docker image sha256:85fd7bd884b6493c8eb6f4dffbe5406d97cce56aff84f1580a5eb5b9d841f158 for redis:6.2-alpine with digest redis@sha256:87c44d5d9f472e767c8737f4130c765d77bdc95c7472d6427cfc9d4632f12da6 ...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.19-rust-1.65-node-18.16-postgresql-13:rubygems-3.4-git-2.36-lfs-2.9-chrome-113-yarn-1.22-graphicsmagick-1.3.36 ...23Using docker image sha256:61b59025d0d646cd177f654d8f81df859675be528f37dcc2ce6f39a49c7a5dd9 for registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bullseye-ruby-3.0.patched-golang-1.19-rust-1.65-node-18.16-postgresql-13: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.19-rust-1.65-node-18.16-postgresql-13@sha256:25367d41b1034f1ecacfc9cb8eebc70cb30c6fdade3781cf295488255bf61614 ...25Running on runner-pywgzlqb-project-278964-concurrent-0 via runner-pywgzlqb-private-1685686798-94ba675f...27Fetching changes with git depth set to 20...28Initialized empty Git repository in /builds/gitlab-org/gitlab/.git/29Created fresh repository.30remote: Enumerating objects: 139970, done. 31remote: Counting objects: 100% (139970/139970), done. 32remote: Compressing objects: 100% (94736/94736), done. 33remote: Total 139970 (delta 61223), reused 92025 (delta 39894), pack-reused 0 34Receiving objects: 100% (139970/139970), 123.36 MiB | 30.67 MiB/s, done.35Resolving deltas: 100% (61223/61223), done.37 * [new ref] refs/pipelines/887306308 -> refs/pipelines/88730630838Checking out 95754c79 as detached HEAD (ref is refs/merge-requests/122015/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.zip 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 (4400964016)...47Downloading artifacts from coordinator... ok host=storage.googleapis.com id=4400964016 responseStatus=200 OK token=64_buqgi48Downloading artifacts for detect-tests (4400964025)...49Downloading artifacts from coordinator... ok host=storage.googleapis.com id=4400964025 responseStatus=200 OK token=64_buqgi50Downloading artifacts for retrieve-tests-metadata (4400964028)...51Downloading artifacts from coordinator... ok host=storage.googleapis.com id=4400964028 responseStatus=200 OK token=64_buqgi52Downloading artifacts for setup-test-env (4400964019)...53Downloading artifacts from coordinator... ok host=storage.googleapis.com id=4400964019 responseStatus=200 OK token=64_buqgi55Using docker image sha256:61b59025d0d646cd177f654d8f81df859675be528f37dcc2ce6f39a49c7a5dd9 for registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bullseye-ruby-3.0.patched-golang-1.19-rust-1.65-node-18.16-postgresql-13: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.19-rust-1.65-node-18.16-postgresql-13@sha256:25367d41b1034f1ecacfc9cb8eebc70cb30c6fdade3781cf295488255bf61614 ...56$ echo $FOSS_ONLY57$ [ "$FOSS_ONLY" = "1" ] && rm -rf ee/ qa/spec/ee/ qa/qa/specs/features/ee/ qa/qa/ee/ qa/qa/ee.rb58$ export GOPATH=$CI_PROJECT_DIR/.go59$ mkdir -p $GOPATH60$ source scripts/utils.sh61$ source scripts/prepare_build.sh716Using decomposed database config (config/database.yml.postgresql)717Disabling ci connection in config/database.yml718Geo DB won't be set up.719Embedding DB won't be set up.731$ source ./scripts/rspec_helpers.sh732$ run_timed_command "gem install knapsack --no-document"733$ gem install knapsack --no-document734Successfully installed knapsack-4.0.07351 gem installed736==> 'gem install knapsack --no-document' succeeded in 1 seconds.737$ echo -e "\e[0Ksection_start:`date +%s`:gitaly-test-spawn[collapsed=true]\r\e[0KStarting Gitaly"739$ section_start "gitaly-test-spawn" "Spawning Gitaly"; scripts/gitaly-test-spawn; section_end "gitaly-test-spawn"744$ echo -e "\e[0Ksection_end:`date +%s`:gitaly-test-spawn\r\e[0K"745$ rspec_paralellized_job "--tag ~quarantine --tag ~zoekt"746SKIP_FLAKY_TESTS_AUTOMATICALLY: 747RETRY_FAILED_TESTS_IN_NEW_PROCESS: true748KNAPSACK_GENERATE_REPORT: true749FLAKY_RSPEC_GENERATE_REPORT: true750KNAPSACK_TEST_FILE_PATTERN: spec/{migrations}{,/**/}*_spec.rb751KNAPSACK_LOG_LEVEL: debug752KNAPSACK_REPORT_PATH: knapsack/rspec_migration_pg13_single-db_2_8_report.json753FLAKY_RSPEC_SUITE_REPORT_PATH: rspec/flaky/report-suite.json754FLAKY_RSPEC_REPORT_PATH: rspec/flaky/all_rspec_migration_pg13_single-db_2_8_report.json755NEW_FLAKY_RSPEC_REPORT_PATH: rspec/flaky/new_rspec_migration_pg13_single-db_2_8_report.json756SKIPPED_TESTS_REPORT_PATH: rspec/skipped_tests_rspec_migration_pg13_single-db_2_8.txt757CRYSTALBALL: 758RSPEC_TESTS_MAPPING_ENABLED: 759RSPEC_TESTS_FILTER_FILE: 760Knapsack report generator started!761warning: parser/current is loading parser/ruby30, which recognizes 3.0.5-compliant syntax, but you are running 3.0.6.763Run options: exclude {:quarantine=>true, :zoekt=>true}764Test environment set up in 0.950704856 seconds765CreateNextCiPartitionsRecord766 # order random767 #up768 when on sass769main: == [advisory_lock_connection] object_id: 5184520, pg_backend_pid: 111770main: == 20221102090940 CreateNextCiPartitionsRecord: migrating =====================771main: -- execute("INSERT INTO \"ci_partitions\" (\"id\", \"created_at\", \"updated_at\")\n VALUES (101, now(), now())\n ON CONFLICT DO NOTHING;\n")772main: -> 0.0012s773main: -- reset_pk_sequence!("ci_partitions")774main: -> 0.0048s775main: -> 101 rows776main: == 20221102090940 CreateNextCiPartitionsRecord: migrated (0.0065s) ============777main: == [advisory_lock_connection] object_id: 5184520, pg_backend_pid: 111778 creates next partitions record and resets the sequence779 when self-managed780main: == [advisory_lock_connection] object_id: 6044580, pg_backend_pid: 113781main: == 20221102090940 CreateNextCiPartitionsRecord: migrating =====================782main: == 20221102090940 CreateNextCiPartitionsRecord: migrated (0.0003s) ============783main: == [advisory_lock_connection] object_id: 6044580, pg_backend_pid: 113784 does not create records785 #down786 when on sass787main: == [advisory_lock_connection] object_id: 6165120, pg_backend_pid: 115788main: == 20221102090940 CreateNextCiPartitionsRecord: migrating =====================789main: -- execute("INSERT INTO \"ci_partitions\" (\"id\", \"created_at\", \"updated_at\")\n VALUES (101, now(), now())\n ON CONFLICT DO NOTHING;\n")790main: -> 0.0013s791main: -- reset_pk_sequence!("ci_partitions")792main: -> 0.0042s793main: -> 101 rows794main: == 20221102090940 CreateNextCiPartitionsRecord: migrated (0.0058s) ============795main: == [advisory_lock_connection] object_id: 6165120, pg_backend_pid: 115796main: -- execute("DELETE FROM \"ci_partitions\"\n WHERE \"ci_partitions\".\"id\" = 101;\n")797main: -> 0.0011s798 removes the record799 when self-managed800main: == [advisory_lock_connection] object_id: 6286140, pg_backend_pid: 117801main: == 20221102090940 CreateNextCiPartitionsRecord: migrating =====================802main: -- execute("INSERT INTO \"ci_partitions\" (\"id\", \"created_at\", \"updated_at\")\n VALUES (101, now(), now())\n ON CONFLICT DO NOTHING;\n")803main: -> 0.0012s804main: -- reset_pk_sequence!("ci_partitions")805main: -> 0.0043s806main: -> 101 rows807main: == 20221102090940 CreateNextCiPartitionsRecord: migrated (0.0060s) ============808main: == [advisory_lock_connection] object_id: 6286140, pg_backend_pid: 117809 does not remove the record810FixPartitionIdsForCiStage811 # order random812 when on saas813 #up814main: == [advisory_lock_connection] object_id: 17844880, pg_backend_pid: 124815main: == 20230208132608 FixPartitionIdsForCiStage: migrating ========================816main: == 20230208132608 FixPartitionIdsForCiStage: migrated (0.0502s) ===============817main: == [advisory_lock_connection] object_id: 17844880, pg_backend_pid: 124818 schedules background jobs for each batch of ci_stages819 #down820main: == [advisory_lock_connection] object_id: 18455420, pg_backend_pid: 126821main: == 20230208132608 FixPartitionIdsForCiStage: migrating ========================822main: == 20230208132608 FixPartitionIdsForCiStage: migrated (0.0437s) ===============823main: == [advisory_lock_connection] object_id: 18455420, pg_backend_pid: 126824 deletes all batched migration records825 when on self-managed instance826 #up827 does not schedule background job828 #down829 does not delete background job830FinalizeBackfillUserDetailsFields831 # order random832 #up833 when migration is missing834main: == [advisory_lock_connection] object_id: 28707280, pg_backend_pid: 136835main: == 20221102231130 FinalizeBackfillUserDetailsFields: migrating ================836main: -- column_exists?(:users, :linkedin)837main: -> 0.0056s838main: == 20221102231130 FinalizeBackfillUserDetailsFields: migrated (0.0129s) =======839main: == [advisory_lock_connection] object_id: 28707280, pg_backend_pid: 136840 warns migration not found841 with migration present842 when migration finished successfully843main: == [advisory_lock_connection] object_id: 29644360, pg_backend_pid: 138844main: == 20221102231130 FinalizeBackfillUserDetailsFields: migrating ================845main: -- column_exists?(:users, :linkedin)846main: -> 0.0054s847main: == 20221102231130 FinalizeBackfillUserDetailsFields: migrated (0.0224s) =======848main: == [advisory_lock_connection] object_id: 29644360, pg_backend_pid: 138849 does not raise exception850 when users.linkedin column has already been dropped851main: == [advisory_lock_connection] object_id: 29797940, pg_backend_pid: 140852main: == 20221102231130 FinalizeBackfillUserDetailsFields: migrating ================853main: -- column_exists?(:users, :linkedin)854main: -> 0.0054s855main: == 20221102231130 FinalizeBackfillUserDetailsFields: migrated (0.0057s) =======856main: == [advisory_lock_connection] object_id: 29797940, pg_backend_pid: 140857 does not raise exception858 with different migration statuses859 status: 0, description: "paused"860 behaves like finalizes the migration861main: == [advisory_lock_connection] object_id: 29931060, pg_backend_pid: 142862main: == 20221102231130 FinalizeBackfillUserDetailsFields: migrating ================863main: -- column_exists?(:users, :linkedin)864main: -> 0.0057s865main: == 20221102231130 FinalizeBackfillUserDetailsFields: migrated (0.1710s) =======866main: == [advisory_lock_connection] object_id: 29931060, pg_backend_pid: 142867 finalizes the migration868 status: 1, description: "active"869 behaves like finalizes the migration870main: == [advisory_lock_connection] object_id: 30116940, pg_backend_pid: 144871main: == 20221102231130 FinalizeBackfillUserDetailsFields: migrating ================872main: -- column_exists?(:users, :linkedin)873main: -> 0.0054s874main: == 20221102231130 FinalizeBackfillUserDetailsFields: migrated (0.1623s) =======875main: == [advisory_lock_connection] object_id: 30116940, pg_backend_pid: 144876 finalizes the migration877 status: 4, description: "failed"878 behaves like finalizes the migration879main: == [advisory_lock_connection] object_id: 30354560, pg_backend_pid: 146880main: == 20221102231130 FinalizeBackfillUserDetailsFields: migrating ================881main: -- column_exists?(:users, :linkedin)882main: -> 0.0058s883main: == 20221102231130 FinalizeBackfillUserDetailsFields: migrated (0.1664s) =======884main: == [advisory_lock_connection] object_id: 30354560, pg_backend_pid: 146885 finalizes the migration886 status: 5, description: "finalizing"887 behaves like finalizes the migration888main: == [advisory_lock_connection] object_id: 30592240, pg_backend_pid: 148889main: == 20221102231130 FinalizeBackfillUserDetailsFields: migrating ================890main: -- column_exists?(:users, :linkedin)891main: -> 0.0055s892main: == 20221102231130 FinalizeBackfillUserDetailsFields: migrated (0.1565s) =======893main: == [advisory_lock_connection] object_id: 30592240, pg_backend_pid: 148894 finalizes the migration895SetEmailConfirmationSettingBeforeRemovingSendUserConfirmationEmailColumn896 # order random897 #up898 when 'send_user_confirmation_email' is set to 'true'899 updates 'email_confirmation_setting' to '2' (hard)900 when 'send_user_confirmation_email' is set to 'false'901 updates 'email_confirmation_setting' to '0' (off)902 #down903 updates 'email_confirmation_setting' to default value: '0' (off)904ScheduleDisableLegacyOpenSourceLicenseForProjectsLessThanFiveMb905 # order random906 when on gitlab.com907 #up908 schedules background jobs for each batch of project_settings909 #down910 deletes all batched migration records911 when on self-managed instance912 #up913 does not schedule background job914 #down915 does not delete background job916FixUpdateImportSourcesOnApplicationSettings917 # order random918 #up919 when import_sources is a String920 behaves like fixes import_sources on application_settings921main: == [advisory_lock_connection] object_id: 72335280, pg_backend_pid: 172922main: == 20221209110935 FixUpdateImportSourcesOnApplicationSettings: migrating ======923main: == 20221209110935 FixUpdateImportSourcesOnApplicationSettings: migrated (0.2420s) 924main: == [advisory_lock_connection] object_id: 72335280, pg_backend_pid: 172925 ensures YAML is stored926 when import_sources is already YAML927 behaves like fixes import_sources on application_settings928main: == [advisory_lock_connection] object_id: 72890800, pg_backend_pid: 174929main: == 20221209110935 FixUpdateImportSourcesOnApplicationSettings: migrating ======930main: == 20221209110935 FixUpdateImportSourcesOnApplicationSettings: migrated (0.2306s) 931main: == [advisory_lock_connection] object_id: 72890800, pg_backend_pid: 174932 ensures YAML is stored933BackfillProjectStatisticsStorageSizeWithoutUploadsSize934 # order random935main: == [advisory_lock_connection] object_id: 85061400, pg_backend_pid: 181936main: == 20221104115712 BackfillProjectStatisticsStorageSizeWithoutUploadsSize: migrating 937main: == 20221104115712 BackfillProjectStatisticsStorageSizeWithoutUploadsSize: migrated (0.0003s) 938main: == [advisory_lock_connection] object_id: 85061400, pg_backend_pid: 181939 does not schedule background jobs when Gitlab.org_or_com? is false940main: == [advisory_lock_connection] object_id: 85899780, pg_backend_pid: 184941main: == 20221104115712 BackfillProjectStatisticsStorageSizeWithoutUploadsSize: migrating 942main: == 20221104115712 BackfillProjectStatisticsStorageSizeWithoutUploadsSize: migrated (0.0436s) 943main: == [advisory_lock_connection] object_id: 85899780, pg_backend_pid: 184944 schedules background jobs for each batch of project_statistics945ScheduleMigrationForRemediation946 # order random947 #down948main: == [advisory_lock_connection] object_id: 97930240, pg_backend_pid: 192949main: == 20230118144623 ScheduleMigrationForRemediation: migrating ==================950main: == 20230118144623 ScheduleMigrationForRemediation: migrated (0.0077s) =========951main: == [advisory_lock_connection] object_id: 97930240, pg_backend_pid: 192952 deletes all batched migration records953 #up954main: == [advisory_lock_connection] object_id: 98387020, pg_backend_pid: 195955main: == 20230118144623 ScheduleMigrationForRemediation: migrating ==================956main: == 20230118144623 ScheduleMigrationForRemediation: migrated (0.0067s) =========957main: == [advisory_lock_connection] object_id: 98387020, pg_backend_pid: 195958 schedules a batched background migration959ScheduleBackfillEnvironmentTier960 # order random961main: == [advisory_lock_connection] object_id: 109075900, pg_backend_pid: 202962main: == 20221205151917 ScheduleBackfillEnvironmentTier: migrating ==================963main: == 20221205151917 ScheduleBackfillEnvironmentTier: migrated (0.0408s) =========964main: == [advisory_lock_connection] object_id: 109075900, pg_backend_pid: 202965 schedules a new batched migration966UpdateImportSourcesOnApplicationSettings967 # order random968 #up969main: == [advisory_lock_connection] object_id: 121599820, pg_backend_pid: 210970main: == 20221209110934 UpdateImportSourcesOnApplicationSettings: migrating =========971main: == 20221209110934 UpdateImportSourcesOnApplicationSettings: migrated (0.2468s) 972main: == [advisory_lock_connection] object_id: 121599820, pg_backend_pid: 210973 removes google_code and preserves existing valid import sources974The application_settings (main) table has 1231 columns.975Recreating the database976Dropped database 'gitlabhq_test'977Created database 'gitlabhq_test'978main: == [advisory_lock_connection] object_id: 122123480, pg_backend_pid: 216979main: == [advisory_lock_connection] object_id: 122123480, pg_backend_pid: 216980Databases re-creation done in 5.0005527759999495981FinalizeBackFillPreparedAtMergeRequests982 # order random983 #up984 when prepared at backfilling migration is missing985main: == [advisory_lock_connection] object_id: 122415420, pg_backend_pid: 220986main: == 20230515153600 FinalizeBackFillPreparedAtMergeRequests: migrating ==========987main: == 20230515153600 FinalizeBackFillPreparedAtMergeRequests: migrated (0.0123s) =988main: == [advisory_lock_connection] object_id: 122415420, pg_backend_pid: 220989 warns migration not found990 with backfilling migration present991 when prepared at backfilling migration finished successfully992main: == [advisory_lock_connection] object_id: 123120120, pg_backend_pid: 222993main: == 20230515153600 FinalizeBackFillPreparedAtMergeRequests: migrating ==========994main: == 20230515153600 FinalizeBackFillPreparedAtMergeRequests: migrated (0.0240s) =995main: == [advisory_lock_connection] object_id: 123120120, pg_backend_pid: 222996 does not raise exception997 when prepared at backfilling migration is paused998 status: 0, description: "paused"999 behaves like finalizes the migration1000 finalizes the migration1001 status: 1, description: "active"1002 behaves like finalizes the migration1003 finalizes the migration1004 status: 4, description: "failed"1005 behaves like finalizes the migration1006 finalizes the migration1007 status: 5, description: "finalizing"1008 behaves like finalizes the migration1009 finalizes the migration1010UpdateIssuesInternalIdScope1011 # order random1012 #up1013main: == [advisory_lock_connection] object_id: 127975960, pg_backend_pid: 2321014main: == 20230224085743 UpdateIssuesInternalIdScope: migrating ======================1015main: == 20230224085743 UpdateIssuesInternalIdScope: migrated (0.0471s) =============1016main: == [advisory_lock_connection] object_id: 127975960, pg_backend_pid: 2321017 schedules background migration1018 #down1019 does not schedule background migration1020EnsureVumBigintBackfillIsFinishedForGlDotCom1021 # order random1022 #up1023main: == [advisory_lock_connection] object_id: 134803620, pg_backend_pid: 2411024main: == 20230321011529 EnsureVumBigintBackfillIsFinishedForGlDotCom: migrating =====1025main: == 20230321011529 EnsureVumBigintBackfillIsFinishedForGlDotCom: migrated (0.0061s) 1026main: == [advisory_lock_connection] object_id: 134803620, pg_backend_pid: 2411027 ensures the migration is completed for GitLab.com, dev, or test1028main: == [advisory_lock_connection] object_id: 135413400, pg_backend_pid: 2431029main: == 20230321011529 EnsureVumBigintBackfillIsFinishedForGlDotCom: migrating =====1030main: == 20230321011529 EnsureVumBigintBackfillIsFinishedForGlDotCom: migrated (0.0055s) 1031main: == [advisory_lock_connection] object_id: 135413400, pg_backend_pid: 2431032 skips the check for other instances1033EnsureMergeRequestMetricsIdBigintBackfillIsFinishedForGitlabDotCom1034 # order random1035 #up1036main: == [advisory_lock_connection] object_id: 141169460, pg_backend_pid: 2491037main: == 20230313133001 EnsureMergeRequestMetricsIdBigintBackfillIsFinishedForGitlabDotCom: migrating 1038main: == 20230313133001 EnsureMergeRequestMetricsIdBigintBackfillIsFinishedForGitlabDotCom: migrated (0.0061s) 1039main: == [advisory_lock_connection] object_id: 141169460, pg_backend_pid: 2491040 ensures the migration is completed for GitLab.com, dev, or test1041main: == [advisory_lock_connection] object_id: 141736320, pg_backend_pid: 2511042main: == 20230313133001 EnsureMergeRequestMetricsIdBigintBackfillIsFinishedForGitlabDotCom: migrating 1043main: == 20230313133001 EnsureMergeRequestMetricsIdBigintBackfillIsFinishedForGitlabDotCom: migrated (0.0058s) 1044main: == [advisory_lock_connection] object_id: 141736320, pg_backend_pid: 2511045 skips the check for other instances1046EnsureNoteDiffFilesBigintBackfillIsFinishedForGitlabDotCom1047 # order random1048 #up1049main: == [advisory_lock_connection] object_id: 147382120, pg_backend_pid: 2571050main: == 20230322023442 EnsureNoteDiffFilesBigintBackfillIsFinishedForGitlabDotCom: migrating 1051main: == 20230322023442 EnsureNoteDiffFilesBigintBackfillIsFinishedForGitlabDotCom: migrated (0.0061s) 1052main: == [advisory_lock_connection] object_id: 147382120, pg_backend_pid: 2571053 ensures the migration is completed for GitLab.com, dev, or test1054main: == [advisory_lock_connection] object_id: 147883480, pg_backend_pid: 2591055main: == 20230322023442 EnsureNoteDiffFilesBigintBackfillIsFinishedForGitlabDotCom: migrating 1056main: == 20230322023442 EnsureNoteDiffFilesBigintBackfillIsFinishedForGitlabDotCom: migrated (0.0055s) 1057main: == [advisory_lock_connection] object_id: 147883480, pg_backend_pid: 2591058 skips the check for other instances1059DropPackagesEventsTable1060 # order random1061main: -- table_exists?(:packages_events)1062main: -> 0.0017s1063main: == [advisory_lock_connection] object_id: 153305980, pg_backend_pid: 2661064main: == 20230316185746 DropPackagesEventsTable: migrating ==========================1065main: -- drop_table(:packages_events, {:if_exists=>true})1066main: -> 0.0026s1067main: == 20230316185746 DropPackagesEventsTable: migrated (0.0101s) =================1068main: == [advisory_lock_connection] object_id: 153305980, pg_backend_pid: 2661069main: -- table_exists?(:packages_events)1070main: -> 0.0022s1071main: -- table_exists?(:packages_events)1072main: -> 0.0024s1073 drops and creates the packages_events table1074QueuePopulateVulnerabilityDismissalFields1075 # order random1076 #down1077main: == [advisory_lock_connection] object_id: 158684540, pg_backend_pid: 2731078main: == 20230412185837 QueuePopulateVulnerabilityDismissalFields: migrating ========1079main: == 20230412185837 QueuePopulateVulnerabilityDismissalFields: migrated (0.0473s) 1080main: == [advisory_lock_connection] object_id: 158684540, pg_backend_pid: 2731081 deletes all batched migration records1082 #up1083main: == [advisory_lock_connection] object_id: 159284220, pg_backend_pid: 2761084main: == 20230412185837 QueuePopulateVulnerabilityDismissalFields: migrating ========1085main: == 20230412185837 QueuePopulateVulnerabilityDismissalFields: migrated (0.0466s) 1086main: == [advisory_lock_connection] object_id: 159284220, pg_backend_pid: 2761087 schedules a new batched migration1088RerunRemoveInvalidDeployAccessLevel1089 # order random1090main: == [advisory_lock_connection] object_id: 163837520, pg_backend_pid: 2831091main: == 20230322151605 RerunRemoveInvalidDeployAccessLevel: migrating ==============1092main: -- exec_query("SELECT COUNT(*) AS count FROM \"protected_environment_deploy_access_levels\" WHERE (\"protected_environment_deploy_access_levels\".\"user_id\" IS NOT NULL OR \"protected_environment_deploy_access_levels\".\"group_id\" IS NOT NULL) AND \"protected_environment_deploy_access_levels\".\"access_level\" IS NOT NULL")1093main: -> 0.0015s1094main: -- exec_query("SELECT \"protected_environment_deploy_access_levels\".\"id\" FROM \"protected_environment_deploy_access_levels\" WHERE (\"protected_environment_deploy_access_levels\".\"user_id\" IS NOT NULL OR \"protected_environment_deploy_access_levels\".\"group_id\" IS NOT NULL) AND \"protected_environment_deploy_access_levels\".\"access_level\" IS NOT NULL ORDER BY \"protected_environment_deploy_access_levels\".\"id\" ASC LIMIT 1")1095main: -> 0.0012s1096main: -- exec_query("SELECT \"protected_environment_deploy_access_levels\".\"id\" FROM \"protected_environment_deploy_access_levels\" WHERE \"protected_environment_deploy_access_levels\".\"id\" >= 1 AND (\"protected_environment_deploy_access_levels\".\"user_id\" IS NOT NULL OR \"protected_environment_deploy_access_levels\".\"group_id\" IS NOT NULL) AND \"protected_environment_deploy_access_levels\".\"access_level\" IS NOT NULL ORDER BY \"protected_environment_deploy_access_levels\".\"id\" ASC LIMIT 1 OFFSET 1")1097main: -> 0.0014s1098main: -- transaction()1099main: -- execute("UPDATE \"protected_environment_deploy_access_levels\" SET \"access_level\" = NULL WHERE \"protected_environment_deploy_access_levels\".\"id\" >= 1 AND (\"protected_environment_deploy_access_levels\".\"user_id\" IS NOT NULL OR \"protected_environment_deploy_access_levels\".\"group_id\" IS NOT NULL) AND \"protected_environment_deploy_access_levels\".\"access_level\" IS NOT NULL")1100main: -> 0.0020s1101main: -> 0.0031s1102main: -- exec_query("SELECT COUNT(*) AS count FROM \"protected_environment_deploy_access_levels\" WHERE \"protected_environment_deploy_access_levels\".\"user_id\" IS NOT NULL AND \"protected_environment_deploy_access_levels\".\"group_id\" IS NOT NULL")1103main: -> 0.0012s1104main: -- exec_query("SELECT \"protected_environment_deploy_access_levels\".\"id\" FROM \"protected_environment_deploy_access_levels\" WHERE \"protected_environment_deploy_access_levels\".\"user_id\" IS NOT NULL AND \"protected_environment_deploy_access_levels\".\"group_id\" IS NOT NULL ORDER BY \"protected_environment_deploy_access_levels\".\"id\" ASC LIMIT 1")1105main: -> 0.0015s1106main: -- exec_query("SELECT \"protected_environment_deploy_access_levels\".\"id\" FROM \"protected_environment_deploy_access_levels\" WHERE \"protected_environment_deploy_access_levels\".\"id\" >= 1 AND \"protected_environment_deploy_access_levels\".\"user_id\" IS NOT NULL AND \"protected_environment_deploy_access_levels\".\"group_id\" IS NOT NULL ORDER BY \"protected_environment_deploy_access_levels\".\"id\" ASC LIMIT 1 OFFSET 1")1107main: -> 0.0012s1108main: -- transaction()1109main: -- execute("UPDATE \"protected_environment_deploy_access_levels\" SET \"group_id\" = NULL WHERE \"protected_environment_deploy_access_levels\".\"id\" >= 1 AND \"protected_environment_deploy_access_levels\".\"id\" < 5 AND \"protected_environment_deploy_access_levels\".\"user_id\" IS NOT NULL AND \"protected_environment_deploy_access_levels\".\"group_id\" IS NOT NULL")1110main: -> 0.0025s1111main: -> 0.0044s1112main: -- exec_query("SELECT \"protected_environment_deploy_access_levels\".\"id\" FROM \"protected_environment_deploy_access_levels\" WHERE \"protected_environment_deploy_access_levels\".\"id\" >= 5 AND \"protected_environment_deploy_access_levels\".\"user_id\" IS NOT NULL AND \"protected_environment_deploy_access_levels\".\"group_id\" IS NOT NULL ORDER BY \"protected_environment_deploy_access_levels\".\"id\" ASC LIMIT 1 OFFSET 1")1113main: -> 0.0018s1114main: -- transaction()1115main: -- execute("UPDATE \"protected_environment_deploy_access_levels\" SET \"group_id\" = NULL WHERE \"protected_environment_deploy_access_levels\".\"id\" >= 5 AND \"protected_environment_deploy_access_levels\".\"user_id\" IS NOT NULL AND \"protected_environment_deploy_access_levels\".\"group_id\" IS NOT NULL")1116main: -> 0.0023s1117main: -> 0.0034s1118main: == 20230322151605 RerunRemoveInvalidDeployAccessLevel: migrated (0.0305s) =====1119main: == [advisory_lock_connection] object_id: 163837520, pg_backend_pid: 2831120 fixes invalid access_level entries and does not affect others1121FixImportSourcesOnApplicationSettingsAfterPhabricatorRemoval1122 # order random1123 #up1124 when import_sources is a String1125 behaves like fixes import_sources on application_settings1126main: == [advisory_lock_connection] object_id: 168353180, pg_backend_pid: 2891127main: == 20230426102200 FixImportSourcesOnApplicationSettingsAfterPhabricatorRemoval: migrating 1128main: == 20230426102200 FixImportSourcesOnApplicationSettingsAfterPhabricatorRemoval: migrated (0.2784s) 1129main: == [advisory_lock_connection] object_id: 168353180, pg_backend_pid: 2891130 ensures YAML is stored1131 when import_sources is already YAML1132 behaves like fixes import_sources on application_settings1133main: == [advisory_lock_connection] object_id: 168818960, pg_backend_pid: 2911134main: == 20230426102200 FixImportSourcesOnApplicationSettingsAfterPhabricatorRemoval: migrating 1135main: == 20230426102200 FixImportSourcesOnApplicationSettingsAfterPhabricatorRemoval: migrated (0.2583s) 1136main: == [advisory_lock_connection] object_id: 168818960, pg_backend_pid: 2911137 ensures YAML is stored1138RemovePhabricatorFromApplicationSettings1139 # order random1140 #up1141main: == [advisory_lock_connection] object_id: 172101780, pg_backend_pid: 2971142main: == 20230419105225 RemovePhabricatorFromApplicationSettings: migrating =========1143main: == 20230419105225 RemovePhabricatorFromApplicationSettings: migrated (0.2705s) 1144main: == [advisory_lock_connection] object_id: 172101780, pg_backend_pid: 2971145 removes phabricator and preserves existing valid import sources1146CleanupBigintConversionForSentNotifications1147 # order random1148main: == [advisory_lock_connection] object_id: 175977420, pg_backend_pid: 3031149main: == 20230411153310 CleanupBigintConversionForSentNotifications: migrating ======1150main: -- remove_column(:sent_notifications, "id_convert_to_bigint")1151main: -> 0.0011s1152main: == 20230411153310 CleanupBigintConversionForSentNotifications: migrated (0.0087s) 1153main: == [advisory_lock_connection] object_id: 175977420, pg_backend_pid: 3031154 correctly migrates up and down1155Knapsack report was generated. Preview:1156{1157 "spec/migrations/20221102090940_create_next_ci_partitions_record_spec.rb": 29.94270750300001,1158 "spec/migrations/20230208132608_fix_partition_ids_for_ci_stage_spec.rb": 21.30286222000001,1159 "spec/migrations/20221102231130_finalize_backfill_user_details_fields_spec.rb": 30.988795470000014,1160 "spec/migrations/set_email_confirmation_setting_before_removing_send_user_confirmation_email_column_spec.rb": 27.52270066999995,1161 "spec/migrations/20221018095434_schedule_disable_legacy_open_source_license_for_projects_less_than_five_mb_spec.rb": 28.467676984000036,1162 "spec/migrations/20221209110935_fix_update_import_sources_on_application_settings_spec.rb": 26.225738589000002,1163 "spec/migrations/20221104115712_backfill_project_statistics_storage_size_without_uploads_size_spec.rb": 26.706867011999975,1164 "spec/migrations/20230118144623_schedule_migration_for_remediation_spec.rb": 22.961469220000026,1165 "spec/migrations/20221205151917_schedule_backfill_environment_tier_spec.rb": 24.532631930000093,1166 "spec/migrations/20221209110934_update_import_sources_on_application_settings_spec.rb": 25.704361365000068,1167 "spec/migrations/20230515153600_finalize_back_fill_prepared_at_merge_requests_spec.rb": 14.690373477000094,1168 "spec/migrations/20230224085743_update_issues_internal_id_scope_spec.rb": 17.638135397000042,1169 "spec/migrations/ensure_vum_bigint_backfill_is_finished_for_gl_dot_com_spec.rb": 15.91782642399994,1170 "spec/migrations/ensure_merge_request_metrics_id_bigint_backfill_is_finished_for_gitlab_dot_com_spec.rb": 16.338086853999926,1171 "spec/migrations/ensure_note_diff_files_bigint_backfill_is_finished_for_gitlab_dot_com_spec.rb": 15.365493964000052,1172 "spec/migrations/drop_packages_events_table_spec.rb": 15.844347190999997,1173 "spec/migrations/20230412185837_queue_populate_vulnerability_dismissal_fields_spec.rb": 14.683421615000043,1174 "spec/migrations/rerun_remove_invalid_deploy_access_level_spec.rb": 15.306123181999965,1175 "spec/migrations/20230426102200_fix_import_sources_on_application_settings_after_phabricator_removal_spec.rb": 15.04803964000007,1176 "spec/migrations/20230419105225_remove_phabricator_from_application_settings_spec.rb": 14.017604653999797,1177 "spec/migrations/20230411153310_cleanup_bigint_conversion_for_sent_notifications_spec.rb": 14.2851404929999721178}1179Knapsack global time execution for tests: 07m 13s1180Finished in 15 minutes 51 seconds (files took 40.66 seconds to load)118152 examples, 0 failures1182Randomized with seed 221421183[TEST PROF INFO] Time spent in factories: 00:00.267 (0.03% of total time)1184RSpec exited with 0.1185No examples to retry, congrats!1187Not uploading cache ruby-gems-debian-bullseye-ruby-3.0-16 due to policy1189Uploading artifacts...1190coverage/: found 5 matching artifact files and directories 1191crystalball/: found 2 matching artifact files and directories 1192WARNING: deprecations/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab) 1193knapsack/: found 4 matching artifact files and directories 1194WARNING: query_recorder/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab) 1195rspec/: found 16 matching artifact files and directories 1196WARNING: tmp/capybara/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab) 1197log/*.log: found 14 matching artifact files and directories 1198WARNING: Upload request redirected location=https://gitlab.com/api/v4/jobs/4400964149/artifacts?artifact_format=zip&artifact_type=archive&expire_in=31d new-url=https://gitlab.com1199WARNING: Retrying... context=artifacts-uploader error=request redirected1200Uploading artifacts as "archive" to coordinator... 201 Created id=4400964149 responseStatus=201 Created token=64_buqgi1201Uploading artifacts...1202rspec/rspec-*.xml: found 1 matching artifact files and directories 1203WARNING: Upload request redirected location=https://gitlab.com/api/v4/jobs/4400964149/artifacts?artifact_format=gzip&artifact_type=junit&expire_in=31d new-url=https://gitlab.com1204WARNING: Retrying... context=artifacts-uploader error=request redirected1205Uploading artifacts as "junit" to coordinator... 201 Created id=4400964149 responseStatus=201 Created token=64_buqgi1207Job succeeded