Skip to content
Snippets Groups Projects

rspec background_migration pg14 1/4

Passed Started by
🤖 GitLab Bot 🤖
@gitlab-bot
1Running with gitlab-runner 16.3.0~beta.108.g2b6048b4 (2b6048b4)
2 on blue-6.private.runners-manager.gitlab.com/gitlab.com/gitlab-org mKJTFBei, system ID: s_90a66139ec06
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:08
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:01
25Running on runner-mkjtfbei-project-278964-concurrent-0 via runner-mkjtfbei-private-1697704057-77307c08...
26 Getting source from Git repository 00:28
27Fetching changes with git depth set to 20...
28Initialized empty Git repository in /builds/gitlab-org/gitlab/.git/
29Created fresh repository.
30remote: Enumerating objects: 175495, done.
31remote: Counting objects: 100% (175495/175495), done.
32remote: Compressing objects: 100% (119238/119238), done.
33remote: Total 175495 (delta 83016), reused 113694 (delta 49335), pack-reused 0
34Receiving objects: 100% (175495/175495), 148.32 MiB | 31.97 MiB/s, done.
35Resolving deltas: 100% (83016/83016), done.
36From https://us-east1-d.ci-gateway.int.gprd.gitlab.net:8989/gitlab-org/gitlab
37 * [new ref] refs/pipelines/1042272888 -> refs/pipelines/1042272888
38Checking out 3af7b5df as detached HEAD (ref is refs/merge-requests/134621/merge)...
39Skipping Git submodules setup
40$ git remote set-url origin "${CI_REPOSITORY_URL}"
41 Restoring cache 00:17
42Checking cache for ruby-gems-debian-bullseye-ruby-3.0-16...
43cache.zip is up to date
44Successfully extracted cache
45 Downloading artifacts 00:22
46Downloading artifacts for compile-test-assets (5328358048)...
47Downloading artifacts from coordinator... ok host=storage.googleapis.com id=5328358048 responseStatus=200 OK token=64_9GMbw
48Downloading artifacts for detect-tests (5328358058)...
49Downloading artifacts from coordinator... ok host=storage.googleapis.com id=5328358058 responseStatus=200 OK token=64_9GMbw
50Downloading artifacts for retrieve-tests-metadata (5328358066)...
51Downloading artifacts from coordinator... ok host=storage.googleapis.com id=5328358066 responseStatus=200 OK token=64_9GMbw
52Downloading artifacts for setup-test-env (5328358054)...
53Downloading artifacts from coordinator... ok host=storage.googleapis.com id=5328358054 responseStatus=200 OK token=64_9GMbw
54 Executing "step_script" stage of the job script 27:31
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:15
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 00:51
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 0 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/{lib/gitlab/background_migration,lib/ee/gitlab/background_migration}{,/**/}*_spec.rb
145KNAPSACK_LOG_LEVEL: debug
146KNAPSACK_REPORT_PATH: knapsack/rspec_background_migration_pg14_1_4_report.json
147FLAKY_RSPEC_SUITE_REPORT_PATH: rspec/flaky/report-suite.json
148FLAKY_RSPEC_REPORT_PATH: rspec/flaky/all_rspec_background_migration_pg14_1_4_report.json
149NEW_FLAKY_RSPEC_REPORT_PATH: rspec/flaky/new_rspec_background_migration_pg14_1_4_report.json
150RSPEC_SKIPPED_TESTS_REPORT_PATH: rspec/skipped_tests-5328358176.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.412613745 seconds
215Gitlab::BackgroundMigration::BackfillSnippetRepositories
216 #perform
217 logs successful migrated snippets
218 when snippet has a non empty repository
219 does not perform any action
220 when snippet has an empty repo
221 behaves like commits the file to the repository
222 when author can update snippet and use git
223 creates the repository and commit the file
224 when author cannot update snippet or use git
225 when user is blocked
226 behaves like migration_bot user commits files
227 is expected to eq "noreply+gitlab-migration-bot%s@localhost"
228 when user is deactivated
229 behaves like migration_bot user commits files
230 is expected to eq "noreply+gitlab-migration-bot%s@localhost"
231 when user is a ghost
232 behaves like migration_bot user commits files
233 is expected to eq "noreply+gitlab-migration-bot%s@localhost"
234 when snippet does not have a repository
235 creates the repository
236 behaves like commits the file to the repository
237 when author can update snippet and use git
238 creates the repository and commit the file
239 when author cannot update snippet or use git
240 when user is blocked
241 behaves like migration_bot user commits files
242 is expected to eq "noreply+gitlab-migration-bot%s@localhost"
243 when user is deactivated
244 behaves like migration_bot user commits files
245 is expected to eq "noreply+gitlab-migration-bot%s@localhost"
246 when user is a ghost
247 behaves like migration_bot user commits files
248 is expected to eq "noreply+gitlab-migration-bot%s@localhost"
249 when an error is raised
250 logs errors
251 retries 2 times the operation if it fails
252 destroys the snippet repository
253 deletes the repository on disk
254 with invalid file names
255 invalid_file_name: "filename.js // with comment", converted_file_name: "filename-js-with-comment"
256 checks for file path errors when errors are raised
257 converts invalid filenames
258 does not convert valid filenames on subsequent migrations
259 invalid_file_name: ".git/hooks/pre-commit", converted_file_name: "git-hooks-pre-commit"
260 checks for file path errors when errors are raised
261 converts invalid filenames
262 does not convert valid filenames on subsequent migrations
263 invalid_file_name: "https://gitlab.com", converted_file_name: "https-gitlab-com"
264 checks for file path errors when errors are raised
265 converts invalid filenames
266 does not convert valid filenames on subsequent migrations
267 invalid_file_name: "html://web.title%mp4/mpg/mpeg.net", converted_file_name: "html-web-title-mp4-mpg-mpeg-net"
268 checks for file path errors when errors are raised
269 converts invalid filenames
270 does not convert valid filenames on subsequent migrations
271 invalid_file_name: "../../etc/passwd", converted_file_name: "etc-passwd"
272 checks for file path errors when errors are raised
273 converts invalid filenames
274 does not convert valid filenames on subsequent migrations
275 invalid_file_name: ".", converted_file_name: "snippetfile1.txt"
276 checks for file path errors when errors are raised
277 converts invalid filenames
278 does not convert valid filenames on subsequent migrations
279 when snippet content size is higher than the existing limit
280 behaves like migration_bot user commits files
281 is expected to eq "noreply+gitlab-migration-bot%s@localhost"
282 when user name is invalid
283 behaves like migration_bot user commits files
284 is expected to eq "noreply+gitlab-migration-bot%s@localhost"
285 when both user name and snippet file_name are invalid
286 updates the file_name only when it is invalid
287 does not alter the commit author in subsequent migrations
288 increases the number of retries temporarily from 2 to 3
289 behaves like migration_bot user commits files
290 is expected to eq "noreply+gitlab-migration-bot%s@localhost"
291I, [2023-10-19T10:12:01.829254 #329] INFO -- : Database: 'main', Table: 'ci_runner_machines': Lock Writes
292I, [2023-10-19T10:12:07.629844 #329] INFO -- : Database: 'main', Table: 'p_ci_runner_machine_builds': Lock Writes
293I, [2023-10-19T10:12:07.901830 #329] INFO -- : Database: 'main', Table: 'ci_cost_settings': Lock Writes
294I, [2023-10-19T10:12:18.209294 #329] INFO -- : Database: 'main', Table: 'ci_editor_ai_conversation_messages': Lock Writes
295I, [2023-10-19T10:12:22.161557 #329] INFO -- : Database: 'main', Table: 'p_ci_builds': Lock Writes
296I, [2023-10-19T10:12:22.162503 #329] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
297I, [2023-10-19T10:12:22.163168 #329] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
298I, [2023-10-19T10:12:34.544798 #329] INFO -- : Database: 'main', Table: 'p_ci_job_annotations': Lock Writes
299INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
300INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
301INFO: "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
302INFO: analyzing "public.p_ci_job_annotations" inheritance tree
303INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
304INFO: "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
305INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
306INFO: analyzing "public.ci_builds_metadata"
307INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
308INFO: analyzing "public.p_ci_builds" inheritance tree
309INFO: analyzing "public.ci_builds"
310INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
311I, [2023-10-19T10:12:56.658092 #329] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes
312Gitlab::BackgroundMigration::BackfillWorkItemTypeIdForIssues
313 sets work_item_type_id only for the given type
314 tracks timings of queries
315 when a record already had a work_item_type_id assigned
316 ovewrites the work_item_type_id
317 when database timeouts
318 error_class: ActiveRecord::StatementTimeout
319 retries on timeout error
320 error_class: ActiveRecord::QueryCanceled
321 retries on timeout error
322I, [2023-10-19T10:14:15.413408 #329] INFO -- : Database: 'main', Table: 'ci_runner_machines': Lock Writes
323I, [2023-10-19T10:14:21.676374 #329] INFO -- : Database: 'main', Table: 'p_ci_runner_machine_builds': Lock Writes
324I, [2023-10-19T10:14:21.949328 #329] INFO -- : Database: 'main', Table: 'ci_cost_settings': Lock Writes
325I, [2023-10-19T10:14:33.556975 #329] INFO -- : Database: 'main', Table: 'ci_editor_ai_conversation_messages': Lock Writes
326I, [2023-10-19T10:14:36.538615 #329] INFO -- : Database: 'main', Table: 'p_ci_builds': Lock Writes
327I, [2023-10-19T10:14:36.539853 #329] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
328I, [2023-10-19T10:14:36.540675 #329] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
329I, [2023-10-19T10:14:50.734895 #329] INFO -- : Database: 'main', Table: 'p_ci_job_annotations': Lock Writes
330INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
331INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
332INFO: "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
333INFO: analyzing "public.p_ci_job_annotations" inheritance tree
334INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
335INFO: "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
336INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
337INFO: analyzing "public.ci_builds_metadata"
338INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
339INFO: analyzing "public.p_ci_builds" inheritance tree
340INFO: analyzing "public.ci_builds"
341INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
342I, [2023-10-19T10:15:13.967787 #329] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes
343Gitlab::BackgroundMigration::CleanupOrphanedRoutes
344 cleans orphaned routes
345 tracks timings of queries
346I, [2023-10-19T10:16:38.194748 #329] INFO -- : Database: 'main', Table: 'ci_runner_machines': Lock Writes
347I, [2023-10-19T10:16:44.423263 #329] INFO -- : Database: 'main', Table: 'p_ci_runner_machine_builds': Lock Writes
348I, [2023-10-19T10:16:44.664465 #329] INFO -- : Database: 'main', Table: 'ci_cost_settings': Lock Writes
349I, [2023-10-19T10:16:55.067942 #329] INFO -- : Database: 'main', Table: 'ci_editor_ai_conversation_messages': Lock Writes
350I, [2023-10-19T10:16:58.922552 #329] INFO -- : Database: 'main', Table: 'p_ci_builds': Lock Writes
351I, [2023-10-19T10:16:58.923567 #329] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
352I, [2023-10-19T10:16:58.924486 #329] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
353I, [2023-10-19T10:17:12.290398 #329] INFO -- : Database: 'main', Table: 'p_ci_job_annotations': Lock Writes
354INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
355INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
356INFO: "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
357INFO: analyzing "public.p_ci_job_annotations" inheritance tree
358INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
359INFO: "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
360INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
361INFO: analyzing "public.ci_builds_metadata"
362INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
363INFO: analyzing "public.p_ci_builds" inheritance tree
364INFO: analyzing "public.ci_builds"
365INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
366I, [2023-10-19T10:17:36.004511 #329] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes
367Gitlab::BackgroundMigration::DestroyInvalidProjectMembers
368 # order random
369 removes invalid memberships but keeps valid ones
370 tracks timings of queries
371 logs IDs of deleted records
372I, [2023-10-19T10:18:53.105801 #329] INFO -- : Database: 'main', Table: 'ci_runner_machines': Lock Writes
373I, [2023-10-19T10:18:59.022125 #329] INFO -- : Database: 'main', Table: 'p_ci_runner_machine_builds': Lock Writes
374I, [2023-10-19T10:18:59.277777 #329] INFO -- : Database: 'main', Table: 'ci_cost_settings': Lock Writes
375I, [2023-10-19T10:19:11.156845 #329] INFO -- : Database: 'main', Table: 'ci_editor_ai_conversation_messages': Lock Writes
376I, [2023-10-19T10:19:14.388847 #329] INFO -- : Database: 'main', Table: 'p_ci_builds': Lock Writes
377I, [2023-10-19T10:19:14.389892 #329] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
378I, [2023-10-19T10:19:14.390642 #329] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
379I, [2023-10-19T10:19:29.723316 #329] INFO -- : Database: 'main', Table: 'p_ci_job_annotations': Lock Writes
380INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
381INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
382INFO: "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
383INFO: analyzing "public.p_ci_job_annotations" inheritance tree
384INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
385INFO: "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
386INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
387INFO: analyzing "public.ci_builds_metadata"
388INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
389INFO: analyzing "public.p_ci_builds" inheritance tree
390INFO: analyzing "public.ci_builds"
391INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
392I, [2023-10-19T10:19:55.302305 #329] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes
393Gitlab::BackgroundMigration::DisableLegacyOpenSourceLicenseForNoIssuesNoRepoProjects
394 sets `legacy_open_source_license_available` to false only for public projects with no issues and no repo
395The application_settings (main) table has 1257 columns.
396Recreating the database
397Dropped database 'gitlabhq_test'
398Dropped database 'gitlabhq_test_ci'
399Created database 'gitlabhq_test'
400Created database 'gitlabhq_test_ci'
401main: == [advisory_lock_connection] object_id: 155867800, pg_backend_pid: 254
402main: == [advisory_lock_connection] object_id: 155867800, pg_backend_pid: 254
403ci: == [advisory_lock_connection] object_id: 156117160, pg_backend_pid: 256
404ci: == [advisory_lock_connection] object_id: 156117160, pg_backend_pid: 256
405Databases re-creation done in 11.063677004000056
406Gitlab::BackgroundMigration::JobCoordinator
407 .for_tracking_database
408 returns an executor with the correct worker class and database
409 when an invalid value is given
410 raises an error
411 #queue
412 returns background migration worker queue
413 #with_shared_connection
414 yields to the block after properly configuring SharedModel
415 #pending_jobs
416 when there are enqueued jobs
417 does not include jobs for other workers
418 when not including dead jobs
419 includes current and future jobs
420 when including dead jobs
421 includes current and future jobs, and also dead and retry jobs
422 #steal
423 when there are enqueued jobs present
424 when queue contains unprocessed jobs
425 steals jobs from a queue
426 sets up the shared connection while stealing jobs
427 does not steal job that has already been taken
428 does not steal jobs for a different migration
429 when a custom predicate is given
430 steals jobs that match the predicate
431 does not steal jobs that do not match the predicate
432 when one of the jobs raises an error
433 enqueues the migration again and re-raises the error
434 when there are scheduled jobs present
435 steals all jobs from the scheduled sets
436 when there are enqueued and scheduled jobs present
437 steals from the scheduled sets queue first
438 when retry_dead_jobs is true
439 steals from the dead and retry queue
440 #perform
441 when the background migration does not inherit from BaseJob
442 performs a background migration with the configured shared connection
443 when the background migration inherits from BaseJob
444 passes the correct connection when constructing the migration
445 .remaining
446 when there are jobs remaining
447 returns the enqueued jobs plus the scheduled jobs
448 when there are no jobs remaining
449 returns zero
450 .exists?
451 when there are enqueued jobs present
452 returns true if specific job exists
453 returns false if specific job does not exist
454 when there are scheduled jobs present
455 returns true if specific job exists
456 returns false if specific job does not exist
457 .dead_jobs?
458 when there are dead jobs present
459 returns true if specific job exists
460 returns false if specific job does not exist
461 .retrying_jobs?
462 when there are dead jobs present
463 returns true if specific job exists
464 returns false if specific job does not exist
465Gitlab::BackgroundMigration::BackfillInternalOnNotes
466 # order random
467 #perform
468 backfills internal column on notes when confidential
469I, [2023-10-19T10:23:06.029617 #329] INFO -- : Database: 'main', Table: 'ci_runner_machines': Lock Writes
470I, [2023-10-19T10:23:11.968377 #329] INFO -- : Database: 'main', Table: 'p_ci_runner_machine_builds': Lock Writes
471I, [2023-10-19T10:23:12.196792 #329] INFO -- : Database: 'main', Table: 'ci_cost_settings': Lock Writes
472I, [2023-10-19T10:23:22.923163 #329] INFO -- : Database: 'main', Table: 'ci_editor_ai_conversation_messages': Lock Writes
473I, [2023-10-19T10:23:26.892635 #329] INFO -- : Database: 'main', Table: 'p_ci_builds': Lock Writes
474I, [2023-10-19T10:23:26.893682 #329] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
475I, [2023-10-19T10:23:26.894404 #329] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
476I, [2023-10-19T10:23:39.425959 #329] INFO -- : Database: 'main', Table: 'p_ci_job_annotations': Lock Writes
477INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
478INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
479INFO: "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
480INFO: analyzing "public.p_ci_job_annotations" inheritance tree
481INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
482INFO: "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
483INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
484INFO: analyzing "public.ci_builds_metadata"
485INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
486INFO: analyzing "public.p_ci_builds" inheritance tree
487INFO: analyzing "public.ci_builds"
488INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
489I, [2023-10-19T10:24:01.776891 #329] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes
490Gitlab::BackgroundMigration::DeleteOrphanedPackagesDependencies
491 # order random
492 executes 3 queries
493 deletes only orphaned dependencies
494I, [2023-10-19T10:25:03.989342 #329] INFO -- : Database: 'main', Table: 'ci_editor_ai_conversation_messages': Lock Writes
495I, [2023-10-19T10:25:06.939825 #329] INFO -- : Database: 'main', Table: 'p_ci_builds': Lock Writes
496I, [2023-10-19T10:25:06.940970 #329] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
497I, [2023-10-19T10:25:06.941752 #329] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
498I, [2023-10-19T10:25:19.951847 #329] INFO -- : Database: 'main', Table: 'p_ci_job_annotations': Lock Writes
499INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
500INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
501INFO: "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
502INFO: analyzing "public.p_ci_job_annotations" inheritance tree
503INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
504INFO: "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
505INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
506INFO: analyzing "public.ci_builds_metadata"
507INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
508INFO: analyzing "public.p_ci_builds" inheritance tree
509INFO: analyzing "public.ci_builds"
510INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
511I, [2023-10-19T10:25:42.298350 #329] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes
512Gitlab::BackgroundMigration::PopulateVulnerabilityDismissalFields
513 # order random
514 #perform
515 updates the missing dismissal information of the vulnerability
516 writes log messages
517 when logger throws exception StandardError
518 logs StandardError
519I, [2023-10-19T10:26:33.810843 #329] INFO -- : Database: 'main', Table: 'ci_editor_ai_conversation_messages': Lock Writes
520I, [2023-10-19T10:26:36.881052 #329] INFO -- : Database: 'main', Table: 'p_ci_builds': Lock Writes
521I, [2023-10-19T10:26:36.882124 #329] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
522I, [2023-10-19T10:26:36.882916 #329] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
523I, [2023-10-19T10:26:50.318375 #329] INFO -- : Database: 'main', Table: 'p_ci_job_annotations': Lock Writes
524INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
525INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
526INFO: "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
527INFO: analyzing "public.p_ci_job_annotations" inheritance tree
528INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
529INFO: "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
530INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
531INFO: analyzing "public.ci_builds_metadata"
532INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
533INFO: analyzing "public.p_ci_builds" inheritance tree
534INFO: analyzing "public.ci_builds"
535INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
536I, [2023-10-19T10:27:13.868809 #329] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes
537Gitlab::BackgroundMigration::BackfillDesignManagementRepositories
538 # order random
539 #perform
540 creates design_management_repositories entries for all projects in range
541 when project_id already exists in design_management_repositories
542 doesn't duplicate project_id
543I, [2023-10-19T10:28:05.039855 #329] INFO -- : Database: 'main', Table: 'ci_editor_ai_conversation_messages': Lock Writes
544I, [2023-10-19T10:28:07.957202 #329] INFO -- : Database: 'main', Table: 'p_ci_builds': Lock Writes
545I, [2023-10-19T10:28:07.958203 #329] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Lock timeout is set", :current_iteration=>1, :lock_timeout_in_ms=>100}
546I, [2023-10-19T10:28:07.958917 #329] INFO -- : {:method=>"with_lock_retries", :class=>"gitlab:db:lock_writes", :message=>"Migration finished", :current_iteration=>1, :lock_timeout_in_ms=>100}
547I, [2023-10-19T10:28:21.389760 #329] INFO -- : Database: 'main', Table: 'p_ci_job_annotations': Lock Writes
548INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
549INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
550INFO: "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
551INFO: analyzing "public.p_ci_job_annotations" inheritance tree
552INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
553INFO: "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
554INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
555INFO: analyzing "public.ci_builds_metadata"
556INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
557INFO: analyzing "public.p_ci_builds" inheritance tree
558INFO: analyzing "public.ci_builds"
559INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
560I, [2023-10-19T10:28:44.832490 #329] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes
561Gitlab::BackgroundMigration::RemoveInvalidDeployAccessLevelGroups
562 # order random
563 #perform
564 backfill tiers for all environments in range
565I, [2023-10-19T10:29:41.668006 #329] INFO -- : Database: 'main', Table: 'p_ci_job_annotations': Lock Writes
566INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
567INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
568INFO: "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
569INFO: analyzing "public.p_ci_job_annotations" inheritance tree
570INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
571INFO: "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
572INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
573INFO: analyzing "public.ci_builds_metadata"
574INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
575INFO: analyzing "public.p_ci_builds" inheritance tree
576INFO: analyzing "public.ci_builds"
577INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
578I, [2023-10-19T10:30:05.095928 #329] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes
579Gitlab::BackgroundMigration::BackfillCodeSuggestionsNamespaceSettings
580 # order random
581 updates the code suggestions values only for group and user namespace
582I, [2023-10-19T10:31:02.218935 #329] INFO -- : Database: 'main', Table: 'p_ci_job_annotations': Lock Writes
583INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
584INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
585INFO: "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
586INFO: analyzing "public.p_ci_job_annotations" inheritance tree
587INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
588INFO: "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
589INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
590INFO: analyzing "public.ci_builds_metadata"
591INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
592INFO: analyzing "public.p_ci_builds" inheritance tree
593INFO: analyzing "public.ci_builds"
594INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
595I, [2023-10-19T10:31:25.497057 #329] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes
596Gitlab::BackgroundMigration::BackfillDefaultBranchProtectionNamespaceSetting
597 # order random
598 updates default_branch_protection_defaults to a correct value
599INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
600INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
601INFO: "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
602INFO: analyzing "public.p_ci_job_annotations" inheritance tree
603INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
604INFO: "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
605INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
606INFO: analyzing "public.ci_builds_metadata"
607INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
608INFO: analyzing "public.p_ci_builds" inheritance tree
609INFO: analyzing "public.ci_builds"
610INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
611I, [2023-10-19T10:32:09.864923 #329] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes
612Gitlab::BackgroundMigration::CopyColumnUsingBackgroundMigrationJob
613 is expected to be < Gitlab::BackgroundMigration::BatchedMigrationJob
614 #perform
615 tracks timings of queries
616 primary keys
617 copies all in range
618 foreign keys
619 copies all in range
620 columns with NULLs
621 copies all in range
622 when multiple columns are given
623 copies all values in the range
624 when the number of source and target columns does not match
625 raises an error
626 pause interval between sub-batches
627 sleeps for the specified time between sub-batches
628 when pause_ms value is negative
629 treats it as a 0
630Gitlab::BackgroundMigration::FixAllowDescendantsOverrideDisabledSharedRunners
631 # order random
632 fixes invalid allow_descendants_override_disabled_shared_runners and does not affect others
633INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
634INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
635INFO: "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
636INFO: analyzing "public.p_ci_job_annotations" inheritance tree
637INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
638INFO: "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
639INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
640INFO: analyzing "public.ci_builds_metadata"
641INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
642INFO: analyzing "public.p_ci_builds" inheritance tree
643INFO: analyzing "public.ci_builds"
644INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
645I, [2023-10-19T10:32:56.654920 #329] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes
646Gitlab::BackgroundMigration::BackfillNugetNormalizedVersion
647 # order random
648 executes 5 queries and updates the normalized_version column
649The application_settings (main) table has 1202 columns.
650Recreating the database
651Dropped database 'gitlabhq_test'
652Dropped database 'gitlabhq_test_ci'
653Created database 'gitlabhq_test'
654Created database 'gitlabhq_test_ci'
655main: == [advisory_lock_connection] object_id: 284572300, pg_backend_pid: 427
656main: == [advisory_lock_connection] object_id: 284572300, pg_backend_pid: 427
657ci: == [advisory_lock_connection] object_id: 284573420, pg_backend_pid: 429
658ci: == [advisory_lock_connection] object_id: 284573420, pg_backend_pid: 429
659Databases re-creation done in 11.30982242600021
660Gitlab::BackgroundMigration::BackfillHasMergeRequestOfVulnerabilityReads
661 # order random
662 sets the has_merge_request of existing record
663 does not modify has_merge_request of other vulnerabilities which do not have merge request
664INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
665INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
666INFO: "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
667INFO: analyzing "public.p_ci_job_annotations" inheritance tree
668INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
669INFO: "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
670INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
671INFO: analyzing "public.ci_builds_metadata"
672INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
673INFO: analyzing "public.p_ci_builds" inheritance tree
674INFO: analyzing "public.ci_builds"
675INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
676I, [2023-10-19T10:33:34.674701 #329] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes
677Gitlab::BackgroundMigration::BackfillUserPreferencesWithDefaults
678 # order random
679 backfills the null values with the default values
680INFO: analyzing "public.p_ci_runner_machine_builds" inheritance tree
681INFO: analyzing "gitlab_partitions_dynamic.ci_runner_machine_builds_100"
682INFO: "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
683INFO: analyzing "public.p_ci_job_annotations" inheritance tree
684INFO: analyzing "gitlab_partitions_dynamic.ci_job_annotations_100"
685INFO: "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
686INFO: analyzing "public.p_ci_builds_metadata" inheritance tree
687INFO: analyzing "public.ci_builds_metadata"
688INFO: "ci_builds_metadata": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
689INFO: analyzing "public.p_ci_builds" inheritance tree
690INFO: analyzing "public.ci_builds"
691INFO: "ci_builds": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
692I, [2023-10-19T10:33:53.559366 #329] INFO -- : Database: 'main', Table: 'p_ci_finished_build_ch_sync_events': Lock Writes
693Gitlab::BackgroundMigration::RenameTaskSystemNoteToChecklistItem
694 # order random
695 tracks timings of queries
696 renames task to checklist item in task system notes that match
697 updates in batches
698Gitlab::BackgroundMigration::BackfillProjectFeaturePackageRegistryAccessLevel
699 backfills project_features.package_registry_access_level
700Gitlab::BackgroundMigration::DeleteOrphansApprovalProjectRules
701 # order random
702 #perform
703 delete only approval rules without association with the security project and report_type equals to 4
704Gitlab::BackgroundMigration::UpdateDelayedProjectRemovalToNullForUserNamespaces
705 updates `delayed_project_removal` column to null for user namespaces
706Gitlab::BackgroundMigration::UpdateCiPipelineArtifactsUnknownLockedStatus
707 # order random
708 #perform
709 updates ci_pipeline_artifacts with unknown lock status
710Gitlab::BackgroundMigration::EncryptCiTriggerToken
711 # order random
712 ensures all unencrypted tokens are encrypted
713Gitlab::BackgroundMigration::UpdateJiraTrackerDataDeploymentTypeBasedOnUrl
714 changes unknown deployment_types based on URL
715Knapsack report was generated. Preview:
716{
717 "spec/lib/gitlab/background_migration/backfill_snippet_repositories_spec.rb": 141.73932666900055,
718 "spec/lib/gitlab/background_migration/backfill_work_item_type_id_for_issues_spec.rb": 60.40400449200024,
719 "spec/lib/gitlab/background_migration/cleanup_orphaned_routes_spec.rb": 59.88808158899974,
720 "spec/lib/gitlab/background_migration/destroy_invalid_project_members_spec.rb": 59.23232191599982,
721 "spec/lib/gitlab/background_migration/disable_legacy_open_source_license_for_no_issues_no_repo_projects_spec.rb": 59.13252297500003,
722 "spec/lib/gitlab/background_migration/job_coordinator_spec.rb": 48.915484311,
723 "spec/lib/gitlab/background_migration/backfill_internal_on_notes_spec.rb": 50.827953471999535,
724 "spec/lib/gitlab/background_migration/delete_orphaned_packages_dependencies_spec.rb": 43.631554706000315,
725 "spec/lib/gitlab/background_migration/populate_vulnerability_dismissal_fields_spec.rb": 41.42380306299947,
726 "spec/lib/gitlab/background_migration/backfill_design_management_repositories_spec.rb": 40.275064239999665,
727 "spec/lib/gitlab/background_migration/remove_invalid_deploy_access_level_groups_spec.rb": 35.270334118999926,
728 "spec/lib/gitlab/background_migration/backfill_code_suggestions_namespace_settings_spec.rb": 34.763110087000314,
729 "spec/lib/gitlab/background_migration/backfill_default_branch_protection_namespace_setting_spec.rb": 18.64410655499978,
730 "spec/lib/gitlab/background_migration/copy_column_using_background_migration_job_spec.rb": 14.560368848000508,
731 "spec/lib/gitlab/background_migration/fix_allow_descendants_override_disabled_shared_runners_spec.rb": 11.381914014999893,
732 "spec/lib/gitlab/background_migration/backfill_nuget_normalized_version_spec.rb": 8.426119276000463,
733 "spec/lib/gitlab/background_migration/backfill_has_merge_request_of_vulnerability_reads_spec.rb": 8.291975989000093,
734 "spec/lib/gitlab/background_migration/backfill_user_preferences_with_defaults_spec.rb": 7.5619800349995785,
735 "spec/lib/gitlab/background_migration/rename_task_system_note_to_checklist_item_spec.rb": 5.833309121999264,
736 "spec/lib/gitlab/background_migration/backfill_project_feature_package_registry_access_level_spec.rb": 2.18357042200023,
737 "spec/lib/gitlab/background_migration/delete_orphans_approval_project_rules_spec.rb": 2.034962136000104,
738 "spec/lib/gitlab/background_migration/update_delayed_project_removal_to_null_for_user_namespaces_spec.rb": 2.038603136000347,
739 "spec/lib/gitlab/background_migration/update_ci_pipeline_artifacts_unknown_locked_status_spec.rb": 2.0845940910003264,
740 "spec/lib/gitlab/background_migration/encrypt_ci_trigger_token_spec.rb": 1.9112504269996862,
741 "spec/lib/gitlab/background_migration/update_jira_tracker_data_deployment_type_based_on_url_spec.rb": 1.9945986390002872
742}
743Knapsack global time execution for tests: 12m 42s
744Finished in 25 minutes 32 seconds (files took 40.04 seconds to load)
745113 examples, 0 failures
746Randomized with seed 19206
747[TEST PROF INFO] Time spent in factories: 00:00.301 (0.02% of total time)
748RSpec exited with 0.
749No examples to retry, congrats!
750 Running after_script 00:04
751Running after script...
752$ echo -e "\e[0Ksection_start:`date +%s`:report_results_section[collapsed=true]\r\e[0KReport results"
753 Report results 00:02
758$ tooling/bin/push_job_metrics || true
759[job-metrics] Pushing job metrics file for the CI/CD job.
760[job-metrics] Pushed 4 CI job metric entries to InfluxDB.
761 Saving cache for successful job 00:00
762Not uploading cache ruby-gems-debian-bullseye-ruby-3.0-16 due to policy
763 Uploading artifacts for successful job 00:04
764Uploading artifacts...
765WARNING: auto_explain/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab)
766coverage/: found 5 matching artifact files and directories
767crystalball/: found 2 matching artifact files and directories
768WARNING: deprecations/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab)
769knapsack/: found 4 matching artifact files and directories
770rspec/: found 16 matching artifact files and directories
771WARNING: tmp/capybara/: no matching files. Ensure that the artifact path is relative to the working directory (/builds/gitlab-org/gitlab)
772log/*.log: found 13 matching artifact files and directories
773WARNING: Upload request redirected location=https://gitlab.com/api/v4/jobs/5328358176/artifacts?artifact_format=zip&artifact_type=archive&expire_in=31d new-url=https://gitlab.com
774WARNING: Retrying... context=artifacts-uploader error=request redirected
775Uploading artifacts as "archive" to coordinator... 201 Created id=5328358176 responseStatus=201 Created token=64_9GMbw
776Uploading artifacts...
777rspec/rspec-*.xml: found 1 matching artifact files and directories
778WARNING: Upload request redirected location=https://gitlab.com/api/v4/jobs/5328358176/artifacts?artifact_format=gzip&artifact_type=junit&expire_in=31d new-url=https://gitlab.com
779WARNING: Retrying... context=artifacts-uploader error=request redirected
780Uploading artifacts as "junit" to coordinator... 201 Created id=5328358176 responseStatus=201 Created token=64_9GMbw
781 Cleaning up project directory and file based variables 00:01
782Job succeeded