Skip to content
Snippets Groups Projects

rspec migration pg13 single-db-ci-connection 7/8

Passed Started by
🤖 GitLab Bot 🤖
@gitlab-bot
1Running with gitlab-runner 15.9.0~beta.212.g8ccc65e7 (8ccc65e7)
2 on green-2.private.runners-manager.gitlab.com/gitlab.com/gitlab-org GaSD-S1F, system ID: s_5651e5b5643b
3 feature flags: FF_NETWORK_PER_BUILD:true, FF_USE_FASTZIP:true, FF_USE_IMPROVED_URL_MASKING:true
4 Resolving secrets 00:00
5 Preparing the "docker+machine" executor 00:05
6Using Docker executor with image registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bullseye-ruby-3.0.patched-golang-1.18-rust-1.65-node-16.14-postgresql-13:rubygems-3.4-git-2.36-lfs-2.9-chrome-109-yarn-1.22-graphicsmagick-1.3.36 ...
7Starting service postgres:13 ...
8Pulling docker image postgres:13 ...
9Using docker image sha256:dd421ca1f7f13d81c5c145d77d97d8d84cd0e6f1e045936ee506ce0f50ee397a for postgres:13 with digest postgres@sha256:00f455399f30cc3f2fe4185476601438b7a4959c74653665582d7c313a783d51 ...
10Starting service redis:6.2-alpine ...
11Pulling docker image redis:6.2-alpine ...
12Using docker image sha256:3616f0c0705d2a35d30dde109daf3cbe58ae7284121aafa6f5cfa987db98d1a8 for redis:6.2-alpine with digest redis@sha256:edddbcad5a41d58df2f142d68439922f1860ea902903d016257337c3342f30fc ...
13Waiting for services to be up and running (timeout 30 seconds)...
14Authenticating with credentials from job payload (GitLab Registry)
15Pulling docker image registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bullseye-ruby-3.0.patched-golang-1.18-rust-1.65-node-16.14-postgresql-13:rubygems-3.4-git-2.36-lfs-2.9-chrome-109-yarn-1.22-graphicsmagick-1.3.36 ...
16Using docker image sha256:7a1b51158a1ee23b080b514ce6ebbf52ac51585877198fb52709e5cd01805a77 for registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bullseye-ruby-3.0.patched-golang-1.18-rust-1.65-node-16.14-postgresql-13:rubygems-3.4-git-2.36-lfs-2.9-chrome-109-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.18-rust-1.65-node-16.14-postgresql-13@sha256:412d55913d43377094427ced549cb422ed2f2c7223e6a605d0d3e0151cb892b0 ...
17 Preparing environment 00:01
18Running on runner-gasd-s1f-project-278964-concurrent-0 via runner-gasd-s1f-private-1680169457-44dea003...
19 Getting source from Git repository 00:30
20$ eval "$CI_PRE_CLONE_SCRIPT"
21Fetching changes with git depth set to 20...
22Initialized empty Git repository in /builds/gitlab-org/gitlab/.git/
23Created fresh repository.
24remote: Enumerating objects: 135903, done.
25remote: Counting objects: 100% (135903/135903), done.
26remote: Compressing objects: 100% (88560/88560), done.
27remote: Total 135903 (delta 58315), reused 94618 (delta 42152), pack-reused 0
28Receiving objects: 100% (135903/135903), 121.35 MiB | 30.69 MiB/s, done.
29Resolving deltas: 100% (58315/58315), done.
30From https://git-us-east1-d.ci-gateway.int.gprd.gitlab.net:8989/gitlab-org/gitlab
31 * [new ref] refs/pipelines/822866544 -> refs/pipelines/822866544
32Checking out 523abdde as detached HEAD (ref is refs/merge-requests/116270/merge)...
33Skipping Git submodules setup
34$ git remote set-url origin "${CI_REPOSITORY_URL}"
35 Restoring cache 00:12
36Checking cache for ruby-gems-debian-bullseye-ruby-3.0-16...
37cache.zip is up to date
38Successfully extracted cache
39Checking cache for gitaly-ruby-gems-debian-bullseye-ruby-3.0-16...
40cache.zip is up to date
41Successfully extracted cache
42 Downloading artifacts 00:21
43Downloading artifacts for compile-test-assets (4031138198)...
44Downloading artifacts from coordinator... ok host=storage.googleapis.com id=4031138198 responseStatus=200 OK token=64_5AJaT
45Downloading artifacts for detect-tests (4031138213)...
46Downloading artifacts from coordinator... ok host=storage.googleapis.com id=4031138213 responseStatus=200 OK token=64_5AJaT
47Downloading artifacts for retrieve-tests-metadata (4031138217)...
48Downloading artifacts from coordinator... ok host=storage.googleapis.com id=4031138217 responseStatus=200 OK token=64_5AJaT
49Downloading artifacts for setup-test-env (4031138204)...
50Downloading artifacts from coordinator... ok host=storage.googleapis.com id=4031138204 responseStatus=200 OK token=64_5AJaT
51 Executing "step_script" stage of the job script 25:16
52Using docker image sha256:7a1b51158a1ee23b080b514ce6ebbf52ac51585877198fb52709e5cd01805a77 for registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bullseye-ruby-3.0.patched-golang-1.18-rust-1.65-node-16.14-postgresql-13:rubygems-3.4-git-2.36-lfs-2.9-chrome-109-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.18-rust-1.65-node-16.14-postgresql-13@sha256:412d55913d43377094427ced549cb422ed2f2c7223e6a605d0d3e0151cb892b0 ...
53$ echo $FOSS_ONLY
54$ [ "$FOSS_ONLY" = "1" ] && rm -rf ee/ qa/spec/ee/ qa/qa/specs/features/ee/ qa/qa/ee/ qa/qa/ee.rb
55$ export GOPATH=$CI_PROJECT_DIR/.go
56$ mkdir -p $GOPATH
57$ source scripts/utils.sh
58$ source scripts/prepare_build.sh
59 Installing gems 00:11
709Using decomposed database config (config/database.yml.postgresql)
710Enabling ci connection (database_tasks: false) in config/database.yml
711Geo DB won't be set up.
712$ setup_db_user_only
713CREATE ROLE
714GRANT
715==> 'setup_db_user_only' succeeded in 0 seconds.
716$ bundle exec rake db:drop db:create db:schema:load db:migrate gitlab:db:lock_writes
717Dropped database 'gitlabhq_test'
718Created database 'gitlabhq_test'
719==> 'bundle exec rake db:drop db:create db:schema:load db:migrate gitlab:db:lock_writes' succeeded in 33 seconds.
720$ setup_db_praefect
721SELECT pg_catalog.set_config('search_path', '', false);
722CREATE DATABASE praefect_test ENCODING 'UTF8';
723==> 'setup_db_praefect' succeeded in 0 seconds.
724$ source ./scripts/rspec_helpers.sh
725$ run_timed_command "gem install knapsack --no-document"
726$ gem install knapsack --no-document
727Successfully installed knapsack-4.0.0
7281 gem installed
729==> 'gem install knapsack --no-document' succeeded in 1 seconds.
730$ echo -e "\e[0Ksection_start:`date +%s`:gitaly-test-spawn[collapsed=true]\r\e[0KStarting Gitaly"
731 Starting Gitaly 00:08
834$ rspec_paralellized_job "--tag ~quarantine --tag ~zoekt"
835SKIP_FLAKY_TESTS_AUTOMATICALLY: false
836RETRY_FAILED_TESTS_IN_NEW_PROCESS: true
837KNAPSACK_GENERATE_REPORT: true
838FLAKY_RSPEC_GENERATE_REPORT: true
839KNAPSACK_TEST_FILE_PATTERN: spec/{migrations}{,/**/}*_spec.rb
840KNAPSACK_LOG_LEVEL: debug
841KNAPSACK_REPORT_PATH: knapsack/rspec_migration_pg13_single-db-ci-connection_7_8_report.json
842FLAKY_RSPEC_SUITE_REPORT_PATH: rspec/flaky/report-suite.json
843FLAKY_RSPEC_REPORT_PATH: rspec/flaky/all_rspec_migration_pg13_single-db-ci-connection_7_8_report.json
844NEW_FLAKY_RSPEC_REPORT_PATH: rspec/flaky/new_rspec_migration_pg13_single-db-ci-connection_7_8_report.json
845SKIPPED_FLAKY_TESTS_REPORT_PATH: rspec/flaky/skipped_flaky_tests_rspec_migration_pg13_single-db-ci-connection_7_8_report.txt
846CRYSTALBALL:
847Knapsack report generator started!
848Run options: exclude {:quarantine=>true, :zoekt=>true}
849Test environment set up in 0.590474985 seconds
850ScheduleResetDuplicateCiRunnersTokenEncryptedValues
851 # order random
852 #down
853ci: == 20220922143634 ScheduleResetDuplicateCiRunnersTokenEncryptedValues: migrating
854ci: == 20220922143634 ScheduleResetDuplicateCiRunnersTokenEncryptedValues: migrated (0.0755s)
855 deletes all batched migration records
856 #up
857ci: == 20220922143634 ScheduleResetDuplicateCiRunnersTokenEncryptedValues: migrating
858ci: == 20220922143634 ScheduleResetDuplicateCiRunnersTokenEncryptedValues: migrated (0.0472s)
859 schedules background jobs for each batch of runners
860SyncNewAmountUsedForCiNamespaceMonthlyUsages
861 # order random
862ci: == 20221107184758 SyncNewAmountUsedForCiNamespaceMonthlyUsages: migrating =====
863ci: == 20221107184758 SyncNewAmountUsedForCiNamespaceMonthlyUsages: migrated (0.0130s)
864 updates `new_amount_used` with values from `amount_used`
865AddUpdateVulnerabilityReadsTrigger
866 #up
867 UPDATE trigger
868 when vulnerability attributes are updated
869main: == 20220106112043 AddUpdateVulnerabilityReadsTrigger: migrating ===============
870main: -- execute("CREATE OR REPLACE FUNCTION update_vulnerability_reads_from_vulnerability()\nRETURNS TRIGGER AS\n$$\nBEGIN\nUPDATE\n vulnerability_reads\nSET\n severity = NEW.severity,\n state = NEW.state,\n resolved_on_default_branch = NEW.resolved_on_default_branch\nWHERE vulnerability_id = NEW.id;\nRETURN NULL;\n\nEND\n$$ LANGUAGE PLPGSQL\n")
871main: -> 0.0021s
872main: -- execute("CREATE TRIGGER trigger_update_vulnerability_reads_on_vulnerability_update\nAFTER UPDATE ON vulnerabilities\nFOR EACH ROW\nWHEN (\n OLD.severity IS DISTINCT FROM NEW.severity OR\n OLD.state IS DISTINCT FROM NEW.state OR\n OLD.resolved_on_default_branch IS DISTINCT FROM NEW.resolved_on_default_branch\n)\nEXECUTE PROCEDURE update_vulnerability_reads_from_vulnerability();\n")
873main: -> 0.0015s
874main: == 20220106112043 AddUpdateVulnerabilityReadsTrigger: migrated (0.0040s) ======
875 updates vulnerability attributes in vulnerability_reads
876 when vulnerability attributes are not updated
877main: == 20220106112043 AddUpdateVulnerabilityReadsTrigger: migrating ===============
878main: -- execute("CREATE OR REPLACE FUNCTION update_vulnerability_reads_from_vulnerability()\nRETURNS TRIGGER AS\n$$\nBEGIN\nUPDATE\n vulnerability_reads\nSET\n severity = NEW.severity,\n state = NEW.state,\n resolved_on_default_branch = NEW.resolved_on_default_branch\nWHERE vulnerability_id = NEW.id;\nRETURN NULL;\n\nEND\n$$ LANGUAGE PLPGSQL\n")
879main: -> 0.0023s
880main: -- execute("CREATE TRIGGER trigger_update_vulnerability_reads_on_vulnerability_update\nAFTER UPDATE ON vulnerabilities\nFOR EACH ROW\nWHEN (\n OLD.severity IS DISTINCT FROM NEW.severity OR\n OLD.state IS DISTINCT FROM NEW.state OR\n OLD.resolved_on_default_branch IS DISTINCT FROM NEW.resolved_on_default_branch\n)\nEXECUTE PROCEDURE update_vulnerability_reads_from_vulnerability();\n")
881main: -> 0.0015s
882main: == 20220106112043 AddUpdateVulnerabilityReadsTrigger: migrated (0.0039s) ======
883 does not update vulnerability attributes in vulnerability_reads
884 #down
885main: -- execute("CREATE OR REPLACE FUNCTION update_vulnerability_reads_from_vulnerability()\nRETURNS TRIGGER AS\n$$\nBEGIN\nUPDATE\n vulnerability_reads\nSET\n severity = NEW.severity,\n state = NEW.state,\n resolved_on_default_branch = NEW.resolved_on_default_branch\nWHERE vulnerability_id = NEW.id;\nRETURN NULL;\n\nEND\n$$ LANGUAGE PLPGSQL\n")
886main: -> 0.0017s
887main: -- execute("CREATE TRIGGER trigger_update_vulnerability_reads_on_vulnerability_update\nAFTER UPDATE ON vulnerabilities\nFOR EACH ROW\nWHEN (\n OLD.severity IS DISTINCT FROM NEW.severity OR\n OLD.state IS DISTINCT FROM NEW.state OR\n OLD.resolved_on_default_branch IS DISTINCT FROM NEW.resolved_on_default_branch\n)\nEXECUTE PROCEDURE update_vulnerability_reads_from_vulnerability();\n")
888main: -> 0.0016s
889main: -- execute("DROP TRIGGER IF EXISTS trigger_update_vulnerability_reads_on_vulnerability_update ON vulnerabilities")
890main: -> 0.0012s
891main: -- execute("DROP FUNCTION IF EXISTS update_vulnerability_reads_from_vulnerability()")
892main: -> 0.0010s
893 drops the trigger
894AdjustTaskNoteRenameBackgroundMigrationValues
895 # order random
896 #up
897 when migration was already finished
898main: == 20221006172302 AdjustTaskNoteRenameBackgroundMigrationValues: migrating ====
899main: == 20221006172302 AdjustTaskNoteRenameBackgroundMigrationValues: migrated (0.0153s)
900 does not update batch sizes
901 when the migration had failing batches
902 when migration had a failed status
903main: == 20221006172302 AdjustTaskNoteRenameBackgroundMigrationValues: migrating ====
904main: == 20221006172302 AdjustTaskNoteRenameBackgroundMigrationValues: migrated (0.0368s)
905 updates started_at timestamp
906 behaves like task note migration with failing batches
907main: == 20221006172302 AdjustTaskNoteRenameBackgroundMigrationValues: migrating ====
908main: == 20221006172302 AdjustTaskNoteRenameBackgroundMigrationValues: migrated (0.0326s)
909 updates batch sizes and resets failed batches
910 when migration had an active status
911main: == 20221006172302 AdjustTaskNoteRenameBackgroundMigrationValues: migrating ====
912main: == 20221006172302 AdjustTaskNoteRenameBackgroundMigrationValues: migrated (0.0238s)
913 does not update started_at timestamp
914 behaves like task note migration with failing batches
915main: == 20221006172302 AdjustTaskNoteRenameBackgroundMigrationValues: migrating ====
916main: == 20221006172302 AdjustTaskNoteRenameBackgroundMigrationValues: migrated (0.0319s)
917 updates batch sizes and resets failed batches
918 #down
919main: == 20221006172302 AdjustTaskNoteRenameBackgroundMigrationValues: migrating ====
920main: == 20221006172302 AdjustTaskNoteRenameBackgroundMigrationValues: migrated (0.0135s)
921 reverts to old batch sizes
922BackfillNamespaceIdForNamespaceRoutes
923 #up
924main: == 20220120123800 BackfillNamespaceIdForNamespaceRoutes: migrating ============
925main: == 20220120123800 BackfillNamespaceIdForNamespaceRoutes: migrated (0.0463s) ===
926 schedules background jobs for each batch of routes
927 #down
928main: == 20220120123800 BackfillNamespaceIdForNamespaceRoutes: migrating ============
929main: == 20220120123800 BackfillNamespaceIdForNamespaceRoutes: migrated (0.0432s) ===
930 deletes all batched migration records
931PopulateVulnerabilityReads
932main: == 20220107064845 PopulateVulnerabilityReads: migrating =======================
933main: -- Scheduled 5 PopulateVulnerabilityReads jobs with a maximum of 1 records per batch and an interval of 120 seconds.
934The migration is expected to take at least 600 seconds. Expect all jobs to have completed after 2023-03-30 11:54:37 UTC."
935main: == 20220107064845 PopulateVulnerabilityReads: migrated (0.0663s) ==============
936 schedules background migrations
937CleanupOrphanedRoutes
938 #up
939main: == 20220524080944 CleanupOrphanedRoutes: migrating ============================
940main: == 20220524080944 CleanupOrphanedRoutes: migrated (0.0491s) ===================
941 schedules background jobs
942 #down
943main: == 20220524080944 CleanupOrphanedRoutes: migrating ============================
944main: == 20220524080944 CleanupOrphanedRoutes: migrated (0.0413s) ===================
945 deletes all batched migration records
946CleanupDraftDataFromFaultyRegex
947 #up
948main: == 20220315171129 CleanupDraftDataFromFaultyRegex: migrating ==================
949main: -- Scheduled 1 CleanupDraftDataFromFaultyRegex jobs with a maximum of 2 records per batch and an interval of 300 seconds.
950The migration is expected to take at least 300 seconds. Expect all jobs to have completed after 2023-03-30 11:51:41 UTC."
951main: == 20220315171129 CleanupDraftDataFromFaultyRegex: migrated (0.0459s) =========
952 schedules CleanupDraftDataFromFaultyRegex background jobs filtering for eligble MRs
953DeleteServiceTemplateRecords
954main: == 20220202105733 DeleteServiceTemplateRecords: migrating =====================
955main: == 20220202105733 DeleteServiceTemplateRecords: migrated (0.0059s) ============
956 deletes template records and associated data
957main: == 20220202105733 DeleteServiceTemplateRecords: migrating =====================
958main: == 20220202105733 DeleteServiceTemplateRecords: migrated (0.0047s) ============
959 does not delete non template records
960BackfillNamespaceIdForProjectRoutes
961 #up
962main: == 20220323023800 BackfillNamespaceIdForProjectRoutes: migrating ==============
963main: == 20220323023800 BackfillNamespaceIdForProjectRoutes: migrated (0.0430s) =====
964 schedules background jobs for each batch of group members
965 #down
966main: == 20220323023800 BackfillNamespaceIdForProjectRoutes: migrating ==============
967main: == 20220323023800 BackfillNamespaceIdForProjectRoutes: migrated (0.0425s) =====
968 deletes all batched migration records
969The application_settings (main) table has 1283 columns.
970Recreating the database
971Dropped database 'gitlabhq_test'
972Created database 'gitlabhq_test'
973Databases re-creation done in 5.326151104999553
974FinalizeInvalidMemberCleanup
975 # order random
976 #up
977 when migration is missing
978main: == 20221006070927 FinalizeInvalidMemberCleanup: migrating =====================
979main: == 20221006070927 FinalizeInvalidMemberCleanup: migrated (0.0080s) ============
980 warns migration not found
981 with migration present
982 when migration finished successfully
983main: == 20221006070927 FinalizeInvalidMemberCleanup: migrating =====================
984main: == 20221006070927 FinalizeInvalidMemberCleanup: migrated (0.0177s) ============
985 does not raise exception
986 with different migration statuses
987 status: 0, description: "paused"
988 behaves like finalizes the migration
989 finalizes the migration
990 status: 1, description: "active"
991 behaves like finalizes the migration
992 finalizes the migration
993 status: 4, description: "failed"
994 behaves like finalizes the migration
995 finalizes the migration
996 status: 5, description: "finalizing"
997 behaves like finalizes the migration
998 finalizes the migration
999RemoveDanglingRunningBuilds
1000main: == 20220128155251 RemoveDanglingRunningBuilds: migrating ======================
1001main: -- execute("DELETE FROM ci_running_builds\n USING ci_builds\n WHERE ci_builds.id = ci_running_builds.build_id\n AND ci_builds.status = 'failed'\n AND ci_builds.type = 'Ci::Build'\n AND ci_running_builds.id BETWEEN 1 AND 2\n")
1002main: -> 0.0019s
1003main: == 20220128155251 RemoveDanglingRunningBuilds: migrated (0.0112s) =============
1004 removes failed builds
1005ScheduleMigratePersonalNamespaceProjectMaintainerToOwner
1006 #up
1007main: == 20220208080921 ScheduleMigratePersonalNamespaceProjectMaintainerToOwner: migrating
1008main: == 20220208080921 ScheduleMigratePersonalNamespaceProjectMaintainerToOwner: migrated (0.0450s)
1009 schedules background jobs for each batch of members
1010DeleteMigrateSharedVulnerabilityScanners
1011 # order random
1012 #up
1013main: == 20220919080303 DeleteMigrateSharedVulnerabilityScanners: migrating =========
1014main: == 20220919080303 DeleteMigrateSharedVulnerabilityScanners: migrated (0.0379s)
1015 deletes jobs
1016main: == 20220919080303 DeleteMigrateSharedVulnerabilityScanners: migrating =========
1017main: == 20220919080303 DeleteMigrateSharedVulnerabilityScanners: migrated (0.0230s)
1018 deletes the migration
1019 when background migration does not exist
1020main: == 20220919080303 DeleteMigrateSharedVulnerabilityScanners: migrating =========
1021main: == 20220919080303 DeleteMigrateSharedVulnerabilityScanners: migrated (0.0030s)
1022 does not delete jobs
1023main: == 20220919080303 DeleteMigrateSharedVulnerabilityScanners: migrating =========
1024main: == 20220919080303 DeleteMigrateSharedVulnerabilityScanners: migrated (0.0029s)
1025 does not delete the migration
1026UpdateLastRunDateForIterationsCadences
1027main: == 20220620132300 UpdateLastRunDateForIterationsCadences: migrating ===========
1028main: -- execute("UPDATE iterations_cadences SET last_run_date=CURRENT_DATE WHERE automatic=true;\n")
1029main: -> 0.0029s
1030main: == 20220620132300 UpdateLastRunDateForIterationsCadences: migrated (0.0031s) ==
1031 sets last_run_date to CURRENT_DATE for iterations cadences with automatic=true
1032ToggleVsaAggregationsEnable
1033main: == 20220405092619 ToggleVsaAggregationsEnable: migrating ======================
1034main: == 20220405092619 ToggleVsaAggregationsEnable: migrated (0.0194s) =============
1035 makes all aggregations enabled
1036ScheduleBackfillDraftStatusOnMergeRequestsCorrectedRegex
1037main: == 20220420214703 ScheduleBackfillDraftStatusOnMergeRequestsCorrectedRegex: migrating
1038main: -- view_exists?(:postgres_partitions)
1039main: -> 0.0021s
1040main: -- index_exists?(:merge_requests, :id, {:where=>"draft = false AND state_id = 1 AND ((title)::text ~* '^(\\[draft\\]|\\(draft\\)|draft:|draft|\\[WIP\\]|WIP:|WIP)'::text)", :name=>"tmp_index_merge_requests_draft_and_status", :algorithm=>:concurrently})
1041main: -> 0.0381s
1042main: -- add_index(:merge_requests, :id, {:where=>"draft = false AND state_id = 1 AND ((title)::text ~* '^(\\[draft\\]|\\(draft\\)|draft:|draft|\\[WIP\\]|WIP:|WIP)'::text)", :name=>"tmp_index_merge_requests_draft_and_status", :algorithm=>:concurrently})
1043main: -> 0.0026s
1044main: -- Scheduled 7 BackfillDraftStatusOnMergeRequestsWithCorrectedRegex jobs with a maximum of 1 records per batch and an interval of 120 seconds.
1045The migration is expected to take at least 840 seconds. Expect all jobs to have completed after 2023-03-30 12:08:57 UTC."
1046main: == 20220420214703 ScheduleBackfillDraftStatusOnMergeRequestsCorrectedRegex: migrated (0.1448s)
1047 schedules BackfillDraftStatusOnMergeRequests background jobs
1048ChangeTaskSystemNoteWordingToChecklistItem
1049 # order random
1050 #down
1051main: == 20220809223215 ChangeTaskSystemNoteWordingToChecklistItem: migrating =======
1052main: == 20220809223215 ChangeTaskSystemNoteWordingToChecklistItem: migrated (0.0500s)
1053 deletes all batched migration records
1054 #up
1055main: == 20220809223215 ChangeTaskSystemNoteWordingToChecklistItem: migrating =======
1056main: == 20220809223215 ChangeTaskSystemNoteWordingToChecklistItem: migrated (0.0430s)
1057 schedules a batched background migration
1058SetEmailConfirmationSettingFromSendUserConfirmationEmailSetting
1059 # order random
1060 #up
1061 when 'send_user_confirmation_email' is set to 'true'
1062 updates 'email_confirmation_setting' to '2' (hard)
1063 when 'send_user_confirmation_email' is set to 'false'
1064 updates 'email_confirmation_setting' to '0' (off)
1065 #down
1066 updates 'email_confirmation_setting' to default value: '0' (off)
1067RescheduleIssueWorkItemTypeIdBackfill
1068 # order random
1069 #up
1070main: == 20220830172142 RescheduleIssueWorkItemTypeIdBackfill: migrating ============
1071main: == 20220830172142 RescheduleIssueWorkItemTypeIdBackfill: migrated (0.2702s) ===
1072 correctly schedules background migrations
1073 #down
1074main: == 20220830172142 RescheduleIssueWorkItemTypeIdBackfill: migrating ============
1075main: == 20220830172142 RescheduleIssueWorkItemTypeIdBackfill: migrated (0.2132s) ===
1076 deletes all batched migration records
1077PopulateReleasesAccessLevelFromRepository
1078 # order random
1079 #up
1080 when releases_access_level is greater than repository_access_level
1081main: == 20221014034338 PopulateReleasesAccessLevelFromRepository: migrating ========
1082main: -- exec_query("SELECT COUNT(*) AS count FROM \"project_features\" WHERE \"project_features\".\"releases_access_level\" > \"project_features\".\"repository_access_level\"")
1083main: -> 0.0015s
1084main: -- exec_query("SELECT \"project_features\".\"id\" FROM \"project_features\" WHERE \"project_features\".\"releases_access_level\" > \"project_features\".\"repository_access_level\" ORDER BY \"project_features\".\"id\" ASC LIMIT 1")
1085main: -> 0.0016s
1086main: -- exec_query("SELECT \"project_features\".\"id\" FROM \"project_features\" WHERE \"project_features\".\"id\" >= 1 AND \"project_features\".\"releases_access_level\" > \"project_features\".\"repository_access_level\" ORDER BY \"project_features\".\"id\" ASC LIMIT 1 OFFSET 1")
1087main: -> 0.0016s
1088main: -- transaction()
1089main: -- execute("UPDATE \"project_features\" SET \"releases_access_level\" = repository_access_level WHERE \"project_features\".\"id\" >= 1 AND \"project_features\".\"releases_access_level\" > \"project_features\".\"repository_access_level\"")
1090main: -> 0.0023s
1091main: -> 0.0034s
1092main: == 20221014034338 PopulateReleasesAccessLevelFromRepository: migrated (0.0099s)
1093 reduces releases_access_level to match repository_access_level
1094 when releases_access_level is less than repository_access_level
1095main: == 20221014034338 PopulateReleasesAccessLevelFromRepository: migrating ========
1096main: -- exec_query("SELECT COUNT(*) AS count FROM \"project_features\" WHERE \"project_features\".\"releases_access_level\" > \"project_features\".\"repository_access_level\"")
1097main: -> 0.0014s
1098main: == 20221014034338 PopulateReleasesAccessLevelFromRepository: migrated (0.0022s)
1099 does not change releases_access_level
1100The application_settings (main) table has 1203 columns.
1101Recreating the database
1102Dropped database 'gitlabhq_test'
1103Created database 'gitlabhq_test'
1104Databases re-creation done in 5.378706064000653
1105UpdateNotesInPast
1106main: == 20220715163254 UpdateNotesInPast: migrating ================================
1107main: == 20220715163254 UpdateNotesInPast: migrated (0.0117s) =======================
1108 updates created_at when it is too much in the past
1109ScheduleDestroyInvalidMembers
1110 # order random
1111 #down
1112main: == 20221004094814 ScheduleDestroyInvalidMembers: migrating ====================
1113main: == 20221004094814 ScheduleDestroyInvalidMembers: migrated (0.0441s) ===========
1114 deletes all batched migration records
1115 #up
1116main: == 20221004094814 ScheduleDestroyInvalidMembers: migrating ====================
1117main: == 20221004094814 ScheduleDestroyInvalidMembers: migrated (0.0405s) ===========
1118 schedules background jobs for each batch of members
1119SecondRecountEpicCacheCounts
1120 # order random
1121 #up
1122main: == 20221214095129 SecondRecountEpicCacheCounts: migrating =====================
1123main: == 20221214095129 SecondRecountEpicCacheCounts: migrated (0.0597s) ============
1124 schedules a batched background migration
1125 #down
1126main: == 20221214095129 SecondRecountEpicCacheCounts: migrating =====================
1127main: == 20221214095129 SecondRecountEpicCacheCounts: migrated (0.0522s) ============
1128 deletes all batched migration records
1129CreateRoutingTableForBuildsMetadataV2
1130 # order random
1131 #up
1132 when the table is already partitioned
1133main: -- execute("CREATE TABLE IF NOT EXISTS \"p_ci_builds_metadata\" (\n LIKE \"ci_builds_metadata\" INCLUDING ALL\n) PARTITION BY LIST(\"partition_id\")\n")
1134main: -> 0.0031s
1135main: -- foreign_keys(:ci_builds_metadata)
1136main: -> 0.0041s
1137main: -- foreign_keys(:p_ci_builds_metadata)
1138main: -> 0.0036s
1139main: -- add_foreign_key(:p_ci_builds_metadata, "ci_builds", {:column=>"build_id", :name=>"fk_e20479742e", :primary_key=>"id", :on_delete=>:cascade, :on_update=>nil, :validate=>true})
1140main: -> 0.0014s
1141main: -- current_schema()
1142main: -> 0.0007s
1143main: -- execute(";\n\nALTER 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")
1144main: -> 0.0034s
1145main: == 20221021145820 CreateRoutingTableForBuildsMetadataV2: migrating ============
1146main: == 20221021145820 CreateRoutingTableForBuildsMetadataV2: migrated (0.0035s) ===
1147 skips the migration
1148SchedulePruneStaleProjectExportJobs
1149 # order random
1150main: == 20221122132812 SchedulePruneStaleProjectExportJobs: migrating ==============
1151main: == 20221122132812 SchedulePruneStaleProjectExportJobs: migrated (0.0836s) =====
1152 schedules a new batched migration
1153NullifyCreatorIdOfOrphanedProjects
1154 # order random
1155 #down
1156main: == 20230130073109 NullifyCreatorIdOfOrphanedProjects: migrating ===============
1157main: == 20230130073109 NullifyCreatorIdOfOrphanedProjects: migrated (0.0601s) ======
1158 removes scheduled background migrations
1159 #up
1160main: == 20230130073109 NullifyCreatorIdOfOrphanedProjects: migrating ===============
1161main: == 20230130073109 NullifyCreatorIdOfOrphanedProjects: migrated (0.0570s) ======
1162 schedules background migration
1163ScheduleMigrationForLinks
1164 # order random
1165 #up
1166main: == 20230208125736 ScheduleMigrationForLinks: migrating ========================
1167main: == 20230208125736 ScheduleMigrationForLinks: migrated (0.0562s) ===============
1168 schedules a batched background migration
1169 #down
1170main: == 20230208125736 ScheduleMigrationForLinks: migrating ========================
1171main: == 20230208125736 ScheduleMigrationForLinks: migrated (0.0472s) ===============
1172 deletes all batched migration records
1173QueueBackfillPreparedAtData
1174 # order random
1175main: == 20230202135758 QueueBackfillPreparedAtData: migrating ======================
1176main: == 20230202135758 QueueBackfillPreparedAtData: migrated (0.0627s) =============
1177 schedules a new batched migration
1178SwapMergeRequestMetricsIdToBigintForGitlabDotCom
1179 # order random
1180 #up
1181 swaps the integer and bigint columns for GitLab.com, dev, or test
1182 is a no-op for other instances
1183RemoveUserNamespaceRecordsFromVsaAggregation
1184 # order random
1185 #up
1186main: == 20230322085041 RemoveUserNamespaceRecordsFromVsaAggregation: migrating =====
1187main: == 20230322085041 RemoveUserNamespaceRecordsFromVsaAggregation: migrated (0.0365s)
1188 deletes the non-group namespace aggregation records
1189 #down
1190main: == 20230322085041 RemoveUserNamespaceRecordsFromVsaAggregation: migrating =====
1191main: == 20230322085041 RemoveUserNamespaceRecordsFromVsaAggregation: migrated (0.0277s)
1192 does nothing
1193RemovePackagesEventsPackageIdFk
1194 # order random
1195main: -- foreign_keys(:packages_events)
1196main: -> 0.0047s
1197main: == 20230316164917 RemovePackagesEventsPackageIdFk: migrating ==================
1198main: -- execute("LOCK TABLE packages_packages, packages_events IN ACCESS EXCLUSIVE MODE")
1199main: -> 0.0014s
1200main: -- remove_foreign_key(:packages_events, :packages_packages, {:name=>"fk_rails_c6c20d0094"})
1201main: -> 0.0055s
1202main: == 20230316164917 RemovePackagesEventsPackageIdFk: migrated (0.0291s) =========
1203main: -- foreign_keys(:packages_events)
1204main: -> 0.0043s
1205main: -- foreign_keys(:packages_events)
1206main: -> 0.0048s
1207 drops and creates the foreign key
1208Knapsack report was generated. Preview:
1209{
1210 "spec/migrations/20220922143634_schedule_reset_duplicate_ci_runners_token_encrypted_values_spec.rb": 19.231589707999774,
1211 "spec/migrations/sync_new_amount_used_for_ci_namespace_monthly_usages_spec.rb": 13.975306743999681,
1212 "spec/migrations/20220106112043_add_update_vulnerability_reads_trigger_spec.rb": 33.62605987400002,
1213 "spec/migrations/adjust_task_note_rename_background_migration_values_spec.rb": 27.616246348999994,
1214 "spec/migrations/backfill_namespace_id_for_namespace_routes_spec.rb": 29.271529478000048,
1215 "spec/migrations/20220107064845_populate_vulnerability_reads_spec.rb": 28.40026608900007,
1216 "spec/migrations/cleanup_orphaned_routes_spec.rb": 24.65087749600025,
1217 "spec/migrations/20220315171129_cleanup_draft_data_from_faulty_regex_spec.rb": 25.284358685999905,
1218 "spec/migrations/20220202105733_delete_service_template_records_spec.rb": 28.856870464000167,
1219 "spec/migrations/backfill_namespace_id_for_project_routes_spec.rb": 26.097334365999814,
1220 "spec/migrations/finalize_invalid_member_cleanup_spec.rb": 25.27477745499982,
1221 "spec/migrations/20220128155251_remove_dangling_running_builds_spec.rb": 25.66928592399927,
1222 "spec/migrations/20220208080921_schedule_migrate_personal_namespace_project_maintainer_to_owner_spec.rb": 25.321443197000008,
1223 "spec/migrations/delete_migrate_shared_vulnerability_scanners_spec.rb": 21.862328315000013,
1224 "spec/migrations/20220620132300_update_last_run_date_for_iterations_cadences_spec.rb": 20.637936518999595,
1225 "spec/migrations/toggle_vsa_aggregations_enable_spec.rb": 24.287880752000092,
1226 "spec/migrations/schedule_backfill_draft_status_on_merge_requests_corrected_regex_spec.rb": 24.40024469800028,
1227 "spec/migrations/change_task_system_note_wording_to_checklist_item_spec.rb": 20.228764493999734,
1228 "spec/migrations/set_email_confirmation_setting_from_send_user_confirmation_email_setting_spec.rb": 20.2974031800004,
1229 "spec/migrations/reschedule_issue_work_item_type_id_backfill_spec.rb": 21.05584366199946,
1230 "spec/migrations/populate_releases_access_level_from_repository_spec.rb": 17.162755640000796,
1231 "spec/migrations/20220715163254_update_notes_in_past_spec.rb": 19.93071690600027,
1232 "spec/migrations/20221004094814_schedule_destroy_invalid_members_spec.rb": 17.421555406999687,
1233 "spec/migrations/second_recount_epic_cache_counts_spec.rb": 14.336771305999719,
1234 "spec/migrations/20221021145820_create_routing_table_for_builds_metadata_v2_spec.rb": 15.497566275000281,
1235 "spec/migrations/20221122132812_schedule_prune_stale_project_export_jobs_spec.rb": 13.313191140000527,
1236 "spec/migrations/20230130073109_nullify_creator_id_of_orphaned_projects_spec.rb": 10.920296135000171,
1237 "spec/migrations/20230208125736_schedule_migration_for_links_spec.rb": 10.87140038600046,
1238 "spec/migrations/queue_backfill_prepared_at_data_spec.rb": 8.01545999100017,
1239 "spec/migrations/swap_merge_request_metrics_id_to_bigint_for_gitlab_dot_com_spec.rb": 6.647082256999056,
1240 "spec/migrations/20230322085041_remove_user_namespace_records_from_vsa_aggregation_spec.rb": 5.408874834000017,
1241 "spec/migrations/remove_packages_events_package_id_fk_spec.rb": 3.895100949999687
1242}
1243Knapsack global time execution for tests: 10m 29s
1244Finished in 23 minutes 36 seconds (files took 37.75 seconds to load)
124563 examples, 0 failures
1246Randomized with seed 33905
1247[TEST PROF INFO] Time spent in factories: 00:00.579 (0.04% of total time)
1248RSpec exited with 0.
1249No examples to retry, congrats!
1250 Saving cache for successful job 00:00
1251Not uploading cache ruby-gems-debian-bullseye-ruby-3.0-16 due to policy
1252Not uploading cache gitaly-ruby-gems-debian-bullseye-ruby-3.0-16 due to policy
1253 Uploading artifacts for successful job 00:05
1254Uploading artifacts...
1255coverage/: found 5 matching artifact files and directories
1256crystalball/: found 2 matching artifact files and directories
1257WARNING: deprecations/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab)
1258knapsack/: found 3 matching artifact files and directories
1259WARNING: query_recorder/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab)
1260rspec/: found 14 matching artifact files and directories
1261WARNING: tmp/capybara/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab)
1262log/*.log: found 13 matching artifact files and directories
1263WARNING: Upload request redirected location=https://gitlab.com/api/v4/jobs/4031138397/artifacts?artifact_format=zip&artifact_type=archive&expire_in=31d new-url=https://gitlab.com
1264WARNING: Retrying... context=artifacts-uploader error=request redirected
1265Uploading artifacts as "archive" to coordinator... 201 Created id=4031138397 responseStatus=201 Created token=64_5AJaT
1266Uploading artifacts...
1267rspec/junit_rspec.xml: found 1 matching artifact files and directories
1268WARNING: Upload request redirected location=https://gitlab.com/api/v4/jobs/4031138397/artifacts?artifact_format=gzip&artifact_type=junit&expire_in=31d new-url=https://gitlab.com
1269WARNING: Retrying... context=artifacts-uploader error=request redirected
1270Uploading artifacts as "junit" to coordinator... 201 Created id=4031138397 responseStatus=201 Created token=64_5AJaT
1271 Cleaning up project directory and file based variables 00:01
1272Job succeeded