diff options
author | Sami Hiltunen <shiltunen@gitlab.com> | 2022-04-13 12:41:00 +0300 |
---|---|---|
committer | Sami Hiltunen <shiltunen@gitlab.com> | 2022-04-13 12:41:00 +0300 |
commit | 9413ca591ebe30dcb133c86d0ec53f6bc2fc30bb (patch) | |
tree | b3cbb9214adbd7618ad44916fc004a70c1aaf280 /_support | |
parent | 93153d53f1c77a28ef76ae9c5777ed5477835962 (diff) | |
parent | 85ace7cf4f63ab8d99372c74f4e7bcb09a2ac219 (diff) |
Merge branch 'smh-background-verifier' into 'master'
Initial implementation of a metadata verifier
See merge request gitlab-org/gitaly!4459
Diffstat (limited to '_support')
-rw-r--r-- | _support/praefect-schema.sql | 11 |
1 files changed, 10 insertions, 1 deletions
diff --git a/_support/praefect-schema.sql b/_support/praefect-schema.sql index b69a2f0c6..78316e80c 100644 --- a/_support/praefect-schema.sql +++ b/_support/praefect-schema.sql @@ -266,7 +266,9 @@ CREATE TABLE public.storage_repositories ( relative_path text NOT NULL, storage text NOT NULL, generation bigint NOT NULL, - repository_id bigint NOT NULL + repository_id bigint NOT NULL, + verified_at timestamp with time zone, + verification_leased_until timestamp with time zone ); @@ -556,6 +558,13 @@ CREATE UNIQUE INDEX storage_repositories_new_pkey ON public.storage_repositories -- +-- Name: verification_queue; Type: INDEX; Schema: public; Owner: - +-- + +CREATE INDEX verification_queue ON public.storage_repositories USING btree (verified_at NULLS FIRST) WHERE (verification_leased_until IS NULL); + + +-- -- Name: virtual_target_on_replication_queue_idx; Type: INDEX; Schema: public; Owner: - -- |