Skip to content
Snippets Groups Projects

rspec migration pg14 4/12

Passed Started by
Vladimir Shushlin
@vshushlin
1Running with gitlab-runner 16.3.0~beta.108.g2b6048b4 (2b6048b4)
2 on blue-1.shared-gitlab-org.runners-manager.gitlab.com/default KzYhZxBv, system ID: s_e6befde69e26
3 feature flags: FF_NETWORK_PER_BUILD:true, FF_USE_FASTZIP:true, FF_USE_IMPROVED_URL_MASKING:true, FF_RESOLVE_FULL_TLS_CHAIN:false
4 Resolving secrets 00:00
5 Preparing the "docker+machine" executor 00:13
6Using Docker executor with image registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bullseye-ruby-3.0.patched-golang-1.20-rust-1.65-node-18.17-postgresql-14:rubygems-3.4-git-2.36-lfs-2.9-chrome-113-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:6c7370fd46a94d5beaed2a0304c7518e74a5759d4da3322ea9f7052507f51d80 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:1b39aac95406782d786043ec3f1772c0a3a5ce1b9ce28cf001cac9a290f366c8 ...
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:f4c047edb00d9bbfcc2b002a01548fab14592940f5b3e6b3f227f690e3fa272d 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:9a1b6b68dc464f0baae914703d5b059e7773bf23c9579c44e2a1b1154a83656f ...
17Starting service redis:6.2-alpine ...
18Pulling docker image redis:6.2-alpine ...
19Using docker image sha256:9b4dc93acb797b99419bb31d8a452680508f1bf10a8604d721c0474072417a2b for redis:6.2-alpine with digest redis@sha256:452b7655bda0e270a6376b71d22fcb30662e745dcb4728f99fa87f01287b465d ...
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-bullseye-ruby-3.0.patched-golang-1.20-rust-1.65-node-18.17-postgresql-14:rubygems-3.4-git-2.36-lfs-2.9-chrome-113-yarn-1.22-graphicsmagick-1.3.36 ...
23Using docker image sha256:d68252162deca904d1a0066983188b98dfe3f6fe8181458b0a55905e79ed85a1 for registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bullseye-ruby-3.0.patched-golang-1.20-rust-1.65-node-18.17-postgresql-14:rubygems-3.4-git-2.36-lfs-2.9-chrome-113-yarn-1.22-graphicsmagick-1.3.36 with digest registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bullseye-ruby-3.0.patched-golang-1.20-rust-1.65-node-18.17-postgresql-14@sha256:2113f34affc7e2ee40bac87419dcd7c65a94d4abfa9edb86192e1aa6a1e46590 ...
24 Preparing environment 00:00
25Running on runner-kzyhzxbv-project-278964-concurrent-0 via runner-kzyhzxbv-shared-gitlab-org-1697789448-6e055a1d...
26 Getting source from Git repository 00:27
27Fetching changes with git depth set to 20...
28Initialized empty Git repository in /builds/gitlab-org/gitlab/.git/
29Created fresh repository.
30remote: Enumerating objects: 148580, done.
31remote: Counting objects: 100% (148580/148580), done.
32remote: Compressing objects: 100% (104624/104624), done.
33remote: Total 148580 (delta 64637), reused 94927 (delta 38178), pack-reused 0
34Receiving objects: 100% (148580/148580), 135.67 MiB | 30.34 MiB/s, done.
35Resolving deltas: 100% (64637/64637), done.
36From https://us-east1-c.ci-gateway.int.gprd.gitlab.net:8989/gitlab-org/gitlab
37 * [new ref] refs/pipelines/1043537122 -> refs/pipelines/1043537122
38Checking out 537c07c6 as detached HEAD (ref is refs/merge-requests/118829/merge)...
39Skipping Git submodules setup
40$ git remote set-url origin "${CI_REPOSITORY_URL}"
41 Restoring cache 00:15
42Checking cache for ruby-gems-debian-bullseye-ruby-3.0-16...
43Downloading cache from https://storage.googleapis.com/gitlab-com-runners-cache/project/278964/ruby-gems-debian-bullseye-ruby-3.0-16
44Successfully extracted cache
45 Downloading artifacts 00:23
46Downloading artifacts for compile-test-assets (5336650410)...
47Downloading artifacts from coordinator... ok host=storage.googleapis.com id=5336650410 responseStatus=200 OK token=64_t7DrL
48Downloading artifacts for detect-tests (5336650454)...
49Downloading artifacts from coordinator... ok host=storage.googleapis.com id=5336650454 responseStatus=200 OK token=64_t7DrL
50Downloading artifacts for retrieve-tests-metadata (5336650473)...
51Downloading artifacts from coordinator... ok host=storage.googleapis.com id=5336650473 responseStatus=200 OK token=64_t7DrL
52Downloading artifacts for setup-test-env (5336650424)...
53Downloading artifacts from coordinator... ok host=storage.googleapis.com id=5336650424 responseStatus=200 OK token=64_t7DrL
54 Executing "step_script" stage of the job script 36:04
55Using docker image sha256:d68252162deca904d1a0066983188b98dfe3f6fe8181458b0a55905e79ed85a1 for registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bullseye-ruby-3.0.patched-golang-1.20-rust-1.65-node-18.17-postgresql-14:rubygems-3.4-git-2.36-lfs-2.9-chrome-113-yarn-1.22-graphicsmagick-1.3.36 with digest registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bullseye-ruby-3.0.patched-golang-1.20-rust-1.65-node-18.17-postgresql-14@sha256:2113f34affc7e2ee40bac87419dcd7c65a94d4abfa9edb86192e1aa6a1e46590 ...
56$ echo $FOSS_ONLY
57$ [ "$FOSS_ONLY" = "1" ] && rm -rf ee/ qa/spec/ee/ qa/qa/specs/features/ee/ qa/qa/ee/ qa/qa/ee.rb
58$ export GOPATH=$CI_PROJECT_DIR/.go
59$ mkdir -p $GOPATH
60$ source scripts/utils.sh
61$ source scripts/prepare_build.sh
62 Installing gems 00:18
93Using decomposed database config (config/database.yml.decomposed-postgresql)
94Geo DB won't be set up.
95Embedding DB won't be set up.
96 Setting up DBs 01:04
125$ source ./scripts/rspec_helpers.sh
126$ run_timed_command "gem install knapsack --no-document"
127$ gem install knapsack --no-document
128Successfully installed knapsack-4.0.0
1291 gem installed
130==> 'gem install knapsack --no-document' succeeded in 1 seconds.
131$ section_start "gitaly-test-spawn" "Spawning Gitaly"; scripts/gitaly-test-spawn; section_end "gitaly-test-spawn"
132 Spawning Gitaly 00:03
136$ export RSPEC_SKIPPED_TESTS_REPORT_PATH="rspec/skipped_tests-${CI_JOB_ID}.txt"
137$ export RSPEC_RETRIED_TESTS_REPORT_PATH="rspec/retried_tests-${CI_JOB_ID}.txt"
138$ tooling/bin/create_job_metrics_file || true
139[job-metrics] Creating the job metrics file for the CI/CD job.
140$ rspec_paralellized_job "--fail-fast=${RSPEC_FAIL_FAST_THRESHOLD} --tag ~quarantine --tag ~zoekt --tag ~click_house"
141RETRY_FAILED_TESTS_IN_NEW_PROCESS: true
142KNAPSACK_GENERATE_REPORT: true
143FLAKY_RSPEC_GENERATE_REPORT: true
144KNAPSACK_TEST_FILE_PATTERN: spec/{migrations}{,/**/}*_spec.rb
145KNAPSACK_LOG_LEVEL: debug
146KNAPSACK_REPORT_PATH: knapsack/rspec_migration_pg14_4_12_report.json
147FLAKY_RSPEC_SUITE_REPORT_PATH: rspec/flaky/report-suite.json
148FLAKY_RSPEC_REPORT_PATH: rspec/flaky/all_rspec_migration_pg14_4_12_report.json
149NEW_FLAKY_RSPEC_REPORT_PATH: rspec/flaky/new_rspec_migration_pg14_4_12_report.json
150RSPEC_SKIPPED_TESTS_REPORT_PATH: rspec/skipped_tests-5336650664.txt
151CRYSTALBALL:
152RSPEC_TESTS_MAPPING_ENABLED:
153RSPEC_TESTS_FILTER_FILE:
154Shell set options (set -o) enabled:
155braceexpand on
156hashall on
157interactive-comments on
158pipefail on
159Knapsack report generator started!
160/builds/gitlab-org/gitlab/ee/app/services/remote_development/service_response_factory.rb:41: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
161/builds/gitlab-org/gitlab/ee/app/services/remote_development/workspaces/create_service.rb:28: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
162/builds/gitlab-org/gitlab/ee/app/services/remote_development/workspaces/reconcile_service.rb:38: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
163/builds/gitlab-org/gitlab/ee/app/services/remote_development/workspaces/update_service.rb:28: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
164/builds/gitlab-org/gitlab/ee/lib/remote_development/agent_config/main.rb:32: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
165/builds/gitlab-org/gitlab/ee/lib/remote_development/agent_config/updater.rb:11: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
166/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/authorizer.rb:12: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
167/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/authorizer.rb:13: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
168/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/creator.rb:15: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
169/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/creator.rb:19: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
170/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/devfile_fetcher.rb:15: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
171/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/devfile_fetcher.rb:16: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
172/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/devfile_flattener.rb:12: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
173/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/editor_component_injector.rb:12: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
174/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/editor_component_injector.rb:17: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
175/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/editor_component_injector.rb:18: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
176/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/personal_access_token_creator.rb:12: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
177/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/personal_access_token_creator.rb:17: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
178/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/post_flatten_devfile_validator.rb:43: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
179/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/post_flatten_devfile_validator.rb:54: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
180/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/post_flatten_devfile_validator.rb:102: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
181/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/post_flatten_devfile_validator.rb:126: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
182/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/post_flatten_devfile_validator.rb:159: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
183/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/post_flatten_devfile_validator.rb:202: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
184/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/post_flatten_devfile_validator.rb:235: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
185/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/pre_flatten_devfile_validator.rb:24: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
186/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/pre_flatten_devfile_validator.rb:52: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
187/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/project_cloner_component_injector.rb:12: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
188/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/project_cloner_component_injector.rb:17: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
189/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/project_cloner_component_injector.rb:18: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
190/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/project_cloner_component_injector.rb:23: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
191/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/volume_component_injector.rb:12: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
192/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/volume_component_injector.rb:13: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
193/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/volume_component_injector.rb:14: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
194/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/workspace_creator.rb:15: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
195/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/workspace_creator.rb:24: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
196/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/workspace_creator.rb:25: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
197/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/workspace_creator.rb:28: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
198/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/create/workspace_variables_creator.rb:12: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
199/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/reconcile/main.rb:43: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
200/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/update/authorizer.rb:12: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
201/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/update/updater.rb:13: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
202/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/reconcile/input/agent_infos_observer.rb:15: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
203/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/reconcile/input/params_extractor.rb:14: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
204/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/reconcile/input/params_extractor.rb:16: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
205/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/reconcile/input/params_to_infos_converter.rb:14: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
206/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/reconcile/input/params_validator.rb:15: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
207/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/reconcile/output/rails_infos_observer.rb:11: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
208/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/reconcile/output/workspaces_to_rails_infos_converter.rb:15: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
209/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/reconcile/persistence/orphaned_workspaces_observer.rb:12: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
210/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/reconcile/persistence/workspaces_from_agent_infos_updater.rb:15: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
211/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/reconcile/persistence/workspaces_to_be_returned_finder.rb:16: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
212/builds/gitlab-org/gitlab/ee/lib/remote_development/workspaces/reconcile/persistence/workspaces_to_be_returned_updater.rb:11: warning: One-line pattern matching is experimental, and the behavior may change in future versions of Ruby!
213Run options: exclude {:quarantine=>true, :zoekt=>true, :click_house=>true}
214Test environment set up in 0.892237026 seconds
215FinalizeCiBuildNeedsBigIntConversion
216 # order random
217 #up
218 dot_com: true, dev_or_test: true, jh: true, expectation: :not_to
219ci: == [advisory_lock_connection] object_id: 33551460, pg_backend_pid: 1377
220ci: == 20230214181633 FinalizeCiBuildNeedsBigIntConversion: migrating =============
221ci: == 20230214181633 FinalizeCiBuildNeedsBigIntConversion: migrated (0.0314s) ====
222ci: == [advisory_lock_connection] object_id: 33551460, pg_backend_pid: 1377
223 ensures the migration is completed for GitLab.com, dev, or test
224 dot_com: true, dev_or_test: false, jh: true, expectation: :not_to
225ci: == [advisory_lock_connection] object_id: 34679020, pg_backend_pid: 1383
226ci: == 20230214181633 FinalizeCiBuildNeedsBigIntConversion: migrating =============
227ci: == 20230214181633 FinalizeCiBuildNeedsBigIntConversion: migrated (0.0297s) ====
228ci: == [advisory_lock_connection] object_id: 34679020, pg_backend_pid: 1383
229 ensures the migration is completed for GitLab.com, dev, or test
230 dot_com: false, dev_or_test: true, jh: true, expectation: :not_to
231ci: == [advisory_lock_connection] object_id: 35194180, pg_backend_pid: 1389
232ci: == 20230214181633 FinalizeCiBuildNeedsBigIntConversion: migrating =============
233ci: == 20230214181633 FinalizeCiBuildNeedsBigIntConversion: migrated (0.0261s) ====
234ci: == [advisory_lock_connection] object_id: 35194180, pg_backend_pid: 1389
235 ensures the migration is completed for GitLab.com, dev, or test
236 dot_com: false, dev_or_test: false, jh: true, expectation: :not_to
237ci: == [advisory_lock_connection] object_id: 35454480, pg_backend_pid: 1396
238ci: == 20230214181633 FinalizeCiBuildNeedsBigIntConversion: migrating =============
239ci: == 20230214181633 FinalizeCiBuildNeedsBigIntConversion: migrated (0.0289s) ====
240ci: == [advisory_lock_connection] object_id: 35454480, pg_backend_pid: 1396
241 ensures the migration is completed for GitLab.com, dev, or test
242 dot_com: true, dev_or_test: true, jh: false, expectation: :to
243ci: == [advisory_lock_connection] object_id: 35732520, pg_backend_pid: 1402
244ci: == 20230214181633 FinalizeCiBuildNeedsBigIntConversion: migrating =============
245ci: == 20230214181633 FinalizeCiBuildNeedsBigIntConversion: migrated (0.0235s) ====
246ci: == [advisory_lock_connection] object_id: 35732520, pg_backend_pid: 1402
247 ensures the migration is completed for GitLab.com, dev, or test
248 dot_com: true, dev_or_test: false, jh: false, expectation: :to
249ci: == [advisory_lock_connection] object_id: 36017260, pg_backend_pid: 1408
250ci: == 20230214181633 FinalizeCiBuildNeedsBigIntConversion: migrating =============
251ci: == 20230214181633 FinalizeCiBuildNeedsBigIntConversion: migrated (0.0240s) ====
252ci: == [advisory_lock_connection] object_id: 36017260, pg_backend_pid: 1408
253 ensures the migration is completed for GitLab.com, dev, or test
254 dot_com: false, dev_or_test: true, jh: false, expectation: :to
255ci: == [advisory_lock_connection] object_id: 36300760, pg_backend_pid: 1414
256ci: == 20230214181633 FinalizeCiBuildNeedsBigIntConversion: migrating =============
257ci: == 20230214181633 FinalizeCiBuildNeedsBigIntConversion: migrated (0.0278s) ====
258ci: == [advisory_lock_connection] object_id: 36300760, pg_backend_pid: 1414
259 ensures the migration is completed for GitLab.com, dev, or test
260 dot_com: false, dev_or_test: false, jh: false, expectation: :not_to
261ci: == [advisory_lock_connection] object_id: 36580000, pg_backend_pid: 1420
262ci: == 20230214181633 FinalizeCiBuildNeedsBigIntConversion: migrating =============
263ci: == 20230214181633 FinalizeCiBuildNeedsBigIntConversion: migrated (0.0248s) ====
264ci: == [advisory_lock_connection] object_id: 36580000, pg_backend_pid: 1420
265 ensures the migration is completed for GitLab.com, dev, or test
266I, [2023-10-20T08:31:47.698553 #329] INFO -- : Database: 'main', Table: 'p_ci_runner_machine_builds': Lock Writes
267I, [2023-10-20T08:31:48.056497 #329] INFO -- : Database: 'main', Table: 'ci_cost_settings': Lock Writes
268I, [2023-10-20T08:32:01.784710 #329] INFO -- : Database: 'main', Table: 'ci_editor_ai_conversation_messages': Lock Writes
269I, [2023-10-20T08:32:05.524712 #329] INFO -- : Database: 'main', Table: 'p_ci_builds': Lock Writes
270I, [2023-10-20T08:32:05.525883 #329] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
271I, [2023-10-20T08:32:05.526714 #329] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
272I, [2023-10-20T08:32:20.782328 #329] INFO -- : Database: 'main', Table: 'p_ci_job_annotations': Lock Writes
273INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
274INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
275INFO: "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
276INFO: analyzing "public.p_ci_job_annotations" inheritance tree
277INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
278INFO: "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
279INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
280INFO: analyzing "public.ci_builds_metadata"
281INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
282INFO: analyzing "public.p_ci_builds" inheritance tree
283INFO: analyzing "public.ci_builds"
284INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
285I, [2023-10-20T08:32:46.687800 #329] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes
286I, [2023-10-20T08:32:55.539680 #329] INFO -- : Database: 'ci', Table: 'catalog_resources': Lock Writes
287I, [2023-10-20T08:32:58.248168 #329] INFO -- : Database: 'ci', Table: 'design_management_repositories': Lock Writes
288I, [2023-10-20T08:32:58.810174 #329] INFO -- : Database: 'ci', Table: 'container_registry_data_repair_details': Lock Writes
289I, [2023-10-20T08:32:59.318715 #329] INFO -- : Database: 'ci', Table: 'search_indices': Lock Writes
290I, [2023-10-20T08:32:59.357528 #329] INFO -- : Database: 'ci', Table: 'search_namespace_index_assignments': Lock Writes
291I, [2023-10-20T08:32:59.442787 #329] INFO -- : Database: 'ci', Table: 'resource_link_events': Lock Writes
292I, [2023-10-20T08:32:59.776952 #329] INFO -- : Database: 'ci', Table: 'packages_npm_metadata_caches': Lock Writes
293I, [2023-10-20T08:33:00.204762 #329] INFO -- : Database: 'ci', Table: 'service_desk_custom_email_credentials': Lock Writes
294I, [2023-10-20T08:33:02.352330 #329] INFO -- : Database: 'ci', Table: 'design_management_repository_states': Lock Writes
295I, [2023-10-20T08:33:02.829853 #329] INFO -- : Database: 'ci', Table: 'dora_performance_scores': Lock Writes
296I, [2023-10-20T08:33:07.988878 #329] INFO -- : Database: 'ci', Table: 'audit_events_instance_external_audit_event_destinations': Lock Writes
297I, [2023-10-20T08:33:08.174821 #329] INFO -- : Database: 'ci', Table: 'agent_user_access_project_authorizations': Lock Writes
298I, [2023-10-20T08:33:08.202714 #329] INFO -- : Database: 'ci', Table: 'agent_user_access_group_authorizations': Lock Writes
299I, [2023-10-20T08:33:08.563233 #329] INFO -- : Database: 'ci', Table: 'abuse_trust_scores': Lock Writes
300I, [2023-10-20T08:33:08.598379 #329] INFO -- : Database: 'ci', Table: 'pm_advisories': Lock Writes
301I, [2023-10-20T08:33:08.600458 #329] INFO -- : Database: 'ci', Table: 'pm_affected_packages': Lock Writes
302I, [2023-10-20T08:33:08.650374 #329] INFO -- : Database: 'ci', Table: 'issue_assignment_events': Lock Writes
303I, [2023-10-20T08:33:09.736773 #329] INFO -- : Database: 'ci', Table: 'merge_request_assignment_events': Lock Writes
304I, [2023-10-20T08:33:10.254355 #329] INFO -- : Database: 'ci', Table: 'project_states': Lock Writes
305I, [2023-10-20T08:33:11.928516 #329] INFO -- : Database: 'ci', Table: 'organizations': Lock Writes
306I, [2023-10-20T08:33:12.357038 #329] INFO -- : Database: 'ci', Table: 'value_stream_dashboard_counts': Lock Writes
307I, [2023-10-20T08:33:12.470075 #329] INFO -- : Database: 'ci', Table: 'note_metadata': Lock Writes
308I, [2023-10-20T08:33:12.861620 #329] INFO -- : Database: 'ci', Table: 'merge_request_diff_llm_summaries': Lock Writes
309I, [2023-10-20T08:33:13.293802 #329] INFO -- : Database: 'ci', Table: 'value_stream_dashboard_aggregations': Lock Writes
310I, [2023-10-20T08:33:13.492673 #329] INFO -- : Database: 'ci', Table: 'abuse_report_events': Lock Writes
311I, [2023-10-20T08:33:14.603586 #329] INFO -- : Database: 'ci', Table: 'audit_events_google_cloud_logging_configurations': Lock Writes
312I, [2023-10-20T08:33:17.511044 #329] INFO -- : Database: 'ci', Table: 'dependency_proxy_packages_settings': Lock Writes
313I, [2023-10-20T08:33:17.512445 #329] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
314I, [2023-10-20T08:33:17.513621 #329] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
315I, [2023-10-20T08:33:17.615279 #329] INFO -- : Database: 'ci', Table: 'instance_audit_events_streaming_headers': Lock Writes
316I, [2023-10-20T08:33:18.983868 #329] INFO -- : Database: 'ci', Table: 'abuse_events': Lock Writes
317I, [2023-10-20T08:33:30.413814 #329] INFO -- : Database: 'ci', Table: 'subscription_add_ons': Lock Writes
318I, [2023-10-20T08:33:30.446659 #329] INFO -- : Database: 'ci', Table: 'subscription_add_on_purchases': Lock Writes
319I, [2023-10-20T08:33:30.767201 #329] INFO -- : Database: 'ci', Table: 'project_compliance_standards_adherence': Lock Writes
320I, [2023-10-20T08:33:33.072610 #329] INFO -- : Database: 'ci', Table: 'organization_settings': Lock Writes
321I, [2023-10-20T08:33:33.362716 #329] INFO -- : Database: 'ci', Table: 'organization_users': Lock Writes
322I, [2023-10-20T08:33:33.977753 #329] INFO -- : Database: 'ci', Table: 'audit_events_streaming_instance_event_type_filters': Lock Writes
323I, [2023-10-20T08:33:36.448422 #329] INFO -- : Database: 'ci', Table: 'subscription_user_add_on_assignments': Lock Writes
324I, [2023-10-20T08:33:36.596518 #329] INFO -- : Database: 'ci', Table: 'system_access_microsoft_applications': Lock Writes
325I, [2023-10-20T08:33:36.629947 #329] INFO -- : Database: 'ci', Table: 'system_access_microsoft_graph_access_tokens': Lock Writes
326I, [2023-10-20T08:33:38.027507 #329] INFO -- : Database: 'ci', Table: 'merge_request_review_llm_summaries': Lock Writes
327I, [2023-10-20T08:33:38.885516 #329] INFO -- : Database: 'ci', Table: 'catalog_resource_versions': Lock Writes
328I, [2023-10-20T08:33:40.263447 #329] INFO -- : Database: 'ci', Table: 'p_batched_git_ref_updates_deletions': Lock Writes
329I, [2023-10-20T08:33:40.292686 #329] INFO -- : Database: 'ci', Table: 'service_access_tokens': Lock Writes
330I, [2023-10-20T08:33:40.321796 #329] INFO -- : Database: 'ci', Table: 'ml_models': Lock Writes
331I, [2023-10-20T08:33:40.955318 #329] INFO -- : Database: 'ci', Table: 'ml_model_versions': Lock Writes
332I, [2023-10-20T08:33:43.478713 #329] INFO -- : Database: 'ci', Table: 'group_ssh_certificates': Lock Writes
333I, [2023-10-20T08:33:43.672677 #329] INFO -- : Database: 'ci', Table: 'group_wiki_repository_states': Lock Writes
334I, [2023-10-20T08:33:44.011263 #329] INFO -- : Database: 'ci', Table: 'target_branch_rules': Lock Writes
335I, [2023-10-20T08:33:48.237598 #329] INFO -- : Database: 'ci', Table: 'catalog_resource_components': Lock Writes
336I, [2023-10-20T08:34:00.067086 #329] INFO -- : Database: 'ci', Table: 'workspace_variables': Lock Writes
337I, [2023-10-20T08:34:00.284967 #329] INFO -- : Database: 'ci', Table: 'packages_nuget_symbols': Lock Writes
338I, [2023-10-20T08:34:00.738698 #329] INFO -- : Database: 'ci', Table: 'audit_events_instance_google_cloud_logging_configurations': Lock Writes
339I, [2023-10-20T08:34:02.398668 #329] INFO -- : Database: 'ci', Table: 'packages_protection_rules': Lock Writes
340I, [2023-10-20T08:34:02.826244 #329] INFO -- : Database: 'ci', Table: 'projects_visits': Lock Writes
341I, [2023-10-20T08:34:02.856167 #329] INFO -- : Database: 'ci', Table: 'groups_visits': Lock Writes
342I, [2023-10-20T08:34:02.891418 #329] INFO -- : Database: 'ci', Table: 'audit_events_amazon_s3_configurations': Lock Writes
343INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
344INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
345INFO: "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
346INFO: analyzing "public.p_ci_job_annotations" inheritance tree
347INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
348INFO: "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
349INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
350INFO: analyzing "public.ci_builds_metadata"
351INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
352INFO: analyzing "public.p_ci_builds" inheritance tree
353INFO: analyzing "public.ci_builds"
354INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
355I, [2023-10-20T08:34:03.943722 #329] INFO -- : Database: 'ci', Table: 'vs_code_settings': Lock Writes
356I, [2023-10-20T08:34:04.678907 #329] INFO -- : Database: 'ci', Table: 'scan_result_policy_violations': Lock Writes
357I, [2023-10-20T08:34:06.186502 #329] INFO -- : Database: 'ci', Table: 'analytics_cycle_analytics_value_stream_settings': Lock Writes
358I, [2023-10-20T08:34:08.586127 #329] INFO -- : Database: 'ci', Table: 'work_item_related_link_restrictions': Lock Writes
359I, [2023-10-20T08:34:08.781632 #329] INFO -- : Database: 'ci', Table: 'abuse_report_user_mentions': Lock Writes
360I, [2023-10-20T08:34:09.280348 #329] INFO -- : Database: 'ci', Table: 'container_registry_protection_rules': Lock Writes
361I, [2023-10-20T08:34:10.843276 #329] INFO -- : Database: 'ci', Table: 'activity_pub_releases_subscriptions': Lock Writes
362FinalizeBackfillEnvironmentTierMigration
363 # order random
364 #up
365 when migration is missing
366main: == [advisory_lock_connection] object_id: 67992280, pg_backend_pid: 2675
367main: == 20230201171450 FinalizeBackfillEnvironmentTierMigration: migrating =========
368main: == 20230201171450 FinalizeBackfillEnvironmentTierMigration: migrated (0.0193s)
369main: == [advisory_lock_connection] object_id: 67992280, pg_backend_pid: 2675
370 warns migration not found
371 with migration present
372 when migration finished successfully
373main: == [advisory_lock_connection] object_id: 68760940, pg_backend_pid: 2677
374main: == 20230201171450 FinalizeBackfillEnvironmentTierMigration: migrating =========
375main: == 20230201171450 FinalizeBackfillEnvironmentTierMigration: migrated (0.0266s)
376main: == [advisory_lock_connection] object_id: 68760940, pg_backend_pid: 2677
377 does not raise exception
378 with different migration statuses
379 status: 0, description: "paused"
380 behaves like finalizes the migration
381 finalizes the migration
382 status: 1, description: "active"
383 behaves like finalizes the migration
384 finalizes the migration
385 status: 4, description: "failed"
386 behaves like finalizes the migration
387 finalizes the migration
388 status: 5, description: "finalizing"
389 behaves like finalizes the migration
390 finalizes the migration
391I, [2023-10-20T08:35:21.762221 #329] INFO -- : Database: 'main', Table: 'p_ci_runner_machine_builds': Lock Writes
392I, [2023-10-20T08:35:22.096176 #329] INFO -- : Database: 'main', Table: 'ci_cost_settings': Lock Writes
393I, [2023-10-20T08:35:34.924525 #329] INFO -- : Database: 'main', Table: 'ci_editor_ai_conversation_messages': Lock Writes
394I, [2023-10-20T08:35:38.575783 #329] INFO -- : Database: 'main', Table: 'p_ci_builds': Lock Writes
395I, [2023-10-20T08:35:38.577044 #329] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
396I, [2023-10-20T08:35:38.577936 #329] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
397I, [2023-10-20T08:35:53.113405 #329] INFO -- : Database: 'main', Table: 'p_ci_job_annotations': Lock Writes
398INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
399INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
400INFO: "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
401INFO: analyzing "public.p_ci_job_annotations" inheritance tree
402INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
403INFO: "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
404INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
405INFO: analyzing "public.ci_builds_metadata"
406INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
407INFO: analyzing "public.p_ci_builds" inheritance tree
408INFO: analyzing "public.ci_builds"
409INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
410I, [2023-10-20T08:36:19.869235 #329] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes
411BumpDefaultPartitionIdValueForCiTables
412 # order random
413 when self-managed
414main: == [advisory_lock_connection] object_id: 91438160, pg_backend_pid: 2697
415main: == 20221220131020 BumpDefaultPartitionIdValueForCiTables: migrating ===========
416main: == 20221220131020 BumpDefaultPartitionIdValueForCiTables: migrated (0.0096s) ==
417main: == [advisory_lock_connection] object_id: 91438160, pg_backend_pid: 2697
418 does not change default values
419 when on sass
420main: == [advisory_lock_connection] object_id: 92260980, pg_backend_pid: 2700
421main: == 20221220131020 BumpDefaultPartitionIdValueForCiTables: migrating ===========
422main: -- change_column_default(:ci_build_needs, :partition_id, {:from=>100, :to=>101})
423main: -> 0.0063s
424main: -- change_column_default(:ci_build_pending_states, :partition_id, {:from=>100, :to=>101})
425main: -> 0.0063s
426main: -- change_column_default(:ci_build_report_results, :partition_id, {:from=>100, :to=>101})
427main: -> 0.0062s
428main: -- change_column_default(:ci_build_trace_chunks, :partition_id, {:from=>100, :to=>101})
429main: -> 0.0065s
430main: -- change_column_default(:ci_build_trace_metadata, :partition_id, {:from=>100, :to=>101})
431main: -> 0.0064s
432main: -- change_column_default(:ci_builds, :partition_id, {:from=>100, :to=>101})
433main: -> 0.0092s
434main: -- change_column_default(:ci_builds_runner_session, :partition_id, {:from=>100, :to=>101})
435main: -> 0.0062s
436main: -- change_column_default(:ci_job_artifacts, :partition_id, {:from=>100, :to=>101})
437main: -> 0.0087s
438main: -- change_column_default(:ci_job_variables, :partition_id, {:from=>100, :to=>101})
439main: -> 0.0049s
440main: -- change_column_default(:ci_pending_builds, :partition_id, {:from=>100, :to=>101})
441main: -> 0.0047s
442main: -- change_column_default(:ci_pipeline_variables, :partition_id, {:from=>100, :to=>101})
443main: -> 0.0046s
444main: -- change_column_default(:ci_pipelines, :partition_id, {:from=>100, :to=>101})
445main: -> 0.0059s
446main: -- change_column_default(:ci_running_builds, :partition_id, {:from=>100, :to=>101})
447main: -> 0.0044s
448main: -- change_column_default(:ci_sources_pipelines, :partition_id, {:from=>100, :to=>101})
449main: -> 0.0050s
450main: -- change_column_default(:ci_sources_pipelines, :source_partition_id, {:from=>100, :to=>101})
451main: -> 0.0046s
452main: -- change_column_default(:ci_stages, :partition_id, {:from=>100, :to=>101})
453main: -> 0.0048s
454main: -- change_column_default(:ci_unit_test_failures, :partition_id, {:from=>100, :to=>101})
455main: -> 0.0050s
456main: -- change_column_default(:p_ci_builds_metadata, :partition_id, {:from=>100, :to=>101})
457main: -> 0.0063s
458main: == 20221220131020 BumpDefaultPartitionIdValueForCiTables: migrated (0.2786s) ==
459main: == [advisory_lock_connection] object_id: 92260980, pg_backend_pid: 2700
460 changes default values
461 with tables already changed
462main: == [advisory_lock_connection] object_id: 93085200, pg_backend_pid: 2703
463main: == 20221220131020 BumpDefaultPartitionIdValueForCiTables: migrating ===========
464main: -- change_column_default(:ci_build_needs, :partition_id, {:from=>100, :to=>101})
465main: -> 0.0058s
466main: -- change_column_default(:ci_build_pending_states, :partition_id, {:from=>100, :to=>101})
467main: -> 0.0046s
468main: -- change_column_default(:ci_build_report_results, :partition_id, {:from=>100, :to=>101})
469main: -> 0.0043s
470main: -- change_column_default(:ci_build_trace_chunks, :partition_id, {:from=>100, :to=>101})
471main: -> 0.0047s
472main: -- change_column_default(:ci_build_trace_metadata, :partition_id, {:from=>100, :to=>101})
473main: -> 0.0051s
474main: -- change_column_default(:ci_builds_runner_session, :partition_id, {:from=>100, :to=>101})
475main: -> 0.0058s
476main: -- change_column_default(:ci_job_artifacts, :partition_id, {:from=>100, :to=>101})
477main: -> 0.0062s
478main: -- change_column_default(:ci_job_variables, :partition_id, {:from=>100, :to=>101})
479main: -> 0.0061s
480main: -- change_column_default(:ci_pending_builds, :partition_id, {:from=>100, :to=>101})
481main: -> 0.0051s
482main: -- change_column_default(:ci_pipeline_variables, :partition_id, {:from=>100, :to=>101})
483main: -> 0.0051s
484main: -- change_column_default(:ci_pipelines, :partition_id, {:from=>100, :to=>101})
485main: -> 0.0061s
486main: -- change_column_default(:ci_running_builds, :partition_id, {:from=>100, :to=>101})
487main: -> 0.0048s
488main: -- change_column_default(:ci_sources_pipelines, :partition_id, {:from=>100, :to=>101})
489main: -> 0.0047s
490main: -- change_column_default(:ci_sources_pipelines, :source_partition_id, {:from=>100, :to=>101})
491main: -> 0.0049s
492main: -- change_column_default(:ci_stages, :partition_id, {:from=>100, :to=>101})
493main: -> 0.0054s
494main: -- change_column_default(:ci_unit_test_failures, :partition_id, {:from=>100, :to=>101})
495main: -> 0.0051s
496main: -- change_column_default(:p_ci_builds_metadata, :partition_id, {:from=>100, :to=>101})
497main: -> 0.0055s
498main: == 20221220131020 BumpDefaultPartitionIdValueForCiTables: migrated (0.2419s) ==
499main: == [advisory_lock_connection] object_id: 93085200, pg_backend_pid: 2703
500 skips updating already changed tables
501I, [2023-10-20T08:37:37.570536 #329] INFO -- : Database: 'main', Table: 'ci_runner_machines': Lock Writes
502I, [2023-10-20T08:37:45.013528 #329] INFO -- : Database: 'main', Table: 'p_ci_runner_machine_builds': Lock Writes
503I, [2023-10-20T08:37:45.297532 #329] INFO -- : Database: 'main', Table: 'ci_cost_settings': Lock Writes
504I, [2023-10-20T08:37:58.072634 #329] INFO -- : Database: 'main', Table: 'ci_editor_ai_conversation_messages': Lock Writes
505I, [2023-10-20T08:38:01.554911 #329] INFO -- : Database: 'main', Table: 'p_ci_builds': Lock Writes
506I, [2023-10-20T08:38:01.556227 #329] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
507I, [2023-10-20T08:38:01.557182 #329] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
508I, [2023-10-20T08:38:17.138536 #329] INFO -- : Database: 'main', Table: 'p_ci_job_annotations': Lock Writes
509INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
510INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
511INFO: "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
512INFO: analyzing "public.p_ci_job_annotations" inheritance tree
513INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
514INFO: "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
515INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
516INFO: analyzing "public.ci_builds_metadata"
517INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
518INFO: analyzing "public.p_ci_builds" inheritance tree
519INFO: analyzing "public.ci_builds"
520INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
521I, [2023-10-20T08:38:43.387144 #329] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes
522SchedulePruneStaleProjectExportJobs
523 # order random
524main: == [advisory_lock_connection] object_id: 117282180, pg_backend_pid: 2719
525main: == 20221122132812 SchedulePruneStaleProjectExportJobs: migrating ==============
526main: == 20221122132812 SchedulePruneStaleProjectExportJobs: migrated (0.0661s) =====
527main: == [advisory_lock_connection] object_id: 117282180, pg_backend_pid: 2719
528 schedules a new batched migration
529I, [2023-10-20T08:39:58.903095 #329] INFO -- : Database: 'main', Table: 'ci_runner_machines': Lock Writes
530I, [2023-10-20T08:40:06.590050 #329] INFO -- : Database: 'main', Table: 'p_ci_runner_machine_builds': Lock Writes
531I, [2023-10-20T08:40:06.877586 #329] INFO -- : Database: 'main', Table: 'ci_cost_settings': Lock Writes
532I, [2023-10-20T08:40:19.891311 #329] INFO -- : Database: 'main', Table: 'ci_editor_ai_conversation_messages': Lock Writes
533I, [2023-10-20T08:40:24.441041 #329] INFO -- : Database: 'main', Table: 'p_ci_builds': Lock Writes
534I, [2023-10-20T08:40:24.442316 #329] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
535I, [2023-10-20T08:40:24.443210 #329] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
536I, [2023-10-20T08:40:39.412690 #329] INFO -- : Database: 'main', Table: 'p_ci_job_annotations': Lock Writes
537INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
538INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
539INFO: "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
540INFO: analyzing "public.p_ci_job_annotations" inheritance tree
541INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
542INFO: "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
543INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
544INFO: analyzing "public.ci_builds_metadata"
545INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
546INFO: analyzing "public.p_ci_builds" inheritance tree
547INFO: analyzing "public.ci_builds"
548INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
549I, [2023-10-20T08:41:06.061044 #329] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes
550ScheduleMigrationForLinks
551 # order random
552 #up
553main: == [advisory_lock_connection] object_id: 140435820, pg_backend_pid: 2736
554main: == 20230208125736 ScheduleMigrationForLinks: migrating ========================
555main: == 20230208125736 ScheduleMigrationForLinks: migrated (0.0095s) ===============
556main: == [advisory_lock_connection] object_id: 140435820, pg_backend_pid: 2736
557 schedules a batched background migration
558 #down
559main: == [advisory_lock_connection] object_id: 141246060, pg_backend_pid: 2738
560main: == 20230208125736 ScheduleMigrationForLinks: migrating ========================
561main: == 20230208125736 ScheduleMigrationForLinks: migrated (0.0082s) ===============
562main: == [advisory_lock_connection] object_id: 141246060, pg_backend_pid: 2738
563 deletes all batched migration records
564I, [2023-10-20T08:42:14.724844 #329] INFO -- : Database: 'main', Table: 'p_ci_runner_machine_builds': Lock Writes
565I, [2023-10-20T08:42:15.006114 #329] INFO -- : Database: 'main', Table: 'ci_cost_settings': Lock Writes
566I, [2023-10-20T08:42:27.497930 #329] INFO -- : Database: 'main', Table: 'ci_editor_ai_conversation_messages': Lock Writes
567I, [2023-10-20T08:42:32.276033 #329] INFO -- : Database: 'main', Table: 'p_ci_builds': Lock Writes
568I, [2023-10-20T08:42:32.277135 #329] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
569I, [2023-10-20T08:42:32.277838 #329] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
570I, [2023-10-20T08:42:47.344607 #329] INFO -- : Database: 'main', Table: 'p_ci_job_annotations': Lock Writes
571INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
572INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
573INFO: "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
574INFO: analyzing "public.p_ci_job_annotations" inheritance tree
575INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
576INFO: "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
577INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
578INFO: analyzing "public.ci_builds_metadata"
579INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
580INFO: analyzing "public.p_ci_builds" inheritance tree
581INFO: analyzing "public.ci_builds"
582INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
583I, [2023-10-20T08:43:14.476344 #329] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes
584EnsureIncidentWorkItemTypeBackfillIsFinished
585 # order random
586 #up
587main: == [advisory_lock_connection] object_id: 158148800, pg_backend_pid: 2754
588main: == 20230522220709 EnsureIncidentWorkItemTypeBackfillIsFinished: migrating =====
589main: -- Incident work item type not found. Make sure the work_item_types table is populatedbefore running this migration
590main: == 20230522220709 EnsureIncidentWorkItemTypeBackfillIsFinished: migrated (0.0195s)
591main: == [advisory_lock_connection] object_id: 158148800, pg_backend_pid: 2754
592 doesn't fail if work item types don't exist on the DB
593 when migration is missing
594main: == [advisory_lock_connection] object_id: 158896320, pg_backend_pid: 2756
595main: == 20230522220709 EnsureIncidentWorkItemTypeBackfillIsFinished: migrating =====
596main: == 20230522220709 EnsureIncidentWorkItemTypeBackfillIsFinished: migrated (0.0273s)
597main: == [advisory_lock_connection] object_id: 158896320, pg_backend_pid: 2756
598 warns migration not found
599 with migration present
600 when migrations have finished
601main: == [advisory_lock_connection] object_id: 159228940, pg_backend_pid: 2758
602main: == 20230522220709 EnsureIncidentWorkItemTypeBackfillIsFinished: migrating =====
603main: == 20230522220709 EnsureIncidentWorkItemTypeBackfillIsFinished: migrated (0.0332s)
604main: == [advisory_lock_connection] object_id: 159228940, pg_backend_pid: 2758
605 does not raise an error
606 with different migration statuses
607 status: 0, description: "paused"
608main: == [advisory_lock_connection] object_id: 159529000, pg_backend_pid: 2760
609main: == 20230522220709 EnsureIncidentWorkItemTypeBackfillIsFinished: migrating =====
610main: == 20230522220709 EnsureIncidentWorkItemTypeBackfillIsFinished: migrated (0.2195s)
611main: == [advisory_lock_connection] object_id: 159529000, pg_backend_pid: 2760
612 finalizes the migration
613 status: 1, description: "active"
614main: == [advisory_lock_connection] object_id: 159843700, pg_backend_pid: 2762
615main: == 20230522220709 EnsureIncidentWorkItemTypeBackfillIsFinished: migrating =====
616main: == 20230522220709 EnsureIncidentWorkItemTypeBackfillIsFinished: migrated (0.2569s)
617main: == [advisory_lock_connection] object_id: 159843700, pg_backend_pid: 2762
618 finalizes the migration
619 status: 4, description: "failed"
620main: == [advisory_lock_connection] object_id: 160226920, pg_backend_pid: 2765
621main: == 20230522220709 EnsureIncidentWorkItemTypeBackfillIsFinished: migrating =====
622main: == 20230522220709 EnsureIncidentWorkItemTypeBackfillIsFinished: migrated (0.2492s)
623main: == [advisory_lock_connection] object_id: 160226920, pg_backend_pid: 2765
624 finalizes the migration
625 status: 5, description: "finalizing"
626main: == [advisory_lock_connection] object_id: 160609980, pg_backend_pid: 2767
627main: == 20230522220709 EnsureIncidentWorkItemTypeBackfillIsFinished: migrating =====
628main: == 20230522220709 EnsureIncidentWorkItemTypeBackfillIsFinished: migrated (0.2111s)
629main: == [advisory_lock_connection] object_id: 160609980, pg_backend_pid: 2767
630 finalizes the migration
631I, [2023-10-20T08:44:36.293469 #329] INFO -- : Database: 'main', Table: 'p_ci_job_annotations': Lock Writes
632INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
633INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
634INFO: "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
635INFO: analyzing "public.p_ci_job_annotations" inheritance tree
636INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
637INFO: "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
638INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
639INFO: analyzing "public.ci_builds_metadata"
640INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
641INFO: analyzing "public.p_ci_builds" inheritance tree
642INFO: analyzing "public.ci_builds"
643INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
644I, [2023-10-20T08:45:03.874956 #329] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes
645BackfillProductAnalyticsDataCollectorHost
646 # order random
647 #up
648 when jitsu host is present
649main: == [advisory_lock_connection] object_id: 175411160, pg_backend_pid: 2781
650main: == 20230327123333 BackfillProductAnalyticsDataCollectorHost: migrating ========
651main: -- execute("UPDATE application_settings\nSET product_analytics_data_collector_host = regexp_replace(jitsu_host, '://(.+?\\.)', '://collector.', 'g')\nWHERE jitsu_host IS NOT NULL AND product_analytics_data_collector_host IS NULL\n")
652main: -> 0.0039s
653main: == 20230327123333 BackfillProductAnalyticsDataCollectorHost: migrated (0.0143s)
654main: == [advisory_lock_connection] object_id: 175411160, pg_backend_pid: 2781
655 backfills missing product_analytics_data_collector_host
656main: == [advisory_lock_connection] object_id: 175939160, pg_backend_pid: 2783
657main: == 20230327123333 BackfillProductAnalyticsDataCollectorHost: migrating ========
658main: -- execute("UPDATE application_settings\nSET product_analytics_data_collector_host = regexp_replace(jitsu_host, '://(.+?\\.)', '://collector.', 'g')\nWHERE jitsu_host IS NOT NULL AND product_analytics_data_collector_host IS NULL\n")
659main: -> 0.0042s
660main: == 20230327123333 BackfillProductAnalyticsDataCollectorHost: migrated (0.0151s)
661main: == [advisory_lock_connection] object_id: 175939160, pg_backend_pid: 2783
662 does not modify existing product_analytics_data_collector_host
663 when jitsu host is not present
664main: == [advisory_lock_connection] object_id: 176231040, pg_backend_pid: 2785
665main: == 20230327123333 BackfillProductAnalyticsDataCollectorHost: migrating ========
666main: -- execute("UPDATE application_settings\nSET product_analytics_data_collector_host = regexp_replace(jitsu_host, '://(.+?\\.)', '://collector.', 'g')\nWHERE jitsu_host IS NOT NULL AND product_analytics_data_collector_host IS NULL\n")
667main: -> 0.0036s
668main: == 20230327123333 BackfillProductAnalyticsDataCollectorHost: migrated (0.0136s)
669main: == [advisory_lock_connection] object_id: 176231040, pg_backend_pid: 2785
670 does not backfill product_analytics_data_collector_host
671The application_settings (main) table has 1240 columns.
672Recreating the database
673Dropped database 'gitlabhq_test'
674Dropped database 'gitlabhq_test_ci'
675Created database 'gitlabhq_test'
676Created database 'gitlabhq_test_ci'
677main: == [advisory_lock_connection] object_id: 176496080, pg_backend_pid: 2796
678main: == [advisory_lock_connection] object_id: 176496080, pg_backend_pid: 2796
679ci: == [advisory_lock_connection] object_id: 176497880, pg_backend_pid: 2798
680ci: == [advisory_lock_connection] object_id: 176497880, pg_backend_pid: 2798
681Databases re-creation done in 14.212383951999982
682AddProjectIdNameIdVersionIndexToInstallableNpmPackages
683 # order random
684main: == [advisory_lock_connection] object_id: 184651860, pg_backend_pid: 2805
685main: == 20230131125844 AddProjectIdNameIdVersionIndexToInstallableNpmPackages: migrating
686main: -- view_exists?(:postgres_partitions)
687main: -> 0.0021s
688main: -- index_exists?(:packages_packages, [:project_id, :name, :id, :version], {:name=>"idx_packages_on_project_id_name_id_version_when_installable_npm", :where=>"package_type = 2 AND status IN (0, 1)", :algorithm=>:concurrently})
689main: -> 0.0218s
690main: -- add_index(:packages_packages, [:project_id, :name, :id, :version], {:name=>"idx_packages_on_project_id_name_id_version_when_installable_npm", :where=>"package_type = 2 AND status IN (0, 1)", :algorithm=>:concurrently})
691main: -> 0.0024s
692main: == 20230131125844 AddProjectIdNameIdVersionIndexToInstallableNpmPackages: migrated (0.0559s)
693main: == [advisory_lock_connection] object_id: 184651860, pg_backend_pid: 2805
694 schedules an index creation
695I, [2023-10-20T08:47:19.451454 #329] INFO -- : Database: 'main', Table: 'p_ci_runner_machine_builds': Lock Writes
696I, [2023-10-20T08:47:19.772141 #329] INFO -- : Database: 'main', Table: 'ci_cost_settings': Lock Writes
697I, [2023-10-20T08:47:32.663481 #329] INFO -- : Database: 'main', Table: 'ci_editor_ai_conversation_messages': Lock Writes
698I, [2023-10-20T08:47:37.368270 #329] INFO -- : Database: 'main', Table: 'p_ci_builds': Lock Writes
699I, [2023-10-20T08:47:37.369694 #329] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
700I, [2023-10-20T08:47:37.370615 #329] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
701I, [2023-10-20T08:47:51.333944 #329] INFO -- : Database: 'main', Table: 'p_ci_job_annotations': Lock Writes
702INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
703INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
704INFO: "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
705INFO: analyzing "public.p_ci_job_annotations" inheritance tree
706INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
707INFO: "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
708INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
709INFO: analyzing "public.ci_builds_metadata"
710INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
711INFO: analyzing "public.p_ci_builds" inheritance tree
712INFO: analyzing "public.ci_builds"
713INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
714I, [2023-10-20T08:48:16.679273 #329] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes
715AddTmpPartialIndexOnVulnerabilityReportTypes
716 # order random
717main: == [advisory_lock_connection] object_id: 205143760, pg_backend_pid: 2821
718main: == 20230221093533 AddTmpPartialIndexOnVulnerabilityReportTypes: migrating =====
719main: -- index_exists?(:vulnerability_occurrences, :id, {:where=>"report_type IN (7, 99)", :name=>"tmp_idx_vulnerability_occurrences_on_id_where_report_type_7_99", :algorithm=>:concurrently})
720main: -> 0.0106s
721main: -- add_index_options(:vulnerability_occurrences, :id, {:where=>"report_type IN (7, 99)", :name=>"tmp_idx_vulnerability_occurrences_on_id_where_report_type_7_99", :algorithm=>:concurrently})
722main: -> 0.0001s
723main: == 20230221093533 AddTmpPartialIndexOnVulnerabilityReportTypes: migrated (0.0366s)
724main: == [advisory_lock_connection] object_id: 205143760, pg_backend_pid: 2821
725 schedules the index
726I, [2023-10-20T08:49:25.953481 #329] INFO -- : Database: 'main', Table: 'ci_editor_ai_conversation_messages': Lock Writes
727I, [2023-10-20T08:49:29.460678 #329] INFO -- : Database: 'main', Table: 'p_ci_builds': Lock Writes
728I, [2023-10-20T08:49:29.461836 #329] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
729I, [2023-10-20T08:49:29.463138 #329] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
730I, [2023-10-20T08:49:43.991489 #329] INFO -- : Database: 'main', Table: 'p_ci_job_annotations': Lock Writes
731INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
732INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
733INFO: "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
734INFO: analyzing "public.p_ci_job_annotations" inheritance tree
735INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
736INFO: "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
737INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
738INFO: analyzing "public.ci_builds_metadata"
739INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
740INFO: analyzing "public.p_ci_builds" inheritance tree
741INFO: analyzing "public.ci_builds"
742INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
743I, [2023-10-20T08:50:08.947373 #329] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes
744ReMigrateRedisSlotKeys
745 # order random
746 #up
747main: == [advisory_lock_connection] object_id: 223771140, pg_backend_pid: 2836
748main: == 20230328111013 ReMigrateRedisSlotKeys: migrating ===========================
749main: == 20230328111013 ReMigrateRedisSlotKeys: migrated (0.0266s) ==================
750main: == [advisory_lock_connection] object_id: 223771140, pg_backend_pid: 2836
751 rename keys
752main: == [advisory_lock_connection] object_id: 224574840, pg_backend_pid: 2838
753main: == 20230328111013 ReMigrateRedisSlotKeys: migrating ===========================
754main: == 20230328111013 ReMigrateRedisSlotKeys: migrated (2.0399s) ==================
755main: == [advisory_lock_connection] object_id: 224574840, pg_backend_pid: 2838
756 runs without errors
757I, [2023-10-20T08:51:09.841906 #329] INFO -- : Database: 'main', Table: 'ci_editor_ai_conversation_messages': Lock Writes
758I, [2023-10-20T08:51:14.337752 #329] INFO -- : Database: 'main', Table: 'p_ci_builds': Lock Writes
759I, [2023-10-20T08:51:14.339060 #329] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
760I, [2023-10-20T08:51:14.339961 #329] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
761I, [2023-10-20T08:51:28.703305 #329] INFO -- : Database: 'main', Table: 'p_ci_job_annotations': Lock Writes
762INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
763INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
764INFO: "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
765INFO: analyzing "public.p_ci_job_annotations" inheritance tree
766INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
767INFO: "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
768INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
769INFO: analyzing "public.ci_builds_metadata"
770INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
771INFO: analyzing "public.p_ci_builds" inheritance tree
772INFO: analyzing "public.ci_builds"
773INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
774I, [2023-10-20T08:51:53.802530 #329] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes
775EnsureVumBigintBackfillIsFinishedForGlDotCom
776 # order random
777 #up
778main: == [advisory_lock_connection] object_id: 241544620, pg_backend_pid: 2853
779main: == 20230321011529 EnsureVumBigintBackfillIsFinishedForGlDotCom: migrating =====
780main: == 20230321011529 EnsureVumBigintBackfillIsFinishedForGlDotCom: migrated (0.0077s)
781main: == [advisory_lock_connection] object_id: 241544620, pg_backend_pid: 2853
782 ensures the migration is completed for GitLab.com, dev, or test
783main: == [advisory_lock_connection] object_id: 242316080, pg_backend_pid: 2855
784main: == 20230321011529 EnsureVumBigintBackfillIsFinishedForGlDotCom: migrating =====
785main: == 20230321011529 EnsureVumBigintBackfillIsFinishedForGlDotCom: migrated (0.0077s)
786main: == [advisory_lock_connection] object_id: 242316080, pg_backend_pid: 2855
787 skips the check for other instances
788I, [2023-10-20T08:52:58.236358 #329] INFO -- : Database: 'main', Table: 'ci_editor_ai_conversation_messages': Lock Writes
789I, [2023-10-20T08:53:01.844212 #329] INFO -- : Database: 'main', Table: 'p_ci_builds': Lock Writes
790I, [2023-10-20T08:53:01.845374 #329] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
791I, [2023-10-20T08:53:01.846151 #329] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
792I, [2023-10-20T08:53:17.644836 #329] INFO -- : Database: 'main', Table: 'p_ci_job_annotations': Lock Writes
793INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
794INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
795INFO: "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
796INFO: analyzing "public.p_ci_job_annotations" inheritance tree
797INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
798INFO: "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
799INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
800INFO: analyzing "public.ci_builds_metadata"
801INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
802INFO: analyzing "public.p_ci_builds" inheritance tree
803INFO: analyzing "public.ci_builds"
804INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
805I, [2023-10-20T08:53:43.521770 #329] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes
806RescheduleIncidentWorkItemTypeIdBackfill
807 # order random
808 #up
809main: == [advisory_lock_connection] object_id: 258730280, pg_backend_pid: 2869
810main: == 20230414200202 RescheduleIncidentWorkItemTypeIdBackfill: migrating =========
811main: == 20230414200202 RescheduleIncidentWorkItemTypeIdBackfill: migrated (0.0683s)
812main: == [advisory_lock_connection] object_id: 258730280, pg_backend_pid: 2869
813 correctly reschedules background migration only for incidents
814main: == [advisory_lock_connection] object_id: 259487560, pg_backend_pid: 2871
815main: == 20230414200202 RescheduleIncidentWorkItemTypeIdBackfill: migrating =========
816main: -- Incident work item type not found. Make sure the work_item_types table is populatedbefore running this migration
817main: == 20230414200202 RescheduleIncidentWorkItemTypeIdBackfill: migrated (0.0130s)
818main: == [advisory_lock_connection] object_id: 259487560, pg_backend_pid: 2871
819 doesn't fail if work item types don't exist on the DB
820I, [2023-10-20T08:54:38.430447 #329] INFO -- : Database: 'main', Table: 'ci_editor_ai_conversation_messages': Lock Writes
821I, [2023-10-20T08:54:41.995794 #329] INFO -- : Database: 'main', Table: 'p_ci_builds': Lock Writes
822I, [2023-10-20T08:54:41.996953 #329] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
823I, [2023-10-20T08:54:41.997806 #329] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
824I, [2023-10-20T08:54:56.711824 #329] INFO -- : Database: 'main', Table: 'p_ci_job_annotations': Lock Writes
825INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
826INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
827INFO: "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
828INFO: analyzing "public.p_ci_job_annotations" inheritance tree
829INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
830INFO: "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
831INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
832INFO: analyzing "public.ci_builds_metadata"
833INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
834INFO: analyzing "public.p_ci_builds" inheritance tree
835INFO: analyzing "public.ci_builds"
836INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
837I, [2023-10-20T08:55:23.154262 #329] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes
838RemovePackagesEventsPackageIdFk
839 # order random
840main: -- foreign_keys(:packages_events)
841main: -> 0.0055s
842main: == [advisory_lock_connection] object_id: 275767980, pg_backend_pid: 2885
843main: == 20230316164917 RemovePackagesEventsPackageIdFk: migrating ==================
844main: -- execute("LOCK TABLE packages_packages, packages_events IN ACCESS EXCLUSIVE MODE")
845main: -> 0.0015s
846main: -- remove_foreign_key(:packages_events, :packages_packages, {:name=>"fk_rails_c6c20d0094"})
847main: -> 0.0069s
848main: == 20230316164917 RemovePackagesEventsPackageIdFk: migrated (0.0402s) =========
849main: == [advisory_lock_connection] object_id: 275767980, pg_backend_pid: 2885
850main: -- foreign_keys(:packages_events)
851main: -> 0.0057s
852main: -- foreign_keys(:packages_events)
853main: -> 0.0059s
854 drops and creates the foreign key
855I, [2023-10-20T08:56:29.310158 #329] INFO -- : Database: 'main', Table: 'ci_editor_ai_conversation_messages': Lock Writes
856I, [2023-10-20T08:56:32.794825 #329] INFO -- : Database: 'main', Table: 'p_ci_builds': Lock Writes
857I, [2023-10-20T08:56:32.796118 #329] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
858I, [2023-10-20T08:56:32.797030 #329] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
859I, [2023-10-20T08:56:48.690027 #329] INFO -- : Database: 'main', Table: 'p_ci_job_annotations': Lock Writes
860INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
861INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
862INFO: "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
863INFO: analyzing "public.p_ci_job_annotations" inheritance tree
864INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
865INFO: "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
866INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
867INFO: analyzing "public.ci_builds_metadata"
868INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
869INFO: analyzing "public.p_ci_builds" inheritance tree
870INFO: analyzing "public.ci_builds"
871INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
872I, [2023-10-20T08:57:14.955856 #329] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes
873FinalizeBackfillResourceLinkEvents
874 # order random
875 with migration present
876 when migrations have finished
877main: == [advisory_lock_connection] object_id: 291034060, pg_backend_pid: 2900
878main: == 20230530012406 FinalizeBackfillResourceLinkEvents: migrating ===============
879main: == 20230530012406 FinalizeBackfillResourceLinkEvents: migrated (0.0258s) ======
880main: == [advisory_lock_connection] object_id: 291034060, pg_backend_pid: 2900
881 does not raise an error
882 with different migration statuses
883 status: 0, description: "paused"
884main: == [advisory_lock_connection] object_id: 292089180, pg_backend_pid: 2902
885main: == 20230530012406 FinalizeBackfillResourceLinkEvents: migrating ===============
886main: == 20230530012406 FinalizeBackfillResourceLinkEvents: migrated (0.0882s) ======
887main: == [advisory_lock_connection] object_id: 292089180, pg_backend_pid: 2902
888 finalizes the migration
889 status: 1, description: "active"
890main: == [advisory_lock_connection] object_id: 292381440, pg_backend_pid: 2904
891main: == 20230530012406 FinalizeBackfillResourceLinkEvents: migrating ===============
892main: == 20230530012406 FinalizeBackfillResourceLinkEvents: migrated (0.0992s) ======
893main: == [advisory_lock_connection] object_id: 292381440, pg_backend_pid: 2904
894 finalizes the migration
895 status: 4, description: "failed"
896main: == [advisory_lock_connection] object_id: 292717780, pg_backend_pid: 2906
897main: == 20230530012406 FinalizeBackfillResourceLinkEvents: migrating ===============
898main: == 20230530012406 FinalizeBackfillResourceLinkEvents: migrated (0.1003s) ======
899main: == [advisory_lock_connection] object_id: 292717780, pg_backend_pid: 2906
900 finalizes the migration
901 status: 5, description: "finalizing"
902main: == [advisory_lock_connection] object_id: 293054060, pg_backend_pid: 2908
903main: == 20230530012406 FinalizeBackfillResourceLinkEvents: migrating ===============
904main: == 20230530012406 FinalizeBackfillResourceLinkEvents: migrated (0.0985s) ======
905main: == [advisory_lock_connection] object_id: 293054060, pg_backend_pid: 2908
906 finalizes the migration
907 when migration is missing
908main: == [advisory_lock_connection] object_id: 293390400, pg_backend_pid: 2910
909main: == 20230530012406 FinalizeBackfillResourceLinkEvents: migrating ===============
910main: == 20230530012406 FinalizeBackfillResourceLinkEvents: migrated (0.0162s) ======
911main: == [advisory_lock_connection] object_id: 293390400, pg_backend_pid: 2910
912 warns migration not found
913The application_settings (main) table has 1210 columns.
914Recreating the database
915Dropped database 'gitlabhq_test'
916Dropped database 'gitlabhq_test_ci'
917Created database 'gitlabhq_test'
918Created database 'gitlabhq_test_ci'
919main: == [advisory_lock_connection] object_id: 293579000, pg_backend_pid: 2921
920main: == [advisory_lock_connection] object_id: 293579000, pg_backend_pid: 2921
921ci: == [advisory_lock_connection] object_id: 293660120, pg_backend_pid: 2923
922ci: == [advisory_lock_connection] object_id: 293660120, pg_backend_pid: 2923
923Databases re-creation done in 12.492233559999931
924RetryCleanupBigintConversionForEventsForGitlabCom
925 # order random
926 #down
927 when column still exists
928 when is GitLab.com, dev, or test
929 behaves like skips the down migration
930 doesn't calls restore_conversion_of_integer_to_bigint method
931 when is a self-managed instance
932 behaves like skips the down migration
933 doesn't calls restore_conversion_of_integer_to_bigint method
934 when column not exists
935 when is GitLab.com, dev, or test
936 restore the temporary columns
937 when is a self-managed instance
938 behaves like skips the down migration
939 doesn't calls restore_conversion_of_integer_to_bigint method
940 #up
941 when column still exists
942 when is GitLab.com, dev, or test
943 drop the temporary columns
944 when is a self-managed instance
945 behaves like skips the up migration
946 doesn't calls cleanup_conversion_of_integer_to_bigint method
947 when column not exists
948 when is GitLab.com, dev, or test
949 behaves like skips the up migration
950 doesn't calls cleanup_conversion_of_integer_to_bigint method
951 when is a self-managed instance
952 behaves like skips the up migration
953 doesn't calls cleanup_conversion_of_integer_to_bigint method
954INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
955INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
956INFO: "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
957INFO: analyzing "public.p_ci_job_annotations" inheritance tree
958INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
959INFO: "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
960INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
961INFO: analyzing "public.ci_builds_metadata"
962INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
963INFO: analyzing "public.p_ci_builds" inheritance tree
964INFO: analyzing "public.ci_builds"
965INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
966I, [2023-10-20T08:58:49.304622 #329] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes
967CleanupProjectPipelineStatusKey
968 # order random
969main: == [advisory_lock_connection] object_id: 301720220, pg_backend_pid: 2948
970main: == 20230703024031 CleanupProjectPipelineStatusKey: migrating ==================
971main: == 20230703024031 CleanupProjectPipelineStatusKey: migrated (0.0093s) =========
972main: == [advisory_lock_connection] object_id: 301720220, pg_backend_pid: 2948
973 enqueues a RedisMigrationWorker job from cursor 0
974INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
975INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
976INFO: "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
977INFO: analyzing "public.p_ci_job_annotations" inheritance tree
978INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
979INFO: "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
980INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
981INFO: analyzing "public.ci_builds_metadata"
982INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
983INFO: analyzing "public.p_ci_builds" inheritance tree
984INFO: analyzing "public.ci_builds"
985INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
986I, [2023-10-20T08:59:39.663860 #329] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes
987DeleteOrphansScanFindingLicenseScanningApprovalRules2
988 # order random
989 #up
990main: == [advisory_lock_connection] object_id: 308409040, pg_backend_pid: 2959
991main: == 20230721095222 DeleteOrphansScanFindingLicenseScanningApprovalRules2: migrating
992main: == 20230721095222 DeleteOrphansScanFindingLicenseScanningApprovalRules2: migrated (0.0918s)
993main: == [advisory_lock_connection] object_id: 308409040, pg_backend_pid: 2959
994 schedules background migration for both levels of approval rules
995INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
996INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
997INFO: "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
998INFO: analyzing "public.p_ci_job_annotations" inheritance tree
999INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
1000INFO: "ci_job_annotations_100": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1001INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
1002INFO: analyzing "public.ci_builds_metadata"
1003INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1004INFO: analyzing "public.p_ci_builds" inheritance tree
1005INFO: analyzing "public.ci_builds"
1006INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1007I, [2023-10-20T09:00:26.212886 #329] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes
1008AddLinkedItemsWorkItemWidget
1009 # order random
1010 behaves like migration that adds widget to work items definitions
1011 #up
1012main: == [advisory_lock_connection] object_id: 313894240, pg_backend_pid: 2970
1013main: == 20230807083334 AddLinkedItemsWorkItemWidget: migrating =====================
1014main: == 20230807083334 AddLinkedItemsWorkItemWidget: migrated (0.0430s) ============
1015main: == [advisory_lock_connection] object_id: 313894240, pg_backend_pid: 2970
1016 creates widget definition in all types
1017main: == [advisory_lock_connection] object_id: 314444160, pg_backend_pid: 2972
1018main: == 20230807083334 AddLinkedItemsWorkItemWidget: migrating =====================
1019main: == 20230807083334 AddLinkedItemsWorkItemWidget: migrated (0.0587s) ============
1020main: == [advisory_lock_connection] object_id: 314444160, pg_backend_pid: 2972
1021 logs a warning if the type is missing
1022 #down
1023main: == [advisory_lock_connection] object_id: 314751040, pg_backend_pid: 2974
1024main: == 20230807083334 AddLinkedItemsWorkItemWidget: migrating =====================
1025main: == 20230807083334 AddLinkedItemsWorkItemWidget: migrated (0.0538s) ============
1026main: == [advisory_lock_connection] object_id: 314751040, pg_backend_pid: 2974
1027 removes definitions for widget
1028INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
1029INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
1030INFO: "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
1031INFO: analyzing "public.p_ci_job_annotations" inheritance tree
1032INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
1033INFO: "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
1034INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
1035INFO: analyzing "public.ci_builds_metadata"
1036INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1037INFO: analyzing "public.p_ci_builds" inheritance tree
1038INFO: analyzing "public.ci_builds"
1039INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1040I, [2023-10-20T09:00:57.526958 #329] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes
1041EnsureCommitUserMentionsNoteIdBigintBackfillIsFinishedForSelfManaged
1042 # order random
1043 #up
1044main: == [advisory_lock_connection] object_id: 318079260, pg_backend_pid: 2984
1045main: == 20230811145848 EnsureCommitUserMentionsNoteIdBigintBackfillIsFinishedForSelfManaged: migrating
1046main: == 20230811145848 EnsureCommitUserMentionsNoteIdBigintBackfillIsFinishedForSelfManaged: migrated (0.0075s)
1047main: == [advisory_lock_connection] object_id: 318079260, pg_backend_pid: 2984
1048 ensures the migration is completed for self-managed instances
1049main: == [advisory_lock_connection] object_id: 318767880, pg_backend_pid: 2986
1050main: == 20230811145848 EnsureCommitUserMentionsNoteIdBigintBackfillIsFinishedForSelfManaged: migrating
1051main: == 20230811145848 EnsureCommitUserMentionsNoteIdBigintBackfillIsFinishedForSelfManaged: migrated (0.0082s)
1052main: == [advisory_lock_connection] object_id: 318767880, pg_backend_pid: 2986
1053 skips the check for GitLab.com, dev, or test
1054INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
1055INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
1056INFO: "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
1057INFO: analyzing "public.p_ci_job_annotations" inheritance tree
1058INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
1059INFO: "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
1060INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
1061INFO: analyzing "public.ci_builds_metadata"
1062INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1063INFO: analyzing "public.p_ci_builds" inheritance tree
1064INFO: analyzing "public.ci_builds"
1065INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1066I, [2023-10-20T09:01:21.724197 #329] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes
1067SwapColumnsForCiPipelineChatDataPipelineIdBigint
1068 # order random
1069 swaps columns
1070 when legacy foreign key exists
1071 renames the legacy foreign key fk_rails_64ebfab6b3
1072INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
1073INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
1074INFO: "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
1075INFO: analyzing "public.p_ci_job_annotations" inheritance tree
1076INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
1077INFO: "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
1078INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
1079INFO: analyzing "public.ci_builds_metadata"
1080INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1081INFO: analyzing "public.p_ci_builds" inheritance tree
1082INFO: analyzing "public.ci_builds"
1083INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
1084I, [2023-10-20T09:01:41.697594 #329] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes
1085LowerProjectBuildTimeoutToRespectMaxValidation
1086 # order random
1087 #down
1088main: == [advisory_lock_connection] object_id: 324114640, pg_backend_pid: 3010
1089main: == 20231003142706 LowerProjectBuildTimeoutToRespectMaxValidation: migrating ===
1090main: == 20231003142706 LowerProjectBuildTimeoutToRespectMaxValidation: migrated (0.0459s)
1091main: == [advisory_lock_connection] object_id: 324114640, pg_backend_pid: 3010
1092 does nothing
1093 #up
1094main: == [advisory_lock_connection] object_id: 324461040, pg_backend_pid: 3013
1095main: == 20231003142706 LowerProjectBuildTimeoutToRespectMaxValidation: migrating ===
1096main: == 20231003142706 LowerProjectBuildTimeoutToRespectMaxValidation: migrated (0.0508s)
1097main: == [advisory_lock_connection] object_id: 324461040, pg_backend_pid: 3013
1098 updates the build timeout
1099auto_explain log contains 1102 entries for main, writing to /builds/gitlab-org/gitlab/auto_explain/rspec-migration-pg14-4-12.329.main.ndjson.gz
1100took 20.252850596
1101auto_explain log contains 1102 entries for ci, writing to /builds/gitlab-org/gitlab/auto_explain/rspec-migration-pg14-4-12.329.ci.ndjson.gz
1102took 17.831999619
1103Knapsack report was generated. Preview:
1104{
1105 "spec/migrations/20230214181633_finalize_ci_build_needs_big_int_conversion_spec.rb": 148.28736450099996,
1106 "spec/migrations/20230201171450_finalize_backfill_environment_tier_migration_spec.rb": 64.92192755400015,
1107 "spec/migrations/20221220131020_bump_default_partition_id_value_for_ci_tables_spec.rb": 66.82512429400003,
1108 "spec/migrations/20221122132812_schedule_prune_stale_project_export_jobs_spec.rb": 62.47321971600013,
1109 "spec/migrations/20230208125736_schedule_migration_for_links_spec.rb": 57.78297774999987,
1110 "spec/migrations/20230522220709_ensure_incident_work_item_type_backfill_is_finished_spec.rb": 57.25821751700005,
1111 "spec/migrations/20230327123333_backfill_product_analytics_data_collector_host_spec.rb": 57.17374929400012,
1112 "spec/migrations/20230131125844_add_project_id_name_id_version_index_to_installable_npm_packages_spec.rb": 50.91235428000027,
1113 "spec/migrations/20230221093533_add_tmp_partial_index_on_vulnerability_report_types_spec.rb": 47.133676615999775,
1114 "spec/migrations/20230302811133_re_migrate_redis_slot_keys_spec.rb": 46.755808075999994,
1115 "spec/migrations/ensure_vum_bigint_backfill_is_finished_for_gl_dot_com_spec.rb": 46.63052675300014,
1116 "spec/migrations/reschedule_incident_work_item_type_id_backfill_spec.rb": 44.020617224000034,
1117 "spec/migrations/remove_packages_events_package_id_fk_spec.rb": 47.37879252199991,
1118 "spec/migrations/20230530012406_finalize_backfill_resource_link_events_spec.rb": 39.065643352999814,
1119 "spec/migrations/20230801150214_retry_cleanup_bigint_conversion_for_events_for_gitlab_com_spec.rb": 25.287682208000206,
1120 "spec/migrations/20230703024031_cleanup_project_pipeline_status_key_spec.rb": 21.291582348999782,
1121 "spec/migrations/20230721095222_delete_orphans_scan_finding_license_scanning_approval_rules2_spec.rb": 19.80807434999997,
1122 "spec/migrations/20230807083334_add_linked_items_work_item_widget_spec.rb": 15.145293471999594,
1123 "spec/migrations/ensure_commit_user_mentions_note_id_bigint_backfill_is_finished_for_self_managed_spec.rb": 10.793936298000062,
1124 "spec/migrations/20230908033511_swap_columns_for_ci_pipeline_chat_data_pipeline_id_bigint_spec.rb": 9.667809462999685,
1125 "spec/migrations/20231003142706_lower_project_build_timeout_to_respect_max_validation_spec.rb": 6.688187687000209
1126}
1127Knapsack global time execution for tests: 15m 45s
1128Finished in 33 minutes 26 seconds (files took 59.25 seconds to load)
112964 examples, 0 failures
1130Randomized with seed 60272
1131[TEST PROF INFO] Time spent in factories: 00:00.332 (0.02% of total time)
1132RSpec exited with 0.
1133No examples to retry, congrats!
1134 Running after_script 00:02
1135Running after script...
1136$ echo -e "\e[0Ksection_start:`date +%s`:report_results_section[collapsed=true]\r\e[0KReport results"
1137 Report results 00:00
1140$ tooling/bin/push_job_metrics || true
1141[job-metrics] Pushing job metrics file for the CI/CD job.
1142[job-metrics] Pushed 4 CI job metric entries to InfluxDB.
1143 Saving cache for successful job 00:01
1144Not uploading cache ruby-gems-debian-bullseye-ruby-3.0-16 due to policy
1145 Uploading artifacts for successful job 00:04
1146Uploading artifacts...
1147auto_explain/: found 3 matching artifact files and directories
1148coverage/: found 5 matching artifact files and directories
1149crystalball/: found 2 matching artifact files and directories
1150WARNING: deprecations/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab)
1151knapsack/: found 4 matching artifact files and directories
1152rspec/: found 16 matching artifact files and directories
1153WARNING: tmp/capybara/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab)
1154log/*.log: found 14 matching artifact files and directories
1155WARNING: Upload request redirected location=https://gitlab.com/api/v4/jobs/5336650664/artifacts?artifact_format=zip&artifact_type=archive&expire_in=31d new-url=https://gitlab.com
1156WARNING: Retrying... context=artifacts-uploader error=request redirected
1157Uploading artifacts as "archive" to coordinator... 201 Created id=5336650664 responseStatus=201 Created token=64_t7DrL
1158Uploading artifacts...
1159rspec/rspec-*.xml: found 1 matching artifact files and directories
1160WARNING: Upload request redirected location=https://gitlab.com/api/v4/jobs/5336650664/artifacts?artifact_format=gzip&artifact_type=junit&expire_in=31d new-url=https://gitlab.com
1161WARNING: Retrying... context=artifacts-uploader error=request redirected
1162Uploading artifacts as "junit" to coordinator... 201 Created id=5336650664 responseStatus=201 Created token=64_t7DrL
1163 Cleaning up project directory and file based variables 00:01
1164Job succeeded