Skip to content
Snippets Groups Projects

rspec migration pg14 single-db 15/15

Passed Started by
Krasimir Angelov
@krasio
1Running with gitlab-runner 17.0.0~pre.88.g761ae5dd (761ae5dd)
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
4Resolving secrets
5 Preparing the "docker+machine" executor 00:06
6Using Docker executor with image registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bookworm-ruby-3.2.patched-golang-1.21-rust-1.73-node-20.12-postgresql-14:rubygems-3.4-git-2.36-lfs-2.9-chrome-123-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:0fc0b666ef9eb249e61edd4e2ec434a328e98117079727c5e7cf6dc9a00d7a94 for redis:6.2-alpine with digest redis@sha256:c6abddbb4223951cf5cb54a19d4a83418582fa69c97c0458ab4f0974f24f119c ...
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.2.patched-golang-1.21-rust-1.73-node-20.12-postgresql-14:rubygems-3.4-git-2.36-lfs-2.9-chrome-123-yarn-1.22-graphicsmagick-1.3.36 ...
23Using docker image sha256:d10d211334d3c94a5e626cf961467431b7d3f3bd8b6109e5caf9357421c0117b for registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bookworm-ruby-3.2.patched-golang-1.21-rust-1.73-node-20.12-postgresql-14:rubygems-3.4-git-2.36-lfs-2.9-chrome-123-yarn-1.22-graphicsmagick-1.3.36 with digest registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bookworm-ruby-3.2.patched-golang-1.21-rust-1.73-node-20.12-postgresql-14@sha256:3c4cd9a237deb59350b4836552151ba2aae96247034074c8f0c2ccaff4558cab ...
24 Preparing environment 00:01
25Running on runner-quqpofsc-project-278964-concurrent-0 via runner-quqpofsc-private-1717022594-32933835...
26 Getting source from Git repository 00:00
27Skipping Git repository setup
28Skipping Git checkout
29Skipping Git submodules setup
30 Restoring cache 00:20
31Checking cache for ruby-gems-debian-bookworm-ruby-3.2-17...
32Downloading cache from https://storage.googleapis.com/gitlab-com-runners-cache/project/278964/ruby-gems-debian-bookworm-ruby-3.2-17
33Successfully extracted cache
34 Downloading artifacts 00:41
35Downloading artifacts for clone-gitlab-repo (6975007209)...
36Downloading artifacts from coordinator... ok host=storage.googleapis.com id=6975007209 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 (6975007223)...
40Downloading artifacts from coordinator... ok host=storage.googleapis.com id=6975007223 responseStatus=200 OK token=glcbt-65
41Downloading artifacts for detect-tests (6975007229)...
42Downloading artifacts from coordinator... ok host=storage.googleapis.com id=6975007229 responseStatus=200 OK token=glcbt-65
43Downloading artifacts for retrieve-tests-metadata (6975007235)...
44Downloading artifacts from coordinator... ok host=storage.googleapis.com id=6975007235 responseStatus=200 OK token=glcbt-65
45Downloading artifacts for setup-test-env (6975007225)...
46Downloading artifacts from coordinator... ok host=storage.googleapis.com id=6975007225 responseStatus=200 OK token=glcbt-65
47 Executing "step_script" stage of the job script
48Using docker image sha256:d10d211334d3c94a5e626cf961467431b7d3f3bd8b6109e5caf9357421c0117b for registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bookworm-ruby-3.2.patched-golang-1.21-rust-1.73-node-20.12-postgresql-14:rubygems-3.4-git-2.36-lfs-2.9-chrome-123-yarn-1.22-graphicsmagick-1.3.36 with digest registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bookworm-ruby-3.2.patched-golang-1.21-rust-1.73-node-20.12-postgresql-14@sha256:3c4cd9a237deb59350b4836552151ba2aae96247034074c8f0c2ccaff4558cab ...
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:14
755Using two connections, single database config (config/database.yml.postgresql)
756Disabling ci connection in config/database.yml
757Geo DB won't be set up.
758Embedding DB won't be set up.
759 Setting up DBs 00:39
782$ source ./scripts/rspec_helpers.sh
783$ run_timed_command "gem install knapsack --no-document"
784$ gem install knapsack --no-document
785Successfully installed knapsack-4.0.0
7861 gem installed
787==> 'gem install knapsack --no-document' succeeded in 0 seconds.
788$ section_start "gitaly-test-spawn" "Spawning Gitaly"; scripts/gitaly-test-spawn; section_end "gitaly-test-spawn"
789 Spawning Gitaly 00:03
793$ export RSPEC_SKIPPED_TESTS_REPORT_PATH="rspec/skipped_tests-${CI_JOB_ID}.txt"
794$ export RSPEC_RETRIED_TESTS_REPORT_PATH="rspec/retried_tests-${CI_JOB_ID}.txt"
795$ tooling/bin/create_job_metrics_file || true
796[job-metrics] Creating the job metrics file for the CI/CD job.
797$ rspec_section rspec_parallelized_job "--fail-fast=${RSPEC_FAIL_FAST_THRESHOLD} --tag ~quarantine --tag ~zoekt --tag ~click_house"
798 RSpec 26:47
799[23:31:14] Starting rspec_parallelized_job
800RETRY_FAILED_TESTS_IN_NEW_PROCESS: true
801KNAPSACK_GENERATE_REPORT: true
802FLAKY_RSPEC_GENERATE_REPORT: true
803KNAPSACK_TEST_FILE_PATTERN: spec/{migrations}{,/**/}*_spec.rb
804KNAPSACK_LOG_LEVEL: debug
805KNAPSACK_REPORT_PATH: knapsack/rspec_migration_pg14_single-db_15_15_278964_report.json
806FLAKY_RSPEC_SUITE_REPORT_PATH: rspec/flaky/report-suite.json
807FLAKY_RSPEC_REPORT_PATH: rspec/flaky/all_rspec_migration_pg14_single-db_15_15_278964_report.json
808NEW_FLAKY_RSPEC_REPORT_PATH: rspec/flaky/new_rspec_migration_pg14_single-db_15_15_278964_report.json
809RSPEC_SKIPPED_TESTS_REPORT_PATH: rspec/skipped_tests-6975007419.txt
810CRYSTALBALL:
811RSPEC_TESTS_MAPPING_ENABLED:
812RSPEC_TESTS_FILTER_FILE:
813Shell set options (set -o) enabled:
814braceexpand on
815hashall on
816interactive-comments on
817pipefail on
818Knapsack report generator started!
819 ██  ██  █████  ██████  ███  ██ ██ ███  ██  ██████ 
820 ██  ██ ██   ██ ██   ██ ████  ██ ██ ████  ██ ██      
821 ██  █  ██ ███████ ██████  ██ ██  ██ ██ ██ ██  ██ ██  ███ 
822 ██ ███ ██ ██   ██ ██   ██ ██  ██ ██ ██ ██  ██ ██ ██  ██ 
823  ███ ███  ██  ██ ██  ██ ██   ████ ██ ██   ████  ██████  
824******************************************************************************
825 Your database has a single connection, and single connections were
826 deprecated in GitLab 15.9 https://docs.gitlab.com/ee/update/deprecations.html#single-database-connection-is-deprecated.
827 In GitLab 17.0 and later, you must have the two main: and ci: sections in your database.yml.
828 Please add a :ci section to your database, following these instructions:
829 https://docs.gitlab.com/ee/install/installation.html#configure-gitlab-db-settings.
830******************************************************************************
831warning: parser/current is loading parser/ruby32, which recognizes 3.2.3-compliant syntax, but you are running 3.2.4.
832Please see https://github.com/whitequark/parser#compatibility-with-ruby-mri.
833Run options: exclude {:quarantine=>true, :zoekt=>true, :click_house=>true}
834# [RSpecRunTime] Starting RSpec timer...
835[TEST PROF INFO] EventProf enabled (sql.active_record)
836unknown OID 2249: failed to recognize type of 'pg_stat_file'. It will be treated as String.
837Test environment set up in 0.582418003 seconds
838# [RSpecRunTime] Starting example group spec/migrations/20230817111938_swap_events_target_id_to_bigint_for_self_hosts_spec.rb. Expected to take 3 minutes 23.35 seconds.
839SwapEventsTargetIdToBigintForSelfHosts
840 #up
841 when GitLab.com, dev, or test
842 behaves like column `target_id_convert_to_bigint` is already dropped
843 does not swap the columns
844 when self-managed instance with the `target_id_convert_to_bigint` column already dropped
845 behaves like column `target_id_convert_to_bigint` is already dropped
846 does not swap the columns
847# [RSpecRunTime] RSpec elapsed time: 1 minute 59.23 seconds. Current RSS: ~1180M. Threads: 2. load average: 1.14 0.93 0.86 1/290 391
848.
849 when self-managed instance columns already swapped
850 does not swaps the columns
851# [RSpecRunTime] RSpec elapsed time: 2 minutes 15.72 seconds. Current RSS: ~1145M. Threads: 2. load average: 1.11 0.94 0.86 1/284 392
852.
853 when self-managed instance
854 swaps the columns
855# [RSpecRunTime] RSpec elapsed time: 2 minutes 45.79 seconds. Current RSS: ~1167M. Threads: 2. load average: 1.07 0.94 0.87 1/284 393
856.
857INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
858INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
859INFO: "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
860INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_101"
861INFO: "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
862INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_102"
863INFO: "ci_runner_machine_builds_102": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
864INFO: analyzing "public.p_ci_job_annotations" inheritance tree
865INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
866INFO: "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
867INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_101"
868INFO: "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
869INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_102"
870INFO: "ci_job_annotations_102": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
871INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
872INFO: analyzing "public.ci_builds_metadata"
873INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
874INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_101"
875INFO: "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
876INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_102"
877INFO: "ci_builds_metadata_102": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
878INFO: analyzing "public.p_ci_builds" inheritance tree
879INFO: analyzing "public.ci_builds"
880INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
881INFO: analyzing "gitlab_partitions_dynamic.ci_builds_101"
882INFO: "ci_builds_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
883INFO: analyzing "gitlab_partitions_dynamic.ci_builds_102"
884INFO: "ci_builds_102": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
885INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
886INFO: analyzing "public.ci_pipeline_variables"
887INFO: "ci_pipeline_variables": 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_pipeline_variables" inheritance tree
889INFO: analyzing "public.ci_pipeline_variables"
890INFO: "ci_pipeline_variables": 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_job_artifacts" inheritance tree
892INFO: analyzing "public.ci_job_artifacts"
893INFO: "ci_job_artifacts": 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_stages" inheritance tree
895INFO: analyzing "public.ci_stages"
896INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
897# [RSpecRunTime] Finishing example group spec/migrations/20230817111938_swap_events_target_id_to_bigint_for_self_hosts_spec.rb. It took 3 minutes 41.42 seconds. Expected to take 3 minutes 23.35 seconds.
898# [RSpecRunTime] RSpec elapsed time: 3 minutes 43.94 seconds. Current RSS: ~1135M. Threads: 2. load average: 1.02 0.96 0.88 1/284 395
899.
900# [RSpecRunTime] Starting example group spec/migrations/swap_merge_request_user_mentions_note_id_to_bigint_for_self_managed_spec.rb. Expected to take 3 minutes 22.12 seconds.
901SwapMergeRequestUserMentionsNoteIdToBigintForSelfManaged
902 #up
903 when GitLab.com, dev, or test
904 behaves like column `note_id_convert_to_bigint` is already dropped
905 does not swaps the columns
906# [RSpecRunTime] RSpec elapsed time: 5 minutes 3.26 seconds. Current RSS: ~1176M. Threads: 2. load average: 1.02 0.97 0.89 1/283 396
907.
908 when self-managed instance with the `note_id_convert_to_bigint` column already dropped
909 behaves like column `note_id_convert_to_bigint` is already dropped
910 does not swaps the columns
911# [RSpecRunTime] RSpec elapsed time: 5 minutes 32.4 seconds. Current RSS: ~1186M. Threads: 2. load average: 1.01 0.97 0.90 1/283 397
912.
913 when self-managed instance columns already swapped
914 does not swaps the columns
915# [RSpecRunTime] RSpec elapsed time: 5 minutes 47.97 seconds. Current RSS: ~1154M. Threads: 2. load average: 1.01 0.97 0.90 3/283 398
916.
917 when self-managed instance
918 swaps the columns
919# [RSpecRunTime] RSpec elapsed time: 6 minutes 17.83 seconds. Current RSS: ~1175M. Threads: 2. load average: 1.08 0.99 0.91 1/283 399
920.
921INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
922INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
923INFO: "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
924INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_101"
925INFO: "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
926INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_102"
927INFO: "ci_runner_machine_builds_102": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
928INFO: analyzing "public.p_ci_job_annotations" inheritance tree
929INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
930INFO: "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
931INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_101"
932INFO: "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
933INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_102"
934INFO: "ci_job_annotations_102": 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_metadata" inheritance tree
936INFO: analyzing "public.ci_builds_metadata"
937INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
938INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_101"
939INFO: "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
940INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_102"
941INFO: "ci_builds_metadata_102": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
942INFO: analyzing "public.p_ci_builds" inheritance tree
943INFO: analyzing "public.ci_builds"
944INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
945INFO: analyzing "gitlab_partitions_dynamic.ci_builds_101"
946INFO: "ci_builds_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
947INFO: analyzing "gitlab_partitions_dynamic.ci_builds_102"
948INFO: "ci_builds_102": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
949INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
950INFO: analyzing "public.ci_pipeline_variables"
951INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
952INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
953INFO: analyzing "public.ci_pipeline_variables"
954INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
955INFO: analyzing "public.p_ci_job_artifacts" inheritance tree
956INFO: analyzing "public.ci_job_artifacts"
957INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
958INFO: analyzing "public.p_ci_stages" inheritance tree
959INFO: analyzing "public.ci_stages"
960INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
961# [RSpecRunTime] Finishing example group spec/migrations/swap_merge_request_user_mentions_note_id_to_bigint_for_self_managed_spec.rb. It took 3 minutes 33.95 seconds. Expected to take 3 minutes 22.12 seconds.
962# [RSpecRunTime] RSpec elapsed time: 7 minutes 17.92 seconds. Current RSS: ~1138M. Threads: 2. load average: 0.87 0.95 0.90 1/284 400
963.
964# [RSpecRunTime] Starting example group spec/migrations/backfill_alert_management_prometheus_integrations_spec.rb. Expected to take 2 minutes 1.92 seconds.
965BackfillAlertManagementPrometheusIntegrations
966main: == [advisory_lock_connection] object_id: 90390060, pg_backend_pid: 158
967main: == 20230811211544 BackfillAlertManagementPrometheusIntegrations: migrating ====
968main: -- execute("INSERT INTO alert_management_http_integrations (\n project_id,\n encrypted_token,\n encrypted_token_iv,\n active,\n name,\n endpoint_identifier,\n type_identifier,\n created_at,\n updated_at\n) SELECT\n project_alerting_settings.project_id,\n project_alerting_settings.encrypted_token,\n project_alerting_settings.encrypted_token_iv,\n COALESCE(integrations.active, FALSE),\n 'Prometheus',\n 'legacy-prometheus',\n 1, --type_identifiers { http: 0, prometheus: 1 }\n CURRENT_TIMESTAMP,\n CURRENT_TIMESTAMP\nFROM project_alerting_settings\nLEFT JOIN integrations\nON project_alerting_settings.project_id = integrations.project_id\nAND integrations.type_new = 'Integrations::Prometheus'\nWHERE project_alerting_settings.project_id BETWEEN 1 AND 1\nON CONFLICT DO NOTHING\n")
969main: -> 0.0040s
970main: -- execute("INSERT INTO alert_management_http_integrations (\n project_id,\n encrypted_token,\n encrypted_token_iv,\n active,\n name,\n endpoint_identifier,\n type_identifier,\n created_at,\n updated_at\n) SELECT\n project_alerting_settings.project_id,\n project_alerting_settings.encrypted_token,\n project_alerting_settings.encrypted_token_iv,\n COALESCE(integrations.active, FALSE),\n 'Prometheus',\n 'legacy-prometheus',\n 1, --type_identifiers { http: 0, prometheus: 1 }\n CURRENT_TIMESTAMP,\n CURRENT_TIMESTAMP\nFROM project_alerting_settings\nLEFT JOIN integrations\nON project_alerting_settings.project_id = integrations.project_id\nAND integrations.type_new = 'Integrations::Prometheus'\nWHERE project_alerting_settings.project_id BETWEEN 2 AND 2\nON CONFLICT DO NOTHING\n")
971main: -> 0.0027s
972main: -- execute("INSERT INTO alert_management_http_integrations (\n project_id,\n encrypted_token,\n encrypted_token_iv,\n active,\n name,\n endpoint_identifier,\n type_identifier,\n created_at,\n updated_at\n) SELECT\n project_alerting_settings.project_id,\n project_alerting_settings.encrypted_token,\n project_alerting_settings.encrypted_token_iv,\n COALESCE(integrations.active, FALSE),\n 'Prometheus',\n 'legacy-prometheus',\n 1, --type_identifiers { http: 0, prometheus: 1 }\n CURRENT_TIMESTAMP,\n CURRENT_TIMESTAMP\nFROM project_alerting_settings\nLEFT JOIN integrations\nON project_alerting_settings.project_id = integrations.project_id\nAND integrations.type_new = 'Integrations::Prometheus'\nWHERE project_alerting_settings.project_id BETWEEN 3 AND 3\nON CONFLICT DO NOTHING\n")
973main: -> 0.0023s
974main: == 20230811211544 BackfillAlertManagementPrometheusIntegrations: migrated (0.0399s)
975main: == [advisory_lock_connection] object_id: 90390060, pg_backend_pid: 158
976 correctly migrates up and down
977 with existing synced http integrations
978main: == [advisory_lock_connection] object_id: 90895760, pg_backend_pid: 162
979main: == 20230811211544 BackfillAlertManagementPrometheusIntegrations: migrating ====
980main: -- execute("INSERT INTO alert_management_http_integrations (\n project_id,\n encrypted_token,\n encrypted_token_iv,\n active,\n name,\n endpoint_identifier,\n type_identifier,\n created_at,\n updated_at\n) SELECT\n project_alerting_settings.project_id,\n project_alerting_settings.encrypted_token,\n project_alerting_settings.encrypted_token_iv,\n COALESCE(integrations.active, FALSE),\n 'Prometheus',\n 'legacy-prometheus',\n 1, --type_identifiers { http: 0, prometheus: 1 }\n CURRENT_TIMESTAMP,\n CURRENT_TIMESTAMP\nFROM project_alerting_settings\nLEFT JOIN integrations\nON project_alerting_settings.project_id = integrations.project_id\nAND integrations.type_new = 'Integrations::Prometheus'\nWHERE project_alerting_settings.project_id BETWEEN 4 AND 4\nON CONFLICT DO NOTHING\n")
981main: -> 0.0040s
982main: -- execute("INSERT INTO alert_management_http_integrations (\n project_id,\n encrypted_token,\n encrypted_token_iv,\n active,\n name,\n endpoint_identifier,\n type_identifier,\n created_at,\n updated_at\n) SELECT\n project_alerting_settings.project_id,\n project_alerting_settings.encrypted_token,\n project_alerting_settings.encrypted_token_iv,\n COALESCE(integrations.active, FALSE),\n 'Prometheus',\n 'legacy-prometheus',\n 1, --type_identifiers { http: 0, prometheus: 1 }\n CURRENT_TIMESTAMP,\n CURRENT_TIMESTAMP\nFROM project_alerting_settings\nLEFT JOIN integrations\nON project_alerting_settings.project_id = integrations.project_id\nAND integrations.type_new = 'Integrations::Prometheus'\nWHERE project_alerting_settings.project_id BETWEEN 5 AND 5\nON CONFLICT DO NOTHING\n")
983main: -> 0.0025s
984main: -- execute("INSERT INTO alert_management_http_integrations (\n project_id,\n encrypted_token,\n encrypted_token_iv,\n active,\n name,\n endpoint_identifier,\n type_identifier,\n created_at,\n updated_at\n) SELECT\n project_alerting_settings.project_id,\n project_alerting_settings.encrypted_token,\n project_alerting_settings.encrypted_token_iv,\n COALESCE(integrations.active, FALSE),\n 'Prometheus',\n 'legacy-prometheus',\n 1, --type_identifiers { http: 0, prometheus: 1 }\n CURRENT_TIMESTAMP,\n CURRENT_TIMESTAMP\nFROM project_alerting_settings\nLEFT JOIN integrations\nON project_alerting_settings.project_id = integrations.project_id\nAND integrations.type_new = 'Integrations::Prometheus'\nWHERE project_alerting_settings.project_id BETWEEN 6 AND 6\nON CONFLICT DO NOTHING\n")
985main: -> 0.0038s
986main: == 20230811211544 BackfillAlertManagementPrometheusIntegrations: migrated (0.0481s)
987main: == [advisory_lock_connection] object_id: 90895760, pg_backend_pid: 162
988 does not overwrite synced attributes
989# [RSpecRunTime] RSpec elapsed time: 9 minutes 0.38 second. Current RSS: ~1167M. Threads: 2. load average: 0.90 0.95 0.91 1/284 401
990.
991INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
992INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
993INFO: "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
994INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_101"
995INFO: "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
996INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_102"
997INFO: "ci_runner_machine_builds_102": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
998INFO: analyzing "public.p_ci_job_annotations" inheritance tree
999INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
1000INFO: "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
1001INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_101"
1002INFO: "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
1003INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_102"
1004INFO: "ci_job_annotations_102": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1005INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
1006INFO: analyzing "public.ci_builds_metadata"
1007INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1008INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_101"
1009INFO: "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
1010INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_102"
1011INFO: "ci_builds_metadata_102": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1012INFO: analyzing "public.p_ci_builds" inheritance tree
1013INFO: analyzing "public.ci_builds"
1014INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1015INFO: analyzing "gitlab_partitions_dynamic.ci_builds_101"
1016INFO: "ci_builds_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1017INFO: analyzing "gitlab_partitions_dynamic.ci_builds_102"
1018INFO: "ci_builds_102": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1019INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1020INFO: analyzing "public.ci_pipeline_variables"
1021INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1022INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1023INFO: analyzing "public.ci_pipeline_variables"
1024INFO: "ci_pipeline_variables": 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_artifacts" inheritance tree
1026INFO: analyzing "public.ci_job_artifacts"
1027INFO: "ci_job_artifacts": 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_stages" inheritance tree
1029INFO: analyzing "public.ci_stages"
1030INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1031# [RSpecRunTime] Finishing example group spec/migrations/backfill_alert_management_prometheus_integrations_spec.rb. It took 2 minutes 47.32 seconds. Expected to take 2 minutes 1.92 seconds.
1032# [RSpecRunTime] RSpec elapsed time: 10 minutes 5.28 seconds. Current RSS: ~1157M. Threads: 2. load average: 1.00 0.97 0.92 1/284 402
1033.
1034# [RSpecRunTime] Starting example group spec/migrations/20230823090001_queue_backfill_project_statistics_storage_size_with_recent_size_spec.rb. Expected to take 1 minute 47.55 seconds.
1035QueueBackfillProjectStatisticsStorageSizeWithRecentSize
1036main: == [advisory_lock_connection] object_id: 125806020, pg_backend_pid: 172
1037main: == 20230823090001 QueueBackfillProjectStatisticsStorageSizeWithRecentSize: migrating
1038main: == 20230823090001 QueueBackfillProjectStatisticsStorageSizeWithRecentSize: migrated (0.0590s)
1039main: == [advisory_lock_connection] object_id: 125806020, pg_backend_pid: 172
1040 schedules a new batched migration
1041INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
1042INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
1043INFO: "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
1044INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_101"
1045INFO: "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
1046INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_102"
1047INFO: "ci_runner_machine_builds_102": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1048INFO: analyzing "public.p_ci_job_annotations" inheritance tree
1049INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
1050INFO: "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
1051INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_101"
1052INFO: "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
1053INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_102"
1054INFO: "ci_job_annotations_102": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1055INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
1056INFO: analyzing "public.ci_builds_metadata"
1057INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1058INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_101"
1059INFO: "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
1060INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_102"
1061INFO: "ci_builds_metadata_102": 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_builds" inheritance tree
1063INFO: analyzing "public.ci_builds"
1064INFO: "ci_builds": 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_builds_101"
1066INFO: "ci_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 "gitlab_partitions_dynamic.ci_builds_102"
1068INFO: "ci_builds_102": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1069INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1070INFO: analyzing "public.ci_pipeline_variables"
1071INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1072INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1073INFO: analyzing "public.ci_pipeline_variables"
1074INFO: "ci_pipeline_variables": 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_job_artifacts" inheritance tree
1076INFO: analyzing "public.ci_job_artifacts"
1077INFO: "ci_job_artifacts": 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_stages" inheritance tree
1079INFO: analyzing "public.ci_stages"
1080INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1081# [RSpecRunTime] Finishing example group spec/migrations/20230823090001_queue_backfill_project_statistics_storage_size_with_recent_size_spec.rb. It took 2 minutes 33.4 seconds. Expected to take 1 minute 47.55 seconds.
1082# [RSpecRunTime] RSpec elapsed time: 12 minutes 38.72 seconds. Current RSS: ~1149M. Threads: 2. load average: 0.90 0.96 0.92 1/285 403
1083.
1084# [RSpecRunTime] Starting example group spec/migrations/20230721095223_delete_orphans_approval_merge_request_rules2_spec.rb. Expected to take 1 minute 40.49 seconds.
1085DeleteOrphansApprovalMergeRequestRules2
1086 #up
1087main: == [advisory_lock_connection] object_id: 161381160, pg_backend_pid: 184
1088main: == 20230721095223 DeleteOrphansApprovalMergeRequestRules2: migrating ==========
1089main: == 20230721095223 DeleteOrphansApprovalMergeRequestRules2: migrated (0.0956s) =
1090main: == [advisory_lock_connection] object_id: 161381160, pg_backend_pid: 184
1091 schedules background migration for merge request approval rules
1092# [RSpecRunTime] RSpec elapsed time: 14 minutes 5.9 seconds. Current RSS: ~1193M. Threads: 2. load average: 0.87 0.93 0.91 1/285 404
1093.
1094INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
1095INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
1096INFO: "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
1097INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_101"
1098INFO: "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
1099INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_102"
1100INFO: "ci_runner_machine_builds_102": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1101INFO: analyzing "public.p_ci_job_annotations" inheritance tree
1102INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
1103INFO: "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
1104INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_101"
1105INFO: "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
1106INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_102"
1107INFO: "ci_job_annotations_102": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1108INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
1109INFO: analyzing "public.ci_builds_metadata"
1110INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1111INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_101"
1112INFO: "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
1113INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_102"
1114INFO: "ci_builds_metadata_102": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1115INFO: analyzing "public.p_ci_builds" inheritance tree
1116INFO: analyzing "public.ci_builds"
1117INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1118INFO: analyzing "gitlab_partitions_dynamic.ci_builds_101"
1119INFO: "ci_builds_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1120INFO: analyzing "gitlab_partitions_dynamic.ci_builds_102"
1121INFO: "ci_builds_102": 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_pipeline_variables" inheritance tree
1123INFO: analyzing "public.ci_pipeline_variables"
1124INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1125INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1126INFO: analyzing "public.ci_pipeline_variables"
1127INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1128INFO: analyzing "public.p_ci_job_artifacts" inheritance tree
1129INFO: analyzing "public.ci_job_artifacts"
1130INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1131INFO: analyzing "public.p_ci_stages" inheritance tree
1132INFO: analyzing "public.ci_stages"
1133INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1134# [RSpecRunTime] Finishing example group spec/migrations/20230721095223_delete_orphans_approval_merge_request_rules2_spec.rb. It took 2 minutes 43.7 seconds. Expected to take 1 minute 40.49 seconds.
1135# [RSpecRunTime] RSpec elapsed time: 15 minutes 22.46 seconds. Current RSS: ~1144M. Threads: 2. load average: 0.94 0.93 0.92 1/285 405
1136.
1137# [RSpecRunTime] Starting example group spec/migrations/20230831084632_queue_sync_scan_result_policies_spec.rb. Expected to take 1 minute 36.49 seconds.
1138QueueSyncScanResultPolicies
1139main: == [advisory_lock_connection] object_id: 198196160, pg_backend_pid: 194
1140main: == 20230831084632 QueueSyncScanResultPolicies: migrating ======================
1141main: == 20230831084632 QueueSyncScanResultPolicies: migrated (0.0572s) =============
1142main: == [advisory_lock_connection] object_id: 198196160, pg_backend_pid: 194
1143 schedules a new batched migration
1144INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
1145INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
1146INFO: "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
1147INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_101"
1148INFO: "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
1149INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_102"
1150INFO: "ci_runner_machine_builds_102": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1151INFO: analyzing "public.p_ci_job_annotations" inheritance tree
1152INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
1153INFO: "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
1154INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_101"
1155INFO: "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
1156INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_102"
1157INFO: "ci_job_annotations_102": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1158INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
1159INFO: analyzing "public.ci_builds_metadata"
1160INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1161INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_101"
1162INFO: "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
1163INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_102"
1164INFO: "ci_builds_metadata_102": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1165INFO: analyzing "public.p_ci_builds" inheritance tree
1166INFO: analyzing "public.ci_builds"
1167INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1168INFO: analyzing "gitlab_partitions_dynamic.ci_builds_101"
1169INFO: "ci_builds_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1170INFO: analyzing "gitlab_partitions_dynamic.ci_builds_102"
1171INFO: "ci_builds_102": 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_pipeline_variables" inheritance tree
1176INFO: analyzing "public.ci_pipeline_variables"
1177INFO: "ci_pipeline_variables": 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_job_artifacts" inheritance tree
1179INFO: analyzing "public.ci_job_artifacts"
1180INFO: "ci_job_artifacts": 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/20230831084632_queue_sync_scan_result_policies_spec.rb. It took 2 minutes 34.23 seconds. Expected to take 1 minute 36.49 seconds.
1185# [RSpecRunTime] RSpec elapsed time: 17 minutes 56.74 seconds. Current RSS: ~1149M. Threads: 2. load average: 0.89 0.91 0.91 1/283 406
1186.
1187# [RSpecRunTime] Starting example group spec/migrations/20231130140901_queue_backfill_vs_code_settings_uuid_spec.rb. Expected to take 1 minute 10.65 seconds.
1188QueueBackfillVsCodeSettingsUuid
1189main: == [advisory_lock_connection] object_id: 229963620, pg_backend_pid: 204
1190main: == 20231130140901 QueueBackfillVsCodeSettingsUuid: migrating ==================
1191main: == 20231130140901 QueueBackfillVsCodeSettingsUuid: migrated (0.0661s) =========
1192main: == [advisory_lock_connection] object_id: 229963620, pg_backend_pid: 204
1193 schedules a new batched migration
1194INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1195INFO: analyzing "public.ci_pipeline_variables"
1196INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1197INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1198INFO: analyzing "public.ci_pipeline_variables"
1199INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1200INFO: analyzing "public.p_ci_job_artifacts" inheritance tree
1201INFO: analyzing "public.ci_job_artifacts"
1202INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1203INFO: analyzing "public.p_ci_stages" inheritance tree
1204INFO: analyzing "public.ci_stages"
1205INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1206# [RSpecRunTime] Finishing example group spec/migrations/20231130140901_queue_backfill_vs_code_settings_uuid_spec.rb. It took 1 minute 55.54 seconds. Expected to take 1 minute 10.65 seconds.
1207# [RSpecRunTime] RSpec elapsed time: 19 minutes 52.31 seconds. Current RSS: ~1140M. Threads: 2. load average: 0.93 0.92 0.91 1/283 407
1208.
1209# [RSpecRunTime] Starting example group spec/migrations/20240123102735_update_negative_star_counts_in_projects_spec.rb. Expected to take 1 minute 6.95 seconds.
1210UpdateNegativeStarCountsInProjects
1211 #down
1212main: == [advisory_lock_connection] object_id: 256754940, pg_backend_pid: 214
1213main: == 20240123102735 UpdateNegativeStarCountsInProjects: migrating ===============
1214main: == 20240123102735 UpdateNegativeStarCountsInProjects: migrated (0.0694s) ======
1215main: == [advisory_lock_connection] object_id: 256754940, pg_backend_pid: 214
1216 does nothing
1217# [RSpecRunTime] RSpec elapsed time: 20 minutes 42.57 seconds. Current RSS: ~1193M. Threads: 2. load average: 1.04 0.95 0.92 1/283 408
1218.
1219 #up
1220main: == [advisory_lock_connection] object_id: 257629120, pg_backend_pid: 217
1221main: == 20240123102735 UpdateNegativeStarCountsInProjects: migrating ===============
1222main: == 20240123102735 UpdateNegativeStarCountsInProjects: migrated (0.0382s) ======
1223main: == [advisory_lock_connection] object_id: 257629120, pg_backend_pid: 217
1224 updates the star_count
1225# [RSpecRunTime] RSpec elapsed time: 20 minutes 50.92 seconds. Current RSS: ~1162M. Threads: 2. load average: 1.03 0.95 0.92 1/283 409
1226.
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_stages" inheritance tree
1234INFO: analyzing "public.ci_stages"
1235INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1236# [RSpecRunTime] Finishing example group spec/migrations/20240123102735_update_negative_star_counts_in_projects_spec.rb. It took 1 minute 33.1 seconds. Expected to take 1 minute 6.95 seconds.
1237# [RSpecRunTime] RSpec elapsed time: 21 minutes 25.45 seconds. Current RSS: ~1157M. Threads: 2. load average: 1.02 0.96 0.93 1/283 410
1238.
1239# [RSpecRunTime] Starting example group spec/migrations/db/post_migrate/20240214040351_swap_columns_for_auto_canceled_by_id_between_ci_builds_and_ci_pipelines_spec.rb. Expected to take 45.78 seconds.
1240SwapColumnsForAutoCanceledByIdBetweenCiBuildsAndCiPipelines
1241 behaves like swap conversion columns
1242main: == [advisory_lock_connection] object_id: 281119320, pg_backend_pid: 224
1243main: == 20240219040351 SwapColumnsForAutoCanceledByIdBetweenCiBuildsAndCiPipelines: migrating
1244main: -- indexes(:p_ci_builds)
1245main: -> 0.0443s
1246main: -- execute("LOCK TABLE ci_pipelines, p_ci_builds IN ACCESS EXCLUSIVE MODE")
1247main: -> 0.0012s
1248main: -- clear_cache!(nil)
1249main: -> 0.0000s
1250main: -- quote_table_name(:p_ci_builds)
1251main: -> 0.0000s
1252main: -- quote_column_name(:auto_canceled_by_id_convert_to_bigint)
1253main: -> 0.0000s
1254main: -- quote_column_name(:temp_name_for_renaming)
1255main: -> 0.0000s
1256main: -- execute("ALTER TABLE \"p_ci_builds\"\n RENAME COLUMN \"auto_canceled_by_id_convert_to_bigint\" TO \"temp_name_for_renaming\"\n")
1257main: -> 0.0017s
1258main: -- clear_cache!(nil)
1259main: -> 0.0000s
1260main: -- quote_table_name(:p_ci_builds)
1261main: -> 0.0000s
1262main: -- quote_column_name(:auto_canceled_by_id)
1263main: -> 0.0000s
1264main: -- quote_column_name(:auto_canceled_by_id_convert_to_bigint)
1265main: -> 0.0000s
1266main: -- execute("ALTER TABLE \"p_ci_builds\"\n RENAME COLUMN \"auto_canceled_by_id\" TO \"auto_canceled_by_id_convert_to_bigint\"\n")
1267main: -> 0.0014s
1268main: -- clear_cache!(nil)
1269main: -> 0.0000s
1270main: -- quote_table_name(:p_ci_builds)
1271main: -> 0.0000s
1272main: -- quote_column_name(:temp_name_for_renaming)
1273main: -> 0.0000s
1274main: -- quote_column_name(:auto_canceled_by_id)
1275main: -> 0.0000s
1276main: -- execute("ALTER TABLE \"p_ci_builds\"\n RENAME COLUMN \"temp_name_for_renaming\" TO \"auto_canceled_by_id\"\n")
1277main: -> 0.0015s
1278main: -- quote_table_name(:trigger_10ee1357e825)
1279main: -> 0.0000s
1280main: -- execute("ALTER FUNCTION \"trigger_10ee1357e825\" RESET ALL")
1281main: -> 0.0008s
1282main: -- execute("LOCK TABLE ci_pipelines, p_ci_builds IN ACCESS EXCLUSIVE MODE")
1283main: -> 0.0018s
1284main: -- remove_foreign_key(:p_ci_builds, :ci_pipelines, {:name=>:fk_a2141b1522})
1285main: -> 0.0082s
1286main: -- quote_table_name("gitlab_partitions_dynamic._test_gitlab_ci_builds_partition")
1287main: -> 0.0000s
1288main: -- quote_column_name(:fk_dd3c83bdee)
1289main: -> 0.0000s
1290main: -- quote_column_name(:fk_a2141b1522)
1291main: -> 0.0000s
1292main: -- execute("ALTER TABLE \"gitlab_partitions_dynamic\".\"_test_gitlab_ci_builds_partition\"\nRENAME CONSTRAINT \"fk_dd3c83bdee\" TO \"fk_a2141b1522\"\n")
1293main: -> 0.0016s
1294main: -- quote_table_name("public.ci_builds")
1295main: -> 0.0000s
1296main: -- quote_column_name(:fk_dd3c83bdee)
1297main: -> 0.0000s
1298main: -- quote_column_name(:fk_a2141b1522)
1299main: -> 0.0000s
1300main: -- execute("ALTER TABLE \"public\".\"ci_builds\"\nRENAME CONSTRAINT \"fk_dd3c83bdee\" TO \"fk_a2141b1522\"\n")
1301main: -> 0.0010s
1302main: -- quote_table_name("gitlab_partitions_dynamic.ci_builds_101")
1303main: -> 0.0000s
1304main: -- quote_column_name(:fk_dd3c83bdee)
1305main: -> 0.0000s
1306main: -- quote_column_name(:fk_a2141b1522)
1307main: -> 0.0000s
1308main: -- execute("ALTER TABLE \"gitlab_partitions_dynamic\".\"ci_builds_101\"\nRENAME CONSTRAINT \"fk_dd3c83bdee\" TO \"fk_a2141b1522\"\n")
1309main: -> 0.0009s
1310main: -- quote_table_name("gitlab_partitions_dynamic.ci_builds_102")
1311main: -> 0.0000s
1312main: -- quote_column_name(:fk_dd3c83bdee)
1313main: -> 0.0000s
1314main: -- quote_column_name(:fk_a2141b1522)
1315main: -> 0.0000s
1316main: -- execute("ALTER TABLE \"gitlab_partitions_dynamic\".\"ci_builds_102\"\nRENAME CONSTRAINT \"fk_dd3c83bdee\" TO \"fk_a2141b1522\"\n")
1317main: -> 0.0016s
1318main: -- quote_table_name(:p_ci_builds)
1319main: -> 0.0000s
1320main: -- quote_column_name(:fk_dd3c83bdee)
1321main: -> 0.0000s
1322main: -- quote_column_name(:fk_a2141b1522)
1323main: -> 0.0000s
1324main: -- execute("ALTER TABLE \"p_ci_builds\"\nRENAME CONSTRAINT \"fk_dd3c83bdee\" TO \"fk_a2141b1522\"\n")
1325main: -> 0.0015s
1326main: -- indexes(:p_ci_builds)
1327main: -> 0.0412s
1328main: -- indexes(:p_ci_builds)
1329main: -> 0.0402s
1330main: -- indexes("gitlab_partitions_dynamic._test_gitlab_ci_builds_partition")
1331main: -> 0.0420s
1332main: -- indexes("gitlab_partitions_dynamic._test_gitlab_ci_builds_partition")
1333main: -> 0.0367s
1334main: -- quote_table_name("gitlab_partitions_dynamic.index_96cb5fea4b")
1335main: -> 0.0000s
1336main: -- quote_table_name("temp_5b83cadfbb")
1337main: -> 0.0000s
1338main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"index_96cb5fea4b\" RENAME TO \"temp_5b83cadfbb\"")
1339main: -> 0.0011s
1340main: -- quote_table_name("gitlab_partitions_dynamic._test_gitlab_ci_builds_partit_auto_canceled_by_id_convert_t_idx")
1341main: -> 0.0000s
1342main: -- quote_table_name("index_96cb5fea4b")
1343main: -> 0.0000s
1344main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"_test_gitlab_ci_builds_partit_auto_canceled_by_id_convert_t_idx\" RENAME TO \"index_96cb5fea4b\"")
1345main: -> 0.0009s
1346main: -- quote_table_name("gitlab_partitions_dynamic.temp_5b83cadfbb")
1347main: -> 0.0000s
1348main: -- quote_table_name("_test_gitlab_ci_builds_partit_auto_canceled_by_id_convert_t_idx")
1349main: -> 0.0000s
1350main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"temp_5b83cadfbb\" RENAME TO \"_test_gitlab_ci_builds_partit_auto_canceled_by_id_convert_t_idx\"")
1351main: -> 0.0008s
1352main: -- indexes("public.ci_builds")
1353main: -> 0.0369s
1354main: -- indexes("public.ci_builds")
1355main: -> 0.0408s
1356main: -- quote_table_name("public.index_ffe1233676")
1357main: -> 0.0000s
1358main: -- quote_table_name("temp_b1a20ba0f9")
1359main: -> 0.0000s
1360main: -- execute("ALTER INDEX \"public\".\"index_ffe1233676\" RENAME TO \"temp_b1a20ba0f9\"")
1361main: -> 0.0012s
1362main: -- quote_table_name("public.index_ci_builds_on_auto_canceled_by_id")
1363main: -> 0.0000s
1364main: -- quote_table_name("index_ffe1233676")
1365main: -> 0.0000s
1366main: -- execute("ALTER INDEX \"public\".\"index_ci_builds_on_auto_canceled_by_id\" RENAME TO \"index_ffe1233676\"")
1367main: -> 0.0010s
1368main: -- quote_table_name("public.temp_b1a20ba0f9")
1369main: -> 0.0000s
1370main: -- quote_table_name("index_ci_builds_on_auto_canceled_by_id")
1371main: -> 0.0000s
1372main: -- execute("ALTER INDEX \"public\".\"temp_b1a20ba0f9\" RENAME TO \"index_ci_builds_on_auto_canceled_by_id\"")
1373main: -> 0.0009s
1374main: -- indexes("gitlab_partitions_dynamic.ci_builds_101")
1375main: -> 0.0383s
1376main: -- indexes("gitlab_partitions_dynamic.ci_builds_101")
1377main: -> 0.0427s
1378main: -- quote_table_name("gitlab_partitions_dynamic.index_be05aa07e1")
1379main: -> 0.0000s
1380main: -- quote_table_name("temp_64259f0ae9")
1381main: -> 0.0000s
1382main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"index_be05aa07e1\" RENAME TO \"temp_64259f0ae9\"")
1383main: -> 0.0011s
1384main: -- quote_table_name("gitlab_partitions_dynamic.ci_builds_101_auto_canceled_by_id_idx")
1385main: -> 0.0000s
1386main: -- quote_table_name("index_be05aa07e1")
1387main: -> 0.0000s
1388main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"ci_builds_101_auto_canceled_by_id_idx\" RENAME TO \"index_be05aa07e1\"")
1389main: -> 0.0009s
1390main: -- quote_table_name("gitlab_partitions_dynamic.temp_64259f0ae9")
1391main: -> 0.0000s
1392main: -- quote_table_name("ci_builds_101_auto_canceled_by_id_idx")
1393main: -> 0.0000s
1394main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"temp_64259f0ae9\" RENAME TO \"ci_builds_101_auto_canceled_by_id_idx\"")
1395main: -> 0.0008s
1396main: -- indexes("gitlab_partitions_dynamic.ci_builds_102")
1397main: -> 0.0364s
1398main: -- indexes("gitlab_partitions_dynamic.ci_builds_102")
1399main: -> 0.0470s
1400main: -- quote_table_name("gitlab_partitions_dynamic.index_8d72ef5f95")
1401main: -> 0.0000s
1402main: -- quote_table_name("temp_a0f25a97bc")
1403main: -> 0.0000s
1404main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"index_8d72ef5f95\" RENAME TO \"temp_a0f25a97bc\"")
1405main: -> 0.0017s
1406main: -- quote_table_name("gitlab_partitions_dynamic.ci_builds_102_auto_canceled_by_id_idx")
1407main: -> 0.0000s
1408main: -- quote_table_name("index_8d72ef5f95")
1409main: -> 0.0000s
1410main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"ci_builds_102_auto_canceled_by_id_idx\" RENAME TO \"index_8d72ef5f95\"")
1411main: -> 0.0013s
1412main: -- quote_table_name("gitlab_partitions_dynamic.temp_a0f25a97bc")
1413main: -> 0.0000s
1414main: -- quote_table_name("ci_builds_102_auto_canceled_by_id_idx")
1415main: -> 0.0000s
1416main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"temp_a0f25a97bc\" RENAME TO \"ci_builds_102_auto_canceled_by_id_idx\"")
1417main: -> 0.0015s
1418main: -- quote_table_name("p_ci_builds_auto_canceled_by_id_bigint_idx")
1419main: -> 0.0000s
1420main: -- quote_table_name("temp_3f76d2212d")
1421main: -> 0.0000s
1422main: -- execute("ALTER INDEX \"p_ci_builds_auto_canceled_by_id_bigint_idx\" RENAME TO \"temp_3f76d2212d\"")
1423main: -> 0.0011s
1424main: -- quote_table_name("p_ci_builds_auto_canceled_by_id_idx")
1425main: -> 0.0000s
1426main: -- quote_table_name(:p_ci_builds_auto_canceled_by_id_bigint_idx)
1427main: -> 0.0000s
1428main: -- execute("ALTER INDEX \"p_ci_builds_auto_canceled_by_id_idx\" RENAME TO \"p_ci_builds_auto_canceled_by_id_bigint_idx\"")
1429main: -> 0.0010s
1430main: -- quote_table_name("temp_3f76d2212d")
1431main: -> 0.0000s
1432main: -- quote_table_name(:p_ci_builds_auto_canceled_by_id_idx)
1433main: -> 0.0000s
1434main: -- execute("ALTER INDEX \"temp_3f76d2212d\" RENAME TO \"p_ci_builds_auto_canceled_by_id_idx\"")
1435main: -> 0.0009s
1436main: -- remove_index(:p_ci_builds, {:name=>:p_ci_builds_auto_canceled_by_id_bigint_idx})
1437main: -> 0.0014s
1438main: == 20240219040351 SwapColumnsForAutoCanceledByIdBetweenCiBuildsAndCiPipelines: migrated (0.5716s)
1439main: == [advisory_lock_connection] object_id: 281119320, pg_backend_pid: 224
1440 correctly swaps conversion columns
1441# [RSpecRunTime] RSpec elapsed time: 22 minutes 6.87 seconds. Current RSS: ~1192M. Threads: 2. load average: 0.91 0.93 0.92 1/283 411
1442.
1443INFO: analyzing "public.p_ci_stages" inheritance tree
1444INFO: analyzing "public.ci_stages"
1445INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1446# [RSpecRunTime] Finishing example group spec/migrations/db/post_migrate/20240214040351_swap_columns_for_auto_canceled_by_id_between_ci_builds_and_ci_pipelines_spec.rb. It took 1 minute 8.39 seconds. Expected to take 45.78 seconds.
1447# [RSpecRunTime] RSpec elapsed time: 22 minutes 33.88 seconds. Current RSS: ~1158M. Threads: 2. load average: 1.02 0.96 0.93 2/283 412
1448.
1449# [RSpecRunTime] Starting example group spec/migrations/20240210104125_ensure_member_roles_names_uniq_spec.rb. Expected to take 40.92 seconds.
1450EnsureMemberRolesNamesUniq
1451 #up
1452main: -- execute("UPDATE member_roles SET name = CONCAT(name, ' (', id, ')')\nWHERE id IN (\n SELECT mr.id FROM member_roles mr\n WHERE EXISTS (SELECT mr_duplicates.id\n FROM member_roles mr_duplicates\n WHERE mr_duplicates.name = mr.name\n AND (\n mr_duplicates.namespace_id = mr.namespace_id\n OR (mr_duplicates.namespace_id IS NULL AND mr.namespace_id IS NULL)\n )\n AND mr_duplicates.id < mr.id))\n")
1453main: -> 0.0029s
1454main: -- execute("UPDATE member_roles SET name = CONCAT(name, ' (', id, ')')\nWHERE id IN (\n SELECT mr.id FROM member_roles mr\n WHERE EXISTS (SELECT mr_duplicates.id\n FROM member_roles mr_duplicates\n WHERE mr_duplicates.name = mr.name\n AND (\n mr_duplicates.namespace_id = mr.namespace_id\n OR (mr_duplicates.namespace_id IS NULL AND mr.namespace_id IS NULL)\n )\n AND mr_duplicates.id < mr.id))\n")
1455main: -> 0.0026s
1456 updates the duplicated names with higher id
1457# [RSpecRunTime] RSpec elapsed time: 23 minutes 11.38 seconds. Current RSS: ~1181M. Threads: 2. load average: 1.13 1.00 0.94 1/283 413
1458.
1459INFO: analyzing "public.p_ci_stages" inheritance tree
1460INFO: analyzing "public.ci_stages"
1461INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1462# [RSpecRunTime] Finishing example group spec/migrations/20240210104125_ensure_member_roles_names_uniq_spec.rb. It took 1 minute 6.43 seconds. Expected to take 40.92 seconds.
1463# [RSpecRunTime] RSpec elapsed time: 23 minutes 40.34 seconds. Current RSS: ~1147M. Threads: 2. load average: 1.07 1.00 0.94 1/284 414
1464.
1465# [RSpecRunTime] Starting example group spec/migrations/20240419140530_set_trusted_extern_uid_to_false_for_existing_bitbucket_identities_spec.rb. Expected to take 21.64 seconds.
1466SetTrustedExternUidToFalseForExistingBitbucketIdentities
1467 #up
1468main: == [advisory_lock_connection] object_id: 320930060, pg_backend_pid: 238
1469main: == 20240419140530 SetTrustedExternUidToFalseForExistingBitbucketIdentities: migrating
1470main: == 20240419140530 SetTrustedExternUidToFalseForExistingBitbucketIdentities: migrated (0.0312s)
1471main: == [advisory_lock_connection] object_id: 320930060, pg_backend_pid: 238
1472 sets trusted_extern_uid to false for existing bitbucket identities
1473# [RSpecRunTime] RSpec elapsed time: 24 minutes 2.65 seconds. Current RSS: ~1162M. Threads: 2. load average: 1.05 1.00 0.95 2/284 415
1474.
1475# [RSpecRunTime] Finishing example group spec/migrations/20240419140530_set_trusted_extern_uid_to_false_for_existing_bitbucket_identities_spec.rb. It took 36.86 seconds. Expected to take 21.64 seconds.
1476# [RSpecRunTime] RSpec elapsed time: 24 minutes 17.24 seconds. Current RSS: ~1156M. Threads: 2. load average: 1.19 1.03 0.96 1/284 416
1477.
1478# [RSpecRunTime] Starting example group spec/migrations/20240402030609_queue_backfill_finding_initial_pipeline_id_spec.rb. Expected to take 10.42 seconds.
1479QueueBackfillFindingInitialPipelineId
1480main: == [advisory_lock_connection] object_id: 326894420, pg_backend_pid: 244
1481main: == 20240514030609 QueueBackfillFindingInitialPipelineId: migrating ============
1482main: == 20240514030609 QueueBackfillFindingInitialPipelineId: migrated (0.0616s) ===
1483main: == [advisory_lock_connection] object_id: 326894420, pg_backend_pid: 244
1484 schedules a new batched migration
1485# [RSpecRunTime] Finishing example group spec/migrations/20240402030609_queue_backfill_finding_initial_pipeline_id_spec.rb. It took 14.58 seconds. Expected to take 10.42 seconds.
1486# [RSpecRunTime] RSpec elapsed time: 24 minutes 31.86 seconds. Current RSS: ~1123M. Threads: 2. load average: 1.08 1.01 0.95 1/284 417
1487.
1488auto_explain log contains 954 entries for main, writing to /builds/gitlab-org/gitlab/auto_explain/rspec-migration-pg14-single-db-15-15.342.main.ndjson.gz
1489took 24.077234204
1490[TEST PROF INFO] EventProf results for sql.active_record
1491Total time: 13:49.596 of 24:29.378 (56.46%)
1492Total events: 637410
1493Top 5 slowest suites (by time):
1494DeleteOrphans...eRequestRules2 (./spec/migrations/20230721095223_delete_orphans_approval_merge_request_rules2_spec.rb:6) – 01:55.050 (74719 / 1) of 02:43.739 (70.26%)
1495QueueSyncScanResultPolicies (./spec/migrations/20230831084632_queue_sync_scan_result_policies_spec.rb:6) – 01:35.823 (68061 / 1) of 02:34.272 (62.11%)
1496QueueBackfill...WithRecentSize (./spec/migrations/20230823090001_queue_backfill_project_statistics_storage_size_with_recent_size_spec.rb:6) – 01:35.710 (68644 / 1) of 02:33.440 (62.38%)
1497BackfillAlert...usIntegrations (./spec/migrations/backfill_alert_management_prometheus_integrations_spec.rb:6) – 01:33.081 (71246 / 2) of 02:47.361 (55.62%)
1498SwapEventsTar...ntForSelfHosts (./spec/migrations/20230817111938_swap_events_target_id_to_bigint_for_self_hosts_spec.rb:6) – 01:29.852 (73766 / 4) of 03:41.457 (40.57%)
1499Knapsack report was generated. Preview:
1500{
1501 "spec/migrations/20230817111938_swap_events_target_id_to_bigint_for_self_hosts_spec.rb": 163.81123386200034,
1502 "spec/migrations/swap_merge_request_user_mentions_note_id_to_bigint_for_self_managed_spec.rb": 153.97473969600014,
1503 "spec/migrations/backfill_alert_management_prometheus_integrations_spec.rb": 102.54688658900022,
1504 "spec/migrations/20230823090001_queue_backfill_project_statistics_storage_size_with_recent_size_spec.rb": 96.19100358600008,
1505 "spec/migrations/20230721095223_delete_orphans_approval_merge_request_rules2_spec.rb": 87.25420727999972,
1506 "spec/migrations/20230831084632_queue_sync_scan_result_policies_spec.rb": 90.60414751999997,
1507 "spec/migrations/20231130140901_queue_backfill_vs_code_settings_uuid_spec.rb": 67.85039533000008,
1508 "spec/migrations/20240123102735_update_negative_star_counts_in_projects_spec.rb": 58.698624912000014,
1509 "spec/migrations/db/post_migrate/20240214040351_swap_columns_for_auto_canceled_by_id_between_ci_builds_and_ci_pipelines_spec.rb": 41.54240503899928,
1510 "spec/migrations/20240210104125_ensure_member_roles_names_uniq_spec.rb": 37.60054012799992,
1511 "spec/migrations/20240419140530_set_trusted_extern_uid_to_false_for_existing_bitbucket_identities_spec.rb": 22.42410654499963,
1512 "spec/migrations/20240402030609_queue_backfill_finding_initial_pipeline_id_spec.rb": 9.532942253000328
1513}
1514Knapsack global time execution for tests: 15m 32s
1515Finished in 24 minutes 56 seconds (files took 45.73 seconds to load)
151620 examples, 0 failures
1517Randomized with seed 62819
1518[TEST PROF INFO] Time spent in factories: 00:00.181 (0.01% of total time)
1519RSpec exited with 0.
1520No examples to retry, congrats!
1521 Running after_script 00:05
1522Running after script...
1523$ source scripts/utils.sh
1524$ bundle exec gem list gitlab_quality-test_tooling
1525gitlab_quality-test_tooling (1.26.0)
1526$ section_start "failed-test-issues" "Report test failures" # collapsed multi-line command
1527 Report test failures 00:00
1529$ section_start "flaky-test-issues" "Report test flakiness" # collapsed multi-line command
1530 Report test flakiness 00:00
1532$ section_start "slow-test-issues" "Report test slowness" # collapsed multi-line command
1533 Report test slowness 00:00
1535$ section_start "slow-test-merge-request-report-note" "Report test slowness in MR note" # collapsed multi-line command
1536 Report test slowness in MR note 00:01
1539$ section_start "knapsack-report-issues" "Report test files close to timing out" # collapsed multi-line command
1540 Report test files close to timing out 00:02
1543$ tooling/bin/push_job_metrics || true
1544[job-metrics] Pushing job metrics file for the CI/CD job.
1545[job-metrics] Pushed 4 CI job metric entries to InfluxDB.
1546 Saving cache for successful job 00:00
1547Not uploading cache ruby-gems-debian-bookworm-ruby-3.2-17 due to policy
1548 Uploading artifacts for successful job 00:04
1549Uploading artifacts...
1550auto_explain/: found 2 matching artifact files and directories
1551coverage/: found 5 matching artifact files and directories
1552crystalball/: found 2 matching artifact files and directories
1553WARNING: deprecations/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab)
1554knapsack/: found 4 matching artifact files and directories
1555rspec/: found 16 matching artifact files and directories
1556WARNING: tmp/capybara/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab)
1557log/*.log: found 13 matching artifact files and directories
1558WARNING: Upload request redirected location=https://gitlab.com/api/v4/jobs/6975007419/artifacts?artifact_format=zip&artifact_type=archive&expire_in=31d new-url=https://gitlab.com
1559WARNING: Retrying... context=artifacts-uploader error=request redirected
1560Uploading artifacts as "archive" to coordinator... 201 Created id=6975007419 responseStatus=201 Created token=glcbt-65
1561Uploading artifacts...
1562rspec/rspec-*.xml: found 1 matching artifact files and directories
1563WARNING: Upload request redirected location=https://gitlab.com/api/v4/jobs/6975007419/artifacts?artifact_format=gzip&artifact_type=junit&expire_in=31d new-url=https://gitlab.com
1564WARNING: Retrying... context=artifacts-uploader error=request redirected
1565Uploading artifacts as "junit" to coordinator... 201 Created id=6975007419 responseStatus=201 Created token=glcbt-65
1566 Cleaning up project directory and file based variables 00:01
1567Job succeeded