Skip to content
Snippets Groups Projects

rspec migration pg13-as-if-foss single-db-ci-connection 6/8

Passed Started by
🤖 GitLab Bot 🤖
@gitlab-bot
1Running with gitlab-runner 15.9.0~beta.115.g598a7c91 (598a7c91)
2 on green-2.shared-gitlab-org.runners-manager.gitlab.com/default 8zCxmpPt, system ID: s_130a96ce9e65
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:06
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:00
18Running on runner-8zcxmppt-project-278964-concurrent-0 via runner-8zcxmppt-shared-gitlab-org-1680167281-f08a8c50...
19 Getting source from Git repository 00:37
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 | 33.59 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:14
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:20
43Downloading artifacts for compile-test-assets as-if-foss (4031138200)...
44Downloading artifacts from coordinator... ok host=storage.googleapis.com id=4031138200 responseStatus=200 OK token=64_ScaHE
45Downloading artifacts for detect-tests (4031138213)...
46Downloading artifacts from coordinator... ok host=storage.googleapis.com id=4031138213 responseStatus=200 OK token=64_ScaHE
47Downloading artifacts for retrieve-tests-metadata (4031138217)...
48Downloading artifacts from coordinator... ok host=storage.googleapis.com id=4031138217 responseStatus=200 OK token=64_ScaHE
49Downloading artifacts for setup-test-env (4031138204)...
50Downloading artifacts from coordinator... ok host=storage.googleapis.com id=4031138204 responseStatus=200 OK token=64_ScaHE
51 Executing "step_script" stage of the job script 27:44
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
541
55$ [ "$FOSS_ONLY" = "1" ] && rm -rf ee/ qa/spec/ee/ qa/qa/specs/features/ee/ qa/qa/ee/ qa/qa/ee.rb
56$ export GOPATH=$CI_PROJECT_DIR/.go
57$ mkdir -p $GOPATH
58$ source scripts/utils.sh
59$ source scripts/prepare_build.sh
60 Installing gems 00:14
710Using decomposed database config (config/database.yml.postgresql)
711Enabling ci connection (database_tasks: false) in config/database.yml
712Geo DB won't be set up.
713$ setup_db_user_only
714CREATE ROLE
715GRANT
716==> 'setup_db_user_only' succeeded in 0 seconds.
717$ bundle exec rake db:drop db:create db:schema:load db:migrate gitlab:db:lock_writes
718Dropped database 'gitlabhq_test'
719Created database 'gitlabhq_test'
720==> 'bundle exec rake db:drop db:create db:schema:load db:migrate gitlab:db:lock_writes' succeeded in 34 seconds.
721$ setup_db_praefect
722SELECT pg_catalog.set_config('search_path', '', false);
723CREATE DATABASE praefect_test ENCODING 'UTF8';
724==> 'setup_db_praefect' succeeded in 1 seconds.
725$ source ./scripts/rspec_helpers.sh
726$ run_timed_command "gem install knapsack --no-document"
727$ gem install knapsack --no-document
728Successfully installed knapsack-4.0.0
7291 gem installed
730$ echo -e "\e[0Ksection_start:`date +%s`:gitaly-test-spawn[collapsed=true]\r\e[0KStarting Gitaly"
731==> 'gem install knapsack --no-document' succeeded in 0 seconds.
732 Starting Gitaly 00:11
835$ rspec_paralellized_job "--tag ~quarantine --tag ~zoekt"
836SKIP_FLAKY_TESTS_AUTOMATICALLY: false
837RETRY_FAILED_TESTS_IN_NEW_PROCESS: true
838KNAPSACK_GENERATE_REPORT:
839FLAKY_RSPEC_GENERATE_REPORT:
840KNAPSACK_TEST_FILE_PATTERN: spec/{migrations}{,/**/}*_spec.rb
841KNAPSACK_LOG_LEVEL: debug
842KNAPSACK_REPORT_PATH: knapsack/rspec_migration_pg13-as-if-foss_single-db-ci-connection_6_8_report.json
843FLAKY_RSPEC_SUITE_REPORT_PATH: rspec/flaky/report-suite.json
844FLAKY_RSPEC_REPORT_PATH: rspec/flaky/all_rspec_migration_pg13-as-if-foss_single-db-ci-connection_6_8_report.json
845NEW_FLAKY_RSPEC_REPORT_PATH: rspec/flaky/new_rspec_migration_pg13-as-if-foss_single-db-ci-connection_6_8_report.json
846SKIPPED_FLAKY_TESTS_REPORT_PATH: rspec/flaky/skipped_flaky_tests_rspec_migration_pg13-as-if-foss_single-db-ci-connection_6_8_report.txt
847CRYSTALBALL:
848Run options: exclude {:quarantine=>true, :zoekt=>true}
849Test environment set up in 0.718313061 seconds
850CreateNextCiPartitionsRecord
851 # order random
852 #down
853 when on sass
854ci: == 20221102090940 CreateNextCiPartitionsRecord: migrating =====================
855ci: -- execute("INSERT INTO \"ci_partitions\" (\"id\", \"created_at\", \"updated_at\")\n VALUES (101, now(), now())\n ON CONFLICT DO NOTHING;\n")
856ci: -> 0.0022s
857ci: -- reset_pk_sequence!("ci_partitions")
858ci: -> 0.0086s
859ci: -> 101 rows
860ci: == 20221102090940 CreateNextCiPartitionsRecord: migrated (0.0116s) ============
861ci: -- execute("DELETE FROM \"ci_partitions\"\n WHERE \"ci_partitions\".\"id\" = 101;\n")
862ci: -> 0.0017s
863 removes the record
864 when self-managed
865ci: == 20221102090940 CreateNextCiPartitionsRecord: migrating =====================
866ci: -- execute("INSERT INTO \"ci_partitions\" (\"id\", \"created_at\", \"updated_at\")\n VALUES (101, now(), now())\n ON CONFLICT DO NOTHING;\n")
867ci: -> 0.0019s
868ci: -- reset_pk_sequence!("ci_partitions")
869ci: -> 0.0088s
870ci: -> 101 rows
871ci: == 20221102090940 CreateNextCiPartitionsRecord: migrated (0.0112s) ============
872 does not remove the record
873 #up
874 when on sass
875ci: == 20221102090940 CreateNextCiPartitionsRecord: migrating =====================
876ci: -- execute("INSERT INTO \"ci_partitions\" (\"id\", \"created_at\", \"updated_at\")\n VALUES (101, now(), now())\n ON CONFLICT DO NOTHING;\n")
877ci: -> 0.0016s
878ci: -- reset_pk_sequence!("ci_partitions")
879ci: -> 0.0065s
880ci: -> 101 rows
881ci: == 20221102090940 CreateNextCiPartitionsRecord: migrated (0.0088s) ============
882 creates next partitions record and resets the sequence
883 when self-managed
884ci: == 20221102090940 CreateNextCiPartitionsRecord: migrating =====================
885ci: == 20221102090940 CreateNextCiPartitionsRecord: migrated (0.0006s) ============
886 does not create records
887FinalizeProjectNamespacesBackfill
888 #up
889 when project namespace backfilling migration is missing
890main: == 20220322071127 FinalizeProjectNamespacesBackfill: migrating ================
891main: == 20220322071127 FinalizeProjectNamespacesBackfill: migrated (0.0121s) =======
892 warns migration not found
893 with backfilling migration present
894 when project namespace backfilling migration finished successfully
895main: == 20220322071127 FinalizeProjectNamespacesBackfill: migrating ================
896main: == 20220322071127 FinalizeProjectNamespacesBackfill: migrated (0.0200s) =======
897 does not raise exception
898 when project namespace backfilling migration is paused
899 status: 0, description: "paused"
900 behaves like finalizes the migration
901 finalizes the migration
902 status: 1, description: "active"
903 behaves like finalizes the migration
904 finalizes the migration
905 status: 4, description: "failed"
906 behaves like finalizes the migration
907 finalizes the migration
908 status: 5, description: "finalizing"
909 behaves like finalizes the migration
910 finalizes the migration
911FinalizeCiBuildNeedsBigIntConversion
912 # order random
913 #up
914 dot_com: true, dev_or_test: true, jh: true, expectation: :not_to
915ci: == 20230214181633 FinalizeCiBuildNeedsBigIntConversion: migrating =============
916ci: == 20230214181633 FinalizeCiBuildNeedsBigIntConversion: migrated (0.0210s) ====
917 ensures the migration is completed for GitLab.com, dev, or test
918 dot_com: true, dev_or_test: false, jh: true, expectation: :not_to
919ci: == 20230214181633 FinalizeCiBuildNeedsBigIntConversion: migrating =============
920ci: == 20230214181633 FinalizeCiBuildNeedsBigIntConversion: migrated (0.0238s) ====
921 ensures the migration is completed for GitLab.com, dev, or test
922 dot_com: false, dev_or_test: true, jh: true, expectation: :not_to
923ci: == 20230214181633 FinalizeCiBuildNeedsBigIntConversion: migrating =============
924ci: == 20230214181633 FinalizeCiBuildNeedsBigIntConversion: migrated (0.0218s) ====
925 ensures the migration is completed for GitLab.com, dev, or test
926 dot_com: false, dev_or_test: false, jh: true, expectation: :not_to
927ci: == 20230214181633 FinalizeCiBuildNeedsBigIntConversion: migrating =============
928ci: == 20230214181633 FinalizeCiBuildNeedsBigIntConversion: migrated (0.0204s) ====
929 ensures the migration is completed for GitLab.com, dev, or test
930 dot_com: true, dev_or_test: true, jh: false, expectation: :to
931ci: == 20230214181633 FinalizeCiBuildNeedsBigIntConversion: migrating =============
932ci: == 20230214181633 FinalizeCiBuildNeedsBigIntConversion: migrated (0.0214s) ====
933 ensures the migration is completed for GitLab.com, dev, or test
934 dot_com: true, dev_or_test: false, jh: false, expectation: :to
935ci: == 20230214181633 FinalizeCiBuildNeedsBigIntConversion: migrating =============
936ci: == 20230214181633 FinalizeCiBuildNeedsBigIntConversion: migrated (0.0205s) ====
937 ensures the migration is completed for GitLab.com, dev, or test
938 dot_com: false, dev_or_test: true, jh: false, expectation: :to
939ci: == 20230214181633 FinalizeCiBuildNeedsBigIntConversion: migrating =============
940ci: == 20230214181633 FinalizeCiBuildNeedsBigIntConversion: migrated (0.0241s) ====
941 ensures the migration is completed for GitLab.com, dev, or test
942 dot_com: false, dev_or_test: false, jh: false, expectation: :not_to
943ci: == 20230214181633 FinalizeCiBuildNeedsBigIntConversion: migrating =============
944ci: == 20230214181633 FinalizeCiBuildNeedsBigIntConversion: migrated (0.0231s) ====
945 ensures the migration is completed for GitLab.com, dev, or test
946EncryptIntegrationProperties
947main: == 20220204194347 EncryptIntegrationProperties: migrating =====================
948main: -- Scheduled 3 EncryptIntegrationProperties jobs with a maximum of 2 records per batch and an interval of 120 seconds.
949The migration is expected to take at least 360 seconds. Expect all jobs to have completed after 2023-03-30 11:49:41 UTC."
950main: == 20220204194347 EncryptIntegrationProperties: migrated (0.0604s) ============
951 correctly schedules background migrations
952RescheduleExpireOAuthTokens
953 #up
954main: == 20220513043344 RescheduleExpireOAuthTokens: migrating ======================
955main: == 20220513043344 RescheduleExpireOAuthTokens: migrated (0.0686s) =============
956 schedules background jobs for each batch of oauth tokens
957 #down
958main: == 20220513043344 RescheduleExpireOAuthTokens: migrating ======================
959main: == 20220513043344 RescheduleExpireOAuthTokens: migrated (0.0758s) =============
960 deletes all batched migration records
961RebalancePartitionIdCiBuild
962 # order random
963 when on self-managed instance
964 #up
965 does not schedule background job
966 #down
967 does not delete background job
968 when on sass
969 #up
970ci: == 20230125093840 RebalancePartitionIdCiBuild: migrating ======================
971ci: == 20230125093840 RebalancePartitionIdCiBuild: migrated (0.0784s) =============
972 schedules background jobs for each batch of ci_builds
973 #down
974ci: == 20230125093840 RebalancePartitionIdCiBuild: migrating ======================
975ci: == 20230125093840 RebalancePartitionIdCiBuild: migrated (0.0865s) =============
976 deletes all batched migration records
977BackfillCycleAnalyticsAggregations
978main: == 20220204110725 BackfillCycleAnalyticsAggregations: migrating ===============
979main: == 20220204110725 BackfillCycleAnalyticsAggregations: migrated (0.0269s) ======
980 does nothing
981 when there are value stream records
982main: == 20220204110725 BackfillCycleAnalyticsAggregations: migrating ===============
983main: -- execute("WITH records_to_be_inserted AS MATERIALIZED (\n SELECT root_ancestor.id AS group_id\n FROM (SELECT \"analytics_cycle_analytics_group_value_streams\".\"group_id\" FROM \"analytics_cycle_analytics_group_value_streams\" WHERE \"analytics_cycle_analytics_group_value_streams\".\"id\" >= 1) as value_streams,\n LATERAL (\n WITH RECURSIVE \"base_and_ancestors\" AS (\n (SELECT \"namespaces\".\"id\", \"namespaces\".\"parent_id\" FROM \"namespaces\" WHERE \"namespaces\".\"id\" = value_streams.group_id)\n UNION\n (SELECT \"namespaces\".\"id\", \"namespaces\".\"parent_id\" FROM \"namespaces\", \"base_and_ancestors\" WHERE \"namespaces\".\"id\" = \"base_and_ancestors\".\"parent_id\")\n )\n SELECT \"namespaces\".\"id\" FROM \"base_and_ancestors\" as \"namespaces\" WHERE parent_id IS NULL LIMIT 1\n ) as root_ancestor\n)\nINSERT INTO \"analytics_cycle_analytics_aggregations\"\nSELECT * FROM \"records_to_be_inserted\"\nON CONFLICT DO NOTHING\n")
984main: -> 0.0045s
985main: == 20220204110725 BackfillCycleAnalyticsAggregations: migrated (0.0162s) ======
986 inserts a record for each top-level namespace
987BackfillAllProjectNamespaces
988 #up
989main: == 20220301093434 BackfillAllProjectNamespaces: migrating =====================
990main: == 20220301093434 BackfillAllProjectNamespaces: migrated (0.0430s) ============
991 schedules background jobs for each batch of namespaces
992 #down
993main: == 20220301093434 BackfillAllProjectNamespaces: migrating =====================
994main: == 20220301093434 BackfillAllProjectNamespaces: migrated (0.0460s) ============
995 deletes all batched migration records
996BackfillProjectNamespacesForGroup
997 #up
998main: == 20211209103048 BackfillProjectNamespacesForGroup: migrating ================
999main: == 20211209103048 BackfillProjectNamespacesForGroup: migrated (0.0481s) =======
1000 schedules background jobs for each batch of namespaces
1001 #down
1002main: == 20211209103048 BackfillProjectNamespacesForGroup: migrating ================
1003main: == 20211209103048 BackfillProjectNamespacesForGroup: migrated (0.0084s) =======
1004 deletes all batched migration records
1005PopulateContainerRepositoriesMigrationPlan
1006main: == 20220316202640 PopulateContainerRepositoriesMigrationPlan: migrating =======
1007main: -- Scheduled 2 PopulateContainerRepositoryMigrationPlan jobs with a maximum of 2 records per batch and an interval of 120 seconds.
1008The migration is expected to take at least 240 seconds. Expect all jobs to have completed after 2023-03-30 11:54:46 UTC."
1009main: == 20220316202640 PopulateContainerRepositoriesMigrationPlan: migrated (0.0461s)
1010 schedules jobs for container_repositories to populate migration_state
1011The application_settings (main) table has 1227 columns.
1012Recreating the database
1013Dropped database 'gitlabhq_test'
1014Created database 'gitlabhq_test'
1015Databases re-creation done in 6.03024538200043
1016RemoveIntegrationsType
1017main: == 20220213103859 RemoveIntegrationsType: migrating ===========================
1018main: -- view_exists?(:postgres_partitions)
1019main: -> 0.0021s
1020main: -- index_exists?(:integrations, :id, {:where=>"type_new is null", :name=>"tmp_idx_integrations_unmigrated_type_new", :algorithm=>:concurrently})
1021main: -> 0.0118s
1022main: -- add_index(:integrations, :id, {:where=>"type_new is null", :name=>"tmp_idx_integrations_unmigrated_type_new", :algorithm=>:concurrently})
1023main: -> 0.0026s
1024main: -- view_exists?(:postgres_partitions)
1025main: -> 0.0027s
1026main: -- indexes(:integrations)
1027main: -> 0.0139s
1028main: -- remove_index(:integrations, {:algorithm=>:concurrently, :name=>"tmp_idx_integrations_unmigrated_type_new"})
1029main: -> 0.0019s
1030main: -- remove_column(:integrations, :type, :text)
1031main: -> 0.0027s
1032main: == 20220213103859 RemoveIntegrationsType: migrated (0.1162s) ==================
1033 performs remaining background migrations
1034AddIndexToProjectsOnMarkedForDeletionAt
1035main: == 20211203091642 AddIndexToProjectsOnMarkedForDeletionAt: migrating ==========
1036main: -- view_exists?(:postgres_partitions)
1037main: -> 0.0019s
1038main: -- index_exists?(:projects, :id, {:where=>"marked_for_deletion_at IS NULL", :name=>"index_projects_not_aimed_for_deletion", :algorithm=>:concurrently})
1039main: -> 0.0536s
1040main: -- add_index(:projects, :id, {:where=>"marked_for_deletion_at IS NULL", :name=>"index_projects_not_aimed_for_deletion", :algorithm=>:concurrently})
1041main: -> 0.0031s
1042main: == 20211203091642 AddIndexToProjectsOnMarkedForDeletionAt: migrated (0.0776s) =
1043 correctly migrates up and down
1044FinalizeGroupMemberNamespaceIdMigration
1045 # order random
1046 #up
1047 when migration is missing
1048main: == 20221002234454 FinalizeGroupMemberNamespaceIdMigration: migrating ==========
1049main: == 20221002234454 FinalizeGroupMemberNamespaceIdMigration: migrated (0.0098s) =
1050 warns migration not found
1051 with migration present
1052 when migration finished successfully
1053main: == 20221002234454 FinalizeGroupMemberNamespaceIdMigration: migrating ==========
1054main: == 20221002234454 FinalizeGroupMemberNamespaceIdMigration: migrated (0.0220s) =
1055 does not raise exception
1056 with different migration statuses
1057 status: 0, description: "paused"
1058 behaves like finalizes the migration
1059 finalizes the migration
1060 status: 1, description: "active"
1061 behaves like finalizes the migration
1062 finalizes the migration
1063 status: 4, description: "failed"
1064 behaves like finalizes the migration
1065 finalizes the migration
1066 status: 5, description: "finalizing"
1067 behaves like finalizes the migration
1068 finalizes the migration
1069ScheduleDisableLegacyOpenSourceLicenceForRecentPublicProjects
1070 when on gitlab.com
1071 #up
1072 schedules background jobs for each batch of projects
1073 #down
1074 deletes all batched migration records
1075 when on self-managed instances
1076 #up
1077 does not schedule background job
1078 #down
1079 does not delete background job
1080RemoveLeftoverExternalPullRequestDeletions
1081WARNING: Active Record does not support composite primary key.
1082loose_foreign_keys_deleted_records has composite primary key. Composite primary key is ignored.
1083main: == 20220309084954 RemoveLeftoverExternalPullRequestDeletions: migrating =======
1084main: -- execute("DELETE FROM \"loose_foreign_keys_deleted_records\"\nWHERE\n(\"loose_foreign_keys_deleted_records\".\"partition\", \"loose_foreign_keys_deleted_records\".\"id\") IN (\n SELECT \"loose_foreign_keys_deleted_records\".\"partition\", \"loose_foreign_keys_deleted_records\".\"id\"\n FROM \"loose_foreign_keys_deleted_records\"\n WHERE\n \"loose_foreign_keys_deleted_records\".\"fully_qualified_table_name\" = 'public.external_pull_requests' AND\n \"loose_foreign_keys_deleted_records\".\"status\" = 1\n LIMIT 100\n)\n")
1085main: -> 0.0024s
1086main: -- execute("DELETE FROM \"loose_foreign_keys_deleted_records\"\nWHERE\n(\"loose_foreign_keys_deleted_records\".\"partition\", \"loose_foreign_keys_deleted_records\".\"id\") IN (\n SELECT \"loose_foreign_keys_deleted_records\".\"partition\", \"loose_foreign_keys_deleted_records\".\"id\"\n FROM \"loose_foreign_keys_deleted_records\"\n WHERE\n \"loose_foreign_keys_deleted_records\".\"fully_qualified_table_name\" = 'public.external_pull_requests' AND\n \"loose_foreign_keys_deleted_records\".\"status\" = 1\n LIMIT 100\n)\n")
1087main: -> 0.0023s
1088main: == 20220309084954 RemoveLeftoverExternalPullRequestDeletions: migrated (0.0049s)
1089 deletes pending external_pull_requests records
1090FixPartitionIdsForCiPipelineVariable
1091 # order random
1092 when on saas
1093 #up
1094ci: == 20230208100917 FixPartitionIdsForCiPipelineVariable: migrating =============
1095ci: == 20230208100917 FixPartitionIdsForCiPipelineVariable: migrated (0.0827s) ====
1096 schedules background jobs for each batch of ci_pipeline_variables
1097 #down
1098ci: == 20230208100917 FixPartitionIdsForCiPipelineVariable: migrating =============
1099ci: == 20230208100917 FixPartitionIdsForCiPipelineVariable: migrated (0.0767s) ====
1100 deletes all batched migration records
1101 when on self-managed instance
1102 #up
1103 does not schedule background job
1104 #down
1105 does not delete background job
1106RemoveDependencyListUsageDataFromRedis
1107 #up
1108main: == 20220310141349 RemoveDependencyListUsageDataFromRedis: migrating ===========
1109main: == 20220310141349 RemoveDependencyListUsageDataFromRedis: migrated (0.0009s) ==
1110 removes the hash from redis
1111AddProjectsEmailsEnabledColumnData
1112 # order random
1113main: == 20221116134633 AddProjectsEmailsEnabledColumnData: migrating ===============
1114main: == 20221116134633 AddProjectsEmailsEnabledColumnData: migrated (0.0574s) ======
1115 schedules background migrations
1116main: == 20221116134633 AddProjectsEmailsEnabledColumnData: migrating ===============
1117main: == 20221116134633 AddProjectsEmailsEnabledColumnData: migrated (0.0514s) ======
1118 sets emails_enabled to be the opposite of emails_disabled
1119 #down
1120main: == 20221116134633 AddProjectsEmailsEnabledColumnData: migrating ===============
1121main: == 20221116134633 AddProjectsEmailsEnabledColumnData: migrated (0.0675s) ======
1122 deletes all batched migration records
1123ScheduleFixingSecurityScanStatuses
1124 # order random
1125 #down
1126main: == 20221128120634 ScheduleFixingSecurityScanStatuses: migrating ===============
1127main: == 20221128120634 ScheduleFixingSecurityScanStatuses: migrated (0.0005s) ======
1128 deletes all batched migration records
1129 #up
1130 when the migration does not run on GitLab.com or development environment
1131main: == 20221128120634 ScheduleFixingSecurityScanStatuses: migrating ===============
1132main: == 20221128120634 ScheduleFixingSecurityScanStatuses: migrated (0.0006s) ======
1133 does not schedule the migration
1134 when the migration runs on GitLab.com
1135 behaves like scheduler for fixing the security scans status
1136main: == 20221128120634 ScheduleFixingSecurityScanStatuses: migrating ===============
1137main: == 20221128120634 ScheduleFixingSecurityScanStatuses: migrated (0.0605s) ======
1138 schedules background job
1139 when the migration runs on dev environment
1140 behaves like scheduler for fixing the security scans status
1141main: == 20221128120634 ScheduleFixingSecurityScanStatuses: migrating ===============
1142main: == 20221128120634 ScheduleFixingSecurityScanStatuses: migrated (0.0534s) ======
1143 schedules background job
1144FinalizeNullifyCreatorIdOfOrphanedProjects
1145 # order random
1146 #up
1147 when migration is missing
1148main: == 20230223065753 FinalizeNullifyCreatorIdOfOrphanedProjects: migrating =======
1149main: == 20230223065753 FinalizeNullifyCreatorIdOfOrphanedProjects: migrated (0.0193s)
1150 warns migration not found
1151 with migration present
1152 when migration finished successfully
1153main: == 20230223065753 FinalizeNullifyCreatorIdOfOrphanedProjects: migrating =======
1154main: == 20230223065753 FinalizeNullifyCreatorIdOfOrphanedProjects: migrated (0.0320s)
1155 does not raise exception
1156 with different migration statuses
1157 status: 0, description: "paused"
1158 behaves like finalizes the migration
1159main: == 20230223065753 FinalizeNullifyCreatorIdOfOrphanedProjects: migrating =======
1160main: == 20230223065753 FinalizeNullifyCreatorIdOfOrphanedProjects: migrated (0.2458s)
1161 finalizes the migration
1162 status: 1, description: "active"
1163 behaves like finalizes the migration
1164main: == 20230223065753 FinalizeNullifyCreatorIdOfOrphanedProjects: migrating =======
1165main: == 20230223065753 FinalizeNullifyCreatorIdOfOrphanedProjects: migrated (0.2502s)
1166 finalizes the migration
1167 status: 4, description: "failed"
1168 behaves like finalizes the migration
1169main: == 20230223065753 FinalizeNullifyCreatorIdOfOrphanedProjects: migrating =======
1170main: == 20230223065753 FinalizeNullifyCreatorIdOfOrphanedProjects: migrated (0.2485s)
1171 finalizes the migration
1172 status: 5, description: "finalizing"
1173 behaves like finalizes the migration
1174main: == 20230223065753 FinalizeNullifyCreatorIdOfOrphanedProjects: migrating =======
1175main: == 20230223065753 FinalizeNullifyCreatorIdOfOrphanedProjects: migrated (0.2383s)
1176 finalizes the migration
1177BackfillEpicCacheCounts
1178 # order random
1179 #down
1180main: == 20220905120848 BackfillEpicCacheCounts: migrating ==========================
1181main: == 20220905120848 BackfillEpicCacheCounts: migrated (0.0675s) =================
1182 deletes all batched migration records
1183 #up
1184main: == 20220905120848 BackfillEpicCacheCounts: migrating ==========================
1185main: == 20220905120848 BackfillEpicCacheCounts: migrated (0.0614s) =================
1186 schedules a batched background migration
1187AddOkrHierarchyRestrictions
1188 # order random
1189main: == 20221116143854 AddOkrHierarchyRestrictions: migrating ======================
1190main: == 20221116143854 AddOkrHierarchyRestrictions: migrated (0.0393s) =============
1191 creates default restrictions
1192 when work items are missing
1193main: == 20221116143854 AddOkrHierarchyRestrictions: migrating ======================
1194main: == 20221116143854 AddOkrHierarchyRestrictions: migrated (0.0151s) =============
1195 does nothing
1196AddObjectiveAndKeyresultToWorkItemTypes
1197 # order random
1198main: == 20221018050323 AddObjectiveAndKeyresultToWorkItemTypes: migrating ==========
1199main: -- execute("INSERT INTO work_item_types (base_type, icon_name, name, created_at, updated_at) VALUES(\n 5, 'issue-type-objective', 'Objective', NOW(), NOW()\n ) ON CONFLICT DO NOTHING;\n")
1200main: -> 0.0015s
1201main: -- execute("INSERT INTO work_item_types (base_type, icon_name, name, created_at, updated_at) VALUES(\n 6, 'issue-type-keyresult', 'Key Result', NOW(), NOW()\n ) ON CONFLICT DO NOTHING;\n")
1202main: -> 0.0022s
1203main: == 20221018050323 AddObjectiveAndKeyresultToWorkItemTypes: migrated (0.0110s) =
1204 adds both objective & keyresult to base work item types
1205main: == 20221018050323 AddObjectiveAndKeyresultToWorkItemTypes: migrating ==========
1206main: -- Objective item record exist, skipping creation
1207main: -- Keyresult item record exist, skipping creation
1208main: == 20221018050323 AddObjectiveAndKeyresultToWorkItemTypes: migrated (0.0150s) =
1209 skips creating both objective & keyresult type record if it already exists
1210QueuePopulateProjectsStarCount
1211 # order random
1212main: == 20221019105041 QueuePopulateProjectsStarCount: migrating ===================
1213main: == 20221019105041 QueuePopulateProjectsStarCount: migrated (0.0586s) ==========
1214 schedules a new batched migration
1215The application_settings (main) table has 1220 columns.
1216Recreating the database
1217Dropped database 'gitlabhq_test'
1218Created database 'gitlabhq_test'
1219Databases re-creation done in 6.031554213999698
1220AddIndexOnPasswordLastChangedAtToUserDetails
1221 # order random
1222main: -- indexes(:user_details)
1223main: -> 0.0071s
1224main: -- current_schema()
1225main: -> 0.0008s
1226main: == 20221028022627 AddIndexOnPasswordLastChangedAtToUserDetails: migrating =====
1227main: -- view_exists?(:postgres_partitions)
1228main: -> 0.0023s
1229main: -- index_exists?(:user_details, :password_last_changed_at, {:name=>"index_user_details_on_password_last_changed_at", :comment=>"JiHu-specific index", :algorithm=>:concurrently})
1230main: -> 0.0067s
1231main: -- add_index(:user_details, :password_last_changed_at, {:name=>"index_user_details_on_password_last_changed_at", :comment=>"JiHu-specific index", :algorithm=>:concurrently})
1232main: -> 0.0038s
1233main: == 20221028022627 AddIndexOnPasswordLastChangedAtToUserDetails: migrated (0.0360s)
1234main: -- indexes(:user_details)
1235main: -> 0.0098s
1236 correctly migrates up and down
1237QueueBackfillComplianceViolations
1238 # order random
1239 #up
1240main: == 20230125195503 QueueBackfillComplianceViolations: migrating ================
1241main: == 20230125195503 QueueBackfillComplianceViolations: migrated (0.0589s) =======
1242 schedules background jobs for each batch of merge_request_compliance_violations
1243 #down
1244main: == 20230125195503 QueueBackfillComplianceViolations: migrating ================
1245main: == 20230125195503 QueueBackfillComplianceViolations: migrated (0.0603s) =======
1246 deletes all batched migration records
1247ScheduleCreateVulnerabilityLinksMigration
1248 # order random
1249 #up
1250main: == 20230130182412 ScheduleCreateVulnerabilityLinksMigration: migrating ========
1251main: == 20230130182412 ScheduleCreateVulnerabilityLinksMigration: migrated (0.0713s)
1252 schedules background jobs for each batch of Vulnerabilities::Feedback
1253 #down
1254main: == 20230130182412 ScheduleCreateVulnerabilityLinksMigration: migrating ========
1255main: == 20230130182412 ScheduleCreateVulnerabilityLinksMigration: migrated (0.0629s)
1256 deletes all batched migration records
1257MigrateEvidencesFromRawMetadata
1258 # order random
1259 #up
1260main: == 20230224144233 MigrateEvidencesFromRawMetadata: migrating ==================
1261main: == 20230224144233 MigrateEvidencesFromRawMetadata: migrated (0.0650s) =========
1262 schedules a batched background migration
1263 #down
1264main: == 20230224144233 MigrateEvidencesFromRawMetadata: migrating ==================
1265main: == 20230224144233 MigrateEvidencesFromRawMetadata: migrated (0.0568s) =========
1266 deletes all batched migration records
1267RescheduleMigrationForRemediation
1268 # order random
1269 #up
1270main: == 20230313150531 RescheduleMigrationForRemediation: migrating ================
1271main: == 20230313150531 RescheduleMigrationForRemediation: migrated (0.0672s) =======
1272 schedules a batched background migration
1273 #down
1274main: == 20230313150531 RescheduleMigrationForRemediation: migrating ================
1275main: == 20230313150531 RescheduleMigrationForRemediation: migrated (0.0799s) =======
1276 deletes all batched migration records
1277ActiveRecord::Schema
1278 > schema version should equal the latest migration timestamp stored in schema_migrations table
1279 the schema_migrations table contains all schema versions
1280BackfillMlCandidatesPackageId
1281 # order random
1282 #up
1283main: -- execute(" UPDATE ml_candidates\n SET package_id = candidate_id_to_package_id.package_id\n FROM (SELECT id as package_id, TRIM(LEADING 'ml_candidates_' FROM name) as candidate_id\n FROM packages_packages\n WHERE name LIKE 'ml_candidate_%'\n and version = '-') AS candidate_id_to_package_id\n WHERE cast(ml_candidates.id as text) = candidate_id_to_package_id.candidate_id\n")
1284main: -> 0.0026s
1285main: -- execute(" UPDATE ml_candidates\n SET package_id = candidate_id_to_package_id.package_id\n FROM (SELECT id as package_id, TRIM(LEADING 'ml_candidates_' FROM name) as candidate_id\n FROM packages_packages\n WHERE name LIKE 'ml_candidate_%'\n and version = '-') AS candidate_id_to_package_id\n WHERE cast(ml_candidates.id as text) = candidate_id_to_package_id.candidate_id\n")
1286main: -> 0.0018s
1287 sets the correct package_ids with idempotency
1288EnsureSnippetUserMentionsBigintBackfillIsFinishedForGitlabDotCom
1289 # order random
1290 #up
1291main: == 20230322011220 EnsureSnippetUserMentionsBigintBackfillIsFinishedForGitlabDotCom: migrating
1292main: == 20230322011220 EnsureSnippetUserMentionsBigintBackfillIsFinishedForGitlabDotCom: migrated (0.0083s)
1293 ensures the migration is completed for GitLab.com, dev, or test
1294main: == 20230322011220 EnsureSnippetUserMentionsBigintBackfillIsFinishedForGitlabDotCom: migrating
1295main: == 20230322011220 EnsureSnippetUserMentionsBigintBackfillIsFinishedForGitlabDotCom: migrated (0.0075s)
1296 skips the check for other instances
1297Finished in 25 minutes 42 seconds (files took 53.49 seconds to load)
129884 examples, 0 failures
1299Randomized with seed 63861
1300RSpec exited with 0.
1301No examples to retry, congrats!
1302 Saving cache for successful job 00:01
1303Not uploading cache ruby-gems-debian-bullseye-ruby-3.0-16 due to policy
1304Not uploading cache gitaly-ruby-gems-debian-bullseye-ruby-3.0-16 due to policy
1305 Uploading artifacts for successful job 00:05
1306Uploading artifacts...
1307coverage/: found 5 matching artifact files and directories
1308crystalball/: found 2 matching artifact files and directories
1309WARNING: deprecations/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab)
1310knapsack/: found 3 matching artifact files and directories
1311WARNING: query_recorder/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab)
1312rspec/: found 12 matching artifact files and directories
1313WARNING: tmp/capybara/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab)
1314log/*.log: found 13 matching artifact files and directories
1315WARNING: Upload request redirected location=https://gitlab.com/api/v4/jobs/4031138814/artifacts?artifact_format=zip&artifact_type=archive&expire_in=31d new-url=https://gitlab.com
1316WARNING: Retrying... context=artifacts-uploader error=request redirected
1317Uploading artifacts as "archive" to coordinator... 201 Created id=4031138814 responseStatus=201 Created token=64_ScaHE
1318Uploading artifacts...
1319rspec/junit_rspec.xml: found 1 matching artifact files and directories
1320WARNING: Upload request redirected location=https://gitlab.com/api/v4/jobs/4031138814/artifacts?artifact_format=gzip&artifact_type=junit&expire_in=31d new-url=https://gitlab.com
1321WARNING: Retrying... context=artifacts-uploader error=request redirected
1322Uploading artifacts as "junit" to coordinator... 201 Created id=4031138814 responseStatus=201 Created token=64_ScaHE
1323 Cleaning up project directory and file based variables 00:01
1324Job succeeded