Skip to content
Snippets Groups Projects

rspec migration pg14 no_gitaly_transactions 6/26

Passed Started by
🤖 GitLab Bot 🤖
@gitlab-bot
1Running with gitlab-runner 17.0.0~pre.88.g761ae5dd (761ae5dd)
2 on green-1.private.runners-manager.gitlab.com/gitlab.com/gitlab-org 4bq1s9yM, system ID: s_9d15f3e4e7ae
3 feature flags: FF_NETWORK_PER_BUILD:true
4Resolving secrets
5 Preparing the "docker+machine" executor 00:07
6Using Docker executor with image registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bookworm-ruby-3.1.5-golang-1.22-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:36c1d3cfe18f4b12d4640576f7048068acbfc3625027b6bbb46bba0e31b11831 for redis:6.2-alpine with digest redis@sha256:e3b17ba9479deec4b7d1eeec1548a253acc5374d68d3b27937fcfe4df8d18c7e ...
20Waiting for services to be up and running (timeout 30 seconds)...
21Authenticating with credentials from job payload (GitLab Registry)
22Pulling docker image registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bookworm-ruby-3.1.5-golang-1.22-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:b26253b493531cada33f45ef568f38c50a310442d05c39f517656e0f7d305dc7 for registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bookworm-ruby-3.1.5-golang-1.22-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.1.5-golang-1.22-rust-1.73-node-20.12-postgresql-14@sha256:543339542a02edc250c2c0424c5077b673f1fca2877024fdc5fb670eff44f8cf ...
24 Preparing environment 00:01
25Running on runner-4bq1s9ym-project-278964-concurrent-0 via runner-4bq1s9ym-private-1722411511-4b57d4df...
26 Getting source from Git repository 00:00
27Skipping Git repository setup
28Skipping Git checkout
29Skipping Git submodules setup
30 Restoring cache 00:18
31Checking cache for ruby-gems-debian-bookworm-ruby-3.1.5-17...
32Downloading cache from https://storage.googleapis.com/gitlab-com-runners-cache/project/278964/ruby-gems-debian-bookworm-ruby-3.1.5-17
33Successfully extracted cache
34 Downloading artifacts 00:38
35Downloading artifacts for clone-gitlab-repo (7471344368)...
36Downloading artifacts from coordinator... ok host=storage.googleapis.com id=7471344368 responseStatus=200 OK token=glcbt-66
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 (7471344747)...
40Downloading artifacts from coordinator... ok host=storage.googleapis.com id=7471344747 responseStatus=200 OK token=glcbt-66
41Downloading artifacts for retrieve-tests-metadata (7471344898)...
42Downloading artifacts from coordinator... ok host=storage.googleapis.com id=7471344898 responseStatus=200 OK token=glcbt-66
43Downloading artifacts for setup-test-env (7471344810)...
44Downloading artifacts from coordinator... ok host=storage.googleapis.com id=7471344810 responseStatus=200 OK token=glcbt-66
45 Executing "step_script" stage of the job script
46Using docker image sha256:b26253b493531cada33f45ef568f38c50a310442d05c39f517656e0f7d305dc7 for registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bookworm-ruby-3.1.5-golang-1.22-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.1.5-golang-1.22-rust-1.73-node-20.12-postgresql-14@sha256:543339542a02edc250c2c0424c5077b673f1fca2877024fdc5fb670eff44f8cf ...
47$ echo $FOSS_ONLY
48$ [ "$FOSS_ONLY" = "1" ] && rm -rf ee/ qa/spec/ee/ qa/qa/specs/features/ee/ qa/qa/ee/ qa/qa/ee.rb
49$ export GOPATH=$CI_PROJECT_DIR/.go
50$ mkdir -p $GOPATH
51$ source scripts/utils.sh
52$ source scripts/prepare_build.sh
53 Installing gems 00:18
82Using decomposed database config (config/database.yml.decomposed-postgresql)
83Geo DB won't be set up.
84Embedding DB won't be set up.
85 Setting up DBs 01:05
96$ source ./scripts/rspec_helpers.sh
97$ run_timed_command "gem install knapsack --no-document"
98$ gem install knapsack --no-document
99Successfully installed knapsack-4.0.0
1001 gem installed
101$ section_start "gitaly-test-spawn" "Spawning Gitaly"; scripts/gitaly-test-spawn; section_end "gitaly-test-spawn"
102==> 'gem install knapsack --no-document' succeeded in 1 seconds.
103 Spawning Gitaly 00:04
107$ export RSPEC_SKIPPED_TESTS_REPORT_PATH="rspec/skipped_tests-${CI_JOB_ID}.txt"
108$ export RSPEC_RETRIED_TESTS_REPORT_PATH="rspec/retried_tests-${CI_JOB_ID}.txt"
109$ tooling/bin/create_job_metrics_file || true
110[job-metrics] Creating the job metrics file for the CI/CD job.
111$ rspec_section rspec_parallelized_job "--fail-fast=${RSPEC_FAIL_FAST_THRESHOLD} --tag ~quarantine --tag ~zoekt --tag ~click_house"
112 RSpec 22:27
113[10:14:26] Starting rspec_parallelized_job
114RETRY_FAILED_TESTS_IN_NEW_PROCESS: true
115KNAPSACK_GENERATE_REPORT: true
116FLAKY_RSPEC_GENERATE_REPORT: true
117KNAPSACK_TEST_FILE_PATTERN: spec/{migrations}{,/**/}*_spec.rb
118KNAPSACK_LOG_LEVEL: debug
119KNAPSACK_REPORT_PATH: knapsack/rspec_migration_pg14_no_gitaly_transactions_6_26_278964_report.json
120FLAKY_RSPEC_SUITE_REPORT_PATH: rspec/flaky/report-suite.json
121FLAKY_RSPEC_REPORT_PATH: rspec/flaky/all_rspec_migration_pg14_no_gitaly_transactions_6_26_278964_report.json
122NEW_FLAKY_RSPEC_REPORT_PATH: rspec/flaky/new_rspec_migration_pg14_no_gitaly_transactions_6_26_278964_report.json
123RSPEC_SKIPPED_TESTS_REPORT_PATH: rspec/skipped_tests-7471346370.txt
124CRYSTALBALL: true
125RSPEC_TESTS_MAPPING_ENABLED:
126RSPEC_TESTS_FILTER_FILE:
127Shell set options (set -o) enabled:
128braceexpand on
129hashall on
130interactive-comments on
131pipefail on
132Knapsack report generator started!
133warning: parser/current is loading parser/ruby31, which recognizes 3.1.6-compliant syntax, but you are running 3.1.5.
134Please see https://github.com/whitequark/parser#compatibility-with-ruby-mri.
135Run options: exclude {:quarantine=>true, :zoekt=>true, :click_house=>true}
136# [RSpecRunTime] Starting RSpec timer...
137[TEST PROF INFO] EventProf enabled (sql.active_record)
138unknown OID 2249: failed to recognize type of 'pg_stat_file'. It will be treated as String.
139unknown OID 2249: failed to recognize type of 'pg_stat_file'. It will be treated as String.
140Test environment set up in 1.498343811 seconds
141# [RSpecRunTime] Starting example group spec/migrations/20230801150214_retry_cleanup_bigint_conversion_for_events_for_gitlab_com_spec.rb. Expected to take 2 minutes 53.61 seconds.
142RetryCleanupBigintConversionForEventsForGitlabCom
143 #up
144 when column still exists
145 when is GitLab.com, dev, or test
146 drop the temporary columns
147 when is a self-managed instance
148 behaves like skips the up migration
149 doesn't calls cleanup_conversion_of_integer_to_bigint method
150# [RSpecRunTime] RSpec elapsed time: 1 minute 54.26 seconds. Current RSS: ~1458M. Threads: 2. load average: 1.21 1.02 1.04 1/273 401
151.
152 when column not exists
153 when is GitLab.com, dev, or test
154 behaves like skips the up migration
155 doesn't calls cleanup_conversion_of_integer_to_bigint method
156# [RSpecRunTime] RSpec elapsed time: 2 minutes 6.51 seconds. Current RSS: ~1473M. Threads: 2. load average: 1.24 1.04 1.04 1/273 402
157.
158 when is a self-managed instance
159 behaves like skips the up migration
160 doesn't calls cleanup_conversion_of_integer_to_bigint method
161# [RSpecRunTime] RSpec elapsed time: 2 minutes 17.39 seconds. Current RSS: ~1480M. Threads: 2. load average: 1.20 1.04 1.04 1/273 403
162.
163 #down
164 when column still exists
165 when is GitLab.com, dev, or test
166 behaves like skips the down migration
167 doesn't calls restore_conversion_of_integer_to_bigint method
168# [RSpecRunTime] RSpec elapsed time: 2 minutes 28.33 seconds. Current RSS: ~1463M. Threads: 2. load average: 1.17 1.04 1.04 1/275 405
169.
170 when is a self-managed instance
171 behaves like skips the down migration
172 doesn't calls restore_conversion_of_integer_to_bigint method
173# [RSpecRunTime] RSpec elapsed time: 2 minutes 40.55 seconds. Current RSS: ~1488M. Threads: 2. load average: 1.29 1.07 1.05 1/275 406
174.
175 when column not exists
176 when is GitLab.com, dev, or test
177 restore the temporary columns
178# [RSpecRunTime] RSpec elapsed time: 2 minutes 51.87 seconds. Current RSS: ~1490M. Threads: 2. load average: 1.25 1.06 1.05 1/275 407
179.
180 when is a self-managed instance
181 behaves like skips the down migration
182 doesn't calls restore_conversion_of_integer_to_bigint method
183# [RSpecRunTime] RSpec elapsed time: 3 minutes 2.66 seconds. Current RSS: ~1483M. Threads: 2. load average: 1.29 1.08 1.05 1/275 408
184.
185INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
186INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
187INFO: "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
188INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_101"
189INFO: "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
190INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_102"
191INFO: "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
192INFO: analyzing "public.p_ci_job_annotations" inheritance tree
193INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
194INFO: "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
195INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_101"
196INFO: "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
197INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_102"
198INFO: "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
199INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
200INFO: analyzing "public.ci_builds_metadata"
201INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
202INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_101"
203INFO: "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
204INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_102"
205INFO: "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
206INFO: analyzing "public.p_ci_builds" inheritance tree
207INFO: analyzing "public.ci_builds"
208INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
209INFO: analyzing "gitlab_partitions_dynamic.ci_builds_101"
210INFO: "ci_builds_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
211INFO: analyzing "gitlab_partitions_dynamic.ci_builds_102"
212INFO: "ci_builds_102": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
213I, [2024-07-31T10:19:13.330353 #324] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes
214I, [2024-07-31T10:19:33.163490 #324] INFO -- : Database: 'main', Table: 'ci_job_token_group_scope_links': Lock Writes
215INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
216INFO: analyzing "public.ci_pipeline_variables"
217INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
218I, [2024-07-31T10:19:34.791760 #324] INFO -- : Database: 'main', Table: 'p_ci_pipeline_variables': Lock Writes
219I, [2024-07-31T10:19:34.793561 #324] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
220I, [2024-07-31T10:19:34.794512 #324] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
221INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
222INFO: analyzing "public.ci_pipeline_variables"
223INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
224INFO: analyzing "public.p_ci_job_artifacts" inheritance tree
225INFO: analyzing "public.ci_job_artifacts"
226INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
227I, [2024-07-31T10:19:40.788387 #324] INFO -- : Database: 'main', Table: 'p_ci_job_artifacts': Lock Writes
228I, [2024-07-31T10:19:40.789580 #324] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
229I, [2024-07-31T10:19:40.790458 #324] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
230INFO: analyzing "public.p_ci_stages" inheritance tree
231INFO: analyzing "public.ci_stages"
232INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
233I, [2024-07-31T10:19:44.154453 #324] INFO -- : Database: 'main', Table: 'p_ci_stages': Lock Writes
234I, [2024-07-31T10:19:44.155598 #324] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
235I, [2024-07-31T10:19:44.156868 #324] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
236I, [2024-07-31T10:19:45.333219 #324] INFO -- : Database: 'main', Table: 'p_ci_build_names': Lock Writes
237I, [2024-07-31T10:19:51.674884 #324] INFO -- : Database: 'main', Table: 'p_ci_builds_execution_configs': Lock Writes
238I, [2024-07-31T10:20:05.596733 #324] INFO -- : Database: 'main', Table: 'p_ci_build_sources': Lock Writes
239I, [2024-07-31T10:20:05.598522 #324] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
240I, [2024-07-31T10:20:05.599721 #324] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
241I, [2024-07-31T10:20:17.224907 #324] INFO -- : Database: 'main', Table: 'p_ci_finished_pipeline_ch_sync_events': Lock Writes
242I, [2024-07-31T10:20:24.098157 #324] INFO -- : Database: 'main', Table: 'p_ci_build_tags': Lock Writes
243# [RSpecRunTime] Finishing example group spec/migrations/20230801150214_retry_cleanup_bigint_conversion_for_events_for_gitlab_com_spec.rb. It took 4 minutes 27.52 seconds. Expected to take 2 minutes 53.61 seconds.
244# [RSpecRunTime] RSpec elapsed time: 4 minutes 32.08 seconds. Current RSS: ~1383M. Threads: 2. load average: 1.06 1.05 1.05 1/274 409
245.
246# [RSpecRunTime] Starting example group spec/migrations/20230810124545_schedule_fixing_namespace_ids_of_vulnerability_reads_spec.rb. Expected to take 1 minute 42.63 seconds.
247ScheduleFixingNamespaceIdsOfVulnerabilityReads
248main: == [advisory_lock_connection] object_id: 63902440, pg_backend_pid: 182
249main: == 20230810124545 ScheduleFixingNamespaceIdsOfVulnerabilityReads: migrating ===
250main: == 20230810124545 ScheduleFixingNamespaceIdsOfVulnerabilityReads: migrated (0.0624s)
251main: == [advisory_lock_connection] object_id: 63902440, pg_backend_pid: 182
252 schedules a new batched migration
253INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
254INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
255INFO: "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
256INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_101"
257INFO: "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
258INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_102"
259INFO: "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
260INFO: analyzing "public.p_ci_job_annotations" inheritance tree
261INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
262INFO: "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
263INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_101"
264INFO: "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
265INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_102"
266INFO: "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
267INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
268INFO: analyzing "public.ci_builds_metadata"
269INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
270INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_101"
271INFO: "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
272INFO: analyzing "gitlab_partitions_dynamic.ci_builds_metadata_102"
273INFO: "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
274INFO: analyzing "public.p_ci_builds" inheritance tree
275INFO: analyzing "public.ci_builds"
276INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
277INFO: analyzing "gitlab_partitions_dynamic.ci_builds_101"
278INFO: "ci_builds_101": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
279INFO: analyzing "gitlab_partitions_dynamic.ci_builds_102"
280INFO: "ci_builds_102": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
281I, [2024-07-31T10:22:05.748253 #324] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes
282I, [2024-07-31T10:22:25.450688 #324] INFO -- : Database: 'main', Table: 'ci_job_token_group_scope_links': Lock Writes
283INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
284INFO: analyzing "public.ci_pipeline_variables"
285INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
286I, [2024-07-31T10:22:27.174963 #324] INFO -- : Database: 'main', Table: 'p_ci_pipeline_variables': Lock Writes
287I, [2024-07-31T10:22:27.176162 #324] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
288I, [2024-07-31T10:22:27.176992 #324] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
289INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
290INFO: analyzing "public.ci_pipeline_variables"
291INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
292INFO: analyzing "public.p_ci_job_artifacts" inheritance tree
293INFO: analyzing "public.ci_job_artifacts"
294INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
295I, [2024-07-31T10:22:33.078707 #324] INFO -- : Database: 'main', Table: 'p_ci_job_artifacts': Lock Writes
296I, [2024-07-31T10:22:33.080089 #324] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
297I, [2024-07-31T10:22:33.080961 #324] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
298INFO: analyzing "public.p_ci_stages" inheritance tree
299INFO: analyzing "public.ci_stages"
300INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
301I, [2024-07-31T10:22:36.448565 #324] INFO -- : Database: 'main', Table: 'p_ci_stages': Lock Writes
302I, [2024-07-31T10:22:36.449660 #324] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
303I, [2024-07-31T10:22:36.450444 #324] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
304I, [2024-07-31T10:22:37.679663 #324] INFO -- : Database: 'main', Table: 'p_ci_build_names': Lock Writes
305I, [2024-07-31T10:22:44.153454 #324] INFO -- : Database: 'main', Table: 'p_ci_builds_execution_configs': Lock Writes
306I, [2024-07-31T10:22:57.679197 #324] INFO -- : Database: 'main', Table: 'p_ci_build_sources': Lock Writes
307I, [2024-07-31T10:22:57.680290 #324] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
308I, [2024-07-31T10:22:57.681029 #324] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
309I, [2024-07-31T10:23:09.497736 #324] INFO -- : Database: 'main', Table: 'p_ci_finished_pipeline_ch_sync_events': Lock Writes
310I, [2024-07-31T10:23:16.133770 #324] INFO -- : Database: 'main', Table: 'p_ci_build_tags': Lock Writes
311# [RSpecRunTime] Finishing example group spec/migrations/20230810124545_schedule_fixing_namespace_ids_of_vulnerability_reads_spec.rb. It took 2 minutes 52.0 seconds. Expected to take 1 minute 42.63 seconds.
312# [RSpecRunTime] RSpec elapsed time: 7 minutes 24.13 seconds. Current RSS: ~1368M. Threads: 2. load average: 0.77 1.01 1.03 1/276 410
313.
314# [RSpecRunTime] Starting example group spec/migrations/20240116211138_update_max_code_indexing_concurrency_in_application_settings_for_gitlab_com_spec.rb. Expected to take 1 minute 33.31 seconds.
315UpdateMaxCodeIndexingConcurrencyInApplicationSettingsForGitlabCom
316 #down
317main: == [advisory_lock_connection] object_id: 100259340, pg_backend_pid: 199
318main: == 20240116211138 UpdateMaxCodeIndexingConcurrencyInApplicationSettingsForGitlabCom: migrating
319main: == 20240116211138 UpdateMaxCodeIndexingConcurrencyInApplicationSettingsForGitlabCom: migrated (0.0095s)
320main: == [advisory_lock_connection] object_id: 100259340, pg_backend_pid: 199
321 does nothing when not in gitlab.com
322main: == [advisory_lock_connection] object_id: 101201860, pg_backend_pid: 203
323main: == 20240116211138 UpdateMaxCodeIndexingConcurrencyInApplicationSettingsForGitlabCom: migrating
324main: -- execute("UPDATE application_settings SET elasticsearch_max_code_indexing_concurrency = 60")
325main: -> 0.0035s
326main: == 20240116211138 UpdateMaxCodeIndexingConcurrencyInApplicationSettingsForGitlabCom: migrated (0.0131s)
327main: == [advisory_lock_connection] object_id: 101201860, pg_backend_pid: 203
328 updates elasticsearch_worker_number_of_shards when gitlab.com
329# [RSpecRunTime] RSpec elapsed time: 8 minutes 34.31 seconds. Current RSS: ~1405M. Threads: 2. load average: 0.90 0.99 1.02 1/276 411
330.
331 #up
332main: == [advisory_lock_connection] object_id: 102088480, pg_backend_pid: 206
333main: == 20240116211138 UpdateMaxCodeIndexingConcurrencyInApplicationSettingsForGitlabCom: migrating
334main: == 20240116211138 UpdateMaxCodeIndexingConcurrencyInApplicationSettingsForGitlabCom: migrated (0.0075s)
335main: == [advisory_lock_connection] object_id: 102088480, pg_backend_pid: 206
336 does nothing when not in gitlab.com
337main: == [advisory_lock_connection] object_id: 102678900, pg_backend_pid: 209
338main: == 20240116211138 UpdateMaxCodeIndexingConcurrencyInApplicationSettingsForGitlabCom: migrating
339main: -- execute("UPDATE application_settings SET elasticsearch_max_code_indexing_concurrency = 60")
340main: -> 0.0034s
341main: == 20240116211138 UpdateMaxCodeIndexingConcurrencyInApplicationSettingsForGitlabCom: migrated (0.0124s)
342main: == [advisory_lock_connection] object_id: 102678900, pg_backend_pid: 209
343 updates elasticsearch_worker_number_of_shards when gitlab.com
344# [RSpecRunTime] RSpec elapsed time: 8 minutes 47.63 seconds. Current RSS: ~1438M. Threads: 2. load average: 1.00 1.01 1.02 1/276 412
345.
346I, [2024-07-31T10:24:51.046895 #324] INFO -- : Database: 'main', Table: 'ci_job_token_group_scope_links': Lock Writes
347INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
348INFO: analyzing "public.ci_pipeline_variables"
349INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
350I, [2024-07-31T10:24:52.750807 #324] INFO -- : Database: 'main', Table: 'p_ci_pipeline_variables': Lock Writes
351I, [2024-07-31T10:24:52.752029 #324] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
352I, [2024-07-31T10:24:52.752848 #324] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
353INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
354INFO: analyzing "public.ci_pipeline_variables"
355INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
356INFO: analyzing "public.p_ci_job_artifacts" inheritance tree
357INFO: analyzing "public.ci_job_artifacts"
358INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
359I, [2024-07-31T10:24:58.912251 #324] INFO -- : Database: 'main', Table: 'p_ci_job_artifacts': Lock Writes
360I, [2024-07-31T10:24:58.913643 #324] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
361I, [2024-07-31T10:24:58.914464 #324] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
362INFO: analyzing "public.p_ci_stages" inheritance tree
363INFO: analyzing "public.ci_stages"
364INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
365I, [2024-07-31T10:25:02.390591 #324] INFO -- : Database: 'main', Table: 'p_ci_stages': Lock Writes
366I, [2024-07-31T10:25:02.391640 #324] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
367I, [2024-07-31T10:25:02.392424 #324] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
368I, [2024-07-31T10:25:03.706309 #324] INFO -- : Database: 'main', Table: 'p_ci_build_names': Lock Writes
369I, [2024-07-31T10:25:09.800499 #324] INFO -- : Database: 'main', Table: 'p_ci_builds_execution_configs': Lock Writes
370I, [2024-07-31T10:25:23.165913 #324] INFO -- : Database: 'main', Table: 'p_ci_build_sources': Lock Writes
371I, [2024-07-31T10:25:23.166957 #324] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
372I, [2024-07-31T10:25:23.168176 #324] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
373I, [2024-07-31T10:25:34.255460 #324] INFO -- : Database: 'main', Table: 'p_ci_finished_pipeline_ch_sync_events': Lock Writes
374I, [2024-07-31T10:25:40.801197 #324] INFO -- : Database: 'main', Table: 'p_ci_build_tags': Lock Writes
375# [RSpecRunTime] Finishing example group spec/migrations/20240116211138_update_max_code_indexing_concurrency_in_application_settings_for_gitlab_com_spec.rb. It took 2 minutes 24.4 seconds. Expected to take 1 minute 33.31 seconds.
376# [RSpecRunTime] RSpec elapsed time: 9 minutes 48.58 seconds. Current RSS: ~1367M. Threads: 2. load average: 0.86 0.97 1.01 1/276 413
377.
378# [RSpecRunTime] Starting example group spec/migrations/20231107092912_queue_backfill_branch_protection_namespace_setting_spec.rb. Expected to take 1 minute 15.37 seconds.
379QueueBackfillBranchProtectionNamespaceSetting
380main: == [advisory_lock_connection] object_id: 135128600, pg_backend_pid: 224
381main: == 20231107092912 QueueBackfillBranchProtectionNamespaceSetting: migrating ====
382main: == 20231107092912 QueueBackfillBranchProtectionNamespaceSetting: migrated (0.0551s)
383main: == [advisory_lock_connection] object_id: 135128600, pg_backend_pid: 224
384 schedules a new batched migration
385I, [2024-07-31T10:27:10.808459 #324] INFO -- : Database: 'main', Table: 'ci_job_token_group_scope_links': Lock Writes
386INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
387INFO: analyzing "public.ci_pipeline_variables"
388INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
389I, [2024-07-31T10:27:12.514759 #324] INFO -- : Database: 'main', Table: 'p_ci_pipeline_variables': Lock Writes
390I, [2024-07-31T10:27:12.515886 #324] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
391I, [2024-07-31T10:27:12.516624 #324] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
392INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
393INFO: analyzing "public.ci_pipeline_variables"
394INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
395INFO: analyzing "public.p_ci_job_artifacts" inheritance tree
396INFO: analyzing "public.ci_job_artifacts"
397INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
398I, [2024-07-31T10:27:18.408696 #324] INFO -- : Database: 'main', Table: 'p_ci_job_artifacts': Lock Writes
399I, [2024-07-31T10:27:18.409781 #324] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
400I, [2024-07-31T10:27:18.410548 #324] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
401INFO: analyzing "public.p_ci_stages" inheritance tree
402INFO: analyzing "public.ci_stages"
403INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
404I, [2024-07-31T10:27:21.894390 #324] INFO -- : Database: 'main', Table: 'p_ci_stages': Lock Writes
405I, [2024-07-31T10:27:21.895559 #324] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
406I, [2024-07-31T10:27:21.896373 #324] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
407I, [2024-07-31T10:27:23.047338 #324] INFO -- : Database: 'main', Table: 'p_ci_build_names': Lock Writes
408I, [2024-07-31T10:27:28.997388 #324] INFO -- : Database: 'main', Table: 'p_ci_builds_execution_configs': Lock Writes
409I, [2024-07-31T10:27:41.893011 #324] INFO -- : Database: 'main', Table: 'p_ci_build_sources': Lock Writes
410I, [2024-07-31T10:27:41.894179 #324] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
411I, [2024-07-31T10:27:41.894952 #324] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
412I, [2024-07-31T10:27:53.109839 #324] INFO -- : Database: 'main', Table: 'p_ci_finished_pipeline_ch_sync_events': Lock Writes
413I, [2024-07-31T10:27:59.502787 #324] INFO -- : Database: 'main', Table: 'p_ci_build_tags': Lock Writes
414# [RSpecRunTime] Finishing example group spec/migrations/20231107092912_queue_backfill_branch_protection_namespace_setting_spec.rb. It took 2 minutes 18.87 seconds. Expected to take 1 minute 15.37 seconds.
415# [RSpecRunTime] RSpec elapsed time: 12 minutes 7.5 seconds. Current RSS: ~1365M. Threads: 2. load average: 1.00 1.00 1.00 1/276 414
416.
417# [RSpecRunTime] Starting example group spec/migrations/swap_columns_for_system_note_metadata_id_spec.rb. Expected to take 1 minute 3.55 seconds.
418SwapColumnsForSystemNoteMetadataId
419 #up
420 swaps the integer and bigint columns with correct constraint names
421# [RSpecRunTime] RSpec elapsed time: 13 minutes 4.57 seconds. Current RSS: ~1370M. Threads: 2. load average: 0.93 0.98 1.00 1/276 415
422.
423INFO: analyzing "public.p_ci_pipeline_variables" inheritance tree
424INFO: analyzing "public.ci_pipeline_variables"
425INFO: "ci_pipeline_variables": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
426INFO: analyzing "public.p_ci_job_artifacts" inheritance tree
427INFO: analyzing "public.ci_job_artifacts"
428INFO: "ci_job_artifacts": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
429I, [2024-07-31T10:29:13.560641 #324] INFO -- : Database: 'main', Table: 'p_ci_job_artifacts': Lock Writes
430I, [2024-07-31T10:29:13.561779 #324] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
431I, [2024-07-31T10:29:13.562606 #324] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
432INFO: analyzing "public.p_ci_stages" inheritance tree
433INFO: analyzing "public.ci_stages"
434INFO: "ci_stages": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
435I, [2024-07-31T10:29:17.072331 #324] INFO -- : Database: 'main', Table: 'p_ci_stages': Lock Writes
436I, [2024-07-31T10:29:17.073839 #324] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
437I, [2024-07-31T10:29:17.074710 #324] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
438I, [2024-07-31T10:29:18.191025 #324] INFO -- : Database: 'main', Table: 'p_ci_build_names': Lock Writes
439I, [2024-07-31T10:29:24.488723 #324] INFO -- : Database: 'main', Table: 'p_ci_builds_execution_configs': Lock Writes
440I, [2024-07-31T10:29:38.157219 #324] INFO -- : Database: 'main', Table: 'p_ci_build_sources': Lock Writes
441I, [2024-07-31T10:29:38.158625 #324] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
442I, [2024-07-31T10:29:38.159393 #324] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
443I, [2024-07-31T10:29:49.138551 #324] INFO -- : Database: 'main', Table: 'p_ci_finished_pipeline_ch_sync_events': Lock Writes
444I, [2024-07-31T10:29:55.419133 #324] INFO -- : Database: 'main', Table: 'p_ci_build_tags': Lock Writes
445# [RSpecRunTime] Finishing example group spec/migrations/swap_columns_for_system_note_metadata_id_spec.rb. It took 1 minute 56.05 seconds. Expected to take 1 minute 3.55 seconds.
446# [RSpecRunTime] RSpec elapsed time: 14 minutes 3.6 seconds. Current RSS: ~1337M. Threads: 2. load average: 0.89 0.96 0.99 1/276 416
447.
448# [RSpecRunTime] Starting example group spec/migrations/db/post_migrate/20240423235307_swap_columns_for_p_ci_builds_project_id_spec.rb. Expected to take 50.8 seconds.
449SwapColumnsForPCiBuildsProjectId
450 behaves like swap conversion columns
451main: == [advisory_lock_connection] object_id: 191133640, pg_backend_pid: 255
452main: == 20240423235307 SwapColumnsForPCiBuildsProjectId: migrating =================
453main: -- index_name_exists?(:p_ci_builds, :p_ci_builds_project_id_id_idx)
454main: -> 0.0026s
455main: -- quote_table_name(:p_ci_builds)
456main: -> 0.0000s
457main: -- execute("LOCK TABLE \"p_ci_builds\" IN ACCESS EXCLUSIVE MODE")
458main: -> 0.0012s
459main: -- clear_cache!(nil)
460main: -> 0.0000s
461main: -- quote_table_name(:p_ci_builds)
462main: -> 0.0000s
463main: -- quote_column_name(:project_id_convert_to_bigint)
464main: -> 0.0000s
465main: -- quote_column_name(:temp_name_for_renaming)
466main: -> 0.0000s
467main: -- execute("ALTER TABLE \"p_ci_builds\"\n RENAME COLUMN \"project_id_convert_to_bigint\" TO \"temp_name_for_renaming\"\n")
468main: -> 0.0015s
469main: -- clear_cache!(nil)
470main: -> 0.0000s
471main: -- quote_table_name(:p_ci_builds)
472main: -> 0.0000s
473main: -- quote_column_name(:project_id)
474main: -> 0.0000s
475main: -- quote_column_name(:project_id_convert_to_bigint)
476main: -> 0.0000s
477main: -- execute("ALTER TABLE \"p_ci_builds\"\n RENAME COLUMN \"project_id\" TO \"project_id_convert_to_bigint\"\n")
478main: -> 0.0015s
479main: -- clear_cache!(nil)
480main: -> 0.0000s
481main: -- quote_table_name(:p_ci_builds)
482main: -> 0.0000s
483main: -- quote_column_name(:temp_name_for_renaming)
484main: -> 0.0000s
485main: -- quote_column_name(:project_id)
486main: -> 0.0000s
487main: -- execute("ALTER TABLE \"p_ci_builds\"\n RENAME COLUMN \"temp_name_for_renaming\" TO \"project_id\"\n")
488main: -> 0.0012s
489main: -- quote_table_name(:trigger_10ee1357e825)
490main: -> 0.0000s
491main: -- execute("ALTER FUNCTION \"trigger_10ee1357e825\" RESET ALL")
492main: -> 0.0009s
493main: -- indexes("p_ci_builds")
494main: -> 0.0428s
495main: -- indexes("p_ci_builds")
496main: -> 0.0429s
497main: -- indexes("public.ci_builds")
498main: -> 0.0418s
499main: -- indexes("public.ci_builds")
500main: -> 0.0440s
501main: -- quote_table_name("public.index_3591adffe4")
502main: -> 0.0000s
503main: -- quote_table_name("temp_1bdabdb3ec")
504main: -> 0.0000s
505main: -- execute("ALTER INDEX \"public\".\"index_3591adffe4\" RENAME TO \"temp_1bdabdb3ec\"")
506main: -> 0.0016s
507main: -- quote_table_name("public.index_ci_builds_on_project_id_and_id")
508main: -> 0.0000s
509main: -- quote_table_name("index_3591adffe4")
510main: -> 0.0000s
511main: -- execute("ALTER INDEX \"public\".\"index_ci_builds_on_project_id_and_id\" RENAME TO \"index_3591adffe4\"")
512main: -> 0.0011s
513main: -- quote_table_name("public.temp_1bdabdb3ec")
514main: -> 0.0000s
515main: -- quote_table_name("index_ci_builds_on_project_id_and_id")
516main: -> 0.0000s
517main: -- execute("ALTER INDEX \"public\".\"temp_1bdabdb3ec\" RENAME TO \"index_ci_builds_on_project_id_and_id\"")
518main: -> 0.0010s
519main: -- indexes("gitlab_partitions_dynamic.ci_builds_101")
520main: -> 0.0397s
521main: -- indexes("gitlab_partitions_dynamic.ci_builds_101")
522main: -> 0.0404s
523main: -- quote_table_name("gitlab_partitions_dynamic.index_10eae1e8cf")
524main: -> 0.0000s
525main: -- quote_table_name("temp_a321ab91cd")
526main: -> 0.0001s
527main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"index_10eae1e8cf\" RENAME TO \"temp_a321ab91cd\"")
528main: -> 0.0016s
529main: -- quote_table_name("gitlab_partitions_dynamic.ci_builds_101_project_id_id_idx")
530main: -> 0.0000s
531main: -- quote_table_name("index_10eae1e8cf")
532main: -> 0.0000s
533main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"ci_builds_101_project_id_id_idx\" RENAME TO \"index_10eae1e8cf\"")
534main: -> 0.0011s
535main: -- quote_table_name("gitlab_partitions_dynamic.temp_a321ab91cd")
536main: -> 0.0000s
537main: -- quote_table_name("ci_builds_101_project_id_id_idx")
538main: -> 0.0000s
539main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"temp_a321ab91cd\" RENAME TO \"ci_builds_101_project_id_id_idx\"")
540main: -> 0.0011s
541main: -- indexes("gitlab_partitions_dynamic.ci_builds_102")
542main: -> 0.0420s
543main: -- indexes("gitlab_partitions_dynamic.ci_builds_102")
544main: -> 0.0412s
545main: -- quote_table_name("gitlab_partitions_dynamic.index_214b33570d")
546main: -> 0.0000s
547main: -- quote_table_name("temp_48a0b416de")
548main: -> 0.0000s
549main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"index_214b33570d\" RENAME TO \"temp_48a0b416de\"")
550main: -> 0.0012s
551main: -- quote_table_name("gitlab_partitions_dynamic.ci_builds_102_project_id_id_idx")
552main: -> 0.0000s
553main: -- quote_table_name("index_214b33570d")
554main: -> 0.0000s
555main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"ci_builds_102_project_id_id_idx\" RENAME TO \"index_214b33570d\"")
556main: -> 0.0012s
557main: -- quote_table_name("gitlab_partitions_dynamic.temp_48a0b416de")
558main: -> 0.0000s
559main: -- quote_table_name("ci_builds_102_project_id_id_idx")
560main: -> 0.0000s
561main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"temp_48a0b416de\" RENAME TO \"ci_builds_102_project_id_id_idx\"")
562main: -> 0.0010s
563main: -- quote_table_name("p_ci_builds_project_id_bigint_id_idx")
564main: -> 0.0000s
565main: -- quote_table_name("temp_f2c2fe031f")
566main: -> 0.0000s
567main: -- execute("ALTER INDEX \"p_ci_builds_project_id_bigint_id_idx\" RENAME TO \"temp_f2c2fe031f\"")
568main: -> 0.0010s
569main: -- quote_table_name("p_ci_builds_project_id_id_idx")
570main: -> 0.0000s
571main: -- quote_table_name(:p_ci_builds_project_id_bigint_id_idx)
572main: -> 0.0000s
573main: -- execute("ALTER INDEX \"p_ci_builds_project_id_id_idx\" RENAME TO \"p_ci_builds_project_id_bigint_id_idx\"")
574main: -> 0.0010s
575main: -- quote_table_name("temp_f2c2fe031f")
576main: -> 0.0001s
577main: -- quote_table_name(:p_ci_builds_project_id_id_idx)
578main: -> 0.0000s
579main: -- execute("ALTER INDEX \"temp_f2c2fe031f\" RENAME TO \"p_ci_builds_project_id_id_idx\"")
580main: -> 0.0013s
581main: -- remove_index(:p_ci_builds, {:name=>:p_ci_builds_project_id_bigint_id_idx, :if_exists=>true})
582main: -> 0.0871s
583main: -- indexes("p_ci_builds")
584main: -> 0.0418s
585main: -- indexes("p_ci_builds")
586main: -> 0.0422s
587main: -- indexes("public.ci_builds")
588main: -> 0.0403s
589main: -- indexes("public.ci_builds")
590main: -> 0.0413s
591main: -- quote_table_name("public.index_66150954f7")
592main: -> 0.0000s
593main: -- quote_table_name("temp_b3fd8fe064")
594main: -> 0.0000s
595main: -- execute("ALTER INDEX \"public\".\"index_66150954f7\" RENAME TO \"temp_b3fd8fe064\"")
596main: -> 0.0013s
597main: -- quote_table_name("public.index_ci_builds_on_project_id_and_name_and_ref")
598main: -> 0.0000s
599main: -- quote_table_name("index_66150954f7")
600main: -> 0.0000s
601main: -- execute("ALTER INDEX \"public\".\"index_ci_builds_on_project_id_and_name_and_ref\" RENAME TO \"index_66150954f7\"")
602main: -> 0.0011s
603main: -- quote_table_name("public.temp_b3fd8fe064")
604main: -> 0.0000s
605main: -- quote_table_name("index_ci_builds_on_project_id_and_name_and_ref")
606main: -> 0.0000s
607main: -- execute("ALTER INDEX \"public\".\"temp_b3fd8fe064\" RENAME TO \"index_ci_builds_on_project_id_and_name_and_ref\"")
608main: -> 0.0016s
609main: -- indexes("gitlab_partitions_dynamic.ci_builds_101")
610main: -> 0.0418s
611main: -- indexes("gitlab_partitions_dynamic.ci_builds_101")
612main: -> 0.0406s
613main: -- quote_table_name("gitlab_partitions_dynamic.index_f875b45146")
614main: -> 0.0000s
615main: -- quote_table_name("temp_12772d8fed")
616main: -> 0.0000s
617main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"index_f875b45146\" RENAME TO \"temp_12772d8fed\"")
618main: -> 0.0013s
619main: -- quote_table_name("gitlab_partitions_dynamic.ci_builds_101_project_id_name_ref_idx")
620main: -> 0.0000s
621main: -- quote_table_name("index_f875b45146")
622main: -> 0.0000s
623main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"ci_builds_101_project_id_name_ref_idx\" RENAME TO \"index_f875b45146\"")
624main: -> 0.0011s
625main: -- quote_table_name("gitlab_partitions_dynamic.temp_12772d8fed")
626main: -> 0.0000s
627main: -- quote_table_name("ci_builds_101_project_id_name_ref_idx")
628main: -> 0.0000s
629main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"temp_12772d8fed\" RENAME TO \"ci_builds_101_project_id_name_ref_idx\"")
630main: -> 0.0012s
631main: -- indexes("gitlab_partitions_dynamic.ci_builds_102")
632main: -> 0.0422s
633main: -- indexes("gitlab_partitions_dynamic.ci_builds_102")
634main: -> 0.0399s
635main: -- quote_table_name("gitlab_partitions_dynamic.index_cb092f7068")
636main: -> 0.0000s
637main: -- quote_table_name("temp_1a46589fa2")
638main: -> 0.0000s
639main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"index_cb092f7068\" RENAME TO \"temp_1a46589fa2\"")
640main: -> 0.0012s
641main: -- quote_table_name("gitlab_partitions_dynamic.ci_builds_102_project_id_name_ref_idx")
642main: -> 0.0000s
643main: -- quote_table_name("index_cb092f7068")
644main: -> 0.0000s
645main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"ci_builds_102_project_id_name_ref_idx\" RENAME TO \"index_cb092f7068\"")
646main: -> 0.0011s
647main: -- quote_table_name("gitlab_partitions_dynamic.temp_1a46589fa2")
648main: -> 0.0000s
649main: -- quote_table_name("ci_builds_102_project_id_name_ref_idx")
650main: -> 0.0000s
651main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"temp_1a46589fa2\" RENAME TO \"ci_builds_102_project_id_name_ref_idx\"")
652main: -> 0.0010s
653main: -- quote_table_name("p_ci_builds_project_id_bigint_name_ref_idx")
654main: -> 0.0000s
655main: -- quote_table_name("temp_ba5bac6411")
656main: -> 0.0000s
657main: -- execute("ALTER INDEX \"p_ci_builds_project_id_bigint_name_ref_idx\" RENAME TO \"temp_ba5bac6411\"")
658main: -> 0.0016s
659main: -- quote_table_name("p_ci_builds_project_id_name_ref_idx")
660main: -> 0.0000s
661main: -- quote_table_name(:p_ci_builds_project_id_bigint_name_ref_idx)
662main: -> 0.0000s
663main: -- execute("ALTER INDEX \"p_ci_builds_project_id_name_ref_idx\" RENAME TO \"p_ci_builds_project_id_bigint_name_ref_idx\"")
664main: -> 0.0010s
665main: -- quote_table_name("temp_ba5bac6411")
666main: -> 0.0000s
667main: -- quote_table_name(:p_ci_builds_project_id_name_ref_idx)
668main: -> 0.0000s
669main: -- execute("ALTER INDEX \"temp_ba5bac6411\" RENAME TO \"p_ci_builds_project_id_name_ref_idx\"")
670main: -> 0.0010s
671main: -- remove_index(:p_ci_builds, {:name=>:p_ci_builds_project_id_bigint_name_ref_idx, :if_exists=>true})
672main: -> 0.0839s
673main: -- indexes("p_ci_builds")
674main: -> 0.0420s
675main: -- indexes("p_ci_builds")
676main: -> 0.0392s
677main: -- indexes("public.ci_builds")
678main: -> 0.0401s
679main: -- indexes("public.ci_builds")
680main: -> 0.0396s
681main: -- quote_table_name("public.index_491160ecb2")
682main: -> 0.0000s
683main: -- quote_table_name("temp_5402eff91e")
684main: -> 0.0000s
685main: -- execute("ALTER INDEX \"public\".\"index_491160ecb2\" RENAME TO \"temp_5402eff91e\"")
686main: -> 0.0021s
687main: -- quote_table_name("public.index_ci_builds_project_id_and_status_for_live_jobs_partial2")
688main: -> 0.0000s
689main: -- quote_table_name("index_491160ecb2")
690main: -> 0.0000s
691main: -- execute("ALTER INDEX \"public\".\"index_ci_builds_project_id_and_status_for_live_jobs_partial2\" RENAME TO \"index_491160ecb2\"")
692main: -> 0.0011s
693main: -- quote_table_name("public.temp_5402eff91e")
694main: -> 0.0000s
695main: -- quote_table_name("index_ci_builds_project_id_and_status_for_live_jobs_partial2")
696main: -> 0.0000s
697main: -- execute("ALTER INDEX \"public\".\"temp_5402eff91e\" RENAME TO \"index_ci_builds_project_id_and_status_for_live_jobs_partial2\"")
698main: -> 0.0010s
699main: -- indexes("gitlab_partitions_dynamic.ci_builds_101")
700main: -> 0.0405s
701main: -- indexes("gitlab_partitions_dynamic.ci_builds_101")
702main: -> 0.0407s
703main: -- quote_table_name("gitlab_partitions_dynamic.index_14c2ce1b32")
704main: -> 0.0000s
705main: -- quote_table_name("temp_1631c1f82e")
706main: -> 0.0004s
707main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"index_14c2ce1b32\" RENAME TO \"temp_1631c1f82e\"")
708main: -> 0.0012s
709main: -- quote_table_name("gitlab_partitions_dynamic.ci_builds_101_project_id_status_idx")
710main: -> 0.0000s
711main: -- quote_table_name("index_14c2ce1b32")
712main: -> 0.0000s
713main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"ci_builds_101_project_id_status_idx\" RENAME TO \"index_14c2ce1b32\"")
714main: -> 0.0012s
715main: -- quote_table_name("gitlab_partitions_dynamic.temp_1631c1f82e")
716main: -> 0.0000s
717main: -- quote_table_name("ci_builds_101_project_id_status_idx")
718main: -> 0.0000s
719main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"temp_1631c1f82e\" RENAME TO \"ci_builds_101_project_id_status_idx\"")
720main: -> 0.0012s
721main: -- indexes("gitlab_partitions_dynamic.ci_builds_102")
722main: -> 0.0416s
723main: -- indexes("gitlab_partitions_dynamic.ci_builds_102")
724main: -> 0.0410s
725main: -- quote_table_name("gitlab_partitions_dynamic.index_e13be50c35")
726main: -> 0.0000s
727main: -- quote_table_name("temp_b55f3e85b3")
728main: -> 0.0000s
729main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"index_e13be50c35\" RENAME TO \"temp_b55f3e85b3\"")
730main: -> 0.0014s
731main: -- quote_table_name("gitlab_partitions_dynamic.ci_builds_102_project_id_status_idx")
732main: -> 0.0000s
733main: -- quote_table_name("index_e13be50c35")
734main: -> 0.0000s
735main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"ci_builds_102_project_id_status_idx\" RENAME TO \"index_e13be50c35\"")
736main: -> 0.0012s
737main: -- quote_table_name("gitlab_partitions_dynamic.temp_b55f3e85b3")
738main: -> 0.0000s
739main: -- quote_table_name("ci_builds_102_project_id_status_idx")
740main: -> 0.0000s
741main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"temp_b55f3e85b3\" RENAME TO \"ci_builds_102_project_id_status_idx\"")
742main: -> 0.0011s
743main: -- quote_table_name("p_ci_builds_project_id_bigint_status_idx")
744main: -> 0.0000s
745main: -- quote_table_name("temp_92d8aac784")
746main: -> 0.0000s
747main: -- execute("ALTER INDEX \"p_ci_builds_project_id_bigint_status_idx\" RENAME TO \"temp_92d8aac784\"")
748main: -> 0.0011s
749main: -- quote_table_name("p_ci_builds_project_id_status_idx")
750main: -> 0.0000s
751main: -- quote_table_name(:p_ci_builds_project_id_bigint_status_idx)
752main: -> 0.0000s
753main: -- execute("ALTER INDEX \"p_ci_builds_project_id_status_idx\" RENAME TO \"p_ci_builds_project_id_bigint_status_idx\"")
754main: -> 0.0010s
755main: -- quote_table_name("temp_92d8aac784")
756main: -> 0.0000s
757main: -- quote_table_name(:p_ci_builds_project_id_status_idx)
758main: -> 0.0001s
759main: -- execute("ALTER INDEX \"temp_92d8aac784\" RENAME TO \"p_ci_builds_project_id_status_idx\"")
760main: -> 0.0011s
761main: -- remove_index(:p_ci_builds, {:name=>:p_ci_builds_project_id_bigint_status_idx, :if_exists=>true})
762main: -> 0.0806s
763main: -- indexes("p_ci_builds")
764main: -> 0.0378s
765main: -- indexes("p_ci_builds")
766main: -> 0.0370s
767main: -- indexes("public.ci_builds")
768main: -> 0.0389s
769main: -- indexes("public.ci_builds")
770main: -> 0.0380s
771main: -- quote_table_name("public.index_57533f9878")
772main: -> 0.0000s
773main: -- quote_table_name("temp_b1a2134956")
774main: -> 0.0000s
775main: -- execute("ALTER INDEX \"public\".\"index_57533f9878\" RENAME TO \"temp_b1a2134956\"")
776main: -> 0.0013s
777main: -- quote_table_name("public.ci_builds_gitlab_monitor_metrics")
778main: -> 0.0000s
779main: -- quote_table_name("index_57533f9878")
780main: -> 0.0000s
781main: -- execute("ALTER INDEX \"public\".\"ci_builds_gitlab_monitor_metrics\" RENAME TO \"index_57533f9878\"")
782main: -> 0.0011s
783main: -- quote_table_name("public.temp_b1a2134956")
784main: -> 0.0000s
785main: -- quote_table_name("ci_builds_gitlab_monitor_metrics")
786main: -> 0.0000s
787main: -- execute("ALTER INDEX \"public\".\"temp_b1a2134956\" RENAME TO \"ci_builds_gitlab_monitor_metrics\"")
788main: -> 0.0010s
789main: -- indexes("gitlab_partitions_dynamic.ci_builds_101")
790main: -> 0.0379s
791main: -- indexes("gitlab_partitions_dynamic.ci_builds_101")
792main: -> 0.0380s
793main: -- quote_table_name("gitlab_partitions_dynamic.index_80a14c0ae5")
794main: -> 0.0000s
795main: -- quote_table_name("temp_e12ee96737")
796main: -> 0.0000s
797main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"index_80a14c0ae5\" RENAME TO \"temp_e12ee96737\"")
798main: -> 0.0013s
799main: -- quote_table_name("gitlab_partitions_dynamic.ci_builds_101_status_created_at_project_id_idx")
800main: -> 0.0000s
801main: -- quote_table_name("index_80a14c0ae5")
802main: -> 0.0000s
803main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"ci_builds_101_status_created_at_project_id_idx\" RENAME TO \"index_80a14c0ae5\"")
804main: -> 0.0015s
805main: -- quote_table_name("gitlab_partitions_dynamic.temp_e12ee96737")
806main: -> 0.0000s
807main: -- quote_table_name("ci_builds_101_status_created_at_project_id_idx")
808main: -> 0.0000s
809main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"temp_e12ee96737\" RENAME TO \"ci_builds_101_status_created_at_project_id_idx\"")
810main: -> 0.0010s
811main: -- indexes("gitlab_partitions_dynamic.ci_builds_102")
812main: -> 0.0372s
813main: -- indexes("gitlab_partitions_dynamic.ci_builds_102")
814main: -> 0.0351s
815main: -- quote_table_name("gitlab_partitions_dynamic.index_3ba7eeaff6")
816main: -> 0.0000s
817main: -- quote_table_name("temp_a95c1e4e0c")
818main: -> 0.0000s
819main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"index_3ba7eeaff6\" RENAME TO \"temp_a95c1e4e0c\"")
820main: -> 0.0013s
821main: -- quote_table_name("gitlab_partitions_dynamic.ci_builds_102_status_created_at_project_id_idx")
822main: -> 0.0000s
823main: -- quote_table_name("index_3ba7eeaff6")
824main: -> 0.0000s
825main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"ci_builds_102_status_created_at_project_id_idx\" RENAME TO \"index_3ba7eeaff6\"")
826main: -> 0.0011s
827main: -- quote_table_name("gitlab_partitions_dynamic.temp_a95c1e4e0c")
828main: -> 0.0000s
829main: -- quote_table_name("ci_builds_102_status_created_at_project_id_idx")
830main: -> 0.0000s
831main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"temp_a95c1e4e0c\" RENAME TO \"ci_builds_102_status_created_at_project_id_idx\"")
832main: -> 0.0010s
833main: -- quote_table_name("p_ci_builds_status_created_at_project_id_bigint_idx")
834main: -> 0.0000s
835main: -- quote_table_name("temp_b3f32fed0f")
836main: -> 0.0000s
837main: -- execute("ALTER INDEX \"p_ci_builds_status_created_at_project_id_bigint_idx\" RENAME TO \"temp_b3f32fed0f\"")
838main: -> 0.0011s
839main: -- quote_table_name("p_ci_builds_status_created_at_project_id_idx")
840main: -> 0.0000s
841main: -- quote_table_name(:p_ci_builds_status_created_at_project_id_bigint_idx)
842main: -> 0.0000s
843main: -- execute("ALTER INDEX \"p_ci_builds_status_created_at_project_id_idx\" RENAME TO \"p_ci_builds_status_created_at_project_id_bigint_idx\"")
844main: -> 0.0010s
845main: -- quote_table_name("temp_b3f32fed0f")
846main: -> 0.0000s
847main: -- quote_table_name(:p_ci_builds_status_created_at_project_id_idx)
848main: -> 0.0000s
849main: -- execute("ALTER INDEX \"temp_b3f32fed0f\" RENAME TO \"p_ci_builds_status_created_at_project_id_idx\"")
850main: -> 0.0010s
851main: -- remove_index(:p_ci_builds, {:name=>:p_ci_builds_status_created_at_project_id_bigint_idx, :if_exists=>true})
852main: -> 0.0740s
853main: == 20240423235307 SwapColumnsForPCiBuildsProjectId: migrated (1.7929s) ========
854main: == [advisory_lock_connection] object_id: 191133640, pg_backend_pid: 255
855 correctly swaps conversion columns
856# [RSpecRunTime] RSpec elapsed time: 14 minutes 40.07 seconds. Current RSS: ~1390M. Threads: 2. load average: 1.02 0.98 1.00 1/276 417
857.
858 when index is different
859 behaves like swap conversion columns
860main: -- execute("DROP INDEX IF EXISTS p_ci_builds_project_id_id_convert_to_bigint_idx;\nDROP INDEX IF EXISTS p_ci_builds_project_id_id_idx;\n")
861main: -> 0.0033s
862main: -- transaction_open?(nil)
863main: -> 0.0001s
864main: -- index_name_exists?(:p_ci_builds, :p_ci_builds_project_id_id_convert_to_bigint_idx)
865main: -> 0.0036s
866main: -- transaction_open?(nil)
867main: -> 0.0002s
868main: -- index_exists?("public.ci_builds", [:project_id, :id], {:name=>"index_9dec349661", :algorithm=>:concurrently})
869main: -> 0.0440s
870main: -- add_index("public.ci_builds", [:project_id, :id], {:name=>"index_9dec349661", :algorithm=>:concurrently})
871main: -> 0.0031s
872main: -- transaction_open?(nil)
873main: -> 0.0001s
874main: -- index_exists?("gitlab_partitions_dynamic.ci_builds_101", [:project_id, :id], {:name=>"index_2c2ee081ff", :algorithm=>:concurrently})
875main: -> 0.0413s
876main: -- add_index("gitlab_partitions_dynamic.ci_builds_101", [:project_id, :id], {:name=>"index_2c2ee081ff", :algorithm=>:concurrently})
877main: -> 0.0029s
878main: -- transaction_open?(nil)
879main: -> 0.0001s
880main: -- index_exists?("gitlab_partitions_dynamic.ci_builds_102", [:project_id, :id], {:name=>"index_8f1108e627", :algorithm=>:concurrently})
881main: -> 0.0401s
882main: -- add_index("gitlab_partitions_dynamic.ci_builds_102", [:project_id, :id], {:name=>"index_8f1108e627", :algorithm=>:concurrently})
883main: -> 0.0025s
884main: -- transaction_open?(nil)
885main: -> 0.0001s
886main: -- add_index(:p_ci_builds, [:project_id, :id], {:name=>:p_ci_builds_project_id_id_convert_to_bigint_idx})
887main: -> 0.0027s
888main: == [advisory_lock_connection] object_id: 196347860, pg_backend_pid: 259
889main: == 20240423235307 SwapColumnsForPCiBuildsProjectId: migrating =================
890main: -- index_name_exists?(:p_ci_builds, :p_ci_builds_project_id_id_idx)
891main: -> 0.0034s
892main: -- indexes("p_ci_builds")
893main: -> 0.0469s
894main: -- indexes("public.ci_builds")
895main: -> 0.0425s
896main: -- quote_table_name("public.index_9dec349661")
897main: -> 0.0001s
898main: -- quote_table_name("index_e4a5307529")
899main: -> 0.0001s
900main: -- execute("ALTER INDEX \"public\".\"index_9dec349661\" RENAME TO \"index_e4a5307529\"")
901main: -> 0.0012s
902main: -- indexes("gitlab_partitions_dynamic.ci_builds_101")
903main: -> 0.0420s
904main: -- quote_table_name("gitlab_partitions_dynamic.index_2c2ee081ff")
905main: -> 0.0001s
906main: -- quote_table_name("index_a2c19538cd")
907main: -> 0.0000s
908main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"index_2c2ee081ff\" RENAME TO \"index_a2c19538cd\"")
909main: -> 0.0012s
910main: -- indexes("gitlab_partitions_dynamic.ci_builds_102")
911main: -> 0.0420s
912main: -- quote_table_name("gitlab_partitions_dynamic.index_8f1108e627")
913main: -> 0.0001s
914main: -- quote_table_name("index_75567f633a")
915main: -> 0.0001s
916main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"index_8f1108e627\" RENAME TO \"index_75567f633a\"")
917main: -> 0.0012s
918main: -- quote_table_name("p_ci_builds_project_id_id_convert_to_bigint_idx")
919main: -> 0.0000s
920main: -- quote_table_name(:p_ci_builds_project_id_id_idx)
921main: -> 0.0000s
922main: -- execute("ALTER INDEX \"p_ci_builds_project_id_id_convert_to_bigint_idx\" RENAME TO \"p_ci_builds_project_id_id_idx\"")
923main: -> 0.0013s
924main: -- quote_table_name(:p_ci_builds)
925main: -> 0.0000s
926main: -- execute("LOCK TABLE \"p_ci_builds\" IN ACCESS EXCLUSIVE MODE")
927main: -> 0.0010s
928main: -- clear_cache!(nil)
929main: -> 0.0000s
930main: -- quote_table_name(:p_ci_builds)
931main: -> 0.0000s
932main: -- quote_column_name(:project_id_convert_to_bigint)
933main: -> 0.0000s
934main: -- quote_column_name(:temp_name_for_renaming)
935main: -> 0.0000s
936main: -- execute("ALTER TABLE \"p_ci_builds\"\n RENAME COLUMN \"project_id_convert_to_bigint\" TO \"temp_name_for_renaming\"\n")
937main: -> 0.0011s
938main: -- clear_cache!(nil)
939main: -> 0.0000s
940main: -- quote_table_name(:p_ci_builds)
941main: -> 0.0000s
942main: -- quote_column_name(:project_id)
943main: -> 0.0000s
944main: -- quote_column_name(:project_id_convert_to_bigint)
945main: -> 0.0000s
946main: -- execute("ALTER TABLE \"p_ci_builds\"\n RENAME COLUMN \"project_id\" TO \"project_id_convert_to_bigint\"\n")
947main: -> 0.0017s
948main: -- clear_cache!(nil)
949main: -> 0.0000s
950main: -- quote_table_name(:p_ci_builds)
951main: -> 0.0000s
952main: -- quote_column_name(:temp_name_for_renaming)
953main: -> 0.0000s
954main: -- quote_column_name(:project_id)
955main: -> 0.0000s
956main: -- execute("ALTER TABLE \"p_ci_builds\"\n RENAME COLUMN \"temp_name_for_renaming\" TO \"project_id\"\n")
957main: -> 0.0013s
958main: -- quote_table_name(:trigger_10ee1357e825)
959main: -> 0.0000s
960main: -- execute("ALTER FUNCTION \"trigger_10ee1357e825\" RESET ALL")
961main: -> 0.0009s
962main: -- indexes("p_ci_builds")
963main: -> 0.0413s
964main: -- indexes("p_ci_builds")
965main: -> 0.0424s
966main: -- indexes("public.ci_builds")
967main: -> 0.0410s
968main: -- indexes("public.ci_builds")
969main: -> 0.0423s
970main: -- quote_table_name("public.index_3591adffe4")
971main: -> 0.0000s
972main: -- quote_table_name("temp_1bdabdb3ec")
973main: -> 0.0000s
974main: -- execute("ALTER INDEX \"public\".\"index_3591adffe4\" RENAME TO \"temp_1bdabdb3ec\"")
975main: -> 0.0016s
976main: -- quote_table_name("public.index_e4a5307529")
977main: -> 0.0000s
978main: -- quote_table_name("index_3591adffe4")
979main: -> 0.0000s
980main: -- execute("ALTER INDEX \"public\".\"index_e4a5307529\" RENAME TO \"index_3591adffe4\"")
981main: -> 0.0012s
982main: -- quote_table_name("public.temp_1bdabdb3ec")
983main: -> 0.0000s
984main: -- quote_table_name("index_e4a5307529")
985main: -> 0.0000s
986main: -- execute("ALTER INDEX \"public\".\"temp_1bdabdb3ec\" RENAME TO \"index_e4a5307529\"")
987main: -> 0.0011s
988main: -- indexes("gitlab_partitions_dynamic.ci_builds_101")
989main: -> 0.0429s
990main: -- indexes("gitlab_partitions_dynamic.ci_builds_101")
991main: -> 0.0427s
992main: -- quote_table_name("gitlab_partitions_dynamic.index_10eae1e8cf")
993main: -> 0.0000s
994main: -- quote_table_name("temp_a321ab91cd")
995main: -> 0.0000s
996main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"index_10eae1e8cf\" RENAME TO \"temp_a321ab91cd\"")
997main: -> 0.0014s
998main: -- quote_table_name("gitlab_partitions_dynamic.index_a2c19538cd")
999main: -> 0.0001s
1000main: -- quote_table_name("index_10eae1e8cf")
1001main: -> 0.0000s
1002main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"index_a2c19538cd\" RENAME TO \"index_10eae1e8cf\"")
1003main: -> 0.0012s
1004main: -- quote_table_name("gitlab_partitions_dynamic.temp_a321ab91cd")
1005main: -> 0.0000s
1006main: -- quote_table_name("index_a2c19538cd")
1007main: -> 0.0000s
1008main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"temp_a321ab91cd\" RENAME TO \"index_a2c19538cd\"")
1009main: -> 0.0015s
1010main: -- indexes("gitlab_partitions_dynamic.ci_builds_102")
1011main: -> 0.0424s
1012main: -- indexes("gitlab_partitions_dynamic.ci_builds_102")
1013main: -> 0.0391s
1014main: -- quote_table_name("gitlab_partitions_dynamic.index_214b33570d")
1015main: -> 0.0000s
1016main: -- quote_table_name("temp_48a0b416de")
1017main: -> 0.0000s
1018main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"index_214b33570d\" RENAME TO \"temp_48a0b416de\"")
1019main: -> 0.0017s
1020main: -- quote_table_name("gitlab_partitions_dynamic.index_75567f633a")
1021main: -> 0.0001s
1022main: -- quote_table_name("index_214b33570d")
1023main: -> 0.0000s
1024main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"index_75567f633a\" RENAME TO \"index_214b33570d\"")
1025main: -> 0.0011s
1026main: -- quote_table_name("gitlab_partitions_dynamic.temp_48a0b416de")
1027main: -> 0.0000s
1028main: -- quote_table_name("index_75567f633a")
1029main: -> 0.0000s
1030main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"temp_48a0b416de\" RENAME TO \"index_75567f633a\"")
1031main: -> 0.0010s
1032main: -- quote_table_name("p_ci_builds_project_id_bigint_id_idx")
1033main: -> 0.0000s
1034main: -- quote_table_name("temp_f2c2fe031f")
1035main: -> 0.0000s
1036main: -- execute("ALTER INDEX \"p_ci_builds_project_id_bigint_id_idx\" RENAME TO \"temp_f2c2fe031f\"")
1037main: -> 0.0009s
1038main: -- quote_table_name("p_ci_builds_project_id_id_idx")
1039main: -> 0.0000s
1040main: -- quote_table_name(:p_ci_builds_project_id_bigint_id_idx)
1041main: -> 0.0000s
1042main: -- execute("ALTER INDEX \"p_ci_builds_project_id_id_idx\" RENAME TO \"p_ci_builds_project_id_bigint_id_idx\"")
1043main: -> 0.0012s
1044main: -- quote_table_name("temp_f2c2fe031f")
1045main: -> 0.0000s
1046main: -- quote_table_name(:p_ci_builds_project_id_id_idx)
1047main: -> 0.0000s
1048main: -- execute("ALTER INDEX \"temp_f2c2fe031f\" RENAME TO \"p_ci_builds_project_id_id_idx\"")
1049main: -> 0.0010s
1050main: -- remove_index(:p_ci_builds, {:name=>:p_ci_builds_project_id_bigint_id_idx, :if_exists=>true})
1051main: -> 0.0806s
1052main: -- indexes("p_ci_builds")
1053main: -> 0.0386s
1054main: -- indexes("p_ci_builds")
1055main: -> 0.0378s
1056main: -- indexes("public.ci_builds")
1057main: -> 0.0381s
1058main: -- indexes("public.ci_builds")
1059main: -> 0.0397s
1060main: -- quote_table_name("public.index_66150954f7")
1061main: -> 0.0000s
1062main: -- quote_table_name("temp_b3fd8fe064")
1063main: -> 0.0000s
1064main: -- execute("ALTER INDEX \"public\".\"index_66150954f7\" RENAME TO \"temp_b3fd8fe064\"")
1065main: -> 0.0012s
1066main: -- quote_table_name("public.index_ci_builds_on_project_id_and_name_and_ref")
1067main: -> 0.0000s
1068main: -- quote_table_name("index_66150954f7")
1069main: -> 0.0000s
1070main: -- execute("ALTER INDEX \"public\".\"index_ci_builds_on_project_id_and_name_and_ref\" RENAME TO \"index_66150954f7\"")
1071main: -> 0.0013s
1072main: -- quote_table_name("public.temp_b3fd8fe064")
1073main: -> 0.0000s
1074main: -- quote_table_name("index_ci_builds_on_project_id_and_name_and_ref")
1075main: -> 0.0000s
1076main: -- execute("ALTER INDEX \"public\".\"temp_b3fd8fe064\" RENAME TO \"index_ci_builds_on_project_id_and_name_and_ref\"")
1077main: -> 0.0010s
1078main: -- indexes("gitlab_partitions_dynamic.ci_builds_101")
1079main: -> 0.0405s
1080main: -- indexes("gitlab_partitions_dynamic.ci_builds_101")
1081main: -> 0.0416s
1082main: -- quote_table_name("gitlab_partitions_dynamic.index_f875b45146")
1083main: -> 0.0000s
1084main: -- quote_table_name("temp_12772d8fed")
1085main: -> 0.0000s
1086main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"index_f875b45146\" RENAME TO \"temp_12772d8fed\"")
1087main: -> 0.0013s
1088main: -- quote_table_name("gitlab_partitions_dynamic.ci_builds_101_project_id_name_ref_idx")
1089main: -> 0.0000s
1090main: -- quote_table_name("index_f875b45146")
1091main: -> 0.0000s
1092main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"ci_builds_101_project_id_name_ref_idx\" RENAME TO \"index_f875b45146\"")
1093main: -> 0.0011s
1094main: -- quote_table_name("gitlab_partitions_dynamic.temp_12772d8fed")
1095main: -> 0.0000s
1096main: -- quote_table_name("ci_builds_101_project_id_name_ref_idx")
1097main: -> 0.0000s
1098main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"temp_12772d8fed\" RENAME TO \"ci_builds_101_project_id_name_ref_idx\"")
1099main: -> 0.0013s
1100main: -- indexes("gitlab_partitions_dynamic.ci_builds_102")
1101main: -> 0.0399s
1102main: -- indexes("gitlab_partitions_dynamic.ci_builds_102")
1103main: -> 0.0396s
1104main: -- quote_table_name("gitlab_partitions_dynamic.index_cb092f7068")
1105main: -> 0.0000s
1106main: -- quote_table_name("temp_1a46589fa2")
1107main: -> 0.0000s
1108main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"index_cb092f7068\" RENAME TO \"temp_1a46589fa2\"")
1109main: -> 0.0013s
1110main: -- quote_table_name("gitlab_partitions_dynamic.ci_builds_102_project_id_name_ref_idx")
1111main: -> 0.0000s
1112main: -- quote_table_name("index_cb092f7068")
1113main: -> 0.0000s
1114main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"ci_builds_102_project_id_name_ref_idx\" RENAME TO \"index_cb092f7068\"")
1115main: -> 0.0011s
1116main: -- quote_table_name("gitlab_partitions_dynamic.temp_1a46589fa2")
1117main: -> 0.0000s
1118main: -- quote_table_name("ci_builds_102_project_id_name_ref_idx")
1119main: -> 0.0000s
1120main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"temp_1a46589fa2\" RENAME TO \"ci_builds_102_project_id_name_ref_idx\"")
1121main: -> 0.0010s
1122main: -- quote_table_name("p_ci_builds_project_id_bigint_name_ref_idx")
1123main: -> 0.0000s
1124main: -- quote_table_name("temp_ba5bac6411")
1125main: -> 0.0000s
1126main: -- execute("ALTER INDEX \"p_ci_builds_project_id_bigint_name_ref_idx\" RENAME TO \"temp_ba5bac6411\"")
1127main: -> 0.0012s
1128main: -- quote_table_name("p_ci_builds_project_id_name_ref_idx")
1129main: -> 0.0000s
1130main: -- quote_table_name(:p_ci_builds_project_id_bigint_name_ref_idx)
1131main: -> 0.0000s
1132main: -- execute("ALTER INDEX \"p_ci_builds_project_id_name_ref_idx\" RENAME TO \"p_ci_builds_project_id_bigint_name_ref_idx\"")
1133main: -> 0.0010s
1134main: -- quote_table_name("temp_ba5bac6411")
1135main: -> 0.0000s
1136main: -- quote_table_name(:p_ci_builds_project_id_name_ref_idx)
1137main: -> 0.0000s
1138main: -- execute("ALTER INDEX \"temp_ba5bac6411\" RENAME TO \"p_ci_builds_project_id_name_ref_idx\"")
1139main: -> 0.0010s
1140main: -- remove_index(:p_ci_builds, {:name=>:p_ci_builds_project_id_bigint_name_ref_idx, :if_exists=>true})
1141main: -> 0.0816s
1142main: -- indexes("p_ci_builds")
1143main: -> 0.0413s
1144main: -- indexes("p_ci_builds")
1145main: -> 0.0413s
1146main: -- indexes("public.ci_builds")
1147main: -> 0.0395s
1148main: -- indexes("public.ci_builds")
1149main: -> 0.0401s
1150main: -- quote_table_name("public.index_491160ecb2")
1151main: -> 0.0000s
1152main: -- quote_table_name("temp_5402eff91e")
1153main: -> 0.0000s
1154main: -- execute("ALTER INDEX \"public\".\"index_491160ecb2\" RENAME TO \"temp_5402eff91e\"")
1155main: -> 0.0013s
1156main: -- quote_table_name("public.index_ci_builds_project_id_and_status_for_live_jobs_partial2")
1157main: -> 0.0000s
1158main: -- quote_table_name("index_491160ecb2")
1159main: -> 0.0000s
1160main: -- execute("ALTER INDEX \"public\".\"index_ci_builds_project_id_and_status_for_live_jobs_partial2\" RENAME TO \"index_491160ecb2\"")
1161main: -> 0.0013s
1162main: -- quote_table_name("public.temp_5402eff91e")
1163main: -> 0.0000s
1164main: -- quote_table_name("index_ci_builds_project_id_and_status_for_live_jobs_partial2")
1165main: -> 0.0000s
1166main: -- execute("ALTER INDEX \"public\".\"temp_5402eff91e\" RENAME TO \"index_ci_builds_project_id_and_status_for_live_jobs_partial2\"")
1167main: -> 0.0010s
1168main: -- indexes("gitlab_partitions_dynamic.ci_builds_101")
1169main: -> 0.0403s
1170main: -- indexes("gitlab_partitions_dynamic.ci_builds_101")
1171main: -> 0.0402s
1172main: -- quote_table_name("gitlab_partitions_dynamic.index_14c2ce1b32")
1173main: -> 0.0000s
1174main: -- quote_table_name("temp_1631c1f82e")
1175main: -> 0.0001s
1176main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"index_14c2ce1b32\" RENAME TO \"temp_1631c1f82e\"")
1177main: -> 0.0014s
1178main: -- quote_table_name("gitlab_partitions_dynamic.ci_builds_101_project_id_status_idx")
1179main: -> 0.0000s
1180main: -- quote_table_name("index_14c2ce1b32")
1181main: -> 0.0000s
1182main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"ci_builds_101_project_id_status_idx\" RENAME TO \"index_14c2ce1b32\"")
1183main: -> 0.0012s
1184main: -- quote_table_name("gitlab_partitions_dynamic.temp_1631c1f82e")
1185main: -> 0.0000s
1186main: -- quote_table_name("ci_builds_101_project_id_status_idx")
1187main: -> 0.0000s
1188main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"temp_1631c1f82e\" RENAME TO \"ci_builds_101_project_id_status_idx\"")
1189main: -> 0.0011s
1190main: -- indexes("gitlab_partitions_dynamic.ci_builds_102")
1191main: -> 0.0392s
1192main: -- indexes("gitlab_partitions_dynamic.ci_builds_102")
1193main: -> 0.0393s
1194main: -- quote_table_name("gitlab_partitions_dynamic.index_e13be50c35")
1195main: -> 0.0001s
1196main: -- quote_table_name("temp_b55f3e85b3")
1197main: -> 0.0000s
1198main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"index_e13be50c35\" RENAME TO \"temp_b55f3e85b3\"")
1199main: -> 0.0012s
1200main: -- quote_table_name("gitlab_partitions_dynamic.ci_builds_102_project_id_status_idx")
1201main: -> 0.0000s
1202main: -- quote_table_name("index_e13be50c35")
1203main: -> 0.0000s
1204main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"ci_builds_102_project_id_status_idx\" RENAME TO \"index_e13be50c35\"")
1205main: -> 0.0012s
1206main: -- quote_table_name("gitlab_partitions_dynamic.temp_b55f3e85b3")
1207main: -> 0.0000s
1208main: -- quote_table_name("ci_builds_102_project_id_status_idx")
1209main: -> 0.0000s
1210main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"temp_b55f3e85b3\" RENAME TO \"ci_builds_102_project_id_status_idx\"")
1211main: -> 0.0011s
1212main: -- quote_table_name("p_ci_builds_project_id_bigint_status_idx")
1213main: -> 0.0000s
1214main: -- quote_table_name("temp_92d8aac784")
1215main: -> 0.0000s
1216main: -- execute("ALTER INDEX \"p_ci_builds_project_id_bigint_status_idx\" RENAME TO \"temp_92d8aac784\"")
1217main: -> 0.0011s
1218main: -- quote_table_name("p_ci_builds_project_id_status_idx")
1219main: -> 0.0000s
1220main: -- quote_table_name(:p_ci_builds_project_id_bigint_status_idx)
1221main: -> 0.0000s
1222main: -- execute("ALTER INDEX \"p_ci_builds_project_id_status_idx\" RENAME TO \"p_ci_builds_project_id_bigint_status_idx\"")
1223main: -> 0.0011s
1224main: -- quote_table_name("temp_92d8aac784")
1225main: -> 0.0000s
1226main: -- quote_table_name(:p_ci_builds_project_id_status_idx)
1227main: -> 0.0000s
1228main: -- execute("ALTER INDEX \"temp_92d8aac784\" RENAME TO \"p_ci_builds_project_id_status_idx\"")
1229main: -> 0.0013s
1230main: -- remove_index(:p_ci_builds, {:name=>:p_ci_builds_project_id_bigint_status_idx, :if_exists=>true})
1231main: -> 0.0798s
1232main: -- indexes("p_ci_builds")
1233main: -> 0.0381s
1234main: -- indexes("p_ci_builds")
1235main: -> 0.0388s
1236main: -- indexes("public.ci_builds")
1237main: -> 0.0371s
1238main: -- indexes("public.ci_builds")
1239main: -> 0.0367s
1240main: -- quote_table_name("public.index_57533f9878")
1241main: -> 0.0000s
1242main: -- quote_table_name("temp_b1a2134956")
1243main: -> 0.0000s
1244main: -- execute("ALTER INDEX \"public\".\"index_57533f9878\" RENAME TO \"temp_b1a2134956\"")
1245main: -> 0.0012s
1246main: -- quote_table_name("public.ci_builds_gitlab_monitor_metrics")
1247main: -> 0.0000s
1248main: -- quote_table_name("index_57533f9878")
1249main: -> 0.0000s
1250main: -- execute("ALTER INDEX \"public\".\"ci_builds_gitlab_monitor_metrics\" RENAME TO \"index_57533f9878\"")
1251main: -> 0.0014s
1252main: -- quote_table_name("public.temp_b1a2134956")
1253main: -> 0.0000s
1254main: -- quote_table_name("ci_builds_gitlab_monitor_metrics")
1255main: -> 0.0000s
1256main: -- execute("ALTER INDEX \"public\".\"temp_b1a2134956\" RENAME TO \"ci_builds_gitlab_monitor_metrics\"")
1257main: -> 0.0013s
1258main: -- indexes("gitlab_partitions_dynamic.ci_builds_101")
1259main: -> 0.0362s
1260main: -- indexes("gitlab_partitions_dynamic.ci_builds_101")
1261main: -> 0.0376s
1262main: -- quote_table_name("gitlab_partitions_dynamic.index_80a14c0ae5")
1263main: -> 0.0000s
1264main: -- quote_table_name("temp_e12ee96737")
1265main: -> 0.0000s
1266main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"index_80a14c0ae5\" RENAME TO \"temp_e12ee96737\"")
1267main: -> 0.0012s
1268main: -- quote_table_name("gitlab_partitions_dynamic.ci_builds_101_status_created_at_project_id_idx")
1269main: -> 0.0000s
1270main: -- quote_table_name("index_80a14c0ae5")
1271main: -> 0.0000s
1272main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"ci_builds_101_status_created_at_project_id_idx\" RENAME TO \"index_80a14c0ae5\"")
1273main: -> 0.0010s
1274main: -- quote_table_name("gitlab_partitions_dynamic.temp_e12ee96737")
1275main: -> 0.0000s
1276main: -- quote_table_name("ci_builds_101_status_created_at_project_id_idx")
1277main: -> 0.0000s
1278main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"temp_e12ee96737\" RENAME TO \"ci_builds_101_status_created_at_project_id_idx\"")
1279main: -> 0.0011s
1280main: -- indexes("gitlab_partitions_dynamic.ci_builds_102")
1281main: -> 0.0379s
1282main: -- indexes("gitlab_partitions_dynamic.ci_builds_102")
1283main: -> 0.0360s
1284main: -- quote_table_name("gitlab_partitions_dynamic.index_3ba7eeaff6")
1285main: -> 0.0000s
1286main: -- quote_table_name("temp_a95c1e4e0c")
1287main: -> 0.0000s
1288main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"index_3ba7eeaff6\" RENAME TO \"temp_a95c1e4e0c\"")
1289main: -> 0.0012s
1290main: -- quote_table_name("gitlab_partitions_dynamic.ci_builds_102_status_created_at_project_id_idx")
1291main: -> 0.0000s
1292main: -- quote_table_name("index_3ba7eeaff6")
1293main: -> 0.0000s
1294main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"ci_builds_102_status_created_at_project_id_idx\" RENAME TO \"index_3ba7eeaff6\"")
1295main: -> 0.0011s
1296main: -- quote_table_name("gitlab_partitions_dynamic.temp_a95c1e4e0c")
1297main: -> 0.0000s
1298main: -- quote_table_name("ci_builds_102_status_created_at_project_id_idx")
1299main: -> 0.0000s
1300main: -- execute("ALTER INDEX \"gitlab_partitions_dynamic\".\"temp_a95c1e4e0c\" RENAME TO \"ci_builds_102_status_created_at_project_id_idx\"")
1301main: -> 0.0010s
1302main: -- quote_table_name("p_ci_builds_status_created_at_project_id_bigint_idx")
1303main: -> 0.0000s
1304main: -- quote_table_name("temp_b3f32fed0f")
1305main: -> 0.0000s
1306main: -- execute("ALTER INDEX \"p_ci_builds_status_created_at_project_id_bigint_idx\" RENAME TO \"temp_b3f32fed0f\"")
1307main: -> 0.0010s
1308main: -- quote_table_name("p_ci_builds_status_created_at_project_id_idx")
1309main: -> 0.0000s
1310main: -- quote_table_name(:p_ci_builds_status_created_at_project_id_bigint_idx)
1311main: -> 0.0000s
1312main: -- execute("ALTER INDEX \"p_ci_builds_status_created_at_project_id_idx\" RENAME TO \"p_ci_builds_status_created_at_project_id_bigint_idx\"")
1313main: -> 0.0010s
1314main: -- quote_table_name("temp_b3f32fed0f")
1315main: -> 0.0000s
1316main: -- quote_table_name(:p_ci_builds_status_created_at_project_id_idx)
1317main: -> 0.0000s
1318main: -- execute("ALTER INDEX \"temp_b3f32fed0f\" RENAME TO \"p_ci_builds_status_created_at_project_id_idx\"")
1319main: -> 0.0011s
1320main: -- remove_index(:p_ci_builds, {:name=>:p_ci_builds_status_created_at_project_id_bigint_idx, :if_exists=>true})
1321main: -> 0.0776s
1322main: == 20240423235307 SwapColumnsForPCiBuildsProjectId: migrated (2.0068s) ========
1323main: == [advisory_lock_connection] object_id: 196347860, pg_backend_pid: 259
1324 correctly swaps conversion columns
1325# [RSpecRunTime] RSpec elapsed time: 14 minutes 51.97 seconds. Current RSS: ~1413M. Threads: 2. load average: 1.02 0.98 1.00 1/276 418
1326.
1327I, [2024-07-31T10:31:01.239108 #324] INFO -- : Database: 'main', Table: 'p_ci_build_sources': Lock Writes
1328I, [2024-07-31T10:31:01.240374 #324] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
1329I, [2024-07-31T10:31:01.241170 #324] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
1330I, [2024-07-31T10:31:12.208101 #324] INFO -- : Database: 'main', Table: 'p_ci_finished_pipeline_ch_sync_events': Lock Writes
1331I, [2024-07-31T10:31:18.496377 #324] INFO -- : Database: 'main', Table: 'p_ci_build_tags': Lock Writes
1332# [RSpecRunTime] Finishing example group spec/migrations/db/post_migrate/20240423235307_swap_columns_for_p_ci_builds_project_id_spec.rb. It took 1 minute 22.69 seconds. Expected to take 50.8 seconds.
1333# [RSpecRunTime] RSpec elapsed time: 15 minutes 26.34 seconds. Current RSS: ~1385M. Threads: 2. load average: 0.89 0.96 0.99 1/276 419
1334.
1335# [RSpecRunTime] Starting example group spec/migrations/20240611122408_remove_project_statistics_wiki_size_and_project_id_index_spec.rb. Expected to take 27.88 seconds.
1336RemoveProjectStatisticsWikiSizeAndProjectIdIndex
1337 #up
1338 does nothing when not on gitlab.com
1339main: -- index_exists?(:project_statistics, [:wiki_size, :project_id], {:name=>"index_project_statistics_on_wiki_size_and_project_id"})
1340main: -> 0.0137s
1341main: -- quote_column_name("index_project_statistics_on_wiki_size_and_project_id")
1342main: -> 0.0003s
1343 prepares async index removal when on gitlab.com
1344# [RSpecRunTime] RSpec elapsed time: 15 minutes 42.16 seconds. Current RSS: ~1489M. Threads: 2. load average: 0.98 0.97 1.00 1/276 420
1345.
1346 #down
1347 does nothing when not on gitlab.com
1348 unprepares async index removal when on gitlab.com
1349# [RSpecRunTime] RSpec elapsed time: 15 minutes 50.69 seconds. Current RSS: ~1513M. Threads: 2. load average: 0.98 0.98 1.00 1/276 421
1350.
1351I, [2024-07-31T10:32:00.048434 #324] INFO -- : Database: 'main', Table: 'p_ci_build_tags': Lock Writes
1352# [RSpecRunTime] Finishing example group spec/migrations/20240611122408_remove_project_statistics_wiki_size_and_project_id_index_spec.rb. It took 41.72 seconds. Expected to take 27.88 seconds.
1353# [RSpecRunTime] RSpec elapsed time: 16 minutes 8.12 seconds. Current RSS: ~1351M. Threads: 2. load average: 0.92 0.96 0.99 1/276 422
1354.
1355# [RSpecRunTime] Starting example group spec/migrations/20240515155063_queue_backfill_design_management_designs_namespace_id_spec.rb. Expected to take 25.65 seconds.
1356QueueBackfillDesignManagementDesignsNamespaceId
1357main: == [advisory_lock_connection] object_id: 216920540, pg_backend_pid: 285
1358main: == 20240515155063 QueueBackfillDesignManagementDesignsNamespaceId: migrating ==
1359main: == 20240515155063 QueueBackfillDesignManagementDesignsNamespaceId: migrated (0.0576s)
1360main: == [advisory_lock_connection] object_id: 216920540, pg_backend_pid: 285
1361 schedules a new batched migration
1362I, [2024-07-31T10:32:43.873344 #324] INFO -- : Database: 'main', Table: 'p_ci_finished_pipeline_ch_sync_events': Lock Writes
1363I, [2024-07-31T10:32:49.932441 #324] INFO -- : Database: 'main', Table: 'p_ci_build_tags': Lock Writes
1364# [RSpecRunTime] Finishing example group spec/migrations/20240515155063_queue_backfill_design_management_designs_namespace_id_spec.rb. It took 49.45 seconds. Expected to take 25.65 seconds.
1365# [RSpecRunTime] RSpec elapsed time: 16 minutes 57.64 seconds. Current RSS: ~1350M. Threads: 2. load average: 1.22 1.04 1.02 1/276 423
1366.
1367# [RSpecRunTime] Starting example group spec/migrations/20240605090456_queue_backfill_draft_notes_project_id_spec.rb. Expected to take 18.72 seconds.
1368QueueBackfillDraftNotesProjectId
1369main: == [advisory_lock_connection] object_id: 224176280, pg_backend_pid: 297
1370main: == 20240605090456 QueueBackfillDraftNotesProjectId: migrating =================
1371main: == 20240605090456 QueueBackfillDraftNotesProjectId: migrated (0.0536s) ========
1372main: == [advisory_lock_connection] object_id: 224176280, pg_backend_pid: 297
1373 schedules a new batched migration
1374I, [2024-07-31T10:33:23.698102 #324] INFO -- : Database: 'main', Table: 'p_ci_finished_pipeline_ch_sync_events': Lock Writes
1375I, [2024-07-31T10:33:29.758722 #324] INFO -- : Database: 'main', Table: 'p_ci_build_tags': Lock Writes
1376# [RSpecRunTime] Finishing example group spec/migrations/20240605090456_queue_backfill_draft_notes_project_id_spec.rb. It took 39.43 seconds. Expected to take 18.72 seconds.
1377# [RSpecRunTime] RSpec elapsed time: 17 minutes 37.12 seconds. Current RSS: ~1345M. Threads: 2. load average: 1.05 1.02 1.01 1/276 424
1378.
1379# [RSpecRunTime] Starting example group spec/migrations/20240619142934_queue_backfill_vulnerability_finding_signatures_project_id_spec.rb. Expected to take 13.76 seconds.
1380QueueBackfillVulnerabilityFindingSignaturesProjectId
1381main: == [advisory_lock_connection] object_id: 229295660, pg_backend_pid: 309
1382main: == 20240619142934 QueueBackfillVulnerabilityFindingSignaturesProjectId: migrating
1383main: == 20240619142934 QueueBackfillVulnerabilityFindingSignaturesProjectId: migrated (0.0580s)
1384main: == [advisory_lock_connection] object_id: 229295660, pg_backend_pid: 309
1385 schedules a new batched migration
1386I, [2024-07-31T10:33:56.857625 #324] INFO -- : Database: 'main', Table: 'p_ci_build_tags': Lock Writes
1387# [RSpecRunTime] Finishing example group spec/migrations/20240619142934_queue_backfill_vulnerability_finding_signatures_project_id_spec.rb. It took 27.45 seconds. Expected to take 13.76 seconds.
1388# [RSpecRunTime] RSpec elapsed time: 18 minutes 4.61 seconds. Current RSS: ~1334M. Threads: 2. load average: 0.96 1.00 1.00 1/276 425
1389.
1390# [RSpecRunTime] Starting example group spec/migrations/20240628133958_queue_backfill_packages_debian_project_architectures_project_id_spec.rb. Expected to take 11.72 seconds.
1391QueueBackfillPackagesDebianProjectArchitecturesProjectId
1392main: == [advisory_lock_connection] object_id: 233133700, pg_backend_pid: 320
1393main: == 20240628133958 QueueBackfillPackagesDebianProjectArchitecturesProjectId: migrating
1394main: == 20240628133958 QueueBackfillPackagesDebianProjectArchitecturesProjectId: migrated (0.0560s)
1395main: == [advisory_lock_connection] object_id: 233133700, pg_backend_pid: 320
1396 schedules a new batched migration
1397I, [2024-07-31T10:34:21.044997 #324] INFO -- : Database: 'main', Table: 'p_ci_build_tags': Lock Writes
1398# [RSpecRunTime] Finishing example group spec/migrations/20240628133958_queue_backfill_packages_debian_project_architectures_project_id_spec.rb. It took 24.47 seconds. Expected to take 11.72 seconds.
1399# [RSpecRunTime] RSpec elapsed time: 18 minutes 29.13 seconds. Current RSS: ~1339M. Threads: 2. load average: 0.90 0.98 1.00 1/276 426
1400.
1401auto_explain log contains 961 entries for main, writing to /builds/gitlab-org/gitlab/auto_explain/rspec-migration-pg14-no-gitaly-transactions-6-26.324.main.ndjson.gz
1402took 21.529373487
1403auto_explain log contains 962 entries for ci, writing to /builds/gitlab-org/gitlab/auto_explain/rspec-migration-pg14-no-gitaly-transactions-6-26.324.ci.ndjson.gz
1404took 20.242398753
1405[TEST PROF INFO] EventProf results for sql.active_record
1406Total time: 11:29.553 of 18:24.615 (62.42%)
1407Total events: 549926
1408Top 5 slowest suites (by time):
1409RetryCleanupB...tsForGitlabCom (./spec/migrations/20230801150214_retry_cleanup_bigint_conversion_for_events_for_gitlab_com_spec.rb:7) – 02:18.349 (105510 / 8) of 04:27.571 (51.71%)
1410ScheduleFixin...erabilityReads (./spec/migrations/20230810124545_schedule_fixing_namespace_ids_of_vulnerability_reads_spec.rb:7) – 01:57.305 (89130 / 1) of 02:52.047 (68.18%)
1411QueueBackfill...mespaceSetting (./spec/migrations/20231107092912_queue_backfill_branch_protection_namespace_setting_spec.rb:6) – 01:36.817 (75699 / 1) of 02:18.918 (69.69%)
1412UpdateMaxCode...gsForGitlabCom (./spec/migrations/20240116211138_update_max_code_indexing_concurrency_in_application_settings_for_gitlab_com_spec.rb:6) – 01:31.019 (73670 / 4) of 02:24.446 (63.01%)
1413SwapColumnsFo...NoteMetadataId (./spec/migrations/swap_columns_for_system_note_metadata_id_spec.rb:6) – 01:20.396 (65564 / 1) of 01:56.103 (69.25%)
1414Knapsack report was generated. Preview:
1415{
1416 "spec/migrations/20230801150214_retry_cleanup_bigint_conversion_for_events_for_gitlab_com_spec.rb": 178.70407750099912,
1417 "spec/migrations/20230810124545_schedule_fixing_namespace_ids_of_vulnerability_reads_spec.rb": 86.63411704899954,
1418 "spec/migrations/20240116211138_update_max_code_indexing_concurrency_in_application_settings_for_gitlab_com_spec.rb": 83.62496680799995,
1419 "spec/migrations/20231107092912_queue_backfill_branch_protection_namespace_setting_spec.rb": 70.16458226599934,
1420 "spec/migrations/swap_columns_for_system_note_metadata_id_spec.rb": 57.20921157999874,
1421 "spec/migrations/db/post_migrate/20240423235307_swap_columns_for_p_ci_builds_project_id_spec.rb": 48.506739627999195,
1422 "spec/migrations/20240611122408_remove_project_statistics_wiki_size_and_project_id_index_spec.rb": 24.470492394999383,
1423 "spec/migrations/20240515155063_queue_backfill_design_management_designs_namespace_id_spec.rb": 23.87228102700101,
1424 "spec/migrations/20240605090456_queue_backfill_draft_notes_project_id_spec.rb": 17.68015471000035,
1425 "spec/migrations/20240619142934_queue_backfill_vulnerability_finding_signatures_project_id_spec.rb": 12.080856454998866,
1426 "spec/migrations/20240628133958_queue_backfill_packages_debian_project_architectures_project_id_spec.rb": 10.66421553300097
1427}
1428Knapsack global time execution for tests: 10m 13s
1429Finished in 19 minutes 11 seconds (files took 1 minute 32.65 seconds to load)
143025 examples, 0 failures
1431Randomized with seed 45424
1432[TEST PROF INFO] Time spent in factories: 00:00.177 (0.01% of total time)
1433RSpec exited with 0.
1434No examples to retry, congrats!
1435 Running after_script 00:09
1436Running after script...
1437$ source scripts/utils.sh
1438$ bundle exec gem list gitlab_quality-test_tooling
1439gitlab_quality-test_tooling (1.33.0)
1440$ section_start "failed-test-issues" "Report test failures" # collapsed multi-line command
1441 Report test failures 00:02
1444$ section_start "flaky-test-issues" "Report test flakiness" # collapsed multi-line command
1445 Report test flakiness 00:00
1447$ section_start "slow-test-issues" "Report test slowness" # collapsed multi-line command
1448 Report test slowness 00:02
1451$ section_start "slow-test-merge-request-report-note" "Report test slowness in MR note" # collapsed multi-line command
1452 Report test slowness in MR note 00:00
1454$ section_start "knapsack-report-issues" "Report test files close to timing out" # collapsed multi-line command
1455 Report test files close to timing out 00:02
1458$ tooling/bin/push_job_metrics || true
1459[job-metrics] Pushing job metrics file for the CI/CD job.
1460[job-metrics] Pushed 4 CI job metric entries to InfluxDB.
1461 Saving cache for successful job 00:00
1462Not uploading cache ruby-gems-debian-bookworm-ruby-3.1.5-17 due to policy
1463 Uploading artifacts for successful job 00:05
1464Uploading artifacts...
1465auto_explain/: found 3 matching artifact files and directories
1466coverage/: found 5 matching artifact files and directories
1467crystalball/: found 5 matching artifact files and directories
1468WARNING: deprecations/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab)
1469knapsack/: found 4 matching artifact files and directories
1470rspec/: found 12 matching artifact files and directories
1471WARNING: tmp/capybara/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab)
1472log/*.log: found 13 matching artifact files and directories
1473WARNING: Upload request redirected location=https://gitlab.com/api/v4/jobs/7471346370/artifacts?artifact_format=zip&artifact_type=archive&expire_in=31d new-url=https://gitlab.com
1474WARNING: Retrying... context=artifacts-uploader error=request redirected
1475Uploading artifacts as "archive" to coordinator... 201 Created id=7471346370 responseStatus=201 Created token=glcbt-66
1476Uploading artifacts...
1477rspec/rspec-*.xml: found 1 matching artifact files and directories
1478WARNING: Upload request redirected location=https://gitlab.com/api/v4/jobs/7471346370/artifacts?artifact_format=gzip&artifact_type=junit&expire_in=31d new-url=https://gitlab.com
1479WARNING: Retrying... context=artifacts-uploader error=request redirected
1480Uploading artifacts as "junit" to coordinator... 201 Created id=7471346370 responseStatus=201 Created token=glcbt-66
1481 Cleaning up project directory and file based variables 00:00
1482Job succeeded