Skip to content
Snippets Groups Projects

db:rollback geo

Passed Started by
🤖 GitLab Bot 🤖
@gitlab-bot
1Running with gitlab-runner 17.0.0~pre.88.g761ae5dd (761ae5dd)
2 on green-4.private.runners-manager.gitlab.com/gitlab.com/gitlab-org rpvz2FF9, system ID: s_d704414ba02a
3 feature flags: FF_NETWORK_PER_BUILD:true
4Resolving secrets
5 Preparing the "docker+machine" executor 00:11
6Using Docker executor with image registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bookworm-ruby-3.1.5-golang-1.22-rust-1.73-node-20.12-postgresql-14:rubygems-3.4-git-2.36-lfs-2.9-chrome-123-yarn-1.22-graphicsmagick-1.3.36 ...
7Starting service registry.gitlab.com/gitlab-org/gitlab-build-images:postgres-14-pgvector-0.4.1 ...
8Authenticating with credentials from job payload (GitLab Registry)
9Pulling docker image registry.gitlab.com/gitlab-org/gitlab-build-images:postgres-14-pgvector-0.4.1 ...
10Using docker image sha256:82f132c22567f8ce17cc132c14b2f9aa3eaf9bb5424d91c2d966912433f0257d for registry.gitlab.com/gitlab-org/gitlab-build-images:postgres-14-pgvector-0.4.1 with digest registry.gitlab.com/gitlab-org/gitlab-build-images@sha256:c55e1364ee4327b244a9cfa1750f19feea14fc774eaf792b725967d146eb45f5 ...
11WARNING: Service registry.gitlab.com/gitlab-org/gitlab-build-images:redis-cluster-6.2.12 is already created. Ignoring.
12WARNING: Service registry.gitlab.com/gitlab-org/gitlab-build-images:redis-cluster-6.2.12 is already created. Ignoring.
13Starting service registry.gitlab.com/gitlab-org/gitlab-build-images:redis-cluster-6.2.12 ...
14Authenticating with credentials from job payload (GitLab Registry)
15Pulling docker image registry.gitlab.com/gitlab-org/gitlab-build-images:redis-cluster-6.2.12 ...
16Using docker image sha256:5c5ba5b83d6c60cb0b225bd670b7a43be8c238cc72347d24af57e5027c3648f3 for registry.gitlab.com/gitlab-org/gitlab-build-images:redis-cluster-6.2.12 with digest registry.gitlab.com/gitlab-org/gitlab-build-images@sha256:46aceab84c42d0e819c8e7940f2f98ce9e184785cd7b22d95872024a35f52407 ...
17Starting service redis:6.2-alpine ...
18Pulling docker image redis:6.2-alpine ...
19Using docker image sha256:36c1d3cfe18f4b12d4640576f7048068acbfc3625027b6bbb46bba0e31b11831 for redis:6.2-alpine with digest redis@sha256:e3b17ba9479deec4b7d1eeec1548a253acc5374d68d3b27937fcfe4df8d18c7e ...
20Waiting for services to be up and running (timeout 30 seconds)...
21Authenticating with credentials from job payload (GitLab Registry)
22Pulling docker image registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bookworm-ruby-3.1.5-golang-1.22-rust-1.73-node-20.12-postgresql-14:rubygems-3.4-git-2.36-lfs-2.9-chrome-123-yarn-1.22-graphicsmagick-1.3.36 ...
23Using docker image sha256:b26253b493531cada33f45ef568f38c50a310442d05c39f517656e0f7d305dc7 for registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bookworm-ruby-3.1.5-golang-1.22-rust-1.73-node-20.12-postgresql-14:rubygems-3.4-git-2.36-lfs-2.9-chrome-123-yarn-1.22-graphicsmagick-1.3.36 with digest registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bookworm-ruby-3.1.5-golang-1.22-rust-1.73-node-20.12-postgresql-14@sha256:543339542a02edc250c2c0424c5077b673f1fca2877024fdc5fb670eff44f8cf ...
24 Preparing environment 00:00
25Running on runner-rpvz2ff9-project-278964-concurrent-0 via runner-rpvz2ff9-private-1722414721-560265ff...
26 Getting source from Git repository 00:35
27Fetching changes with git depth set to 20...
28Initialized empty Git repository in /builds/gitlab-org/gitlab/.git/
29Created fresh repository.
30remote: Enumerating objects: 232541, done.
31remote: Counting objects: 100% (232541/232541), done.
32remote: Compressing objects: 100% (158939/158939), done.
33remote: Total 232541 (delta 126976), reused 142433 (delta 64809), pack-reused 0 (from 0)
34Receiving objects: 100% (232541/232541), 154.61 MiB | 29.67 MiB/s, done.
35Resolving deltas: 100% (126976/126976), done.
36From https://us-east1-d.ci-gateway.int.gprd.gitlab.net:8989/gitlab-org/gitlab
37 * [new ref] refs/pipelines/1395141577 -> refs/pipelines/1395141577
38 * [new branch] master -> origin/master
39Checking out adaf0a90 as detached HEAD (ref is master)...
40Skipping Git submodules setup
41$ git remote set-url origin "${CI_REPOSITORY_URL}"
42 Restoring cache 00:18
43Checking cache for ruby-gems-debian-bookworm-ruby-3.1.5-17...
44Downloading cache from https://storage.googleapis.com/gitlab-com-runners-cache/project/278964/ruby-gems-debian-bookworm-ruby-3.1.5-17
45Successfully extracted cache
46 Downloading artifacts 00:12
47Downloading artifacts for setup-test-env (7471344810)...
48Downloading artifacts from coordinator... ok host=storage.googleapis.com id=7471344810 responseStatus=200 OK token=glcbt-66
49 Executing "step_script" stage of the job script 02:27
50Using docker image sha256:b26253b493531cada33f45ef568f38c50a310442d05c39f517656e0f7d305dc7 for registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bookworm-ruby-3.1.5-golang-1.22-rust-1.73-node-20.12-postgresql-14:rubygems-3.4-git-2.36-lfs-2.9-chrome-123-yarn-1.22-graphicsmagick-1.3.36 with digest registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bookworm-ruby-3.1.5-golang-1.22-rust-1.73-node-20.12-postgresql-14@sha256:543339542a02edc250c2c0424c5077b673f1fca2877024fdc5fb670eff44f8cf ...
51$ echo $FOSS_ONLY
52$ [ "$FOSS_ONLY" = "1" ] && rm -rf ee/ qa/spec/ee/ qa/qa/specs/features/ee/ qa/qa/ee/ qa/qa/ee.rb
53$ export GOPATH=$CI_PROJECT_DIR/.go
54$ mkdir -p $GOPATH
55$ source scripts/utils.sh
56$ source scripts/prepare_build.sh
57 Installing gems 00:26
86Using decomposed database config (config/database.yml.decomposed-postgresql)
87Geo DB will be set up.
88Embedding DB won't be set up.
89 Setting up DBs 01:13
102$ bundle exec rake db:migrate:geo VERSION=20170627195211
103geo: == [advisory_lock_connection] object_id: 113980, pg_backend_pid: 139
104geo: == 20240214235418 RemoveDesignManagementRepositoryRegistryForceToRedownloadColumn: reverting
105geo: -- add_column(:design_management_repository_registry, :force_to_redownload, :boolean, {:default=>false, :null=>false, :if_not_exists=>true})
106geo: -> 0.0276s
107geo: == 20240214235418 RemoveDesignManagementRepositoryRegistryForceToRedownloadColumn: reverted (0.0291s)
108geo: == 20240214235349 RemoveGroupWikiRepositoryRegistryForceToRedownloadColumn: reverting
109geo: -- add_column(:group_wiki_repository_registry, :force_to_redownload, :boolean, {:if_not_exists=>true})
110geo: -> 0.0032s
111geo: == 20240214235349 RemoveGroupWikiRepositoryRegistryForceToRedownloadColumn: reverted (0.0035s)
112geo: == 20240214235323 RemoveProjectRepositoryRegistryForceToRedownloadColumn: reverting
113geo: -- add_column(:project_repository_registry, :force_to_redownload, :boolean, {:default=>false, :null=>false, :if_not_exists=>true})
114geo: -> 0.0035s
115geo: == 20240214235323 RemoveProjectRepositoryRegistryForceToRedownloadColumn: reverted (0.0037s)
116geo: == 20240214235239 RemoveProjectWikiRepositoryRegistryForceToRedownloadColumn: reverting
117geo: -- add_column(:project_wiki_repository_registry, :force_to_redownload, :boolean, {:default=>false, :null=>false, :if_not_exists=>true})
118geo: -> 0.0041s
119geo: == 20240214235239 RemoveProjectWikiRepositoryRegistryForceToRedownloadColumn: reverted (0.0044s)
120geo: == 20240214235202 RemoveSnippetRepositoryRegistryForceToRedownloadColumn: reverting
121geo: -- add_column(:snippet_repository_registry, :force_to_redownload, :boolean, {:if_not_exists=>true})
122geo: -> 0.0032s
123geo: == 20240214235202 RemoveSnippetRepositoryRegistryForceToRedownloadColumn: reverted (0.0035s)
124geo: == 20231205202917 RemoveGeoSecondaryDeprecatedWorkersJobInstances: reverting ==
125geo: == 20231205202917 RemoveGeoSecondaryDeprecatedWorkersJobInstances: reverted (0.0002s)
126geo: == 20231023230850 DropProjectRegistry: reverting ==============================
127geo: -- create_table(:project_registry, {:id=>:serial, :force=>:cascade})
128geo: -> 0.0227s
129geo: == 20231023230850 DropProjectRegistry: reverted (0.0230s) =====================
130geo: == 20230918101143 DropDesignRegistry: reverting ===============================
131geo: -- create_table(:design_registry, {:id=>:serial, :force=>:cascade})
132geo: -> 0.0060s
133geo: == 20230918101143 DropDesignRegistry: reverted (0.0064s) ======================
134geo: == 20230808031211 ResyncDirectUploadJobArtifactRegistry: reverting ============
135geo: == 20230808031211 ResyncDirectUploadJobArtifactRegistry: reverted (0.0002s) ===
136geo: == 20230717200028 AddTextLimitToGroupWikiRepositoryRegistryVerificationFailure: reverting
137geo: -- transaction_open?(nil)
138geo: -> 0.0000s
139geo: -- transaction_open?(nil)
140geo: -> 0.0000s
141geo: -- execute(" ALTER TABLE group_wiki_repository_registry\n DROP CONSTRAINT IF EXISTS check_0a6e7bc04a\n")
142geo: -> 0.0010s
143geo: == 20230717200028 AddTextLimitToGroupWikiRepositoryRegistryVerificationFailure: reverted (0.0037s)
144geo: == 20230717195815 CreateGroupWikiRepositoryRegistryVerificationIndexies: reverting
145geo: -- transaction_open?(nil)
146geo: -> 0.0000s
147geo: -- view_exists?(:postgres_partitions)
148geo: -> 0.0011s
149geo: -- index_exists?(:group_wiki_repository_registry, :verification_retry_at, {:name=>:group_wiki_repository_registry_failed_verification, :algorithm=>:concurrently})
150geo: -> 0.0066s
151geo: -- remove_index(:group_wiki_repository_registry, {:name=>:group_wiki_repository_registry_failed_verification, :algorithm=>:concurrently, :column=>:verification_retry_at})
152geo: -> 0.0067s
153geo: -- transaction_open?(nil)
154geo: -> 0.0000s
155geo: -- view_exists?(:postgres_partitions)
156geo: -> 0.0010s
157geo: -- index_exists?(:group_wiki_repository_registry, :verification_state, {:name=>:group_wiki_repository_registry_needs_verification, :algorithm=>:concurrently})
158geo: -> 0.0051s
159geo: -- remove_index(:group_wiki_repository_registry, {:name=>:group_wiki_repository_registry_needs_verification, :algorithm=>:concurrently, :column=>:verification_state})
160geo: -> 0.0057s
161geo: -- transaction_open?(nil)
162geo: -> 0.0000s
163geo: -- view_exists?(:postgres_partitions)
164geo: -> 0.0009s
165geo: -- index_exists?(:group_wiki_repository_registry, :verified_at, {:name=>:container_repository_registry_pending_verification, :algorithm=>:concurrently})
166geo: -> 0.0043s
167geo: == 20230717195815 CreateGroupWikiRepositoryRegistryVerificationIndexies: reverted (0.0390s)
168geo: == 20230717195110 PrepareGroupWikiRepositoryRegistryForVerification: reverting
169geo: -- remove_column(:group_wiki_repository_registry, :verified_at)
170geo: -> 0.0008s
171geo: -- remove_column(:group_wiki_repository_registry, :verification_started_at)
172geo: -> 0.0006s
173geo: -- remove_column(:group_wiki_repository_registry, :verification_retry_at)
174geo: -> 0.0006s
175geo: -- remove_column(:group_wiki_repository_registry, :verification_state)
176geo: -> 0.0009s
177geo: -- remove_column(:group_wiki_repository_registry, :verification_retry_count)
178geo: -> 0.0008s
179geo: -- remove_column(:group_wiki_repository_registry, :checksum_mismatch)
180geo: -> 0.0007s
181geo: -- remove_column(:group_wiki_repository_registry, :verification_checksum)
182geo: -> 0.0007s
183geo: -- remove_column(:group_wiki_repository_registry, :verification_checksum_mismatched)
184geo: -> 0.0007s
185geo: -- remove_column(:group_wiki_repository_registry, :verification_failure)
186geo: -> 0.0006s
187geo: == 20230717195110 PrepareGroupWikiRepositoryRegistryForVerification: reverted (0.0070s)
188geo: == 20230418172503 CreateProjectRepositoryRegistry: reverting ==================
189geo: -- drop_table(:project_repository_registry, {:id=>:bigserial, :force=>:cascade})
190geo: -> 0.0017s
191geo: == 20230418172503 CreateProjectRepositoryRegistry: reverted (0.0044s) =========
192geo: == 20230323102034 CreateDesignManagementRepositoryRegistry: reverting =========
193geo: -- drop_table(:design_management_repository_registry, {:id=>:bigserial, :force=>:cascade})
194geo: -> 0.0016s
195geo: == 20230323102034 CreateDesignManagementRepositoryRegistry: reverted (0.0020s)
196geo: == 20230201312431 AddTextLimitToContainerRepositoryRegistryVerificationFailure: reverting
197geo: -- transaction_open?(nil)
198geo: -> 0.0000s
199geo: -- transaction_open?(nil)
200geo: -> 0.0000s
201geo: -- execute(" ALTER TABLE container_repository_registry\n DROP CONSTRAINT IF EXISTS check_9b8292bb64\n")
202geo: -> 0.0007s
203geo: == 20230201312431 AddTextLimitToContainerRepositoryRegistryVerificationFailure: reverted (0.0034s)
204geo: == 20230201121712 CreateContainerRepositoryRegistryVerificationIndexies: reverting
205geo: -- transaction_open?(nil)
206geo: -> 0.0000s
207geo: -- view_exists?(:postgres_partitions)
208geo: -> 0.0010s
209geo: -- index_exists?(:container_repository_registry, :verification_retry_at, {:name=>:container_repository_registry_failed_verification, :algorithm=>:concurrently})
210geo: -> 0.0058s
211geo: -- remove_index(:container_repository_registry, {:name=>:container_repository_registry_failed_verification, :algorithm=>:concurrently, :column=>:verification_retry_at})
212geo: -> 0.0064s
213geo: -- transaction_open?(nil)
214geo: -> 0.0000s
215geo: -- view_exists?(:postgres_partitions)
216geo: -> 0.0010s
217geo: -- index_exists?(:container_repository_registry, :verification_state, {:name=>:container_repository_registry_needs_verification, :algorithm=>:concurrently})
218geo: -> 0.0050s
219geo: -- remove_index(:container_repository_registry, {:name=>:container_repository_registry_needs_verification, :algorithm=>:concurrently, :column=>:verification_state})
220geo: -> 0.0057s
221geo: -- transaction_open?(nil)
222geo: -> 0.0000s
223geo: -- view_exists?(:postgres_partitions)
224geo: -> 0.0009s
225geo: -- index_exists?(:container_repository_registry, :verified_at, {:name=>:container_repository_registry_pending_verification, :algorithm=>:concurrently})
226geo: -> 0.0041s
227geo: -- remove_index(:container_repository_registry, {:name=>:container_repository_registry_pending_verification, :algorithm=>:concurrently, :column=>:verified_at})
228geo: -> 0.0050s
229geo: == 20230201121712 CreateContainerRepositoryRegistryVerificationIndexies: reverted (0.0436s)
230geo: == 20230201110601 PrepareContainerRepositoryRegistryForVerification: reverting
231geo: -- remove_column(:container_repository_registry, :verified_at)
232geo: -> 0.0007s
233geo: -- remove_column(:container_repository_registry, :verification_started_at)
234geo: -> 0.0006s
235geo: -- remove_column(:container_repository_registry, :verification_retry_at)
236geo: -> 0.0007s
237geo: -- remove_column(:container_repository_registry, :verification_state)
238geo: -> 0.0008s
239geo: -- remove_column(:container_repository_registry, :verification_retry_count)
240geo: -> 0.0007s
241geo: -- remove_column(:container_repository_registry, :verification_checksum)
242geo: -> 0.0006s
243geo: -- remove_column(:container_repository_registry, :verification_checksum_mismatched)
244geo: -> 0.0006s
245geo: -- remove_column(:container_repository_registry, :checksum_mismatch)
246geo: -> 0.0006s
247geo: -- remove_column(:container_repository_registry, :verification_failure)
248geo: -> 0.0006s
249geo: == 20230201110601 PrepareContainerRepositoryRegistryForVerification: reverted (0.0066s)
250geo: == 20230123021021 TruncateContainerRepositoryRegistry2: reverting =============
251geo: == 20230123021021 TruncateContainerRepositoryRegistry2: reverted (0.0002s) ====
252geo: == 20230116223815 TruncateProjectWikiRepositoryRegistry: reverting ============
253geo: == 20230116223815 TruncateProjectWikiRepositoryRegistry: reverted (0.0001s) ===
254geo: == 20230116222320 RemoveNotNullConstraintOnProjectWikiRepositoryRegistryProjectId: reverting
255geo: -- change_column_null(:project_wiki_repository_registry, :project_id, false)
256geo: -> 0.0008s
257geo: == 20230116222320 RemoveNotNullConstraintOnProjectWikiRepositoryRegistryProjectId: reverted (0.0010s)
258geo: == 20230116221137 AddNotNullConstraintToProjectWikiRepositoryId: reverting ====
259geo: -- transaction_open?(nil)
260geo: -> 0.0000s
261geo: -- transaction_open?(nil)
262geo: -> 0.0000s
263geo: -- execute(" ALTER TABLE project_wiki_repository_registry\n DROP CONSTRAINT IF EXISTS check_4112c47225\n")
264geo: -> 0.0007s
265geo: == 20230116221137 AddNotNullConstraintToProjectWikiRepositoryId: reverted (0.0035s)
266geo: == 20230116220255 AddIndexToProjectWikiRepositoryRegistry: reverting ==========
267geo: -- transaction_open?(nil)
268geo: -> 0.0000s
269geo: -- view_exists?(:postgres_partitions)
270geo: -> 0.0010s
271geo: -- indexes(:project_wiki_repository_registry)
272geo: -> 0.0063s
273geo: -- remove_index(:project_wiki_repository_registry, {:algorithm=>:concurrently, :name=>"idx_project_wiki_repository_registry_project_wiki_repository_id"})
274geo: -> 0.0009s
275geo: == 20230116220255 AddIndexToProjectWikiRepositoryRegistry: reverted (0.0111s) =
276geo: == 20230116215802 AddProjectWikiRepositoryIdToProjectWikiRepositoryRegistry: reverting
277geo: -- remove_column(:project_wiki_repository_registry, :project_wiki_repository_id)
278geo: -> 0.0007s
279geo: == 20230116215802 AddProjectWikiRepositoryIdToProjectWikiRepositoryRegistry: reverted (0.0009s)
280geo: == 20230104022140 TruncateContainerRepositoryRegistry: reverting ==============
281geo: == 20230104022140 TruncateContainerRepositoryRegistry: reverted (0.0001s) =====
282geo: == 20221107151025 RemoveJobArtifactRegistrySuccessColumn: reverting ===========
283geo: -- column_exists?(:job_artifact_registry, :success)
284geo: -> 0.0026s
285geo: -- add_column(:job_artifact_registry, :success, :boolean)
286geo: -> 0.0008s
287geo: -- transaction_open?(nil)
288geo: -> 0.0000s
289geo: -- view_exists?(:postgres_partitions)
290geo: -> 0.0010s
291geo: -- index_exists?(:job_artifact_registry, :success, {:algorithm=>:concurrently})
292geo: -> 0.0050s
293geo: -- add_index(:job_artifact_registry, :success, {:algorithm=>:concurrently})
294geo: -> 0.0014s
295geo: == 20221107151025 RemoveJobArtifactRegistrySuccessColumn: reverted (0.0138s) ==
296geo: == 20221102195145 CreateDependencyProxyManifestRegistry: reverting ============
297geo: -- drop_table(:dependency_proxy_manifest_registry, {:id=>:bigserial, :force=>:cascade})
298geo: -> 0.0016s
299geo: == 20221102195145 CreateDependencyProxyManifestRegistry: reverted (0.0019s) ===
300geo: == 20221018201808 CreateDependencyProxyBlobRegistry: reverting ================
301geo: -- drop_table(:dependency_proxy_blob_registry)
302geo: -> 0.0022s
303geo: == 20221018201808 CreateDependencyProxyBlobRegistry: reverted (0.0024s) =======
304geo: == 20221017195204 CreateProjectWikiRepositoryRegistry: reverting ==============
305geo: -- drop_table(:project_wiki_repository_registry, {:id=>:bigserial, :force=>:cascade})
306geo: -> 0.0017s
307geo: == 20221017195204 CreateProjectWikiRepositoryRegistry: reverted (0.0020s) =====
308geo: == 20220617125507 CreateCiSecureFileRegistry: reverting =======================
309geo: -- drop_table(:ci_secure_file_registry)
310geo: -> 0.0023s
311geo: == 20220617125507 CreateCiSecureFileRegistry: reverted (0.0025s) ==============
312geo: == 20220202101354 MigrateJobArtifactRegistry: reverting =======================
313geo: == 20220202101354 MigrateJobArtifactRegistry: reverted (0.0000s) ==============
314geo: == 20211207175940 AddTextLimitToPagesDeploymentRegistryVerificationFailure: reverting
315geo: -- transaction_open?(nil)
316geo: -> 0.0000s
317geo: -- transaction_open?(nil)
318geo: -> 0.0000s
319geo: -- execute(" ALTER TABLE pages_deployment_registry\n DROP CONSTRAINT IF EXISTS check_7eb0430eff\n")
320geo: -> 0.0006s
321geo: == 20211207175940 AddTextLimitToPagesDeploymentRegistryVerificationFailure: reverted (0.0028s)
322geo: == 20211207162157 AddIndexesToPagesDeploymentRegistry: reverting ==============
323geo: -- transaction_open?(nil)
324geo: -> 0.0000s
325geo: -- view_exists?(:postgres_partitions)
326geo: -> 0.0006s
327geo: -- indexes(:pages_deployment_registry)
328geo: -> 0.0033s
329geo: -- remove_index(:pages_deployment_registry, {:algorithm=>:concurrently, :name=>"index_pages_deployment_registry_on_pages_deployment_id"})
330geo: -> 0.0010s
331geo: -- transaction_open?(nil)
332geo: -> 0.0000s
333geo: -- view_exists?(:postgres_partitions)
334geo: -> 0.0005s
335geo: -- indexes(:pages_deployment_registry)
336geo: -> 0.0028s
337geo: -- remove_index(:pages_deployment_registry, {:algorithm=>:concurrently, :name=>"pages_deployment_registry_failed_verification"})
338geo: -> 0.0009s
339geo: -- transaction_open?(nil)
340geo: -> 0.0000s
341geo: -- view_exists?(:postgres_partitions)
342geo: -> 0.0005s
343geo: -- indexes(:pages_deployment_registry)
344geo: -> 0.0023s
345geo: -- remove_index(:pages_deployment_registry, {:algorithm=>:concurrently, :name=>"pages_deployment_registry_needs_verification"})
346geo: -> 0.0008s
347geo: -- transaction_open?(nil)
348geo: -> 0.0000s
349geo: -- view_exists?(:postgres_partitions)
350geo: -> 0.0004s
351geo: -- indexes(:pages_deployment_registry)
352geo: -> 0.0022s
353geo: -- remove_index(:pages_deployment_registry, {:algorithm=>:concurrently, :name=>"pages_deployment_registry_pending_verification"})
354geo: -> 0.0009s
355geo: == 20211207162157 AddIndexesToPagesDeploymentRegistry: reverted (0.0237s) =====
356geo: == 20211126312431 AddTextLimitToFileRegistryVerificationFailure: reverting ====
357geo: -- transaction_open?(nil)
358geo: -> 0.0000s
359geo: -- transaction_open?(nil)
360geo: -> 0.0000s
361geo: -- execute(" ALTER TABLE file_registry\n DROP CONSTRAINT IF EXISTS check_1886652634\n")
362geo: -> 0.0006s
363geo: == 20211126312431 AddTextLimitToFileRegistryVerificationFailure: reverted (0.0030s)
364geo: == 20211124000002 AddIndexesToLfsObjectRegistry: reverting ====================
365geo: -- transaction_open?(nil)
366geo: -> 0.0000s
367geo: -- view_exists?(:postgres_partitions)
368geo: -> 0.0005s
369geo: -- indexes(:lfs_object_registry)
370geo: -> 0.0034s
371geo: -- remove_index(:lfs_object_registry, {:algorithm=>:concurrently, :name=>"index_lfs_object_registry_on_lfs_object_id"})
372geo: -> 0.0009s
373geo: -- transaction_open?(nil)
374geo: -> 0.0000s
375geo: -- view_exists?(:postgres_partitions)
376geo: -> 0.0006s
377geo: -- indexes(:lfs_object_registry)
378geo: -> 0.0031s
379geo: -- remove_index(:lfs_object_registry, {:algorithm=>:concurrently, :name=>"lfs_object_registry_failed_verification"})
380geo: -> 0.0009s
381geo: -- transaction_open?(nil)
382geo: -> 0.0000s
383geo: -- view_exists?(:postgres_partitions)
384geo: -> 0.0005s
385geo: -- indexes(:lfs_object_registry)
386geo: -> 0.0028s
387geo: -- remove_index(:lfs_object_registry, {:algorithm=>:concurrently, :name=>"lfs_object_registry_needs_verification"})
388geo: -> 0.0009s
389geo: -- transaction_open?(nil)
390geo: -> 0.0000s
391geo: -- view_exists?(:postgres_partitions)
392geo: -> 0.0005s
393geo: -- indexes(:lfs_object_registry)
394geo: -> 0.0024s
395geo: -- remove_index(:lfs_object_registry, {:algorithm=>:concurrently, :name=>"lfs_object_registry_pending_verification"})
396geo: -> 0.0009s
397geo: == 20211124000002 AddIndexesToLfsObjectRegistry: reverted (0.0252s) ===========
398geo: == 20211124000001 AddTextLimitToLfsObjectRegistryVerificationFailure: reverting
399geo: -- transaction_open?(nil)
400geo: -> 0.0000s
401geo: -- transaction_open?(nil)
402geo: -> 0.0000s
403geo: -- execute(" ALTER TABLE lfs_object_registry\n DROP CONSTRAINT IF EXISTS check_8bcaa12138\n")
404geo: -> 0.0006s
405geo: == 20211124000001 AddTextLimitToLfsObjectRegistryVerificationFailure: reverted (0.0031s)
406geo: == 20211124000000 AddVerificationToLfsObjectRegistry: reverting ===============
407geo: -- remove_column(:lfs_object_registry, :verification_failure, :text)
408geo: -> 0.0007s
409geo: -- remove_column(:lfs_object_registry, :verification_checksum_mismatched, :binary)
410geo: -> 0.0007s
411geo: -- remove_column(:lfs_object_registry, :verification_checksum, :binary)
412geo: -> 0.0006s
413geo: -- remove_column(:lfs_object_registry, :checksum_mismatch, :boolean, {:default=>false, :null=>false})
414geo: -> 0.0007s
415geo: -- remove_column(:lfs_object_registry, :verification_state, :integer, {:limit=>2, :default=>0, :null=>false})
416geo: -> 0.0006s
417geo: -- remove_column(:lfs_object_registry, :verification_retry_count, :integer, {:default=>0})
418geo: -> 0.0008s
419geo: -- remove_column(:lfs_object_registry, :verification_retry_at, :datetime_with_timezone)
420geo: -> 0.0006s
421geo: -- remove_column(:lfs_object_registry, :verified_at, :datetime_with_timezone)
422geo: -> 0.0006s
423geo: -- remove_column(:lfs_object_registry, :verification_started_at, :datetime_with_timezone)
424geo: -> 0.0006s
425geo: == 20211124000000 AddVerificationToLfsObjectRegistry: reverted (0.0067s) ======
426geo: == 20211119152539 AddVerificationToPagesDeploymentRegistry: reverting =========
427geo: -- remove_column(:pages_deployment_registry, :verification_failure, :text)
428geo: -> 0.0006s
429geo: -- remove_column(:pages_deployment_registry, :verification_checksum_mismatched, :binary)
430geo: -> 0.0006s
431geo: -- remove_column(:pages_deployment_registry, :verification_checksum, :binary)
432geo: -> 0.0006s
433geo: -- remove_column(:pages_deployment_registry, :checksum_mismatch, :boolean, {:default=>false, :null=>false})
434geo: -> 0.0007s
435geo: -- remove_column(:pages_deployment_registry, :verification_state, :integer, {:limit=>2, :default=>0, :null=>false})
436geo: -> 0.0008s
437geo: -- remove_column(:pages_deployment_registry, :verification_retry_count, :integer, {:default=>0, :limit=>2, :null=>false})
438geo: -> 0.0007s
439geo: -- remove_column(:pages_deployment_registry, :verification_retry_at, :datetime_with_timezone)
440geo: -> 0.0006s
441geo: -- remove_column(:pages_deployment_registry, :verified_at, :datetime_with_timezone)
442geo: -> 0.0006s
443geo: -- remove_column(:pages_deployment_registry, :verification_started_at, :datetime_with_timezone)
444geo: -> 0.0006s
445geo: == 20211119152539 AddVerificationToPagesDeploymentRegistry: reverted (0.0066s)
446geo: == 20211102121712 CreateFileRegistryVerificationIndexies: reverting ===========
447geo: -- transaction_open?(nil)
448geo: -> 0.0000s
449geo: -- view_exists?(:postgres_partitions)
450geo: -> 0.0006s
451geo: -- index_exists?(:file_registry, :verification_retry_at, {:name=>:file_registry_failed_verification, :algorithm=>:concurrently})
452geo: -> 0.0025s
453geo: -- remove_index(:file_registry, {:name=>:file_registry_failed_verification, :algorithm=>:concurrently, :column=>:verification_retry_at})
454geo: -> 0.0031s
455geo: -- transaction_open?(nil)
456geo: -> 0.0000s
457geo: -- view_exists?(:postgres_partitions)
458geo: -> 0.0005s
459geo: -- index_exists?(:file_registry, :verification_state, {:name=>:file_registry_needs_verification, :algorithm=>:concurrently})
460geo: -> 0.0020s
461geo: -- remove_index(:file_registry, {:name=>:file_registry_needs_verification, :algorithm=>:concurrently, :column=>:verification_state})
462geo: -> 0.0027s
463geo: -- transaction_open?(nil)
464geo: -> 0.0000s
465geo: -- view_exists?(:postgres_partitions)
466geo: -> 0.0006s
467geo: -- index_exists?(:file_registry, :verified_at, {:name=>:file_registry_pending_verification, :algorithm=>:concurrently})
468geo: -> 0.0018s
469geo: -- remove_index(:file_registry, {:name=>:file_registry_pending_verification, :algorithm=>:concurrently, :column=>:verified_at})
470geo: -> 0.0024s
471geo: == 20211102121712 CreateFileRegistryVerificationIndexies: reverted (0.0219s) ==
472geo: == 20211101113611 PrepareFileRegistryForVerification: reverting ===============
473geo: -- remove_column(:file_registry, :verified_at)
474geo: -> 0.0006s
475geo: -- remove_column(:file_registry, :verification_started_at)
476geo: -> 0.0006s
477geo: -- remove_column(:file_registry, :verification_retry_at)
478geo: -> 0.0007s
479geo: -- remove_column(:file_registry, :verification_state)
480geo: -> 0.0006s
481geo: -- remove_column(:file_registry, :verification_retry_count)
482geo: -> 0.0006s
483geo: -- remove_column(:file_registry, :verification_checksum)
484geo: -> 0.0006s
485geo: -- remove_column(:file_registry, :verification_checksum_mismatched)
486geo: -> 0.0006s
487geo: -- remove_column(:file_registry, :checksum_mismatch)
488geo: -> 0.0006s
489geo: -- remove_column(:file_registry, :verification_failure)
490geo: -> 0.0006s
491geo: == 20211101113611 PrepareFileRegistryForVerification: reverted (0.0060s) ======
492geo: == 20211021112221 RemoveUploadLegacyFields: reverting =========================
493geo: -- add_column(:file_registry, :sha256, :string)
494geo: -> 0.0008s
495geo: -- add_column(:file_registry, :bytes, :integer)
496geo: -> 0.0006s
497geo: -- add_column(:file_registry, :success, :boolean, {:null=>false})
498geo: -> 0.0014s
499geo: -- add_column(:file_registry, :file_type, :string, {:null=>false})
500geo: -> 0.0011s
501geo: == 20211021112221 RemoveUploadLegacyFields: reverted (0.0044s) ================
502== 20210820152707 CreatePagesDeploymentRegistry: reverting ====================
503-- drop_table(:pages_deployment_registry, {:id=>:bigserial, :force=>:cascade})
504 -> 0.0012s
505== 20210820152707 CreatePagesDeploymentRegistry: reverted (0.0014s) ===========
506== 20210818111211 FixStateColumnInFileRegistry: reverting =====================
507== 20210818111211 FixStateColumnInFileRegistry: reverted (0.0000s) ============
508== 20210706120644 PrepareFileRegistryForSsf: reverting ========================
509-- remove_column(:file_registry, :last_sync_failure, :string, {:limit=>255})
510 -> 0.0008s
511-- remove_column(:file_registry, :last_synced_at, :datetime_with_timezone)
512 -> 0.0007s
513-- remove_column(:file_registry, :state, :integer, {:null=>false, :limit=>2, :default=>0})
514 -> 0.0007s
515-- change_column_default(:file_registry, :retry_count, {:from=>0, :to=>nil})
516 -> 0.0019s
517== 20210706120644 PrepareFileRegistryForSsf: reverted (0.0046s) ===============
518== 20210624160455 FixStateColumnInLfsObjectRegistry: reverting ================
519== 20210624160455 FixStateColumnInLfsObjectRegistry: reverted (0.0000s) =======
520== 20210505170208 AddIndexesToMergeRequestDiffRegistryTable: reverting ========
521-- transaction_open?(nil)
522 -> 0.0000s
523-- view_exists?(:postgres_partitions)
524 -> 0.0005s
525-- indexes(:merge_request_diff_registry)
526 -> 0.0033s
527-- remove_index(:merge_request_diff_registry, {:algorithm=>:concurrently, :name=>"index_merge_request_diff_registry_on_mr_diff_id"})
528 -> 0.0009s
529-- transaction_open?(nil)
530 -> 0.0000s
531-- view_exists?(:postgres_partitions)
532 -> 0.0006s
533-- index_exists?(:merge_request_diff_registry, :merge_request_diff_id, {:name=>"index_merge_request_diff_registry_on_mr_diff_id", :algorithm=>:concurrently})
534 -> 0.0028s
535-- add_index(:merge_request_diff_registry, :merge_request_diff_id, {:name=>"index_merge_request_diff_registry_on_mr_diff_id", :algorithm=>:concurrently})
536 -> 0.0012s
537-- transaction_open?(nil)
538 -> 0.0000s
539-- view_exists?(:postgres_partitions)
540 -> 0.0005s
541-- indexes(:merge_request_diff_registry)
542 -> 0.0032s
543-- remove_index(:merge_request_diff_registry, {:algorithm=>:concurrently, :name=>"merge_request_diff_registry_failed_verification"})
544 -> 0.0009s
545-- transaction_open?(nil)
546 -> 0.0000s
547-- view_exists?(:postgres_partitions)
548 -> 0.0005s
549-- indexes(:merge_request_diff_registry)
550 -> 0.0028s
551-- remove_index(:merge_request_diff_registry, {:algorithm=>:concurrently, :name=>"merge_request_diff_registry_needs_verification"})
552 -> 0.0009s
553-- transaction_open?(nil)
554 -> 0.0000s
555-- view_exists?(:postgres_partitions)
556 -> 0.0006s
557-- indexes(:merge_request_diff_registry)
558 -> 0.0023s
559-- remove_index(:merge_request_diff_registry, {:algorithm=>:concurrently, :name=>"merge_request_diff_registry_pending_verification"})
560 -> 0.0008s
561== 20210505170208 AddIndexesToMergeRequestDiffRegistryTable: reverted (0.0318s)
562== 20210504143244 AddVerificationToMergeRequestDiffRegistry: reverting ========
563== 20210504143244 AddVerificationToMergeRequestDiffRegistry: reverted (0.0000s)
564== 20210420180119 AddIndexesToTerraformStateVersionRegistry: reverting ========
565-- transaction_open?(nil)
566 -> 0.0000s
567-- view_exists?(:postgres_partitions)
568 -> 0.0005s
569-- indexes(:terraform_state_version_registry)
570 -> 0.0035s
571-- remove_index(:terraform_state_version_registry, {:algorithm=>:concurrently, :name=>"index_terraform_state_version_registry_on_t_state_version_id"})
572 -> 0.0010s
573-- transaction_open?(nil)
574 -> 0.0000s
575-- view_exists?(:postgres_partitions)
576 -> 0.0005s
577-- indexes(:terraform_state_version_registry)
578 -> 0.0031s
579-- remove_index(:terraform_state_version_registry, {:algorithm=>:concurrently, :name=>:index_terraform_state_version_registry_on_retry_at})
580 -> 0.0009s
581-- transaction_open?(nil)
582 -> 0.0000s
583-- view_exists?(:postgres_partitions)
584 -> 0.0004s
585-- indexes(:terraform_state_version_registry)
586 -> 0.0029s
587-- remove_index(:terraform_state_version_registry, {:algorithm=>:concurrently, :name=>:index_terraform_state_version_registry_on_state})
588 -> 0.0009s
589-- transaction_open?(nil)
590 -> 0.0000s
591-- view_exists?(:postgres_partitions)
592 -> 0.0005s
593-- indexes(:terraform_state_version_registry)
594 -> 0.0028s
595-- remove_index(:terraform_state_version_registry, {:algorithm=>:concurrently, :name=>"terraform_state_version_registry_failed_verification"})
596 -> 0.0009s
597-- transaction_open?(nil)
598 -> 0.0000s
599-- view_exists?(:postgres_partitions)
600 -> 0.0005s
601-- indexes(:terraform_state_version_registry)
602 -> 0.0022s
603-- remove_index(:terraform_state_version_registry, {:algorithm=>:concurrently, :name=>"terraform_state_version_registry_needs_verification"})
604 -> 0.0009s
605-- transaction_open?(nil)
606 -> 0.0000s
607-- view_exists?(:postgres_partitions)
608 -> 0.0005s
609-- indexes(:terraform_state_version_registry)
610 -> 0.0017s
611-- remove_index(:terraform_state_version_registry, {:algorithm=>:concurrently, :name=>"terraform_state_version_registry_pending_verification"})
612 -> 0.0008s
613== 20210420180119 AddIndexesToTerraformStateVersionRegistry: reverted (0.0364s)
614== 20210407140527 AddVerificationToTerraformStateVersionRegistry: reverting ===
615-- remove_column(:terraform_state_version_registry, :verification_failure, :string, {:limit=>255})
616 -> 0.0007s
617-- remove_column(:terraform_state_version_registry, :verification_checksum_mismatched, :binary)
618 -> 0.0006s
619-- remove_column(:terraform_state_version_registry, :verification_checksum, :binary)
620 -> 0.0006s
621-- remove_column(:terraform_state_version_registry, :checksum_mismatch, :boolean, {:default=>false, :null=>false})
622 -> 0.0007s
623-- remove_column(:terraform_state_version_registry, :verification_state, :integer, {:limit=>2, :default=>0, :null=>false})
624 -> 0.0006s
625-- remove_column(:terraform_state_version_registry, :verification_retry_count, :integer, {:default=>0})
626 -> 0.0007s
627-- remove_column(:terraform_state_version_registry, :verification_retry_at, :datetime_with_timezone)
628 -> 0.0007s
629-- remove_column(:terraform_state_version_registry, :verified_at, :datetime_with_timezone)
630 -> 0.0006s
631-- remove_column(:terraform_state_version_registry, :verification_started_at, :datetime_with_timezone)
632 -> 0.0006s
633== 20210407140527 AddVerificationToTerraformStateVersionRegistry: reverted (0.0067s)
634== 20210325150435 CreatePipelineArtifactRegistry: reverting ===================
635-- drop_table(:pipeline_artifact_registry)
636 -> 0.0020s
637== 20210325150435 CreatePipelineArtifactRegistry: reverted (0.0021s) ==========
638== 20210313051642 AddVerificationIndexesToSnippetRepositoryRegistry: reverting
639-- transaction_open?(nil)
640 -> 0.0000s
641-- view_exists?(:postgres_partitions)
642 -> 0.0005s
643-- indexes(:snippet_repository_registry)
644 -> 0.0032s
645-- remove_index(:snippet_repository_registry, {:algorithm=>:concurrently, :name=>"snippet_repository_registry_pending_verification"})
646 -> 0.0009s
647-- transaction_open?(nil)
648 -> 0.0000s
649-- view_exists?(:postgres_partitions)
650 -> 0.0005s
651-- indexes(:snippet_repository_registry)
652 -> 0.0027s
653-- remove_index(:snippet_repository_registry, {:algorithm=>:concurrently, :name=>"snippet_repository_registry_failed_verification"})
654 -> 0.0010s
655-- transaction_open?(nil)
656 -> 0.0000s
657-- view_exists?(:postgres_partitions)
658 -> 0.0005s
659-- indexes(:snippet_repository_registry)
660 -> 0.0024s
661-- remove_index(:snippet_repository_registry, {:algorithm=>:concurrently, :name=>"snippet_repository_registry_needs_verification"})
662 -> 0.0009s
663== 20210313051642 AddVerificationIndexesToSnippetRepositoryRegistry: reverted (0.0186s)
664== 20210313050709 AddVerificationToSnippetRepositoryRegistry: reverting =======
665-- remove_column(:snippet_repository_registry, :verification_failure, :string, {:limit=>255})
666 -> 0.0007s
667-- remove_column(:snippet_repository_registry, :verification_checksum_mismatched, :binary)
668 -> 0.0006s
669-- remove_column(:snippet_repository_registry, :verification_checksum, :binary)
670 -> 0.0006s
671-- remove_column(:snippet_repository_registry, :checksum_mismatch, :boolean)
672 -> 0.0007s
673-- remove_column(:snippet_repository_registry, :verification_state, :integer, {:limit=>2, :default=>0, :null=>false})
674 -> 0.0007s
675-- remove_column(:snippet_repository_registry, :verification_retry_count, :integer)
676 -> 0.0007s
677-- remove_column(:snippet_repository_registry, :verification_retry_at, :datetime_with_timezone)
678 -> 0.0006s
679-- remove_column(:snippet_repository_registry, :verified_at, :datetime_with_timezone)
680 -> 0.0006s
681-- remove_column(:snippet_repository_registry, :verification_started_at, :datetime_with_timezone)
682 -> 0.0007s
683== 20210313050709 AddVerificationToSnippetRepositoryRegistry: reverted (0.0066s)
684== 20210225200858 AddTextLimitToLfsObjectRegistryLastSyncFailure: reverting ===
685-- transaction_open?(nil)
686 -> 0.0000s
687-- execute(" ALTER TABLE lfs_object_registry\n DROP CONSTRAINT IF EXISTS check_c41d57c1dc\n")
688 -> 0.0006s
689== 20210225200858 AddTextLimitToLfsObjectRegistryLastSyncFailure: reverted (0.0029s)
690== 20210223111722 CreateGroupWikiRepositoryRegistry: reverting ================
691-- drop_table(:group_wiki_repository_registry)
692 -> 0.0018s
693== 20210223111722 CreateGroupWikiRepositoryRegistry: reverted (0.0020s) =======
694== 20210217020156 AddUniqueIndexOnTerraformStateVersionRegistry: reverting ====
695-- transaction_open?(nil)
696 -> 0.0000s
697-- view_exists?(:postgres_partitions)
698 -> 0.0007s
699-- index_exists?(:terraform_state_version_registry, :terraform_state_version_id, {:name=>"index_tf_state_versions_registry_on_tf_state_versions_id", :algorithm=>:concurrently})
700 -> 0.0016s
701-- add_index(:terraform_state_version_registry, :terraform_state_version_id, {:name=>"index_tf_state_versions_registry_on_tf_state_versions_id", :algorithm=>:concurrently})
702 -> 0.0011s
703-- transaction_open?(nil)
704 -> 0.0000s
705-- view_exists?(:postgres_partitions)
706 -> 0.0004s
707-- indexes(:terraform_state_version_registry)
708 -> 0.0020s
709-- remove_index(:terraform_state_version_registry, {:algorithm=>:concurrently, :name=>"index_tf_state_versions_registry_tf_state_versions_id_unique"})
710 -> 0.0011s
711== 20210217020156 AddUniqueIndexOnTerraformStateVersionRegistry: reverted (0.0119s)
712== 20210217020154 AddUniqueIndexOnContainerRepositoryRegistry: reverting ======
713-- transaction_open?(nil)
714 -> 0.0000s
715-- view_exists?(:postgres_partitions)
716 -> 0.0005s
717-- index_exists?(:container_repository_registry, :container_repository_id, {:name=>"index_container_repository_registry_on_repository_id", :algorithm=>:concurrently})
718 -> 0.0022s
719-- add_index(:container_repository_registry, :container_repository_id, {:name=>"index_container_repository_registry_on_repository_id", :algorithm=>:concurrently})
720 -> 0.0012s
721-- transaction_open?(nil)
722 -> 0.0000s
723-- view_exists?(:postgres_partitions)
724 -> 0.0005s
725-- indexes(:container_repository_registry)
726 -> 0.0026s
727-- remove_index(:container_repository_registry, {:algorithm=>:concurrently, :name=>"index_container_repository_registry_repository_id_unique"})
728 -> 0.0010s
729== 20210217020154 AddUniqueIndexOnContainerRepositoryRegistry: reverted (0.0126s)
730== 20210208175408 CreateGeoSecondaryUsageData: reverting ======================
731-- drop_table(:secondary_usage_data)
732 -> 0.0012s
733== 20210208175408 CreateGeoSecondaryUsageData: reverted (0.0014s) =============
734== 20210125222907 AddLfsObjectStateIndex: reverting ===========================
735-- transaction_open?(nil)
736 -> 0.0000s
737-- view_exists?(:postgres_partitions)
738 -> 0.0006s
739-- index_exists?(:lfs_object_registry, :state, {:name=>"index_state_in_lfs_objects", :algorithm=>:concurrently})
740 -> 0.0022s
741-- remove_index(:lfs_object_registry, {:name=>"index_state_in_lfs_objects", :algorithm=>:concurrently, :column=>:state})
742 -> 0.0031s
743== 20210125222907 AddLfsObjectStateIndex: reverted (0.0082s) ==================
744== 20210120225014 MigrateLfsObjectRegistry: reverting =========================
745-- change_column_default(:lfs_object_registry, :retry_count, {:from=>0, :to=>nil})
746 -> 0.0021s
747-- remove_column(:lfs_object_registry, :state)
748 -> 0.0007s
749-- remove_column(:lfs_object_registry, :last_synced_at)
750 -> 0.0007s
751-- remove_column(:lfs_object_registry, :last_sync_failure)
752 -> 0.0006s
753== 20210120225014 MigrateLfsObjectRegistry: reverted (0.0044s) ================
754== 20210111912220 PrepareJobArtifactRegistryForSsfIndecies: reverting =========
755-- transaction_open?(nil)
756 -> 0.0000s
757-- view_exists?(:postgres_partitions)
758 -> 0.0006s
759-- index_exists?(:job_artifact_registry, :verification_retry_at, {:name=>:job_artifact_registry_failed_verification, :algorithm=>:concurrently})
760 -> 0.0035s
761-- remove_index(:job_artifact_registry, {:name=>:job_artifact_registry_failed_verification, :algorithm=>:concurrently, :column=>:verification_retry_at})
762 -> 0.0042s
763-- transaction_open?(nil)
764 -> 0.0000s
765-- view_exists?(:postgres_partitions)
766 -> 0.0005s
767-- index_exists?(:job_artifact_registry, :verification_state, {:name=>:job_artifact_registry_needs_verification, :algorithm=>:concurrently})
768 -> 0.0029s
769-- remove_index(:job_artifact_registry, {:name=>:job_artifact_registry_needs_verification, :algorithm=>:concurrently, :column=>:verification_state})
770 -> 0.0039s
771-- transaction_open?(nil)
772 -> 0.0000s
773-- view_exists?(:postgres_partitions)
774 -> 0.0005s
775-- index_exists?(:job_artifact_registry, :verified_at, {:name=>:job_artifact_registry_pending_verification, :algorithm=>:concurrently})
776 -> 0.0026s
777-- remove_index(:job_artifact_registry, {:name=>:job_artifact_registry_pending_verification, :algorithm=>:concurrently, :column=>:verified_at})
778 -> 0.0033s
779== 20210111912220 PrepareJobArtifactRegistryForSsfIndecies: reverted (0.0292s)
780== 20210111911002 PrepareJobArtifactRegistryForSsf: reverting =================
781-- remove_column(:job_artifact_registry, :last_sync_failure, :string, {:limit=>255})
782 -> 0.0008s
783-- remove_column(:job_artifact_registry, :verification_failure, :string, {:limit=>255})
784 -> 0.0007s
785-- remove_column(:job_artifact_registry, :checksum_mismatch, :boolean, {:default=>false, :null=>false})
786 -> 0.0008s
787-- remove_column(:job_artifact_registry, :verification_checksum_mismatched, :binary)
788 -> 0.0008s
789-- remove_column(:job_artifact_registry, :verification_checksum, :binary)
790 -> 0.0006s
791-- remove_column(:job_artifact_registry, :verification_retry_count, :integer, {:default=>0, :limit=>2, :null=>false})
792 -> 0.0007s
793-- remove_column(:job_artifact_registry, :verification_state, :integer, {:default=>0, :null=>false, :limit=>2})
794 -> 0.0007s
795-- remove_column(:job_artifact_registry, :state, :integer, {:null=>false, :limit=>2, :default=>0})
796 -> 0.0007s
797-- remove_column(:job_artifact_registry, :verification_retry_at, :datetime_with_timezone)
798 -> 0.0006s
799-- remove_column(:job_artifact_registry, :verification_started_at, :datetime_with_timezone)
800 -> 0.0006s
801-- remove_column(:job_artifact_registry, :verified_at, :datetime_with_timezone)
802 -> 0.0006s
803-- remove_column(:job_artifact_registry, :last_synced_at, :datetime_with_timezone)
804 -> 0.0006s
805-- change_column_default(:job_artifact_registry, :retry_count, {:from=>0, :to=>nil})
806 -> 0.0021s
807== 20210111911002 PrepareJobArtifactRegistryForSsf: reverted (0.0115s) ========
808== 20201208031224 AddVerificationIndexesToPackageFileRegistry: reverting ======
809-- transaction_open?(nil)
810 -> 0.0000s
811-- view_exists?(:postgres_partitions)
812 -> 0.0005s
813-- indexes(:package_file_registry)
814 -> 0.0036s
815-- remove_index(:package_file_registry, {:algorithm=>:concurrently, :name=>"package_file_registry_pending_verification"})
816 -> 0.0010s
817-- transaction_open?(nil)
818 -> 0.0000s
819-- view_exists?(:postgres_partitions)
820 -> 0.0005s
821-- indexes(:package_file_registry)
822 -> 0.0029s
823-- remove_index(:package_file_registry, {:algorithm=>:concurrently, :name=>"package_file_registry_failed_verification"})
824 -> 0.0010s
825-- transaction_open?(nil)
826 -> 0.0000s
827-- view_exists?(:postgres_partitions)
828 -> 0.0005s
829-- indexes(:package_file_registry)
830 -> 0.0026s
831-- remove_index(:package_file_registry, {:algorithm=>:concurrently, :name=>"package_file_registry_needs_verification"})
832 -> 0.0009s
833== 20201208031224 AddVerificationIndexesToPackageFileRegistry: reverted (0.0202s)
834== 20201208025254 AddVerificationFieldsToPackageFileRegistry: reverting =======
835-- remove_column(:package_file_registry, :verification_started_at, :datetime_with_timezone)
836 -> 0.0008s
837-- remove_column(:package_file_registry, :verification_state, :integer, {:default=>0, :limit=>2, :null=>false})
838 -> 0.0007s
839== 20201208025254 AddVerificationFieldsToPackageFileRegistry: reverted (0.0019s)
840== 20200924184638 RemoveNonVersionedTerraformStateRegistry: reverting =========
841-- create_table(:terraform_state_registry, {:id=>:bigserial, :force=>:cascade})
842 -> 0.0065s
843-- transaction_open?(nil)
844 -> 0.0000s
845-- execute("ALTER TABLE terraform_state_registry\nADD CONSTRAINT check_70a3f43f16\nCHECK ( char_length(last_sync_failure) <= 255 )\nNOT VALID;\n")
846 -> 0.0008s
847-- execute("ALTER TABLE terraform_state_registry VALIDATE CONSTRAINT check_70a3f43f16;")
848 -> 0.0006s
849== 20200924184638 RemoveNonVersionedTerraformStateRegistry: reverted (0.0151s)
850== 20200915152620 CreateTerraformStateVersionRegistry: reverting ==============
851-- drop_table(:terraform_state_version_registry)
852 -> 0.0016s
853== 20200915152620 CreateTerraformStateVersionRegistry: reverted (0.0018s) =====
854== 20200827120552 CreateMergeRequestDiffRegistry: reverting ===================
855-- drop_table(:merge_request_diff_registry)
856 -> 0.0017s
857== 20200827120552 CreateMergeRequestDiffRegistry: reverted (0.0018s) ==========
858== 20200811171011 CreateSnippetRepositoryRegistry: reverting ==================
859-- drop_table(:snippet_repository_registry)
860 -> 0.0020s
861== 20200811171011 CreateSnippetRepositoryRegistry: reverted (0.0022s) =========
862== 20200730133800 RemoveTableVulnerabilityExportRegistry: reverting ===========
863== 20200730133800 RemoveTableVulnerabilityExportRegistry: reverted (0.0000s) ==
864== 20200710194046 CreateVulnerabilityExportRegistry: reverting ================
865== 20200710194046 CreateVulnerabilityExportRegistry: reverted (0.0006s) =======
866== 20200707210300 CreateTerraformStateRegistry: reverting =====================
867-- drop_table(:terraform_state_registry)
868 -> 0.0019s
869== 20200707210300 CreateTerraformStateRegistry: reverted (0.0021s) ============
870== 20200707011052 AddVerifiedOnPrimaryColumnsToProjectRegistry: reverting =====
871-- remove_column(:project_registry, :primary_wiki_checksummed, :boolean, {:default=>false, :null=>false})
872 -> 0.0012s
873-- remove_column(:project_registry, :primary_repository_checksummed, :boolean, {:default=>false, :null=>false})
874 -> 0.0012s
875== 20200707011052 AddVerifiedOnPrimaryColumnsToProjectRegistry: reverted (0.0029s)
876== 20200407120740 AddVerificationFieldsToPackageFileOnSecondary: reverting ====
877-- remove_column(:package_file_registry, :verification_retry_at, :datetime_with_timezone)
878 -> 0.0007s
879-- remove_column(:package_file_registry, :verified_at, :datetime_with_timezone)
880 -> 0.0015s
881-- remove_column(:package_file_registry, :verification_retry_count, :integer)
882 -> 0.0011s
883-- remove_column(:package_file_registry, :verification_checksum_mismatched, :binary)
884 -> 0.0009s
885-- remove_column(:package_file_registry, :checksum_mismatch, :boolean)
886 -> 0.0009s
887-- remove_column(:package_file_registry, :verification_checksum, :binary)
888 -> 0.0008s
889-- remove_column(:package_file_registry, :verification_failure, :string, {:limit=>255})
890 -> 0.0008s
891== 20200407120740 AddVerificationFieldsToPackageFileOnSecondary: reverted (0.0075s)
892== 20200121194300 CreatePackageFileRegistry: reverting ========================
893-- drop_table(:package_file_registry, {:id=>:serial, :force=>:cascade})
894 -> 0.0013s
895== 20200121194300 CreatePackageFileRegistry: reverted (0.0016s) ===============
896== 20191025194337 DeleteLfsObjectsFromFileRegistry: reverting =================
897== 20191025194337 DeleteLfsObjectsFromFileRegistry: reverted (0.0000s) ========
898== 20191010204941 MigrateLfsObjectsToSeparateRegistry: reverting ==============
899-- execute("DELETE FROM lfs_object_registry WHERE ID IN (SELECT file_id FROM file_registry WHERE file_type = 'lfs')")
900 -> 0.0016s
901-- execute("DROP TRIGGER IF EXISTS replicate_lfs_object_registry ON file_registry")
902 -> 0.0008s
903-- execute("DROP FUNCTION IF EXISTS replicate_lfs_object_registry()")
904 -> 0.0007s
905== 20191010204941 MigrateLfsObjectsToSeparateRegistry: reverted (0.0034s) =====
906== 20191010203257 CreateLfsObjectRegistry: reverting ==========================
907-- drop_table(:lfs_object_registry, {:force=>:cascade})
908 -> 0.0012s
909== 20191010203257 CreateLfsObjectRegistry: reverted (0.0015s) =================
910== 20191007122326 AddUniqueConstraintOnDesignRegistryProjectId: reverting =====
911-- remove_index(:design_registry, :project_id, {:name=>"index_design_registry_on_project_id", :unique=>true})
912 -> 0.0032s
913-- add_index(:design_registry, :project_id, {:name=>"index_design_registry_on_project_id"})
914 -> 0.0012s
915== 20191007122326 AddUniqueConstraintOnDesignRegistryProjectId: reverted (0.0048s)
916== 20190923111102 AddDesignRegistry: reverting ================================
917-- drop_table(:design_registry, {:id=>:serial, :force=>:cascade})
918 -> 0.0013s
919== 20190923111102 AddDesignRegistry: reverted (0.0016s) =======================
920== 20190802200655 AddCreatedAtToEventLogStates: reverting =====================
921-- remove_column(:event_log_states, :created_at)
922 -> 0.0008s
923== 20190802200655 AddCreatedAtToEventLogStates: reverted (0.0008s) ============
924== 20190612211021 AddContainerRepositoryRegistry: reverting ===================
925-- drop_table(:container_repository_registry, {:id=>:serial, :force=>:cascade})
926 -> 0.0014s
927== 20190612211021 AddContainerRepositoryRegistry: reverted (0.0017s) ==========
928== 20190314201959 AddChecksumMismatchedColumndsToProjectRegistry: reverting ===
929-- remove_column(:project_registry, :wiki_verification_checksum_mismatched, :binary)
930 -> 0.0008s
931-- remove_column(:project_registry, :repository_verification_checksum_mismatched, :binary)
932 -> 0.0007s
933== 20190314201959 AddChecksumMismatchedColumndsToProjectRegistry: reverted (0.0018s)
934== 20181213184140 AddLastVerificationColumnsToProjectRegistry: reverting ======
935-- remove_column(:project_registry, :last_wiki_verification_ran_at, :datetime_with_timezone)
936 -> 0.0008s
937-- remove_column(:project_registry, :last_repository_verification_ran_at, :datetime_with_timezone)
938 -> 0.0008s
939== 20181213184140 AddLastVerificationColumnsToProjectRegistry: reverted (0.0019s)
940== 20180806020615 AddPendingSynchronizationsPartialIndex: reverting ===========
941-- transaction_open?(nil)
942 -> 0.0000s
943-- view_exists?(:postgres_partitions)
944 -> 0.0006s
945-- indexes(:project_registry)
946 -> 0.0076s
947-- remove_index(:project_registry, nil, {:algorithm=>:concurrently, :name=>"idx_project_registry_pending_repositories_partial"})
948 -> 0.0011s
949== 20180806020615 AddPendingSynchronizationsPartialIndex: reverted (0.0130s) ==
950== 20180806011909 AddFailedSynchronizationsPartialIndex: reverting ============
951-- transaction_open?(nil)
952 -> 0.0000s
953-- view_exists?(:postgres_partitions)
954 -> 0.0006s
955-- indexes(:project_registry)
956 -> 0.0068s
957-- remove_index(:project_registry, nil, {:algorithm=>:concurrently, :name=>"idx_project_registry_failed_repositories_partial"})
958 -> 0.0011s
959== 20180806011909 AddFailedSynchronizationsPartialIndex: reverted (0.0119s) ===
960== 20180803160048 AddSyncedRepositoriesPartialIndex: reverting ================
961-- transaction_open?(nil)
962 -> 0.0000s
963-- view_exists?(:postgres_partitions)
964 -> 0.0005s
965-- indexes(:project_registry)
966 -> 0.0067s
967-- remove_index(:project_registry, nil, {:algorithm=>:concurrently, :name=>"idx_project_registry_synced_repositories_partial"})
968 -> 0.0011s
969== 20180803160048 AddSyncedRepositoriesPartialIndex: reverted (0.0115s) =======
970== 20180802215313 AddRetryVerificationFieldsToProjectRegistry: reverting ======
971-- remove_column(:project_registry, :wiki_verification_retry_count, :integer)
972 -> 0.0008s
973-- remove_column(:project_registry, :repository_verification_retry_count, :integer)
974 -> 0.0007s
975== 20180802215313 AddRetryVerificationFieldsToProjectRegistry: reverted (0.0018s)
976== 20180727221937 AddMissingOnPrimaryToProjectRegistry: reverting =============
977-- remove_column(:project_registry, :wiki_missing_on_primary, :boolean)
978 -> 0.0007s
979-- remove_column(:project_registry, :repository_missing_on_primary, :boolean)
980 -> 0.0007s
981== 20180727221937 AddMissingOnPrimaryToProjectRegistry: reverted (0.0016s) ====
982== 20180613184349 AddResyncWasScheduledAtToProjectRegistry: reverting =========
983-- remove_column(:project_registry, :resync_wiki_was_scheduled_at, :datetime_with_timezone)
984 -> 0.0008s
985-- remove_column(:project_registry, :resync_repository_was_scheduled_at, :datetime_with_timezone)
986 -> 0.0006s
987== 20180613184349 AddResyncWasScheduledAtToProjectRegistry: reverted (0.0017s)
988== 20180510223634 SetResyncFlagForRetriedProjects: reverting ==================
989== 20180510223634 SetResyncFlagForRetriedProjects: reverted (0.0000s) =========
990== 20180427114641 AddRepositoryCheckToGeoProjectRegistry: reverting ===========
991-- remove_column(:project_registry, :last_repository_check_at, :datetime_with_timezone)
992 -> 0.0007s
993-- remove_column(:project_registry, :last_repository_check_failed, :boolean)
994 -> 0.0006s
995== 20180427114641 AddRepositoryCheckToGeoProjectRegistry: reverted (0.0017s) ==
996== 20180419192603 AddIndexesToChecksumMismatchFieldsOnProjectRegistry: reverting
997-- transaction_open?(nil)
998 -> 0.0000s
999-- view_exists?(:postgres_partitions)
1000 -> 0.0005s
1001-- indexes(:project_registry)
1002 -> 0.0062s
1003-- remove_index(:project_registry, nil, {:algorithm=>:concurrently, :name=>"idx_repository_checksum_mismatch"})
1004 -> 0.0010s
1005-- transaction_open?(nil)
1006 -> 0.0000s
1007-- view_exists?(:postgres_partitions)
1008 -> 0.0004s
1009-- indexes(:project_registry)
1010 -> 0.0061s
1011-- remove_index(:project_registry, nil, {:algorithm=>:concurrently, :name=>"idx_wiki_checksum_mismatch"})
1012 -> 0.0011s
1013== 20180419192603 AddIndexesToChecksumMismatchFieldsOnProjectRegistry: reverted (0.0216s)
1014== 20180419174834 AddChecksumMismatchFieldsToProjectRegistry: reverting =======
1015-- remove_column(:project_registry, :wiki_checksum_mismatch, :boolean, {:null=>false, :default=>false})
1016 -> 0.0008s
1017-- remove_column(:project_registry, :repository_checksum_mismatch, :boolean, {:null=>false, :default=>false})
1018 -> 0.0007s
1019== 20180419174834 AddChecksumMismatchFieldsToProjectRegistry: reverted (0.0020s)
1020== 20180412213305 AddIndexToArtifactIdOnJobArtifactRegistry: reverting ========
1021-- index_exists?(:job_artifact_registry, :artifact_id, {:name=>"index_job_artifact_registry_on_artifact_id"})
1022 -> 0.0023s
1023-- transaction_open?(nil)
1024 -> 0.0000s
1025-- view_exists?(:postgres_partitions)
1026 -> 0.0006s
1027-- index_exists?(:job_artifact_registry_finder, :artifact_id, {:algorithm=>:concurrently, :name=>"index_job_artifact_registry_finder_on_artifact_id"})
1028 -> 0.0009s
1029== 20180412213305 AddIndexToArtifactIdOnJobArtifactRegistry: reverted (0.0055s)
1030== 20180405074130 AddPartialIndexProjectRepositoryVerification: reverting =====
1031-- transaction_open?(nil)
1032 -> 0.0000s
1033-- view_exists?(:postgres_partitions)
1034 -> 0.0006s
1035-- indexes(:project_registry)
1036 -> 0.0054s
1037-- remove_index(:project_registry, nil, {:algorithm=>:concurrently, :name=>"idx_project_registry_on_repo_checksums_and_failure_partial"})
1038 -> 0.0012s
1039-- transaction_open?(nil)
1040 -> 0.0000s
1041-- view_exists?(:postgres_partitions)
1042 -> 0.0005s
1043-- indexes(:project_registry)
1044 -> 0.0050s
1045-- remove_index(:project_registry, nil, {:algorithm=>:concurrently, :name=>"idx_project_registry_on_wiki_checksums_and_failure_partial"})
1046 -> 0.0011s
1047== 20180405074130 AddPartialIndexProjectRepositoryVerification: reverted (0.0200s)
1048== 20180402170913 AddMissingOnPrimaryToJobArtifactRegistry: reverting =========
1049-- column_exists?(:job_artifact_registry, :missing_on_primary)
1050 -> 0.0013s
1051-- remove_column(:job_artifact_registry, :missing_on_primary)
1052 -> 0.0008s
1053== 20180402170913 AddMissingOnPrimaryToJobArtifactRegistry: reverted (0.0022s)
1054== 20180331055706 DeleteJobArtifactsFromFileRegistry: reverting ===============
1055== 20180331055706 DeleteJobArtifactsFromFileRegistry: reverted (0.0000s) ======
1056== 20180327071612 AddPartialIndexToProjectRegistyChecksumShaColumns: reverting
1057-- transaction_open?(nil)
1058 -> 0.0000s
1059-- view_exists?(:postgres_partitions)
1060 -> 0.0006s
1061-- indexes(:project_registry)
1062 -> 0.0048s
1063-- remove_index(:project_registry, nil, {:algorithm=>:concurrently, :name=>"idx_project_registry_on_repository_checksum_sha_partial"})
1064 -> 0.0011s
1065-- transaction_open?(nil)
1066 -> 0.0000s
1067-- view_exists?(:postgres_partitions)
1068 -> 0.0005s
1069-- indexes(:project_registry)
1070 -> 0.0044s
1071-- remove_index(:project_registry, nil, {:algorithm=>:concurrently, :name=>"idx_project_registry_on_wiki_checksum_sha_partial"})
1072 -> 0.0010s
1073== 20180327071612 AddPartialIndexToProjectRegistyChecksumShaColumns: reverted (0.0185s)
1074== 20180326171626 RemoveOldRepositoryVerificationChecksumFromGeoProjectRegistry: reverting
1075-- add_column(:project_registry, :repository_verification_checksum, :string)
1076 -> 0.0009s
1077-- add_column(:project_registry, :wiki_verification_checksum, :string)
1078 -> 0.0007s
1079== 20180326171626 RemoveOldRepositoryVerificationChecksumFromGeoProjectRegistry: reverted (0.0017s)
1080== 20180323182105 AddMissingOnPrimaryToFileRegistry: reverting ================
1081-- remove_column(:file_registry, :missing_on_primary)
1082 -> 0.0007s
1083== 20180323182105 AddMissingOnPrimaryToFileRegistry: reverted (0.0008s) =======
1084== 20180322062741 MigrateCiJobArtifactsToSeparateRegistry: reverting ==========
1085== 20180322062741 MigrateCiJobArtifactsToSeparateRegistry: reverted (0.0130s) =
1086== 20180321144947 ChangeRepositoryVerificationChecksumToSha: reverting ========
1087-- remove_column(:project_registry, :repository_verification_checksum_sha)
1088 -> 0.0008s
1089-- remove_column(:project_registry, :wiki_verification_checksum_sha)
1090 -> 0.0007s
1091== 20180321144947 ChangeRepositoryVerificationChecksumToSha: reverted (0.0017s)
1092== 20180320013929 RemoveLastVerificationAtColumnsFromGeoProjectRegistry: reverting
1093-- add_column(:project_registry, :last_repository_verification_at, :datetime_with_timezone)
1094 -> 0.0008s
1095-- add_column(:project_registry, :last_wiki_verification_at, :datetime_with_timezone)
1096 -> 0.0008s
1097== 20180320013929 RemoveLastVerificationAtColumnsFromGeoProjectRegistry: reverted (0.0018s)
1098== 20180320011914 RemoveLastVerificationFailedColumnsFromGeoProjectRegistry: reverting
1099-- add_column(:project_registry, :last_repository_verification_failed, :boolean, {:default=>false, :null=>false})
1100 -> 0.0012s
1101-- add_column(:project_registry, :last_wiki_verification_failed, :boolean, {:default=>false, :null=>false})
1102 -> 0.0012s
1103== 20180320011914 RemoveLastVerificationFailedColumnsFromGeoProjectRegistry: reverted (0.0026s)
1104== 20180315222132 AddPartialIndexToProjectRegistyChecksumColumns: reverting ===
1105-- index_exists?(:project_registry, :repository_verification_checksum, {:name=>"idx_project_registry_on_repository_checksum_partial"})
1106 -> 0.0044s
1107-- index_exists?(:project_registry, :wiki_verification_checksum, {:name=>"idx_project_registry_on_wiki_checksum_partial"})
1108 -> 0.0042s
1109== 20180315222132 AddPartialIndexToProjectRegistyChecksumColumns: reverted (0.0089s)
1110== 20180314175612 AddPartialIndexToProjectRegistyVerificationFailureColumns: reverting
1111-- index_exists?(:project_registry, :project_id, {:name=>"idx_project_registry_on_repository_failure_partial"})
1112 -> 0.0043s
1113-- transaction_open?(nil)
1114 -> 0.0000s
1115-- view_exists?(:postgres_partitions)
1116 -> 0.0006s
1117-- indexes(:project_registry)
1118 -> 0.0041s
1119-- remove_index(:project_registry, nil, {:algorithm=>:concurrently, :name=>"idx_project_registry_on_repository_failure_partial"})
1120 -> 0.0011s
1121-- index_exists?(:project_registry, :project_id, {:name=>"idx_project_registry_on_wiki_failure_partial"})
1122 -> 0.0038s
1123-- transaction_open?(nil)
1124 -> 0.0000s
1125-- view_exists?(:postgres_partitions)
1126 -> 0.0005s
1127-- indexes(:project_registry)
1128 -> 0.0037s
1129-- remove_index(:project_registry, nil, {:algorithm=>:concurrently, :name=>"idx_project_registry_on_wiki_failure_partial"})
1130 -> 0.0010s
1131== 20180314175612 AddPartialIndexToProjectRegistyVerificationFailureColumns: reverted (0.0253s)
1132== 20180201154345 AddRepositoryVerificationToProjectRegistry: reverting =======
1133-- remove_column(:project_registry, :last_wiki_verification_failure, :string)
1134 -> 0.0008s
1135-- remove_column(:project_registry, :last_wiki_verification_failed, :boolean, {:null=>false, :default=>false})
1136 -> 0.0007s
1137-- remove_column(:project_registry, :last_wiki_verification_at, :datetime_with_timezone)
1138 -> 0.0006s
1139-- remove_column(:project_registry, :wiki_verification_checksum, :string)
1140 -> 0.0006s
1141-- remove_column(:project_registry, :last_repository_verification_failure, :string)
1142 -> 0.0006s
1143-- remove_column(:project_registry, :last_repository_verification_failed, :boolean, {:null=>false, :default=>false})
1144 -> 0.0007s
1145-- remove_column(:project_registry, :last_repository_verification_at, :datetime_with_timezone)
1146 -> 0.0006s
1147-- remove_column(:project_registry, :repository_verification_checksum, :string)
1148 -> 0.0006s
1149== 20180201154345 AddRepositoryVerificationToProjectRegistry: reverted (0.0060s)
1150== 20171115143841 AddLastSyncFailureToProjectRegistry: reverting ==============
1151-- remove_column(:project_registry, :last_wiki_sync_failure, :string)
1152 -> 0.0007s
1153-- remove_column(:project_registry, :last_repository_sync_failure, :string)
1154 -> 0.0006s
1155== 20171115143841 AddLastSyncFailureToProjectRegistry: reverted (0.0015s) =====
1156== 20171101105200 AddRetryCountFieldsToRegistries: reverting ==================
1157-- remove_column(:file_registry, :retry_count, :integer)
1158 -> 0.0006s
1159-- remove_column(:file_registry, :retry_at, :datetime)
1160 -> 0.0010s
1161-- remove_column(:project_registry, :repository_retry_count, :integer)
1162 -> 0.0006s
1163-- remove_column(:project_registry, :repository_retry_at, :datetime)
1164 -> 0.0007s
1165-- remove_column(:project_registry, :force_to_redownload_repository, :boolean)
1166 -> 0.0006s
1167-- remove_column(:project_registry, :wiki_retry_count, :integer)
1168 -> 0.0006s
1169-- remove_column(:project_registry, :wiki_retry_at, :datetime)
1170 -> 0.0007s
1171-- remove_column(:project_registry, :force_to_redownload_wiki, :boolean)
1172 -> 0.0006s
1173== 20171101105200 AddRetryCountFieldsToRegistries: reverted (0.0057s) =========
1174== 20171009162209 AddFileRegistrySuccessIndex: reverting ======================
1175-- transaction_open?(nil)
1176 -> 0.0000s
1177-- view_exists?(:postgres_partitions)
1178 -> 0.0006s
1179-- index_exists?(:file_registry, :success, {:algorithm=>:concurrently, :name=>"index_file_registry_on_success"})
1180 -> 0.0009s
1181== 20171009162209 AddFileRegistrySuccessIndex: reverted (0.0027s) =============
1182== 20171009162208 AddFileRegistrySuccess: reverting ===========================
1183-- remove_column(:file_registry, :success)
1184 -> 0.0006s
1185== 20171009162208 AddFileRegistrySuccess: reverted (0.0031s) ==================
1186== 20171005045404 RemoveFileUploadsFromRegistry: reverting ====================
1187== 20171005045404 RemoveFileUploadsFromRegistry: reverted (0.0000s) ===========
1188== 20170906182752 AddUniqueIndexToProjectIdOnProjectRegistry: reverting =======
1189-- index_exists?(:project_registry, :project_id, {:name=>"index_project_registry_on_project_id"})
1190 -> 0.0030s
1191-- transaction_open?(nil)
1192 -> 0.0000s
1193-- view_exists?(:postgres_partitions)
1194 -> 0.0005s
1195-- index_exists?(:project_registry, :project_id, {:algorithm=>:concurrently, :name=>"index_project_registry_on_project_id"})
1196 -> 0.0286s
1197-- remove_index(:project_registry, nil, {:algorithm=>:concurrently, :column=>:project_id, :name=>"index_project_registry_on_project_id"})
1198 -> 0.0038s
1199-- transaction_open?(nil)
1200 -> 0.0000s
1201-- view_exists?(:postgres_partitions)
1202 -> 0.0005s
1203-- index_exists?(:project_registry, :project_id, {:algorithm=>:concurrently, :name=>"index_project_registry_on_project_id"})
1204 -> 0.0024s
1205-- add_index(:project_registry, :project_id, {:algorithm=>:concurrently})
1206 -> 0.0014s
1207== 20170906182752 AddUniqueIndexToProjectIdOnProjectRegistry: reverted (0.0459s)
1208== 20170906174622 RemoveDuplicatesFromProjectRegistry: reverting ==============
1209== 20170906174622 RemoveDuplicatesFromProjectRegistry: reverted (0.0000s) =====
1210geo: == [advisory_lock_connection] object_id: 113980, pg_backend_pid: 139
1211$ bundle exec rake db:migrate:geo
1212geo: == [advisory_lock_connection] object_id: 113600, pg_backend_pid: 158
1213== 20170906174622 RemoveDuplicatesFromProjectRegistry: migrating ==============
1214-- execute(" WITH good_rows AS MATERIALIZED (\n SELECT project_id, MAX(id) as max_id\n FROM project_registry\n GROUP BY project_id\n HAVING COUNT(*) > 1\n )\n DELETE FROM project_registry duplicated_rows\n USING good_rows\n WHERE good_rows.project_id = duplicated_rows.project_id\n AND good_rows.max_id <> duplicated_rows.id;\n")
1215 -> 0.0017s
1216== 20170906174622 RemoveDuplicatesFromProjectRegistry: migrated (0.0019s) =====
1217== 20170906182752 AddUniqueIndexToProjectIdOnProjectRegistry: migrating =======
1218-- index_exists?(:project_registry, :project_id, {:name=>"index_project_registry_on_project_id"})
1219 -> 0.0049s
1220-- transaction_open?(nil)
1221 -> 0.0000s
1222-- view_exists?(:postgres_partitions)
1223 -> 0.0006s
1224-- index_exists?(:project_registry, :project_id, {:algorithm=>:concurrently, :name=>"index_project_registry_on_project_id"})
1225 -> 0.0030s
1226-- remove_index(:project_registry, nil, {:algorithm=>:concurrently, :column=>:project_id, :name=>"index_project_registry_on_project_id"})
1227 -> 0.0044s
1228-- transaction_open?(nil)
1229 -> 0.0000s
1230-- view_exists?(:postgres_partitions)
1231 -> 0.0005s
1232-- index_exists?(:project_registry, :project_id, {:unique=>true, :algorithm=>:concurrently, :name=>"index_project_registry_on_project_id"})
1233 -> 0.0027s
1234-- add_index(:project_registry, :project_id, {:unique=>true, :algorithm=>:concurrently})
1235 -> 0.0018s
1236== 20170906182752 AddUniqueIndexToProjectIdOnProjectRegistry: migrated (0.0244s)
1237== 20171005045404 RemoveFileUploadsFromRegistry: migrating ====================
1238== 20171005045404 RemoveFileUploadsFromRegistry: migrated (0.0111s) ===========
1239== 20171009162208 AddFileRegistrySuccess: migrating ===========================
1240-- add_column(:file_registry, :success, :boolean, {:default=>true, :allow_null=>false})
1241 -> 0.0015s
1242-- change_column(:file_registry, :success, :boolean)
1243 -> 0.0010s
1244== 20171009162208 AddFileRegistrySuccess: migrated (0.0060s) ==================
1245== 20171009162209 AddFileRegistrySuccessIndex: migrating ======================
1246-- transaction_open?(nil)
1247 -> 0.0000s
1248-- view_exists?(:postgres_partitions)
1249 -> 0.0008s
1250-- index_exists?(:file_registry, :success, {:algorithm=>:concurrently, :name=>"index_file_registry_on_success"})
1251 -> 0.0011s
1252-- add_index(:file_registry, :success, {:algorithm=>:concurrently})
1253 -> 0.0013s
1254== 20171009162209 AddFileRegistrySuccessIndex: migrated (0.0052s) =============
1255== 20171101105200 AddRetryCountFieldsToRegistries: migrating ==================
1256-- add_column(:file_registry, :retry_count, :integer)
1257 -> 0.0008s
1258-- add_column(:file_registry, :retry_at, :timestamp, {:precision=>nil})
1259 -> 0.0007s
1260-- add_column(:project_registry, :repository_retry_count, :integer)
1261 -> 0.0006s
1262-- add_column(:project_registry, :repository_retry_at, :timestamp, {:precision=>nil})
1263 -> 0.0006s
1264-- add_column(:project_registry, :force_to_redownload_repository, :boolean)
1265 -> 0.0008s
1266-- add_column(:project_registry, :wiki_retry_count, :integer)
1267 -> 0.0006s
1268-- add_column(:project_registry, :wiki_retry_at, :timestamp, {:precision=>nil})
1269 -> 0.0007s
1270-- add_column(:project_registry, :force_to_redownload_wiki, :boolean)
1271 -> 0.0007s
1272-- transaction_open?(nil)
1273 -> 0.0000s
1274-- view_exists?(:postgres_partitions)
1275 -> 0.0007s
1276-- index_exists?(:file_registry, :retry_at, {:algorithm=>:concurrently, :name=>"index_file_registry_on_retry_at"})
1277 -> 0.0017s
1278-- add_index(:file_registry, :retry_at, {:algorithm=>:concurrently})
1279 -> 0.0012s
1280-- transaction_open?(nil)
1281 -> 0.0000s
1282-- view_exists?(:postgres_partitions)
1283 -> 0.0004s
1284-- index_exists?(:project_registry, :repository_retry_at, {:algorithm=>:concurrently, :name=>"index_project_registry_on_repository_retry_at"})
1285 -> 0.0028s
1286-- add_index(:project_registry, :repository_retry_at, {:algorithm=>:concurrently})
1287 -> 0.0011s
1288-- transaction_open?(nil)
1289 -> 0.0000s
1290-- view_exists?(:postgres_partitions)
1291 -> 0.0005s
1292-- index_exists?(:project_registry, :wiki_retry_at, {:algorithm=>:concurrently, :name=>"index_project_registry_on_wiki_retry_at"})
1293 -> 0.0030s
1294-- add_index(:project_registry, :wiki_retry_at, {:algorithm=>:concurrently})
1295 -> 0.0011s
1296== 20171101105200 AddRetryCountFieldsToRegistries: migrated (0.0244s) =========
1297== 20171115143841 AddLastSyncFailureToProjectRegistry: migrating ==============
1298-- add_column(:project_registry, :last_repository_sync_failure, :string)
1299 -> 0.0007s
1300-- add_column(:project_registry, :last_wiki_sync_failure, :string)
1301 -> 0.0006s
1302== 20171115143841 AddLastSyncFailureToProjectRegistry: migrated (0.0014s) =====
1303== 20180201154345 AddRepositoryVerificationToProjectRegistry: migrating =======
1304-- add_column(:project_registry, :repository_verification_checksum, :string)
1305 -> 0.0007s
1306-- add_column(:project_registry, :last_repository_verification_at, :datetime_with_timezone)
1307 -> 0.0006s
1308-- add_column(:project_registry, :last_repository_verification_failed, :boolean, {:null=>false, :default=>false})
1309 -> 0.0009s
1310-- add_column(:project_registry, :last_repository_verification_failure, :string)
1311 -> 0.0006s
1312-- add_column(:project_registry, :wiki_verification_checksum, :string)
1313 -> 0.0006s
1314-- add_column(:project_registry, :last_wiki_verification_at, :datetime_with_timezone)
1315 -> 0.0006s
1316-- add_column(:project_registry, :last_wiki_verification_failed, :boolean, {:null=>false, :default=>false})
1317 -> 0.0009s
1318-- add_column(:project_registry, :last_wiki_verification_failure, :string)
1319 -> 0.0007s
1320== 20180201154345 AddRepositoryVerificationToProjectRegistry: migrated (0.0060s)
1321== 20180314175612 AddPartialIndexToProjectRegistyVerificationFailureColumns: migrating
1322-- index_exists?(:project_registry, :project_id, {:name=>"idx_project_registry_on_repository_failure_partial"})
1323 -> 0.0040s
1324-- transaction_open?(nil)
1325 -> 0.0000s
1326-- view_exists?(:postgres_partitions)
1327 -> 0.0008s
1328-- index_exists?(:project_registry, :project_id, {:name=>"idx_project_registry_on_repository_failure_partial", :where=>"last_repository_verification_failure IS NOT NULL", :algorithm=>:concurrently})
1329 -> 0.0036s
1330-- add_index(:project_registry, :project_id, {:name=>"idx_project_registry_on_repository_failure_partial", :where=>"last_repository_verification_failure IS NOT NULL", :algorithm=>:concurrently})
1331 -> 0.0013s
1332-- index_exists?(:project_registry, :project_id, {:name=>"idx_project_registry_on_wiki_failure_partial"})
1333 -> 0.0037s
1334-- transaction_open?(nil)
1335 -> 0.0000s
1336-- view_exists?(:postgres_partitions)
1337 -> 0.0006s
1338-- index_exists?(:project_registry, :project_id, {:name=>"idx_project_registry_on_wiki_failure_partial", :where=>"last_wiki_verification_failure IS NOT NULL", :algorithm=>:concurrently})
1339 -> 0.0042s
1340-- add_index(:project_registry, :project_id, {:name=>"idx_project_registry_on_wiki_failure_partial", :where=>"last_wiki_verification_failure IS NOT NULL", :algorithm=>:concurrently})
1341 -> 0.0014s
1342== 20180314175612 AddPartialIndexToProjectRegistyVerificationFailureColumns: migrated (0.0246s)
1343== 20180315222132 AddPartialIndexToProjectRegistyChecksumColumns: migrating ===
1344-- index_exists?(:project_registry, :repository_verification_checksum, {:name=>"idx_project_registry_on_repository_checksum_partial"})
1345 -> 0.0041s
1346-- transaction_open?(nil)
1347 -> 0.0000s
1348-- view_exists?(:postgres_partitions)
1349 -> 0.0005s
1350-- index_exists?(:project_registry, :repository_verification_checksum, {:name=>"idx_project_registry_on_repository_checksum_partial", :where=>"repository_verification_checksum IS NULL", :algorithm=>:concurrently})
1351 -> 0.0039s
1352-- add_index(:project_registry, :repository_verification_checksum, {:name=>"idx_project_registry_on_repository_checksum_partial", :where=>"repository_verification_checksum IS NULL", :algorithm=>:concurrently})
1353 -> 0.0012s
1354-- index_exists?(:project_registry, :wiki_verification_checksum, {:name=>"idx_project_registry_on_wiki_checksum_partial"})
1355 -> 0.0044s
1356-- transaction_open?(nil)
1357 -> 0.0000s
1358-- view_exists?(:postgres_partitions)
1359 -> 0.0006s
1360-- index_exists?(:project_registry, :wiki_verification_checksum, {:name=>"idx_project_registry_on_wiki_checksum_partial", :where=>"wiki_verification_checksum IS NULL", :algorithm=>:concurrently})
1361 -> 0.0043s
1362-- add_index(:project_registry, :wiki_verification_checksum, {:name=>"idx_project_registry_on_wiki_checksum_partial", :where=>"wiki_verification_checksum IS NULL", :algorithm=>:concurrently})
1363 -> 0.0013s
1364== 20180315222132 AddPartialIndexToProjectRegistyChecksumColumns: migrated (0.0252s)
1365== 20180320011914 RemoveLastVerificationFailedColumnsFromGeoProjectRegistry: migrating
1366-- remove_column(:project_registry, :last_repository_verification_failed)
1367 -> 0.0008s
1368-- remove_column(:project_registry, :last_wiki_verification_failed)
1369 -> 0.0007s
1370== 20180320011914 RemoveLastVerificationFailedColumnsFromGeoProjectRegistry: migrated (0.0016s)
1371== 20180320013929 RemoveLastVerificationAtColumnsFromGeoProjectRegistry: migrating
1372-- remove_column(:project_registry, :last_repository_verification_at)
1373 -> 0.0006s
1374-- remove_column(:project_registry, :last_wiki_verification_at)
1375 -> 0.0006s
1376== 20180320013929 RemoveLastVerificationAtColumnsFromGeoProjectRegistry: migrated (0.0013s)
1377== 20180321144947 ChangeRepositoryVerificationChecksumToSha: migrating ========
1378-- add_column(:project_registry, :repository_verification_checksum_sha, :binary)
1379 -> 0.0008s
1380-- add_column(:project_registry, :wiki_verification_checksum_sha, :binary)
1381 -> 0.0007s
1382== 20180321144947 ChangeRepositoryVerificationChecksumToSha: migrated (0.0017s)
1383== 20180322062741 MigrateCiJobArtifactsToSeparateRegistry: migrating ==========
1384== 20180322062741 MigrateCiJobArtifactsToSeparateRegistry: migrated (0.0099s) =
1385== 20180323182105 AddMissingOnPrimaryToFileRegistry: migrating ================
1386-- add_column(:file_registry, :missing_on_primary, :boolean, {:default=>false, :allow_null=>false})
1387 -> 0.0013s
1388== 20180323182105 AddMissingOnPrimaryToFileRegistry: migrated (0.0015s) =======
1389== 20180326171626 RemoveOldRepositoryVerificationChecksumFromGeoProjectRegistry: migrating
1390-- remove_column(:project_registry, :repository_verification_checksum)
1391 -> 0.0009s
1392-- remove_column(:project_registry, :wiki_verification_checksum)
1393 -> 0.0007s
1394== 20180326171626 RemoveOldRepositoryVerificationChecksumFromGeoProjectRegistry: migrated (0.0017s)
1395== 20180327071612 AddPartialIndexToProjectRegistyChecksumShaColumns: migrating
1396-- transaction_open?(nil)
1397 -> 0.0000s
1398-- view_exists?(:postgres_partitions)
1399 -> 0.0006s
1400-- index_exists?(:project_registry, :repository_verification_checksum_sha, {:name=>"idx_project_registry_on_repository_checksum_sha_partial", :where=>"repository_verification_checksum_sha IS NULL", :algorithm=>:concurrently})
1401 -> 0.0046s
1402-- add_index(:project_registry, :repository_verification_checksum_sha, {:name=>"idx_project_registry_on_repository_checksum_sha_partial", :where=>"repository_verification_checksum_sha IS NULL", :algorithm=>:concurrently})
1403 -> 0.0014s
1404-- transaction_open?(nil)
1405 -> 0.0000s
1406-- view_exists?(:postgres_partitions)
1407 -> 0.0005s
1408-- index_exists?(:project_registry, :wiki_verification_checksum_sha, {:name=>"idx_project_registry_on_wiki_checksum_sha_partial", :where=>"wiki_verification_checksum_sha IS NULL", :algorithm=>:concurrently})
1409 -> 0.0044s
1410-- add_index(:project_registry, :wiki_verification_checksum_sha, {:name=>"idx_project_registry_on_wiki_checksum_sha_partial", :where=>"wiki_verification_checksum_sha IS NULL", :algorithm=>:concurrently})
1411 -> 0.0012s
1412== 20180327071612 AddPartialIndexToProjectRegistyChecksumShaColumns: migrated (0.0177s)
1413== 20180331055706 DeleteJobArtifactsFromFileRegistry: migrating ===============
1414-- execute("DELETE FROM file_registry WHERE file_type = 'job_artifact'")
1415 -> 0.0007s
1416-- execute("DROP TRIGGER IF EXISTS replicate_job_artifact_registry ON file_registry")
1417 -> 0.0006s
1418-- execute("DROP FUNCTION IF EXISTS replicate_job_artifact_registry()")
1419 -> 0.0005s
1420== 20180331055706 DeleteJobArtifactsFromFileRegistry: migrated (0.0020s) ======
1421== 20180402170913 AddMissingOnPrimaryToJobArtifactRegistry: migrating =========
1422-- add_column(:job_artifact_registry, :missing_on_primary, :boolean, {:default=>false, :allow_null=>false})
1423 -> 0.0014s
1424== 20180402170913 AddMissingOnPrimaryToJobArtifactRegistry: migrated (0.0016s)
1425== 20180405074130 AddPartialIndexProjectRepositoryVerification: migrating =====
1426-- transaction_open?(nil)
1427 -> 0.0000s
1428-- view_exists?(:postgres_partitions)
1429 -> 0.0006s
1430-- index_exists?(:project_registry, [:project_id], {:name=>"idx_project_registry_on_repo_checksums_and_failure_partial", :where=>"repository_verification_checksum_sha IS NULL AND last_repository_verification_failure IS NULL", :algorithm=>:concurrently})
1431 -> 0.0051s
1432-- add_index(:project_registry, [:project_id], {:name=>"idx_project_registry_on_repo_checksums_and_failure_partial", :where=>"repository_verification_checksum_sha IS NULL AND last_repository_verification_failure IS NULL", :algorithm=>:concurrently})
1433 -> 0.0013s
1434-- transaction_open?(nil)
1435 -> 0.0000s
1436-- view_exists?(:postgres_partitions)
1437 -> 0.0005s
1438-- index_exists?(:project_registry, [:project_id], {:name=>"idx_project_registry_on_wiki_checksums_and_failure_partial", :where=>"wiki_verification_checksum_sha IS NULL AND last_wiki_verification_failure IS NULL", :algorithm=>:concurrently})
1439 -> 0.0059s
1440-- add_index(:project_registry, [:project_id], {:name=>"idx_project_registry_on_wiki_checksums_and_failure_partial", :where=>"wiki_verification_checksum_sha IS NULL AND last_wiki_verification_failure IS NULL", :algorithm=>:concurrently})
1441 -> 0.0014s
1442== 20180405074130 AddPartialIndexProjectRepositoryVerification: migrated (0.0198s)
1443== 20180412213305 AddIndexToArtifactIdOnJobArtifactRegistry: migrating ========
1444-- transaction_open?(nil)
1445 -> 0.0000s
1446-- view_exists?(:postgres_partitions)
1447 -> 0.0006s
1448-- index_exists?(:job_artifact_registry, :artifact_id, {:algorithm=>:concurrently, :name=>"index_job_artifact_registry_on_artifact_id"})
1449 -> 0.0020s
1450-- add_index(:job_artifact_registry, :artifact_id, {:algorithm=>:concurrently})
1451 -> 0.0012s
1452== 20180412213305 AddIndexToArtifactIdOnJobArtifactRegistry: migrated (0.0060s)
1453== 20180419174834 AddChecksumMismatchFieldsToProjectRegistry: migrating =======
1454-- add_column(:project_registry, :repository_checksum_mismatch, :boolean, {:null=>false, :default=>false})
1455 -> 0.0012s
1456-- add_column(:project_registry, :wiki_checksum_mismatch, :boolean, {:null=>false, :default=>false})
1457 -> 0.0010s
1458== 20180419174834 AddChecksumMismatchFieldsToProjectRegistry: migrated (0.0024s)
1459== 20180419192603 AddIndexesToChecksumMismatchFieldsOnProjectRegistry: migrating
1460-- transaction_open?(nil)
1461 -> 0.0000s
1462-- view_exists?(:postgres_partitions)
1463 -> 0.0005s
1464-- index_exists?(:project_registry, :project_id, {:name=>"idx_repository_checksum_mismatch", :where=>"repository_checksum_mismatch = true", :algorithm=>:concurrently})
1465 -> 0.0061s
1466-- add_index(:project_registry, :project_id, {:name=>"idx_repository_checksum_mismatch", :where=>"repository_checksum_mismatch = true", :algorithm=>:concurrently})
1467 -> 0.0013s
1468-- transaction_open?(nil)
1469 -> 0.0000s
1470-- view_exists?(:postgres_partitions)
1471 -> 0.0005s
1472-- index_exists?(:project_registry, :project_id, {:name=>"idx_wiki_checksum_mismatch", :where=>"wiki_checksum_mismatch = true", :algorithm=>:concurrently})
1473 -> 0.0059s
1474-- add_index(:project_registry, :project_id, {:name=>"idx_wiki_checksum_mismatch", :where=>"wiki_checksum_mismatch = true", :algorithm=>:concurrently})
1475 -> 0.0012s
1476== 20180419192603 AddIndexesToChecksumMismatchFieldsOnProjectRegistry: migrated (0.0200s)
1477== 20180427114641 AddRepositoryCheckToGeoProjectRegistry: migrating ===========
1478-- add_column(:project_registry, :last_repository_check_failed, :boolean)
1479 -> 0.0010s
1480-- add_column(:project_registry, :last_repository_check_at, :datetime_with_timezone)
1481 -> 0.0006s
1482== 20180427114641 AddRepositoryCheckToGeoProjectRegistry: migrated (0.0017s) ==
1483== 20180510223634 SetResyncFlagForRetriedProjects: migrating ==================
1484-- execute(" UPDATE project_registry SET resync_repository = 't' WHERE repository_retry_count > 0 AND resync_repository = 'f';\n UPDATE project_registry SET resync_wiki = 't' WHERE wiki_retry_count > 0 AND resync_wiki = 'f';\n")
1485 -> 0.0013s
1486== 20180510223634 SetResyncFlagForRetriedProjects: migrated (0.0013s) =========
1487== 20180613184349 AddResyncWasScheduledAtToProjectRegistry: migrating =========
1488-- add_column(:project_registry, :resync_repository_was_scheduled_at, :datetime_with_timezone)
1489 -> 0.0009s
1490-- add_column(:project_registry, :resync_wiki_was_scheduled_at, :datetime_with_timezone)
1491 -> 0.0009s
1492== 20180613184349 AddResyncWasScheduledAtToProjectRegistry: migrated (0.0019s)
1493== 20180727221937 AddMissingOnPrimaryToProjectRegistry: migrating =============
1494-- add_column(:project_registry, :repository_missing_on_primary, :boolean)
1495 -> 0.0009s
1496-- add_column(:project_registry, :wiki_missing_on_primary, :boolean)
1497 -> 0.0009s
1498== 20180727221937 AddMissingOnPrimaryToProjectRegistry: migrated (0.0019s) ====
1499== 20180802215313 AddRetryVerificationFieldsToProjectRegistry: migrating ======
1500-- add_column(:project_registry, :repository_verification_retry_count, :integer)
1501 -> 0.0008s
1502-- add_column(:project_registry, :wiki_verification_retry_count, :integer)
1503 -> 0.0009s
1504== 20180802215313 AddRetryVerificationFieldsToProjectRegistry: migrated (0.0018s)
1505== 20180803160048 AddSyncedRepositoriesPartialIndex: migrating ================
1506-- transaction_open?(nil)
1507 -> 0.0000s
1508-- view_exists?(:postgres_partitions)
1509 -> 0.0011s
1510-- index_exists?(:project_registry, :last_repository_successful_sync_at, {:where=>"resync_repository = 'f' AND repository_retry_count IS NULL AND repository_verification_checksum_sha IS NOT NULL", :name=>"idx_project_registry_synced_repositories_partial", :algorithm=>:concurrently})
1511 -> 0.0066s
1512-- add_index(:project_registry, :last_repository_successful_sync_at, {:where=>"resync_repository = 'f' AND repository_retry_count IS NULL AND repository_verification_checksum_sha IS NOT NULL", :name=>"idx_project_registry_synced_repositories_partial", :algorithm=>:concurrently})
1513 -> 0.0014s
1514== 20180803160048 AddSyncedRepositoriesPartialIndex: migrated (0.0119s) =======
1515== 20180806011909 AddFailedSynchronizationsPartialIndex: migrating ============
1516-- transaction_open?(nil)
1517 -> 0.0000s
1518-- view_exists?(:postgres_partitions)
1519 -> 0.0006s
1520-- index_exists?(:project_registry, :repository_retry_count, {:where=>"repository_retry_count > 0 OR last_repository_verification_failure IS NOT NULL OR repository_checksum_mismatch", :name=>"idx_project_registry_failed_repositories_partial", :algorithm=>:concurrently})
1521 -> 0.0079s
1522-- add_index(:project_registry, :repository_retry_count, {:where=>"repository_retry_count > 0 OR last_repository_verification_failure IS NOT NULL OR repository_checksum_mismatch", :name=>"idx_project_registry_failed_repositories_partial", :algorithm=>:concurrently})
1523 -> 0.0016s
1524== 20180806011909 AddFailedSynchronizationsPartialIndex: migrated (0.0125s) ===
1525== 20180806020615 AddPendingSynchronizationsPartialIndex: migrating ===========
1526-- transaction_open?(nil)
1527 -> 0.0000s
1528-- view_exists?(:postgres_partitions)
1529 -> 0.0005s
1530-- index_exists?(:project_registry, :repository_retry_count, {:where=>"repository_retry_count IS NULL AND last_repository_successful_sync_at IS NOT NULL AND (resync_repository = 't' OR repository_verification_checksum_sha IS NULL AND last_repository_verification_failure IS NULL)", :name=>"idx_project_registry_pending_repositories_partial", :algorithm=>:concurrently})
1531 -> 0.0072s
1532-- add_index(:project_registry, :repository_retry_count, {:where=>"repository_retry_count IS NULL AND last_repository_successful_sync_at IS NOT NULL AND (resync_repository = 't' OR repository_verification_checksum_sha IS NULL AND last_repository_verification_failure IS NULL)", :name=>"idx_project_registry_pending_repositories_partial", :algorithm=>:concurrently})
1533 -> 0.0014s
1534== 20180806020615 AddPendingSynchronizationsPartialIndex: migrated (0.0115s) ==
1535== 20181213184140 AddLastVerificationColumnsToProjectRegistry: migrating ======
1536-- add_column(:project_registry, :last_repository_verification_ran_at, :datetime_with_timezone)
1537 -> 0.0009s
1538-- add_column(:project_registry, :last_wiki_verification_ran_at, :datetime_with_timezone)
1539 -> 0.0007s
1540== 20181213184140 AddLastVerificationColumnsToProjectRegistry: migrated (0.0018s)
1541== 20190314201959 AddChecksumMismatchedColumndsToProjectRegistry: migrating ===
1542-- add_column(:project_registry, :repository_verification_checksum_mismatched, :binary)
1543 -> 0.0007s
1544-- add_column(:project_registry, :wiki_verification_checksum_mismatched, :binary)
1545 -> 0.0007s
1546== 20190314201959 AddChecksumMismatchedColumndsToProjectRegistry: migrated (0.0015s)
1547== 20190612211021 AddContainerRepositoryRegistry: migrating ===================
1548-- create_table(:container_repository_registry, {:id=>:serial, :force=>:cascade})
1549 -> 0.0055s
1550== 20190612211021 AddContainerRepositoryRegistry: migrated (0.0056s) ==========
1551== 20190802200655 AddCreatedAtToEventLogStates: migrating =====================
1552-- add_column(:event_log_states, :created_at, :timestamp, {:null=>true, :precision=>nil})
1553 -> 0.0010s
1554-- execute("UPDATE event_log_states SET created_at = (\n SELECT COALESCE(\n (SELECT project_registry.created_at\n FROM project_registry\n ORDER BY project_registry.id ASC\n LIMIT 1), NOW()\n )\n )")
1555 -> 0.0011s
1556-- change_column_null(:event_log_states, :created_at, false)
1557 -> 0.0006s
1558== 20190802200655 AddCreatedAtToEventLogStates: migrated (0.0029s) ============
1559== 20190923111102 AddDesignRegistry: migrating ================================
1560-- create_table(:design_registry, {:id=>:serial, :force=>:cascade})
1561 -> 0.0054s
1562== 20190923111102 AddDesignRegistry: migrated (0.0055s) =======================
1563== 20191007122326 AddUniqueConstraintOnDesignRegistryProjectId: migrating =====
1564-- remove_index(:design_registry, {:column=>:project_id, :name=>"index_design_registry_on_project_id"})
1565 -> 0.0029s
1566-- add_index(:design_registry, :project_id, {:name=>"index_design_registry_on_project_id", :unique=>true})
1567 -> 0.0010s
1568== 20191007122326 AddUniqueConstraintOnDesignRegistryProjectId: migrated (0.0041s)
1569== 20191010203257 CreateLfsObjectRegistry: migrating ==========================
1570-- create_table(:lfs_object_registry, {:force=>:cascade})
1571 -> 0.0060s
1572== 20191010203257 CreateLfsObjectRegistry: migrated (0.0061s) =================
1573== 20191010204941 MigrateLfsObjectsToSeparateRegistry: migrating ==============
1574-- execute("LOCK TABLE file_registry IN EXCLUSIVE MODE")
1575 -> 0.0005s
1576-- execute("INSERT INTO lfs_object_registry (created_at, retry_at, lfs_object_id, bytes, retry_count, missing_on_primary, success, sha256)\nSELECT created_at, retry_at, file_id, bytes, retry_count, missing_on_primary, success, sha256::bytea\nFROM file_registry WHERE file_type = 'lfs'\n")
1577 -> 0.0008s
1578-- execute("CREATE OR REPLACE FUNCTION replicate_lfs_object_registry()\nRETURNS trigger AS\n$BODY$\nBEGIN\n IF (TG_OP = 'UPDATE') THEN\n UPDATE lfs_object_registry\n SET (retry_at, bytes, retry_count, missing_on_primary, success, sha256) =\n (NEW.retry_at, NEW.bytes, NEW.retry_count, NEW.missing_on_primary, NEW.success, NEW.sha256::bytea)\n WHERE lfs_object_id = NEW.file_id;\n ELSEIF (TG_OP = 'INSERT') THEN\n INSERT INTO lfs_object_registry (created_at, retry_at, lfs_object_id, bytes, retry_count, missing_on_primary, success, sha256)\n VALUES (NEW.created_at, NEW.retry_at, NEW.file_id, NEW.bytes, NEW.retry_count, NEW.missing_on_primary, NEW.success, NEW.sha256::bytea);\nEND IF;\nRETURN NEW;\nEND;\n$BODY$\nLANGUAGE 'plpgsql'\nVOLATILE;\n")
1579 -> 0.0016s
1580-- execute("CREATE TRIGGER replicate_lfs_object_registry\nAFTER INSERT OR UPDATE ON file_registry\nFOR EACH ROW WHEN (NEW.file_type = 'lfs') EXECUTE PROCEDURE replicate_lfs_object_registry();\n")
1581 -> 0.0007s
1582== 20191010204941 MigrateLfsObjectsToSeparateRegistry: migrated (0.0041s) =====
1583== 20191025194337 DeleteLfsObjectsFromFileRegistry: migrating =================
1584-- execute("DELETE FROM file_registry WHERE file_type = 'lfs'")
1585 -> 0.0007s
1586-- execute("DROP TRIGGER IF EXISTS replicate_lfs_object_registry ON file_registry")
1587 -> 0.0006s
1588-- execute("DROP FUNCTION IF EXISTS replicate_lfs_object_registry()")
1589 -> 0.0005s
1590== 20191025194337 DeleteLfsObjectsFromFileRegistry: migrated (0.0021s) ========
1591== 20200121194300 CreatePackageFileRegistry: migrating ========================
1592-- create_table(:package_file_registry, {:id=>:serial, :force=>:cascade})
1593 -> 0.0050s
1594== 20200121194300 CreatePackageFileRegistry: migrated (0.0053s) ===============
1595== 20200407120740 AddVerificationFieldsToPackageFileOnSecondary: migrating ====
1596-- add_column(:package_file_registry, :verification_failure, :string, {:limit=>255})
1597 -> 0.0012s
1598-- add_column(:package_file_registry, :verification_checksum, :binary)
1599 -> 0.0007s
1600-- add_column(:package_file_registry, :checksum_mismatch, :boolean)
1601 -> 0.0006s
1602-- add_column(:package_file_registry, :verification_checksum_mismatched, :binary)
1603 -> 0.0006s
1604-- add_column(:package_file_registry, :verification_retry_count, :integer)
1605 -> 0.0008s
1606-- add_column(:package_file_registry, :verified_at, :datetime_with_timezone)
1607 -> 0.0006s
1608-- add_column(:package_file_registry, :verification_retry_at, :datetime_with_timezone)
1609 -> 0.0006s
1610== 20200407120740 AddVerificationFieldsToPackageFileOnSecondary: migrated (0.0057s)
1611== 20200707011052 AddVerifiedOnPrimaryColumnsToProjectRegistry: migrating =====
1612-- add_column(:project_registry, :primary_repository_checksummed, :boolean, {:default=>false, :null=>false})
1613 -> 0.0012s
1614-- add_column(:project_registry, :primary_wiki_checksummed, :boolean, {:default=>false, :null=>false})
1615 -> 0.0009s
1616== 20200707011052 AddVerifiedOnPrimaryColumnsToProjectRegistry: migrated (0.0023s)
1617== 20200707210300 CreateTerraformStateRegistry: migrating =====================
1618-- create_table(:terraform_state_registry, {:id=>:bigserial, :force=>:cascade})
1619 -> 0.0059s
1620-- transaction_open?(nil)
1621 -> 0.0000s
1622-- execute("ALTER TABLE terraform_state_registry\nADD CONSTRAINT check_70a3f43f16\nCHECK ( char_length(last_sync_failure) <= 255 )\nNOT VALID;\n")
1623 -> 0.0007s
1624-- execute("ALTER TABLE terraform_state_registry VALIDATE CONSTRAINT check_70a3f43f16;")
1625 -> 0.0006s
1626== 20200707210300 CreateTerraformStateRegistry: migrated (0.0137s) ============
1627== 20200710194046 CreateVulnerabilityExportRegistry: migrating ================
1628-- create_table(:vulnerability_export_registry, {:id=>:bigserial, :force=>:cascade})
1629 -> 0.0056s
1630-- transaction_open?(nil)
1631 -> 0.0000s
1632-- execute("ALTER TABLE vulnerability_export_registry\nADD CONSTRAINT check_6edacda197\nCHECK ( char_length(last_sync_failure) <= 255 )\nNOT VALID;\n")
1633 -> 0.0007s
1634-- execute("ALTER TABLE vulnerability_export_registry VALIDATE CONSTRAINT check_6edacda197;")
1635 -> 0.0006s
1636== 20200710194046 CreateVulnerabilityExportRegistry: migrated (0.0126s) =======
1637== 20200730133800 RemoveTableVulnerabilityExportRegistry: migrating ===========
1638-- table_exists?(:vulnerability_export_registry)
1639 -> 0.0006s
1640-- drop_table(:vulnerability_export_registry)
1641 -> 0.0013s
1642== 20200730133800 RemoveTableVulnerabilityExportRegistry: migrated (0.0022s) ==
1643== 20200811171011 CreateSnippetRepositoryRegistry: migrating ==================
1644-- create_table(:snippet_repository_registry, {:id=>:bigserial, :force=>:cascade})
1645 -> 0.0057s
1646-- transaction_open?(nil)
1647 -> 0.0000s
1648-- execute("ALTER TABLE snippet_repository_registry\nADD CONSTRAINT check_5409cb1003\nCHECK ( char_length(last_sync_failure) <= 255 )\nNOT VALID;\n")
1649 -> 0.0007s
1650-- execute("ALTER TABLE snippet_repository_registry VALIDATE CONSTRAINT check_5409cb1003;")
1651 -> 0.0008s
1652== 20200811171011 CreateSnippetRepositoryRegistry: migrated (0.0125s) =========
1653== 20200827120552 CreateMergeRequestDiffRegistry: migrating ===================
1654-- create_table(:merge_request_diff_registry)
1655 -> 0.0057s
1656-- transaction_open?(nil)
1657 -> 0.0000s
1658-- execute("ALTER TABLE merge_request_diff_registry\nADD CONSTRAINT check_803d4b5fb5\nCHECK ( char_length(last_sync_failure) <= 255 )\nNOT VALID;\n")
1659 -> 0.0007s
1660-- execute("ALTER TABLE merge_request_diff_registry VALIDATE CONSTRAINT check_803d4b5fb5;")
1661 -> 0.0007s
1662== 20200827120552 CreateMergeRequestDiffRegistry: migrated (0.0138s) ==========
1663== 20200915152620 CreateTerraformStateVersionRegistry: migrating ==============
1664-- create_table(:terraform_state_version_registry, {:id=>:bigserial, :force=>:cascade})
1665 -> 0.0059s
1666-- transaction_open?(nil)
1667 -> 0.0000s
1668-- execute("ALTER TABLE terraform_state_version_registry\nADD CONSTRAINT check_7827f2d2cf\nCHECK ( char_length(last_sync_failure) <= 255 )\nNOT VALID;\n")
1669 -> 0.0007s
1670-- execute("ALTER TABLE terraform_state_version_registry VALIDATE CONSTRAINT check_7827f2d2cf;")
1671 -> 0.0006s
1672== 20200915152620 CreateTerraformStateVersionRegistry: migrated (0.0138s) =====
1673== 20200924184638 RemoveNonVersionedTerraformStateRegistry: migrating =========
1674-- drop_table(:terraform_state_registry)
1675 -> 0.0024s
1676== 20200924184638 RemoveNonVersionedTerraformStateRegistry: migrated (0.0024s)
1677== 20201208025254 AddVerificationFieldsToPackageFileRegistry: migrating =======
1678-- add_column(:package_file_registry, :verification_state, :integer, {:default=>0, :limit=>2, :null=>false})
1679 -> 0.0012s
1680-- add_column(:package_file_registry, :verification_started_at, :datetime_with_timezone)
1681 -> 0.0007s
1682== 20201208025254 AddVerificationFieldsToPackageFileRegistry: migrated (0.0021s)
1683== 20201208031224 AddVerificationIndexesToPackageFileRegistry: migrating ======
1684-- transaction_open?(nil)
1685 -> 0.0000s
1686-- view_exists?(:postgres_partitions)
1687 -> 0.0006s
1688-- index_exists?(:package_file_registry, :verified_at, {:where=>"(state = 2 AND verification_state = 0)", :order=>{:verified_at=>"ASC NULLS FIRST"}, :name=>"package_file_registry_pending_verification", :algorithm=>:concurrently})
1689 -> 0.0023s
1690-- add_index(:package_file_registry, :verified_at, {:where=>"(state = 2 AND verification_state = 0)", :order=>{:verified_at=>"ASC NULLS FIRST"}, :name=>"package_file_registry_pending_verification", :algorithm=>:concurrently})
1691 -> 0.0013s
1692-- transaction_open?(nil)
1693 -> 0.0000s
1694-- view_exists?(:postgres_partitions)
1695 -> 0.0005s
1696-- index_exists?(:package_file_registry, :verification_retry_at, {:where=>"(state = 2 AND verification_state = 3)", :order=>{:verification_retry_at=>"ASC NULLS FIRST"}, :name=>"package_file_registry_failed_verification", :algorithm=>:concurrently})
1697 -> 0.0025s
1698-- add_index(:package_file_registry, :verification_retry_at, {:where=>"(state = 2 AND verification_state = 3)", :order=>{:verification_retry_at=>"ASC NULLS FIRST"}, :name=>"package_file_registry_failed_verification", :algorithm=>:concurrently})
1699 -> 0.0011s
1700-- transaction_open?(nil)
1701 -> 0.0000s
1702-- view_exists?(:postgres_partitions)
1703 -> 0.0004s
1704-- index_exists?(:package_file_registry, :verification_state, {:where=>"(state = 2 AND (verification_state IN (0, 3)))", :name=>"package_file_registry_needs_verification", :algorithm=>:concurrently})
1705 -> 0.0028s
1706-- add_index(:package_file_registry, :verification_state, {:where=>"(state = 2 AND (verification_state IN (0, 3)))", :name=>"package_file_registry_needs_verification", :algorithm=>:concurrently})
1707 -> 0.0012s
1708== 20201208031224 AddVerificationIndexesToPackageFileRegistry: migrated (0.0192s)
1709== 20210111911002 PrepareJobArtifactRegistryForSsf: migrating =================
1710-- change_column_default(:job_artifact_registry, :retry_count, {:from=>nil, :to=>0})
1711 -> 0.0021s
1712-- add_column(:job_artifact_registry, :last_synced_at, :datetime_with_timezone)
1713 -> 0.0007s
1714-- add_column(:job_artifact_registry, :verified_at, :datetime_with_timezone)
1715 -> 0.0006s
1716-- add_column(:job_artifact_registry, :verification_started_at, :datetime_with_timezone)
1717 -> 0.0006s
1718-- add_column(:job_artifact_registry, :verification_retry_at, :datetime_with_timezone)
1719 -> 0.0008s
1720-- add_column(:job_artifact_registry, :state, :integer, {:null=>false, :limit=>2, :default=>0})
1721 -> 0.0010s
1722-- add_column(:job_artifact_registry, :verification_state, :integer, {:default=>0, :null=>false, :limit=>2})
1723 -> 0.0009s
1724-- add_column(:job_artifact_registry, :verification_retry_count, :integer, {:default=>0, :limit=>2, :null=>false})
1725 -> 0.0009s
1726-- add_column(:job_artifact_registry, :verification_checksum, :binary)
1727 -> 0.0006s
1728-- add_column(:job_artifact_registry, :verification_checksum_mismatched, :binary)
1729 -> 0.0006s
1730-- add_column(:job_artifact_registry, :checksum_mismatch, :boolean, {:default=>false, :null=>false})
1731 -> 0.0009s
1732-- add_column(:job_artifact_registry, :verification_failure, :string, {:limit=>255})
1733 -> 0.0007s
1734-- add_column(:job_artifact_registry, :last_sync_failure, :string, {:limit=>255})
1735 -> 0.0006s
1736== 20210111911002 PrepareJobArtifactRegistryForSsf: migrated (0.0119s) ========
1737== 20210111912220 PrepareJobArtifactRegistryForSsfIndecies: migrating =========
1738-- transaction_open?(nil)
1739 -> 0.0000s
1740-- view_exists?(:postgres_partitions)
1741 -> 0.0005s
1742-- index_exists?(:job_artifact_registry, :verification_retry_at, {:name=>:job_artifact_registry_failed_verification, :order=>"NULLS FIRST", :where=>"((state = 2) AND (verification_state = 3))", :algorithm=>:concurrently})
1743 -> 0.0023s
1744-- add_index(:job_artifact_registry, :verification_retry_at, {:name=>:job_artifact_registry_failed_verification, :order=>"NULLS FIRST", :where=>"((state = 2) AND (verification_state = 3))", :algorithm=>:concurrently})
1745 -> 0.0013s
1746-- transaction_open?(nil)
1747 -> 0.0000s
1748-- view_exists?(:postgres_partitions)
1749 -> 0.0005s
1750-- index_exists?(:job_artifact_registry, :verification_state, {:name=>:job_artifact_registry_needs_verification, :where=>"((state = 2) AND (verification_state = ANY (ARRAY[0, 3])))", :algorithm=>:concurrently})
1751 -> 0.0026s
1752-- add_index(:job_artifact_registry, :verification_state, {:name=>:job_artifact_registry_needs_verification, :where=>"((state = 2) AND (verification_state = ANY (ARRAY[0, 3])))", :algorithm=>:concurrently})
1753 -> 0.0012s
1754-- transaction_open?(nil)
1755 -> 0.0000s
1756-- view_exists?(:postgres_partitions)
1757 -> 0.0005s
1758-- index_exists?(:job_artifact_registry, :verified_at, {:name=>:job_artifact_registry_pending_verification, :order=>"NULLS FIRST", :where=>"((state = 2) AND (verification_state = 0))", :algorithm=>:concurrently})
1759 -> 0.0030s
1760-- add_index(:job_artifact_registry, :verified_at, {:name=>:job_artifact_registry_pending_verification, :order=>"NULLS FIRST", :where=>"((state = 2) AND (verification_state = 0))", :algorithm=>:concurrently})
1761 -> 0.0012s
1762== 20210111912220 PrepareJobArtifactRegistryForSsfIndecies: migrated (0.0195s)
1763== 20210120225014 MigrateLfsObjectRegistry: migrating =========================
1764-- change_column_default(:lfs_object_registry, :retry_count, {:from=>nil, :to=>0})
1765 -> 0.0020s
1766-- add_column(:lfs_object_registry, :state, :integer, {:null=>false, :limit=>2, :default=>0})
1767 -> 0.0010s
1768-- add_column(:lfs_object_registry, :last_synced_at, :datetime_with_timezone)
1769 -> 0.0007s
1770-- add_column(:lfs_object_registry, :last_sync_failure, :text)
1771 -> 0.0006s
1772== 20210120225014 MigrateLfsObjectRegistry: migrated (0.0049s) ================
1773== 20210125222907 AddLfsObjectStateIndex: migrating ===========================
1774-- transaction_open?(nil)
1775 -> 0.0000s
1776-- view_exists?(:postgres_partitions)
1777 -> 0.0006s
1778-- index_exists?(:lfs_object_registry, :state, {:name=>"index_state_in_lfs_objects", :algorithm=>:concurrently})
1779 -> 0.0023s
1780-- add_index(:lfs_object_registry, :state, {:name=>"index_state_in_lfs_objects", :algorithm=>:concurrently})
1781 -> 0.0011s
1782== 20210125222907 AddLfsObjectStateIndex: migrated (0.0061s) ==================
1783== 20210208175408 CreateGeoSecondaryUsageData: migrating ======================
1784-- create_table(:secondary_usage_data)
1785 -> 0.0027s
1786== 20210208175408 CreateGeoSecondaryUsageData: migrated (0.0028s) =============
1787== 20210217020154 AddUniqueIndexOnContainerRepositoryRegistry: migrating ======
1788-- execute(" DELETE FROM container_repository_registry\n USING (\n SELECT container_repository_id, MIN(id) as min_id\n FROM container_repository_registry\n GROUP BY container_repository_id\n HAVING COUNT(id) > 1\n ) as container_repository_registry_duplicates\n WHERE container_repository_registry_duplicates.container_repository_id = container_repository_registry.container_repository_id\n AND container_repository_registry_duplicates.min_id <> container_repository_registry.id\n")
1789 -> 0.0009s
1790-- transaction_open?(nil)
1791 -> 0.0000s
1792-- view_exists?(:postgres_partitions)
1793 -> 0.0006s
1794-- index_exists?(:container_repository_registry, :container_repository_id, {:unique=>true, :name=>"index_container_repository_registry_repository_id_unique", :algorithm=>:concurrently})
1795 -> 0.0022s
1796-- add_index(:container_repository_registry, :container_repository_id, {:unique=>true, :name=>"index_container_repository_registry_repository_id_unique", :algorithm=>:concurrently})
1797 -> 0.0012s
1798-- transaction_open?(nil)
1799 -> 0.0000s
1800-- view_exists?(:postgres_partitions)
1801 -> 0.0005s
1802-- indexes(:container_repository_registry)
1803 -> 0.0026s
1804-- remove_index(:container_repository_registry, {:algorithm=>:concurrently, :name=>"index_container_repository_registry_on_repository_id"})
1805 -> 0.0009s
1806== 20210217020154 AddUniqueIndexOnContainerRepositoryRegistry: migrated (0.0130s)
1807== 20210217020156 AddUniqueIndexOnTerraformStateVersionRegistry: migrating ====
1808-- execute(" DELETE FROM terraform_state_version_registry\n USING (\n SELECT terraform_state_version_id, MIN(id) as min_id\n FROM terraform_state_version_registry\n GROUP BY terraform_state_version_id\n HAVING COUNT(id) > 1\n ) as terraform_state_version_registry_duplicates\n WHERE terraform_state_version_registry_duplicates.terraform_state_version_id = terraform_state_version_registry.terraform_state_version_id\n AND terraform_state_version_registry_duplicates.min_id <> terraform_state_version_registry.id\n")
1809 -> 0.0011s
1810-- transaction_open?(nil)
1811 -> 0.0000s
1812-- view_exists?(:postgres_partitions)
1813 -> 0.0005s
1814-- index_exists?(:terraform_state_version_registry, :terraform_state_version_id, {:unique=>true, :name=>"index_tf_state_versions_registry_tf_state_versions_id_unique", :algorithm=>:concurrently})
1815 -> 0.0023s
1816-- add_index(:terraform_state_version_registry, :terraform_state_version_id, {:unique=>true, :name=>"index_tf_state_versions_registry_tf_state_versions_id_unique", :algorithm=>:concurrently})
1817 -> 0.0010s
1818-- transaction_open?(nil)
1819 -> 0.0000s
1820-- view_exists?(:postgres_partitions)
1821 -> 0.0005s
1822-- indexes(:terraform_state_version_registry)
1823 -> 0.0025s
1824-- remove_index(:terraform_state_version_registry, {:algorithm=>:concurrently, :name=>"index_tf_state_versions_registry_on_tf_state_versions_id"})
1825 -> 0.0008s
1826== 20210217020156 AddUniqueIndexOnTerraformStateVersionRegistry: migrated (0.0127s)
1827== 20210223111722 CreateGroupWikiRepositoryRegistry: migrating ================
1828-- create_table(:group_wiki_repository_registry, {:id=>:bigserial, :force=>:cascade})
1829 -> 0.0060s
1830-- transaction_open?(nil)
1831 -> 0.0000s
1832-- execute("ALTER TABLE group_wiki_repository_registry\nADD CONSTRAINT check_983ee0d9c3\nCHECK ( char_length(last_sync_failure) <= 255 )\nNOT VALID;\n")
1833 -> 0.0007s
1834-- execute("ALTER TABLE group_wiki_repository_registry VALIDATE CONSTRAINT check_983ee0d9c3;")
1835 -> 0.0008s
1836== 20210223111722 CreateGroupWikiRepositoryRegistry: migrated (0.0125s) =======
1837== 20210225200858 AddTextLimitToLfsObjectRegistryLastSyncFailure: migrating ===
1838-- transaction_open?(nil)
1839 -> 0.0000s
1840-- execute("ALTER TABLE lfs_object_registry\nADD CONSTRAINT check_c41d57c1dc\nCHECK ( char_length(last_sync_failure) <= 255 )\nNOT VALID;\n")
1841 -> 0.0007s
1842-- execute("ALTER TABLE lfs_object_registry VALIDATE CONSTRAINT check_c41d57c1dc;")
1843 -> 0.0006s
1844== 20210225200858 AddTextLimitToLfsObjectRegistryLastSyncFailure: migrated (0.0063s)
1845== 20210313050709 AddVerificationToSnippetRepositoryRegistry: migrating =======
1846-- add_column(:snippet_repository_registry, :verification_started_at, :datetime_with_timezone)
1847 -> 0.0007s
1848-- add_column(:snippet_repository_registry, :verified_at, :datetime_with_timezone)
1849 -> 0.0006s
1850-- add_column(:snippet_repository_registry, :verification_retry_at, :datetime_with_timezone)
1851 -> 0.0006s
1852-- add_column(:snippet_repository_registry, :verification_retry_count, :integer)
1853 -> 0.0006s
1854-- add_column(:snippet_repository_registry, :verification_state, :integer, {:limit=>2, :default=>0, :null=>false})
1855 -> 0.0011s
1856-- add_column(:snippet_repository_registry, :checksum_mismatch, :boolean)
1857 -> 0.0006s
1858-- add_column(:snippet_repository_registry, :verification_checksum, :binary)
1859 -> 0.0007s
1860-- add_column(:snippet_repository_registry, :verification_checksum_mismatched, :binary)
1861 -> 0.0006s
1862-- add_column(:snippet_repository_registry, :verification_failure, :string, {:limit=>255})
1863 -> 0.0006s
1864== 20210313050709 AddVerificationToSnippetRepositoryRegistry: migrated (0.0067s)
1865== 20210313051642 AddVerificationIndexesToSnippetRepositoryRegistry: migrating
1866-- transaction_open?(nil)
1867 -> 0.0000s
1868-- view_exists?(:postgres_partitions)
1869 -> 0.0006s
1870-- index_exists?(:snippet_repository_registry, :verified_at, {:where=>"(state = 2 AND verification_state = 0)", :order=>{:verified_at=>"ASC NULLS FIRST"}, :name=>"snippet_repository_registry_pending_verification", :algorithm=>:concurrently})
1871 -> 0.0023s
1872-- add_index(:snippet_repository_registry, :verified_at, {:where=>"(state = 2 AND verification_state = 0)", :order=>{:verified_at=>"ASC NULLS FIRST"}, :name=>"snippet_repository_registry_pending_verification", :algorithm=>:concurrently})
1873 -> 0.0012s
1874-- transaction_open?(nil)
1875 -> 0.0000s
1876-- view_exists?(:postgres_partitions)
1877 -> 0.0004s
1878-- index_exists?(:snippet_repository_registry, :verification_retry_at, {:where=>"(state = 2 AND verification_state = 3)", :order=>{:verification_retry_at=>"ASC NULLS FIRST"}, :name=>"snippet_repository_registry_failed_verification", :algorithm=>:concurrently})
1879 -> 0.0025s
1880-- add_index(:snippet_repository_registry, :verification_retry_at, {:where=>"(state = 2 AND verification_state = 3)", :order=>{:verification_retry_at=>"ASC NULLS FIRST"}, :name=>"snippet_repository_registry_failed_verification", :algorithm=>:concurrently})
1881 -> 0.0012s
1882-- transaction_open?(nil)
1883 -> 0.0000s
1884-- view_exists?(:postgres_partitions)
1885 -> 0.0005s
1886-- index_exists?(:snippet_repository_registry, :verification_state, {:where=>"(state = 2 AND (verification_state IN (0, 3)))", :name=>"snippet_repository_registry_needs_verification", :algorithm=>:concurrently})
1887 -> 0.0028s
1888-- add_index(:snippet_repository_registry, :verification_state, {:where=>"(state = 2 AND (verification_state IN (0, 3)))", :name=>"snippet_repository_registry_needs_verification", :algorithm=>:concurrently})
1889 -> 0.0012s
1890== 20210313051642 AddVerificationIndexesToSnippetRepositoryRegistry: migrated (0.0189s)
1891== 20210325150435 CreatePipelineArtifactRegistry: migrating ===================
1892-- create_table(:pipeline_artifact_registry, {:id=>:bigserial, :force=>:cascade})
1893 -> 0.0095s
1894== 20210325150435 CreatePipelineArtifactRegistry: migrated (0.0096s) ==========
1895== 20210407140527 AddVerificationToTerraformStateVersionRegistry: migrating ===
1896-- add_column(:terraform_state_version_registry, :verification_started_at, :datetime_with_timezone)
1897 -> 0.0007s
1898-- add_column(:terraform_state_version_registry, :verified_at, :datetime_with_timezone)
1899 -> 0.0007s
1900-- add_column(:terraform_state_version_registry, :verification_retry_at, :datetime_with_timezone)
1901 -> 0.0006s
1902-- add_column(:terraform_state_version_registry, :verification_retry_count, :integer, {:default=>0})
1903 -> 0.0009s
1904-- add_column(:terraform_state_version_registry, :verification_state, :integer, {:limit=>2, :default=>0, :null=>false})
1905 -> 0.0009s
1906-- add_column(:terraform_state_version_registry, :checksum_mismatch, :boolean, {:default=>false, :null=>false})
1907 -> 0.0009s
1908-- add_column(:terraform_state_version_registry, :verification_checksum, :binary)
1909 -> 0.0006s
1910-- add_column(:terraform_state_version_registry, :verification_checksum_mismatched, :binary)
1911 -> 0.0006s
1912-- add_column(:terraform_state_version_registry, :verification_failure, :string, {:limit=>255})
1913 -> 0.0006s
1914== 20210407140527 AddVerificationToTerraformStateVersionRegistry: migrated (0.0071s)
1915== 20210420180119 AddIndexesToTerraformStateVersionRegistry: migrating ========
1916-- transaction_open?(nil)
1917 -> 0.0000s
1918-- view_exists?(:postgres_partitions)
1919 -> 0.0006s
1920-- index_exists?(:terraform_state_version_registry, :terraform_state_version_id, {:name=>"index_terraform_state_version_registry_on_t_state_version_id", :unique=>true, :algorithm=>:concurrently})
1921 -> 0.0023s
1922-- add_index(:terraform_state_version_registry, :terraform_state_version_id, {:name=>"index_terraform_state_version_registry_on_t_state_version_id", :unique=>true, :algorithm=>:concurrently})
1923 -> 0.0012s
1924-- transaction_open?(nil)
1925 -> 0.0000s
1926-- view_exists?(:postgres_partitions)
1927 -> 0.0005s
1928-- index_exists?(:terraform_state_version_registry, :retry_at, {:algorithm=>:concurrently})
1929 -> 0.0025s
1930-- index_name(:terraform_state_version_registry, :retry_at)
1931 -> 0.0000s
1932-- Index not created because it already exists (this may be due to an aborted migration or similar): table_name: terraform_state_version_registry, column_name: retry_at
1933-- transaction_open?(nil)
1934 -> 0.0000s
1935-- view_exists?(:postgres_partitions)
1936 -> 0.0004s
1937-- index_exists?(:terraform_state_version_registry, :state, {:algorithm=>:concurrently})
1938 -> 0.0024s
1939-- index_name(:terraform_state_version_registry, :state)
1940 -> 0.0000s
1941-- Index not created because it already exists (this may be due to an aborted migration or similar): table_name: terraform_state_version_registry, column_name: state
1942-- transaction_open?(nil)
1943 -> 0.0000s
1944-- view_exists?(:postgres_partitions)
1945 -> 0.0006s
1946-- index_exists?(:terraform_state_version_registry, :verification_retry_at, {:name=>"terraform_state_version_registry_failed_verification", :order=>"NULLS FIRST", :where=>"((state = 2) AND (verification_state = 3))", :algorithm=>:concurrently})
1947 -> 0.0026s
1948-- add_index(:terraform_state_version_registry, :verification_retry_at, {:name=>"terraform_state_version_registry_failed_verification", :order=>"NULLS FIRST", :where=>"((state = 2) AND (verification_state = 3))", :algorithm=>:concurrently})
1949 -> 0.0013s
1950-- transaction_open?(nil)
1951 -> 0.0000s
1952-- view_exists?(:postgres_partitions)
1953 -> 0.0005s
1954-- index_exists?(:terraform_state_version_registry, :verification_state, {:name=>"terraform_state_version_registry_needs_verification", :where=>"((state = 2) AND (verification_state = ANY (ARRAY[0, 3])))", :algorithm=>:concurrently})
1955 -> 0.0028s
1956-- add_index(:terraform_state_version_registry, :verification_state, {:name=>"terraform_state_version_registry_needs_verification", :where=>"((state = 2) AND (verification_state = ANY (ARRAY[0, 3])))", :algorithm=>:concurrently})
1957 -> 0.0012s
1958-- transaction_open?(nil)
1959 -> 0.0000s
1960-- view_exists?(:postgres_partitions)
1961 -> 0.0004s
1962-- index_exists?(:terraform_state_version_registry, :verified_at, {:name=>"terraform_state_version_registry_pending_verification", :order=>"NULLS FIRST", :where=>"((state = 2) AND (verification_state = 0))", :algorithm=>:concurrently})
1963 -> 0.0032s
1964-- add_index(:terraform_state_version_registry, :verified_at, {:name=>"terraform_state_version_registry_pending_verification", :order=>"NULLS FIRST", :where=>"((state = 2) AND (verification_state = 0))", :algorithm=>:concurrently})
1965 -> 0.0012s
1966== 20210420180119 AddIndexesToTerraformStateVersionRegistry: migrated (0.0358s)
1967== 20210504143244 AddVerificationToMergeRequestDiffRegistry: migrating ========
1968-- column_exists?(:merge_request_diff_registry, :verification_started_at)
1969 -> 0.0013s
1970-- add_column(:merge_request_diff_registry, :verification_started_at, :datetime_with_timezone)
1971 -> 0.0007s
1972-- column_exists?(:merge_request_diff_registry, :verified_at)
1973 -> 0.0011s
1974-- add_column(:merge_request_diff_registry, :verified_at, :datetime_with_timezone)
1975 -> 0.0006s
1976-- column_exists?(:merge_request_diff_registry, :verification_retry_at)
1977 -> 0.0011s
1978-- add_column(:merge_request_diff_registry, :verification_retry_at, :datetime_with_timezone)
1979 -> 0.0008s
1980-- column_exists?(:merge_request_diff_registry, :verification_retry_count)
1981 -> 0.0012s
1982-- add_column(:merge_request_diff_registry, :verification_retry_count, :integer)
1983 -> 0.0007s
1984-- column_exists?(:merge_request_diff_registry, :verification_state)
1985 -> 0.0011s
1986-- add_column(:merge_request_diff_registry, :verification_state, :integer, {:limit=>2, :default=>0, :null=>false})
1987 -> 0.0010s
1988-- column_exists?(:merge_request_diff_registry, :checksum_mismatch)
1989 -> 0.0012s
1990-- add_column(:merge_request_diff_registry, :checksum_mismatch, :boolean)
1991 -> 0.0006s
1992-- column_exists?(:merge_request_diff_registry, :verification_checksum)
1993 -> 0.0011s
1994-- add_column(:merge_request_diff_registry, :verification_checksum, :binary)
1995 -> 0.0007s
1996-- column_exists?(:merge_request_diff_registry, :verification_checksum_mismatched)
1997 -> 0.0013s
1998-- add_column(:merge_request_diff_registry, :verification_checksum_mismatched, :binary)
1999 -> 0.0007s
2000-- column_exists?(:merge_request_diff_registry, :verification_failure)
2001 -> 0.0016s
2002-- add_column(:merge_request_diff_registry, :verification_failure, :string, {:limit=>255})
2003 -> 0.0006s
2004== 20210504143244 AddVerificationToMergeRequestDiffRegistry: migrated (0.0184s)
2005== 20210505170208 AddIndexesToMergeRequestDiffRegistryTable: migrating ========
2006-- transaction_open?(nil)
2007 -> 0.0000s
2008-- view_exists?(:postgres_partitions)
2009 -> 0.0007s
2010-- indexes(:merge_request_diff_registry)
2011 -> 0.0024s
2012-- remove_index(:merge_request_diff_registry, {:algorithm=>:concurrently, :name=>"index_merge_request_diff_registry_on_mr_diff_id"})
2013 -> 0.0010s
2014-- transaction_open?(nil)
2015 -> 0.0000s
2016-- view_exists?(:postgres_partitions)
2017 -> 0.0004s
2018-- index_exists?(:merge_request_diff_registry, :merge_request_diff_id, {:name=>"index_merge_request_diff_registry_on_mr_diff_id", :unique=>true, :algorithm=>:concurrently})
2019 -> 0.0018s
2020-- add_index(:merge_request_diff_registry, :merge_request_diff_id, {:name=>"index_merge_request_diff_registry_on_mr_diff_id", :unique=>true, :algorithm=>:concurrently})
2021 -> 0.0010s
2022-- transaction_open?(nil)
2023 -> 0.0000s
2024-- view_exists?(:postgres_partitions)
2025 -> 0.0005s
2026-- index_exists?(:merge_request_diff_registry, :verification_retry_at, {:name=>"merge_request_diff_registry_failed_verification", :order=>"NULLS FIRST", :where=>"((state = 2) AND (verification_state = 3))", :algorithm=>:concurrently})
2027 -> 0.0020s
2028-- add_index(:merge_request_diff_registry, :verification_retry_at, {:name=>"merge_request_diff_registry_failed_verification", :order=>"NULLS FIRST", :where=>"((state = 2) AND (verification_state = 3))", :algorithm=>:concurrently})
2029 -> 0.0011s
2030-- transaction_open?(nil)
2031 -> 0.0000s
2032-- view_exists?(:postgres_partitions)
2033 -> 0.0005s
2034-- index_exists?(:merge_request_diff_registry, :verification_state, {:name=>"merge_request_diff_registry_needs_verification", :where=>"((state = 2) AND (verification_state = ANY (ARRAY[0, 3])))", :algorithm=>:concurrently})
2035 -> 0.0025s
2036-- add_index(:merge_request_diff_registry, :verification_state, {:name=>"merge_request_diff_registry_needs_verification", :where=>"((state = 2) AND (verification_state = ANY (ARRAY[0, 3])))", :algorithm=>:concurrently})
2037 -> 0.0012s
2038-- transaction_open?(nil)
2039 -> 0.0000s
2040-- view_exists?(:postgres_partitions)
2041 -> 0.0004s
2042-- index_exists?(:merge_request_diff_registry, :verified_at, {:name=>"merge_request_diff_registry_pending_verification", :order=>"NULLS FIRST", :where=>"((state = 2) AND (verification_state = 0))", :algorithm=>:concurrently})
2043 -> 0.0029s
2044-- add_index(:merge_request_diff_registry, :verified_at, {:name=>"merge_request_diff_registry_pending_verification", :order=>"NULLS FIRST", :where=>"((state = 2) AND (verification_state = 0))", :algorithm=>:concurrently})
2045 -> 0.0012s
2046== 20210505170208 AddIndexesToMergeRequestDiffRegistryTable: migrated (0.0295s)
2047== 20210624160455 FixStateColumnInLfsObjectRegistry: migrating ================
2048-- transaction_open?(nil)
2049 -> 0.0000s
2050-- exec_query("SELECT COUNT(*) AS count FROM \"lfs_object_registry\" WHERE \"lfs_object_registry\".\"success\" = TRUE")
2051 -> 0.0009s
2052== 20210624160455 FixStateColumnInLfsObjectRegistry: migrated (0.0014s) =======
2053== 20210706120644 PrepareFileRegistryForSsf: migrating ========================
2054-- change_column_default(:file_registry, :retry_count, {:from=>nil, :to=>0})
2055 -> 0.0022s
2056-- add_column(:file_registry, :state, :integer, {:null=>false, :limit=>2, :default=>0})
2057 -> 0.0009s
2058-- add_column(:file_registry, :last_synced_at, :datetime_with_timezone)
2059 -> 0.0006s
2060-- add_column(:file_registry, :last_sync_failure, :string, {:limit=>255})
2061 -> 0.0006s
2062== 20210706120644 PrepareFileRegistryForSsf: migrated (0.0046s) ===============
2063== 20210818111211 FixStateColumnInFileRegistry: migrating =====================
2064-- transaction_open?(nil)
2065 -> 0.0000s
2066-- exec_query("SELECT COUNT(*) AS count FROM \"file_registry\" WHERE \"file_registry\".\"success\" = TRUE")
2067 -> 0.0008s
2068== 20210818111211 FixStateColumnInFileRegistry: migrated (0.0011s) ============
2069== 20210820152707 CreatePagesDeploymentRegistry: migrating ====================
2070-- create_table(:pages_deployment_registry, {:id=>:bigserial, :force=>:cascade})
2071 -> 0.0048s
2072== 20210820152707 CreatePagesDeploymentRegistry: migrated (0.0049s) ===========
2073geo: == 20211021112221 RemoveUploadLegacyFields: migrating =========================
2074geo: -- remove_column(:file_registry, :file_type, :string, {:null=>false})
2075geo: -> 0.0006s
2076geo: -- remove_column(:file_registry, :success, :boolean, {:null=>false})
2077geo: -> 0.0007s
2078geo: -- remove_column(:file_registry, :bytes, :integer)
2079geo: -> 0.0006s
2080geo: -- remove_column(:file_registry, :sha256, :string)
2081geo: -> 0.0006s
2082geo: == 20211021112221 RemoveUploadLegacyFields: migrated (0.0027s) ================
2083geo: == 20211101113611 PrepareFileRegistryForVerification: migrating ===============
2084geo: -- add_column(:file_registry, :verified_at, :datetime_with_timezone)
2085geo: -> 0.0007s
2086geo: -- add_column(:file_registry, :verification_started_at, :datetime_with_timezone)
2087geo: -> 0.0007s
2088geo: -- add_column(:file_registry, :verification_retry_at, :datetime_with_timezone)
2089geo: -> 0.0006s
2090geo: -- add_column(:file_registry, :verification_state, :integer, {:default=>0, :null=>false, :limit=>2})
2091geo: -> 0.0010s
2092geo: -- add_column(:file_registry, :verification_retry_count, :integer, {:default=>0, :limit=>2, :null=>false})
2093geo: -> 0.0009s
2094geo: -- add_column(:file_registry, :verification_checksum, :binary)
2095geo: -> 0.0006s
2096geo: -- add_column(:file_registry, :verification_checksum_mismatched, :binary)
2097geo: -> 0.0006s
2098geo: -- add_column(:file_registry, :checksum_mismatch, :boolean, {:default=>false, :null=>false})
2099geo: -> 0.0010s
2100geo: -- add_column(:file_registry, :verification_failure, :text)
2101geo: -> 0.0007s
2102geo: == 20211101113611 PrepareFileRegistryForVerification: migrated (0.0075s) ======
2103geo: == 20211102121712 CreateFileRegistryVerificationIndexies: migrating ===========
2104geo: -- transaction_open?(nil)
2105geo: -> 0.0000s
2106geo: -- view_exists?(:postgres_partitions)
2107geo: -> 0.0006s
2108geo: -- index_exists?(:file_registry, :verification_retry_at, {:name=>:file_registry_failed_verification, :order=>"NULLS FIRST", :where=>"((state = 2) AND (verification_state = 3))", :algorithm=>:concurrently})
2109geo: -> 0.0015s
2110geo: -- add_index(:file_registry, :verification_retry_at, {:name=>:file_registry_failed_verification, :order=>"NULLS FIRST", :where=>"((state = 2) AND (verification_state = 3))", :algorithm=>:concurrently})
2111geo: -> 0.0012s
2112geo: -- transaction_open?(nil)
2113geo: -> 0.0000s
2114geo: -- view_exists?(:postgres_partitions)
2115geo: -> 0.0004s
2116geo: -- index_exists?(:file_registry, :verification_state, {:name=>:file_registry_needs_verification, :where=>"((state = 2) AND (verification_state = ANY (ARRAY[0, 3])))", :algorithm=>:concurrently})
2117geo: -> 0.0018s
2118geo: -- add_index(:file_registry, :verification_state, {:name=>:file_registry_needs_verification, :where=>"((state = 2) AND (verification_state = ANY (ARRAY[0, 3])))", :algorithm=>:concurrently})
2119geo: -> 0.0011s
2120geo: -- transaction_open?(nil)
2121geo: -> 0.0000s
2122geo: -- view_exists?(:postgres_partitions)
2123geo: -> 0.0005s
2124geo: -- index_exists?(:file_registry, :verified_at, {:name=>:file_registry_pending_verification, :order=>"NULLS FIRST", :where=>"((state = 2) AND (verification_state = 0))", :algorithm=>:concurrently})
2125geo: -> 0.0021s
2126geo: -- add_index(:file_registry, :verified_at, {:name=>:file_registry_pending_verification, :order=>"NULLS FIRST", :where=>"((state = 2) AND (verification_state = 0))", :algorithm=>:concurrently})
2127geo: -> 0.0013s
2128geo: == 20211102121712 CreateFileRegistryVerificationIndexies: migrated (0.0164s) ==
2129geo: == 20211119152539 AddVerificationToPagesDeploymentRegistry: migrating =========
2130geo: -- add_column(:pages_deployment_registry, :verification_started_at, :datetime_with_timezone)
2131geo: -> 0.0007s
2132geo: -- add_column(:pages_deployment_registry, :verified_at, :datetime_with_timezone)
2133geo: -> 0.0007s
2134geo: -- add_column(:pages_deployment_registry, :verification_retry_at, :datetime_with_timezone)
2135geo: -> 0.0006s
2136geo: -- add_column(:pages_deployment_registry, :verification_retry_count, :integer, {:default=>0, :limit=>2, :null=>false})
2137geo: -> 0.0011s
2138geo: -- add_column(:pages_deployment_registry, :verification_state, :integer, {:limit=>2, :default=>0, :null=>false})
2139geo: -> 0.0010s
2140geo: -- add_column(:pages_deployment_registry, :checksum_mismatch, :boolean, {:default=>false, :null=>false})
2141geo: -> 0.0010s
2142geo: -- add_column(:pages_deployment_registry, :verification_checksum, :binary)
2143geo: -> 0.0011s
2144geo: -- add_column(:pages_deployment_registry, :verification_checksum_mismatched, :binary)
2145geo: -> 0.0006s
2146geo: -- add_column(:pages_deployment_registry, :verification_failure, :text)
2147geo: -> 0.0006s
2148geo: == 20211119152539 AddVerificationToPagesDeploymentRegistry: migrated (0.0082s)
2149geo: == 20211124000000 AddVerificationToLfsObjectRegistry: migrating ===============
2150geo: -- add_column(:lfs_object_registry, :verification_started_at, :datetime_with_timezone)
2151geo: -> 0.0007s
2152geo: -- add_column(:lfs_object_registry, :verified_at, :datetime_with_timezone)
2153geo: -> 0.0007s
2154geo: -- add_column(:lfs_object_registry, :verification_retry_at, :datetime_with_timezone)
2155geo: -> 0.0006s
2156geo: -- add_column(:lfs_object_registry, :verification_retry_count, :integer, {:default=>0})
2157geo: -> 0.0010s
2158geo: -- add_column(:lfs_object_registry, :verification_state, :integer, {:limit=>2, :default=>0, :null=>false})
2159geo: -> 0.0011s
2160geo: -- add_column(:lfs_object_registry, :checksum_mismatch, :boolean, {:default=>false, :null=>false})
2161geo: -> 0.0011s
2162geo: -- add_column(:lfs_object_registry, :verification_checksum, :binary)
2163geo: -> 0.0006s
2164geo: -- add_column(:lfs_object_registry, :verification_checksum_mismatched, :binary)
2165geo: -> 0.0006s
2166geo: -- add_column(:lfs_object_registry, :verification_failure, :text)
2167geo: -> 0.0006s
2168geo: == 20211124000000 AddVerificationToLfsObjectRegistry: migrated (0.0077s) ======
2169geo: == 20211124000001 AddTextLimitToLfsObjectRegistryVerificationFailure: migrating
2170geo: -- transaction_open?(nil)
2171geo: -> 0.0000s
2172geo: -- transaction_open?(nil)
2173geo: -> 0.0000s
2174geo: -- execute("ALTER TABLE lfs_object_registry\nADD CONSTRAINT check_8bcaa12138\nCHECK ( char_length(verification_failure) <= 255 )\nNOT VALID;\n")
2175geo: -> 0.0007s
2176geo: -- execute("ALTER TABLE lfs_object_registry VALIDATE CONSTRAINT check_8bcaa12138;")
2177geo: -> 0.0006s
2178geo: == 20211124000001 AddTextLimitToLfsObjectRegistryVerificationFailure: migrated (0.0063s)
2179geo: == 20211124000002 AddIndexesToLfsObjectRegistry: migrating ====================
2180geo: -- transaction_open?(nil)
2181geo: -> 0.0000s
2182geo: -- view_exists?(:postgres_partitions)
2183geo: -> 0.0006s
2184geo: -- index_exists?(:lfs_object_registry, :lfs_object_id, {:name=>"index_lfs_object_registry_on_lfs_object_id", :unique=>true, :algorithm=>:concurrently})
2185geo: -> 0.0026s
2186geo: -- Index not created because it already exists (this may be due to an aborted migration or similar): table_name: lfs_object_registry, column_name: lfs_object_id
2187geo: -- transaction_open?(nil)
2188geo: -> 0.0000s
2189geo: -- view_exists?(:postgres_partitions)
2190geo: -> 0.0005s
2191geo: -- index_exists?(:lfs_object_registry, :verification_retry_at, {:name=>"lfs_object_registry_failed_verification", :order=>"NULLS FIRST", :where=>"((state = 2) AND (verification_state = 3))", :algorithm=>:concurrently})
2192geo: -> 0.0024s
2193geo: -- add_index(:lfs_object_registry, :verification_retry_at, {:name=>"lfs_object_registry_failed_verification", :order=>"NULLS FIRST", :where=>"((state = 2) AND (verification_state = 3))", :algorithm=>:concurrently})
2194geo: -> 0.0012s
2195geo: -- transaction_open?(nil)
2196geo: -> 0.0000s
2197geo: -- view_exists?(:postgres_partitions)
2198geo: -> 0.0005s
2199geo: -- index_exists?(:lfs_object_registry, :verification_state, {:name=>"lfs_object_registry_needs_verification", :where=>"((state = 2) AND (verification_state = ANY (ARRAY[0, 3])))", :algorithm=>:concurrently})
2200geo: -> 0.0027s
2201geo: -- add_index(:lfs_object_registry, :verification_state, {:name=>"lfs_object_registry_needs_verification", :where=>"((state = 2) AND (verification_state = ANY (ARRAY[0, 3])))", :algorithm=>:concurrently})
2202geo: -> 0.0012s
2203geo: -- transaction_open?(nil)
2204geo: -> 0.0000s
2205geo: -- view_exists?(:postgres_partitions)
2206geo: -> 0.0005s
2207geo: -- index_exists?(:lfs_object_registry, :verified_at, {:name=>"lfs_object_registry_pending_verification", :order=>"NULLS FIRST", :where=>"((state = 2) AND (verification_state = 0))", :algorithm=>:concurrently})
2208geo: -> 0.0030s
2209geo: -- add_index(:lfs_object_registry, :verified_at, {:name=>"lfs_object_registry_pending_verification", :order=>"NULLS FIRST", :where=>"((state = 2) AND (verification_state = 0))", :algorithm=>:concurrently})
2210geo: -> 0.0012s
2211geo: == 20211124000002 AddIndexesToLfsObjectRegistry: migrated (0.0239s) ===========
2212geo: == 20211126312431 AddTextLimitToFileRegistryVerificationFailure: migrating ====
2213geo: -- transaction_open?(nil)
2214geo: -> 0.0000s
2215geo: -- transaction_open?(nil)
2216geo: -> 0.0000s
2217geo: -- execute("ALTER TABLE file_registry\nADD CONSTRAINT check_1886652634\nCHECK ( char_length(verification_failure) <= 256 )\nNOT VALID;\n")
2218geo: -> 0.0007s
2219geo: -- execute("ALTER TABLE file_registry VALIDATE CONSTRAINT check_1886652634;")
2220geo: -> 0.0008s
2221geo: == 20211126312431 AddTextLimitToFileRegistryVerificationFailure: migrated (0.0062s)
2222geo: == 20211207162157 AddIndexesToPagesDeploymentRegistry: migrating ==============
2223geo: -- transaction_open?(nil)
2224geo: -> 0.0000s
2225geo: -- view_exists?(:postgres_partitions)
2226geo: -> 0.0006s
2227geo: -- index_exists?(:pages_deployment_registry, :pages_deployment_id, {:name=>"index_pages_deployment_registry_on_pages_deployment_id", :unique=>true, :algorithm=>:concurrently})
2228geo: -> 0.0022s
2229geo: -- Index not created because it already exists (this may be due to an aborted migration or similar): table_name: pages_deployment_registry, column_name: pages_deployment_id
2230geo: -- transaction_open?(nil)
2231geo: -> 0.0000s
2232geo: -- view_exists?(:postgres_partitions)
2233geo: -> 0.0005s
2234geo: -- index_exists?(:pages_deployment_registry, :verification_retry_at, {:name=>"pages_deployment_registry_failed_verification", :order=>"NULLS FIRST", :where=>"((state = 2) AND (verification_state = 3))", :algorithm=>:concurrently})
2235geo: -> 0.0021s
2236geo: -- add_index(:pages_deployment_registry, :verification_retry_at, {:name=>"pages_deployment_registry_failed_verification", :order=>"NULLS FIRST", :where=>"((state = 2) AND (verification_state = 3))", :algorithm=>:concurrently})
2237geo: -> 0.0012s
2238geo: -- transaction_open?(nil)
2239geo: -> 0.0000s
2240geo: -- view_exists?(:postgres_partitions)
2241geo: -> 0.0005s
2242geo: -- index_exists?(:pages_deployment_registry, :verification_state, {:name=>"pages_deployment_registry_needs_verification", :where=>"((state = 2) AND (verification_state = ANY (ARRAY[0, 3])))", :algorithm=>:concurrently})
2243geo: -> 0.0024s
2244geo: -- add_index(:pages_deployment_registry, :verification_state, {:name=>"pages_deployment_registry_needs_verification", :where=>"((state = 2) AND (verification_state = ANY (ARRAY[0, 3])))", :algorithm=>:concurrently})
2245geo: -> 0.0012s
2246geo: -- transaction_open?(nil)
2247geo: -> 0.0000s
2248geo: -- view_exists?(:postgres_partitions)
2249geo: -> 0.0005s
2250geo: -- index_exists?(:pages_deployment_registry, :verified_at, {:name=>"pages_deployment_registry_pending_verification", :order=>"NULLS FIRST", :where=>"((state = 2) AND (verification_state = 0))", :algorithm=>:concurrently})
2251geo: -> 0.0029s
2252geo: -- add_index(:pages_deployment_registry, :verified_at, {:name=>"pages_deployment_registry_pending_verification", :order=>"NULLS FIRST", :where=>"((state = 2) AND (verification_state = 0))", :algorithm=>:concurrently})
2253geo: -> 0.0011s
2254geo: == 20211207162157 AddIndexesToPagesDeploymentRegistry: migrated (0.0228s) =====
2255geo: == 20211207175940 AddTextLimitToPagesDeploymentRegistryVerificationFailure: migrating
2256geo: -- transaction_open?(nil)
2257geo: -> 0.0000s
2258geo: -- transaction_open?(nil)
2259geo: -> 0.0000s
2260geo: -- execute("ALTER TABLE pages_deployment_registry\nADD CONSTRAINT check_7eb0430eff\nCHECK ( char_length(verification_failure) <= 255 )\nNOT VALID;\n")
2261geo: -> 0.0008s
2262geo: -- execute("ALTER TABLE pages_deployment_registry VALIDATE CONSTRAINT check_7eb0430eff;")
2263geo: -> 0.0006s
2264geo: == 20211207175940 AddTextLimitToPagesDeploymentRegistryVerificationFailure: migrated (0.0080s)
2265geo: == 20220202101354 MigrateJobArtifactRegistry: migrating =======================
2266geo: -- transaction_open?(nil)
2267geo: -> 0.0000s
2268geo: -- Scheduled 0 MigrateJobArtifactRegistryToSsf jobs with a maximum of 5000 records per batch and an interval of 120 seconds.
2269The migration is expected to take at least 0 seconds. Expect all jobs to have completed after 2024-07-31 10:15:18 UTC."
2270geo: == 20220202101354 MigrateJobArtifactRegistry: migrated (0.0115s) ==============
2271geo: == 20220617125507 CreateCiSecureFileRegistry: migrating =======================
2272geo: -- create_table(:ci_secure_file_registry, {:id=>:bigserial, :force=>:cascade})
2273geo: -- quote_column_name(:verification_failure)
2274geo: -> 0.0000s
2275geo: -- quote_column_name(:last_sync_failure)
2276geo: -> 0.0000s
2277geo: -> 0.0130s
2278geo: == 20220617125507 CreateCiSecureFileRegistry: migrated (0.0145s) ==============
2279geo: == 20221017195204 CreateProjectWikiRepositoryRegistry: migrating ==============
2280geo: -- create_table(:project_wiki_repository_registry, {:id=>:bigserial, :force=>:cascade})
2281geo: -- quote_column_name(:verification_failure)
2282geo: -> 0.0000s
2283geo: -- quote_column_name(:last_sync_failure)
2284geo: -> 0.0000s
2285geo: -> 0.0124s
2286geo: == 20221017195204 CreateProjectWikiRepositoryRegistry: migrated (0.0127s) =====
2287geo: == 20221018201808 CreateDependencyProxyBlobRegistry: migrating ================
2288geo: -- create_table(:dependency_proxy_blob_registry, {:id=>:bigserial, :force=>:cascade})
2289geo: -- quote_column_name(:verification_failure)
2290geo: -> 0.0000s
2291geo: -- quote_column_name(:last_sync_failure)
2292geo: -> 0.0000s
2293geo: -> 0.0121s
2294geo: == 20221018201808 CreateDependencyProxyBlobRegistry: migrated (0.0126s) =======
2295geo: == 20221102195145 CreateDependencyProxyManifestRegistry: migrating ============
2296geo: -- create_table(:dependency_proxy_manifest_registry, {:id=>:bigserial, :force=>:cascade})
2297geo: -- quote_column_name(:verification_failure)
2298geo: -> 0.0000s
2299geo: -- quote_column_name(:last_sync_failure)
2300geo: -> 0.0000s
2301geo: -> 0.0118s
2302geo: == 20221102195145 CreateDependencyProxyManifestRegistry: migrated (0.0120s) ===
2303geo: == 20221107151025 RemoveJobArtifactRegistrySuccessColumn: migrating ===========
2304geo: -- remove_column(:job_artifact_registry, :success)
2305geo: -> 0.0012s
2306geo: == 20221107151025 RemoveJobArtifactRegistrySuccessColumn: migrated (0.0014s) ==
2307geo: == 20230104022140 TruncateContainerRepositoryRegistry: migrating ==============
2308geo: -- execute("TRUNCATE TABLE container_repository_registry")
2309geo: -> 0.0019s
2310geo: == 20230104022140 TruncateContainerRepositoryRegistry: migrated (0.0021s) =====
2311geo: == 20230116215802 AddProjectWikiRepositoryIdToProjectWikiRepositoryRegistry: migrating
2312geo: -- add_column(:project_wiki_repository_registry, :project_wiki_repository_id, :bigint)
2313geo: -> 0.0010s
2314geo: == 20230116215802 AddProjectWikiRepositoryIdToProjectWikiRepositoryRegistry: migrated (0.0013s)
2315geo: == 20230116220255 AddIndexToProjectWikiRepositoryRegistry: migrating ==========
2316geo: -- transaction_open?(nil)
2317geo: -> 0.0000s
2318geo: -- view_exists?(:postgres_partitions)
2319geo: -> 0.0048s
2320geo: -- index_exists?(:project_wiki_repository_registry, :project_wiki_repository_id, {:name=>"idx_project_wiki_repository_registry_project_wiki_repository_id", :unique=>true, :algorithm=>:concurrently})
2321geo: -> 0.0064s
2322geo: -- add_index(:project_wiki_repository_registry, :project_wiki_repository_id, {:name=>"idx_project_wiki_repository_registry_project_wiki_repository_id", :unique=>true, :algorithm=>:concurrently})
2323geo: -> 0.0012s
2324geo: == 20230116220255 AddIndexToProjectWikiRepositoryRegistry: migrated (0.0159s) =
2325geo: == 20230116221137 AddNotNullConstraintToProjectWikiRepositoryId: migrating ====
2326geo: -- current_schema(nil)
2327geo: -> 0.0006s
2328geo: -- transaction_open?(nil)
2329geo: -> 0.0000s
2330geo: -- transaction_open?(nil)
2331geo: -> 0.0000s
2332geo: -- execute("ALTER TABLE project_wiki_repository_registry\nADD CONSTRAINT check_4112c47225\nCHECK ( project_wiki_repository_id IS NOT NULL )\nNOT VALID;\n")
2333geo: -> 0.0009s
2334geo: == 20230116221137 AddNotNullConstraintToProjectWikiRepositoryId: migrated (0.0112s)
2335geo: == 20230116222320 RemoveNotNullConstraintOnProjectWikiRepositoryRegistryProjectId: migrating
2336geo: -- change_column_null(:project_wiki_repository_registry, :project_id, true)
2337geo: -> 0.0008s
2338geo: == 20230116222320 RemoveNotNullConstraintOnProjectWikiRepositoryRegistryProjectId: migrated (0.0011s)
2339geo: == 20230116223815 TruncateProjectWikiRepositoryRegistry: migrating ============
2340geo: -- execute("TRUNCATE TABLE project_wiki_repository_registry")
2341geo: -> 0.0028s
2342geo: == 20230116223815 TruncateProjectWikiRepositoryRegistry: migrated (0.0031s) ===
2343geo: == 20230123021021 TruncateContainerRepositoryRegistry2: migrating =============
2344geo: -- execute("TRUNCATE TABLE container_repository_registry")
2345geo: -> 0.0019s
2346geo: == 20230123021021 TruncateContainerRepositoryRegistry2: migrated (0.0021s) ====
2347geo: == 20230201110601 PrepareContainerRepositoryRegistryForVerification: migrating
2348geo: -- add_column(:container_repository_registry, :verified_at, :datetime_with_timezone)
2349geo: -> 0.0009s
2350geo: -- add_column(:container_repository_registry, :verification_started_at, :datetime_with_timezone)
2351geo: -> 0.0008s
2352geo: -- add_column(:container_repository_registry, :verification_retry_at, :datetime_with_timezone)
2353geo: -> 0.0007s
2354geo: -- add_column(:container_repository_registry, :verification_state, :integer, {:default=>0, :null=>false, :limit=>2})
2355geo: -> 0.0014s
2356geo: -- add_column(:container_repository_registry, :verification_retry_count, :integer, {:default=>0, :limit=>2, :null=>false})
2357geo: -> 0.0012s
2358geo: -- add_column(:container_repository_registry, :verification_checksum, :binary)
2359geo: -> 0.0007s
2360geo: -- add_column(:container_repository_registry, :verification_checksum_mismatched, :binary)
2361geo: -> 0.0008s
2362geo: -- add_column(:container_repository_registry, :checksum_mismatch, :boolean, {:default=>false, :null=>false})
2363geo: -> 0.0011s
2364geo: -- add_column(:container_repository_registry, :verification_failure, :text)
2365geo: -> 0.0007s
2366geo: == 20230201110601 PrepareContainerRepositoryRegistryForVerification: migrated (0.0091s)
2367geo: == 20230201121712 CreateContainerRepositoryRegistryVerificationIndexies: migrating
2368geo: -- transaction_open?(nil)
2369geo: -> 0.0000s
2370geo: -- view_exists?(:postgres_partitions)
2371geo: -> 0.0012s
2372geo: -- index_exists?(:container_repository_registry, :verification_retry_at, {:name=>:container_repository_registry_failed_verification, :order=>"NULLS FIRST", :where=>"verification_state = 3", :algorithm=>:concurrently})
2373geo: -> 0.0040s
2374geo: -- add_index(:container_repository_registry, :verification_retry_at, {:name=>:container_repository_registry_failed_verification, :order=>"NULLS FIRST", :where=>"verification_state = 3", :algorithm=>:concurrently})
2375geo: -> 0.0015s
2376geo: -- transaction_open?(nil)
2377geo: -> 0.0000s
2378geo: -- view_exists?(:postgres_partitions)
2379geo: -> 0.0008s
2380geo: -- index_exists?(:container_repository_registry, :verification_state, {:name=>:container_repository_registry_needs_verification, :where=>"verification_state = ANY (ARRAY[0, 3])", :algorithm=>:concurrently})
2381geo: -> 0.0045s
2382geo: -- add_index(:container_repository_registry, :verification_state, {:name=>:container_repository_registry_needs_verification, :where=>"verification_state = ANY (ARRAY[0, 3])", :algorithm=>:concurrently})
2383geo: -> 0.0014s
2384geo: -- transaction_open?(nil)
2385geo: -> 0.0000s
2386geo: -- view_exists?(:postgres_partitions)
2387geo: -> 0.0008s
2388geo: -- index_exists?(:container_repository_registry, :verified_at, {:name=>:container_repository_registry_pending_verification, :order=>"NULLS FIRST", :where=>"verification_state = 0", :algorithm=>:concurrently})
2389geo: -> 0.0051s
2390geo: -- add_index(:container_repository_registry, :verified_at, {:name=>:container_repository_registry_pending_verification, :order=>"NULLS FIRST", :where=>"verification_state = 0", :algorithm=>:concurrently})
2391geo: -> 0.0015s
2392geo: == 20230201121712 CreateContainerRepositoryRegistryVerificationIndexies: migrated (0.0298s)
2393geo: == 20230201312431 AddTextLimitToContainerRepositoryRegistryVerificationFailure: migrating
2394geo: -- transaction_open?(nil)
2395geo: -> 0.0000s
2396geo: -- transaction_open?(nil)
2397geo: -> 0.0000s
2398geo: -- execute("ALTER TABLE container_repository_registry\nADD CONSTRAINT check_9b8292bb64\nCHECK ( char_length(verification_failure) <= 255 )\nNOT VALID;\n")
2399geo: -> 0.0008s
2400geo: -- execute("ALTER TABLE container_repository_registry VALIDATE CONSTRAINT check_9b8292bb64;")
2401geo: -> 0.0007s
2402geo: == 20230201312431 AddTextLimitToContainerRepositoryRegistryVerificationFailure: migrated (0.0085s)
2403geo: == 20230323102034 CreateDesignManagementRepositoryRegistry: migrating =========
2404geo: -- create_table(:design_management_repository_registry, {:id=>:bigserial, :force=>:cascade})
2405geo: -- quote_column_name(:verification_failure)
2406geo: -> 0.0000s
2407geo: -- quote_column_name(:last_sync_failure)
2408geo: -> 0.0000s
2409geo: -> 0.0125s
2410geo: == 20230323102034 CreateDesignManagementRepositoryRegistry: migrated (0.0128s)
2411geo: == 20230418172503 CreateProjectRepositoryRegistry: migrating ==================
2412geo: -- create_table(:project_repository_registry, {:id=>:bigserial, :force=>:cascade})
2413geo: -- quote_column_name(:verification_failure)
2414geo: -> 0.0000s
2415geo: -- quote_column_name(:last_sync_failure)
2416geo: -> 0.0000s
2417geo: -> 0.0122s
2418geo: == 20230418172503 CreateProjectRepositoryRegistry: migrated (0.0124s) =========
2419geo: == 20230717195110 PrepareGroupWikiRepositoryRegistryForVerification: migrating
2420geo: -- add_column(:group_wiki_repository_registry, :verified_at, :datetime_with_timezone)
2421geo: -> 0.0009s
2422geo: -- add_column(:group_wiki_repository_registry, :verification_started_at, :datetime_with_timezone)
2423geo: -> 0.0009s
2424geo: -- add_column(:group_wiki_repository_registry, :verification_retry_at, :datetime_with_timezone)
2425geo: -> 0.0008s
2426geo: -- add_column(:group_wiki_repository_registry, :verification_state, :integer, {:default=>0, :null=>false, :limit=>2})
2427geo: -> 0.0015s
2428geo: -- add_column(:group_wiki_repository_registry, :verification_retry_count, :integer, {:default=>0, :limit=>2, :null=>false})
2429geo: -> 0.0014s
2430geo: -- add_column(:group_wiki_repository_registry, :checksum_mismatch, :boolean, {:default=>false, :null=>false})
2431geo: -> 0.0012s
2432geo: -- add_column(:group_wiki_repository_registry, :verification_checksum, :binary)
2433geo: -> 0.0007s
2434geo: -- add_column(:group_wiki_repository_registry, :verification_checksum_mismatched, :binary)
2435geo: -> 0.0007s
2436geo: -- add_column(:group_wiki_repository_registry, :verification_failure, :text)
2437geo: -> 0.0007s
2438geo: == 20230717195110 PrepareGroupWikiRepositoryRegistryForVerification: migrated (0.0096s)
2439geo: == 20230717195815 CreateGroupWikiRepositoryRegistryVerificationIndexies: migrating
2440geo: -- transaction_open?(nil)
2441geo: -> 0.0000s
2442geo: -- view_exists?(:postgres_partitions)
2443geo: -> 0.0011s
2444geo: -- index_exists?(:group_wiki_repository_registry, :verification_retry_at, {:name=>:group_wiki_repository_registry_failed_verification, :order=>"NULLS FIRST", :where=>"verification_state = 3", :algorithm=>:concurrently})
2445geo: -> 0.0040s
2446geo: -- add_index(:group_wiki_repository_registry, :verification_retry_at, {:name=>:group_wiki_repository_registry_failed_verification, :order=>"NULLS FIRST", :where=>"verification_state = 3", :algorithm=>:concurrently})
2447geo: -> 0.0015s
2448geo: -- transaction_open?(nil)
2449geo: -> 0.0000s
2450geo: -- view_exists?(:postgres_partitions)
2451geo: -> 0.0010s
2452geo: -- index_exists?(:group_wiki_repository_registry, :verification_state, {:name=>:group_wiki_repository_registry_needs_verification, :where=>"verification_state = ANY (ARRAY[0, 3])", :algorithm=>:concurrently})
2453geo: -> 0.0046s
2454geo: -- add_index(:group_wiki_repository_registry, :verification_state, {:name=>:group_wiki_repository_registry_needs_verification, :where=>"verification_state = ANY (ARRAY[0, 3])", :algorithm=>:concurrently})
2455geo: -> 0.0014s
2456geo: -- transaction_open?(nil)
2457geo: -> 0.0000s
2458geo: -- view_exists?(:postgres_partitions)
2459geo: -> 0.0009s
2460geo: -- index_exists?(:group_wiki_repository_registry, :verified_at, {:name=>:group_wiki_repository_registry_pending_verification, :order=>"NULLS FIRST", :where=>"verification_state = 0", :algorithm=>:concurrently})
2461geo: -> 0.0051s
2462geo: -- add_index(:group_wiki_repository_registry, :verified_at, {:name=>:group_wiki_repository_registry_pending_verification, :order=>"NULLS FIRST", :where=>"verification_state = 0", :algorithm=>:concurrently})
2463geo: -> 0.0016s
2464geo: == 20230717195815 CreateGroupWikiRepositoryRegistryVerificationIndexies: migrated (0.0304s)
2465geo: == 20230717200028 AddTextLimitToGroupWikiRepositoryRegistryVerificationFailure: migrating
2466geo: -- transaction_open?(nil)
2467geo: -> 0.0000s
2468geo: -- transaction_open?(nil)
2469geo: -> 0.0000s
2470geo: -- execute("ALTER TABLE group_wiki_repository_registry\nADD CONSTRAINT check_0a6e7bc04a\nCHECK ( char_length(verification_failure) <= 255 )\nNOT VALID;\n")
2471geo: -> 0.0010s
2472geo: -- execute("ALTER TABLE group_wiki_repository_registry VALIDATE CONSTRAINT check_0a6e7bc04a;")
2473geo: -> 0.0008s
2474geo: == 20230717200028 AddTextLimitToGroupWikiRepositoryRegistryVerificationFailure: migrated (0.0091s)
2475geo: == 20230808031211 ResyncDirectUploadJobArtifactRegistry: migrating ============
2476geo: -- Skipping because job artifacts are not stored in object storage with direct upload
2477geo: == 20230808031211 ResyncDirectUploadJobArtifactRegistry: migrated (0.0003s) ===
2478geo: == 20230918101143 DropDesignRegistry: migrating ===============================
2479geo: -- drop_table(:design_registry)
2480geo: -> 0.0014s
2481geo: == 20230918101143 DropDesignRegistry: migrated (0.0016s) ======================
2482geo: == 20231023230850 DropProjectRegistry: migrating ==============================
2483geo: -- drop_table(:project_registry)
2484geo: -> 0.0026s
2485geo: == 20231023230850 DropProjectRegistry: migrated (0.0029s) =====================
2486geo: == 20231205202917 RemoveGeoSecondaryDeprecatedWorkersJobInstances: migrating ==
2487geo: -- transaction_open?(nil)
2488geo: -> 0.0000s
2489geo: == 20231205202917 RemoveGeoSecondaryDeprecatedWorkersJobInstances: migrated (0.0010s)
2490geo: == 20240214235202 RemoveSnippetRepositoryRegistryForceToRedownloadColumn: migrating
2491geo: -- remove_column(:snippet_repository_registry, :force_to_redownload, {:if_exists=>true})
2492geo: -> 0.0037s
2493geo: == 20240214235202 RemoveSnippetRepositoryRegistryForceToRedownloadColumn: migrated (0.0040s)
2494geo: == 20240214235239 RemoveProjectWikiRepositoryRegistryForceToRedownloadColumn: migrating
2495geo: -- remove_column(:project_wiki_repository_registry, :force_to_redownload, {:if_exists=>true})
2496geo: -> 0.0035s
2497geo: == 20240214235239 RemoveProjectWikiRepositoryRegistryForceToRedownloadColumn: migrated (0.0038s)
2498geo: == 20240214235323 RemoveProjectRepositoryRegistryForceToRedownloadColumn: migrating
2499geo: -- remove_column(:project_repository_registry, :force_to_redownload, {:if_exists=>true})
2500geo: -> 0.0033s
2501geo: == 20240214235323 RemoveProjectRepositoryRegistryForceToRedownloadColumn: migrated (0.0036s)
2502geo: == 20240214235349 RemoveGroupWikiRepositoryRegistryForceToRedownloadColumn: migrating
2503geo: -- remove_column(:group_wiki_repository_registry, :force_to_redownload, {:if_exists=>true})
2504geo: -> 0.0033s
2505geo: == 20240214235349 RemoveGroupWikiRepositoryRegistryForceToRedownloadColumn: migrated (0.0036s)
2506geo: == 20240214235418 RemoveDesignManagementRepositoryRegistryForceToRedownloadColumn: migrating
2507geo: -- remove_column(:design_management_repository_registry, :force_to_redownload, {:if_exists=>true})
2508geo: -> 0.0033s
2509geo: == 20240214235418 RemoveDesignManagementRepositoryRegistryForceToRedownloadColumn: migrated (0.0036s)
2510geo: == [advisory_lock_connection] object_id: 113600, pg_backend_pid: 158
2511 Saving cache for successful job 00:00
2512Not uploading cache ruby-gems-debian-bookworm-ruby-3.1.5-17 due to policy
2513 Cleaning up project directory and file based variables 00:01
2514Job succeeded