Skip to content
Snippets Groups Projects

rspec migration pg14 single-db 3/15

Passed Started by
Rajendra Kadam
@rkadam3
1Running with gitlab-runner 16.9.1 (782c6ecb)
2 on green-3.private.runners-manager.gitlab.com/gitlab.com/gitlab-org QuQPoFsC, system ID: s_fc023362bf2f
3 feature flags: FF_NETWORK_PER_BUILD:true, FF_USE_IMPROVED_URL_MASKING:true
4 Resolving secrets 00:00
5 Preparing the "docker+machine" executor 00:09
6Using Docker executor with image registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bookworm-ruby-3.1.patched-golang-1.20-rust-1.73-node-18.17-postgresql-14:rubygems-3.4-git-2.36-lfs-2.9-chrome-120-yarn-1.22-graphicsmagick-1.3.36 ...
7Starting service registry.gitlab.com/gitlab-org/gitlab-build-images:postgres-14-pgvector-0.4.1 ...
8Authenticating with credentials from job payload (GitLab Registry)
9Pulling docker image registry.gitlab.com/gitlab-org/gitlab-build-images:postgres-14-pgvector-0.4.1 ...
10Using docker image sha256:82f132c22567f8ce17cc132c14b2f9aa3eaf9bb5424d91c2d966912433f0257d for registry.gitlab.com/gitlab-org/gitlab-build-images:postgres-14-pgvector-0.4.1 with digest registry.gitlab.com/gitlab-org/gitlab-build-images@sha256:c55e1364ee4327b244a9cfa1750f19feea14fc774eaf792b725967d146eb45f5 ...
11WARNING: Service registry.gitlab.com/gitlab-org/gitlab-build-images:redis-cluster-6.2.12 is already created. Ignoring.
12WARNING: Service registry.gitlab.com/gitlab-org/gitlab-build-images:redis-cluster-6.2.12 is already created. Ignoring.
13Starting service registry.gitlab.com/gitlab-org/gitlab-build-images:redis-cluster-6.2.12 ...
14Authenticating with credentials from job payload (GitLab Registry)
15Pulling docker image registry.gitlab.com/gitlab-org/gitlab-build-images:redis-cluster-6.2.12 ...
16Using docker image sha256:5c5ba5b83d6c60cb0b225bd670b7a43be8c238cc72347d24af57e5027c3648f3 for registry.gitlab.com/gitlab-org/gitlab-build-images:redis-cluster-6.2.12 with digest registry.gitlab.com/gitlab-org/gitlab-build-images@sha256:46aceab84c42d0e819c8e7940f2f98ce9e184785cd7b22d95872024a35f52407 ...
17Starting service redis:6.2-alpine ...
18Pulling docker image redis:6.2-alpine ...
19Using docker image sha256:b6c412dc298714b5c26feca1330d8f743b48caf0b1feeadfd554d7d446f985a5 for redis:6.2-alpine with digest redis@sha256:51d6c56749a4243096327e3fb964a48ed92254357108449cb6e23999c37773c5 ...
20Waiting for services to be up and running (timeout 30 seconds)...
21Authenticating with credentials from job payload (GitLab Registry)
22Pulling docker image registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bookworm-ruby-3.1.patched-golang-1.20-rust-1.73-node-18.17-postgresql-14:rubygems-3.4-git-2.36-lfs-2.9-chrome-120-yarn-1.22-graphicsmagick-1.3.36 ...
23Using docker image sha256:fc7435a87025ef82fcd7c3a7df1e52121e8a88ab05430c94ba7ad5920fecc0d0 for registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bookworm-ruby-3.1.patched-golang-1.20-rust-1.73-node-18.17-postgresql-14:rubygems-3.4-git-2.36-lfs-2.9-chrome-120-yarn-1.22-graphicsmagick-1.3.36 with digest registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bookworm-ruby-3.1.patched-golang-1.20-rust-1.73-node-18.17-postgresql-14@sha256:c129fa1214137f01be7f1412c5233ac179604d32d9d852cbe06113596fb24504 ...
24 Preparing environment 00:00
25Running on runner-quqpofsc-project-278964-concurrent-0 via runner-quqpofsc-private-1709554061-60ad9bc0...
26 Getting source from Git repository 00:01
27Skipping Git repository setup
28Skipping Git checkout
29Skipping Git submodules setup
30 Restoring cache 00:15
31Checking cache for ruby-gems-debian-bookworm-ruby-3.1-17...
32cache.zip is up to date
33Successfully extracted cache
34 Downloading artifacts 00:34
35Downloading artifacts for clone-gitlab-repo (6311410718)...
36Downloading artifacts from coordinator... ok host=storage.googleapis.com id=6311410718 responseStatus=200 OK token=glcbt-65
37WARNING: Part of .git directory is on the list of files to extract
38WARNING: This may introduce unexpected problems
39Downloading artifacts for compile-test-assets (6311410765)...
40Downloading artifacts from coordinator... ok host=storage.googleapis.com id=6311410765 responseStatus=200 OK token=glcbt-65
41Downloading artifacts for detect-tests (6311410787)...
42Downloading artifacts from coordinator... ok host=storage.googleapis.com id=6311410787 responseStatus=200 OK token=glcbt-65
43Downloading artifacts for retrieve-tests-metadata (6311410799)...
44Downloading artifacts from coordinator... ok host=storage.googleapis.com id=6311410799 responseStatus=200 OK token=glcbt-65
45Downloading artifacts for setup-test-env (6311410773)...
46Downloading artifacts from coordinator... ok host=storage.googleapis.com id=6311410773 responseStatus=200 OK token=glcbt-65
47 Executing "step_script" stage of the job script 27:10
48Using docker image sha256:fc7435a87025ef82fcd7c3a7df1e52121e8a88ab05430c94ba7ad5920fecc0d0 for registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bookworm-ruby-3.1.patched-golang-1.20-rust-1.73-node-18.17-postgresql-14:rubygems-3.4-git-2.36-lfs-2.9-chrome-120-yarn-1.22-graphicsmagick-1.3.36 with digest registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bookworm-ruby-3.1.patched-golang-1.20-rust-1.73-node-18.17-postgresql-14@sha256:c129fa1214137f01be7f1412c5233ac179604d32d9d852cbe06113596fb24504 ...
49$ echo $FOSS_ONLY
50$ [ "$FOSS_ONLY" = "1" ] && rm -rf ee/ qa/spec/ee/ qa/qa/specs/features/ee/ qa/qa/ee/ qa/qa/ee.rb
51$ export GOPATH=$CI_PROJECT_DIR/.go
52$ mkdir -p $GOPATH
53$ source scripts/utils.sh
54$ source scripts/prepare_build.sh
55 Installing gems 00:18
732Using two connections, single database config (config/database.yml.postgresql)
733Disabling ci connection in config/database.yml
734Geo DB won't be set up.
735Embedding DB won't be set up.
736 Setting up DBs 00:37
758$ source ./scripts/rspec_helpers.sh
759$ run_timed_command "gem install knapsack --no-document"
760$ gem install knapsack --no-document
761Successfully installed knapsack-4.0.0
7621 gem installed
763==> 'gem install knapsack --no-document' succeeded in 1 seconds.
764$ section_start "gitaly-test-spawn" "Spawning Gitaly"; scripts/gitaly-test-spawn; section_end "gitaly-test-spawn"
765 Spawning Gitaly 00:03
769$ export RSPEC_SKIPPED_TESTS_REPORT_PATH="rspec/skipped_tests-${CI_JOB_ID}.txt"
770$ export RSPEC_RETRIED_TESTS_REPORT_PATH="rspec/retried_tests-${CI_JOB_ID}.txt"
771$ tooling/bin/create_job_metrics_file || true
772[job-metrics] Creating the job metrics file for the CI/CD job.
773$ rspec_parallelized_job "--fail-fast=${RSPEC_FAIL_FAST_THRESHOLD} --tag ~quarantine --tag ~zoekt --tag ~click_house"
774[13:29:16] Starting rspec_parallelized_job
775RETRY_FAILED_TESTS_IN_NEW_PROCESS: true
776KNAPSACK_GENERATE_REPORT: true
777FLAKY_RSPEC_GENERATE_REPORT: true
778KNAPSACK_TEST_FILE_PATTERN: spec/{migrations}{,/**/}*_spec.rb
779KNAPSACK_LOG_LEVEL: debug
780KNAPSACK_REPORT_PATH: knapsack/rspec_migration_pg14_single-db_3_15_278964_report.json
781FLAKY_RSPEC_SUITE_REPORT_PATH: rspec/flaky/report-suite.json
782FLAKY_RSPEC_REPORT_PATH: rspec/flaky/all_rspec_migration_pg14_single-db_3_15_278964_report.json
783NEW_FLAKY_RSPEC_REPORT_PATH: rspec/flaky/new_rspec_migration_pg14_single-db_3_15_278964_report.json
784RSPEC_SKIPPED_TESTS_REPORT_PATH: rspec/skipped_tests-6311411134.txt
785CRYSTALBALL:
786RSPEC_TESTS_MAPPING_ENABLED:
787RSPEC_TESTS_FILTER_FILE:
788Shell set options (set -o) enabled:
789braceexpand on
790hashall on
791interactive-comments on
792pipefail on
793Knapsack report generator started!
794 ██  ██  █████  ██████  ███  ██ ██ ███  ██  ██████ 
795 ██  ██ ██   ██ ██   ██ ████  ██ ██ ████  ██ ██      
796 ██  █  ██ ███████ ██████  ██ ██  ██ ██ ██ ██  ██ ██  ███ 
797 ██ ███ ██ ██   ██ ██   ██ ██  ██ ██ ██ ██  ██ ██ ██  ██ 
798  ███ ███  ██  ██ ██  ██ ██   ████ ██ ██   ████  ██████  
799******************************************************************************
800 Your database has a single connection, and single connections were
801 deprecated in GitLab 15.9 https://docs.gitlab.com/ee/update/deprecations.html#single-database-connection-is-deprecated.
802 Please add a :ci section to your database, following these instructions:
803 https://docs.gitlab.com/ee/install/installation.html#configure-gitlab-db-settings.
804******************************************************************************
805Run options: exclude {:quarantine=>true, :zoekt=>true, :click_house=>true}
806# [RSpecRunTime] Starting RSpec timer...
807[TEST PROF INFO] EventProf enabled (sql.active_record)
808unknown OID 2249: failed to recognize type of 'pg_stat_file'. It will be treated as String.
809Test environment set up in 1.263382235 seconds
810# [RSpecRunTime] Starting example group spec/migrations/20230328100534_truncate_error_tracking_tables_spec.rb. Expected to take 2 minutes 52.79 seconds.
811TruncateErrorTrackingTables
812 when on self-managed
813 when using Main db
814 does not truncate the table
815 when uses CI db
816 does not truncate the table
817# [RSpecRunTime] RSpec elapsed time: 1 minute 13.18 seconds. Current RSS: ~1358M. load average: 1.14 1.35 1.29 1/269 383
818 when on GitLab.com
819 when using Main db
820main: -- execute("TRUNCATE table error_tracking_errors CASCADE")
821main: -> 0.0002s
822 truncates the table
823# [RSpecRunTime] RSpec elapsed time: 1 minute 15.54 seconds. Current RSS: ~1364M. load average: 1.14 1.35 1.29 1/269 384
824 when uses CI db
825 does not truncate the table (PENDING: Skipping because none of the extra databases [:ci] are setup)
826# [RSpecRunTime] RSpec elapsed time: 1 minute 17.74 seconds. Current RSS: ~1357M. load average: 1.13 1.34 1.29 1/269 385
827INFO: analyzing "public.p_ci_builds" inheritance tree
828INFO: analyzing "public.ci_builds"
829INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
830INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
831INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
832INFO: "ci_runner_machine_builds_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
833INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_101"
834INFO: "ci_runner_machine_builds_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
835INFO: analyzing "public.p_ci_job_annotations" inheritance tree
836INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
837INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
838INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
839INFO: analyzing "public.ci_builds_metadata"
840INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
841INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_101"
842INFO: "ci_builds_metadata_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
843INFO: analyzing "public.p_ci_builds" inheritance tree
844INFO: analyzing "public.ci_builds"
845INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
846INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
847INFO: analyzing "public.ci_pipeline_variables"
848INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
849INFO: analyzing "public.p_ci_job_artifacts" inheritance tree
850INFO: analyzing "public.ci_job_artifacts"
851INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
852INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
853INFO: analyzing "public.ci_pipeline_variables"
854INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
855INFO: analyzing "public.p_ci_stages" inheritance tree
856INFO: analyzing "public.ci_stages"
857INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
858# [RSpecRunTime] Finishing example group spec/migrations/20230328100534_truncate_error_tracking_tables_spec.rb. It took 2 minutes 34.41 seconds. Expected to take 2 minutes 52.79 seconds.
859# [RSpecRunTime] RSpec elapsed time: 2 minutes 37.65 seconds. Current RSS: ~1343M. load average: 1.10 1.29 1.27 1/266 387
860# [RSpecRunTime] Starting example group spec/migrations/20230224085743_update_issues_internal_id_scope_spec.rb. Expected to take 1 minute 17.3 seconds.
861UpdateIssuesInternalIdScope
862 #down
863 does not schedule background migration
864# [RSpecRunTime] RSpec elapsed time: 3 minutes 48.93 seconds. Current RSS: ~1353M. load average: 1.24 1.27 1.27 1/265 388
865 #up
866main: == [advisory_lock_connection] object_id: 41085140, pg_backend_pid: 131
867main: == 20230224085743 UpdateIssuesInternalIdScope: migrating ======================
868main: == 20230224085743 UpdateIssuesInternalIdScope: migrated (0.0598s) =============
869main: == [advisory_lock_connection] object_id: 41085140, pg_backend_pid: 131
870 schedules background migration
871# [RSpecRunTime] RSpec elapsed time: 3 minutes 51.26 seconds. Current RSS: ~1348M. load average: 1.24 1.27 1.27 1/265 389
872INFO: analyzing "public.p_ci_builds" inheritance tree
873INFO: analyzing "public.ci_builds"
874INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
875INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
876INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
877INFO: "ci_runner_machine_builds_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
878INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_101"
879INFO: "ci_runner_machine_builds_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
880INFO: analyzing "public.p_ci_job_annotations" inheritance tree
881INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
882INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
883INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
884INFO: analyzing "public.ci_builds_metadata"
885INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
886INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_101"
887INFO: "ci_builds_metadata_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
888INFO: analyzing "public.p_ci_builds" inheritance tree
889INFO: analyzing "public.ci_builds"
890INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
891INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
892INFO: analyzing "public.ci_pipeline_variables"
893INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
894INFO: analyzing "public.p_ci_job_artifacts" inheritance tree
895INFO: analyzing "public.ci_job_artifacts"
896INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
897INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
898INFO: analyzing "public.ci_pipeline_variables"
899INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
900INFO: analyzing "public.p_ci_stages" inheritance tree
901INFO: analyzing "public.ci_stages"
902INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
903# [RSpecRunTime] Finishing example group spec/migrations/20230224085743_update_issues_internal_id_scope_spec.rb. It took 2 minutes 40.29 seconds. Expected to take 1 minute 17.3 seconds.
904# [RSpecRunTime] RSpec elapsed time: 5 minutes 17.99 seconds. Current RSS: ~1344M. load average: 1.07 1.21 1.25 1/265 391
905# [RSpecRunTime] Starting example group spec/migrations/ensure_commit_user_mentions_note_id_bigint_backfill_is_finished_for_gitlab_dot_com_spec.rb. Expected to take 1 minute 15.65 seconds.
906EnsureCommitUserMentionsNoteIdBigintBackfillIsFinishedForGitlabDotCom
907 #up
908main: == [advisory_lock_connection] object_id: 69671780, pg_backend_pid: 141
909main: == 20230313031629 EnsureCommitUserMentionsNoteIdBigintBackfillIsFinishedForGitlabDotCom: migrating
910main: == 20230313031629 EnsureCommitUserMentionsNoteIdBigintBackfillIsFinishedForGitlabDotCom: migrated (0.0108s)
911main: == [advisory_lock_connection] object_id: 69671780, pg_backend_pid: 141
912 ensures the migration is completed for GitLab.com, dev, or test
913main: == [advisory_lock_connection] object_id: 70521880, pg_backend_pid: 143
914main: == 20230313031629 EnsureCommitUserMentionsNoteIdBigintBackfillIsFinishedForGitlabDotCom: migrating
915main: == 20230313031629 EnsureCommitUserMentionsNoteIdBigintBackfillIsFinishedForGitlabDotCom: migrated (0.0085s)
916main: == [advisory_lock_connection] object_id: 70521880, pg_backend_pid: 143
917 skips the check for other instances
918# [RSpecRunTime] RSpec elapsed time: 6 minutes 31.16 seconds. Current RSS: ~1350M. load average: 1.26 1.22 1.25 1/265 392
919INFO: analyzing "public.p_ci_builds" inheritance tree
920INFO: analyzing "public.ci_builds"
921INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
922INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
923INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
924INFO: "ci_runner_machine_builds_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
925INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_101"
926INFO: "ci_runner_machine_builds_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
927INFO: analyzing "public.p_ci_job_annotations" inheritance tree
928INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
929INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
930INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
931INFO: analyzing "public.ci_builds_metadata"
932INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
933INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_101"
934INFO: "ci_builds_metadata_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
935INFO: analyzing "public.p_ci_builds" inheritance tree
936INFO: analyzing "public.ci_builds"
937INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
938INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
939INFO: analyzing "public.ci_pipeline_variables"
940INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
941INFO: analyzing "public.p_ci_job_artifacts" inheritance tree
942INFO: analyzing "public.ci_job_artifacts"
943INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
944INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
945INFO: analyzing "public.ci_pipeline_variables"
946INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
947INFO: analyzing "public.p_ci_stages" inheritance tree
948INFO: analyzing "public.ci_stages"
949INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
950# [RSpecRunTime] Finishing example group spec/migrations/ensure_commit_user_mentions_note_id_bigint_backfill_is_finished_for_gitlab_dot_com_spec.rb. It took 2 minutes 40.19 seconds. Expected to take 1 minute 15.65 seconds.
951# [RSpecRunTime] RSpec elapsed time: 7 minutes 58.22 seconds. Current RSS: ~1344M. load average: 1.12 1.17 1.22 1/265 393
952# [RSpecRunTime] Starting example group spec/migrations/20230330103104_reschedule_migrate_evidences_spec.rb. Expected to take 1 minute 12.99 seconds.
953RescheduleMigrateEvidences
954 #up
955main: == [advisory_lock_connection] object_id: 98069500, pg_backend_pid: 154
956main: == 20230330103104 RescheduleMigrateEvidences: migrating =======================
957main: == 20230330103104 RescheduleMigrateEvidences: migrated (0.0102s) ==============
958main: == [advisory_lock_connection] object_id: 98069500, pg_backend_pid: 154
959 does not schedule a batched background migration
960# [RSpecRunTime] RSpec elapsed time: 9 minutes 8.13 seconds. Current RSS: ~1345M. load average: 1.05 1.13 1.20 1/265 394
961 #down
962main: == [advisory_lock_connection] object_id: 98942960, pg_backend_pid: 156
963main: == 20230330103104 RescheduleMigrateEvidences: migrating =======================
964main: == 20230330103104 RescheduleMigrateEvidences: migrated (0.0095s) ==============
965main: == [advisory_lock_connection] object_id: 98942960, pg_backend_pid: 156
966 deletes all batched migration records
967# [RSpecRunTime] RSpec elapsed time: 9 minutes 10.74 seconds. Current RSS: ~1349M. load average: 1.05 1.13 1.20 1/265 395
968INFO: analyzing "public.p_ci_builds" inheritance tree
969INFO: analyzing "public.ci_builds"
970INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
971INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
972INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
973INFO: "ci_runner_machine_builds_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
974INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_101"
975INFO: "ci_runner_machine_builds_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
976INFO: analyzing "public.p_ci_job_annotations" inheritance tree
977INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
978INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
979INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
980INFO: analyzing "public.ci_builds_metadata"
981INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
982INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_101"
983INFO: "ci_builds_metadata_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
984INFO: analyzing "public.p_ci_builds" inheritance tree
985INFO: analyzing "public.ci_builds"
986INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
987INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
988INFO: analyzing "public.ci_pipeline_variables"
989INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
990INFO: analyzing "public.p_ci_job_artifacts" inheritance tree
991INFO: analyzing "public.ci_job_artifacts"
992INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
993INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
994INFO: analyzing "public.ci_pipeline_variables"
995INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
996INFO: analyzing "public.p_ci_stages" inheritance tree
997INFO: analyzing "public.ci_stages"
998INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
999# [RSpecRunTime] Finishing example group spec/migrations/20230330103104_reschedule_migrate_evidences_spec.rb. It took 2 minutes 34.59 seconds. Expected to take 1 minute 12.99 seconds.
1000# [RSpecRunTime] RSpec elapsed time: 10 minutes 32.84 seconds. Current RSS: ~1343M. load average: 0.91 1.07 1.17 1/265 396
1001# [RSpecRunTime] Starting example group spec/migrations/20230412185837_queue_populate_vulnerability_dismissal_fields_spec.rb. Expected to take 1 minute 9.6 seconds.
1002QueuePopulateVulnerabilityDismissalFields
1003 #up
1004main: == [advisory_lock_connection] object_id: 125332340, pg_backend_pid: 167
1005main: == 20230412185837 QueuePopulateVulnerabilityDismissalFields: migrating ========
1006main: == 20230412185837 QueuePopulateVulnerabilityDismissalFields: migrated (0.0576s)
1007main: == [advisory_lock_connection] object_id: 125332340, pg_backend_pid: 167
1008 schedules a new batched migration
1009# [RSpecRunTime] RSpec elapsed time: 11 minutes 42.94 seconds. Current RSS: ~1340M. load average: 0.86 1.01 1.14 1/265 397
1010 #down
1011main: == [advisory_lock_connection] object_id: 126482800, pg_backend_pid: 170
1012main: == 20230412185837 QueuePopulateVulnerabilityDismissalFields: migrating ========
1013main: == 20230412185837 QueuePopulateVulnerabilityDismissalFields: migrated (0.0564s)
1014main: == [advisory_lock_connection] object_id: 126482800, pg_backend_pid: 170
1015 deletes all batched migration records
1016# [RSpecRunTime] RSpec elapsed time: 11 minutes 45.54 seconds. Current RSS: ~1343M. load average: 0.86 1.01 1.14 2/265 398
1017The application_settings (main) table has 1203 columns.
1018Recreating the database
1019Dropped database 'gitlabhq_test'
1020Created database 'gitlabhq_test'
1021main: == [advisory_lock_connection] object_id: 126644720, pg_backend_pid: 177
1022main: == [advisory_lock_connection] object_id: 126644720, pg_backend_pid: 177
1023Databases re-creation done in 5.946115118000307
1024# [RSpecRunTime] Finishing example group spec/migrations/20230412185837_queue_populate_vulnerability_dismissal_fields_spec.rb. It took 1 minute 18.81 seconds. Expected to take 1 minute 9.6 seconds.
1025# [RSpecRunTime] RSpec elapsed time: 11 minutes 51.7 seconds. Current RSS: ~1336M. load average: 0.87 1.01 1.14 1/265 400
1026# [RSpecRunTime] Starting example group spec/migrations/add_type_to_http_integrations_spec.rb. Expected to take 1 minute 3.24 seconds.
1027AddTypeToHttpIntegrations
1028main: == [advisory_lock_connection] object_id: 136644160, pg_backend_pid: 183
1029main: == 20230428165514 AddTypeToHttpIntegrations: migrating ========================
1030main: -- add_column(:alert_management_http_integrations, :type_identifier, :integer, {:default=>0, :null=>false, :limit=>2})
1031main: -> 0.0023s
1032main: == 20230428165514 AddTypeToHttpIntegrations: migrated (0.0105s) ===============
1033main: == [advisory_lock_connection] object_id: 136644160, pg_backend_pid: 183
1034 correctly migrates up and down
1035INFO: analyzing "public.p_ci_builds" inheritance tree
1036INFO: analyzing "public.ci_builds"
1037INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1038INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
1039INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
1040INFO: "ci_runner_machine_builds_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1041INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_101"
1042INFO: "ci_runner_machine_builds_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1043INFO: analyzing "public.p_ci_job_annotations" inheritance tree
1044INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
1045INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1046INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
1047INFO: analyzing "public.ci_builds_metadata"
1048INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1049INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_101"
1050INFO: "ci_builds_metadata_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1051INFO: analyzing "public.p_ci_builds" inheritance tree
1052INFO: analyzing "public.ci_builds"
1053INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1054INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1055INFO: analyzing "public.ci_pipeline_variables"
1056INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1057INFO: analyzing "public.p_ci_job_artifacts" inheritance tree
1058INFO: analyzing "public.ci_job_artifacts"
1059INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1060INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1061INFO: analyzing "public.ci_pipeline_variables"
1062INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1063INFO: analyzing "public.p_ci_stages" inheritance tree
1064INFO: analyzing "public.ci_stages"
1065INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1066# [RSpecRunTime] Finishing example group spec/migrations/add_type_to_http_integrations_spec.rb. It took 2 minutes 7.18 seconds. Expected to take 1 minute 3.24 seconds.
1067# [RSpecRunTime] RSpec elapsed time: 13 minutes 58.92 seconds. Current RSS: ~1331M. load average: 0.91 0.98 1.11 1/265 401
1068# [RSpecRunTime] Starting example group spec/migrations/20230522111534_reschedule_migration_for_links_from_metadata_spec.rb. Expected to take 1 minute 1.6 seconds.
1069RescheduleMigrationForLinksFromMetadata
1070 #up
1071main: == [advisory_lock_connection] object_id: 161054340, pg_backend_pid: 193
1072main: == 20230522111534 RescheduleMigrationForLinksFromMetadata: migrating ==========
1073main: == 20230522111534 RescheduleMigrationForLinksFromMetadata: migrated (0.0625s) =
1074main: == [advisory_lock_connection] object_id: 161054340, pg_backend_pid: 193
1075 schedules a batched background migration
1076# [RSpecRunTime] RSpec elapsed time: 14 minutes 53.59 seconds. Current RSS: ~1323M. load average: 0.92 0.97 1.09 1/265 402
1077 #down
1078main: == [advisory_lock_connection] object_id: 162046780, pg_backend_pid: 195
1079main: == 20230522111534 RescheduleMigrationForLinksFromMetadata: migrating ==========
1080main: == 20230522111534 RescheduleMigrationForLinksFromMetadata: migrated (0.0662s) =
1081main: == [advisory_lock_connection] object_id: 162046780, pg_backend_pid: 195
1082 deletes all batched migration records
1083# [RSpecRunTime] RSpec elapsed time: 14 minutes 56.07 seconds. Current RSS: ~1337M. load average: 0.92 0.97 1.09 1/265 403
1084INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
1085INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
1086INFO: "ci_runner_machine_builds_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1087INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_101"
1088INFO: "ci_runner_machine_builds_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1089INFO: analyzing "public.p_ci_job_annotations" inheritance tree
1090INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
1091INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1092INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
1093INFO: analyzing "public.ci_builds_metadata"
1094INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1095INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_101"
1096INFO: "ci_builds_metadata_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1097INFO: analyzing "public.p_ci_builds" inheritance tree
1098INFO: analyzing "public.ci_builds"
1099INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1100INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1101INFO: analyzing "public.ci_pipeline_variables"
1102INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1103INFO: analyzing "public.p_ci_job_artifacts" inheritance tree
1104INFO: analyzing "public.ci_job_artifacts"
1105INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1106INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1107INFO: analyzing "public.ci_pipeline_variables"
1108INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1109INFO: analyzing "public.p_ci_stages" inheritance tree
1110INFO: analyzing "public.ci_stages"
1111INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1112# [RSpecRunTime] Finishing example group spec/migrations/20230522111534_reschedule_migration_for_links_from_metadata_spec.rb. It took 2 minutes 5.71 seconds. Expected to take 1 minute 1.6 seconds.
1113# [RSpecRunTime] RSpec elapsed time: 16 minutes 4.67 seconds. Current RSS: ~1332M. load average: 0.95 0.98 1.08 1/265 404
1114# [RSpecRunTime] Starting example group spec/migrations/20230723203612_backfill_default_branch_protection_application_setting_spec.rb. Expected to take 47.66 seconds.
1115BackfillDefaultBranchProtectionApplicationSetting
1116main: == [advisory_lock_connection] object_id: 182206160, pg_backend_pid: 205
1117main: == 20230723203612 BackfillDefaultBranchProtectionApplicationSetting: migrating
1118main: == 20230723203612 BackfillDefaultBranchProtectionApplicationSetting: migrated (0.5695s)
1119main: == [advisory_lock_connection] object_id: 182206160, pg_backend_pid: 205
1120 schedules a new batched migration
1121INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
1122INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
1123INFO: "ci_runner_machine_builds_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1124INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_101"
1125INFO: "ci_runner_machine_builds_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1126INFO: analyzing "public.p_ci_job_annotations" inheritance tree
1127INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
1128INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1129INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
1130INFO: analyzing "public.ci_builds_metadata"
1131INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1132INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_101"
1133INFO: "ci_builds_metadata_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1134INFO: analyzing "public.p_ci_builds" inheritance tree
1135INFO: analyzing "public.ci_builds"
1136INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1137INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1138INFO: analyzing "public.ci_pipeline_variables"
1139INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1140INFO: analyzing "public.p_ci_job_artifacts" inheritance tree
1141INFO: analyzing "public.ci_job_artifacts"
1142INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1143INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1144INFO: analyzing "public.ci_pipeline_variables"
1145INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1146INFO: analyzing "public.p_ci_stages" inheritance tree
1147INFO: analyzing "public.ci_stages"
1148INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1149# [RSpecRunTime] Finishing example group spec/migrations/20230723203612_backfill_default_branch_protection_application_setting_spec.rb. It took 1 minute 31.51 seconds. Expected to take 47.66 seconds.
1150# [RSpecRunTime] RSpec elapsed time: 17 minutes 36.22 seconds. Current RSS: ~1326M. load average: 0.83 0.94 1.06 1/265 405
1151# [RSpecRunTime] Starting example group spec/migrations/20230809104753_swap_epic_user_mentions_note_id_to_bigint_for_self_hosts_spec.rb. Expected to take 45.14 seconds.
1152SwapEpicUserMentionsNoteIdToBigintForSelfHosts
1153 #up
1154 when GitLab.com, dev, or test
1155 does not swap the columns
1156# [RSpecRunTime] RSpec elapsed time: 18 minutes 6.63 seconds. Current RSS: ~1327M. load average: 0.90 0.95 1.06 1/265 406
1157 when self-managed instance with the columns already swapped
1158main: == [advisory_lock_connection] object_id: 197685720, pg_backend_pid: 217
1159main: == 20230809104753 SwapEpicUserMentionsNoteIdToBigintForSelfHosts: migrating ===
1160main: -- column_exists?("epic_user_mentions", "note_id_convert_to_bigint")
1161main: -> 0.0035s
1162main: -- columns("epic_user_mentions")
1163main: -> 0.0031s
1164main: == 20230809104753 SwapEpicUserMentionsNoteIdToBigintForSelfHosts: migrated (0.0151s)
1165main: == [advisory_lock_connection] object_id: 197685720, pg_backend_pid: 217
1166 does not swap the columns
1167# [RSpecRunTime] RSpec elapsed time: 18 minutes 8.71 seconds. Current RSS: ~1340M. load average: 0.83 0.93 1.05 1/265 407
1168 when self-managed instance with the `note_id_convert_to_bigint` column already dropped
1169 does not swap the columns
1170# [RSpecRunTime] RSpec elapsed time: 18 minutes 11.17 seconds. Current RSS: ~1336M. load average: 0.83 0.93 1.05 1/265 408
1171 when self-managed instance
1172 swaps the columns
1173# [RSpecRunTime] RSpec elapsed time: 18 minutes 13.94 seconds. Current RSS: ~1326M. load average: 0.92 0.95 1.06 1/265 409
1174INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
1175INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
1176INFO: "ci_runner_machine_builds_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1177INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_101"
1178INFO: "ci_runner_machine_builds_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1179INFO: analyzing "public.p_ci_job_annotations" inheritance tree
1180INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
1181INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1182INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
1183INFO: analyzing "public.ci_builds_metadata"
1184INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1185INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_101"
1186INFO: "ci_builds_metadata_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1187INFO: analyzing "public.p_ci_builds" inheritance tree
1188INFO: analyzing "public.ci_builds"
1189INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1190INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1191INFO: analyzing "public.ci_pipeline_variables"
1192INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1193INFO: analyzing "public.p_ci_job_artifacts" inheritance tree
1194INFO: analyzing "public.ci_job_artifacts"
1195INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1196INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1197INFO: analyzing "public.ci_pipeline_variables"
1198INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1199INFO: analyzing "public.p_ci_stages" inheritance tree
1200INFO: analyzing "public.ci_stages"
1201INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1202# [RSpecRunTime] Finishing example group spec/migrations/20230809104753_swap_epic_user_mentions_note_id_to_bigint_for_self_hosts_spec.rb. It took 1 minute 14.25 seconds. Expected to take 45.14 seconds.
1203# [RSpecRunTime] RSpec elapsed time: 18 minutes 50.51 seconds. Current RSS: ~1321M. load average: 0.96 0.96 1.05 1/265 410
1204# [RSpecRunTime] Starting example group spec/migrations/20230724164745_queue_delete_orphaned_transferred_project_approval_rules_spec.rb. Expected to take 42.61 seconds.
1205QueueDeleteOrphanedTransferredProjectApprovalRules
1206main: == [advisory_lock_connection] object_id: 212623920, pg_backend_pid: 230
1207main: == 20230724164745 QueueDeleteOrphanedTransferredProjectApprovalRules: migrating
1208main: == 20230724164745 QueueDeleteOrphanedTransferredProjectApprovalRules: migrated (0.0556s)
1209main: == [advisory_lock_connection] object_id: 212623920, pg_backend_pid: 230
1210 schedules a new batched migration
1211INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
1212INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
1213INFO: "ci_runner_machine_builds_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1214INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_101"
1215INFO: "ci_runner_machine_builds_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1216INFO: analyzing "public.p_ci_job_annotations" inheritance tree
1217INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
1218INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1219INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
1220INFO: analyzing "public.ci_builds_metadata"
1221INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1222INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_101"
1223INFO: "ci_builds_metadata_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1224INFO: analyzing "public.p_ci_builds" inheritance tree
1225INFO: analyzing "public.ci_builds"
1226INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1227INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1228INFO: analyzing "public.ci_pipeline_variables"
1229INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1230INFO: analyzing "public.p_ci_job_artifacts" inheritance tree
1231INFO: analyzing "public.ci_job_artifacts"
1232INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1233INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1234INFO: analyzing "public.ci_pipeline_variables"
1235INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1236INFO: analyzing "public.p_ci_stages" inheritance tree
1237INFO: analyzing "public.ci_stages"
1238INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1239# [RSpecRunTime] Finishing example group spec/migrations/20230724164745_queue_delete_orphaned_transferred_project_approval_rules_spec.rb. It took 1 minute 30.39 seconds. Expected to take 42.61 seconds.
1240# [RSpecRunTime] RSpec elapsed time: 20 minutes 20.94 seconds. Current RSS: ~1315M. load average: 0.88 0.94 1.03 1/265 411
1241# [RSpecRunTime] Starting example group spec/migrations/20230814144045_swap_timelogs_note_id_to_bigint_for_self_hosts_spec.rb. Expected to take 40.07 seconds.
1242SwapTimelogsNoteIdToBigintForSelfHosts
1243 #up
1244 when GitLab.com, dev, or test
1245 behaves like column `note_id_convert_to_bigint` is already dropped
1246 does not swaps the columns
1247# [RSpecRunTime] RSpec elapsed time: 20 minutes 50.93 seconds. Current RSS: ~1313M. load average: 0.85 0.93 1.03 1/265 412
1248 when self-managed instance with the `note_id_convert_to_bigint` column already dropped
1249 behaves like column `note_id_convert_to_bigint` is already dropped
1250 does not swaps the columns
1251# [RSpecRunTime] RSpec elapsed time: 20 minutes 53.3 seconds. Current RSS: ~1314M. load average: 0.86 0.93 1.02 1/265 413
1252 when self-managed instance columns already swapped
1253 does not swaps the columns
1254# [RSpecRunTime] RSpec elapsed time: 20 minutes 55.41 seconds. Current RSS: ~1316M. load average: 0.86 0.93 1.02 1/265 414
1255 when self-managed instance
1256 swaps the columns
1257# [RSpecRunTime] RSpec elapsed time: 20 minutes 57.98 seconds. Current RSS: ~1313M. load average: 0.87 0.93 1.02 1/265 415
1258INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
1259INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
1260INFO: "ci_runner_machine_builds_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1261INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_101"
1262INFO: "ci_runner_machine_builds_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1263INFO: analyzing "public.p_ci_job_annotations" inheritance tree
1264INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
1265INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1266INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
1267INFO: analyzing "public.ci_builds_metadata"
1268INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1269INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_101"
1270INFO: "ci_builds_metadata_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1271INFO: analyzing "public.p_ci_builds" inheritance tree
1272INFO: analyzing "public.ci_builds"
1273INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1274INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1275INFO: analyzing "public.ci_pipeline_variables"
1276INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1277INFO: analyzing "public.p_ci_job_artifacts" inheritance tree
1278INFO: analyzing "public.ci_job_artifacts"
1279INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1280INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1281INFO: analyzing "public.ci_pipeline_variables"
1282INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1283INFO: analyzing "public.p_ci_stages" inheritance tree
1284INFO: analyzing "public.ci_stages"
1285INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1286# [RSpecRunTime] Finishing example group spec/migrations/20230814144045_swap_timelogs_note_id_to_bigint_for_self_hosts_spec.rb. It took 1 minute 14.91 seconds. Expected to take 40.07 seconds.
1287# [RSpecRunTime] RSpec elapsed time: 21 minutes 35.88 seconds. Current RSS: ~1367M. load average: 0.88 0.93 1.02 1/265 416
1288# [RSpecRunTime] Starting example group spec/migrations/20230815140656_queue_populate_denormalized_columns_for_sbom_occurrences_spec.rb. Expected to take 31.44 seconds.
1289QueuePopulateDenormalizedColumnsForSbomOccurrences
1290main: == [advisory_lock_connection] object_id: 241116660, pg_backend_pid: 256
1291main: == 20230815140656 QueuePopulateDenormalizedColumnsForSbomOccurrences: migrating
1292main: == 20230815140656 QueuePopulateDenormalizedColumnsForSbomOccurrences: migrated (0.0573s)
1293main: == [advisory_lock_connection] object_id: 241116660, pg_backend_pid: 256
1294 schedules a new batched migration
1295INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
1296INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
1297INFO: "ci_runner_machine_builds_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1298INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_101"
1299INFO: "ci_runner_machine_builds_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1300INFO: analyzing "public.p_ci_job_annotations" inheritance tree
1301INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
1302INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1303INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
1304INFO: analyzing "public.ci_builds_metadata"
1305INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1306INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_101"
1307INFO: "ci_builds_metadata_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1308INFO: analyzing "public.p_ci_builds" inheritance tree
1309INFO: analyzing "public.ci_builds"
1310INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1311INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1312INFO: analyzing "public.ci_pipeline_variables"
1313INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1314INFO: analyzing "public.p_ci_job_artifacts" inheritance tree
1315INFO: analyzing "public.ci_job_artifacts"
1316INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1317INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1318INFO: analyzing "public.ci_pipeline_variables"
1319INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1320INFO: analyzing "public.p_ci_stages" inheritance tree
1321INFO: analyzing "public.ci_stages"
1322INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1323# [RSpecRunTime] Finishing example group spec/migrations/20230815140656_queue_populate_denormalized_columns_for_sbom_occurrences_spec.rb. It took 1 minute 7.49 seconds. Expected to take 31.44 seconds.
1324# [RSpecRunTime] RSpec elapsed time: 22 minutes 43.41 seconds. Current RSS: ~1363M. load average: 0.77 0.87 0.99 1/265 417
1325# [RSpecRunTime] Starting example group spec/migrations/20230929155123_migrate_disable_merge_trains_value_spec.rb. Expected to take 27.77 seconds.
1326MigrateDisableMergeTrainsValue
1327 #up
1328 migrates the flag value into the setting value
1329# [RSpecRunTime] RSpec elapsed time: 23 minutes 8.99 seconds. Current RSS: ~1356M. load average: 0.79 0.87 0.99 1/265 418
1330 #down
1331 reverts the migration
1332# [RSpecRunTime] RSpec elapsed time: 23 minutes 11.14 seconds. Current RSS: ~1363M. load average: 0.79 0.87 0.99 1/265 419
1333INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1334INFO: analyzing "public.ci_pipeline_variables"
1335INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1336INFO: analyzing "public.p_ci_job_artifacts" inheritance tree
1337INFO: analyzing "public.ci_job_artifacts"
1338INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1339INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1340INFO: analyzing "public.ci_pipeline_variables"
1341INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1342INFO: analyzing "public.p_ci_stages" inheritance tree
1343INFO: analyzing "public.ci_stages"
1344INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1345# [RSpecRunTime] Finishing example group spec/migrations/20230929155123_migrate_disable_merge_trains_value_spec.rb. It took 57.88 seconds. Expected to take 27.77 seconds.
1346# [RSpecRunTime] RSpec elapsed time: 23 minutes 41.34 seconds. Current RSS: ~1350M. load average: 0.87 0.88 0.99 1/265 420
1347# [RSpecRunTime] Starting example group spec/migrations/fix_broken_user_achievements_awarded_spec.rb. Expected to take 24.72 seconds.
1348FixBrokenUserAchievementsAwarded
1349 #up
1350 when ghost user exists
1351main: == [advisory_lock_connection] object_id: 263187920, pg_backend_pid: 270
1352main: == 20231127185327 FixBrokenUserAchievementsAwarded: migrating =================
1353main: -- exec_query("SELECT COUNT(*) AS count FROM \"user_achievements\" WHERE \"user_achievements\".\"awarded_by_user_id\" IS NULL")
1354main: -> 0.0023s
1355main: -- exec_query("SELECT \"user_achievements\".\"id\" FROM \"user_achievements\" WHERE \"user_achievements\".\"awarded_by_user_id\" IS NULL ORDER BY \"user_achievements\".\"id\" ASC LIMIT 1")
1356main: -> 0.0026s
1357main: -- exec_query("SELECT \"user_achievements\".\"id\" FROM \"user_achievements\" WHERE \"user_achievements\".\"id\" >= 1 AND \"user_achievements\".\"awarded_by_user_id\" IS NULL ORDER BY \"user_achievements\".\"id\" ASC LIMIT 1 OFFSET 1")
1358main: -> 0.0024s
1359main: -- transaction(nil)
1360main: -- execute("UPDATE \"user_achievements\" SET \"awarded_by_user_id\" = 3 WHERE \"user_achievements\".\"id\" >= 1 AND \"user_achievements\".\"awarded_by_user_id\" IS NULL")
1361main: -> 0.0031s
1362main: -> 0.0050s
1363main: == 20231127185327 FixBrokenUserAchievementsAwarded: migrated (0.0615s) ========
1364main: == [advisory_lock_connection] object_id: 263187920, pg_backend_pid: 270
1365 migrates the invalid user achievement
1366main: == [advisory_lock_connection] object_id: 264046640, pg_backend_pid: 272
1367main: == 20231127185327 FixBrokenUserAchievementsAwarded: migrating =================
1368main: -- exec_query("SELECT COUNT(*) AS count FROM \"user_achievements\" WHERE \"user_achievements\".\"awarded_by_user_id\" IS NULL")
1369main: -> 0.0023s
1370main: -- exec_query("SELECT \"user_achievements\".\"id\" FROM \"user_achievements\" WHERE \"user_achievements\".\"awarded_by_user_id\" IS NULL ORDER BY \"user_achievements\".\"id\" ASC LIMIT 1")
1371main: -> 0.0014s
1372main: -- exec_query("SELECT \"user_achievements\".\"id\" FROM \"user_achievements\" WHERE \"user_achievements\".\"id\" >= 3 AND \"user_achievements\".\"awarded_by_user_id\" IS NULL ORDER BY \"user_achievements\".\"id\" ASC LIMIT 1 OFFSET 1")
1373main: -> 0.0014s
1374main: -- transaction(nil)
1375main: -- execute("UPDATE \"user_achievements\" SET \"awarded_by_user_id\" = 6 WHERE \"user_achievements\".\"id\" >= 3 AND \"user_achievements\".\"awarded_by_user_id\" IS NULL")
1376main: -> 0.0024s
1377main: -> 0.0037s
1378main: == 20231127185327 FixBrokenUserAchievementsAwarded: migrated (0.0528s) ========
1379main: == [advisory_lock_connection] object_id: 264046640, pg_backend_pid: 272
1380 does not migrate the valid user achievement
1381# [RSpecRunTime] RSpec elapsed time: 24 minutes 1.63 seconds. Current RSS: ~1345M. load average: 0.85 0.87 0.99 1/265 421
1382 when ghost user does not exist
1383main: == [advisory_lock_connection] object_id: 264605400, pg_backend_pid: 275
1384main: == 20231127185327 FixBrokenUserAchievementsAwarded: migrating =================
1385main: == 20231127185327 FixBrokenUserAchievementsAwarded: migrated (0.0198s) ========
1386main: == [advisory_lock_connection] object_id: 264605400, pg_backend_pid: 275
1387 does not migrate the invalid user achievement
1388# [RSpecRunTime] RSpec elapsed time: 24 minutes 4.05 seconds. Current RSS: ~1344M. load average: 0.78 0.86 0.98 1/265 422
1389INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1390INFO: analyzing "public.ci_pipeline_variables"
1391INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1392INFO: analyzing "public.p_ci_job_artifacts" inheritance tree
1393INFO: analyzing "public.ci_job_artifacts"
1394INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1395INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1396INFO: analyzing "public.ci_pipeline_variables"
1397INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1398INFO: analyzing "public.p_ci_stages" inheritance tree
1399INFO: analyzing "public.ci_stages"
1400INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1401# [RSpecRunTime] Finishing example group spec/migrations/fix_broken_user_achievements_awarded_spec.rb. It took 43.94 seconds. Expected to take 24.72 seconds.
1402# [RSpecRunTime] RSpec elapsed time: 24 minutes 25.32 seconds. Current RSS: ~1342M. load average: 0.84 0.87 0.98 1/265 423
1403# [RSpecRunTime] Starting example group spec/migrations/20231212135235_queue_backfill_vs_code_settings_version_spec.rb. Expected to take 15.88 seconds.
1404QueueBackfillVsCodeSettingsVersion
1405main: == [advisory_lock_connection] object_id: 270682320, pg_backend_pid: 281
1406main: == 20231212135235 QueueBackfillVsCodeSettingsVersion: migrating ===============
1407main: == 20231212135235 QueueBackfillVsCodeSettingsVersion: migrated (0.0646s) ======
1408main: == [advisory_lock_connection] object_id: 270682320, pg_backend_pid: 281
1409 schedules a new batched migration
1410The application_settings (main) table has 1217 columns.
1411Recreating the database
1412Dropped database 'gitlabhq_test'
1413Created database 'gitlabhq_test'
1414main: == [advisory_lock_connection] object_id: 271526600, pg_backend_pid: 288
1415main: == [advisory_lock_connection] object_id: 271526600, pg_backend_pid: 288
1416Databases re-creation done in 5.988958906999869
1417# [RSpecRunTime] Finishing example group spec/migrations/20231212135235_queue_backfill_vs_code_settings_version_spec.rb. It took 21.48 seconds. Expected to take 15.88 seconds.
1418# [RSpecRunTime] RSpec elapsed time: 24 minutes 46.85 seconds. Current RSS: ~1322M. load average: 0.95 0.89 0.99 1/265 425
1419# [RSpecRunTime] Starting example group spec/migrations/20240209153920_queue_purge_security_scans_with_empty_finding_data_spec.rb. Expected to take 7.51 seconds.
1420QueuePurgeSecurityScansWithEmptyFindingData
1421main: == [advisory_lock_connection] object_id: 272275680, pg_backend_pid: 292
1422main: == 20240209153920 QueuePurgeSecurityScansWithEmptyFindingData: migrating ======
1423main: == 20240209153920 QueuePurgeSecurityScansWithEmptyFindingData: migrated (0.0168s)
1424main: == [advisory_lock_connection] object_id: 272275680, pg_backend_pid: 292
1425 does not schedule a new batched migration for CE
1426INFO: analyzing "public.p_ci_stages" inheritance tree
1427INFO: analyzing "public.ci_stages"
1428INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1429# [RSpecRunTime] Finishing example group spec/migrations/20240209153920_queue_purge_security_scans_with_empty_finding_data_spec.rb. It took 14.11 seconds. Expected to take 7.51 seconds.
1430# [RSpecRunTime] RSpec elapsed time: 25 minutes 1.0 second. Current RSS: ~1332M. load average: 0.96 0.90 0.99 2/266 426
1431auto_explain log contains 923 entries for main, writing to /builds/gitlab-org/gitlab/auto_explain/rspec-migration-pg14-single-db-3-15.336.main.ndjson.gz
1432took 13.46621383
1433[TEST PROF INFO] EventProf results for sql.active_record
1434Total time: 18:50.519 of 24:57.814 (75.48%)
1435Total events: 626616
1436Top 5 slowest suites (by time):
1437EnsureCommitU...orGitlabDotCom (./spec/migrations/ensure_commit_user_mentions_note_id_bigint_backfill_is_finished_for_gitlab_dot_com_spec.rb:6) – 02:02.827 (63659 / 2) of 02:40.227 (76.66%)
1438UpdateIssuesInternalIdScope (./spec/migrations/20230224085743_update_issues_internal_id_scope_spec.rb:6) – 02:01.794 (66035 / 2) of 02:40.335 (75.96%)
1439RescheduleMigrateEvidences (./spec/migrations/20230330103104_reschedule_migrate_evidences_spec.rb:6) – 02:01.129 (60492 / 2) of 02:34.627 (78.34%)
1440TruncateErrorTrackingTables (./spec/migrations/20230328100534_truncate_error_tracking_tables_spec.rb:6) – 01:54.527 (63844 / 4) of 02:34.453 (74.15%)
1441AddTypeToHttpIntegrations (./spec/migrations/add_type_to_http_integrations_spec.rb:6) – 01:39.006 (54710 / 1) of 02:07.220 (77.82%)
1442Knapsack report was generated. Preview:
1443{
1444 "spec/migrations/20230328100534_truncate_error_tracking_tables_spec.rb": 74.811800167,
1445 "spec/migrations/20230224085743_update_issues_internal_id_scope_spec.rb": 73.6593827480001,
1446 "spec/migrations/ensure_commit_user_mentions_note_id_bigint_backfill_is_finished_for_gitlab_dot_com_spec.rb": 73.23044996200042,
1447 "spec/migrations/20230330103104_reschedule_migrate_evidences_spec.rb": 72.57377527600056,
1448 "spec/migrations/20230412185837_queue_populate_vulnerability_dismissal_fields_spec.rb": 72.75134041500041,
1449 "spec/migrations/add_type_to_http_integrations_spec.rb": 56.7466345290004,
1450 "spec/migrations/20230522111534_reschedule_migration_for_links_from_metadata_spec.rb": 57.205576672999996,
1451 "spec/migrations/20230723203612_backfill_default_branch_protection_application_setting_spec.rb": 41.7706433379999,
1452 "spec/migrations/20230809104753_swap_epic_user_mentions_note_id_to_bigint_for_self_hosts_spec.rb": 37.79094106799948,
1453 "spec/migrations/20230724164745_queue_delete_orphaned_transferred_project_approval_rules_spec.rb": 40.52656237500014,
1454 "spec/migrations/20230814144045_swap_timelogs_note_id_to_bigint_for_self_hosts_spec.rb": 37.147527449000336,
1455 "spec/migrations/20230815140656_queue_populate_denormalized_columns_for_sbom_occurrences_spec.rb": 30.84766732800017,
1456 "spec/migrations/20230929155123_migrate_disable_merge_trains_value_spec.rb": 27.799632678000307,
1457 "spec/migrations/fix_broken_user_achievements_awarded_spec.rb": 22.77307198499966,
1458 "spec/migrations/20231212135235_queue_backfill_vs_code_settings_version_spec.rb": 15.374555661000159,
1459 "spec/migrations/20240209153920_queue_purge_security_scans_with_empty_finding_data_spec.rb": 6.688189542000146
1460}
1461Knapsack global time execution for tests: 12m 21s
1462Pending: (Failures listed here are expected and do not affect your suite's status)
1463 1) TruncateErrorTrackingTables when on GitLab.com when uses CI db does not truncate the table
1464 # Skipping because none of the extra databases [:ci] are setup
1465 # ./spec/migrations/20230328100534_truncate_error_tracking_tables_spec.rb:27
1466Finished in 25 minutes 15 seconds (files took 44.88 seconds to load)
146733 examples, 0 failures, 1 pending
1468Randomized with seed 55328
1469[TEST PROF INFO] Time spent in factories: 00:00.231 (0.02% of total time)
1470RSpec exited with 0.
1471No examples to retry, congrats!
1472 Running after_script 00:05
1473Running after script...
1474$ echo -e "\e[0Ksection_start:`date +%s`:report_results_section[collapsed=true]\r\e[0KReport results"
1475 Report results 00:03
1485$ tooling/bin/push_job_metrics || true
1486[job-metrics] Pushing job metrics file for the CI/CD job.
1487[job-metrics] Pushed 4 CI job metric entries to InfluxDB.
1488 Saving cache for successful job 00:01
1489Not uploading cache ruby-gems-debian-bookworm-ruby-3.1-17 due to policy
1490 Uploading artifacts for successful job 00:04
1491Uploading artifacts...
1492auto_explain/: found 2 matching artifact files and directories
1493coverage/: found 5 matching artifact files and directories
1494crystalball/: found 2 matching artifact files and directories
1495WARNING: deprecations/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab)
1496knapsack/: found 4 matching artifact files and directories
1497rspec/: found 16 matching artifact files and directories
1498WARNING: tmp/capybara/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab)
1499log/*.log: found 13 matching artifact files and directories
1500WARNING: Upload request redirected location=https://gitlab.com/api/v4/jobs/6311411134/artifacts?artifact_format=zip&artifact_type=archive&expire_in=31d new-url=https://gitlab.com
1501WARNING: Retrying... context=artifacts-uploader error=request redirected
1502Uploading artifacts as "archive" to coordinator... 201 Created id=6311411134 responseStatus=201 Created token=glcbt-65
1503Uploading artifacts...
1504rspec/rspec-*.xml: found 1 matching artifact files and directories
1505WARNING: Upload request redirected location=https://gitlab.com/api/v4/jobs/6311411134/artifacts?artifact_format=gzip&artifact_type=junit&expire_in=31d new-url=https://gitlab.com
1506WARNING: Retrying... context=artifacts-uploader error=request redirected
1507Uploading artifacts as "junit" to coordinator... 201 Created id=6311411134 responseStatus=201 Created token=glcbt-65
1508 Cleaning up project directory and file based variables 00:01
1509Job succeeded