Skip to content
Snippets Groups Projects

rspec migration pg13 2/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:01
18Running on runner-8zcxmppt-project-278964-concurrent-0 via runner-8zcxmppt-shared-gitlab-org-1680170068-ecbcde98...
19 Getting source from Git repository 00:25
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 | 26.10 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:13
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:22
43Downloading artifacts for compile-test-assets (4031138198)...
44Downloading artifacts from coordinator... ok host=storage.googleapis.com id=4031138198 responseStatus=200 OK token=64_di2wQ
45Downloading artifacts for detect-tests (4031138213)...
46Downloading artifacts from coordinator... ok host=storage.googleapis.com id=4031138213 responseStatus=200 OK token=64_di2wQ
47Downloading artifacts for retrieve-tests-metadata (4031138217)...
48Downloading artifacts from coordinator... ok host=storage.googleapis.com id=4031138217 responseStatus=200 OK token=64_di2wQ
49Downloading artifacts for setup-test-env (4031138204)...
50Downloading artifacts from coordinator... ok host=storage.googleapis.com id=4031138204 responseStatus=200 OK token=64_di2wQ
51 Executing "step_script" stage of the job script 28:19
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:12
709Using decomposed database config (config/database.yml.decomposed-postgresql)
710Geo DB won't be set up.
711$ setup_db_user_only
712CREATE ROLE
713GRANT
714==> 'setup_db_user_only' succeeded in 0 seconds.
715$ bundle exec rake db:drop db:create db:schema:load db:migrate gitlab:db:lock_writes
716Dropped database 'gitlabhq_test'
717Dropped database 'gitlabhq_test_ci'
718Created database 'gitlabhq_test'
719Created database 'gitlabhq_test_ci'
720==> 'bundle exec rake db:drop db:create db:schema:load db:migrate gitlab:db:lock_writes' succeeded in 53 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 0 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==> 'gem install knapsack --no-document' succeeded in 1 seconds.
731$ echo -e "\e[0Ksection_start:`date +%s`:gitaly-test-spawn[collapsed=true]\r\e[0KStarting Gitaly"
732 Starting Gitaly 00:10
835$ rspec_paralellized_job "--tag ~quarantine --tag ~zoekt"
836SKIP_FLAKY_TESTS_AUTOMATICALLY: false
837RETRY_FAILED_TESTS_IN_NEW_PROCESS: true
838KNAPSACK_GENERATE_REPORT: true
839FLAKY_RSPEC_GENERATE_REPORT: true
840KNAPSACK_TEST_FILE_PATTERN: spec/{migrations}{,/**/}*_spec.rb
841KNAPSACK_LOG_LEVEL: debug
842KNAPSACK_REPORT_PATH: knapsack/rspec_migration_pg13_2_8_report.json
843FLAKY_RSPEC_SUITE_REPORT_PATH: rspec/flaky/report-suite.json
844FLAKY_RSPEC_REPORT_PATH: rspec/flaky/all_rspec_migration_pg13_2_8_report.json
845NEW_FLAKY_RSPEC_REPORT_PATH: rspec/flaky/new_rspec_migration_pg13_2_8_report.json
846SKIPPED_FLAKY_TESTS_REPORT_PATH: rspec/flaky/skipped_flaky_tests_rspec_migration_pg13_2_8_report.txt
847CRYSTALBALL:
848Knapsack node specs:
849spec/migrations/change_public_projects_cost_factor_spec.rb
850spec/migrations/finalize_orphaned_routes_cleanup_spec.rb
851spec/migrations/20220627090231_schedule_disable_legacy_open_source_license_for_inactive_public_projects_spec.rb
852spec/migrations/reschedule_backfill_imported_issue_search_data_spec.rb
853spec/migrations/20211207125331_remove_jobs_for_recalculate_vulnerabilities_occurrences_uuid_spec.rb
854spec/migrations/backfill_member_namespace_id_for_group_members_spec.rb
855spec/migrations/populate_audit_event_streaming_verification_token_spec.rb
856spec/migrations/backfill_group_features_spec.rb
857spec/migrations/20220222192525_remove_null_releases_spec.rb
858spec/migrations/20230209140102_fix_partition_ids_for_ci_build_metadata_spec.rb
859spec/migrations/20220906074449_schedule_disable_legacy_open_source_license_for_projects_less_than_one_mb_spec.rb
860spec/migrations/20220204095121_backfill_namespace_statistics_with_dependency_proxy_size_spec.rb
861spec/migrations/20220321234317_remove_all_issuable_escalation_statuses_spec.rb
862spec/migrations/20221013154159_update_invalid_dormant_user_setting_spec.rb
863spec/migrations/20220120094340_drop_position_from_security_findings_spec.rb
864spec/migrations/add_web_hook_calls_to_plan_limits_paid_tiers_spec.rb
865spec/migrations/20230209090702_fix_partition_ids_for_ci_build_report_result_spec.rb
866spec/migrations/20220802204737_remove_deactivated_user_highest_role_stats_spec.rb
867spec/migrations/20220802114351_reschedule_backfill_container_registry_size_into_project_statistics_spec.rb
868spec/migrations/20220629184402_unset_escalation_policies_for_alert_incidents_spec.rb
869spec/migrations/20221008032350_add_password_expiration_migration_spec.rb
870spec/migrations/20221104115712_backfill_project_statistics_storage_size_without_uploads_size_spec.rb
871spec/migrations/20221123133054_queue_reset_status_on_container_repositories_spec.rb
872spec/migrations/cleanup_vulnerability_state_transitions_with_same_from_state_to_state_spec.rb
873spec/migrations/20221221110733_remove_temp_index_for_project_statistics_upload_size_migration_spec.rb
874spec/migrations/20221219122320_copy_clickhouse_connection_string_to_encrypted_var_spec.rb
875spec/migrations/20230117114739_clear_duplicate_jobs_cookies_spec.rb
876spec/migrations/20230224085743_update_issues_internal_id_scope_spec.rb
877spec/migrations/swap_vulnerability_user_mentions_note_id_to_bigint_for_gitlab_dot_com_spec.rb
878spec/migrations/insert_daily_invites_trial_plan_limits_spec.rb
879spec/migrations/ensure_design_user_mentions_note_id_bigint_backfill_is_finished_for_gitlab_dot_com_spec.rb
880spec/migrations/20230321153035_add_package_id_created_at_desc_index_to_package_files_spec.rb
881Filter specs:
882Running specs:
883Running all node tests without filter
884spec/migrations/change_public_projects_cost_factor_spec.rb
885spec/migrations/finalize_orphaned_routes_cleanup_spec.rb
886spec/migrations/20220627090231_schedule_disable_legacy_open_source_license_for_inactive_public_projects_spec.rb
887spec/migrations/reschedule_backfill_imported_issue_search_data_spec.rb
888spec/migrations/20211207125331_remove_jobs_for_recalculate_vulnerabilities_occurrences_uuid_spec.rb
889spec/migrations/backfill_member_namespace_id_for_group_members_spec.rb
890spec/migrations/populate_audit_event_streaming_verification_token_spec.rb
891spec/migrations/backfill_group_features_spec.rb
892spec/migrations/20220222192525_remove_null_releases_spec.rb
893spec/migrations/20230209140102_fix_partition_ids_for_ci_build_metadata_spec.rb
894spec/migrations/20220906074449_schedule_disable_legacy_open_source_license_for_projects_less_than_one_mb_spec.rb
895spec/migrations/20220204095121_backfill_namespace_statistics_with_dependency_proxy_size_spec.rb
896spec/migrations/20220321234317_remove_all_issuable_escalation_statuses_spec.rb
897spec/migrations/20221013154159_update_invalid_dormant_user_setting_spec.rb
898spec/migrations/20220120094340_drop_position_from_security_findings_spec.rb
899spec/migrations/add_web_hook_calls_to_plan_limits_paid_tiers_spec.rb
900spec/migrations/20230209090702_fix_partition_ids_for_ci_build_report_result_spec.rb
901spec/migrations/20220802204737_remove_deactivated_user_highest_role_stats_spec.rb
902spec/migrations/20220802114351_reschedule_backfill_container_registry_size_into_project_statistics_spec.rb
903spec/migrations/20220629184402_unset_escalation_policies_for_alert_incidents_spec.rb
904spec/migrations/20221008032350_add_password_expiration_migration_spec.rb
905spec/migrations/20221104115712_backfill_project_statistics_storage_size_without_uploads_size_spec.rb
906spec/migrations/20221123133054_queue_reset_status_on_container_repositories_spec.rb
907spec/migrations/cleanup_vulnerability_state_transitions_with_same_from_state_to_state_spec.rb
908spec/migrations/20221221110733_remove_temp_index_for_project_statistics_upload_size_migration_spec.rb
909spec/migrations/20221219122320_copy_clickhouse_connection_string_to_encrypted_var_spec.rb
910spec/migrations/20230117114739_clear_duplicate_jobs_cookies_spec.rb
911spec/migrations/20230224085743_update_issues_internal_id_scope_spec.rb
912spec/migrations/swap_vulnerability_user_mentions_note_id_to_bigint_for_gitlab_dot_com_spec.rb
913spec/migrations/insert_daily_invites_trial_plan_limits_spec.rb
914spec/migrations/ensure_design_user_mentions_note_id_bigint_backfill_is_finished_for_gitlab_dot_com_spec.rb
915spec/migrations/20230321153035_add_package_id_created_at_desc_index_to_package_files_spec.rb
916Running all node tests without filter
917Running all node tests without filter
918Running command: bundle exec rspec -Ispec -rspec_helper --color --failure-exit-code 1 --error-exit-code 2 --format documentation --format RspecJunitFormatter --out rspec/junit_rspec.xml --tag ~quarantine --tag ~zoekt --default-path spec -- spec/migrations/change_public_projects_cost_factor_spec.rb spec/migrations/finalize_orphaned_routes_cleanup_spec.rb spec/migrations/20220627090231_schedule_disable_legacy_open_source_license_for_inactive_public_projects_spec.rb spec/migrations/reschedule_backfill_imported_issue_search_data_spec.rb spec/migrations/20211207125331_remove_jobs_for_recalculate_vulnerabilities_occurrences_uuid_spec.rb spec/migrations/backfill_member_namespace_id_for_group_members_spec.rb spec/migrations/populate_audit_event_streaming_verification_token_spec.rb spec/migrations/backfill_group_features_spec.rb spec/migrations/20220222192525_remove_null_releases_spec.rb spec/migrations/20230209140102_fix_partition_ids_for_ci_build_metadata_spec.rb spec/migrations/20220906074449_schedule_disable_legacy_open_source_license_for_projects_less_than_one_mb_spec.rb spec/migrations/20220204095121_backfill_namespace_statistics_with_dependency_proxy_size_spec.rb spec/migrations/20220321234317_remove_all_issuable_escalation_statuses_spec.rb spec/migrations/20221013154159_update_invalid_dormant_user_setting_spec.rb spec/migrations/20220120094340_drop_position_from_security_findings_spec.rb spec/migrations/add_web_hook_calls_to_plan_limits_paid_tiers_spec.rb spec/migrations/20230209090702_fix_partition_ids_for_ci_build_report_result_spec.rb spec/migrations/20220802204737_remove_deactivated_user_highest_role_stats_spec.rb spec/migrations/20220802114351_reschedule_backfill_container_registry_size_into_project_statistics_spec.rb spec/migrations/20220629184402_unset_escalation_policies_for_alert_incidents_spec.rb spec/migrations/20221008032350_add_password_expiration_migration_spec.rb spec/migrations/20221104115712_backfill_project_statistics_storage_size_without_uploads_size_spec.rb spec/migrations/20221123133054_queue_reset_status_on_container_repositories_spec.rb spec/migrations/cleanup_vulnerability_state_transitions_with_same_from_state_to_state_spec.rb spec/migrations/20221221110733_remove_temp_index_for_project_statistics_upload_size_migration_spec.rb spec/migrations/20221219122320_copy_clickhouse_connection_string_to_encrypted_var_spec.rb spec/migrations/20230117114739_clear_duplicate_jobs_cookies_spec.rb spec/migrations/20230224085743_update_issues_internal_id_scope_spec.rb spec/migrations/swap_vulnerability_user_mentions_note_id_to_bigint_for_gitlab_dot_com_spec.rb spec/migrations/insert_daily_invites_trial_plan_limits_spec.rb spec/migrations/ensure_design_user_mentions_note_id_bigint_backfill_is_finished_for_gitlab_dot_com_spec.rb spec/migrations/20230321153035_add_package_id_created_at_desc_index_to_package_files_spec.rbKnapsack report generator started!
919Run options: exclude {:quarantine=>true, :zoekt=>true}
920Test environment set up in 1.082320983 seconds
921ChangePublicProjectsCostFactor
922 #up
923 when on SaaS
924ci: == 20220610140605 ChangePublicProjectsCostFactor: migrating ===================
925ci: == 20220610140605 ChangePublicProjectsCostFactor: migrated (0.0047s) ==========
926 updates the cost factor from 0 only for shared runners
927 when on self-managed
928ci: == 20220610140605 ChangePublicProjectsCostFactor: migrating ===================
929ci: == 20220610140605 ChangePublicProjectsCostFactor: migrated (0.0004s) ==========
930 skips the migration
931 #down
932 when on SaaS
933ci: == 20220610140605 ChangePublicProjectsCostFactor: migrating ===================
934ci: == 20220610140605 ChangePublicProjectsCostFactor: migrated (0.0041s) ==========
935 resets the cost factor to 0 only for shared runners that were updated
936I, [2023-03-30T11:41:25.179607 #361] INFO -- : Database: 'main', Table: 'ci_runner_machines': Lock Writes
937I, [2023-03-30T11:41:31.543602 #361] INFO -- : Database: 'main', Table: 'p_ci_runner_machine_builds': Lock Writes
938I, [2023-03-30T11:41:31.824030 #361] INFO -- : Database: 'main', Table: 'ci_cost_settings': Lock Writes
939I, [2023-03-30T11:41:51.747642 #361] INFO -- : Database: 'ci', Table: 'dast_pre_scan_verification_steps': Lock Writes
940I, [2023-03-30T11:41:51.853287 #361] INFO -- : Database: 'ci', Table: 'achievements': Lock Writes
941I, [2023-03-30T11:41:52.321449 #361] INFO -- : Database: 'ci', Table: 'slack_api_scopes': Lock Writes
942I, [2023-03-30T11:41:52.323534 #361] INFO -- : Database: 'ci', Table: 'slack_integrations_scopes': Lock Writes
943I, [2023-03-30T11:41:52.619865 #361] INFO -- : Database: 'ci', Table: 'dast_scanner_profiles_tags': Lock Writes
944I, [2023-03-30T11:41:53.139062 #361] INFO -- : Database: 'ci', Table: 'user_achievements': Lock Writes
945I, [2023-03-30T11:41:53.934901 #361] INFO -- : Database: 'ci', Table: 'elastic_group_index_statuses': Lock Writes
946I, [2023-03-30T11:41:54.107809 #361] INFO -- : Database: 'ci', Table: 'analytics_dashboards_pointers': Lock Writes
947I, [2023-03-30T11:41:54.109171 #361] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
948I, [2023-03-30T11:41:54.110040 #361] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
949I, [2023-03-30T11:41:54.999823 #361] INFO -- : Database: 'ci', Table: 'zoekt_shards': Lock Writes
950I, [2023-03-30T11:41:55.003087 #361] INFO -- : Database: 'ci', Table: 'zoekt_indexed_namespaces': Lock Writes
951I, [2023-03-30T11:41:55.461784 #361] INFO -- : Database: 'ci', Table: 'dast_profiles_tags': Lock Writes
952I, [2023-03-30T11:41:55.529673 #361] INFO -- : Database: 'ci', Table: 'namespaces_storage_limit_exclusions': Lock Writes
953I, [2023-03-30T11:41:56.750504 #361] INFO -- : Database: 'ci', Table: 'namespace_ldap_settings': Lock Writes
954I, [2023-03-30T11:41:57.405640 #361] INFO -- : Database: 'ci', Table: 'project_data_transfers': Lock Writes
955I, [2023-03-30T11:41:57.406816 #361] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
956I, [2023-03-30T11:41:57.407632 #361] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
957I, [2023-03-30T11:41:57.601950 #361] INFO -- : Database: 'ci', Table: 'service_desk_custom_email_verifications': Lock Writes
958I, [2023-03-30T11:41:58.342093 #361] INFO -- : Database: 'ci', Table: 'scan_result_policies': Lock Writes
959I, [2023-03-30T11:41:59.940084 #361] INFO -- : Database: 'ci', Table: 'work_item_widget_definitions': Lock Writes
960I, [2023-03-30T11:42:01.059569 #361] INFO -- : Database: 'ci', Table: 'container_repository_states': Lock Writes
961I, [2023-03-30T11:42:01.060951 #361] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
962I, [2023-03-30T11:42:01.061831 #361] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
963I, [2023-03-30T11:42:01.416453 #361] INFO -- : Database: 'ci', Table: 'automation_rules': Lock Writes
964I, [2023-03-30T11:42:02.412851 #361] INFO -- : Database: 'ci', Table: 'bulk_import_export_batches': Lock Writes
965I, [2023-03-30T11:42:02.552201 #361] INFO -- : Database: 'ci', Table: 'bulk_import_batch_trackers': Lock Writes
966I, [2023-03-30T11:42:03.957539 #361] INFO -- : Database: 'ci', Table: 'catalog_resources': Lock Writes
967I, [2023-03-30T11:42:05.943322 #361] INFO -- : Database: 'ci', Table: 'design_management_repositories': Lock Writes
968I, [2023-03-30T11:42:06.054636 #361] INFO -- : Database: 'ci', Table: 'schema_inconsistencies': Lock Writes
969I, [2023-03-30T11:42:06.459299 #361] INFO -- : Database: 'ci', Table: 'container_registry_data_repair_details': Lock Writes
970I, [2023-03-30T11:42:06.797303 #361] INFO -- : Database: 'ci', Table: 'search_indices': Lock Writes
971I, [2023-03-30T11:42:06.829151 #361] INFO -- : Database: 'ci', Table: 'search_namespace_index_assignments': Lock Writes
972I, [2023-03-30T11:42:07.313778 #361] INFO -- : Database: 'ci', Table: 'service_desk_custom_email_credentials': Lock Writes
973I, [2023-03-30T11:42:08.747126 #361] INFO -- : Database: 'ci', Table: 'dora_performance_scores': Lock Writes
974FinalizeOrphanedRoutesCleanup
975 #up
976 when migration is missing
977main: == 20220620060633 FinalizeOrphanedRoutesCleanup: migrating ====================
978main: == 20220620060633 FinalizeOrphanedRoutesCleanup: migrated (0.0081s) ===========
979 warns migration not found
980 with migration present
981 when migration finished successfully
982main: == 20220620060633 FinalizeOrphanedRoutesCleanup: migrating ====================
983main: == 20220620060633 FinalizeOrphanedRoutesCleanup: migrated (0.0222s) ===========
984 does not raise exception
985 with different migration statuses
986 status: 0, description: "paused"
987 behaves like finalizes the migration
988 finalizes the migration
989 status: 1, description: "active"
990 behaves like finalizes the migration
991 finalizes the migration
992 status: 4, description: "failed"
993 behaves like finalizes the migration
994 finalizes the migration
995 status: 5, description: "finalizing"
996 behaves like finalizes the migration
997 finalizes the migration
998I, [2023-03-30T11:43:00.508991 #361] INFO -- : Database: 'main', Table: 'ci_runner_machines': Lock Writes
999I, [2023-03-30T11:43:06.986153 #361] INFO -- : Database: 'main', Table: 'p_ci_runner_machine_builds': Lock Writes
1000I, [2023-03-30T11:43:07.234672 #361] INFO -- : Database: 'main', Table: 'ci_cost_settings': Lock Writes
1001ScheduleDisableLegacyOpenSourceLicenseForInactivePublicProjects
1002 on gitlab.com
1003 #up
1004main: == 20220627090231 ScheduleDisableLegacyOpenSourceLicenseForInactivePublicProjects: migrating
1005main: == 20220627090231 ScheduleDisableLegacyOpenSourceLicenseForInactivePublicProjects: migrated (0.0528s)
1006 schedules background jobs for each batch of projects
1007 #down
1008main: == 20220627090231 ScheduleDisableLegacyOpenSourceLicenseForInactivePublicProjects: migrating
1009main: == 20220627090231 ScheduleDisableLegacyOpenSourceLicenseForInactivePublicProjects: migrated (0.0508s)
1010 deletes all batched migration records
1011 on self-managed instances
1012 #up
1013 does not schedule background job
1014 #down
1015 does not delete background job
1016I, [2023-03-30T11:44:01.268287 #361] INFO -- : Database: 'main', Table: 'ci_runner_machines': Lock Writes
1017I, [2023-03-30T11:44:07.708494 #361] INFO -- : Database: 'main', Table: 'p_ci_runner_machine_builds': Lock Writes
1018I, [2023-03-30T11:44:07.953986 #361] INFO -- : Database: 'main', Table: 'ci_cost_settings': Lock Writes
1019RescheduleBackfillImportedIssueSearchData
1020 when BackfillIssueSearchData.max_value is nil
1021 behaves like backfill rescheduler
1022main: == 20220707075300 RescheduleBackfillImportedIssueSearchData: migrating ========
1023main: == 20220707075300 RescheduleBackfillImportedIssueSearchData: migrated (0.1054s)
1024 schedules a new batched migration
1025 when BackfillIssueSearchData.max_value exists
1026 behaves like backfill rescheduler
1027main: == 20220707075300 RescheduleBackfillImportedIssueSearchData: migrating ========
1028main: == 20220707075300 RescheduleBackfillImportedIssueSearchData: migrated (0.0764s)
1029 schedules a new batched migration
1030 when an issue is available
1031 when BackfillIssueSearchData.max_value = Issue.maximum(:id)
1032 behaves like backfill rescheduler
1033main: == 20220707075300 RescheduleBackfillImportedIssueSearchData: migrating ========
1034main: == 20220707075300 RescheduleBackfillImportedIssueSearchData: migrated (0.0706s)
1035 schedules a new batched migration
1036 when BackfillIssueSearchData.max_value > Issue.maximum(:id)
1037 behaves like backfill rescheduler
1038main: == 20220707075300 RescheduleBackfillImportedIssueSearchData: migrating ========
1039main: == 20220707075300 RescheduleBackfillImportedIssueSearchData: migrated (0.0660s)
1040 schedules a new batched migration
1041 when BackfillIssueSearchData.max_value < Issue.maximum(:id)
1042 behaves like backfill rescheduler
1043main: == 20220707075300 RescheduleBackfillImportedIssueSearchData: migrating ========
1044main: == 20220707075300 RescheduleBackfillImportedIssueSearchData: migrated (0.0718s)
1045 schedules a new batched migration
1046I, [2023-03-30T11:45:03.655479 #361] INFO -- : Database: 'main', Table: 'ci_runner_machines': Lock Writes
1047I, [2023-03-30T11:45:10.290247 #361] INFO -- : Database: 'main', Table: 'p_ci_runner_machine_builds': Lock Writes
1048I, [2023-03-30T11:45:10.577789 #361] INFO -- : Database: 'main', Table: 'ci_cost_settings': Lock Writes
1049RemoveJobsForRecalculateVulnerabilitiesOccurrencesUuid
1050 when RecalculateVulnerabilitiesOccurrencesUuid jobs are present
1051main: == 20211207125331 RemoveJobsForRecalculateVulnerabilitiesOccurrencesUuid: migrating
1052main: == 20211207125331 RemoveJobsForRecalculateVulnerabilitiesOccurrencesUuid: migrated (0.0126s)
1053 removes all jobs
1054I, [2023-03-30T11:46:19.552419 #361] INFO -- : Database: 'main', Table: 'ci_runner_machines': Lock Writes
1055I, [2023-03-30T11:46:26.433717 #361] INFO -- : Database: 'main', Table: 'p_ci_runner_machine_builds': Lock Writes
1056I, [2023-03-30T11:46:26.696624 #361] INFO -- : Database: 'main', Table: 'ci_cost_settings': Lock Writes
1057BackfillMemberNamespaceIdForGroupMembers
1058 #up
1059main: == 20220120211832 BackfillMemberNamespaceIdForGroupMembers: migrating =========
1060main: == 20220120211832 BackfillMemberNamespaceIdForGroupMembers: migrated (0.0469s)
1061 schedules background jobs for each batch of group members
1062 #down
1063main: == 20220120211832 BackfillMemberNamespaceIdForGroupMembers: migrating =========
1064main: == 20220120211832 BackfillMemberNamespaceIdForGroupMembers: migrated (0.0542s)
1065 deletes all batched migration records
1066I, [2023-03-30T11:47:34.091084 #361] INFO -- : Database: 'main', Table: 'ci_runner_machines': Lock Writes
1067I, [2023-03-30T11:47:40.970063 #361] INFO -- : Database: 'main', Table: 'p_ci_runner_machine_builds': Lock Writes
1068I, [2023-03-30T11:47:41.217036 #361] INFO -- : Database: 'main', Table: 'ci_cost_settings': Lock Writes
1069PopulateAuditEventStreamingVerificationToken
1070 #up
1071main: == 20220119094503 PopulateAuditEventStreamingVerificationToken: migrating =====
1072main: == 20220119094503 PopulateAuditEventStreamingVerificationToken: migrated (0.0100s)
1073 adds verification tokens to records created before the migration
1074I, [2023-03-30T11:48:45.867537 #361] INFO -- : Database: 'main', Table: 'ci_runner_machines': Lock Writes
1075I, [2023-03-30T11:48:52.522441 #361] INFO -- : Database: 'main', Table: 'p_ci_runner_machine_builds': Lock Writes
1076I, [2023-03-30T11:48:52.786615 #361] INFO -- : Database: 'main', Table: 'ci_cost_settings': Lock Writes
1077BackfillGroupFeatures
1078 #up
1079main: == 20220302114046 BackfillGroupFeatures: migrating ============================
1080main: == 20220302114046 BackfillGroupFeatures: migrated (0.0520s) ===================
1081 schedules background jobs for each batch of namespaces
1082 #down
1083main: == 20220302114046 BackfillGroupFeatures: migrating ============================
1084main: == 20220302114046 BackfillGroupFeatures: migrated (0.0475s) ===================
1085 deletes all batched migration records
1086I, [2023-03-30T11:49:56.037462 #361] INFO -- : Database: 'main', Table: 'ci_runner_machines': Lock Writes
1087I, [2023-03-30T11:50:03.031919 #361] INFO -- : Database: 'main', Table: 'p_ci_runner_machine_builds': Lock Writes
1088I, [2023-03-30T11:50:03.300524 #361] INFO -- : Database: 'main', Table: 'ci_cost_settings': Lock Writes
1089RemoveNullReleases
1090main: == 20220222192525 RemoveNullReleases: migrating ===============================
1091main: == 20220222192525 RemoveNullReleases: migrated (0.0070s) ======================
1092main: == 20220222192525 RemoveNullReleases: reverting ===============================
1093main: == 20220222192525 RemoveNullReleases: reverted (0.0000s) ======================
1094main: == 20220222192524 CreateNotNullConstraintReleasesTag: reverting ===============
1095main: -- transaction_open?()
1096main: -> 0.0000s
1097main: -- transaction_open?()
1098main: -> 0.0000s
1099main: -- execute(" ALTER TABLE releases\n DROP CONSTRAINT IF EXISTS releases_not_null_tag\n")
1100main: -> 0.0013s
1101main: == 20220222192524 CreateNotNullConstraintReleasesTag: reverted (0.0064s) ======
1102main: == 20220222192525 RemoveNullReleases: migrating ===============================
1103main: == 20220222192525 RemoveNullReleases: migrated (0.0128s) ======================
1104 deletes template records and associated data
1105The application_settings (main) table has 1261 columns.
1106Recreating the database
1107Dropped database 'gitlabhq_test'
1108Dropped database 'gitlabhq_test_ci'
1109Created database 'gitlabhq_test'
1110Created database 'gitlabhq_test_ci'
1111Databases re-creation done in 10.680677676999949
1112FixPartitionIdsForCiBuildMetadata
1113 # order random
1114 when on self-managed instance
1115 #up
1116 does not schedule background job
1117 #down
1118 does not delete background job
1119 when on saas
1120 #up
1121ci: == 20230209140102 FixPartitionIdsForCiBuildMetadata: migrating ================
1122ci: == 20230209140102 FixPartitionIdsForCiBuildMetadata: migrated (0.0750s) =======
1123 schedules background jobs for each batch of p_ci_builds_metadata
1124 #down
1125ci: == 20230209140102 FixPartitionIdsForCiBuildMetadata: migrating ================
1126ci: == 20230209140102 FixPartitionIdsForCiBuildMetadata: migrated (0.0768s) =======
1127 deletes all batched migration records
1128I, [2023-03-30T11:51:19.112239 #361] INFO -- : Database: 'main', Table: 'p_ci_runner_machine_builds': Lock Writes
1129I, [2023-03-30T11:51:19.366114 #361] INFO -- : Database: 'main', Table: 'ci_cost_settings': Lock Writes
1130I, [2023-03-30T11:51:26.926216 #361] INFO -- : Database: 'ci', Table: 'bulk_import_export_batches': Lock Writes
1131I, [2023-03-30T11:51:27.044019 #361] INFO -- : Database: 'ci', Table: 'bulk_import_batch_trackers': Lock Writes
1132I, [2023-03-30T11:51:29.415121 #361] INFO -- : Database: 'ci', Table: 'catalog_resources': Lock Writes
1133I, [2023-03-30T11:51:31.407593 #361] INFO -- : Database: 'ci', Table: 'design_management_repositories': Lock Writes
1134I, [2023-03-30T11:51:31.510134 #361] INFO -- : Database: 'ci', Table: 'schema_inconsistencies': Lock Writes
1135I, [2023-03-30T11:51:31.921949 #361] INFO -- : Database: 'ci', Table: 'container_registry_data_repair_details': Lock Writes
1136I, [2023-03-30T11:51:32.281144 #361] INFO -- : Database: 'ci', Table: 'search_indices': Lock Writes
1137I, [2023-03-30T11:51:32.309033 #361] INFO -- : Database: 'ci', Table: 'search_namespace_index_assignments': Lock Writes
1138I, [2023-03-30T11:51:32.757782 #361] INFO -- : Database: 'ci', Table: 'service_desk_custom_email_credentials': Lock Writes
1139I, [2023-03-30T11:51:34.206376 #361] INFO -- : Database: 'ci', Table: 'dora_performance_scores': Lock Writes
1140ScheduleDisableLegacyOpenSourceLicenseForProjectsLessThanOneMb
1141 # order random
1142 when on gitlab.com
1143 #up
1144 schedules background jobs for each batch of project_settings
1145 #down
1146 deletes all batched migration records
1147 when on self-managed instance
1148 #up
1149 does not schedule background job
1150 #down
1151 does not delete background job
1152I, [2023-03-30T11:52:10.714982 #361] INFO -- : Database: 'main', Table: 'ci_runner_machines': Lock Writes
1153I, [2023-03-30T11:52:17.333679 #361] INFO -- : Database: 'main', Table: 'p_ci_runner_machine_builds': Lock Writes
1154I, [2023-03-30T11:52:17.582420 #361] INFO -- : Database: 'main', Table: 'ci_cost_settings': Lock Writes
1155BackfillNamespaceStatisticsWithDependencyProxySize
1156 #up
1157main: == 20220204095121 BackfillNamespaceStatisticsWithDependencyProxySize: migrating
1158main: -- exec_query("SELECT dependency_proxy_manifests.group_id FROM dependency_proxy_manifests\nUNION\nSELECT dependency_proxy_blobs.group_id from dependency_proxy_blobs\n")
1159main: -> 0.0021s
1160main: == 20220204095121 BackfillNamespaceStatisticsWithDependencyProxySize: migrated (0.0081s)
1161 correctly schedules background migrations
1162I, [2023-03-30T11:53:19.574455 #361] INFO -- : Database: 'main', Table: 'ci_runner_machines': Lock Writes
1163I, [2023-03-30T11:53:26.148134 #361] INFO -- : Database: 'main', Table: 'p_ci_runner_machine_builds': Lock Writes
1164I, [2023-03-30T11:53:26.389429 #361] INFO -- : Database: 'main', Table: 'ci_cost_settings': Lock Writes
1165RemoveAllIssuableEscalationStatuses
1166main: == 20220321234317 RemoveAllIssuableEscalationStatuses: migrating ==============
1167main: -- execute("DELETE FROM incident_management_issuable_escalation_statuses\nWHERE id BETWEEN 1 AND 1\n")
1168main: -> 0.0014s
1169main: == 20220321234317 RemoveAllIssuableEscalationStatuses: migrated (0.0127s) =====
1170 removes all escalation status records
1171I, [2023-03-30T11:54:24.471694 #361] INFO -- : Database: 'main', Table: 'ci_runner_machines': Lock Writes
1172I, [2023-03-30T11:54:31.466097 #361] INFO -- : Database: 'main', Table: 'p_ci_runner_machine_builds': Lock Writes
1173I, [2023-03-30T11:54:31.739162 #361] INFO -- : Database: 'main', Table: 'ci_cost_settings': Lock Writes
1174UpdateInvalidDormantUserSetting
1175 # order random
1176 with a row in the application_settings table
1177 with deactivate_dormant_users_period set to a value greater than or equal to 90
1178main: == 20221013154159 UpdateInvalidDormantUserSetting: migrating ==================
1179main: -- execute("update application_settings set deactivate_dormant_users_period=90 where deactivate_dormant_users_period < 90")
1180main: -> 0.0025s
1181main: == 20221013154159 UpdateInvalidDormantUserSetting: migrated (0.0030s) =========
1182 does not update the row
1183 with deactivate_dormant_users_period set to a value less than or equal to 90
1184main: == 20221013154159 UpdateInvalidDormantUserSetting: migrating ==================
1185main: -- execute("update application_settings set deactivate_dormant_users_period=90 where deactivate_dormant_users_period < 90")
1186main: -> 0.0022s
1187main: == 20221013154159 UpdateInvalidDormantUserSetting: migrated (0.0026s) =========
1188 updates the existing row
1189 with no rows in the application_settings table
1190main: == 20221013154159 UpdateInvalidDormantUserSetting: migrating ==================
1191main: -- execute("update application_settings set deactivate_dormant_users_period=90 where deactivate_dormant_users_period < 90")
1192main: -> 0.0021s
1193main: == 20221013154159 UpdateInvalidDormantUserSetting: migrated (0.0023s) =========
1194 does not insert a row
1195I, [2023-03-30T11:55:12.143755 #361] INFO -- : Database: 'main', Table: 'ci_runner_machines': Lock Writes
1196I, [2023-03-30T11:55:18.722104 #361] INFO -- : Database: 'main', Table: 'p_ci_runner_machine_builds': Lock Writes
1197I, [2023-03-30T11:55:19.024648 #361] INFO -- : Database: 'main', Table: 'ci_cost_settings': Lock Writes
1198DropPositionFromSecurityFindings
1199main: == 20220120094340 DropPositionFromSecurityFindings: migrating =================
1200main: -- remove_column(:security_findings, :position, :integer)
1201main: -> 0.0013s
1202main: == 20220120094340 DropPositionFromSecurityFindings: migrated (0.0014s) ========
1203 correctly migrates up and down
1204I, [2023-03-30T11:56:23.081406 #361] INFO -- : Database: 'main', Table: 'ci_runner_machines': Lock Writes
1205I, [2023-03-30T11:56:29.764141 #361] INFO -- : Database: 'main', Table: 'p_ci_runner_machine_builds': Lock Writes
1206I, [2023-03-30T11:56:30.064918 #361] INFO -- : Database: 'main', Table: 'ci_cost_settings': Lock Writes
1207AddWebHookCallsToPlanLimitsPaidTiers
1208 when on Gitlab.com
1209main: == 20220523030805 AddWebHookCallsToPlanLimitsPaidTiers: migrating =============
1210main: -- quote_column_name("web_hook_calls")
1211main: -> 0.0000s
1212main: -- quote("free")
1213main: -> 0.0000s
1214main: -- quote(500)
1215main: -> 0.0000s
1216main: -- execute("INSERT INTO plan_limits (plan_id, \"web_hook_calls\")\nSELECT id, '500' FROM plans WHERE name = 'free' LIMIT 1\nON CONFLICT (plan_id) DO UPDATE SET \"web_hook_calls\" = EXCLUDED.\"web_hook_calls\";\n")
1217main: -> 0.0030s
1218main: -- quote_column_name("web_hook_calls_mid")
1219main: -> 0.0000s
1220main: -- quote("free")
1221main: -> 0.0000s
1222main: -- quote(500)
1223main: -> 0.0000s
1224main: -- execute("INSERT INTO plan_limits (plan_id, \"web_hook_calls_mid\")\nSELECT id, '500' FROM plans WHERE name = 'free' LIMIT 1\nON CONFLICT (plan_id) DO UPDATE SET \"web_hook_calls_mid\" = EXCLUDED.\"web_hook_calls_mid\";\n")
1225main: -> 0.0021s
1226main: -- quote_column_name("web_hook_calls_low")
1227main: -> 0.0000s
1228main: -- quote("free")
1229main: -> 0.0000s
1230main: -- quote(500)
1231main: -> 0.0000s
1232main: -- execute("INSERT INTO plan_limits (plan_id, \"web_hook_calls_low\")\nSELECT id, '500' FROM plans WHERE name = 'free' LIMIT 1\nON CONFLICT (plan_id) DO UPDATE SET \"web_hook_calls_low\" = EXCLUDED.\"web_hook_calls_low\";\n")
1233main: -> 0.0017s
1234main: -- quote_column_name("web_hook_calls")
1235main: -> 0.0000s
1236main: -- quote("bronze")
1237main: -> 0.0000s
1238main: -- quote(4000)
1239main: -> 0.0000s
1240main: -- execute("INSERT INTO plan_limits (plan_id, \"web_hook_calls\")\nSELECT id, '4000' FROM plans WHERE name = 'bronze' LIMIT 1\nON CONFLICT (plan_id) DO UPDATE SET \"web_hook_calls\" = EXCLUDED.\"web_hook_calls\";\n")
1241main: -> 0.0017s
1242main: -- quote_column_name("web_hook_calls_mid")
1243main: -> 0.0000s
1244main: -- quote("bronze")
1245main: -> 0.0000s
1246main: -- quote(2800)
1247main: -> 0.0000s
1248main: -- execute("INSERT INTO plan_limits (plan_id, \"web_hook_calls_mid\")\nSELECT id, '2800' FROM plans WHERE name = 'bronze' LIMIT 1\nON CONFLICT (plan_id) DO UPDATE SET \"web_hook_calls_mid\" = EXCLUDED.\"web_hook_calls_mid\";\n")
1249main: -> 0.0018s
1250main: -- quote_column_name("web_hook_calls_low")
1251main: -> 0.0000s
1252main: -- quote("bronze")
1253main: -> 0.0000s
1254main: -- quote(1600)
1255main: -> 0.0000s
1256main: -- execute("INSERT INTO plan_limits (plan_id, \"web_hook_calls_low\")\nSELECT id, '1600' FROM plans WHERE name = 'bronze' LIMIT 1\nON CONFLICT (plan_id) DO UPDATE SET \"web_hook_calls_low\" = EXCLUDED.\"web_hook_calls_low\";\n")
1257main: -> 0.0016s
1258main: -- quote_column_name("web_hook_calls")
1259main: -> 0.0000s
1260main: -- quote("silver")
1261main: -> 0.0000s
1262main: -- quote(4000)
1263main: -> 0.0000s
1264main: -- execute("INSERT INTO plan_limits (plan_id, \"web_hook_calls\")\nSELECT id, '4000' FROM plans WHERE name = 'silver' LIMIT 1\nON CONFLICT (plan_id) DO UPDATE SET \"web_hook_calls\" = EXCLUDED.\"web_hook_calls\";\n")
1265main: -> 0.0016s
1266main: -- quote_column_name("web_hook_calls_mid")
1267main: -> 0.0000s
1268main: -- quote("silver")
1269main: -> 0.0000s
1270main: -- quote(2800)
1271main: -> 0.0000s
1272main: -- execute("INSERT INTO plan_limits (plan_id, \"web_hook_calls_mid\")\nSELECT id, '2800' FROM plans WHERE name = 'silver' LIMIT 1\nON CONFLICT (plan_id) DO UPDATE SET \"web_hook_calls_mid\" = EXCLUDED.\"web_hook_calls_mid\";\n")
1273main: -> 0.0017s
1274main: -- quote_column_name("web_hook_calls_low")
1275main: -> 0.0000s
1276main: -- quote("silver")
1277main: -> 0.0000s
1278main: -- quote(1600)
1279main: -> 0.0000s
1280main: -- execute("INSERT INTO plan_limits (plan_id, \"web_hook_calls_low\")\nSELECT id, '1600' FROM plans WHERE name = 'silver' LIMIT 1\nON CONFLICT (plan_id) DO UPDATE SET \"web_hook_calls_low\" = EXCLUDED.\"web_hook_calls_low\";\n")
1281main: -> 0.0017s
1282main: -- quote_column_name("web_hook_calls")
1283main: -> 0.0000s
1284main: -- quote("premium")
1285main: -> 0.0000s
1286main: -- quote(4000)
1287main: -> 0.0000s
1288main: -- execute("INSERT INTO plan_limits (plan_id, \"web_hook_calls\")\nSELECT id, '4000' FROM plans WHERE name = 'premium' LIMIT 1\nON CONFLICT (plan_id) DO UPDATE SET \"web_hook_calls\" = EXCLUDED.\"web_hook_calls\";\n")
1289main: -> 0.0017s
1290main: -- quote_column_name("web_hook_calls_mid")
1291main: -> 0.0000s
1292main: -- quote("premium")
1293main: -> 0.0000s
1294main: -- quote(2800)
1295main: -> 0.0000s
1296main: -- execute("INSERT INTO plan_limits (plan_id, \"web_hook_calls_mid\")\nSELECT id, '2800' FROM plans WHERE name = 'premium' LIMIT 1\nON CONFLICT (plan_id) DO UPDATE SET \"web_hook_calls_mid\" = EXCLUDED.\"web_hook_calls_mid\";\n")
1297main: -> 0.0018s
1298main: -- quote_column_name("web_hook_calls_low")
1299main: -> 0.0000s
1300main: -- quote("premium")
1301main: -> 0.0000s
1302main: -- quote(1600)
1303main: -> 0.0000s
1304main: -- execute("INSERT INTO plan_limits (plan_id, \"web_hook_calls_low\")\nSELECT id, '1600' FROM plans WHERE name = 'premium' LIMIT 1\nON CONFLICT (plan_id) DO UPDATE SET \"web_hook_calls_low\" = EXCLUDED.\"web_hook_calls_low\";\n")
1305main: -> 0.0016s
1306main: -- quote_column_name("web_hook_calls")
1307main: -> 0.0000s
1308main: -- quote("premium_trial")
1309main: -> 0.0000s
1310main: -- quote(4000)
1311main: -> 0.0000s
1312main: -- execute("INSERT INTO plan_limits (plan_id, \"web_hook_calls\")\nSELECT id, '4000' FROM plans WHERE name = 'premium_trial' LIMIT 1\nON CONFLICT (plan_id) DO UPDATE SET \"web_hook_calls\" = EXCLUDED.\"web_hook_calls\";\n")
1313main: -> 0.0017s
1314main: -- quote_column_name("web_hook_calls_mid")
1315main: -> 0.0000s
1316main: -- quote("premium_trial")
1317main: -> 0.0000s
1318main: -- quote(2800)
1319main: -> 0.0000s
1320main: -- execute("INSERT INTO plan_limits (plan_id, \"web_hook_calls_mid\")\nSELECT id, '2800' FROM plans WHERE name = 'premium_trial' LIMIT 1\nON CONFLICT (plan_id) DO UPDATE SET \"web_hook_calls_mid\" = EXCLUDED.\"web_hook_calls_mid\";\n")
1321main: -> 0.0016s
1322main: -- quote_column_name("web_hook_calls_low")
1323main: -> 0.0000s
1324main: -- quote("premium_trial")
1325main: -> 0.0000s
1326main: -- quote(1600)
1327main: -> 0.0000s
1328main: -- execute("INSERT INTO plan_limits (plan_id, \"web_hook_calls_low\")\nSELECT id, '1600' FROM plans WHERE name = 'premium_trial' LIMIT 1\nON CONFLICT (plan_id) DO UPDATE SET \"web_hook_calls_low\" = EXCLUDED.\"web_hook_calls_low\";\n")
1329main: -> 0.0016s
1330main: -- quote_column_name("web_hook_calls")
1331main: -> 0.0000s
1332main: -- quote("gold")
1333main: -> 0.0002s
1334main: -- quote(13000)
1335main: -> 0.0000s
1336main: -- execute("INSERT INTO plan_limits (plan_id, \"web_hook_calls\")\nSELECT id, '13000' FROM plans WHERE name = 'gold' LIMIT 1\nON CONFLICT (plan_id) DO UPDATE SET \"web_hook_calls\" = EXCLUDED.\"web_hook_calls\";\n")
1337main: -> 0.0017s
1338main: -- quote_column_name("web_hook_calls_mid")
1339main: -> 0.0000s
1340main: -- quote("gold")
1341main: -> 0.0000s
1342main: -- quote(9000)
1343main: -> 0.0000s
1344main: -- execute("INSERT INTO plan_limits (plan_id, \"web_hook_calls_mid\")\nSELECT id, '9000' FROM plans WHERE name = 'gold' LIMIT 1\nON CONFLICT (plan_id) DO UPDATE SET \"web_hook_calls_mid\" = EXCLUDED.\"web_hook_calls_mid\";\n")
1345main: -> 0.0016s
1346main: -- quote_column_name("web_hook_calls_low")
1347main: -> 0.0000s
1348main: -- quote("gold")
1349main: -> 0.0000s
1350main: -- quote(6000)
1351main: -> 0.0000s
1352main: -- execute("INSERT INTO plan_limits (plan_id, \"web_hook_calls_low\")\nSELECT id, '6000' FROM plans WHERE name = 'gold' LIMIT 1\nON CONFLICT (plan_id) DO UPDATE SET \"web_hook_calls_low\" = EXCLUDED.\"web_hook_calls_low\";\n")
1353main: -> 0.0020s
1354main: -- quote_column_name("web_hook_calls")
1355main: -> 0.0000s
1356main: -- quote("ultimate")
1357main: -> 0.0000s
1358main: -- quote(13000)
1359main: -> 0.0000s
1360main: -- execute("INSERT INTO plan_limits (plan_id, \"web_hook_calls\")\nSELECT id, '13000' FROM plans WHERE name = 'ultimate' LIMIT 1\nON CONFLICT (plan_id) DO UPDATE SET \"web_hook_calls\" = EXCLUDED.\"web_hook_calls\";\n")
1361main: -> 0.0016s
1362main: -- quote_column_name("web_hook_calls_mid")
1363main: -> 0.0000s
1364main: -- quote("ultimate")
1365main: -> 0.0001s
1366main: -- quote(9000)
1367main: -> 0.0000s
1368main: -- execute("INSERT INTO plan_limits (plan_id, \"web_hook_calls_mid\")\nSELECT id, '9000' FROM plans WHERE name = 'ultimate' LIMIT 1\nON CONFLICT (plan_id) DO UPDATE SET \"web_hook_calls_mid\" = EXCLUDED.\"web_hook_calls_mid\";\n")
1369main: -> 0.0017s
1370main: -- quote_column_name("web_hook_calls_low")
1371main: -> 0.0000s
1372main: -- quote("ultimate")
1373main: -> 0.0000s
1374main: -- quote(6000)
1375main: -> 0.0000s
1376main: -- execute("INSERT INTO plan_limits (plan_id, \"web_hook_calls_low\")\nSELECT id, '6000' FROM plans WHERE name = 'ultimate' LIMIT 1\nON CONFLICT (plan_id) DO UPDATE SET \"web_hook_calls_low\" = EXCLUDED.\"web_hook_calls_low\";\n")
1377main: -> 0.0018s
1378main: -- quote_column_name("web_hook_calls")
1379main: -> 0.0000s
1380main: -- quote("ultimate_trial")
1381main: -> 0.0000s
1382main: -- quote(13000)
1383main: -> 0.0000s
1384main: -- execute("INSERT INTO plan_limits (plan_id, \"web_hook_calls\")\nSELECT id, '13000' FROM plans WHERE name = 'ultimate_trial' LIMIT 1\nON CONFLICT (plan_id) DO UPDATE SET \"web_hook_calls\" = EXCLUDED.\"web_hook_calls\";\n")
1385main: -> 0.0016s
1386main: -- quote_column_name("web_hook_calls_mid")
1387main: -> 0.0000s
1388main: -- quote("ultimate_trial")
1389main: -> 0.0000s
1390main: -- quote(9000)
1391main: -> 0.0000s
1392main: -- execute("INSERT INTO plan_limits (plan_id, \"web_hook_calls_mid\")\nSELECT id, '9000' FROM plans WHERE name = 'ultimate_trial' LIMIT 1\nON CONFLICT (plan_id) DO UPDATE SET \"web_hook_calls_mid\" = EXCLUDED.\"web_hook_calls_mid\";\n")
1393main: -> 0.0017s
1394main: -- quote_column_name("web_hook_calls_low")
1395main: -> 0.0000s
1396main: -- quote("ultimate_trial")
1397main: -> 0.0000s
1398main: -- quote(6000)
1399main: -> 0.0000s
1400main: -- execute("INSERT INTO plan_limits (plan_id, \"web_hook_calls_low\")\nSELECT id, '6000' FROM plans WHERE name = 'ultimate_trial' LIMIT 1\nON CONFLICT (plan_id) DO UPDATE SET \"web_hook_calls_low\" = EXCLUDED.\"web_hook_calls_low\";\n")
1401main: -> 0.0018s
1402main: -- quote_column_name("web_hook_calls")
1403main: -> 0.0000s
1404main: -- quote("opensource")
1405main: -> 0.0000s
1406main: -- quote(13000)
1407main: -> 0.0000s
1408main: -- execute("INSERT INTO plan_limits (plan_id, \"web_hook_calls\")\nSELECT id, '13000' FROM plans WHERE name = 'opensource' LIMIT 1\nON CONFLICT (plan_id) DO UPDATE SET \"web_hook_calls\" = EXCLUDED.\"web_hook_calls\";\n")
1409main: -> 0.0016s
1410main: -- quote_column_name("web_hook_calls_mid")
1411main: -> 0.0000s
1412main: -- quote("opensource")
1413main: -> 0.0000s
1414main: -- quote(9000)
1415main: -> 0.0000s
1416main: -- execute("INSERT INTO plan_limits (plan_id, \"web_hook_calls_mid\")\nSELECT id, '9000' FROM plans WHERE name = 'opensource' LIMIT 1\nON CONFLICT (plan_id) DO UPDATE SET \"web_hook_calls_mid\" = EXCLUDED.\"web_hook_calls_mid\";\n")
1417main: -> 0.0018s
1418main: -- quote_column_name("web_hook_calls_low")
1419main: -> 0.0000s
1420main: -- quote("opensource")
1421main: -> 0.0000s
1422main: -- quote(6000)
1423main: -> 0.0000s
1424main: -- execute("INSERT INTO plan_limits (plan_id, \"web_hook_calls_low\")\nSELECT id, '6000' FROM plans WHERE name = 'opensource' LIMIT 1\nON CONFLICT (plan_id) DO UPDATE SET \"web_hook_calls_low\" = EXCLUDED.\"web_hook_calls_low\";\n")
1425main: -> 0.0017s
1426main: == 20220523030805 AddWebHookCallsToPlanLimitsPaidTiers: migrated (0.0557s) ====
1427 correctly migrates up and down
1428 when on self hosted
1429main: == 20220523030805 AddWebHookCallsToPlanLimitsPaidTiers: migrating =============
1430main: == 20220523030805 AddWebHookCallsToPlanLimitsPaidTiers: migrated (0.0004s) ====
1431 does nothing
1432I, [2023-03-30T11:57:24.539946 #361] INFO -- : Database: 'main', Table: 'ci_runner_machines': Lock Writes
1433I, [2023-03-30T11:57:31.062625 #361] INFO -- : Database: 'main', Table: 'p_ci_runner_machine_builds': Lock Writes
1434I, [2023-03-30T11:57:31.327440 #361] INFO -- : Database: 'main', Table: 'ci_cost_settings': Lock Writes
1435FixPartitionIdsForCiBuildReportResult
1436 # order random
1437 when on saas
1438 #up
1439ci: == 20230209090702 FixPartitionIdsForCiBuildReportResult: migrating ============
1440ci: == 20230209090702 FixPartitionIdsForCiBuildReportResult: migrated (0.0667s) ===
1441 schedules background jobs for each batch of ci_build_report_results
1442 #down
1443ci: == 20230209090702 FixPartitionIdsForCiBuildReportResult: migrating ============
1444ci: == 20230209090702 FixPartitionIdsForCiBuildReportResult: migrated (0.0979s) ===
1445 deletes all batched migration records
1446 when on self-managed instance
1447 #up
1448 does not schedule background job
1449 #down
1450 does not delete background job
1451I, [2023-03-30T11:58:07.315098 #361] INFO -- : Database: 'main', Table: 'p_ci_runner_machine_builds': Lock Writes
1452I, [2023-03-30T11:58:07.560908 #361] INFO -- : Database: 'main', Table: 'ci_cost_settings': Lock Writes
1453I, [2023-03-30T11:58:15.052108 #361] INFO -- : Database: 'ci', Table: 'bulk_import_export_batches': Lock Writes
1454I, [2023-03-30T11:58:15.159507 #361] INFO -- : Database: 'ci', Table: 'bulk_import_batch_trackers': Lock Writes
1455I, [2023-03-30T11:58:16.574270 #361] INFO -- : Database: 'ci', Table: 'catalog_resources': Lock Writes
1456I, [2023-03-30T11:58:18.541562 #361] INFO -- : Database: 'ci', Table: 'design_management_repositories': Lock Writes
1457I, [2023-03-30T11:58:18.646574 #361] INFO -- : Database: 'ci', Table: 'schema_inconsistencies': Lock Writes
1458I, [2023-03-30T11:58:19.037823 #361] INFO -- : Database: 'ci', Table: 'container_registry_data_repair_details': Lock Writes
1459I, [2023-03-30T11:58:19.368083 #361] INFO -- : Database: 'ci', Table: 'search_indices': Lock Writes
1460I, [2023-03-30T11:58:19.397122 #361] INFO -- : Database: 'ci', Table: 'search_namespace_index_assignments': Lock Writes
1461I, [2023-03-30T11:58:19.833509 #361] INFO -- : Database: 'ci', Table: 'service_desk_custom_email_credentials': Lock Writes
1462I, [2023-03-30T11:58:21.244210 #361] INFO -- : Database: 'ci', Table: 'dora_performance_scores': Lock Writes
1463RemoveDeactivatedUserHighestRoleStats
1464 #up
1465 when on gitlab.com
1466main: == 20220802204737 RemoveDeactivatedUserHighestRoleStats: migrating ============
1467main: == 20220802204737 RemoveDeactivatedUserHighestRoleStats: migrated (0.0003s) ===
1468 does not change user highest role records
1469 when not on gitlab.com
1470main: == 20220802204737 RemoveDeactivatedUserHighestRoleStats: migrating ============
1471main: == 20220802204737 RemoveDeactivatedUserHighestRoleStats: migrated (0.0530s) ===
1472 removes all user highest role records for deactivated users
1473I, [2023-03-30T11:58:58.068546 #361] INFO -- : Database: 'main', Table: 'ci_runner_machines': Lock Writes
1474I, [2023-03-30T11:59:04.780850 #361] INFO -- : Database: 'main', Table: 'p_ci_runner_machine_builds': Lock Writes
1475I, [2023-03-30T11:59:05.053204 #361] INFO -- : Database: 'main', Table: 'ci_cost_settings': Lock Writes
1476RescheduleBackfillContainerRegistrySizeIntoProjectStatistics
1477main: == 20220802114351 RescheduleBackfillContainerRegistrySizeIntoProjectStatistics: migrating
1478main: == 20220802114351 RescheduleBackfillContainerRegistrySizeIntoProjectStatistics: migrated (0.0005s)
1479 does not schedule background jobs when Gitlab.com is false
1480main: == 20220802114351 RescheduleBackfillContainerRegistrySizeIntoProjectStatistics: migrating
1481main: == 20220802114351 RescheduleBackfillContainerRegistrySizeIntoProjectStatistics: migrated (0.0599s)
1482 schedules background jobs for each batch of container_repository
1483I, [2023-03-30T11:59:49.286876 #361] INFO -- : Database: 'main', Table: 'ci_runner_machines': Lock Writes
1484I, [2023-03-30T11:59:56.067185 #361] INFO -- : Database: 'main', Table: 'p_ci_runner_machine_builds': Lock Writes
1485I, [2023-03-30T11:59:56.322520 #361] INFO -- : Database: 'main', Table: 'ci_cost_settings': Lock Writes
1486UnsetEscalationPoliciesForAlertIncidents
1487 # order random
1488main: == 20220629184402 UnsetEscalationPoliciesForAlertIncidents: migrating =========
1489main: == 20220629184402 UnsetEscalationPoliciesForAlertIncidents: migrated (0.0127s)
1490 removes the escalation policy if the incident corresponds to an alert
1491I, [2023-03-30T12:00:43.674426 #361] INFO -- : Database: 'main', Table: 'ci_runner_machines': Lock Writes
1492I, [2023-03-30T12:00:50.390659 #361] INFO -- : Database: 'main', Table: 'p_ci_runner_machine_builds': Lock Writes
1493I, [2023-03-30T12:00:50.644635 #361] INFO -- : Database: 'main', Table: 'ci_cost_settings': Lock Writes
1494AddPasswordExpirationMigration
1495 # order random
1496 #up
1497main: == 20221008032350 AddPasswordExpirationMigration: migrating ===================
1498main: -- add_column(:application_settings, :password_expiration_enabled, :boolean, {:default=>false, :null=>false, :comment=>"JiHu-specific column"})
1499main: -> 0.0058s
1500main: -- add_column(:application_settings, :password_expires_in_days, :integer, {:default=>90, :null=>false, :comment=>"JiHu-specific column"})
1501main: -> 0.0037s
1502main: -- add_column(:application_settings, :password_expires_notice_before_days, :integer, {:default=>7, :null=>false, :comment=>"JiHu-specific column"})
1503main: -> 0.0036s
1504main: == 20221008032350 AddPasswordExpirationMigration: migrated (0.0137s) ==========
1505 allows to read password expiration fields
1506I, [2023-03-30T12:01:26.651883 #361] INFO -- : Database: 'main', Table: 'ci_runner_machines': Lock Writes
1507I, [2023-03-30T12:01:33.331079 #361] INFO -- : Database: 'main', Table: 'p_ci_runner_machine_builds': Lock Writes
1508I, [2023-03-30T12:01:33.584887 #361] INFO -- : Database: 'main', Table: 'ci_cost_settings': Lock Writes
1509BackfillProjectStatisticsStorageSizeWithoutUploadsSize
1510 # order random
1511main: == 20221104115712 BackfillProjectStatisticsStorageSizeWithoutUploadsSize: migrating
1512main: == 20221104115712 BackfillProjectStatisticsStorageSizeWithoutUploadsSize: migrated (0.0479s)
1513 schedules background jobs for each batch of project_statistics
1514main: == 20221104115712 BackfillProjectStatisticsStorageSizeWithoutUploadsSize: migrating
1515main: == 20221104115712 BackfillProjectStatisticsStorageSizeWithoutUploadsSize: migrated (0.0003s)
1516 does not schedule background jobs when Gitlab.org_or_com? is false
1517The application_settings (main) table has 1223 columns.
1518Recreating the database
1519Dropped database 'gitlabhq_test'
1520Dropped database 'gitlabhq_test_ci'
1521Created database 'gitlabhq_test'
1522Created database 'gitlabhq_test_ci'
1523Databases re-creation done in 10.396531311000217
1524QueueResetStatusOnContainerRepositories
1525 # order random
1526main: == 20221123133054 QueueResetStatusOnContainerRepositories: migrating ==========
1527main: == 20221123133054 QueueResetStatusOnContainerRepositories: migrated (0.0560s) =
1528 schedules a new batched migration
1529 with the container registry disabled
1530main: == 20221123133054 QueueResetStatusOnContainerRepositories: migrating ==========
1531main: == 20221123133054 QueueResetStatusOnContainerRepositories: migrated (0.0003s) =
1532 does not schedule a new batched migration
1533I, [2023-03-30T12:02:32.174768 #361] INFO -- : Database: 'main', Table: 'ci_runner_machines': Lock Writes
1534I, [2023-03-30T12:02:38.883927 #361] INFO -- : Database: 'main', Table: 'p_ci_runner_machine_builds': Lock Writes
1535I, [2023-03-30T12:02:39.139690 #361] INFO -- : Database: 'main', Table: 'ci_cost_settings': Lock Writes
1536CleanupVulnerabilityStateTransitionsWithSameFromStateToState
1537 # order random
1538main: == 20221013215832 CleanupVulnerabilityStateTransitionsWithSameFromStateToState: migrating
1539main: == 20221013215832 CleanupVulnerabilityStateTransitionsWithSameFromStateToState: migrated (0.0021s)
1540 deletes state transitions with no state change
1541I, [2023-03-30T12:03:12.413710 #361] INFO -- : Database: 'main', Table: 'ci_runner_machines': Lock Writes
1542I, [2023-03-30T12:03:19.277940 #361] INFO -- : Database: 'main', Table: 'p_ci_runner_machine_builds': Lock Writes
1543I, [2023-03-30T12:03:19.531504 #361] INFO -- : Database: 'main', Table: 'ci_cost_settings': Lock Writes
1544RemoveTempIndexForProjectStatisticsUploadSizeMigration
1545 # order random
1546main: -- indexes("project_statistics")
1547main: -> 0.0115s
1548main: == 20221221110733 RemoveTempIndexForProjectStatisticsUploadSizeMigration: migrating
1549main: -- view_exists?(:postgres_partitions)
1550main: -> 0.0016s
1551main: -- indexes(:project_statistics)
1552main: -> 0.0108s
1553main: -- remove_index(:project_statistics, {:algorithm=>:concurrently, :name=>"tmp_index_project_statistics_uploads_size"})
1554main: -> 0.0017s
1555main: == 20221221110733 RemoveTempIndexForProjectStatisticsUploadSizeMigration: migrated (0.0377s)
1556main: -- indexes("project_statistics")
1557main: -> 0.0110s
1558main: -- current_schema()
1559main: -> 0.0007s
1560main: -- indexes("project_statistics")
1561main: -> 0.0114s
1562 correctly migrates up and down
1563I, [2023-03-30T12:03:42.725308 #361] INFO -- : Database: 'main', Table: 'ci_runner_machines': Lock Writes
1564I, [2023-03-30T12:03:50.364275 #361] INFO -- : Database: 'main', Table: 'p_ci_runner_machine_builds': Lock Writes
1565I, [2023-03-30T12:03:50.625584 #361] INFO -- : Database: 'main', Table: 'ci_cost_settings': Lock Writes
1566CopyClickhouseConnectionStringToEncryptedVar
1567 # order random
1568main: == 20221219122320 CopyClickhouseConnectionStringToEncryptedVar: migrating =====
1569main: == 20221219122320 CopyClickhouseConnectionStringToEncryptedVar: migrated (0.3138s)
1570 copies the clickhouse_connection_string to the encrypted column
1571I, [2023-03-30T12:04:14.534374 #361] INFO -- : Database: 'main', Table: 'ci_runner_machines': Lock Writes
1572I, [2023-03-30T12:04:21.091288 #361] INFO -- : Database: 'main', Table: 'p_ci_runner_machine_builds': Lock Writes
1573I, [2023-03-30T12:04:21.330798 #361] INFO -- : Database: 'main', Table: 'ci_cost_settings': Lock Writes
1574ClearDuplicateJobsCookies
1575 # order random
1576main: == 20230117114739 ClearDuplicateJobsCookies: migrating ========================
1577main: == 20230117114739 ClearDuplicateJobsCookies: migrated (0.0073s) ===============
1578 deletes duplicate jobs cookies
1579I, [2023-03-30T12:04:46.550495 #361] INFO -- : Database: 'main', Table: 'p_ci_runner_machine_builds': Lock Writes
1580I, [2023-03-30T12:04:46.828445 #361] INFO -- : Database: 'main', Table: 'ci_cost_settings': Lock Writes
1581UpdateIssuesInternalIdScope
1582 # order random
1583 #up
1584main: == 20230224085743 UpdateIssuesInternalIdScope: migrating ======================
1585main: == 20230224085743 UpdateIssuesInternalIdScope: migrated (0.0610s) =============
1586 schedules background migration
1587 #down
1588 does not schedule background migration
1589SwapVulnerabilityUserMentionsNoteIdToBigintForGitlabDotCom
1590 # order random
1591 #up
1592 swaps the integer and bigint columns for GitLab.com, dev, or test
1593 is a no-op for other instances
1594InsertDailyInvitesTrialPlanLimits
1595 # order random
1596 when on gitlab.com
1597main: == 20230316093433 InsertDailyInvitesTrialPlanLimits: migrating ================
1598main: -- quote_column_name("daily_invites")
1599main: -> 0.0000s
1600main: -- quote("premium_trial")
1601main: -> 0.0000s
1602main: -- quote(50)
1603main: -> 0.0000s
1604main: -- execute("INSERT INTO plan_limits (plan_id, \"daily_invites\")\nSELECT id, '50' FROM plans WHERE name = 'premium_trial' LIMIT 1\nON CONFLICT (plan_id) DO UPDATE SET \"daily_invites\" = EXCLUDED.\"daily_invites\";\n")
1605main: -> 0.0019s
1606main: -- quote_column_name("daily_invites")
1607main: -> 0.0000s
1608main: -- quote("ultimate_trial")
1609main: -> 0.0000s
1610main: -- quote(50)
1611main: -> 0.0000s
1612main: -- execute("INSERT INTO plan_limits (plan_id, \"daily_invites\")\nSELECT id, '50' FROM plans WHERE name = 'ultimate_trial' LIMIT 1\nON CONFLICT (plan_id) DO UPDATE SET \"daily_invites\" = EXCLUDED.\"daily_invites\";\n")
1613main: -> 0.0016s
1614main: == 20230316093433 InsertDailyInvitesTrialPlanLimits: migrated (0.0123s) =======
1615 correctly migrates up and down
1616 when on self-managed
1617main: == 20230316093433 InsertDailyInvitesTrialPlanLimits: migrating ================
1618main: == 20230316093433 InsertDailyInvitesTrialPlanLimits: migrated (0.0071s) =======
1619 correctly migrates up and down
1620EnsureDesignUserMentionsNoteIdBigintBackfillIsFinishedForGitlabDotCom
1621 # order random
1622 #up
1623main: == 20230321024333 EnsureDesignUserMentionsNoteIdBigintBackfillIsFinishedForGitlabDotCom: migrating
1624main: == 20230321024333 EnsureDesignUserMentionsNoteIdBigintBackfillIsFinishedForGitlabDotCom: migrated (0.0066s)
1625 ensures the migration is completed for GitLab.com, dev, or test
1626main: == 20230321024333 EnsureDesignUserMentionsNoteIdBigintBackfillIsFinishedForGitlabDotCom: migrating
1627main: == 20230321024333 EnsureDesignUserMentionsNoteIdBigintBackfillIsFinishedForGitlabDotCom: migrated (0.0068s)
1628 skips the check for other instances
1629AddPackageIdCreatedAtDescIndexToPackageFiles
1630 # order random
1631main: == 20230321153035 AddPackageIdCreatedAtDescIndexToPackageFiles: migrating =====
1632main: -- view_exists?(:postgres_partitions)
1633main: -> 0.0015s
1634main: -- index_exists?(:packages_package_files, "package_id, created_at DESC", {:name=>"index_packages_package_files_on_package_id_and_created_at_desc", :algorithm=>:concurrently})
1635main: -> 0.0151s
1636main: -- add_index(:packages_package_files, "package_id, created_at DESC", {:name=>"index_packages_package_files_on_package_id_and_created_at_desc", :algorithm=>:concurrently})
1637main: -> 0.0018s
1638main: == 20230321153035 AddPackageIdCreatedAtDescIndexToPackageFiles: migrated (0.0425s)
1639 correctly migrates up and down
1640Knapsack report was generated. Preview:
1641{
1642 "spec/migrations/change_public_projects_cost_factor_spec.rb": 61.65103521199944,
1643 "spec/migrations/finalize_orphaned_routes_cleanup_spec.rb": 33.185261933999755,
1644 "spec/migrations/20220627090231_schedule_disable_legacy_open_source_license_for_inactive_public_projects_spec.rb": 27.79728237800009,
1645 "spec/migrations/reschedule_backfill_imported_issue_search_data_spec.rb": 31.14371634300005,
1646 "spec/migrations/20211207125331_remove_jobs_for_recalculate_vulnerabilities_occurrences_uuid_spec.rb": 31.682874138999978,
1647 "spec/migrations/backfill_member_namespace_id_for_group_members_spec.rb": 31.289676761999544,
1648 "spec/migrations/populate_audit_event_streaming_verification_token_spec.rb": 29.346939267999915,
1649 "spec/migrations/backfill_group_features_spec.rb": 30.02267948000008,
1650 "spec/migrations/20220222192525_remove_null_releases_spec.rb": 28.12291478000043,
1651 "spec/migrations/20230209140102_fix_partition_ids_for_ci_build_metadata_spec.rb": 24.938593707999644,
1652 "spec/migrations/20220906074449_schedule_disable_legacy_open_source_license_for_projects_less_than_one_mb_spec.rb": 24.076381847000448,
1653 "spec/migrations/20220204095121_backfill_namespace_statistics_with_dependency_proxy_size_spec.rb": 28.139595515999645,
1654 "spec/migrations/20220321234317_remove_all_issuable_escalation_statuses_spec.rb": 26.67326090700044,
1655 "spec/migrations/20221013154159_update_invalid_dormant_user_setting_spec.rb": 22.652722070999516,
1656 "spec/migrations/20220120094340_drop_position_from_security_findings_spec.rb": 29.23682414399991,
1657 "spec/migrations/add_web_hook_calls_to_plan_limits_paid_tiers_spec.rb": 26.267981361999773,
1658 "spec/migrations/20230209090702_fix_partition_ids_for_ci_build_report_result_spec.rb": 24.545432346999405,
1659 "spec/migrations/20220802204737_remove_deactivated_user_highest_role_stats_spec.rb": 21.785285981000015,
1660 "spec/migrations/20220802114351_reschedule_backfill_container_registry_size_into_project_statistics_spec.rb": 21.547416763999536,
1661 "spec/migrations/20220629184402_unset_escalation_policies_for_alert_incidents_spec.rb": 21.82013309500053,
1662 "spec/migrations/20221008032350_add_password_expiration_migration_spec.rb": 17.832476571999905,
1663 "spec/migrations/20221104115712_backfill_project_statistics_storage_size_without_uploads_size_spec.rb": 17.369452777999868,
1664 "spec/migrations/20221123133054_queue_reset_status_on_container_repositories_spec.rb": 16.857458890999624,
1665 "spec/migrations/cleanup_vulnerability_state_transitions_with_same_from_state_to_state_spec.rb": 16.08533627199995,
1666 "spec/migrations/20221221110733_remove_temp_index_for_project_statistics_upload_size_migration_spec.rb": 11.961262424999404,
1667 "spec/migrations/20221219122320_copy_clickhouse_connection_string_to_encrypted_var_spec.rb": 12.479575839999598,
1668 "spec/migrations/20230117114739_clear_duplicate_jobs_cookies_spec.rb": 9.798523209999985,
1669 "spec/migrations/20230224085743_update_issues_internal_id_scope_spec.rb": 8.427307610999378,
1670 "spec/migrations/swap_vulnerability_user_mentions_note_id_to_bigint_for_gitlab_dot_com_spec.rb": 6.979047816000275,
1671 "spec/migrations/insert_daily_invites_trial_plan_limits_spec.rb": 6.676674631000424,
1672 "spec/migrations/ensure_design_user_mentions_note_id_bigint_backfill_is_finished_for_gitlab_dot_com_spec.rb": 5.924759708000238,
1673 "spec/migrations/20230321153035_add_package_id_created_at_desc_index_to_package_files_spec.rb": 3.764833182000075
1674}
1675Knapsack global time execution for tests: 11m 50s
1676Finished in 26 minutes 6 seconds (files took 44.67 seconds to load)
167768 examples, 0 failures
1678Randomized with seed 47963
1679[TEST PROF INFO] Time spent in factories: 00:00.591 (0.04% of total time)
1680RSpec exited with 0.
1681No examples to retry, congrats!
1682 Saving cache for successful job 00:02
1683Not uploading cache ruby-gems-debian-bullseye-ruby-3.0-16 due to policy
1684Not uploading cache gitaly-ruby-gems-debian-bullseye-ruby-3.0-16 due to policy
1685 Uploading artifacts for successful job 00:06
1686Uploading artifacts...
1687coverage/: found 5 matching artifact files and directories
1688crystalball/: found 2 matching artifact files and directories
1689WARNING: deprecations/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab)
1690knapsack/: found 3 matching artifact files and directories
1691WARNING: query_recorder/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab)
1692rspec/: found 14 matching artifact files and directories
1693WARNING: tmp/capybara/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab)
1694log/*.log: found 13 matching artifact files and directories
1695WARNING: Upload request redirected location=https://gitlab.com/api/v4/jobs/4031138344/artifacts?artifact_format=zip&artifact_type=archive&expire_in=31d new-url=https://gitlab.com
1696WARNING: Retrying... context=artifacts-uploader error=request redirected
1697Uploading artifacts as "archive" to coordinator... 201 Created id=4031138344 responseStatus=201 Created token=64_di2wQ
1698Uploading artifacts...
1699rspec/junit_rspec.xml: found 1 matching artifact files and directories
1700WARNING: Upload request redirected location=https://gitlab.com/api/v4/jobs/4031138344/artifacts?artifact_format=gzip&artifact_type=junit&expire_in=31d new-url=https://gitlab.com
1701WARNING: Retrying... context=artifacts-uploader error=request redirected
1702Uploading artifacts as "junit" to coordinator... 201 Created id=4031138344 responseStatus=201 Created token=64_di2wQ
1703 Cleaning up project directory and file based variables 00:00
1704Job succeeded