Skip to content
Snippets Groups Projects

rspec migration pg14 single-db 14/15

Passed Started by
Rajendra Kadam
@rkadam3
1Running with gitlab-runner 16.9.1 (782c6ecb)
2 on green-1.private.runners-manager.gitlab.com/gitlab.com/gitlab-org 4bq1s9yM, system ID: s_9d15f3e4e7ae
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:07
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:01
25Running on runner-4bq1s9ym-project-278964-concurrent-0 via runner-4bq1s9ym-private-1709550071-abe44d10...
26 Getting source from Git repository 00:00
27Skipping Git repository setup
28Skipping Git checkout
29Skipping Git submodules setup
30 Restoring cache 00:17
31Checking cache for ruby-gems-debian-bookworm-ruby-3.1-17...
32Downloading cache from https://storage.googleapis.com/gitlab-com-runners-cache/project/278964/ruby-gems-debian-bookworm-ruby-3.1-17
33Successfully extracted cache
34 Downloading artifacts 00:35
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 30:31
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:15
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$ section_start "gitaly-test-spawn" "Spawning Gitaly"; scripts/gitaly-test-spawn; section_end "gitaly-test-spawn"
764==> 'gem install knapsack --no-document' succeeded in 0 seconds.
765 Spawning Gitaly 00:04
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:21] 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_14_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_14_15_278964_report.json
783NEW_FLAKY_RSPEC_REPORT_PATH: rspec/flaky/new_rspec_migration_pg14_single-db_14_15_278964_report.json
784RSPEC_SKIPPED_TESTS_REPORT_PATH: rspec/skipped_tests-6311411163.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.404287077 seconds
810# [RSpecRunTime] Starting example group spec/migrations/schedule_migrate_shared_vulnerability_identifiers_spec.rb. Expected to take 1 minute 24.58 seconds.
811ScheduleMigrateSharedVulnerabilityIdentifiers
812 #up
813main: == [advisory_lock_connection] object_id: 11722140, pg_backend_pid: 118
814main: == 20230221093536 ScheduleMigrateSharedVulnerabilityIdentifiers: migrating ====
815main: == 20230221093536 ScheduleMigrateSharedVulnerabilityIdentifiers: migrated (0.0671s)
816main: == [advisory_lock_connection] object_id: 11722140, pg_backend_pid: 118
817 schedules
818 #down
819 deletes
820# [RSpecRunTime] RSpec elapsed time: 1 minute 21.88 seconds. Current RSS: ~1347M. load average: 1.19 1.22 1.16 1/275 384
821INFO: analyzing "public.p_ci_builds" inheritance tree
822INFO: analyzing "public.ci_builds"
823INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
824INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
825INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
826INFO: "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
827INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_101"
828INFO: "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
829INFO: analyzing "public.p_ci_job_annotations" inheritance tree
830INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
831INFO: "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
832INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
833INFO: analyzing "public.ci_builds_metadata"
834INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
835INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_101"
836INFO: "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
837INFO: analyzing "public.p_ci_builds" inheritance tree
838INFO: analyzing "public.ci_builds"
839INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
840INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
841INFO: analyzing "public.ci_pipeline_variables"
842INFO: "ci_pipeline_variables": 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_job_artifacts" inheritance tree
844INFO: analyzing "public.ci_job_artifacts"
845INFO: "ci_job_artifacts": 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_stages" inheritance tree
850INFO: analyzing "public.ci_stages"
851INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
852# [RSpecRunTime] Finishing example group spec/migrations/schedule_migrate_shared_vulnerability_identifiers_spec.rb. It took 2 minutes 45.63 seconds. Expected to take 1 minute 24.58 seconds.
853# [RSpecRunTime] RSpec elapsed time: 2 minutes 49.14 seconds. Current RSS: ~1335M. load average: 1.01 1.16 1.14 1/273 386
854# [RSpecRunTime] Starting example group spec/migrations/swap_merge_request_user_mentions_note_id_to_bigint_2_spec.rb. Expected to take 1 minute 22.56 seconds.
855SwapMergeRequestUserMentionsNoteIdToBigint2
856 #up
857 swaps the integer and bigint columns for GitLab.com, dev, or test
858 is a no-op for other instances
859main: == [advisory_lock_connection] object_id: 43377380, pg_backend_pid: 137
860main: == 20230310020356 SwapMergeRequestUserMentionsNoteIdToBigint2: migrating ======
861main: == 20230310020356 SwapMergeRequestUserMentionsNoteIdToBigint2: migrated (0.0096s)
862main: == [advisory_lock_connection] object_id: 43377380, pg_backend_pid: 137
863 is a no-op if columns are already swapped
864# [RSpecRunTime] RSpec elapsed time: 4 minutes 6.75 seconds. Current RSS: ~1339M. load average: 1.17 1.18 1.15 1/274 387
865INFO: analyzing "public.p_ci_builds" inheritance tree
866INFO: analyzing "public.ci_builds"
867INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
868INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
869INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
870INFO: "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
871INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_101"
872INFO: "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
873INFO: analyzing "public.p_ci_job_annotations" inheritance tree
874INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
875INFO: "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
876INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
877INFO: analyzing "public.ci_builds_metadata"
878INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
879INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_101"
880INFO: "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
881INFO: analyzing "public.p_ci_builds" inheritance tree
882INFO: analyzing "public.ci_builds"
883INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
884INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
885INFO: analyzing "public.ci_pipeline_variables"
886INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
887INFO: analyzing "public.p_ci_job_artifacts" inheritance tree
888INFO: analyzing "public.ci_job_artifacts"
889INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
890INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
891INFO: analyzing "public.ci_pipeline_variables"
892INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
893INFO: analyzing "public.p_ci_stages" inheritance tree
894INFO: analyzing "public.ci_stages"
895INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
896# [RSpecRunTime] Finishing example group spec/migrations/swap_merge_request_user_mentions_note_id_to_bigint_2_spec.rb. It took 2 minutes 43.81 seconds. Expected to take 1 minute 22.56 seconds.
897# [RSpecRunTime] RSpec elapsed time: 5 minutes 32.98 seconds. Current RSS: ~1348M. load average: 1.18 1.17 1.15 1/272 388
898# [RSpecRunTime] Starting example group spec/migrations/swap_epic_user_mentions_note_id_to_bigint_for_gitlab_dot_com_spec.rb. Expected to take 1 minute 19.05 seconds.
899SwapEpicUserMentionsNoteIdToBigintForGitlabDotCom
900 #up
901 swaps the integer and bigint columns for GitLab.com, dev, or test
902 is a no-op for other instances
903# [RSpecRunTime] RSpec elapsed time: 6 minutes 46.72 seconds. Current RSS: ~1345M. load average: 1.20 1.17 1.15 1/272 389
904INFO: analyzing "public.p_ci_builds" inheritance tree
905INFO: analyzing "public.ci_builds"
906INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
907INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
908INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
909INFO: "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
910INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_101"
911INFO: "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
912INFO: analyzing "public.p_ci_job_annotations" inheritance tree
913INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
914INFO: "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
915INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
916INFO: analyzing "public.ci_builds_metadata"
917INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
918INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_101"
919INFO: "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
920INFO: analyzing "public.p_ci_builds" inheritance tree
921INFO: analyzing "public.ci_builds"
922INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
923INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
924INFO: analyzing "public.ci_pipeline_variables"
925INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
926INFO: analyzing "public.p_ci_job_artifacts" inheritance tree
927INFO: analyzing "public.ci_job_artifacts"
928INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
929INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
930INFO: analyzing "public.ci_pipeline_variables"
931INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
932INFO: analyzing "public.p_ci_stages" inheritance tree
933INFO: analyzing "public.ci_stages"
934INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
935# [RSpecRunTime] Finishing example group spec/migrations/swap_epic_user_mentions_note_id_to_bigint_for_gitlab_dot_com_spec.rb. It took 2 minutes 36.16 seconds. Expected to take 1 minute 19.05 seconds.
936# [RSpecRunTime] RSpec elapsed time: 8 minutes 9.17 seconds. Current RSS: ~1338M. load average: 0.97 1.09 1.12 1/272 390
937# [RSpecRunTime] Starting example group spec/migrations/20230314144640_reschedule_migration_for_links_spec.rb. Expected to take 1 minute 16.49 seconds.
938RescheduleMigrationForLinks
939 #up
940main: == [advisory_lock_connection] object_id: 98759500, pg_backend_pid: 160
941main: == 20230314144640 RescheduleMigrationForLinks: migrating ======================
942main: == 20230314144640 RescheduleMigrationForLinks: migrated (0.0091s) =============
943main: == [advisory_lock_connection] object_id: 98759500, pg_backend_pid: 160
944 schedules a batched background migration
945# [RSpecRunTime] RSpec elapsed time: 9 minutes 23.77 seconds. Current RSS: ~1356M. load average: 1.18 1.13 1.13 1/273 391
946 #down
947main: == [advisory_lock_connection] object_id: 99587580, pg_backend_pid: 162
948main: == 20230314144640 RescheduleMigrationForLinks: migrating ======================
949main: == 20230314144640 RescheduleMigrationForLinks: migrated (0.0093s) =============
950main: == [advisory_lock_connection] object_id: 99587580, pg_backend_pid: 162
951 deletes all batched migration records
952# [RSpecRunTime] RSpec elapsed time: 9 minutes 26.49 seconds. Current RSS: ~1350M. load average: 1.17 1.13 1.13 1/273 392
953INFO: analyzing "public.p_ci_builds" inheritance tree
954INFO: analyzing "public.ci_builds"
955INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
956INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
957INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
958INFO: "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
959INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_101"
960INFO: "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
961INFO: analyzing "public.p_ci_job_annotations" inheritance tree
962INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
963INFO: "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
964INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
965INFO: analyzing "public.ci_builds_metadata"
966INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
967INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_101"
968INFO: "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
969INFO: analyzing "public.p_ci_builds" inheritance tree
970INFO: analyzing "public.ci_builds"
971INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
972INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
973INFO: analyzing "public.ci_pipeline_variables"
974INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
975INFO: analyzing "public.p_ci_job_artifacts" inheritance tree
976INFO: analyzing "public.ci_job_artifacts"
977INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
978INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
979INFO: analyzing "public.ci_pipeline_variables"
980INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
981INFO: analyzing "public.p_ci_stages" inheritance tree
982INFO: analyzing "public.ci_stages"
983INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
984# [RSpecRunTime] Finishing example group spec/migrations/20230314144640_reschedule_migration_for_links_spec.rb. It took 2 minutes 46.3 seconds. Expected to take 1 minute 16.49 seconds.
985# [RSpecRunTime] RSpec elapsed time: 10 minutes 55.5 seconds. Current RSS: ~1344M. load average: 1.08 1.11 1.12 1/273 393
986# [RSpecRunTime] Starting example group spec/migrations/20230303105806_queue_delete_orphaned_packages_dependencies_spec.rb. Expected to take 1 minute 13.53 seconds.
987QueueDeleteOrphanedPackagesDependencies
988main: == [advisory_lock_connection] object_id: 128116880, pg_backend_pid: 174
989main: == 20230303105806 QueueDeleteOrphanedPackagesDependencies: migrating ==========
990main: == 20230303105806 QueueDeleteOrphanedPackagesDependencies: migrated (0.0579s) =
991main: == [advisory_lock_connection] object_id: 128116880, pg_backend_pid: 174
992 schedules a new batched migration
993The application_settings (main) table has 1201 columns.
994Recreating the database
995Dropped database 'gitlabhq_test'
996Created database 'gitlabhq_test'
997main: == [advisory_lock_connection] object_id: 129001580, pg_backend_pid: 181
998main: == [advisory_lock_connection] object_id: 129001580, pg_backend_pid: 181
999Databases re-creation done in 6.294267467999816
1000# [RSpecRunTime] Finishing example group spec/migrations/20230303105806_queue_delete_orphaned_packages_dependencies_spec.rb. It took 1 minute 24.98 seconds. Expected to take 1 minute 13.53 seconds.
1001# [RSpecRunTime] RSpec elapsed time: 12 minutes 20.52 seconds. Current RSS: ~1320M. load average: 1.24 1.16 1.14 1/273 395
1002# [RSpecRunTime] Starting example group spec/migrations/drop_packages_events_table_spec.rb. Expected to take 1 minute 11.65 seconds.
1003DropPackagesEventsTable
1004main: -- table_exists?(:packages_events)
1005main: -> 0.0030s
1006main: == [advisory_lock_connection] object_id: 140513460, pg_backend_pid: 187
1007main: == 20230316185746 DropPackagesEventsTable: migrating ==========================
1008main: -- drop_table(:packages_events, {:if_exists=>true})
1009main: -> 0.0024s
1010main: == 20230316185746 DropPackagesEventsTable: migrated (0.0140s) =================
1011main: == [advisory_lock_connection] object_id: 140513460, pg_backend_pid: 187
1012main: -- table_exists?(:packages_events)
1013main: -> 0.0029s
1014main: -- table_exists?(:packages_events)
1015main: -> 0.0023s
1016 drops and creates the packages_events table
1017INFO: analyzing "public.p_ci_builds" inheritance tree
1018INFO: analyzing "public.ci_builds"
1019INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1020INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
1021INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
1022INFO: "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
1023INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_101"
1024INFO: "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
1025INFO: analyzing "public.p_ci_job_annotations" inheritance tree
1026INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
1027INFO: "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
1028INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
1029INFO: analyzing "public.ci_builds_metadata"
1030INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1031INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_101"
1032INFO: "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
1033INFO: analyzing "public.p_ci_builds" inheritance tree
1034INFO: analyzing "public.ci_builds"
1035INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1036INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1037INFO: analyzing "public.ci_pipeline_variables"
1038INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1039INFO: analyzing "public.p_ci_job_artifacts" inheritance tree
1040INFO: analyzing "public.ci_job_artifacts"
1041INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1042INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1043INFO: analyzing "public.ci_pipeline_variables"
1044INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1045INFO: analyzing "public.p_ci_stages" inheritance tree
1046INFO: analyzing "public.ci_stages"
1047INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1048# [RSpecRunTime] Finishing example group spec/migrations/drop_packages_events_table_spec.rb. It took 2 minutes 29.15 seconds. Expected to take 1 minute 11.65 seconds.
1049# [RSpecRunTime] RSpec elapsed time: 14 minutes 49.71 seconds. Current RSS: ~1326M. load average: 0.94 1.10 1.12 1/273 396
1050# [RSpecRunTime] Starting example group spec/migrations/ensure_merge_request_metrics_id_bigint_backfill_is_finished_for_self_hosts_spec.rb. Expected to take 1 minute 3.4 seconds.
1051EnsureMergeRequestMetricsIdBigintBackfillIsFinishedForSelfHosts
1052 #up
1053main: == [advisory_lock_connection] object_id: 167789720, pg_backend_pid: 198
1054main: == 20230419094535 EnsureMergeRequestMetricsIdBigintBackfillIsFinishedForSelfHosts: migrating
1055main: == 20230419094535 EnsureMergeRequestMetricsIdBigintBackfillIsFinishedForSelfHosts: migrated (0.0082s)
1056main: == [advisory_lock_connection] object_id: 167789720, pg_backend_pid: 198
1057 ensures the migration is completed
1058# [RSpecRunTime] RSpec elapsed time: 15 minutes 51.41 seconds. Current RSS: ~1335M. load average: 1.04 1.09 1.11 1/272 397
1059INFO: analyzing "public.p_ci_builds" inheritance tree
1060INFO: analyzing "public.ci_builds"
1061INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1062INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
1063INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
1064INFO: "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
1065INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_101"
1066INFO: "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
1067INFO: analyzing "public.p_ci_job_annotations" inheritance tree
1068INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
1069INFO: "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
1070INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
1071INFO: analyzing "public.ci_builds_metadata"
1072INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1073INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_101"
1074INFO: "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
1075INFO: analyzing "public.p_ci_builds" inheritance tree
1076INFO: analyzing "public.ci_builds"
1077INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1078INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1079INFO: analyzing "public.ci_pipeline_variables"
1080INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1081INFO: analyzing "public.p_ci_job_artifacts" inheritance tree
1082INFO: analyzing "public.ci_job_artifacts"
1083INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1084INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1085INFO: analyzing "public.ci_pipeline_variables"
1086INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1087INFO: analyzing "public.p_ci_stages" inheritance tree
1088INFO: analyzing "public.ci_stages"
1089INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1090# [RSpecRunTime] Finishing example group spec/migrations/ensure_merge_request_metrics_id_bigint_backfill_is_finished_for_self_hosts_spec.rb. It took 2 minutes 18.69 seconds. Expected to take 1 minute 3.4 seconds.
1091# [RSpecRunTime] RSpec elapsed time: 17 minutes 8.44 seconds. Current RSS: ~1327M. load average: 1.05 1.08 1.10 1/272 398
1092# [RSpecRunTime] Starting example group spec/migrations/20230505115558_add_authors_and_description_to_nuget_metadatum_spec.rb. Expected to take 1 minute 1.65 seconds.
1093AddAuthorsAndDescriptionToNugetMetadatum
1094main: == [advisory_lock_connection] object_id: 192955200, pg_backend_pid: 208
1095main: == 20230505115558 AddAuthorsAndDescriptionToNugetMetadatum: migrating =========
1096main: -- add_column(:packages_nuget_metadata, :authors, :text, {:if_not_exists=>true})
1097main: -> 0.0049s
1098main: -- add_column(:packages_nuget_metadata, :description, :text, {:if_not_exists=>true})
1099main: -> 0.0045s
1100main: -- execute("ALTER TABLE packages_nuget_metadata\nADD CONSTRAINT check_e2fc129ebd\nCHECK ( char_length(authors) <= 255 )\nNOT VALID;\n")
1101main: -> 0.0015s
1102main: -- execute("ALTER TABLE packages_nuget_metadata VALIDATE CONSTRAINT check_e2fc129ebd;")
1103main: -> 0.0012s
1104main: -- execute("ALTER TABLE packages_nuget_metadata\nADD CONSTRAINT check_d39a5fe9ee\nCHECK ( char_length(description) <= 4000 )\nNOT VALID;\n")
1105main: -> 0.0016s
1106main: -- execute("ALTER TABLE packages_nuget_metadata VALIDATE CONSTRAINT check_d39a5fe9ee;")
1107main: -> 0.0014s
1108main: == 20230505115558 AddAuthorsAndDescriptionToNugetMetadatum: migrated (0.0573s)
1109main: == [advisory_lock_connection] object_id: 192955200, pg_backend_pid: 208
1110 correctly migrates up and down
1111INFO: analyzing "public.p_ci_builds" inheritance tree
1112INFO: analyzing "public.ci_builds"
1113INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1114INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
1115INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
1116INFO: "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
1117INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_101"
1118INFO: "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
1119INFO: analyzing "public.p_ci_job_annotations" inheritance tree
1120INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
1121INFO: "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
1122INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
1123INFO: analyzing "public.ci_builds_metadata"
1124INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1125INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_101"
1126INFO: "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
1127INFO: analyzing "public.p_ci_builds" inheritance tree
1128INFO: analyzing "public.ci_builds"
1129INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1130INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1131INFO: analyzing "public.ci_pipeline_variables"
1132INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1133INFO: analyzing "public.p_ci_job_artifacts" inheritance tree
1134INFO: analyzing "public.ci_job_artifacts"
1135INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1136INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1137INFO: analyzing "public.ci_pipeline_variables"
1138INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1139INFO: analyzing "public.p_ci_stages" inheritance tree
1140INFO: analyzing "public.ci_stages"
1141INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1142# [RSpecRunTime] Finishing example group spec/migrations/20230505115558_add_authors_and_description_to_nuget_metadatum_spec.rb. It took 2 minutes 16.15 seconds. Expected to take 1 minute 1.65 seconds.
1143# [RSpecRunTime] RSpec elapsed time: 19 minutes 24.62 seconds. Current RSS: ~1319M. load average: 1.02 1.07 1.09 1/272 399
1144# [RSpecRunTime] Starting example group spec/migrations/20230719083202_backfill_project_statistics_storage_size_without_pipeline_artifacts_size_spec.rb. Expected to take 47.69 seconds.
1145BackfillProjectStatisticsStorageSizeWithoutPipelineArtifactsSize
1146main: == [advisory_lock_connection] object_id: 214576980, pg_backend_pid: 218
1147main: == 20230719083202 BackfillProjectStatisticsStorageSizeWithoutPipelineArtifactsSize: migrating
1148main: == 20230719083202 BackfillProjectStatisticsStorageSizeWithoutPipelineArtifactsSize: migrated (0.0096s)
1149main: == [advisory_lock_connection] object_id: 214576980, pg_backend_pid: 218
1150 does not schedule background jobs when Gitlab.org_or_com? is false
1151main: == [advisory_lock_connection] object_id: 215282140, pg_backend_pid: 221
1152main: == 20230719083202 BackfillProjectStatisticsStorageSizeWithoutPipelineArtifactsSize: migrating
1153main: == 20230719083202 BackfillProjectStatisticsStorageSizeWithoutPipelineArtifactsSize: migrated (0.0869s)
1154main: == [advisory_lock_connection] object_id: 215282140, pg_backend_pid: 221
1155 schedules a new batched migration
1156INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
1157INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
1158INFO: "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
1159INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_101"
1160INFO: "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
1161INFO: analyzing "public.p_ci_job_annotations" inheritance tree
1162INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
1163INFO: "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
1164INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
1165INFO: analyzing "public.ci_builds_metadata"
1166INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1167INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_101"
1168INFO: "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
1169INFO: analyzing "public.p_ci_builds" inheritance tree
1170INFO: analyzing "public.ci_builds"
1171INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1172INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1173INFO: analyzing "public.ci_pipeline_variables"
1174INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1175INFO: analyzing "public.p_ci_job_artifacts" inheritance tree
1176INFO: analyzing "public.ci_job_artifacts"
1177INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1178INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1179INFO: analyzing "public.ci_pipeline_variables"
1180INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1181INFO: analyzing "public.p_ci_stages" inheritance tree
1182INFO: analyzing "public.ci_stages"
1183INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1184# [RSpecRunTime] Finishing example group spec/migrations/20230719083202_backfill_project_statistics_storage_size_without_pipeline_artifacts_size_spec.rb. It took 1 minute 37.85 seconds. Expected to take 47.69 seconds.
1185# [RSpecRunTime] RSpec elapsed time: 21 minutes 2.51 seconds. Current RSS: ~1316M. load average: 0.99 1.05 1.08 1/272 400
1186# [RSpecRunTime] Starting example group spec/migrations/20230712145557_queue_backfill_missing_vulnerability_dismissal_details_spec.rb. Expected to take 45.3 seconds.
1187QueueBackfillMissingVulnerabilityDismissalDetails
1188main: == [advisory_lock_connection] object_id: 231106500, pg_backend_pid: 230
1189main: == 20230712145557 QueueBackfillMissingVulnerabilityDismissalDetails: migrating
1190main: == 20230712145557 QueueBackfillMissingVulnerabilityDismissalDetails: migrated (0.0599s)
1191main: == [advisory_lock_connection] object_id: 231106500, pg_backend_pid: 230
1192 schedules a new batched migration
1193INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
1194INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
1195INFO: "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
1196INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_101"
1197INFO: "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
1198INFO: analyzing "public.p_ci_job_annotations" inheritance tree
1199INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
1200INFO: "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
1201INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
1202INFO: analyzing "public.ci_builds_metadata"
1203INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1204INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_101"
1205INFO: "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
1206INFO: analyzing "public.p_ci_builds" inheritance tree
1207INFO: analyzing "public.ci_builds"
1208INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1209INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1210INFO: analyzing "public.ci_pipeline_variables"
1211INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1212INFO: analyzing "public.p_ci_job_artifacts" inheritance tree
1213INFO: analyzing "public.ci_job_artifacts"
1214INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1215INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1216INFO: analyzing "public.ci_pipeline_variables"
1217INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1218INFO: analyzing "public.p_ci_stages" inheritance tree
1219INFO: analyzing "public.ci_stages"
1220INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1221# [RSpecRunTime] Finishing example group spec/migrations/20230712145557_queue_backfill_missing_vulnerability_dismissal_details_spec.rb. It took 1 minute 39.98 seconds. Expected to take 45.3 seconds.
1222# [RSpecRunTime] RSpec elapsed time: 22 minutes 42.52 seconds. Current RSS: ~1313M. load average: 1.16 1.08 1.08 1/272 401
1223# [RSpecRunTime] Starting example group spec/migrations/20230810123044_swap_snippet_user_mentions_note_id_to_bigint_for_self_hosts_spec.rb. Expected to take 42.8 seconds.
1224SwapSnippetUserMentionsNoteIdToBigintForSelfHosts
1225 #up
1226 when GitLab.com, dev, or test
1227 behaves like column `note_id_convert_to_bigint` is already dropped
1228 does not swaps the columns
1229# [RSpecRunTime] RSpec elapsed time: 23 minutes 15.19 seconds. Current RSS: ~1311M. load average: 1.02 1.05 1.08 1/272 402
1230 when self-managed instance with the `note_id_convert_to_bigint` column already dropped
1231 behaves like column `note_id_convert_to_bigint` is already dropped
1232 does not swaps the columns
1233# [RSpecRunTime] RSpec elapsed time: 23 minutes 17.67 seconds. Current RSS: ~1310M. load average: 1.02 1.05 1.08 1/272 403
1234 when self-managed instance columns already swapped
1235 does not swaps the columns
1236# [RSpecRunTime] RSpec elapsed time: 23 minutes 19.89 seconds. Current RSS: ~1318M. load average: 1.02 1.05 1.08 1/272 404
1237 when self-managed instance
1238 swaps the columns
1239# [RSpecRunTime] RSpec elapsed time: 23 minutes 22.84 seconds. Current RSS: ~1313M. load average: 1.02 1.05 1.08 1/272 405
1240INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
1241INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
1242INFO: "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
1243INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_101"
1244INFO: "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
1245INFO: analyzing "public.p_ci_job_annotations" inheritance tree
1246INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
1247INFO: "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
1248INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
1249INFO: analyzing "public.ci_builds_metadata"
1250INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1251INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_101"
1252INFO: "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
1253INFO: analyzing "public.p_ci_builds" inheritance tree
1254INFO: analyzing "public.ci_builds"
1255INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1256INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1257INFO: analyzing "public.ci_pipeline_variables"
1258INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1259INFO: analyzing "public.p_ci_job_artifacts" inheritance tree
1260INFO: analyzing "public.ci_job_artifacts"
1261INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1262INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1263INFO: analyzing "public.ci_pipeline_variables"
1264INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1265INFO: analyzing "public.p_ci_stages" inheritance tree
1266INFO: analyzing "public.ci_stages"
1267INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1268# [RSpecRunTime] Finishing example group spec/migrations/20230810123044_swap_snippet_user_mentions_note_id_to_bigint_for_self_hosts_spec.rb. It took 1 minute 18.91 seconds. Expected to take 42.8 seconds.
1269# [RSpecRunTime] RSpec elapsed time: 24 minutes 1.46 seconds. Current RSS: ~1311M. load average: 1.13 1.07 1.08 1/272 406
1270# [RSpecRunTime] Starting example group spec/migrations/20230728174927_add_epic_work_item_type_spec.rb. Expected to take 39.36 seconds.
1271AddEpicWorkItemType
1272main: == [advisory_lock_connection] object_id: 262055720, pg_backend_pid: 256
1273main: == 20230728174927 AddEpicWorkItemType: migrating ==============================
1274main: == 20230728174927 AddEpicWorkItemType: migrated (0.0661s) =====================
1275main: == [advisory_lock_connection] object_id: 262055720, pg_backend_pid: 256
1276 adds the epic type, widget definitions and hierarchy restrictions
1277main: == [advisory_lock_connection] object_id: 262381660, pg_backend_pid: 258
1278main: == 20230728174927 AddEpicWorkItemType: migrating ==============================
1279main: -- Epic work item type record exists, skipping creation
1280main: == 20230728174927 AddEpicWorkItemType: migrated (0.0149s) =====================
1281main: == [advisory_lock_connection] object_id: 262381660, pg_backend_pid: 258
1282 skips creating the new type an it's definitions
1283The application_settings (main) table has 1229 columns.
1284Recreating the database
1285Dropped database 'gitlabhq_test'
1286Created database 'gitlabhq_test'
1287main: == [advisory_lock_connection] object_id: 262784260, pg_backend_pid: 264
1288main: == [advisory_lock_connection] object_id: 262784260, pg_backend_pid: 264
1289Databases re-creation done in 5.9542316120005125
1290# [RSpecRunTime] Finishing example group spec/migrations/20230728174927_add_epic_work_item_type_spec.rb. It took 43.78 seconds. Expected to take 39.36 seconds.
1291# [RSpecRunTime] RSpec elapsed time: 24 minutes 45.27 seconds. Current RSS: ~1308M. load average: 1.13 1.08 1.08 1/272 408
1292# [RSpecRunTime] Starting example group spec/migrations/20230823090001_queue_backfill_project_statistics_storage_size_with_recent_size_spec.rb. Expected to take 32.09 seconds.
1293QueueBackfillProjectStatisticsStorageSizeWithRecentSize
1294main: == [advisory_lock_connection] object_id: 267539460, pg_backend_pid: 269
1295main: == 20230823090001 QueueBackfillProjectStatisticsStorageSizeWithRecentSize: migrating
1296main: == 20230823090001 QueueBackfillProjectStatisticsStorageSizeWithRecentSize: migrated (0.0553s)
1297main: == [advisory_lock_connection] object_id: 267539460, pg_backend_pid: 269
1298 schedules a new batched migration
1299INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
1300INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
1301INFO: "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
1302INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_101"
1303INFO: "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
1304INFO: analyzing "public.p_ci_job_annotations" inheritance tree
1305INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
1306INFO: "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
1307INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_101"
1308INFO: "ci_job_annotations_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1309INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
1310INFO: analyzing "public.ci_builds_metadata"
1311INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1312INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_101"
1313INFO: "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
1314INFO: analyzing "public.p_ci_builds" inheritance tree
1315INFO: analyzing "public.ci_builds"
1316INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1317INFO: analyzing "gitlab_partitions_dynamic.ci_builds_101"
1318INFO: "ci_builds_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1319INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1320INFO: analyzing "public.ci_pipeline_variables"
1321INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1322INFO: analyzing "public.p_ci_job_artifacts" inheritance tree
1323INFO: analyzing "public.ci_job_artifacts"
1324INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1325INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1326INFO: analyzing "public.ci_pipeline_variables"
1327INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1328INFO: analyzing "public.p_ci_stages" inheritance tree
1329INFO: analyzing "public.ci_stages"
1330INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1331# [RSpecRunTime] Finishing example group spec/migrations/20230823090001_queue_backfill_project_statistics_storage_size_with_recent_size_spec.rb. It took 1 minute 6.09 seconds. Expected to take 32.09 seconds.
1332# [RSpecRunTime] RSpec elapsed time: 25 minutes 51.4 seconds. Current RSS: ~1370M. load average: 0.96 1.03 1.07 1/272 409
1333# [RSpecRunTime] Starting example group spec/migrations/db/migrate/20231103162825_add_wolfi_purl_type_to_package_metadata_purl_types_spec.rb. Expected to take 27.27 seconds.
1334AddWolfiPurlTypeToPackageMetadataPurlTypes
1335 #up
1336 updates setting
1337# [RSpecRunTime] RSpec elapsed time: 26 minutes 12.57 seconds. Current RSS: ~1363M. load average: 1.11 1.06 1.08 1/272 410
1338 #down
1339 with default value
1340 updates setting
1341# [RSpecRunTime] RSpec elapsed time: 26 minutes 16.16 seconds. Current RSS: ~1357M. load average: 1.02 1.04 1.07 1/272 411
1342INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1343INFO: analyzing "public.ci_pipeline_variables"
1344INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1345INFO: analyzing "public.p_ci_job_artifacts" inheritance tree
1346INFO: analyzing "public.ci_job_artifacts"
1347INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1348INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1349INFO: analyzing "public.ci_pipeline_variables"
1350INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1351INFO: analyzing "public.p_ci_stages" inheritance tree
1352INFO: analyzing "public.ci_stages"
1353INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1354# [RSpecRunTime] Finishing example group spec/migrations/db/migrate/20231103162825_add_wolfi_purl_type_to_package_metadata_purl_types_spec.rb. It took 49.62 seconds. Expected to take 27.27 seconds.
1355# [RSpecRunTime] RSpec elapsed time: 26 minutes 41.06 seconds. Current RSS: ~1363M. load average: 0.95 1.02 1.06 1/272 412
1356# [RSpecRunTime] Starting example group spec/migrations/20231102142554_migrate_zoekt_shards_to_zoekt_nodes_spec.rb. Expected to take 25.48 seconds.
1357MigrateZoektShardsToZoektNodes
1358 #down
1359 deletes all zoekt_node records
1360# [RSpecRunTime] RSpec elapsed time: 27 minutes 1.75 seconds. Current RSS: ~1357M. load average: 1.04 1.04 1.07 1/273 413
1361 #up
1362main: == [advisory_lock_connection] object_id: 290448360, pg_backend_pid: 288
1363main: == 20231102142554 MigrateZoektShardsToZoektNodes: migrating ===================
1364main: == 20231102142554 MigrateZoektShardsToZoektNodes: migrated (0.0101s) ==========
1365main: == [advisory_lock_connection] object_id: 290448360, pg_backend_pid: 288
1366 migrates zoekt_shard records to zoekt_nodes
1367# [RSpecRunTime] RSpec elapsed time: 27 minutes 4.01 seconds. Current RSS: ~1360M. load average: 1.04 1.04 1.07 1/272 414
1368INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1369INFO: analyzing "public.ci_pipeline_variables"
1370INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1371INFO: analyzing "public.p_ci_job_artifacts" inheritance tree
1372INFO: analyzing "public.ci_job_artifacts"
1373INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1374INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1375INFO: analyzing "public.ci_pipeline_variables"
1376INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1377INFO: analyzing "public.p_ci_stages" inheritance tree
1378INFO: analyzing "public.ci_stages"
1379INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1380# [RSpecRunTime] Finishing example group spec/migrations/20231102142554_migrate_zoekt_shards_to_zoekt_nodes_spec.rb. It took 48.04 seconds. Expected to take 25.48 seconds.
1381# [RSpecRunTime] RSpec elapsed time: 27 minutes 29.13 seconds. Current RSS: ~1355M. load average: 0.95 1.01 1.06 1/272 415
1382# [RSpecRunTime] Starting example group spec/migrations/20240116072014_change_i_code_review_create_mr_keys_from_hll_to_integer_spec.rb. Expected to take 14.25 seconds.
1383ChangeICodeReviewCreateMrKeysFromHllToInteger
1384 #up
1385main: == [advisory_lock_connection] object_id: 297254300, pg_backend_pid: 294
1386main: == 20240116072014 ChangeICodeReviewCreateMrKeysFromHllToInteger: migrating ====
1387main: == 20240116072014 ChangeICodeReviewCreateMrKeysFromHllToInteger: migrated (0.0132s)
1388main: == [advisory_lock_connection] object_id: 297254300, pg_backend_pid: 294
1389 migrates all RedisHLL keys for i_code_review_create_mr
1390main: == [advisory_lock_connection] object_id: 298326340, pg_backend_pid: 296
1391main: == 20240116072014 ChangeICodeReviewCreateMrKeysFromHllToInteger: migrating ====
1392main: == 20240116072014 ChangeICodeReviewCreateMrKeysFromHllToInteger: migrated (0.0117s)
1393main: == [advisory_lock_connection] object_id: 298326340, pg_backend_pid: 296
1394 does not not migrate other RedisHLL keys
1395# [RSpecRunTime] RSpec elapsed time: 27 minutes 42.29 seconds. Current RSS: ~1351M. load average: 0.88 1.00 1.05 1/272 416
1396INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1397INFO: analyzing "public.ci_pipeline_variables"
1398INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1399INFO: analyzing "public.p_ci_job_artifacts" inheritance tree
1400INFO: analyzing "public.ci_job_artifacts"
1401INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1402INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1403INFO: analyzing "public.ci_pipeline_variables"
1404INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1405INFO: analyzing "public.p_ci_stages" inheritance tree
1406INFO: analyzing "public.ci_stages"
1407INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1408# [RSpecRunTime] Finishing example group spec/migrations/20240116072014_change_i_code_review_create_mr_keys_from_hll_to_integer_spec.rb. It took 26.48 seconds. Expected to take 14.25 seconds.
1409# [RSpecRunTime] RSpec elapsed time: 27 minutes 55.64 seconds. Current RSS: ~1348M. load average: 0.90 1.00 1.05 1/272 417
1410# [RSpecRunTime] Starting example group spec/migrations/20240108185335_backfill_internal_ids_with_issues_usage_for_epics_spec.rb. Expected to take 12.26 seconds.
1411BackfillInternalIdsWithIssuesUsageForEpics
1412 #up
1413main: == [advisory_lock_connection] object_id: 302888480, pg_backend_pid: 302
1414main: == 20240108185335 BackfillInternalIdsWithIssuesUsageForEpics: migrating =======
1415main: == 20240108185335 BackfillInternalIdsWithIssuesUsageForEpics: migrated (0.0687s)
1416main: == [advisory_lock_connection] object_id: 302888480, pg_backend_pid: 302
1417 backfills internal_ids for epics as group level issues
1418# [RSpecRunTime] RSpec elapsed time: 28 minutes 7.69 seconds. Current RSS: ~1344M. load average: 0.99 1.01 1.06 1/272 418
1419INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1420INFO: analyzing "public.ci_pipeline_variables"
1421INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1422INFO: analyzing "public.p_ci_job_artifacts" inheritance tree
1423INFO: analyzing "public.ci_job_artifacts"
1424INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1425INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1426INFO: analyzing "public.ci_pipeline_variables"
1427INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1428INFO: analyzing "public.p_ci_stages" inheritance tree
1429INFO: analyzing "public.ci_stages"
1430INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1431# [RSpecRunTime] Finishing example group spec/migrations/20240108185335_backfill_internal_ids_with_issues_usage_for_epics_spec.rb. It took 26.38 seconds. Expected to take 12.26 seconds.
1432# [RSpecRunTime] RSpec elapsed time: 28 minutes 22.06 seconds. Current RSS: ~1341M. load average: 1.00 1.01 1.05 1/272 419
1433auto_explain log contains 928 entries for main, writing to /builds/gitlab-org/gitlab/auto_explain/rspec-migration-pg14-single-db-14-15.337.main.ndjson.gz
1434took 12.588759113
1435[TEST PROF INFO] EventProf results for sql.active_record
1436Total time: 21:15.592 of 28:18.579 (75.1%)
1437Total events: 691432
1438Top 5 slowest suites (by time):
1439RescheduleMigrationForLinks (./spec/migrations/20230314144640_reschedule_migration_for_links_spec.rb:6) – 02:06.745 (63293 / 2) of 02:46.332 (76.2%)
1440ScheduleMigra...ityIdentifiers (./spec/migrations/schedule_migrate_shared_vulnerability_identifiers_spec.rb:7) – 02:02.619 (66892 / 2) of 02:45.666 (74.02%)
1441SwapMergeRequ...oteIdToBigint2 (./spec/migrations/swap_merge_request_user_mentions_note_id_to_bigint_2_spec.rb:7) – 02:02.590 (65545 / 3) of 02:43.838 (74.82%)
1442SwapEpicUserM...orGitlabDotCom (./spec/migrations/swap_epic_user_mentions_note_id_to_bigint_for_gitlab_dot_com_spec.rb:6) – 02:00.547 (60016 / 2) of 02:36.194 (77.18%)
1443DropPackagesEventsTable (./spec/migrations/drop_packages_events_table_spec.rb:7) – 01:52.040 (62031 / 1) of 02:29.192 (75.1%)
1444Knapsack report was generated. Preview:
1445{
1446 "spec/migrations/schedule_migrate_shared_vulnerability_identifiers_spec.rb": 78.71250459899966,
1447 "spec/migrations/swap_merge_request_user_mentions_note_id_to_bigint_2_spec.rb": 77.66362481600117,
1448 "spec/migrations/swap_epic_user_mentions_note_id_to_bigint_for_gitlab_dot_com_spec.rb": 73.80511964899961,
1449 "spec/migrations/20230314144640_reschedule_migration_for_links_spec.rb": 77.37457117799931,
1450 "spec/migrations/20230303105806_queue_delete_orphaned_packages_dependencies_spec.rb": 78.56457479399978,
1451 "spec/migrations/drop_packages_events_table_spec.rb": 64.82344979799927,
1452 "spec/migrations/ensure_merge_request_metrics_id_bigint_backfill_is_finished_for_self_hosts_spec.rb": 61.74185192799996,
1453 "spec/migrations/20230505115558_add_authors_and_description_to_nuget_metadatum_spec.rb": 60.818674080001074,
1454 "spec/migrations/20230719083202_backfill_project_statistics_storage_size_without_pipeline_artifacts_size_spec.rb": 45.17789473999983,
1455 "spec/migrations/20230712145557_queue_backfill_missing_vulnerability_dismissal_details_spec.rb": 45.04819602200041,
1456 "spec/migrations/20230810123044_swap_snippet_user_mentions_note_id_to_bigint_for_self_hosts_spec.rb": 40.396274679998896,
1457 "spec/migrations/20230728174927_add_epic_work_item_type_spec.rb": 37.70131847599987,
1458 "spec/migrations/20230823090001_queue_backfill_project_statistics_storage_size_with_recent_size_spec.rb": 31.579735060999155,
1459 "spec/migrations/db/migrate/20231103162825_add_wolfi_purl_type_to_package_metadata_purl_types_spec.rb": 24.822555169001134,
1460 "spec/migrations/20231102142554_migrate_zoekt_shards_to_zoekt_nodes_spec.rb": 23.008798266999293,
1461 "spec/migrations/20240116072014_change_i_code_review_create_mr_keys_from_hll_to_integer_spec.rb": 13.244944756999757,
1462 "spec/migrations/20240108185335_backfill_internal_ids_with_issues_usage_for_epics_spec.rb": 12.112564824999936
1463}
1464Knapsack global time execution for tests: 14m 06s
1465Finished in 28 minutes 35 seconds (files took 49.63 seconds to load)
146630 examples, 0 failures
1467Randomized with seed 56404
1468[TEST PROF INFO] Time spent in factories: 00:00.248 (0.01% of total time)
1469RSpec exited with 0.
1470No examples to retry, congrats!
1471 Running after_script 00:06
1472Running after script...
1473$ echo -e "\e[0Ksection_start:`date +%s`:report_results_section[collapsed=true]\r\e[0KReport results"
1474 Report results 00:04
1484$ tooling/bin/push_job_metrics || true
1485[job-metrics] Pushing job metrics file for the CI/CD job.
1486[job-metrics] Pushed 4 CI job metric entries to InfluxDB.
1487 Saving cache for successful job 00:00
1488Not uploading cache ruby-gems-debian-bookworm-ruby-3.1-17 due to policy
1489 Uploading artifacts for successful job 00:05
1490Uploading artifacts...
1491auto_explain/: found 2 matching artifact files and directories
1492coverage/: found 5 matching artifact files and directories
1493crystalball/: found 2 matching artifact files and directories
1494WARNING: deprecations/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab)
1495knapsack/: found 4 matching artifact files and directories
1496rspec/: found 16 matching artifact files and directories
1497WARNING: tmp/capybara/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab)
1498log/*.log: found 13 matching artifact files and directories
1499WARNING: Upload request redirected location=https://gitlab.com/api/v4/jobs/6311411163/artifacts?artifact_format=zip&artifact_type=archive&expire_in=31d new-url=https://gitlab.com
1500WARNING: Retrying... context=artifacts-uploader error=request redirected
1501Uploading artifacts as "archive" to coordinator... 201 Created id=6311411163 responseStatus=201 Created token=glcbt-65
1502Uploading artifacts...
1503rspec/rspec-*.xml: found 1 matching artifact files and directories
1504WARNING: Upload request redirected location=https://gitlab.com/api/v4/jobs/6311411163/artifacts?artifact_format=gzip&artifact_type=junit&expire_in=31d new-url=https://gitlab.com
1505WARNING: Retrying... context=artifacts-uploader error=request redirected
1506Uploading artifacts as "junit" to coordinator... 201 Created id=6311411163 responseStatus=201 Created token=glcbt-65
1507 Cleaning up project directory and file based variables 00:00
1508Job succeeded