Skip to content
Snippets Groups Projects

rspec migration pg14 single-db 7/15

Passed Started by
Krasimir Angelov
@krasio
1Running with gitlab-runner 17.0.0~pre.88.g761ae5dd (761ae5dd)
2 on green-5.private.runners-manager.gitlab.com/gitlab.com/gitlab-org Zi_8oswQ, system ID: s_8a4f217c24b6
3 feature flags: FF_NETWORK_PER_BUILD:true
4Resolving secrets
5 Preparing the "docker+machine" executor 01:01
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:00
25Running on runner-zi8oswq-project-278964-concurrent-0 via runner-zi8oswq-private-1717022051-d535d8fb...
26 Getting source from Git repository 00:01
27Skipping Git repository setup
28Skipping Git checkout
29Skipping Git submodules setup
30 Restoring cache 00:19
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:42
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:16
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:43
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$ section_start "gitaly-test-spawn" "Spawning Gitaly"; scripts/gitaly-test-spawn; section_end "gitaly-test-spawn"
788==> 'gem install knapsack --no-document' succeeded in 1 seconds.
789 Spawning Gitaly 00:04
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 34:41
799[23:32:16] 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_7_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_7_15_278964_report.json
808NEW_FLAKY_RSPEC_REPORT_PATH: rspec/flaky/new_rspec_migration_pg14_single-db_7_15_278964_report.json
809RSPEC_SKIPPED_TESTS_REPORT_PATH: rspec/skipped_tests-6975007409.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 2.293953828 seconds
838# [RSpecRunTime] Starting example group spec/migrations/swap_commit_user_mentions_note_id_to_bigint_for_self_managed_spec.rb. Expected to take 3 minutes 39.26 seconds.
839SwapCommitUserMentionsNoteIdToBigintForSelfManaged
840 #up
841 when GitLab.com, dev, or test
842 behaves like column `note_id_convert_to_bigint` is already dropped
843 does not swaps the columns
844 when self-managed instance with the `note_id_convert_to_bigint` column already dropped
845 behaves like column `note_id_convert_to_bigint` is already dropped
846 does not swaps the columns
847# [RSpecRunTime] RSpec elapsed time: 2 minutes 31.87 seconds. Current RSS: ~1176M. Threads: 2. load average: 1.14 1.38 1.37 2/293 390
848.
849 when self-managed instance columns already swapped
850 does not swaps the columns
851# [RSpecRunTime] RSpec elapsed time: 2 minutes 51.39 seconds. Current RSS: ~1136M. Threads: 2. load average: 1.10 1.36 1.36 1/292 391
852.
853 when self-managed instance
854 swaps the columns
855# [RSpecRunTime] RSpec elapsed time: 3 minutes 30.73 seconds. Current RSS: ~1170M. Threads: 2. load average: 1.12 1.33 1.35 1/292 392
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/swap_commit_user_mentions_note_id_to_bigint_for_self_managed_spec.rb. It took 4 minutes 44.44 seconds. Expected to take 3 minutes 39.26 seconds.
898# [RSpecRunTime] RSpec elapsed time: 4 minutes 49.03 seconds. Current RSS: ~1149M. Threads: 2. load average: 1.11 1.27 1.33 1/292 393
899.
900# [RSpecRunTime] Starting example group spec/migrations/20230802212443_add_current_user_todos_widget_to_epic_work_item_type_spec.rb. Expected to take 2 minutes 45.85 seconds.
901AddCurrentUserTodosWidgetToEpicWorkItemType
902 behaves like migration that adds a widget to a work item type
903 #up
904main: == [advisory_lock_connection] object_id: 54071960, pg_backend_pid: 142
905main: == 20230802212443 AddCurrentUserTodosWidgetToEpicWorkItemType: migrating ======
906main: == 20230802212443 AddCurrentUserTodosWidgetToEpicWorkItemType: migrated (0.0349s)
907main: == [advisory_lock_connection] object_id: 54071960, pg_backend_pid: 142
908 adds widget to work item type
909 when type does not exist
910main: == [advisory_lock_connection] object_id: 54568420, pg_backend_pid: 145
911main: == 20230802212443 AddCurrentUserTodosWidgetToEpicWorkItemType: migrating ======
912main: -- Epic work item type does not exist, skipping widget creation
913main: == 20230802212443 AddCurrentUserTodosWidgetToEpicWorkItemType: migrated (0.0204s)
914main: == [advisory_lock_connection] object_id: 54568420, pg_backend_pid: 145
915 skips creating the new widget definition
916# [RSpecRunTime] RSpec elapsed time: 6 minutes 51.31 seconds. Current RSS: ~1150M. Threads: 2. load average: 1.06 1.19 1.29 1/293 395
917.
918 #down
919main: == [advisory_lock_connection] object_id: 55056300, pg_backend_pid: 148
920main: == 20230802212443 AddCurrentUserTodosWidgetToEpicWorkItemType: migrating ======
921main: == 20230802212443 AddCurrentUserTodosWidgetToEpicWorkItemType: migrated (0.0311s)
922main: == [advisory_lock_connection] object_id: 55056300, pg_backend_pid: 148
923 removes widget from work item type
924# [RSpecRunTime] RSpec elapsed time: 7 minutes 37.25 seconds. Current RSS: ~1187M. Threads: 2. load average: 1.03 1.16 1.27 1/292 396
925.
926INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
927INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
928INFO: "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
929INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_101"
930INFO: "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
931INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_102"
932INFO: "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
933INFO: analyzing "public.p_ci_job_annotations" inheritance tree
934INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
935INFO: "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
936INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_101"
937INFO: "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
938INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_102"
939INFO: "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
940INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
941INFO: analyzing "public.ci_builds_metadata"
942INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
943INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_101"
944INFO: "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
945INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_102"
946INFO: "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
947INFO: analyzing "public.p_ci_builds" inheritance tree
948INFO: analyzing "public.ci_builds"
949INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
950INFO: analyzing "gitlab_partitions_dynamic.ci_builds_101"
951INFO: "ci_builds_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
952INFO: analyzing "gitlab_partitions_dynamic.ci_builds_102"
953INFO: "ci_builds_102": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
954INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
955INFO: analyzing "public.ci_pipeline_variables"
956INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
957INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
958INFO: analyzing "public.ci_pipeline_variables"
959INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
960INFO: analyzing "public.p_ci_job_artifacts" inheritance tree
961INFO: analyzing "public.ci_job_artifacts"
962INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
963INFO: analyzing "public.p_ci_stages" inheritance tree
964INFO: analyzing "public.ci_stages"
965INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
966# [RSpecRunTime] Finishing example group spec/migrations/20230802212443_add_current_user_todos_widget_to_epic_work_item_type_spec.rb. It took 4 minutes 18.83 seconds. Expected to take 2 minutes 45.85 seconds.
967# [RSpecRunTime] RSpec elapsed time: 9 minutes 7.91 seconds. Current RSS: ~1137M. Threads: 2. load average: 1.00 1.11 1.25 1/292 397
968.
969# [RSpecRunTime] Starting example group spec/migrations/20240108072318_fix_invalid_records_ci_build_trace_metadata_spec.rb. Expected to take 2 minutes 15.84 seconds.
970FixInvalidRecordsCiBuildTraceMetadata
971 when FKs exist
972main: == [advisory_lock_connection] object_id: 86295780, pg_backend_pid: 160
973main: == 20240108072318 FixInvalidRecordsCiBuildTraceMetadata: migrating ============
974main: == 20240108072318 FixInvalidRecordsCiBuildTraceMetadata: migrated (0.0300s) ===
975main: == [advisory_lock_connection] object_id: 86295780, pg_backend_pid: 160
976 does not remove records
977# [RSpecRunTime] RSpec elapsed time: 10 minutes 18.32 seconds. Current RSS: ~1162M. Threads: 2. load average: 1.14 1.13 1.24 1/292 398
978.
979 with missing FKs
980main: == [advisory_lock_connection] object_id: 86861800, pg_backend_pid: 162
981main: == 20240108072318 FixInvalidRecordsCiBuildTraceMetadata: migrating ============
982main: == 20240108072318 FixInvalidRecordsCiBuildTraceMetadata: migrated (0.0550s) ===
983main: == [advisory_lock_connection] object_id: 86861800, pg_backend_pid: 162
984 removes orphan records
985 with invalid FKs
986main: == [advisory_lock_connection] object_id: 87285240, pg_backend_pid: 165
987main: == 20240108072318 FixInvalidRecordsCiBuildTraceMetadata: migrating ============
988main: == 20240108072318 FixInvalidRecordsCiBuildTraceMetadata: migrated (0.0642s) ===
989main: == [advisory_lock_connection] object_id: 87285240, pg_backend_pid: 165
990 removes orphan records
991# [RSpecRunTime] RSpec elapsed time: 10 minutes 45.89 seconds. Current RSS: ~1146M. Threads: 2. load average: 1.02 1.10 1.23 1/292 399
992.
993INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
994INFO: analyzing "public.ci_pipeline_variables"
995INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
996INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
997INFO: analyzing "public.ci_pipeline_variables"
998INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
999INFO: analyzing "public.p_ci_job_artifacts" inheritance tree
1000INFO: "ci_job_artifacts": scanned 1 of 1 pages, containing 0 live rows and 3 dead rows; 0 rows in sample, 0 estimated total rows
1001INFO: analyzing "public.ci_job_artifacts"
1002INFO: "ci_job_artifacts": scanned 1 of 1 pages, containing 0 live rows and 3 dead rows; 0 rows in sample, 0 estimated total rows
1003INFO: analyzing "public.p_ci_stages" inheritance tree
1004INFO: analyzing "public.ci_stages"
1005INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1006# [RSpecRunTime] Finishing example group spec/migrations/20240108072318_fix_invalid_records_ci_build_trace_metadata_spec.rb. It took 2 minutes 33.89 seconds. Expected to take 2 minutes 15.84 seconds.
1007# [RSpecRunTime] RSpec elapsed time: 11 minutes 41.87 seconds. Current RSS: ~1139M. Threads: 2. load average: 1.01 1.08 1.21 1/292 400
1008.
1009# [RSpecRunTime] Starting example group spec/migrations/20230728174927_add_epic_work_item_type_spec.rb. Expected to take 1 minute 50.62 seconds.
1010AddEpicWorkItemType
1011main: == [advisory_lock_connection] object_id: 117929840, pg_backend_pid: 176
1012main: == 20230728174927 AddEpicWorkItemType: migrating ==============================
1013main: -- Epic work item type record exists, skipping creation
1014main: == 20230728174927 AddEpicWorkItemType: migrated (0.0220s) =====================
1015main: == [advisory_lock_connection] object_id: 117929840, pg_backend_pid: 176
1016 skips creating the new type an it's definitions
1017main: == [advisory_lock_connection] object_id: 118435060, pg_backend_pid: 179
1018main: == 20230728174927 AddEpicWorkItemType: migrating ==============================
1019main: == 20230728174927 AddEpicWorkItemType: migrated (0.1240s) =====================
1020main: == [advisory_lock_connection] object_id: 118435060, pg_backend_pid: 179
1021 adds the epic type, widget definitions and hierarchy restrictions
1022INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
1023INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
1024INFO: "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
1025INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_101"
1026INFO: "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
1027INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_102"
1028INFO: "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
1029INFO: analyzing "public.p_ci_job_annotations" inheritance tree
1030INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
1031INFO: "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
1032INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_101"
1033INFO: "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
1034INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_102"
1035INFO: "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
1036INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
1037INFO: analyzing "public.ci_builds_metadata"
1038INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1039INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_101"
1040INFO: "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
1041INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_102"
1042INFO: "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
1043INFO: analyzing "public.p_ci_builds" inheritance tree
1044INFO: analyzing "public.ci_builds"
1045INFO: "ci_builds": 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_builds_101"
1047INFO: "ci_builds_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1048INFO: analyzing "gitlab_partitions_dynamic.ci_builds_102"
1049INFO: "ci_builds_102": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1050INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1051INFO: analyzing "public.ci_pipeline_variables"
1052INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1053INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1054INFO: analyzing "public.ci_pipeline_variables"
1055INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1056INFO: analyzing "public.p_ci_job_artifacts" inheritance tree
1057INFO: "ci_job_artifacts": scanned 1 of 1 pages, containing 0 live rows and 3 dead rows; 0 rows in sample, 0 estimated total rows
1058INFO: analyzing "public.ci_job_artifacts"
1059INFO: "ci_job_artifacts": scanned 1 of 1 pages, containing 0 live rows and 3 dead rows; 0 rows in sample, 0 estimated total rows
1060INFO: analyzing "public.p_ci_stages" inheritance tree
1061INFO: analyzing "public.ci_stages"
1062INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1063# [RSpecRunTime] Finishing example group spec/migrations/20230728174927_add_epic_work_item_type_spec.rb. It took 3 minutes 50.83 seconds. Expected to take 1 minute 50.62 seconds.
1064# [RSpecRunTime] RSpec elapsed time: 15 minutes 32.76 seconds. Current RSS: ~1146M. Threads: 2. load average: 0.94 0.99 1.14 1/292 401
1065.
1066# [RSpecRunTime] Starting example group spec/migrations/20230907155247_queue_backfill_has_merge_request_of_vulnerability_reads_spec.rb. Expected to take 1 minute 44.22 seconds.
1067QueueBackfillHasMergeRequestOfVulnerabilityReads
1068main: == [advisory_lock_connection] object_id: 153328620, pg_backend_pid: 190
1069main: == 20230907155247 QueueBackfillHasMergeRequestOfVulnerabilityReads: migrating =
1070main: == 20230907155247 QueueBackfillHasMergeRequestOfVulnerabilityReads: migrated (0.0828s)
1071main: == [advisory_lock_connection] object_id: 153328620, pg_backend_pid: 190
1072 schedules a new batched migration
1073INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
1074INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
1075INFO: "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
1076INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_101"
1077INFO: "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
1078INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_102"
1079INFO: "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
1080INFO: analyzing "public.p_ci_job_annotations" inheritance tree
1081INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
1082INFO: "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
1083INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_101"
1084INFO: "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
1085INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_102"
1086INFO: "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
1087INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
1088INFO: analyzing "public.ci_builds_metadata"
1089INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1090INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_101"
1091INFO: "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
1092INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_102"
1093INFO: "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
1094INFO: analyzing "public.p_ci_builds" inheritance tree
1095INFO: analyzing "public.ci_builds"
1096INFO: "ci_builds": 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_builds_101"
1098INFO: "ci_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_builds_102"
1100INFO: "ci_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_pipeline_variables" inheritance tree
1102INFO: analyzing "public.ci_pipeline_variables"
1103INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1104INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1105INFO: analyzing "public.ci_pipeline_variables"
1106INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1107INFO: analyzing "public.p_ci_job_artifacts" inheritance tree
1108INFO: "ci_job_artifacts": scanned 1 of 1 pages, containing 0 live rows and 3 dead rows; 0 rows in sample, 0 estimated total rows
1109INFO: analyzing "public.ci_job_artifacts"
1110INFO: "ci_job_artifacts": scanned 1 of 1 pages, containing 0 live rows and 3 dead rows; 0 rows in sample, 0 estimated total rows
1111INFO: analyzing "public.p_ci_stages" inheritance tree
1112INFO: analyzing "public.ci_stages"
1113INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1114# [RSpecRunTime] Finishing example group spec/migrations/20230907155247_queue_backfill_has_merge_request_of_vulnerability_reads_spec.rb. It took 3 minutes 18.76 seconds. Expected to take 1 minute 44.22 seconds.
1115# [RSpecRunTime] RSpec elapsed time: 18 minutes 51.58 seconds. Current RSS: ~1136M. Threads: 2. load average: 0.88 0.97 1.09 1/292 402
1116.
1117# [RSpecRunTime] Starting example group spec/migrations/20231103223224_backfill_zoekt_node_id_on_indexed_namespaces_spec.rb. Expected to take 1 minute 31.15 seconds.
1118BackfillZoektNodeIdOnIndexedNamespaces
1119 #up
1120main: == [advisory_lock_connection] object_id: 186023180, pg_backend_pid: 202
1121main: == 20231103223224 BackfillZoektNodeIdOnIndexedNamespaces: migrating ===========
1122main: -- execute(" UPDATE zoekt_indexed_namespaces\n SET zoekt_node_id = (SELECT id FROM zoekt_nodes ORDER BY created_at DESC LIMIT 1)\n")
1123main: -> 0.0022s
1124main: == 20231103223224 BackfillZoektNodeIdOnIndexedNamespaces: migrated (0.0114s) ==
1125main: == [advisory_lock_connection] object_id: 186023180, pg_backend_pid: 202
1126 backfills zoekt_node_id with zoekt_shard_id
1127 when there is somehow more than one zoekt node
1128main: == [advisory_lock_connection] object_id: 186709140, pg_backend_pid: 205
1129main: == 20231103223224 BackfillZoektNodeIdOnIndexedNamespaces: migrating ===========
1130main: -- execute(" UPDATE zoekt_indexed_namespaces\n SET zoekt_node_id = (SELECT id FROM zoekt_nodes ORDER BY created_at DESC LIMIT 1)\n")
1131main: -> 0.0016s
1132main: == 20231103223224 BackfillZoektNodeIdOnIndexedNamespaces: migrated (0.0094s) ==
1133main: == [advisory_lock_connection] object_id: 186709140, pg_backend_pid: 205
1134 uses the latest zoekt node
1135# [RSpecRunTime] RSpec elapsed time: 20 minutes 37.86 seconds. Current RSS: ~1157M. Threads: 2. load average: 0.96 0.97 1.07 1/290 403
1136.
1137INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1138INFO: analyzing "public.ci_pipeline_variables"
1139INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1140INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1141INFO: analyzing "public.ci_pipeline_variables"
1142INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1143INFO: analyzing "public.p_ci_job_artifacts" inheritance tree
1144INFO: "ci_job_artifacts": scanned 1 of 1 pages, containing 0 live rows and 3 dead rows; 0 rows in sample, 0 estimated total rows
1145INFO: analyzing "public.ci_job_artifacts"
1146INFO: "ci_job_artifacts": scanned 1 of 1 pages, containing 0 live rows and 3 dead rows; 0 rows in sample, 0 estimated total rows
1147INFO: analyzing "public.p_ci_stages" inheritance tree
1148INFO: analyzing "public.ci_stages"
1149INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1150# [RSpecRunTime] Finishing example group spec/migrations/20231103223224_backfill_zoekt_node_id_on_indexed_namespaces_spec.rb. It took 2 minutes 54.84 seconds. Expected to take 1 minute 31.15 seconds.
1151# [RSpecRunTime] RSpec elapsed time: 21 minutes 46.46 seconds. Current RSS: ~1142M. Threads: 2. load average: 0.89 0.95 1.06 1/291 404
1152.
1153# [RSpecRunTime] Starting example group spec/migrations/20230815160428_rename_plans_titles_with_legacy_plan_names_spec.rb. Expected to take 1 minute 20.58 seconds.
1154RenamePlansTitlesWithLegacyPlanNames
1155 #up
1156main: == [advisory_lock_connection] object_id: 219449280, pg_backend_pid: 215
1157main: == 20230815160428 RenamePlansTitlesWithLegacyPlanNames: migrating =============
1158main: -- execute("UPDATE plans SET title = 'Premium' WHERE name = 'premium'")
1159main: -> 0.0021s
1160main: -- execute("UPDATE plans SET title = 'Ultimate' WHERE name = 'ultimate'")
1161main: -> 0.0032s
1162main: == 20230815160428 RenamePlansTitlesWithLegacyPlanNames: migrated (0.0194s) ====
1163main: == [advisory_lock_connection] object_id: 219449280, pg_backend_pid: 215
1164 updates the plan titles
1165# [RSpecRunTime] RSpec elapsed time: 23 minutes 29.26 seconds. Current RSS: ~1189M. Threads: 2. load average: 1.04 0.99 1.06 1/291 405
1166.
1167INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
1168INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
1169INFO: "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
1170INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_101"
1171INFO: "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
1172INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_102"
1173INFO: "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
1174INFO: analyzing "public.p_ci_job_annotations" inheritance tree
1175INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
1176INFO: "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
1177INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_101"
1178INFO: "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
1179INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_102"
1180INFO: "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
1181INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
1182INFO: analyzing "public.ci_builds_metadata"
1183INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1184INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_101"
1185INFO: "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
1186INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_102"
1187INFO: "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
1188INFO: analyzing "public.p_ci_builds" inheritance tree
1189INFO: analyzing "public.ci_builds"
1190INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1191INFO: analyzing "gitlab_partitions_dynamic.ci_builds_101"
1192INFO: "ci_builds_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1193INFO: analyzing "gitlab_partitions_dynamic.ci_builds_102"
1194INFO: "ci_builds_102": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1195INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1196INFO: analyzing "public.ci_pipeline_variables"
1197INFO: "ci_pipeline_variables": 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_pipeline_variables" inheritance tree
1199INFO: analyzing "public.ci_pipeline_variables"
1200INFO: "ci_pipeline_variables": 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_job_artifacts" inheritance tree
1202INFO: "ci_job_artifacts": scanned 1 of 1 pages, containing 0 live rows and 3 dead rows; 0 rows in sample, 0 estimated total rows
1203INFO: analyzing "public.ci_job_artifacts"
1204INFO: "ci_job_artifacts": scanned 1 of 1 pages, containing 0 live rows and 3 dead rows; 0 rows in sample, 0 estimated total rows
1205INFO: analyzing "public.p_ci_stages" inheritance tree
1206INFO: analyzing "public.ci_stages"
1207INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1208# [RSpecRunTime] Finishing example group spec/migrations/20230815160428_rename_plans_titles_with_legacy_plan_names_spec.rb. It took 3 minutes 14.78 seconds. Expected to take 1 minute 20.58 seconds.
1209# [RSpecRunTime] RSpec elapsed time: 25 minutes 1.3 seconds. Current RSS: ~1139M. Threads: 2. load average: 1.05 1.00 1.05 2/291 406
1210.
1211# [RSpecRunTime] Starting example group spec/migrations/20231221223259_queue_drop_vulnerabilities_without_finding_id_spec.rb. Expected to take 1 minute 1.77 seconds.
1212QueueDropVulnerabilitiesWithoutFindingId
1213main: == [advisory_lock_connection] object_id: 250718820, pg_backend_pid: 226
1214main: == 20231221223259 QueueDropVulnerabilitiesWithoutFindingId: migrating =========
1215main: == 20231221223259 QueueDropVulnerabilitiesWithoutFindingId: migrated (0.0790s)
1216main: == [advisory_lock_connection] object_id: 250718820, pg_backend_pid: 226
1217 schedules a new batched migration
1218INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1219INFO: analyzing "public.ci_pipeline_variables"
1220INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1221INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
1222INFO: analyzing "public.ci_pipeline_variables"
1223INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1224INFO: analyzing "public.p_ci_job_artifacts" inheritance tree
1225INFO: "ci_job_artifacts": scanned 1 of 1 pages, containing 0 live rows and 3 dead rows; 0 rows in sample, 0 estimated total rows
1226INFO: analyzing "public.ci_job_artifacts"
1227INFO: "ci_job_artifacts": scanned 1 of 1 pages, containing 0 live rows and 3 dead rows; 0 rows in sample, 0 estimated total rows
1228INFO: analyzing "public.p_ci_stages" inheritance tree
1229INFO: analyzing "public.ci_stages"
1230INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1231# [RSpecRunTime] Finishing example group spec/migrations/20231221223259_queue_drop_vulnerabilities_without_finding_id_spec.rb. It took 2 minutes 29.13 seconds. Expected to take 1 minute 1.77 seconds.
1232# [RSpecRunTime] RSpec elapsed time: 27 minutes 30.5 seconds. Current RSS: ~1144M. Threads: 2. load average: 1.05 1.02 1.04 1/291 407
1233.
1234# [RSpecRunTime] Starting example group spec/migrations/20240209153920_queue_purge_security_scans_with_empty_finding_data_spec.rb. Expected to take 45.84 seconds.
1235QueuePurgeSecurityScansWithEmptyFindingData
1236main: == [advisory_lock_connection] object_id: 275298080, pg_backend_pid: 236
1237main: == 20240209153920 QueuePurgeSecurityScansWithEmptyFindingData: migrating ======
1238main: == 20240209153920 QueuePurgeSecurityScansWithEmptyFindingData: migrated (0.0386s)
1239main: == [advisory_lock_connection] object_id: 275298080, pg_backend_pid: 236
1240 does not schedule a new batched migration for CE
1241INFO: analyzing "public.p_ci_stages" inheritance tree
1242INFO: analyzing "public.ci_stages"
1243INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1244# [RSpecRunTime] Finishing example group spec/migrations/20240209153920_queue_purge_security_scans_with_empty_finding_data_spec.rb. It took 1 minute 53.07 seconds. Expected to take 45.84 seconds.
1245# [RSpecRunTime] RSpec elapsed time: 29 minutes 23.64 seconds. Current RSS: ~1148M. Threads: 2. load average: 0.94 0.98 1.02 1/291 408
1246.
1247# [RSpecRunTime] Starting example group spec/migrations/db/post_migrate/20240416005004_swap_columns_for_p_ci_builds_runner_id_spec.rb. Expected to take 41.92 seconds.
1248SwapColumnsForPCiBuildsRunnerId
1249 when index is different
1250 behaves like swap conversion columns
1251main: -- execute("DROP INDEX IF EXISTS p_ci_builds_runner_id_id_convert_to_bigint_idx;\nDROP INDEX IF EXISTS p_ci_builds_runner_id_id_idx;\n")
1252main: -> 0.0032s
1253main: -- transaction_open?(nil)
1254main: -> 0.0001s
1255main: -- index_name_exists?(:p_ci_builds, :p_ci_builds_runner_id_id_convert_to_bigint_idx)
1256main: -> 0.0051s
1257main: -- transaction_open?(nil)
1258main: -> 0.0001s
1259main: -- index_exists?("gitlab_partitions_dynamic._test_gitlab_ci_builds_partition", [:runner_id, :id], {:name=>"index_2b0efc2862", :algorithm=>:concurrently})
1260main: -> 0.0490s
1261main: -- add_index("gitlab_partitions_dynamic._test_gitlab_ci_builds_partition", [:runner_id, :id], {:name=>"index_2b0efc2862", :algorithm=>:concurrently})
1262main: -> 0.0026s
1263main: -- transaction_open?(nil)
1264main: -> 0.0001s
1265main: -- index_exists?("public.ci_builds", [:runner_id, :id], {:name=>"index_ce33cf4d90", :algorithm=>:concurrently})
1266main: -> 0.0361s
1267main: -- add_index("public.ci_builds", [:runner_id, :id], {:name=>"index_ce33cf4d90", :algorithm=>:concurrently})
1268main: -> 0.0025s
1269main: -- transaction_open?(nil)
1270main: -> 0.0001s
1271main: -- index_exists?("gitlab_partitions_dynamic.ci_builds_101", [:runner_id, :id], {:name=>"index_2649d05a35", :algorithm=>:concurrently})
1272main: -> 0.0581s
1273main: -- add_index("gitlab_partitions_dynamic.ci_builds_101", [:runner_id, :id], {:name=>"index_2649d05a35", :algorithm=>:concurrently})
1274main: -> 0.0035s
1275main: -- transaction_open?(nil)
1276main: -> 0.0001s
1277main: -- index_exists?("gitlab_partitions_dynamic.ci_builds_102", [:runner_id, :id], {:name=>"index_9cc0ba7348", :algorithm=>:concurrently})
1278main: -> 0.0430s
1279main: -- add_index("gitlab_partitions_dynamic.ci_builds_102", [:runner_id, :id], {:name=>"index_9cc0ba7348", :algorithm=>:concurrently})
1280main: -> 0.0032s
1281main: -- transaction_open?(nil)
1282main: -> 0.0001s
1283main: -- add_index(:p_ci_builds, [:runner_id, :id], {:name=>:p_ci_builds_runner_id_id_convert_to_bigint_idx})
1284main: -> 0.0034s
1285main: == [advisory_lock_connection] object_id: 292716640, pg_backend_pid: 245
1286main: == 20240416005004 SwapColumnsForPCiBuildsRunnerId: migrating ==================
1287main: -- index_name_exists?(:p_ci_builds, :p_ci_builds_runner_id_id_idx)
1288main: -> 0.0033s
1289main: -- indexes("p_ci_builds")
1290main: -> 0.0454s
1291main: -- indexes("gitlab_partitions_dynamic._test_gitlab_ci_builds_partition")
1292main: -> 0.0349s
1293main: -- quote_table_name("gitlab_partitions_dynamic.index_2b0efc2862")
1294main: -> 0.0001s
1295main: -- quote_table_name("index_7ee2feb2c9")
1296main: -> 0.0000s
1297main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"index_2b0efc2862\" RENAME TO \"index_7ee2feb2c9\"")
1298main: -> 0.0011s
1299main: -- indexes("public.ci_builds")
1300main: -> 0.0390s
1301main: -- quote_table_name("public.index_ce33cf4d90")
1302main: -> 0.0001s
1303main: -- quote_table_name("index_c2e24a89ff")
1304main: -> 0.0000s
1305main: -- execute("ALTER INDEX \"public\".\"index_ce33cf4d90\" RENAME TO \"index_c2e24a89ff\"")
1306main: -> 0.0011s
1307main: -- indexes("gitlab_partitions_dynamic.ci_builds_101")
1308main: -> 0.0371s
1309main: -- quote_table_name("gitlab_partitions_dynamic.index_2649d05a35")
1310main: -> 0.0001s
1311main: -- quote_table_name("index_3c2855dadb")
1312main: -> 0.0000s
1313main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"index_2649d05a35\" RENAME TO \"index_3c2855dadb\"")
1314main: -> 0.0011s
1315main: -- indexes("gitlab_partitions_dynamic.ci_builds_102")
1316main: -> 0.0390s
1317main: -- quote_table_name("gitlab_partitions_dynamic.index_9cc0ba7348")
1318main: -> 0.0001s
1319main: -- quote_table_name("index_98bb37e896")
1320main: -> 0.0000s
1321main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"index_9cc0ba7348\" RENAME TO \"index_98bb37e896\"")
1322main: -> 0.0011s
1323main: -- quote_table_name("p_ci_builds_runner_id_id_convert_to_bigint_idx")
1324main: -> 0.0000s
1325main: -- quote_table_name(:p_ci_builds_runner_id_id_idx)
1326main: -> 0.0000s
1327main: -- execute("ALTER INDEX \"p_ci_builds_runner_id_id_convert_to_bigint_idx\" RENAME TO \"p_ci_builds_runner_id_id_idx\"")
1328main: -> 0.0011s
1329main: -- execute("LOCK TABLE p_ci_builds IN ACCESS EXCLUSIVE MODE")
1330main: -> 0.0009s
1331main: -- clear_cache!(nil)
1332main: -> 0.0001s
1333main: -- quote_table_name(:p_ci_builds)
1334main: -> 0.0000s
1335main: -- quote_column_name(:runner_id_convert_to_bigint)
1336main: -> 0.0000s
1337main: -- quote_column_name(:temp_name_for_renaming)
1338main: -> 0.0000s
1339main: -- execute("ALTER TABLE \"p_ci_builds\"\n RENAME COLUMN \"runner_id_convert_to_bigint\" TO \"temp_name_for_renaming\"\n")
1340main: -> 0.0010s
1341main: -- clear_cache!(nil)
1342main: -> 0.0000s
1343main: -- quote_table_name(:p_ci_builds)
1344main: -> 0.0000s
1345main: -- quote_column_name(:runner_id)
1346main: -> 0.0000s
1347main: -- quote_column_name(:runner_id_convert_to_bigint)
1348main: -> 0.0000s
1349main: -- execute("ALTER TABLE \"p_ci_builds\"\n RENAME COLUMN \"runner_id\" TO \"runner_id_convert_to_bigint\"\n")
1350main: -> 0.0015s
1351main: -- clear_cache!(nil)
1352main: -> 0.0000s
1353main: -- quote_table_name(:p_ci_builds)
1354main: -> 0.0000s
1355main: -- quote_column_name(:temp_name_for_renaming)
1356main: -> 0.0000s
1357main: -- quote_column_name(:runner_id)
1358main: -> 0.0000s
1359main: -- execute("ALTER TABLE \"p_ci_builds\"\n RENAME COLUMN \"temp_name_for_renaming\" TO \"runner_id\"\n")
1360main: -> 0.0012s
1361main: -- quote_table_name(:trigger_10ee1357e825)
1362main: -> 0.0000s
1363main: -- execute("ALTER FUNCTION \"trigger_10ee1357e825\" RESET ALL")
1364main: -> 0.0008s
1365main: -- indexes("p_ci_builds")
1366main: -> 0.0536s
1367main: -- indexes("p_ci_builds")
1368main: -> 0.0389s
1369main: -- indexes("gitlab_partitions_dynamic._test_gitlab_ci_builds_partition")
1370main: -> 0.0385s
1371main: -- indexes("gitlab_partitions_dynamic._test_gitlab_ci_builds_partition")
1372main: -> 0.0354s
1373main: -- quote_table_name("gitlab_partitions_dynamic.index_77ff69389c")
1374main: -> 0.0000s
1375main: -- quote_table_name("temp_966d91e25f")
1376main: -> 0.0000s
1377main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"index_77ff69389c\" RENAME TO \"temp_966d91e25f\"")
1378main: -> 0.0014s
1379main: -- quote_table_name("gitlab_partitions_dynamic.index_7ee2feb2c9")
1380main: -> 0.0001s
1381main: -- quote_table_name("index_77ff69389c")
1382main: -> 0.0000s
1383main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"index_7ee2feb2c9\" RENAME TO \"index_77ff69389c\"")
1384main: -> 0.0011s
1385main: -- quote_table_name("gitlab_partitions_dynamic.temp_966d91e25f")
1386main: -> 0.0000s
1387main: -- quote_table_name("index_7ee2feb2c9")
1388main: -> 0.0000s
1389main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"temp_966d91e25f\" RENAME TO \"index_7ee2feb2c9\"")
1390main: -> 0.0009s
1391main: -- indexes("public.ci_builds")
1392main: -> 0.0369s
1393main: -- indexes("public.ci_builds")
1394main: -> 0.0420s
1395main: -- quote_table_name("public.index_adafd086ad")
1396main: -> 0.0000s
1397main: -- quote_table_name("temp_e7f61ebf60")
1398main: -> 0.0000s
1399main: -- execute("ALTER INDEX \"public\".\"index_adafd086ad\" RENAME TO \"temp_e7f61ebf60\"")
1400main: -> 0.0012s
1401main: -- quote_table_name("public.index_c2e24a89ff")
1402main: -> 0.0001s
1403main: -- quote_table_name("index_adafd086ad")
1404main: -> 0.0000s
1405main: -- execute("ALTER INDEX \"public\".\"index_c2e24a89ff\" RENAME TO \"index_adafd086ad\"")
1406main: -> 0.0010s
1407main: -- quote_table_name("public.temp_e7f61ebf60")
1408main: -> 0.0000s
1409main: -- quote_table_name("index_c2e24a89ff")
1410main: -> 0.0000s
1411main: -- execute("ALTER INDEX \"public\".\"temp_e7f61ebf60\" RENAME TO \"index_c2e24a89ff\"")
1412main: -> 0.0018s
1413main: -- indexes("gitlab_partitions_dynamic.ci_builds_101")
1414main: -> 0.0402s
1415main: -- indexes("gitlab_partitions_dynamic.ci_builds_101")
1416main: -> 0.0470s
1417main: -- quote_table_name("gitlab_partitions_dynamic.index_db48796375")
1418main: -> 0.0000s
1419main: -- quote_table_name("temp_e10f0f23d2")
1420main: -> 0.0000s
1421main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"index_db48796375\" RENAME TO \"temp_e10f0f23d2\"")
1422main: -> 0.0015s
1423main: -- quote_table_name("gitlab_partitions_dynamic.index_3c2855dadb")
1424main: -> 0.0000s
1425main: -- quote_table_name("index_db48796375")
1426main: -> 0.0000s
1427main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"index_3c2855dadb\" RENAME TO \"index_db48796375\"")
1428main: -> 0.0012s
1429main: -- quote_table_name("gitlab_partitions_dynamic.temp_e10f0f23d2")
1430main: -> 0.0000s
1431main: -- quote_table_name("index_3c2855dadb")
1432main: -> 0.0000s
1433main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"temp_e10f0f23d2\" RENAME TO \"index_3c2855dadb\"")
1434main: -> 0.0011s
1435main: -- indexes("gitlab_partitions_dynamic.ci_builds_102")
1436main: -> 0.0400s
1437main: -- indexes("gitlab_partitions_dynamic.ci_builds_102")
1438main: -> 0.0378s
1439main: -- quote_table_name("gitlab_partitions_dynamic.index_8a013a3c62")
1440main: -> 0.0000s
1441main: -- quote_table_name("temp_94d8a588ae")
1442main: -> 0.0000s
1443main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"index_8a013a3c62\" RENAME TO \"temp_94d8a588ae\"")
1444main: -> 0.0019s
1445main: -- quote_table_name("gitlab_partitions_dynamic.index_98bb37e896")
1446main: -> 0.0001s
1447main: -- quote_table_name("index_8a013a3c62")
1448main: -> 0.0000s
1449main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"index_98bb37e896\" RENAME TO \"index_8a013a3c62\"")
1450main: -> 0.0011s
1451main: -- quote_table_name("gitlab_partitions_dynamic.temp_94d8a588ae")
1452main: -> 0.0000s
1453main: -- quote_table_name("index_98bb37e896")
1454main: -> 0.0000s
1455main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"temp_94d8a588ae\" RENAME TO \"index_98bb37e896\"")
1456main: -> 0.0009s
1457main: -- quote_table_name("p_ci_builds_runner_id_bigint_id_idx")
1458main: -> 0.0000s
1459main: -- quote_table_name("temp_4cad540b65")
1460main: -> 0.0000s
1461main: -- execute("ALTER INDEX \"p_ci_builds_runner_id_bigint_id_idx\" RENAME TO \"temp_4cad540b65\"")
1462main: -> 0.0008s
1463main: -- quote_table_name("p_ci_builds_runner_id_id_idx")
1464main: -> 0.0000s
1465main: -- quote_table_name(:p_ci_builds_runner_id_bigint_id_idx)
1466main: -> 0.0000s
1467main: -- execute("ALTER INDEX \"p_ci_builds_runner_id_id_idx\" RENAME TO \"p_ci_builds_runner_id_bigint_id_idx\"")
1468main: -> 0.0008s
1469main: -- quote_table_name("temp_4cad540b65")
1470main: -> 0.0000s
1471main: -- quote_table_name(:p_ci_builds_runner_id_id_idx)
1472main: -> 0.0000s
1473main: -- execute("ALTER INDEX \"temp_4cad540b65\" RENAME TO \"p_ci_builds_runner_id_id_idx\"")
1474main: -> 0.0008s
1475main: -- remove_index(:p_ci_builds, {:name=>:p_ci_builds_runner_id_bigint_id_idx, :if_exists=>true})
1476main: -> 0.0819s
1477main: -- indexes("p_ci_builds")
1478main: -> 0.0810s
1479main: -- indexes("p_ci_builds")
1480main: -> 0.0721s
1481main: -- indexes("gitlab_partitions_dynamic._test_gitlab_ci_builds_partition")
1482main: -> 0.0903s
1483main: -- indexes("gitlab_partitions_dynamic._test_gitlab_ci_builds_partition")
1484main: -> 0.0444s
1485main: -- quote_table_name("gitlab_partitions_dynamic.index_4c88304bfe")
1486main: -> 0.0000s
1487main: -- quote_table_name("temp_d3b65f65b8")
1488main: -> 0.0000s
1489main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"index_4c88304bfe\" RENAME TO \"temp_d3b65f65b8\"")
1490main: -> 0.0013s
1491main: -- quote_table_name("gitlab_partitions_dynamic._test_gitlab_ci_builds_partitio_runner_id_convert_to_bigint_idx")
1492main: -> 0.0000s
1493main: -- quote_table_name("index_4c88304bfe")
1494main: -> 0.0000s
1495main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"_test_gitlab_ci_builds_partitio_runner_id_convert_to_bigint_idx\" RENAME TO \"index_4c88304bfe\"")
1496main: -> 0.0010s
1497main: -- quote_table_name("gitlab_partitions_dynamic.temp_d3b65f65b8")
1498main: -> 0.0000s
1499main: -- quote_table_name("_test_gitlab_ci_builds_partitio_runner_id_convert_to_bigint_idx")
1500main: -> 0.0000s
1501main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"temp_d3b65f65b8\" RENAME TO \"_test_gitlab_ci_builds_partitio_runner_id_convert_to_bigint_idx\"")
1502main: -> 0.0009s
1503main: -- indexes("public.ci_builds")
1504main: -> 0.0387s
1505main: -- indexes("public.ci_builds")
1506main: -> 0.0506s
1507main: -- quote_table_name("public.index_b4cf879bcf")
1508main: -> 0.0000s
1509main: -- quote_table_name("temp_87733f0b5e")
1510main: -> 0.0000s
1511main: -- execute("ALTER INDEX \"public\".\"index_b4cf879bcf\" RENAME TO \"temp_87733f0b5e\"")
1512main: -> 0.0021s
1513main: -- quote_table_name("public.index_ci_builds_runner_id_running")
1514main: -> 0.0000s
1515main: -- quote_table_name("index_b4cf879bcf")
1516main: -> 0.0000s
1517main: -- execute("ALTER INDEX \"public\".\"index_ci_builds_runner_id_running\" RENAME TO \"index_b4cf879bcf\"")
1518main: -> 0.0014s
1519main: -- quote_table_name("public.temp_87733f0b5e")
1520main: -> 0.0000s
1521main: -- quote_table_name("index_ci_builds_runner_id_running")
1522main: -> 0.0000s
1523main: -- execute("ALTER INDEX \"public\".\"temp_87733f0b5e\" RENAME TO \"index_ci_builds_runner_id_running\"")
1524main: -> 0.0013s
1525main: -- indexes("gitlab_partitions_dynamic.ci_builds_101")
1526main: -> 0.0548s
1527main: -- indexes("gitlab_partitions_dynamic.ci_builds_101")
1528main: -> 0.0376s
1529main: -- quote_table_name("gitlab_partitions_dynamic.index_61c5c551d1")
1530main: -> 0.0000s
1531main: -- quote_table_name("temp_fbc080f86d")
1532main: -> 0.0000s
1533main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"index_61c5c551d1\" RENAME TO \"temp_fbc080f86d\"")
1534main: -> 0.0012s
1535main: -- quote_table_name("gitlab_partitions_dynamic.ci_builds_101_runner_id_idx")
1536main: -> 0.0000s
1537main: -- quote_table_name("index_61c5c551d1")
1538main: -> 0.0000s
1539main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"ci_builds_101_runner_id_idx\" RENAME TO \"index_61c5c551d1\"")
1540main: -> 0.0011s
1541main: -- quote_table_name("gitlab_partitions_dynamic.temp_fbc080f86d")
1542main: -> 0.0000s
1543main: -- quote_table_name("ci_builds_101_runner_id_idx")
1544main: -> 0.0000s
1545main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"temp_fbc080f86d\" RENAME TO \"ci_builds_101_runner_id_idx\"")
1546main: -> 0.0010s
1547main: -- indexes("gitlab_partitions_dynamic.ci_builds_102")
1548main: -> 0.0414s
1549main: -- indexes("gitlab_partitions_dynamic.ci_builds_102")
1550main: -> 0.0438s
1551main: -- quote_table_name("gitlab_partitions_dynamic.index_65de480d99")
1552main: -> 0.0000s
1553main: -- quote_table_name("temp_2c0f151ae2")
1554main: -> 0.0000s
1555main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"index_65de480d99\" RENAME TO \"temp_2c0f151ae2\"")
1556main: -> 0.0015s
1557main: -- quote_table_name("gitlab_partitions_dynamic.ci_builds_102_runner_id_idx")
1558main: -> 0.0000s
1559main: -- quote_table_name("index_65de480d99")
1560main: -> 0.0000s
1561main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"ci_builds_102_runner_id_idx\" RENAME TO \"index_65de480d99\"")
1562main: -> 0.0015s
1563main: -- quote_table_name("gitlab_partitions_dynamic.temp_2c0f151ae2")
1564main: -> 0.0000s
1565main: -- quote_table_name("ci_builds_102_runner_id_idx")
1566main: -> 0.0000s
1567main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"temp_2c0f151ae2\" RENAME TO \"ci_builds_102_runner_id_idx\"")
1568main: -> 0.0013s
1569main: -- quote_table_name("p_ci_builds_runner_id_bigint_idx")
1570main: -> 0.0000s
1571main: -- quote_table_name("temp_61a737762c")
1572main: -> 0.0000s
1573main: -- execute("ALTER INDEX \"p_ci_builds_runner_id_bigint_idx\" RENAME TO \"temp_61a737762c\"")
1574main: -> 0.0012s
1575main: -- quote_table_name("p_ci_builds_runner_id_idx")
1576main: -> 0.0000s
1577main: -- quote_table_name(:p_ci_builds_runner_id_bigint_idx)
1578main: -> 0.0000s
1579main: -- execute("ALTER INDEX \"p_ci_builds_runner_id_idx\" RENAME TO \"p_ci_builds_runner_id_bigint_idx\"")
1580main: -> 0.0028s
1581main: -- quote_table_name("temp_61a737762c")
1582main: -> 0.0001s
1583main: -- quote_table_name(:p_ci_builds_runner_id_idx)
1584main: -> 0.0000s
1585main: -- execute("ALTER INDEX \"temp_61a737762c\" RENAME TO \"p_ci_builds_runner_id_idx\"")
1586main: -> 0.0022s
1587main: -- remove_index(:p_ci_builds, {:name=>:p_ci_builds_runner_id_bigint_idx, :if_exists=>true})
1588main: -> 0.1006s
1589main: -- indexes("p_ci_builds")
1590main: -> 0.0397s
1591main: -- indexes("p_ci_builds")
1592main: -> 0.0414s
1593main: -- indexes("gitlab_partitions_dynamic._test_gitlab_ci_builds_partition")
1594main: -> 0.0381s
1595main: -- indexes("gitlab_partitions_dynamic._test_gitlab_ci_builds_partition")
1596main: -> 0.0427s
1597main: -- quote_table_name("gitlab_partitions_dynamic.index_4d63615bc0")
1598main: -> 0.0000s
1599main: -- quote_table_name("temp_b84d9deaf6")
1600main: -> 0.0000s
1601main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"index_4d63615bc0\" RENAME TO \"temp_b84d9deaf6\"")
1602main: -> 0.0013s
1603main: -- quote_table_name("gitlab_partitions_dynamic._test_gitlab_ci_builds_partit_status_type_runner_id_convert_idx")
1604main: -> 0.0000s
1605main: -- quote_table_name("index_4d63615bc0")
1606main: -> 0.0000s
1607main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"_test_gitlab_ci_builds_partit_status_type_runner_id_convert_idx\" RENAME TO \"index_4d63615bc0\"")
1608main: -> 0.0011s
1609main: -- quote_table_name("gitlab_partitions_dynamic.temp_b84d9deaf6")
1610main: -> 0.0000s
1611main: -- quote_table_name("_test_gitlab_ci_builds_partit_status_type_runner_id_convert_idx")
1612main: -> 0.0000s
1613main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"temp_b84d9deaf6\" RENAME TO \"_test_gitlab_ci_builds_partit_status_type_runner_id_convert_idx\"")
1614main: -> 0.0010s
1615main: -- indexes("public.ci_builds")
1616main: -> 0.0332s
1617main: -- indexes("public.ci_builds")
1618main: -> 0.0400s
1619main: -- quote_table_name("public.index_9f1fa3baee")
1620main: -> 0.0000s
1621main: -- quote_table_name("temp_666923d3fa")
1622main: -> 0.0000s
1623main: -- execute("ALTER INDEX \"public\".\"index_9f1fa3baee\" RENAME TO \"temp_666923d3fa\"")
1624main: -> 0.0042s
1625main: -- quote_table_name("public.index_ci_builds_on_status_and_type_and_runner_id")
1626main: -> 0.0000s
1627main: -- quote_table_name("index_9f1fa3baee")
1628main: -> 0.0000s
1629main: -- execute("ALTER INDEX \"public\".\"index_ci_builds_on_status_and_type_and_runner_id\" RENAME TO \"index_9f1fa3baee\"")
1630main: -> 0.0016s
1631main: -- quote_table_name("public.temp_666923d3fa")
1632main: -> 0.0000s
1633main: -- quote_table_name("index_ci_builds_on_status_and_type_and_runner_id")
1634main: -> 0.0000s
1635main: -- execute("ALTER INDEX \"public\".\"temp_666923d3fa\" RENAME TO \"index_ci_builds_on_status_and_type_and_runner_id\"")
1636main: -> 0.0016s
1637main: -- indexes("gitlab_partitions_dynamic.ci_builds_101")
1638main: -> 0.0313s
1639main: -- indexes("gitlab_partitions_dynamic.ci_builds_101")
1640main: -> 0.0351s
1641main: -- quote_table_name("gitlab_partitions_dynamic.index_a877f193a3")
1642main: -> 0.0000s
1643main: -- quote_table_name("temp_ae2e1a75f0")
1644main: -> 0.0000s
1645main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"index_a877f193a3\" RENAME TO \"temp_ae2e1a75f0\"")
1646main: -> 0.0017s
1647main: -- quote_table_name("gitlab_partitions_dynamic.ci_builds_101_status_type_runner_id_idx")
1648main: -> 0.0000s
1649main: -- quote_table_name("index_a877f193a3")
1650main: -> 0.0000s
1651main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"ci_builds_101_status_type_runner_id_idx\" RENAME TO \"index_a877f193a3\"")
1652main: -> 0.0012s
1653main: -- quote_table_name("gitlab_partitions_dynamic.temp_ae2e1a75f0")
1654main: -> 0.0000s
1655main: -- quote_table_name("ci_builds_101_status_type_runner_id_idx")
1656main: -> 0.0000s
1657main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"temp_ae2e1a75f0\" RENAME TO \"ci_builds_101_status_type_runner_id_idx\"")
1658main: -> 0.0013s
1659main: -- indexes("gitlab_partitions_dynamic.ci_builds_102")
1660main: -> 0.0344s
1661main: -- indexes("gitlab_partitions_dynamic.ci_builds_102")
1662main: -> 0.0498s
1663main: -- quote_table_name("gitlab_partitions_dynamic.index_a3ab818c70")
1664main: -> 0.0000s
1665main: -- quote_table_name("temp_4e9cec7e02")
1666main: -> 0.0000s
1667main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"index_a3ab818c70\" RENAME TO \"temp_4e9cec7e02\"")
1668main: -> 0.0013s
1669main: -- quote_table_name("gitlab_partitions_dynamic.ci_builds_102_status_type_runner_id_idx")
1670main: -> 0.0000s
1671main: -- quote_table_name("index_a3ab818c70")
1672main: -> 0.0000s
1673main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"ci_builds_102_status_type_runner_id_idx\" RENAME TO \"index_a3ab818c70\"")
1674main: -> 0.0014s
1675main: -- quote_table_name("gitlab_partitions_dynamic.temp_4e9cec7e02")
1676main: -> 0.0000s
1677main: -- quote_table_name("ci_builds_102_status_type_runner_id_idx")
1678main: -> 0.0000s
1679main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"temp_4e9cec7e02\" RENAME TO \"ci_builds_102_status_type_runner_id_idx\"")
1680main: -> 0.0011s
1681main: -- quote_table_name("p_ci_builds_status_type_runner_id_bigint_idx")
1682main: -> 0.0000s
1683main: -- quote_table_name("temp_427bdbf302")
1684main: -> 0.0000s
1685main: -- execute("ALTER INDEX \"p_ci_builds_status_type_runner_id_bigint_idx\" RENAME TO \"temp_427bdbf302\"")
1686main: -> 0.0010s
1687main: -- quote_table_name("p_ci_builds_status_type_runner_id_idx")
1688main: -> 0.0000s
1689main: -- quote_table_name(:p_ci_builds_status_type_runner_id_bigint_idx)
1690main: -> 0.0000s
1691main: -- execute("ALTER INDEX \"p_ci_builds_status_type_runner_id_idx\" RENAME TO \"p_ci_builds_status_type_runner_id_bigint_idx\"")
1692main: -> 0.0010s
1693main: -- quote_table_name("temp_427bdbf302")
1694main: -> 0.0000s
1695main: -- quote_table_name(:p_ci_builds_status_type_runner_id_idx)
1696main: -> 0.0000s
1697main: -- execute("ALTER INDEX \"temp_427bdbf302\" RENAME TO \"p_ci_builds_status_type_runner_id_idx\"")
1698main: -> 0.0010s
1699main: -- remove_index(:p_ci_builds, {:name=>:p_ci_builds_status_type_runner_id_bigint_idx, :if_exists=>true})
1700main: -> 0.0819s
1701main: == 20240416005004 SwapColumnsForPCiBuildsRunnerId: migrated (2.0028s) =========
1702main: == [advisory_lock_connection] object_id: 292716640, pg_backend_pid: 245
1703 correctly swaps conversion columns
1704# [RSpecRunTime] RSpec elapsed time: 30 minutes 7.0 seconds. Current RSS: ~1171M. Threads: 2. load average: 0.97 0.99 1.02 1/292 409
1705.
1706 behaves like swap conversion columns
1707main: == [advisory_lock_connection] object_id: 298064160, pg_backend_pid: 249
1708main: == 20240416005004 SwapColumnsForPCiBuildsRunnerId: migrating ==================
1709main: -- index_name_exists?(:p_ci_builds, :p_ci_builds_runner_id_id_idx)
1710main: -> 0.0071s
1711main: -- execute("LOCK TABLE p_ci_builds IN ACCESS EXCLUSIVE MODE")
1712main: -> 0.0044s
1713main: -- clear_cache!(nil)
1714main: -> 0.0000s
1715main: -- quote_table_name(:p_ci_builds)
1716main: -> 0.0000s
1717main: -- quote_column_name(:runner_id_convert_to_bigint)
1718main: -> 0.0000s
1719main: -- quote_column_name(:temp_name_for_renaming)
1720main: -> 0.0000s
1721main: -- execute("ALTER TABLE \"p_ci_builds\"\n RENAME COLUMN \"runner_id_convert_to_bigint\" TO \"temp_name_for_renaming\"\n")
1722main: -> 0.0034s
1723main: -- clear_cache!(nil)
1724main: -> 0.0001s
1725main: -- quote_table_name(:p_ci_builds)
1726main: -> 0.0000s
1727main: -- quote_column_name(:runner_id)
1728main: -> 0.0000s
1729main: -- quote_column_name(:runner_id_convert_to_bigint)
1730main: -> 0.0000s
1731main: -- execute("ALTER TABLE \"p_ci_builds\"\n RENAME COLUMN \"runner_id\" TO \"runner_id_convert_to_bigint\"\n")
1732main: -> 0.0046s
1733main: -- clear_cache!(nil)
1734main: -> 0.0001s
1735main: -- quote_table_name(:p_ci_builds)
1736main: -> 0.0000s
1737main: -- quote_column_name(:temp_name_for_renaming)
1738main: -> 0.0000s
1739main: -- quote_column_name(:runner_id)
1740main: -> 0.0000s
1741main: -- execute("ALTER TABLE \"p_ci_builds\"\n RENAME COLUMN \"temp_name_for_renaming\" TO \"runner_id\"\n")
1742main: -> 0.0063s
1743main: -- quote_table_name(:trigger_10ee1357e825)
1744main: -> 0.0001s
1745main: -- execute("ALTER FUNCTION \"trigger_10ee1357e825\" RESET ALL")
1746main: -> 0.0029s
1747main: -- indexes("p_ci_builds")
1748main: -> 0.0552s
1749main: -- indexes("p_ci_builds")
1750main: -> 0.0594s
1751main: -- indexes("gitlab_partitions_dynamic._test_gitlab_ci_builds_partition")
1752main: -> 0.0458s
1753main: -- indexes("gitlab_partitions_dynamic._test_gitlab_ci_builds_partition")
1754main: -> 0.0683s
1755main: -- quote_table_name("gitlab_partitions_dynamic.index_77ff69389c")
1756main: -> 0.0000s
1757main: -- quote_table_name("temp_966d91e25f")
1758main: -> 0.0000s
1759main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"index_77ff69389c\" RENAME TO \"temp_966d91e25f\"")
1760main: -> 0.0015s
1761main: -- quote_table_name("gitlab_partitions_dynamic.index_7ee2feb2c9")
1762main: -> 0.0000s
1763main: -- quote_table_name("index_77ff69389c")
1764main: -> 0.0000s
1765main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"index_7ee2feb2c9\" RENAME TO \"index_77ff69389c\"")
1766main: -> 0.0013s
1767main: -- quote_table_name("gitlab_partitions_dynamic.temp_966d91e25f")
1768main: -> 0.0000s
1769main: -- quote_table_name("index_7ee2feb2c9")
1770main: -> 0.0000s
1771main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"temp_966d91e25f\" RENAME TO \"index_7ee2feb2c9\"")
1772main: -> 0.0012s
1773main: -- indexes("public.ci_builds")
1774main: -> 0.0794s
1775main: -- indexes("public.ci_builds")
1776main: -> 0.1132s
1777main: -- quote_table_name("public.index_adafd086ad")
1778main: -> 0.0000s
1779main: -- quote_table_name("temp_e7f61ebf60")
1780main: -> 0.0000s
1781main: -- execute("ALTER INDEX \"public\".\"index_adafd086ad\" RENAME TO \"temp_e7f61ebf60\"")
1782main: -> 0.0043s
1783main: -- quote_table_name("public.index_c2e24a89ff")
1784main: -> 0.0000s
1785main: -- quote_table_name("index_adafd086ad")
1786main: -> 0.0000s
1787main: -- execute("ALTER INDEX \"public\".\"index_c2e24a89ff\" RENAME TO \"index_adafd086ad\"")
1788main: -> 0.0023s
1789main: -- quote_table_name("public.temp_e7f61ebf60")
1790main: -> 0.0000s
1791main: -- quote_table_name("index_c2e24a89ff")
1792main: -> 0.0000s
1793main: -- execute("ALTER INDEX \"public\".\"temp_e7f61ebf60\" RENAME TO \"index_c2e24a89ff\"")
1794main: -> 0.0022s
1795main: -- indexes("gitlab_partitions_dynamic.ci_builds_101")
1796main: -> 0.0639s
1797main: -- indexes("gitlab_partitions_dynamic.ci_builds_101")
1798main: -> 0.0431s
1799main: -- quote_table_name("gitlab_partitions_dynamic.index_db48796375")
1800main: -> 0.0000s
1801main: -- quote_table_name("temp_e10f0f23d2")
1802main: -> 0.0000s
1803main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"index_db48796375\" RENAME TO \"temp_e10f0f23d2\"")
1804main: -> 0.0018s
1805main: -- quote_table_name("gitlab_partitions_dynamic.index_3c2855dadb")
1806main: -> 0.0000s
1807main: -- quote_table_name("index_db48796375")
1808main: -> 0.0000s
1809main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"index_3c2855dadb\" RENAME TO \"index_db48796375\"")
1810main: -> 0.0014s
1811main: -- quote_table_name("gitlab_partitions_dynamic.temp_e10f0f23d2")
1812main: -> 0.0000s
1813main: -- quote_table_name("index_3c2855dadb")
1814main: -> 0.0000s
1815main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"temp_e10f0f23d2\" RENAME TO \"index_3c2855dadb\"")
1816main: -> 0.0012s
1817main: -- indexes("gitlab_partitions_dynamic.ci_builds_102")
1818main: -> 0.0985s
1819main: -- indexes("gitlab_partitions_dynamic.ci_builds_102")
1820main: -> 0.0833s
1821main: -- quote_table_name("gitlab_partitions_dynamic.index_8a013a3c62")
1822main: -> 0.0000s
1823main: -- quote_table_name("temp_94d8a588ae")
1824main: -> 0.0000s
1825main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"index_8a013a3c62\" RENAME TO \"temp_94d8a588ae\"")
1826main: -> 0.0018s
1827main: -- quote_table_name("gitlab_partitions_dynamic.index_98bb37e896")
1828main: -> 0.0000s
1829main: -- quote_table_name("index_8a013a3c62")
1830main: -> 0.0000s
1831main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"index_98bb37e896\" RENAME TO \"index_8a013a3c62\"")
1832main: -> 0.0017s
1833main: -- quote_table_name("gitlab_partitions_dynamic.temp_94d8a588ae")
1834main: -> 0.0000s
1835main: -- quote_table_name("index_98bb37e896")
1836main: -> 0.0000s
1837main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"temp_94d8a588ae\" RENAME TO \"index_98bb37e896\"")
1838main: -> 0.0013s
1839main: -- quote_table_name("p_ci_builds_runner_id_bigint_id_idx")
1840main: -> 0.0000s
1841main: -- quote_table_name("temp_4cad540b65")
1842main: -> 0.0000s
1843main: -- execute("ALTER INDEX \"p_ci_builds_runner_id_bigint_id_idx\" RENAME TO \"temp_4cad540b65\"")
1844main: -> 0.0014s
1845main: -- quote_table_name("p_ci_builds_runner_id_id_idx")
1846main: -> 0.0000s
1847main: -- quote_table_name(:p_ci_builds_runner_id_bigint_id_idx)
1848main: -> 0.0000s
1849main: -- execute("ALTER INDEX \"p_ci_builds_runner_id_id_idx\" RENAME TO \"p_ci_builds_runner_id_bigint_id_idx\"")
1850main: -> 0.0015s
1851main: -- quote_table_name("temp_4cad540b65")
1852main: -> 0.0000s
1853main: -- quote_table_name(:p_ci_builds_runner_id_id_idx)
1854main: -> 0.0000s
1855main: -- execute("ALTER INDEX \"temp_4cad540b65\" RENAME TO \"p_ci_builds_runner_id_id_idx\"")
1856main: -> 0.0016s
1857main: -- remove_index(:p_ci_builds, {:name=>:p_ci_builds_runner_id_bigint_id_idx, :if_exists=>true})
1858main: -> 0.1115s
1859main: -- indexes("p_ci_builds")
1860main: -> 0.0944s
1861main: -- indexes("p_ci_builds")
1862main: -> 0.0650s
1863main: -- indexes("gitlab_partitions_dynamic._test_gitlab_ci_builds_partition")
1864main: -> 0.0762s
1865main: -- indexes("gitlab_partitions_dynamic._test_gitlab_ci_builds_partition")
1866main: -> 0.0446s
1867main: -- quote_table_name("gitlab_partitions_dynamic.index_4c88304bfe")
1868main: -> 0.0000s
1869main: -- quote_table_name("temp_d3b65f65b8")
1870main: -> 0.0000s
1871main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"index_4c88304bfe\" RENAME TO \"temp_d3b65f65b8\"")
1872main: -> 0.0019s
1873main: -- quote_table_name("gitlab_partitions_dynamic._test_gitlab_ci_builds_partitio_runner_id_convert_to_bigint_idx")
1874main: -> 0.0000s
1875main: -- quote_table_name("index_4c88304bfe")
1876main: -> 0.0000s
1877main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"_test_gitlab_ci_builds_partitio_runner_id_convert_to_bigint_idx\" RENAME TO \"index_4c88304bfe\"")
1878main: -> 0.0011s
1879main: -- quote_table_name("gitlab_partitions_dynamic.temp_d3b65f65b8")
1880main: -> 0.0000s
1881main: -- quote_table_name("_test_gitlab_ci_builds_partitio_runner_id_convert_to_bigint_idx")
1882main: -> 0.0000s
1883main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"temp_d3b65f65b8\" RENAME TO \"_test_gitlab_ci_builds_partitio_runner_id_convert_to_bigint_idx\"")
1884main: -> 0.0010s
1885main: -- indexes("public.ci_builds")
1886main: -> 0.0392s
1887main: -- indexes("public.ci_builds")
1888main: -> 0.0335s
1889main: -- quote_table_name("public.index_b4cf879bcf")
1890main: -> 0.0001s
1891main: -- quote_table_name("temp_87733f0b5e")
1892main: -> 0.0000s
1893main: -- execute("ALTER INDEX \"public\".\"index_b4cf879bcf\" RENAME TO \"temp_87733f0b5e\"")
1894main: -> 0.0173s
1895main: -- quote_table_name("public.index_ci_builds_runner_id_running")
1896main: -> 0.0000s
1897main: -- quote_table_name("index_b4cf879bcf")
1898main: -> 0.0000s
1899main: -- execute("ALTER INDEX \"public\".\"index_ci_builds_runner_id_running\" RENAME TO \"index_b4cf879bcf\"")
1900main: -> 0.0032s
1901main: -- quote_table_name("public.temp_87733f0b5e")
1902main: -> 0.0001s
1903main: -- quote_table_name("index_ci_builds_runner_id_running")
1904main: -> 0.0000s
1905main: -- execute("ALTER INDEX \"public\".\"temp_87733f0b5e\" RENAME TO \"index_ci_builds_runner_id_running\"")
1906main: -> 0.0028s
1907main: -- indexes("gitlab_partitions_dynamic.ci_builds_101")
1908main: -> 0.0518s
1909main: -- indexes("gitlab_partitions_dynamic.ci_builds_101")
1910main: -> 0.0750s
1911main: -- quote_table_name("gitlab_partitions_dynamic.index_61c5c551d1")
1912main: -> 0.0000s
1913main: -- quote_table_name("temp_fbc080f86d")
1914main: -> 0.0000s
1915main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"index_61c5c551d1\" RENAME TO \"temp_fbc080f86d\"")
1916main: -> 0.0014s
1917main: -- quote_table_name("gitlab_partitions_dynamic.ci_builds_101_runner_id_idx")
1918main: -> 0.0000s
1919main: -- quote_table_name("index_61c5c551d1")
1920main: -> 0.0000s
1921main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"ci_builds_101_runner_id_idx\" RENAME TO \"index_61c5c551d1\"")
1922main: -> 0.0013s
1923main: -- quote_table_name("gitlab_partitions_dynamic.temp_fbc080f86d")
1924main: -> 0.0000s
1925main: -- quote_table_name("ci_builds_101_runner_id_idx")
1926main: -> 0.0000s
1927main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"temp_fbc080f86d\" RENAME TO \"ci_builds_101_runner_id_idx\"")
1928main: -> 0.0012s
1929main: -- indexes("gitlab_partitions_dynamic.ci_builds_102")
1930main: -> 0.0533s
1931main: -- indexes("gitlab_partitions_dynamic.ci_builds_102")
1932main: -> 0.0385s
1933main: -- quote_table_name("gitlab_partitions_dynamic.index_65de480d99")
1934main: -> 0.0000s
1935main: -- quote_table_name("temp_2c0f151ae2")
1936main: -> 0.0000s
1937main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"index_65de480d99\" RENAME TO \"temp_2c0f151ae2\"")
1938main: -> 0.0011s
1939main: -- quote_table_name("gitlab_partitions_dynamic.ci_builds_102_runner_id_idx")
1940main: -> 0.0000s
1941main: -- quote_table_name("index_65de480d99")
1942main: -> 0.0000s
1943main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"ci_builds_102_runner_id_idx\" RENAME TO \"index_65de480d99\"")
1944main: -> 0.0009s
1945main: -- quote_table_name("gitlab_partitions_dynamic.temp_2c0f151ae2")
1946main: -> 0.0000s
1947main: -- quote_table_name("ci_builds_102_runner_id_idx")
1948main: -> 0.0000s
1949main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"temp_2c0f151ae2\" RENAME TO \"ci_builds_102_runner_id_idx\"")
1950main: -> 0.0008s
1951main: -- quote_table_name("p_ci_builds_runner_id_bigint_idx")
1952main: -> 0.0000s
1953main: -- quote_table_name("temp_61a737762c")
1954main: -> 0.0000s
1955main: -- execute("ALTER INDEX \"p_ci_builds_runner_id_bigint_idx\" RENAME TO \"temp_61a737762c\"")
1956main: -> 0.0008s
1957main: -- quote_table_name("p_ci_builds_runner_id_idx")
1958main: -> 0.0000s
1959main: -- quote_table_name(:p_ci_builds_runner_id_bigint_idx)
1960main: -> 0.0000s
1961main: -- execute("ALTER INDEX \"p_ci_builds_runner_id_idx\" RENAME TO \"p_ci_builds_runner_id_bigint_idx\"")
1962main: -> 0.0008s
1963main: -- quote_table_name("temp_61a737762c")
1964main: -> 0.0000s
1965main: -- quote_table_name(:p_ci_builds_runner_id_idx)
1966main: -> 0.0000s
1967main: -- execute("ALTER INDEX \"temp_61a737762c\" RENAME TO \"p_ci_builds_runner_id_idx\"")
1968main: -> 0.0008s
1969main: -- remove_index(:p_ci_builds, {:name=>:p_ci_builds_runner_id_bigint_idx, :if_exists=>true})
1970main: -> 0.0722s
1971main: -- indexes("p_ci_builds")
1972main: -> 0.0323s
1973main: -- indexes("p_ci_builds")
1974main: -> 0.0491s
1975main: -- indexes("gitlab_partitions_dynamic._test_gitlab_ci_builds_partition")
1976main: -> 0.0428s
1977main: -- indexes("gitlab_partitions_dynamic._test_gitlab_ci_builds_partition")
1978main: -> 0.0386s
1979main: -- quote_table_name("gitlab_partitions_dynamic.index_4d63615bc0")
1980main: -> 0.0000s
1981main: -- quote_table_name("temp_b84d9deaf6")
1982main: -> 0.0000s
1983main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"index_4d63615bc0\" RENAME TO \"temp_b84d9deaf6\"")
1984main: -> 0.0012s
1985main: -- quote_table_name("gitlab_partitions_dynamic._test_gitlab_ci_builds_partit_status_type_runner_id_convert_idx")
1986main: -> 0.0000s
1987main: -- quote_table_name("index_4d63615bc0")
1988main: -> 0.0000s
1989main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"_test_gitlab_ci_builds_partit_status_type_runner_id_convert_idx\" RENAME TO \"index_4d63615bc0\"")
1990main: -> 0.0011s
1991main: -- quote_table_name("gitlab_partitions_dynamic.temp_b84d9deaf6")
1992main: -> 0.0000s
1993main: -- quote_table_name("_test_gitlab_ci_builds_partit_status_type_runner_id_convert_idx")
1994main: -> 0.0000s
1995main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"temp_b84d9deaf6\" RENAME TO \"_test_gitlab_ci_builds_partit_status_type_runner_id_convert_idx\"")
1996main: -> 0.0012s
1997main: -- indexes("public.ci_builds")
1998main: -> 0.0663s
1999main: -- indexes("public.ci_builds")
2000main: -> 0.0553s
2001main: -- quote_table_name("public.index_9f1fa3baee")
2002main: -> 0.0001s
2003main: -- quote_table_name("temp_666923d3fa")
2004main: -> 0.0000s
2005main: -- execute("ALTER INDEX \"public\".\"index_9f1fa3baee\" RENAME TO \"temp_666923d3fa\"")
2006main: -> 0.0040s
2007main: -- quote_table_name("public.index_ci_builds_on_status_and_type_and_runner_id")
2008main: -> 0.0000s
2009main: -- quote_table_name("index_9f1fa3baee")
2010main: -> 0.0000s
2011main: -- execute("ALTER INDEX \"public\".\"index_ci_builds_on_status_and_type_and_runner_id\" RENAME TO \"index_9f1fa3baee\"")
2012main: -> 0.0043s
2013main: -- quote_table_name("public.temp_666923d3fa")
2014main: -> 0.0000s
2015main: -- quote_table_name("index_ci_builds_on_status_and_type_and_runner_id")
2016main: -> 0.0000s
2017main: -- execute("ALTER INDEX \"public\".\"temp_666923d3fa\" RENAME TO \"index_ci_builds_on_status_and_type_and_runner_id\"")
2018main: -> 0.0031s
2019main: -- indexes("gitlab_partitions_dynamic.ci_builds_101")
2020main: -> 0.0627s
2021main: -- indexes("gitlab_partitions_dynamic.ci_builds_101")
2022main: -> 0.0419s
2023main: -- quote_table_name("gitlab_partitions_dynamic.index_a877f193a3")
2024main: -> 0.0001s
2025main: -- quote_table_name("temp_ae2e1a75f0")
2026main: -> 0.0000s
2027main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"index_a877f193a3\" RENAME TO \"temp_ae2e1a75f0\"")
2028main: -> 0.0015s
2029main: -- quote_table_name("gitlab_partitions_dynamic.ci_builds_101_status_type_runner_id_idx")
2030main: -> 0.0000s
2031main: -- quote_table_name("index_a877f193a3")
2032main: -> 0.0000s
2033main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"ci_builds_101_status_type_runner_id_idx\" RENAME TO \"index_a877f193a3\"")
2034main: -> 0.0012s
2035main: -- quote_table_name("gitlab_partitions_dynamic.temp_ae2e1a75f0")
2036main: -> 0.0000s
2037main: -- quote_table_name("ci_builds_101_status_type_runner_id_idx")
2038main: -> 0.0000s
2039main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"temp_ae2e1a75f0\" RENAME TO \"ci_builds_101_status_type_runner_id_idx\"")
2040main: -> 0.0427s
2041main: -- indexes("gitlab_partitions_dynamic.ci_builds_102")
2042main: -> 0.0600s
2043main: -- indexes("gitlab_partitions_dynamic.ci_builds_102")
2044main: -> 0.0491s
2045main: -- quote_table_name("gitlab_partitions_dynamic.index_a3ab818c70")
2046main: -> 0.0001s
2047main: -- quote_table_name("temp_4e9cec7e02")
2048main: -> 0.0000s
2049main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"index_a3ab818c70\" RENAME TO \"temp_4e9cec7e02\"")
2050main: -> 0.0015s
2051main: -- quote_table_name("gitlab_partitions_dynamic.ci_builds_102_status_type_runner_id_idx")
2052main: -> 0.0000s
2053main: -- quote_table_name("index_a3ab818c70")
2054main: -> 0.0000s
2055main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"ci_builds_102_status_type_runner_id_idx\" RENAME TO \"index_a3ab818c70\"")
2056main: -> 0.0013s
2057main: -- quote_table_name("gitlab_partitions_dynamic.temp_4e9cec7e02")
2058main: -> 0.0000s
2059main: -- quote_table_name("ci_builds_102_status_type_runner_id_idx")
2060main: -> 0.0015s
2061main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"temp_4e9cec7e02\" RENAME TO \"ci_builds_102_status_type_runner_id_idx\"")
2062main: -> 0.0014s
2063main: -- quote_table_name("p_ci_builds_status_type_runner_id_bigint_idx")
2064main: -> 0.0000s
2065main: -- quote_table_name("temp_427bdbf302")
2066main: -> 0.0000s
2067main: -- execute("ALTER INDEX \"p_ci_builds_status_type_runner_id_bigint_idx\" RENAME TO \"temp_427bdbf302\"")
2068main: -> 0.0012s
2069main: -- quote_table_name("p_ci_builds_status_type_runner_id_idx")
2070main: -> 0.0000s
2071main: -- quote_table_name(:p_ci_builds_status_type_runner_id_bigint_idx)
2072main: -> 0.0000s
2073main: -- execute("ALTER INDEX \"p_ci_builds_status_type_runner_id_idx\" RENAME TO \"p_ci_builds_status_type_runner_id_bigint_idx\"")
2074main: -> 0.0013s
2075main: -- quote_table_name("temp_427bdbf302")
2076main: -> 0.0000s
2077main: -- quote_table_name(:p_ci_builds_status_type_runner_id_idx)
2078main: -> 0.0000s
2079main: -- execute("ALTER INDEX \"temp_427bdbf302\" RENAME TO \"p_ci_builds_status_type_runner_id_idx\"")
2080main: -> 0.0011s
2081main: -- remove_index(:p_ci_builds, {:name=>:p_ci_builds_status_type_runner_id_bigint_idx, :if_exists=>true})
2082main: -> 0.1149s
2083main: == 20240416005004 SwapColumnsForPCiBuildsRunnerId: migrated (2.3745s) =========
2084main: == [advisory_lock_connection] object_id: 298064160, pg_backend_pid: 249
2085 correctly swaps conversion columns
2086# [RSpecRunTime] RSpec elapsed time: 30 minutes 23.04 seconds. Current RSS: ~1157M. Threads: 2. load average: 1.06 1.00 1.02 1/292 410
2087.
2088# [RSpecRunTime] Finishing example group spec/migrations/db/post_migrate/20240416005004_swap_columns_for_p_ci_builds_runner_id_spec.rb. It took 1 minute 23.03 seconds. Expected to take 41.92 seconds.
2089# [RSpecRunTime] RSpec elapsed time: 30 minutes 46.72 seconds. Current RSS: ~1138M. Threads: 2. load average: 1.09 1.02 1.02 1/292 411
2090.
2091# [RSpecRunTime] Starting example group spec/migrations/20240508085441_re_add_redirect_routes_path_index_spec.rb. Expected to take 14.58 seconds.
2092ReAddRedirectRoutesPathIndex
2093 when the index already exist
2094main: -- indexes(:redirect_routes)
2095main: -> 0.0123s
2096 does not do anything
2097# [RSpecRunTime] RSpec elapsed time: 31 minutes 1.17 seconds. Current RSS: ~1141M. Threads: 2. load average: 1.07 1.02 1.02 1/292 412
2098.
2099 when the index does not exist
2100main: -- indexes(:redirect_routes)
2101main: -> 0.0073s
2102main: -- current_schema(nil)
2103main: -> 0.0009s
2104main: -- transaction_open?(nil)
2105main: -> 0.0001s
2106main: -- view_exists?(:postgres_partitions)
2107main: -> 0.0022s
2108main: -- index_exists?(:redirect_routes, "LOWER(path) varchar_pattern_ops", {:unique=>true, :name=>"index_redirect_routes_on_path_unique_text_pattern_ops", :algorithm=>:concurrently})
2109main: -> 0.0077s
2110main: -- add_index(:redirect_routes, "LOWER(path) varchar_pattern_ops", {:unique=>true, :name=>"index_redirect_routes_on_path_unique_text_pattern_ops", :algorithm=>:concurrently})
2111main: -> 0.0025s
2112main: -- indexes(:redirect_routes)
2113main: -> 0.0109s
2114 creates the index
2115# [RSpecRunTime] RSpec elapsed time: 31 minutes 6.65 seconds. Current RSS: ~1138M. Threads: 2. load average: 1.07 1.02 1.02 1/292 413
2116.
2117# [RSpecRunTime] Finishing example group spec/migrations/20240508085441_re_add_redirect_routes_path_index_spec.rb. It took 29.78 seconds. Expected to take 14.58 seconds.
2118# [RSpecRunTime] RSpec elapsed time: 31 minutes 16.56 seconds. Current RSS: ~1123M. Threads: 2. load average: 1.06 1.02 1.02 1/292 414
2119.
2120# [RSpecRunTime] Starting example group spec/migrations/20240501044238_queue_backfill_approval_merge_request_rule_sources_project_id_spec.rb. Expected to take 14.22 seconds.
2121QueueBackfillApprovalMergeRequestRuleSourcesProjectId
2122main: == [advisory_lock_connection] object_id: 310642520, pg_backend_pid: 262
2123main: == 20240501044238 QueueBackfillApprovalMergeRequestRuleSourcesProjectId: migrating
2124main: == 20240501044238 QueueBackfillApprovalMergeRequestRuleSourcesProjectId: migrated (0.0653s)
2125main: == [advisory_lock_connection] object_id: 310642520, pg_backend_pid: 262
2126 schedules a new batched migration
2127# [RSpecRunTime] Finishing example group spec/migrations/20240501044238_queue_backfill_approval_merge_request_rule_sources_project_id_spec.rb. It took 30.6 seconds. Expected to take 14.22 seconds.
2128# [RSpecRunTime] RSpec elapsed time: 31 minutes 47.22 seconds. Current RSS: ~1127M. Threads: 2. load average: 0.97 1.00 1.01 1/292 415
2129.
2130# [RSpecRunTime] Starting example group spec/migrations/20240521090846_queue_backfill_boards_epic_board_labels_group_id_spec.rb. Expected to take 5.92 seconds.
2131QueueBackfillBoardsEpicBoardLabelsGroupId
2132main: == [advisory_lock_connection] object_id: 312331820, pg_backend_pid: 269
2133main: == 20240521090846 QueueBackfillBoardsEpicBoardLabelsGroupId: migrating ========
2134main: == 20240521090846 QueueBackfillBoardsEpicBoardLabelsGroupId: migrated (0.0770s)
2135main: == [advisory_lock_connection] object_id: 312331820, pg_backend_pid: 269
2136 schedules a new batched migration
2137# [RSpecRunTime] Finishing example group spec/migrations/20240521090846_queue_backfill_boards_epic_board_labels_group_id_spec.rb. It took 10.75 seconds. Expected to take 5.92 seconds.
2138# [RSpecRunTime] RSpec elapsed time: 31 minutes 58.03 seconds. Current RSS: ~1124M. Threads: 2. load average: 0.97 1.00 1.01 1/292 416
2139.
2140auto_explain log contains 950 entries for main, writing to /builds/gitlab-org/gitlab/auto_explain/rspec-migration-pg14-single-db-7-15.341.main.ndjson.gz
2141took 25.355232978
2142[TEST PROF INFO] EventProf results for sql.active_record
2143Total time: 17:56.883 of 31:53.487 (56.28%)
2144Total events: 610734
2145Top 5 slowest suites (by time):
2146AddEpicWorkItemType (./spec/migrations/20230728174927_add_epic_work_item_type_spec.rb:6) – 02:17.115 (72689 / 2) of 03:50.887 (59.39%)
2147RenamePlansTi...egacyPlanNames (./spec/migrations/20230815160428_rename_plans_titles_with_legacy_plan_names_spec.rb:6) – 02:08.977 (69496 / 1) of 03:14.847 (66.19%)
2148AddCurrentUse...icWorkItemType (./spec/migrations/20230802212443_add_current_user_todos_widget_to_epic_work_item_type_spec.rb:6) – 02:07.085 (73716 / 3) of 04:18.896 (49.09%)
2149QueueBackfill...erabilityReads (./spec/migrations/20230907155247_queue_backfill_has_merge_request_of_vulnerability_reads_spec.rb:6) – 01:58.546 (66817 / 1) of 03:18.803 (59.63%)
2150SwapCommitUse...ForSelfManaged (./spec/migrations/swap_commit_user_mentions_note_id_to_bigint_for_self_managed_spec.rb:6) – 01:52.511 (74220 / 4) of 04:44.487 (39.55%)
2151Knapsack report was generated. Preview:
2152{
2153 "spec/migrations/swap_commit_user_mentions_note_id_to_bigint_for_self_managed_spec.rb": 207.2504974550002,
2154 "spec/migrations/20230802212443_add_current_user_todos_widget_to_epic_work_item_type_spec.rb": 168.41175073800014,
2155 "spec/migrations/20240108072318_fix_invalid_records_ci_build_trace_metadata_spec.rb": 98.06444563299965,
2156 "spec/migrations/20230728174927_add_epic_work_item_type_spec.rb": 145.01129479799965,
2157 "spec/migrations/20230907155247_queue_backfill_has_merge_request_of_vulnerability_reads_spec.rb": 118.38231682900005,
2158 "spec/migrations/20231103223224_backfill_zoekt_node_id_on_indexed_namespaces_spec.rb": 106.41043659499974,
2159 "spec/migrations/20230815160428_rename_plans_titles_with_legacy_plan_names_spec.rb": 102.91578632599976,
2160 "spec/migrations/20231221223259_queue_drop_vulnerabilities_without_finding_id_spec.rb": 87.05629110799964,
2161 "spec/migrations/20240209153920_queue_purge_security_scans_with_empty_finding_data_spec.rb": 66.15885574299955,
2162 "spec/migrations/db/post_migrate/20240416005004_swap_columns_for_p_ci_builds_runner_id_spec.rb": 59.65881246400022,
2163 "spec/migrations/20240508085441_re_add_redirect_routes_path_index_spec.rb": 20.179079235000245,
2164 "spec/migrations/20240501044238_queue_backfill_approval_merge_request_rule_sources_project_id_spec.rb": 18.486163775000023,
2165 "spec/migrations/20240521090846_queue_backfill_boards_epic_board_labels_group_id_spec.rb": 6.271335614000236
2166}
2167Knapsack global time execution for tests: 20m 04s
2168Finished in 32 minutes 23 seconds (files took 57.61 seconds to load)
216924 examples, 0 failures
2170Randomized with seed 62848
2171[TEST PROF INFO] Time spent in factories: 00:00.318 (0.02% of total time)
2172RSpec exited with 0.
2173No examples to retry, congrats!
2174 Running after_script 00:07
2175Running after script...
2176$ source scripts/utils.sh
2177$ bundle exec gem list gitlab_quality-test_tooling
2178gitlab_quality-test_tooling (1.26.0)
2179$ section_start "failed-test-issues" "Report test failures" # collapsed multi-line command
2180 Report test failures 00:00
2182$ section_start "flaky-test-issues" "Report test flakiness" # collapsed multi-line command
2183Not reporting test flakiness because $CREATE_RAILS_FLAKY_TEST_ISSUES != 'true'
2184 Report test flakiness 00:00
2185$ section_start "slow-test-issues" "Report test slowness" # collapsed multi-line command
2186 Report test slowness 00:00
2188$ section_start "slow-test-merge-request-report-note" "Report test slowness in MR note" # collapsed multi-line command
2189 Report test slowness in MR note 00:02
2192$ section_start "knapsack-report-issues" "Report test files close to timing out" # collapsed multi-line command
2193 Report test files close to timing out 00:02
2196$ tooling/bin/push_job_metrics || true
2197[job-metrics] Pushing job metrics file for the CI/CD job.
2198[job-metrics] Pushed 4 CI job metric entries to InfluxDB.
2199 Saving cache for successful job 00:01
2200Not uploading cache ruby-gems-debian-bookworm-ruby-3.2-17 due to policy
2201 Uploading artifacts for successful job 00:05
2202Uploading artifacts...
2203auto_explain/: found 2 matching artifact files and directories
2204coverage/: found 5 matching artifact files and directories
2205crystalball/: found 2 matching artifact files and directories
2206WARNING: deprecations/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab)
2207knapsack/: found 4 matching artifact files and directories
2208rspec/: found 16 matching artifact files and directories
2209WARNING: tmp/capybara/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab)
2210log/*.log: found 13 matching artifact files and directories
2211WARNING: Upload request redirected location=https://gitlab.com/api/v4/jobs/6975007409/artifacts?artifact_format=zip&artifact_type=archive&expire_in=31d new-url=https://gitlab.com
2212WARNING: Retrying... context=artifacts-uploader error=request redirected
2213Uploading artifacts as "archive" to coordinator... 201 Created id=6975007409 responseStatus=201 Created token=glcbt-65
2214Uploading artifacts...
2215rspec/rspec-*.xml: found 1 matching artifact files and directories
2216WARNING: Upload request redirected location=https://gitlab.com/api/v4/jobs/6975007409/artifacts?artifact_format=gzip&artifact_type=junit&expire_in=31d new-url=https://gitlab.com
2217WARNING: Retrying... context=artifacts-uploader error=request redirected
2218Uploading artifacts as "junit" to coordinator... 201 Created id=6975007409 responseStatus=201 Created token=glcbt-65
2219 Cleaning up project directory and file based variables 00:00
2220Job succeeded