Skip to content
Snippets Groups Projects

db:rollback geo

Passed Started by
Adam Hegyi
@ahegyi
1Running with gitlab-runner 15.6.0~beta.186.ga889181a (a889181a)
2 on blue-3.private.runners-manager.gitlab.com/gitlab.com/gitlab-org 6io2xoDD
3 feature flags: FF_USE_FASTZIP:true, FF_USE_IMPROVED_URL_MASKING:true
4 Resolving secrets 00:00
5 Preparing the "docker+machine" executor 00:08
6Using Docker executor with image registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bullseye-ruby-2.7.patched-golang-1.18-node-16.14-postgresql-12:rubygems-3.2-git-2.36-lfs-2.9-chrome-103-yarn-1.22-graphicsmagick-1.3.36 ...
7Starting service postgres:12 ...
8Pulling docker image postgres:12 ...
9Using docker image sha256:56e1d6dc77b242b5f4f91e7319f0740f7ab8bdf41023fd5d703f412ac87976f5 for postgres:12 with digest postgres@sha256:93fd73e2322241eec204dac54b316bf429670ff6e5292e16f9e2fd3a3374a713 ...
10Starting service redis:6.0-alpine ...
11Pulling docker image redis:6.0-alpine ...
12Using docker image sha256:83c577984741ab5b2e78640e0524852998d539ea3961e6d56680f336371f5c83 for redis:6.0-alpine with digest redis@sha256:459e91c5fe54134da1601ef85a4d9bc40c953862737fdfbe8f3c2b2a3eb6b20b ...
13Waiting for services to be up and running (timeout 30 seconds)...
14Authenticating with credentials from job payload (GitLab Registry)
15Pulling docker image registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bullseye-ruby-2.7.patched-golang-1.18-node-16.14-postgresql-12:rubygems-3.2-git-2.36-lfs-2.9-chrome-103-yarn-1.22-graphicsmagick-1.3.36 ...
16Using docker image sha256:5c5404ecc69273636c3ef49645be715ef30ea99e51ad146a2efbeac2a1875f9c for registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bullseye-ruby-2.7.patched-golang-1.18-node-16.14-postgresql-12:rubygems-3.2-git-2.36-lfs-2.9-chrome-103-yarn-1.22-graphicsmagick-1.3.36 with digest registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bullseye-ruby-2.7.patched-golang-1.18-node-16.14-postgresql-12@sha256:b032fe79dc0bf3ebfaeb610c82eacc500fbd0ec6e01889444011cf5a72b4135d ...
17 Preparing environment 00:00
18Running on runner-6io2xodd-project-278964-concurrent-0 via runner-6io2xodd-private-1667568258-0ea89a91...
19 Getting source from Git repository 00:22
20$ eval "$CI_PRE_CLONE_SCRIPT"
21Fetching changes with git depth set to 20...
22Initialized empty Git repository in /builds/gitlab-org/gitlab/.git/
23Created fresh repository.
24remote: Enumerating objects: 135178, done.
25remote: Counting objects: 100% (135178/135178), done.
26remote: Compressing objects: 100% (85462/85462), done.
27remote: Total 135178 (delta 62673), reused 94880 (delta 44892), pack-reused 0
28Receiving objects: 100% (135178/135178), 115.46 MiB | 33.57 MiB/s, done.
29Resolving deltas: 100% (62673/62673), done.
30From https://git-us-east1-c.ci-gateway.int.gprd.gitlab.net:8989/gitlab-org/gitlab
31 * [new ref] refs/pipelines/685831713 -> refs/pipelines/685831713
32 * [new branch] master -> origin/master
33Checking out 58c4ca27 as master...
34Skipping Git submodules setup
35$ git remote set-url origin "${CI_REPOSITORY_URL}"
36 Restoring cache 00:18
37Checking cache for ruby-gems-debian-bullseye-ruby-2.7-16...
38cache.zip is up to date
39Successfully extracted cache
40Checking cache for gitaly-ruby-gems-debian-bullseye-ruby-2.7-16...
41cache.zip is up to date
42Successfully extracted cache
43 Downloading artifacts 00:12
44Downloading artifacts for setup-test-env (3275962693)...
45Downloading artifacts from coordinator... ok id=3275962693 responseStatus=200 OK token=yFDvJsv-
46 Executing "step_script" stage of the job script 01:04
47Using docker image sha256:5c5404ecc69273636c3ef49645be715ef30ea99e51ad146a2efbeac2a1875f9c for registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bullseye-ruby-2.7.patched-golang-1.18-node-16.14-postgresql-12:rubygems-3.2-git-2.36-lfs-2.9-chrome-103-yarn-1.22-graphicsmagick-1.3.36 with digest registry.gitlab.com/gitlab-org/gitlab-build-images/debian-bullseye-ruby-2.7.patched-golang-1.18-node-16.14-postgresql-12@sha256:b032fe79dc0bf3ebfaeb610c82eacc500fbd0ec6e01889444011cf5a72b4135d ...
48$ echo $FOSS_ONLY
49$ [ "$FOSS_ONLY" = "1" ] && rm -rf ee/ qa/spec/ee/ qa/qa/specs/features/ee/ qa/qa/ee/ qa/qa/ee.rb
50$ export GOPATH=$CI_PROJECT_DIR/.go
51$ mkdir -p $GOPATH
52$ source scripts/utils.sh
53$ source scripts/prepare_build.sh
54 Installing gems 00:10
670Using decomposed database config (config/database.yml.decomposed-postgresql)
671$ setup_db_user_only
672CREATE ROLE
673GRANT
674==> 'setup_db_user_only' succeeded in 0 seconds.
675$ bundle exec rake db:drop db:create db:schema:load db:migrate
676Dropped database 'gitlabhq_test'
677Dropped database 'gitlabhq_test_ci'
678Dropped database 'gitlabhq_geo_test'
679Created database 'gitlabhq_test'
680Created database 'gitlabhq_test_ci'
681Created database 'gitlabhq_geo_test'
682==> 'bundle exec rake db:drop db:create db:schema:load db:migrate' succeeded in 30 seconds.
683$ setup_db_praefect
684SELECT pg_catalog.set_config('search_path', '', false);
685CREATE DATABASE praefect_test ENCODING 'UTF8';
686==> 'setup_db_praefect' succeeded in 0 seconds.
687$ bundle exec rake db:migrate:geo VERSION=20170627195211
688geo: == 20221017195204 CreateProjectWikiRepositoryRegistry: reverting ==============
689geo: -- drop_table(:project_wiki_repository_registry, {:id=>:bigserial, :force=>:cascade})
690geo: -> 0.0030s
691geo: == 20221017195204 CreateProjectWikiRepositoryRegistry: reverted (0.0061s) =====
692geo: == 20220617125507 CreateCiSecureFileRegistry: reverting =======================
693geo: -- drop_table(:ci_secure_file_registry)
694geo: -> 0.0021s
695geo: == 20220617125507 CreateCiSecureFileRegistry: reverted (0.0023s) ==============
696geo: == 20220202101354 MigrateJobArtifactRegistry: reverting =======================
697geo: == 20220202101354 MigrateJobArtifactRegistry: reverted (0.0000s) ==============
698geo: == 20211207175940 AddTextLimitToPagesDeploymentRegistryVerificationFailure: reverting
699geo: -- transaction_open?()
700geo: -> 0.0000s
701geo: -- transaction_open?()
702geo: -> 0.0000s
703geo: -- execute(" ALTER TABLE pages_deployment_registry\n DROP CONSTRAINT IF EXISTS check_7eb0430eff\n")
704geo: -> 0.0007s
705geo: == 20211207175940 AddTextLimitToPagesDeploymentRegistryVerificationFailure: reverted (0.0068s)
706geo: == 20211207162157 AddIndexesToPagesDeploymentRegistry: reverting ==============
707geo: -- transaction_open?()
708geo: -> 0.0000s
709geo: -- indexes(:pages_deployment_registry)
710geo: -> 0.0041s
711geo: -- remove_index(:pages_deployment_registry, {:algorithm=>:concurrently, :name=>"index_pages_deployment_registry_on_pages_deployment_id"})
712geo: -> 0.0008s
713geo: -- transaction_open?()
714geo: -> 0.0000s
715geo: -- indexes(:pages_deployment_registry)
716geo: -> 0.0027s
717geo: -- remove_index(:pages_deployment_registry, {:algorithm=>:concurrently, :name=>"pages_deployment_registry_failed_verification"})
718geo: -> 0.0008s
719geo: -- transaction_open?()
720geo: -> 0.0000s
721geo: -- indexes(:pages_deployment_registry)
722geo: -> 0.0023s
723geo: -- remove_index(:pages_deployment_registry, {:algorithm=>:concurrently, :name=>"pages_deployment_registry_needs_verification"})
724geo: -> 0.0008s
725geo: -- transaction_open?()
726geo: -> 0.0000s
727geo: -- indexes(:pages_deployment_registry)
728geo: -> 0.0020s
729geo: -- remove_index(:pages_deployment_registry, {:algorithm=>:concurrently, :name=>"pages_deployment_registry_pending_verification"})
730geo: -> 0.0008s
731geo: == 20211207162157 AddIndexesToPagesDeploymentRegistry: reverted (0.0193s) =====
732geo: == 20211126312431 AddTextLimitToFileRegistryVerificationFailure: reverting ====
733geo: -- transaction_open?()
734geo: -> 0.0000s
735geo: -- transaction_open?()
736geo: -> 0.0000s
737geo: -- execute(" ALTER TABLE file_registry\n DROP CONSTRAINT IF EXISTS check_1886652634\n")
738geo: -> 0.0006s
739geo: == 20211126312431 AddTextLimitToFileRegistryVerificationFailure: reverted (0.0027s)
740geo: == 20211124000002 AddIndexesToLfsObjectRegistry: reverting ====================
741geo: -- transaction_open?()
742geo: -> 0.0000s
743geo: -- indexes(:lfs_object_registry)
744geo: -> 0.0034s
745geo: -- remove_index(:lfs_object_registry, {:algorithm=>:concurrently, :name=>"index_lfs_object_registry_on_lfs_object_id"})
746geo: -> 0.0008s
747geo: -- transaction_open?()
748geo: -> 0.0000s
749geo: -- indexes(:lfs_object_registry)
750geo: -> 0.0030s
751geo: -- remove_index(:lfs_object_registry, {:algorithm=>:concurrently, :name=>"lfs_object_registry_failed_verification"})
752geo: -> 0.0009s
753geo: -- transaction_open?()
754geo: -> 0.0000s
755geo: -- indexes(:lfs_object_registry)
756geo: -> 0.0028s
757geo: -- remove_index(:lfs_object_registry, {:algorithm=>:concurrently, :name=>"lfs_object_registry_needs_verification"})
758geo: -> 0.0008s
759geo: -- transaction_open?()
760geo: -> 0.0000s
761geo: -- indexes(:lfs_object_registry)
762geo: -> 0.0024s
763geo: -- remove_index(:lfs_object_registry, {:algorithm=>:concurrently, :name=>"lfs_object_registry_pending_verification"})
764geo: -> 0.0009s
765geo: == 20211124000002 AddIndexesToLfsObjectRegistry: reverted (0.0202s) ===========
766geo: == 20211124000001 AddTextLimitToLfsObjectRegistryVerificationFailure: reverting
767geo: -- transaction_open?()
768geo: -> 0.0000s
769geo: -- transaction_open?()
770geo: -> 0.0000s
771geo: -- execute(" ALTER TABLE lfs_object_registry\n DROP CONSTRAINT IF EXISTS check_8bcaa12138\n")
772geo: -> 0.0006s
773geo: == 20211124000001 AddTextLimitToLfsObjectRegistryVerificationFailure: reverted (0.0029s)
774geo: == 20211124000000 AddVerificationToLfsObjectRegistry: reverting ===============
775geo: -- remove_column(:lfs_object_registry, :verification_failure, :text)
776geo: -> 0.0007s
777geo: -- remove_column(:lfs_object_registry, :verification_checksum_mismatched, :binary)
778geo: -> 0.0006s
779geo: -- remove_column(:lfs_object_registry, :verification_checksum, :binary)
780geo: -> 0.0006s
781geo: -- remove_column(:lfs_object_registry, :checksum_mismatch, :boolean, {:default=>false, :null=>false})
782geo: -> 0.0007s
783geo: -- remove_column(:lfs_object_registry, :verification_state, :integer, {:limit=>2, :default=>0, :null=>false})
784geo: -> 0.0007s
785geo: -- remove_column(:lfs_object_registry, :verification_retry_count, :integer, {:default=>0})
786geo: -> 0.0007s
787geo: -- remove_column(:lfs_object_registry, :verification_retry_at, :datetime_with_timezone)
788geo: -> 0.0006s
789geo: -- remove_column(:lfs_object_registry, :verified_at, :datetime_with_timezone)
790geo: -> 0.0006s
791geo: -- remove_column(:lfs_object_registry, :verification_started_at, :datetime_with_timezone)
792geo: -> 0.0006s
793geo: == 20211124000000 AddVerificationToLfsObjectRegistry: reverted (0.0066s) ======
794geo: == 20211119152539 AddVerificationToPagesDeploymentRegistry: reverting =========
795geo: -- remove_column(:pages_deployment_registry, :verification_failure, :text)
796geo: -> 0.0007s
797geo: -- remove_column(:pages_deployment_registry, :verification_checksum_mismatched, :binary)
798geo: -> 0.0006s
799geo: -- remove_column(:pages_deployment_registry, :verification_checksum, :binary)
800geo: -> 0.0006s
801geo: -- remove_column(:pages_deployment_registry, :checksum_mismatch, :boolean, {:default=>false, :null=>false})
802geo: -> 0.0007s
803geo: -- remove_column(:pages_deployment_registry, :verification_state, :integer, {:limit=>2, :default=>0, :null=>false})
804geo: -> 0.0007s
805geo: -- remove_column(:pages_deployment_registry, :verification_retry_count, :integer, {:default=>0, :limit=>2, :null=>false})
806geo: -> 0.0007s
807geo: -- remove_column(:pages_deployment_registry, :verification_retry_at, :datetime_with_timezone)
808geo: -> 0.0008s
809geo: -- remove_column(:pages_deployment_registry, :verified_at, :datetime_with_timezone)
810geo: -> 0.0007s
811geo: -- remove_column(:pages_deployment_registry, :verification_started_at, :datetime_with_timezone)
812geo: -> 0.0006s
813geo: == 20211119152539 AddVerificationToPagesDeploymentRegistry: reverted (0.0068s)
814geo: == 20211102121712 CreateFileRegistryVerificationIndexies: reverting ===========
815geo: -- transaction_open?()
816geo: -> 0.0000s
817geo: -- index_exists?(:file_registry, :verification_retry_at, {:name=>:file_registry_failed_verification, :algorithm=>:concurrently})
818geo: -> 0.0027s
819geo: -- remove_index(:file_registry, {:name=>:file_registry_failed_verification, :algorithm=>:concurrently, :column=>:verification_retry_at})
820geo: -> 0.0032s
821geo: -- transaction_open?()
822geo: -> 0.0000s
823geo: -- index_exists?(:file_registry, :verification_state, {:name=>:file_registry_needs_verification, :algorithm=>:concurrently})
824geo: -> 0.0020s
825geo: -- remove_index(:file_registry, {:name=>:file_registry_needs_verification, :algorithm=>:concurrently, :column=>:verification_state})
826geo: -> 0.0027s
827geo: -- transaction_open?()
828geo: -> 0.0000s
829geo: -- index_exists?(:file_registry, :verified_at, {:name=>:file_registry_pending_verification, :algorithm=>:concurrently})
830geo: -> 0.0017s
831geo: -- remove_index(:file_registry, {:name=>:file_registry_pending_verification, :algorithm=>:concurrently, :column=>:verified_at})
832geo: -> 0.0025s
833geo: == 20211102121712 CreateFileRegistryVerificationIndexies: reverted (0.0190s) ==
834geo: == 20211101113611 PrepareFileRegistryForVerification: reverting ===============
835geo: -- remove_column(:file_registry, :verified_at)
836geo: -> 0.0007s
837geo: -- remove_column(:file_registry, :verification_started_at)
838geo: -> 0.0006s
839geo: -- remove_column(:file_registry, :verification_retry_at)
840geo: -> 0.0006s
841geo: -- remove_column(:file_registry, :verification_state)
842geo: -> 0.0007s
843geo: -- remove_column(:file_registry, :verification_retry_count)
844geo: -> 0.0006s
845geo: -- remove_column(:file_registry, :verification_checksum)
846geo: -> 0.0006s
847geo: -- remove_column(:file_registry, :verification_checksum_mismatched)
848geo: -> 0.0006s
849geo: -- remove_column(:file_registry, :checksum_mismatch)
850geo: -> 0.0006s
851geo: -- remove_column(:file_registry, :verification_failure)
852geo: -> 0.0006s
853geo: == 20211101113611 PrepareFileRegistryForVerification: reverted (0.0061s) ======
854geo: == 20211021112221 RemoveUploadLegacyFields: reverting =========================
855geo: -- add_column(:file_registry, :sha256, :string)
856geo: -> 0.0012s
857geo: -- add_column(:file_registry, :bytes, :integer)
858geo: -> 0.0006s
859geo: -- add_column(:file_registry, :success, :boolean, {:null=>false})
860geo: -> 0.0007s
861geo: -- add_column(:file_registry, :file_type, :string, {:null=>false})
862geo: -> 0.0007s
863geo: == 20211021112221 RemoveUploadLegacyFields: reverted (0.0038s) ================
864== 20210820152707 CreatePagesDeploymentRegistry: reverting ====================
865-- drop_table(:pages_deployment_registry, {:id=>:bigserial, :force=>:cascade})
866 -> 0.0015s
867== 20210820152707 CreatePagesDeploymentRegistry: reverted (0.0016s) ===========
868== 20210818111211 FixStateColumnInFileRegistry: reverting =====================
869== 20210818111211 FixStateColumnInFileRegistry: reverted (0.0000s) ============
870== 20210706120644 PrepareFileRegistryForSsf: reverting ========================
871-- remove_column(:file_registry, :last_sync_failure, :string, {:limit=>255})
872 -> 0.0011s
873-- remove_column(:file_registry, :last_synced_at, :datetime_with_timezone)
874 -> 0.0006s
875-- remove_column(:file_registry, :state, :integer, {:null=>false, :limit=>2, :default=>0})
876 -> 0.0008s
877-- change_column_default(:file_registry, :retry_count, {:from=>0, :to=>nil})
878 -> 0.0027s
879== 20210706120644 PrepareFileRegistryForSsf: reverted (0.0057s) ===============
880== 20210624160455 FixStateColumnInLfsObjectRegistry: reverting ================
881== 20210624160455 FixStateColumnInLfsObjectRegistry: reverted (0.0000s) =======
882== 20210505170208 AddIndexesToMergeRequestDiffRegistryTable: reverting ========
883-- transaction_open?()
884 -> 0.0000s
885-- indexes(:merge_request_diff_registry)
886 -> 0.0032s
887-- remove_index(:merge_request_diff_registry, {:algorithm=>:concurrently, :name=>"index_merge_request_diff_registry_on_mr_diff_id"})
888 -> 0.0010s
889-- transaction_open?()
890 -> 0.0000s
891-- view_exists?(:postgres_partitions)
892 -> 0.0007s
893-- index_exists?(:merge_request_diff_registry, :merge_request_diff_id, {:name=>"index_merge_request_diff_registry_on_mr_diff_id", :algorithm=>:concurrently})
894 -> 0.0029s
895-- add_index(:merge_request_diff_registry, :merge_request_diff_id, {:name=>"index_merge_request_diff_registry_on_mr_diff_id", :algorithm=>:concurrently})
896 -> 0.0013s
897-- transaction_open?()
898 -> 0.0000s
899-- indexes(:merge_request_diff_registry)
900 -> 0.0031s
901-- remove_index(:merge_request_diff_registry, {:algorithm=>:concurrently, :name=>"merge_request_diff_registry_failed_verification"})
902 -> 0.0009s
903-- transaction_open?()
904 -> 0.0000s
905-- indexes(:merge_request_diff_registry)
906 -> 0.0027s
907-- remove_index(:merge_request_diff_registry, {:algorithm=>:concurrently, :name=>"merge_request_diff_registry_needs_verification"})
908 -> 0.0009s
909-- transaction_open?()
910 -> 0.0000s
911-- indexes(:merge_request_diff_registry)
912 -> 0.0025s
913-- remove_index(:merge_request_diff_registry, {:algorithm=>:concurrently, :name=>"merge_request_diff_registry_pending_verification"})
914 -> 0.0010s
915== 20210505170208 AddIndexesToMergeRequestDiffRegistryTable: reverted (0.0280s)
916== 20210504143244 AddVerificationToMergeRequestDiffRegistry: reverting ========
917== 20210504143244 AddVerificationToMergeRequestDiffRegistry: reverted (0.0000s)
918== 20210420180119 AddIndexesToTerraformStateVersionRegistry: reverting ========
919-- transaction_open?()
920 -> 0.0000s
921-- indexes(:terraform_state_version_registry)
922 -> 0.0037s
923-- remove_index(:terraform_state_version_registry, {:algorithm=>:concurrently, :name=>"index_terraform_state_version_registry_on_t_state_version_id"})
924 -> 0.0009s
925-- transaction_open?()
926 -> 0.0000s
927-- indexes(:terraform_state_version_registry)
928 -> 0.0031s
929-- remove_index(:terraform_state_version_registry, {:algorithm=>:concurrently, :name=>:index_terraform_state_version_registry_on_retry_at})
930 -> 0.0010s
931-- transaction_open?()
932 -> 0.0000s
933-- indexes(:terraform_state_version_registry)
934 -> 0.0028s
935-- remove_index(:terraform_state_version_registry, {:algorithm=>:concurrently, :name=>:index_terraform_state_version_registry_on_state})
936 -> 0.0009s
937-- transaction_open?()
938 -> 0.0000s
939-- indexes(:terraform_state_version_registry)
940 -> 0.0024s
941-- remove_index(:terraform_state_version_registry, {:algorithm=>:concurrently, :name=>"terraform_state_version_registry_failed_verification"})
942 -> 0.0008s
943-- transaction_open?()
944 -> 0.0000s
945-- indexes(:terraform_state_version_registry)
946 -> 0.0021s
947-- remove_index(:terraform_state_version_registry, {:algorithm=>:concurrently, :name=>"terraform_state_version_registry_needs_verification"})
948 -> 0.0008s
949-- transaction_open?()
950 -> 0.0000s
951-- indexes(:terraform_state_version_registry)
952 -> 0.0017s
953-- remove_index(:terraform_state_version_registry, {:algorithm=>:concurrently, :name=>"terraform_state_version_registry_pending_verification"})
954 -> 0.0008s
955== 20210420180119 AddIndexesToTerraformStateVersionRegistry: reverted (0.0310s)
956== 20210407140527 AddVerificationToTerraformStateVersionRegistry: reverting ===
957-- remove_column(:terraform_state_version_registry, :verification_failure, :string, {:limit=>255})
958 -> 0.0013s
959-- remove_column(:terraform_state_version_registry, :verification_checksum_mismatched, :binary)
960 -> 0.0006s
961-- remove_column(:terraform_state_version_registry, :verification_checksum, :binary)
962 -> 0.0006s
963-- remove_column(:terraform_state_version_registry, :checksum_mismatch, :boolean, {:default=>false, :null=>false})
964 -> 0.0007s
965-- remove_column(:terraform_state_version_registry, :verification_state, :integer, {:limit=>2, :default=>0, :null=>false})
966 -> 0.0007s
967-- remove_column(:terraform_state_version_registry, :verification_retry_count, :integer, {:default=>0})
968 -> 0.0007s
969-- remove_column(:terraform_state_version_registry, :verification_retry_at, :datetime_with_timezone)
970 -> 0.0006s
971-- remove_column(:terraform_state_version_registry, :verified_at, :datetime_with_timezone)
972 -> 0.0006s
973-- remove_column(:terraform_state_version_registry, :verification_started_at, :datetime_with_timezone)
974 -> 0.0006s
975== 20210407140527 AddVerificationToTerraformStateVersionRegistry: reverted (0.0072s)
976== 20210325150435 CreatePipelineArtifactRegistry: reverting ===================
977-- drop_table(:pipeline_artifact_registry)
978 -> 0.0019s
979== 20210325150435 CreatePipelineArtifactRegistry: reverted (0.0020s) ==========
980== 20210313051642 AddVerificationIndexesToSnippetRepositoryRegistry: reverting
981-- transaction_open?()
982 -> 0.0000s
983-- indexes(:snippet_repository_registry)
984 -> 0.0031s
985-- remove_index(:snippet_repository_registry, {:algorithm=>:concurrently, :name=>"snippet_repository_registry_pending_verification"})
986 -> 0.0009s
987-- transaction_open?()
988 -> 0.0000s
989-- indexes(:snippet_repository_registry)
990 -> 0.0027s
991-- remove_index(:snippet_repository_registry, {:algorithm=>:concurrently, :name=>"snippet_repository_registry_failed_verification"})
992 -> 0.0010s
993-- transaction_open?()
994 -> 0.0000s
995-- indexes(:snippet_repository_registry)
996 -> 0.0023s
997-- remove_index(:snippet_repository_registry, {:algorithm=>:concurrently, :name=>"snippet_repository_registry_needs_verification"})
998 -> 0.0008s
999== 20210313051642 AddVerificationIndexesToSnippetRepositoryRegistry: reverted (0.0149s)
1000== 20210313050709 AddVerificationToSnippetRepositoryRegistry: reverting =======
1001-- remove_column(:snippet_repository_registry, :verification_failure, :string, {:limit=>255})
1002 -> 0.0012s
1003-- remove_column(:snippet_repository_registry, :verification_checksum_mismatched, :binary)
1004 -> 0.0006s
1005-- remove_column(:snippet_repository_registry, :verification_checksum, :binary)
1006 -> 0.0006s
1007-- remove_column(:snippet_repository_registry, :checksum_mismatch, :boolean)
1008 -> 0.0006s
1009-- remove_column(:snippet_repository_registry, :verification_state, :integer, {:limit=>2, :default=>0, :null=>false})
1010 -> 0.0008s
1011-- remove_column(:snippet_repository_registry, :verification_retry_count, :integer)
1012 -> 0.0006s
1013-- remove_column(:snippet_repository_registry, :verification_retry_at, :datetime_with_timezone)
1014 -> 0.0007s
1015-- remove_column(:snippet_repository_registry, :verified_at, :datetime_with_timezone)
1016 -> 0.0006s
1017-- remove_column(:snippet_repository_registry, :verification_started_at, :datetime_with_timezone)
1018 -> 0.0006s
1019== 20210313050709 AddVerificationToSnippetRepositoryRegistry: reverted (0.0071s)
1020== 20210225200858 AddTextLimitToLfsObjectRegistryLastSyncFailure: reverting ===
1021-- transaction_open?()
1022 -> 0.0000s
1023-- execute(" ALTER TABLE lfs_object_registry\n DROP CONSTRAINT IF EXISTS check_c41d57c1dc\n")
1024 -> 0.0006s
1025== 20210225200858 AddTextLimitToLfsObjectRegistryLastSyncFailure: reverted (0.0028s)
1026== 20210223111722 CreateGroupWikiRepositoryRegistry: reverting ================
1027-- drop_table(:group_wiki_repository_registry)
1028 -> 0.0018s
1029== 20210223111722 CreateGroupWikiRepositoryRegistry: reverted (0.0018s) =======
1030== 20210217020156 AddUniqueIndexOnTerraformStateVersionRegistry: reverting ====
1031-- transaction_open?()
1032 -> 0.0000s
1033-- view_exists?(:postgres_partitions)
1034 -> 0.0006s
1035-- index_exists?(:terraform_state_version_registry, :terraform_state_version_id, {:name=>"index_tf_state_versions_registry_on_tf_state_versions_id", :algorithm=>:concurrently})
1036 -> 0.0014s
1037-- add_index(:terraform_state_version_registry, :terraform_state_version_id, {:name=>"index_tf_state_versions_registry_on_tf_state_versions_id", :algorithm=>:concurrently})
1038 -> 0.0011s
1039-- transaction_open?()
1040 -> 0.0000s
1041-- indexes(:terraform_state_version_registry)
1042 -> 0.0016s
1043-- remove_index(:terraform_state_version_registry, {:algorithm=>:concurrently, :name=>"index_tf_state_versions_registry_tf_state_versions_id_unique"})
1044 -> 0.0009s
1045== 20210217020156 AddUniqueIndexOnTerraformStateVersionRegistry: reverted (0.0091s)
1046== 20210217020154 AddUniqueIndexOnContainerRepositoryRegistry: reverting ======
1047-- transaction_open?()
1048 -> 0.0000s
1049-- view_exists?(:postgres_partitions)
1050 -> 0.0005s
1051-- index_exists?(:container_repository_registry, :container_repository_id, {:name=>"index_container_repository_registry_on_repository_id", :algorithm=>:concurrently})
1052 -> 0.0021s
1053-- add_index(:container_repository_registry, :container_repository_id, {:name=>"index_container_repository_registry_on_repository_id", :algorithm=>:concurrently})
1054 -> 0.0010s
1055-- transaction_open?()
1056 -> 0.0000s
1057-- indexes(:container_repository_registry)
1058 -> 0.0023s
1059-- remove_index(:container_repository_registry, {:algorithm=>:concurrently, :name=>"index_container_repository_registry_repository_id_unique"})
1060 -> 0.0008s
1061== 20210217020154 AddUniqueIndexOnContainerRepositoryRegistry: reverted (0.0101s)
1062== 20210208175408 CreateGeoSecondaryUsageData: reverting ======================
1063-- drop_table(:secondary_usage_data, {})
1064 -> 0.0016s
1065== 20210208175408 CreateGeoSecondaryUsageData: reverted (0.0017s) =============
1066== 20210125222907 AddLfsObjectStateIndex: reverting ===========================
1067-- transaction_open?()
1068 -> 0.0000s
1069-- index_exists?(:lfs_object_registry, :state, {:name=>"index_state_in_lfs_objects", :algorithm=>:concurrently})
1070 -> 0.0020s
1071-- remove_index(:lfs_object_registry, {:name=>"index_state_in_lfs_objects", :algorithm=>:concurrently, :column=>:state})
1072 -> 0.0028s
1073== 20210125222907 AddLfsObjectStateIndex: reverted (0.0062s) ==================
1074== 20210120225014 MigrateLfsObjectRegistry: reverting =========================
1075-- change_column_default(:lfs_object_registry, :retry_count, {:from=>0, :to=>nil})
1076 -> 0.0025s
1077-- remove_column(:lfs_object_registry, :state)
1078 -> 0.0007s
1079-- remove_column(:lfs_object_registry, :last_synced_at)
1080 -> 0.0007s
1081-- remove_column(:lfs_object_registry, :last_sync_failure)
1082 -> 0.0006s
1083== 20210120225014 MigrateLfsObjectRegistry: reverted (0.0047s) ================
1084== 20210111912220 PrepareJobArtifactRegistryForSsfIndecies: reverting =========
1085-- transaction_open?()
1086 -> 0.0000s
1087-- index_exists?(:job_artifact_registry, :verification_retry_at, {:name=>:job_artifact_registry_failed_verification, :algorithm=>:concurrently})
1088 -> 0.0032s
1089-- remove_index(:job_artifact_registry, {:name=>:job_artifact_registry_failed_verification, :algorithm=>:concurrently, :column=>:verification_retry_at})
1090 -> 0.0038s
1091-- transaction_open?()
1092 -> 0.0000s
1093-- index_exists?(:job_artifact_registry, :verification_state, {:name=>:job_artifact_registry_needs_verification, :algorithm=>:concurrently})
1094 -> 0.0026s
1095-- remove_index(:job_artifact_registry, {:name=>:job_artifact_registry_needs_verification, :algorithm=>:concurrently, :column=>:verification_state})
1096 -> 0.0034s
1097-- transaction_open?()
1098 -> 0.0000s
1099-- index_exists?(:job_artifact_registry, :verified_at, {:name=>:job_artifact_registry_pending_verification, :algorithm=>:concurrently})
1100 -> 0.0023s
1101-- remove_index(:job_artifact_registry, {:name=>:job_artifact_registry_pending_verification, :algorithm=>:concurrently, :column=>:verified_at})
1102 -> 0.0031s
1103== 20210111912220 PrepareJobArtifactRegistryForSsfIndecies: reverted (0.0225s)
1104== 20210111911002 PrepareJobArtifactRegistryForSsf: reverting =================
1105-- remove_column(:job_artifact_registry, :last_sync_failure, :string, {:limit=>255})
1106 -> 0.0012s
1107-- remove_column(:job_artifact_registry, :verification_failure, :string, {:limit=>255})
1108 -> 0.0007s
1109-- remove_column(:job_artifact_registry, :checksum_mismatch, :boolean, {:default=>false, :null=>false})
1110 -> 0.0007s
1111-- remove_column(:job_artifact_registry, :verification_checksum_mismatched, :binary)
1112 -> 0.0007s
1113-- remove_column(:job_artifact_registry, :verification_checksum, :binary)
1114 -> 0.0006s
1115-- remove_column(:job_artifact_registry, :verification_retry_count, :integer, {:default=>0, :limit=>2, :null=>false})
1116 -> 0.0007s
1117-- remove_column(:job_artifact_registry, :verification_state, :integer, {:default=>0, :null=>false, :limit=>2})
1118 -> 0.0007s
1119-- remove_column(:job_artifact_registry, :state, :integer, {:null=>false, :limit=>2, :default=>0})
1120 -> 0.0007s
1121-- remove_column(:job_artifact_registry, :verification_retry_at, :datetime_with_timezone)
1122 -> 0.0006s
1123-- remove_column(:job_artifact_registry, :verification_started_at, :datetime_with_timezone)
1124 -> 0.0006s
1125-- remove_column(:job_artifact_registry, :verified_at, :datetime_with_timezone)
1126 -> 0.0006s
1127-- remove_column(:job_artifact_registry, :last_synced_at, :datetime_with_timezone)
1128 -> 0.0006s
1129-- change_column_default(:job_artifact_registry, :retry_count, {:from=>0, :to=>nil})
1130 -> 0.0020s
1131== 20210111911002 PrepareJobArtifactRegistryForSsf: reverted (0.0113s) ========
1132== 20201208031224 AddVerificationIndexesToPackageFileRegistry: reverting ======
1133-- transaction_open?()
1134 -> 0.0000s
1135-- indexes(:package_file_registry)
1136 -> 0.0033s
1137-- remove_index(:package_file_registry, {:algorithm=>:concurrently, :name=>"package_file_registry_pending_verification"})
1138 -> 0.0009s
1139-- transaction_open?()
1140 -> 0.0000s
1141-- indexes(:package_file_registry)
1142 -> 0.0026s
1143-- remove_index(:package_file_registry, {:algorithm=>:concurrently, :name=>"package_file_registry_failed_verification"})
1144 -> 0.0009s
1145-- transaction_open?()
1146 -> 0.0000s
1147-- indexes(:package_file_registry)
1148 -> 0.0023s
1149-- remove_index(:package_file_registry, {:algorithm=>:concurrently, :name=>"package_file_registry_needs_verification"})
1150 -> 0.0008s
1151== 20201208031224 AddVerificationIndexesToPackageFileRegistry: reverted (0.0147s)
1152== 20201208025254 AddVerificationFieldsToPackageFileRegistry: reverting =======
1153-- remove_column(:package_file_registry, :verification_started_at, :datetime_with_timezone)
1154 -> 0.0012s
1155-- remove_column(:package_file_registry, :verification_state, :integer, {:default=>0, :limit=>2, :null=>false})
1156 -> 0.0007s
1157== 20201208025254 AddVerificationFieldsToPackageFileRegistry: reverted (0.0020s)
1158== 20200924184638 RemoveNonVersionedTerraformStateRegistry: reverting =========
1159-- table_exists?(:terraform_state_registry)
1160 -> 0.0006s
1161-- create_table(:terraform_state_registry, {:id=>:bigserial, :force=>:cascade})
1162 -> 0.0054s
1163-- transaction_open?()
1164 -> 0.0000s
1165-- current_schema()
1166 -> 0.0004s
1167-- execute("ALTER TABLE terraform_state_registry\nADD CONSTRAINT check_70a3f43f16\nCHECK ( char_length(last_sync_failure) <= 255 )\nNOT VALID;\n")
1168 -> 0.0007s
1169-- current_schema()
1170 -> 0.0003s
1171-- execute("ALTER TABLE terraform_state_registry VALIDATE CONSTRAINT check_70a3f43f16;")
1172 -> 0.0006s
1173== 20200924184638 RemoveNonVersionedTerraformStateRegistry: reverted (0.0135s)
1174== 20200915152620 CreateTerraformStateVersionRegistry: reverting ==============
1175-- drop_table(:terraform_state_version_registry)
1176 -> 0.0014s
1177== 20200915152620 CreateTerraformStateVersionRegistry: reverted (0.0014s) =====
1178== 20200827120552 CreateMergeRequestDiffRegistry: reverting ===================
1179-- drop_table(:merge_request_diff_registry)
1180 -> 0.0014s
1181== 20200827120552 CreateMergeRequestDiffRegistry: reverted (0.0015s) ==========
1182== 20200811171011 CreateSnippetRepositoryRegistry: reverting ==================
1183-- drop_table(:snippet_repository_registry)
1184 -> 0.0014s
1185== 20200811171011 CreateSnippetRepositoryRegistry: reverted (0.0014s) =========
1186== 20200730133800 RemoveTableVulnerabilityExportRegistry: reverting ===========
1187== 20200730133800 RemoveTableVulnerabilityExportRegistry: reverted (0.0000s) ==
1188== 20200710194046 CreateVulnerabilityExportRegistry: reverting ================
1189-- table_exists?(:vulnerability_export_registry)
1190 -> 0.0006s
1191== 20200710194046 CreateVulnerabilityExportRegistry: reverted (0.0007s) =======
1192== 20200707210300 CreateTerraformStateRegistry: reverting =====================
1193-- drop_table(:terraform_state_registry)
1194 -> 0.0015s
1195== 20200707210300 CreateTerraformStateRegistry: reverted (0.0015s) ============
1196== 20200707011052 AddVerifiedOnPrimaryColumnsToProjectRegistry: reverting =====
1197-- remove_column(:project_registry, :primary_wiki_checksummed, :boolean, {:default=>false, :null=>false})
1198 -> 0.0012s
1199-- remove_column(:project_registry, :primary_repository_checksummed, :boolean, {:default=>false, :null=>false})
1200 -> 0.0007s
1201== 20200707011052 AddVerifiedOnPrimaryColumnsToProjectRegistry: reverted (0.0022s)
1202== 20200407120740 AddVerificationFieldsToPackageFileOnSecondary: reverting ====
1203-- remove_column(:package_file_registry, :verification_retry_at, :datetime_with_timezone)
1204 -> 0.0006s
1205-- remove_column(:package_file_registry, :verified_at, :datetime_with_timezone)
1206 -> 0.0006s
1207-- remove_column(:package_file_registry, :verification_retry_count, :integer)
1208 -> 0.0006s
1209-- remove_column(:package_file_registry, :verification_checksum_mismatched, :binary)
1210 -> 0.0006s
1211-- remove_column(:package_file_registry, :checksum_mismatch, :boolean)
1212 -> 0.0006s
1213-- remove_column(:package_file_registry, :verification_checksum, :binary)
1214 -> 0.0005s
1215-- remove_column(:package_file_registry, :verification_failure, :string, {:limit=>255})
1216 -> 0.0006s
1217== 20200407120740 AddVerificationFieldsToPackageFileOnSecondary: reverted (0.0045s)
1218== 20200121194300 CreatePackageFileRegistry: reverting ========================
1219-- drop_table(:package_file_registry, {:id=>:serial, :force=>:cascade})
1220 -> 0.0016s
1221== 20200121194300 CreatePackageFileRegistry: reverted (0.0017s) ===============
1222== 20191025194337 DeleteLfsObjectsFromFileRegistry: reverting =================
1223== 20191025194337 DeleteLfsObjectsFromFileRegistry: reverted (0.0000s) ========
1224== 20191010204941 MigrateLfsObjectsToSeparateRegistry: reverting ==============
1225-- execute("DELETE FROM lfs_object_registry WHERE ID IN (SELECT file_id FROM file_registry WHERE file_type = 'lfs')")
1226 -> 0.0020s
1227-- execute("DROP TRIGGER IF EXISTS replicate_lfs_object_registry ON file_registry")
1228 -> 0.0008s
1229-- execute("DROP FUNCTION IF EXISTS replicate_lfs_object_registry()")
1230 -> 0.0005s
1231== 20191010204941 MigrateLfsObjectsToSeparateRegistry: reverted (0.0034s) =====
1232== 20191010203257 CreateLfsObjectRegistry: reverting ==========================
1233-- drop_table(:lfs_object_registry, {:force=>:cascade})
1234 -> 0.0016s
1235== 20191010203257 CreateLfsObjectRegistry: reverted (0.0018s) =================
1236== 20191007122326 AddUniqueConstraintOnDesignRegistryProjectId: reverting =====
1237-- remove_index(:design_registry, :project_id, {:name=>"index_design_registry_on_project_id", :unique=>true})
1238 -> 0.0031s
1239-- add_index(:design_registry, :project_id, {:name=>"index_design_registry_on_project_id"})
1240 -> 0.0009s
1241== 20191007122326 AddUniqueConstraintOnDesignRegistryProjectId: reverted (0.0043s)
1242== 20190923111102 AddDesignRegistry: reverting ================================
1243-- drop_table(:design_registry, {:id=>:serial, :force=>:cascade})
1244 -> 0.0016s
1245== 20190923111102 AddDesignRegistry: reverted (0.0018s) =======================
1246== 20190802200655 AddCreatedAtToEventLogStates: reverting =====================
1247-- remove_column(:event_log_states, :created_at)
1248 -> 0.0012s
1249== 20190802200655 AddCreatedAtToEventLogStates: reverted (0.0013s) ============
1250== 20190612211021 AddContainerRepositoryRegistry: reverting ===================
1251-- drop_table(:container_repository_registry, {:id=>:serial, :force=>:cascade})
1252 -> 0.0015s
1253== 20190612211021 AddContainerRepositoryRegistry: reverted (0.0017s) ==========
1254== 20190314201959 AddChecksumMismatchedColumndsToProjectRegistry: reverting ===
1255-- remove_column(:project_registry, :wiki_verification_checksum_mismatched, :binary, {})
1256 -> 0.0012s
1257-- remove_column(:project_registry, :repository_verification_checksum_mismatched, :binary, {})
1258 -> 0.0006s
1259== 20190314201959 AddChecksumMismatchedColumndsToProjectRegistry: reverted (0.0020s)
1260== 20181213184140 AddLastVerificationColumnsToProjectRegistry: reverting ======
1261-- remove_column(:project_registry, :last_wiki_verification_ran_at, :datetime_with_timezone, {})
1262 -> 0.0012s
1263-- remove_column(:project_registry, :last_repository_verification_ran_at, :datetime_with_timezone, {})
1264 -> 0.0006s
1265== 20181213184140 AddLastVerificationColumnsToProjectRegistry: reverted (0.0020s)
1266== 20180806020615 AddPendingSynchronizationsPartialIndex: reverting ===========
1267-- transaction_open?()
1268 -> 0.0000s
1269-- indexes(:project_registry)
1270 -> 0.0072s
1271-- remove_index(:project_registry, nil, {:algorithm=>:concurrently, :name=>"idx_project_registry_pending_repositories_partial"})
1272 -> 0.0011s
1273== 20180806020615 AddPendingSynchronizationsPartialIndex: reverted (0.0106s) ==
1274== 20180806011909 AddFailedSynchronizationsPartialIndex: reverting ============
1275-- transaction_open?()
1276 -> 0.0000s
1277-- indexes(:project_registry)
1278 -> 0.0064s
1279-- remove_index(:project_registry, nil, {:algorithm=>:concurrently, :name=>"idx_project_registry_failed_repositories_partial"})
1280 -> 0.0008s
1281== 20180806011909 AddFailedSynchronizationsPartialIndex: reverted (0.0092s) ===
1282== 20180803160048 AddSyncedRepositoriesPartialIndex: reverting ================
1283-- transaction_open?()
1284 -> 0.0000s
1285-- indexes(:project_registry)
1286 -> 0.0062s
1287-- remove_index(:project_registry, nil, {:algorithm=>:concurrently, :name=>"idx_project_registry_synced_repositories_partial"})
1288 -> 0.0009s
1289== 20180803160048 AddSyncedRepositoriesPartialIndex: reverted (0.0093s) =======
1290== 20180802215313 AddRetryVerificationFieldsToProjectRegistry: reverting ======
1291-- remove_column(:project_registry, :wiki_verification_retry_count, :integer, {})
1292 -> 0.0011s
1293-- remove_column(:project_registry, :repository_verification_retry_count, :integer, {})
1294 -> 0.0006s
1295== 20180802215313 AddRetryVerificationFieldsToProjectRegistry: reverted (0.0019s)
1296== 20180727221937 AddMissingOnPrimaryToProjectRegistry: reverting =============
1297-- remove_column(:project_registry, :wiki_missing_on_primary, :boolean, {})
1298 -> 0.0011s
1299-- remove_column(:project_registry, :repository_missing_on_primary, :boolean, {})
1300 -> 0.0006s
1301== 20180727221937 AddMissingOnPrimaryToProjectRegistry: reverted (0.0020s) ====
1302== 20180613184349 AddResyncWasScheduledAtToProjectRegistry: reverting =========
1303-- remove_column(:project_registry, :resync_wiki_was_scheduled_at, :datetime_with_timezone, {})
1304 -> 0.0011s
1305-- remove_column(:project_registry, :resync_repository_was_scheduled_at, :datetime_with_timezone, {})
1306 -> 0.0007s
1307== 20180613184349 AddResyncWasScheduledAtToProjectRegistry: reverted (0.0021s)
1308== 20180510223634 SetResyncFlagForRetriedProjects: reverting ==================
1309== 20180510223634 SetResyncFlagForRetriedProjects: reverted (0.0000s) =========
1310== 20180427114641 AddRepositoryCheckToGeoProjectRegistry: reverting ===========
1311-- remove_column(:project_registry, :last_repository_check_at, :datetime_with_timezone, {})
1312 -> 0.0012s
1313-- remove_column(:project_registry, :last_repository_check_failed, :boolean, {})
1314 -> 0.0006s
1315== 20180427114641 AddRepositoryCheckToGeoProjectRegistry: reverted (0.0021s) ==
1316== 20180419192603 AddIndexesToChecksumMismatchFieldsOnProjectRegistry: reverting
1317-- transaction_open?()
1318 -> 0.0001s
1319-- indexes(:project_registry)
1320 -> 0.0059s
1321-- remove_index(:project_registry, nil, {:algorithm=>:concurrently, :name=>"idx_repository_checksum_mismatch"})
1322 -> 0.0010s
1323-- transaction_open?()
1324 -> 0.0000s
1325-- indexes(:project_registry)
1326 -> 0.0056s
1327-- remove_index(:project_registry, nil, {:algorithm=>:concurrently, :name=>"idx_wiki_checksum_mismatch"})
1328 -> 0.0009s
1329== 20180419192603 AddIndexesToChecksumMismatchFieldsOnProjectRegistry: reverted (0.0178s)
1330== 20180419174834 AddChecksumMismatchFieldsToProjectRegistry: reverting =======
1331-- remove_column(:project_registry, :wiki_checksum_mismatch, :boolean, {:null=>false, :default=>false})
1332 -> 0.0013s
1333-- remove_column(:project_registry, :repository_checksum_mismatch, :boolean, {:null=>false, :default=>false})
1334 -> 0.0007s
1335== 20180419174834 AddChecksumMismatchFieldsToProjectRegistry: reverted (0.0023s)
1336== 20180412213305 AddIndexToArtifactIdOnJobArtifactRegistry: reverting ========
1337-- index_exists?(:job_artifact_registry, :artifact_id, {:name=>"index_job_artifact_registry_on_artifact_id"})
1338 -> 0.0022s
1339-- transaction_open?()
1340 -> 0.0000s
1341-- index_exists?(:job_artifact_registry_finder, :artifact_id, {:algorithm=>:concurrently, :name=>"index_job_artifact_registry_finder_on_artifact_id"})
1342 -> 0.0009s
1343== 20180412213305 AddIndexToArtifactIdOnJobArtifactRegistry: reverted (0.0038s)
1344== 20180405074130 AddPartialIndexProjectRepositoryVerification: reverting =====
1345-- transaction_open?()
1346 -> 0.0000s
1347-- indexes(:project_registry)
1348 -> 0.0051s
1349-- remove_index(:project_registry, nil, {:algorithm=>:concurrently, :name=>"idx_project_registry_on_repo_checksums_and_failure_partial"})
1350 -> 0.0009s
1351-- transaction_open?()
1352 -> 0.0000s
1353-- indexes(:project_registry)
1354 -> 0.0050s
1355-- remove_index(:project_registry, nil, {:algorithm=>:concurrently, :name=>"idx_project_registry_on_wiki_checksums_and_failure_partial"})
1356 -> 0.0009s
1357== 20180405074130 AddPartialIndexProjectRepositoryVerification: reverted (0.0161s)
1358== 20180402170913 AddMissingOnPrimaryToJobArtifactRegistry: reverting =========
1359-- column_exists?(:job_artifact_registry, :missing_on_primary)
1360 -> 0.0014s
1361-- remove_column(:job_artifact_registry, :missing_on_primary)
1362 -> 0.0007s
1363== 20180402170913 AddMissingOnPrimaryToJobArtifactRegistry: reverted (0.0022s)
1364== 20180331055706 DeleteJobArtifactsFromFileRegistry: reverting ===============
1365== 20180331055706 DeleteJobArtifactsFromFileRegistry: reverted (0.0000s) ======
1366== 20180327071612 AddPartialIndexToProjectRegistyChecksumShaColumns: reverting
1367-- transaction_open?()
1368 -> 0.0000s
1369-- indexes(:project_registry)
1370 -> 0.0049s
1371-- remove_index(:project_registry, nil, {:algorithm=>:concurrently, :name=>"idx_project_registry_on_repository_checksum_sha_partial"})
1372 -> 0.0010s
1373-- transaction_open?()
1374 -> 0.0000s
1375-- indexes(:project_registry)
1376 -> 0.0042s
1377-- remove_index(:project_registry, nil, {:algorithm=>:concurrently, :name=>"idx_project_registry_on_wiki_checksum_sha_partial"})
1378 -> 0.0009s
1379== 20180327071612 AddPartialIndexToProjectRegistyChecksumShaColumns: reverted (0.0151s)
1380== 20180326171626 RemoveOldRepositoryVerificationChecksumFromGeoProjectRegistry: reverting
1381-- add_column(:project_registry, :repository_verification_checksum, :string, {})
1382 -> 0.0013s
1383-- add_column(:project_registry, :wiki_verification_checksum, :string, {})
1384 -> 0.0007s
1385== 20180326171626 RemoveOldRepositoryVerificationChecksumFromGeoProjectRegistry: reverted (0.0021s)
1386== 20180323182105 AddMissingOnPrimaryToFileRegistry: reverting ================
1387-- remove_column(:file_registry, :missing_on_primary)
1388 -> 0.0008s
1389== 20180323182105 AddMissingOnPrimaryToFileRegistry: reverted (0.0009s) =======
1390== 20180322062741 MigrateCiJobArtifactsToSeparateRegistry: reverting ==========
1391== 20180322062741 MigrateCiJobArtifactsToSeparateRegistry: reverted (0.0113s) =
1392== 20180321144947 ChangeRepositoryVerificationChecksumToSha: reverting ========
1393-- remove_column(:project_registry, :repository_verification_checksum_sha)
1394 -> 0.0011s
1395-- remove_column(:project_registry, :wiki_verification_checksum_sha)
1396 -> 0.0006s
1397== 20180321144947 ChangeRepositoryVerificationChecksumToSha: reverted (0.0018s)
1398== 20180320013929 RemoveLastVerificationAtColumnsFromGeoProjectRegistry: reverting
1399-- add_column(:project_registry, :last_repository_verification_at, :datetime_with_timezone, {})
1400 -> 0.0016s
1401-- add_column(:project_registry, :last_wiki_verification_at, :datetime_with_timezone, {})
1402 -> 0.0007s
1403== 20180320013929 RemoveLastVerificationAtColumnsFromGeoProjectRegistry: reverted (0.0025s)
1404== 20180320011914 RemoveLastVerificationFailedColumnsFromGeoProjectRegistry: reverting
1405-- add_column(:project_registry, :last_repository_verification_failed, :boolean, {:default=>false, :null=>false})
1406 -> 0.0016s
1407-- add_column(:project_registry, :last_wiki_verification_failed, :boolean, {:default=>false, :null=>false})
1408 -> 0.0009s
1409== 20180320011914 RemoveLastVerificationFailedColumnsFromGeoProjectRegistry: reverted (0.0026s)
1410== 20180315222132 AddPartialIndexToProjectRegistyChecksumColumns: reverting ===
1411-- index_exists?(:project_registry, :repository_verification_checksum, {:name=>"idx_project_registry_on_repository_checksum_partial"})
1412 -> 0.0039s
1413-- index_exists?(:project_registry, :wiki_verification_checksum, {:name=>"idx_project_registry_on_wiki_checksum_partial"})
1414 -> 0.0038s
1415== 20180315222132 AddPartialIndexToProjectRegistyChecksumColumns: reverted (0.0078s)
1416== 20180314175612 AddPartialIndexToProjectRegistyVerificationFailureColumns: reverting
1417-- index_exists?(:project_registry, :project_id, {:name=>"idx_project_registry_on_repository_failure_partial"})
1418 -> 0.0039s
1419-- transaction_open?()
1420 -> 0.0000s
1421-- indexes(:project_registry)
1422 -> 0.0039s
1423-- remove_index(:project_registry, nil, {:algorithm=>:concurrently, :name=>"idx_project_registry_on_repository_failure_partial"})
1424 -> 0.0009s
1425-- index_exists?(:project_registry, :project_id, {:name=>"idx_project_registry_on_wiki_failure_partial"})
1426 -> 0.0035s
1427-- transaction_open?()
1428 -> 0.0000s
1429-- indexes(:project_registry)
1430 -> 0.0035s
1431-- remove_index(:project_registry, nil, {:algorithm=>:concurrently, :name=>"idx_project_registry_on_wiki_failure_partial"})
1432 -> 0.0008s
1433== 20180314175612 AddPartialIndexToProjectRegistyVerificationFailureColumns: reverted (0.0204s)
1434== 20180201154345 AddRepositoryVerificationToProjectRegistry: reverting =======
1435-- remove_column(:project_registry, :last_wiki_verification_failure, :string, {})
1436 -> 0.0011s
1437-- remove_column(:project_registry, :last_wiki_verification_failed, :boolean, {:null=>false, :default=>false})
1438 -> 0.0008s
1439-- remove_column(:project_registry, :last_wiki_verification_at, :datetime_with_timezone, {})
1440 -> 0.0007s
1441-- remove_column(:project_registry, :wiki_verification_checksum, :string, {})
1442 -> 0.0006s
1443-- remove_column(:project_registry, :last_repository_verification_failure, :string, {})
1444 -> 0.0007s
1445-- remove_column(:project_registry, :last_repository_verification_failed, :boolean, {:null=>false, :default=>false})
1446 -> 0.0008s
1447-- remove_column(:project_registry, :last_repository_verification_at, :datetime_with_timezone, {})
1448 -> 0.0006s
1449-- remove_column(:project_registry, :repository_verification_checksum, :string, {})
1450 -> 0.0006s
1451== 20180201154345 AddRepositoryVerificationToProjectRegistry: reverted (0.0066s)
1452== 20171115143841 AddLastSyncFailureToProjectRegistry: reverting ==============
1453-- remove_column(:project_registry, :last_wiki_sync_failure, :string, {})
1454 -> 0.0012s
1455-- remove_column(:project_registry, :last_repository_sync_failure, :string, {})
1456 -> 0.0006s
1457== 20171115143841 AddLastSyncFailureToProjectRegistry: reverted (0.0021s) =====
1458== 20171101105200 AddRetryCountFieldsToRegistries: reverting ==================
1459-- remove_column(:file_registry, :retry_count, :integer)
1460 -> 0.0007s
1461-- remove_column(:file_registry, :retry_at, :datetime)
1462 -> 0.0008s
1463-- remove_column(:project_registry, :repository_retry_count, :integer)
1464 -> 0.0006s
1465-- remove_column(:project_registry, :repository_retry_at, :datetime)
1466 -> 0.0007s
1467-- remove_column(:project_registry, :force_to_redownload_repository, :boolean)
1468 -> 0.0006s
1469-- remove_column(:project_registry, :wiki_retry_count, :integer)
1470 -> 0.0006s
1471-- remove_column(:project_registry, :wiki_retry_at, :datetime)
1472 -> 0.0008s
1473-- remove_column(:project_registry, :force_to_redownload_wiki, :boolean)
1474 -> 0.0006s
1475== 20171101105200 AddRetryCountFieldsToRegistries: reverted (0.0059s) =========
1476== 20171009162209 AddFileRegistrySuccessIndex: reverting ======================
1477-- transaction_open?()
1478 -> 0.0000s
1479-- index_exists?(:file_registry, :success, {:algorithm=>:concurrently, :name=>"index_file_registry_on_success"})
1480 -> 0.0010s
1481== 20171009162209 AddFileRegistrySuccessIndex: reverted (0.0016s) =============
1482== 20171009162208 AddFileRegistrySuccess: reverting ===========================
1483-- remove_column(:file_registry, :success)
1484 -> 0.0007s
1485== 20171009162208 AddFileRegistrySuccess: reverted (0.0034s) ==================
1486== 20171005045404 RemoveFileUploadsFromRegistry: reverting ====================
1487== 20171005045404 RemoveFileUploadsFromRegistry: reverted (0.0000s) ===========
1488== 20170906182752 AddUniqueIndexToProjectIdOnProjectRegistry: reverting =======
1489-- index_exists?(:project_registry, :project_id, {:name=>"index_project_registry_on_project_id"})
1490 -> 0.0028s
1491-- transaction_open?()
1492 -> 0.0000s
1493-- index_exists?(:project_registry, :project_id, {:algorithm=>:concurrently, :name=>"index_project_registry_on_project_id"})
1494 -> 0.0026s
1495-- remove_index(:project_registry, nil, {:algorithm=>:concurrently, :column=>:project_id, :name=>"index_project_registry_on_project_id"})
1496 -> 0.0034s
1497-- transaction_open?()
1498 -> 0.0000s
1499-- view_exists?(:postgres_partitions)
1500 -> 0.0005s
1501-- index_exists?(:project_registry, :project_id, {:algorithm=>:concurrently, :name=>"index_project_registry_on_project_id"})
1502 -> 0.0023s
1503-- add_index(:project_registry, :project_id, {:algorithm=>:concurrently})
1504 -> 0.0010s
1505== 20170906182752 AddUniqueIndexToProjectIdOnProjectRegistry: reverted (0.0170s)
1506== 20170906174622 RemoveDuplicatesFromProjectRegistry: reverting ==============
1507== 20170906174622 RemoveDuplicatesFromProjectRegistry: reverted (0.0000s) =====
1508$ bundle exec rake db:migrate:geo
1509== 20170906174622 RemoveDuplicatesFromProjectRegistry: migrating ==============
1510-- 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")
1511 -> 0.0012s
1512== 20170906174622 RemoveDuplicatesFromProjectRegistry: migrated (0.0028s) =====
1513== 20170906182752 AddUniqueIndexToProjectIdOnProjectRegistry: migrating =======
1514-- index_exists?(:project_registry, :project_id, {:name=>"index_project_registry_on_project_id"})
1515 -> 0.0037s
1516-- transaction_open?()
1517 -> 0.0000s
1518-- index_exists?(:project_registry, :project_id, {:algorithm=>:concurrently, :name=>"index_project_registry_on_project_id"})
1519 -> 0.0025s
1520-- remove_index(:project_registry, nil, {:algorithm=>:concurrently, :column=>:project_id, :name=>"index_project_registry_on_project_id"})
1521 -> 0.0034s
1522-- transaction_open?()
1523 -> 0.0000s
1524-- view_exists?(:postgres_partitions)
1525 -> 0.0005s
1526-- index_exists?(:project_registry, :project_id, {:unique=>true, :algorithm=>:concurrently, :name=>"index_project_registry_on_project_id"})
1527 -> 0.0022s
1528-- add_index(:project_registry, :project_id, {:unique=>true, :algorithm=>:concurrently})
1529 -> 0.0012s
1530== 20170906182752 AddUniqueIndexToProjectIdOnProjectRegistry: migrated (0.0180s)
1531== 20171005045404 RemoveFileUploadsFromRegistry: migrating ====================
1532== 20171005045404 RemoveFileUploadsFromRegistry: migrated (0.0077s) ===========
1533== 20171009162208 AddFileRegistrySuccess: migrating ===========================
1534-- add_column(:file_registry, :success, :boolean, {:default=>true, :limit=>nil, :null=>false})
1535 -> 0.0017s
1536-- change_column(:file_registry, :success, :boolean, {})
1537 -> 0.0007s
1538== 20171009162208 AddFileRegistrySuccess: migrated (0.0047s) ==================
1539== 20171009162209 AddFileRegistrySuccessIndex: migrating ======================
1540-- transaction_open?()
1541 -> 0.0000s
1542-- view_exists?(:postgres_partitions)
1543 -> 0.0005s
1544-- index_exists?(:file_registry, :success, {:algorithm=>:concurrently, :name=>"index_file_registry_on_success"})
1545 -> 0.0008s
1546-- add_index(:file_registry, :success, {:algorithm=>:concurrently})
1547 -> 0.0010s
1548== 20171009162209 AddFileRegistrySuccessIndex: migrated (0.0042s) =============
1549== 20171101105200 AddRetryCountFieldsToRegistries: migrating ==================
1550-- add_column(:file_registry, :retry_count, :integer, {})
1551 -> 0.0007s
1552-- add_column(:file_registry, :retry_at, :datetime, {})
1553 -> 0.0007s
1554-- add_column(:project_registry, :repository_retry_count, :integer, {})
1555 -> 0.0006s
1556-- add_column(:project_registry, :repository_retry_at, :datetime, {})
1557 -> 0.0007s
1558-- add_column(:project_registry, :force_to_redownload_repository, :boolean, {})
1559 -> 0.0006s
1560-- add_column(:project_registry, :wiki_retry_count, :integer, {})
1561 -> 0.0006s
1562-- add_column(:project_registry, :wiki_retry_at, :datetime, {})
1563 -> 0.0006s
1564-- add_column(:project_registry, :force_to_redownload_wiki, :boolean, {})
1565 -> 0.0006s
1566-- transaction_open?()
1567 -> 0.0000s
1568-- view_exists?(:postgres_partitions)
1569 -> 0.0005s
1570-- index_exists?(:file_registry, :retry_at, {:algorithm=>:concurrently, :name=>"index_file_registry_on_retry_at"})
1571 -> 0.0013s
1572-- add_index(:file_registry, :retry_at, {:algorithm=>:concurrently})
1573 -> 0.0010s
1574-- transaction_open?()
1575 -> 0.0000s
1576-- view_exists?(:postgres_partitions)
1577 -> 0.0006s
1578-- index_exists?(:project_registry, :repository_retry_at, {:algorithm=>:concurrently, :name=>"index_project_registry_on_repository_retry_at"})
1579 -> 0.0024s
1580-- add_index(:project_registry, :repository_retry_at, {:algorithm=>:concurrently})
1581 -> 0.0010s
1582-- transaction_open?()
1583 -> 0.0000s
1584-- view_exists?(:postgres_partitions)
1585 -> 0.0005s
1586-- index_exists?(:project_registry, :wiki_retry_at, {:algorithm=>:concurrently, :name=>"index_project_registry_on_wiki_retry_at"})
1587 -> 0.0029s
1588-- add_index(:project_registry, :wiki_retry_at, {:algorithm=>:concurrently})
1589 -> 0.0010s
1590== 20171101105200 AddRetryCountFieldsToRegistries: migrated (0.0223s) =========
1591== 20171115143841 AddLastSyncFailureToProjectRegistry: migrating ==============
1592-- add_column(:project_registry, :last_repository_sync_failure, :string, {})
1593 -> 0.0009s
1594-- add_column(:project_registry, :last_wiki_sync_failure, :string, {})
1595 -> 0.0006s
1596== 20171115143841 AddLastSyncFailureToProjectRegistry: migrated (0.0017s) =====
1597== 20180201154345 AddRepositoryVerificationToProjectRegistry: migrating =======
1598-- add_column(:project_registry, :repository_verification_checksum, :string, {})
1599 -> 0.0010s
1600-- add_column(:project_registry, :last_repository_verification_at, :datetime_with_timezone, {})
1601 -> 0.0006s
1602-- add_column(:project_registry, :last_repository_verification_failed, :boolean, {:null=>false, :default=>false})
1603 -> 0.0009s
1604-- add_column(:project_registry, :last_repository_verification_failure, :string, {})
1605 -> 0.0006s
1606-- add_column(:project_registry, :wiki_verification_checksum, :string, {})
1607 -> 0.0006s
1608-- add_column(:project_registry, :last_wiki_verification_at, :datetime_with_timezone, {})
1609 -> 0.0006s
1610-- add_column(:project_registry, :last_wiki_verification_failed, :boolean, {:null=>false, :default=>false})
1611 -> 0.0009s
1612-- add_column(:project_registry, :last_wiki_verification_failure, :string, {})
1613 -> 0.0006s
1614== 20180201154345 AddRepositoryVerificationToProjectRegistry: migrated (0.0062s)
1615== 20180314175612 AddPartialIndexToProjectRegistyVerificationFailureColumns: migrating
1616-- index_exists?(:project_registry, :project_id, {:name=>"idx_project_registry_on_repository_failure_partial"})
1617 -> 0.0032s
1618-- transaction_open?()
1619 -> 0.0000s
1620-- view_exists?(:postgres_partitions)
1621 -> 0.0005s
1622-- index_exists?(:project_registry, :project_id, {:name=>"idx_project_registry_on_repository_failure_partial", :where=>"last_repository_verification_failure IS NOT NULL", :algorithm=>:concurrently})
1623 -> 0.0031s
1624-- add_index(:project_registry, :project_id, {:name=>"idx_project_registry_on_repository_failure_partial", :where=>"last_repository_verification_failure IS NOT NULL", :algorithm=>:concurrently})
1625 -> 0.0010s
1626-- index_exists?(:project_registry, :project_id, {:name=>"idx_project_registry_on_wiki_failure_partial"})
1627 -> 0.0035s
1628-- transaction_open?()
1629 -> 0.0000s
1630-- view_exists?(:postgres_partitions)
1631 -> 0.0005s
1632-- index_exists?(:project_registry, :project_id, {:name=>"idx_project_registry_on_wiki_failure_partial", :where=>"last_wiki_verification_failure IS NOT NULL", :algorithm=>:concurrently})
1633 -> 0.0034s
1634-- add_index(:project_registry, :project_id, {:name=>"idx_project_registry_on_wiki_failure_partial", :where=>"last_wiki_verification_failure IS NOT NULL", :algorithm=>:concurrently})
1635 -> 0.0009s
1636== 20180314175612 AddPartialIndexToProjectRegistyVerificationFailureColumns: migrated (0.0200s)
1637== 20180315222132 AddPartialIndexToProjectRegistyChecksumColumns: migrating ===
1638-- index_exists?(:project_registry, :repository_verification_checksum, {:name=>"idx_project_registry_on_repository_checksum_partial"})
1639 -> 0.0038s
1640-- transaction_open?()
1641 -> 0.0000s
1642-- view_exists?(:postgres_partitions)
1643 -> 0.0005s
1644-- index_exists?(:project_registry, :repository_verification_checksum, {:name=>"idx_project_registry_on_repository_checksum_partial", :where=>"repository_verification_checksum IS NULL", :algorithm=>:concurrently})
1645 -> 0.0036s
1646-- add_index(:project_registry, :repository_verification_checksum, {:name=>"idx_project_registry_on_repository_checksum_partial", :where=>"repository_verification_checksum IS NULL", :algorithm=>:concurrently})
1647 -> 0.0018s
1648-- index_exists?(:project_registry, :wiki_verification_checksum, {:name=>"idx_project_registry_on_wiki_checksum_partial"})
1649 -> 0.0045s
1650-- transaction_open?()
1651 -> 0.0000s
1652-- view_exists?(:postgres_partitions)
1653 -> 0.0005s
1654-- index_exists?(:project_registry, :wiki_verification_checksum, {:name=>"idx_project_registry_on_wiki_checksum_partial", :where=>"wiki_verification_checksum IS NULL", :algorithm=>:concurrently})
1655 -> 0.0042s
1656-- add_index(:project_registry, :wiki_verification_checksum, {:name=>"idx_project_registry_on_wiki_checksum_partial", :where=>"wiki_verification_checksum IS NULL", :algorithm=>:concurrently})
1657 -> 0.0011s
1658== 20180315222132 AddPartialIndexToProjectRegistyChecksumColumns: migrated (0.0249s)
1659== 20180320011914 RemoveLastVerificationFailedColumnsFromGeoProjectRegistry: migrating
1660-- remove_column(:project_registry, :last_repository_verification_failed)
1661 -> 0.0012s
1662-- remove_column(:project_registry, :last_wiki_verification_failed)
1663 -> 0.0006s
1664== 20180320011914 RemoveLastVerificationFailedColumnsFromGeoProjectRegistry: migrated (0.0019s)
1665== 20180320013929 RemoveLastVerificationAtColumnsFromGeoProjectRegistry: migrating
1666-- remove_column(:project_registry, :last_repository_verification_at)
1667 -> 0.0010s
1668-- remove_column(:project_registry, :last_wiki_verification_at)
1669 -> 0.0006s
1670== 20180320013929 RemoveLastVerificationAtColumnsFromGeoProjectRegistry: migrated (0.0017s)
1671== 20180321144947 ChangeRepositoryVerificationChecksumToSha: migrating ========
1672-- add_column(:project_registry, :repository_verification_checksum_sha, :binary, {})
1673 -> 0.0010s
1674-- add_column(:project_registry, :wiki_verification_checksum_sha, :binary, {})
1675 -> 0.0006s
1676== 20180321144947 ChangeRepositoryVerificationChecksumToSha: migrated (0.0018s)
1677== 20180322062741 MigrateCiJobArtifactsToSeparateRegistry: migrating ==========
1678== 20180322062741 MigrateCiJobArtifactsToSeparateRegistry: migrated (0.0160s) =
1679== 20180323182105 AddMissingOnPrimaryToFileRegistry: migrating ================
1680-- add_column(:file_registry, :missing_on_primary, :boolean, {:default=>false, :limit=>nil, :null=>false})
1681 -> 0.0010s
1682== 20180323182105 AddMissingOnPrimaryToFileRegistry: migrated (0.0011s) =======
1683== 20180326171626 RemoveOldRepositoryVerificationChecksumFromGeoProjectRegistry: migrating
1684-- remove_column(:project_registry, :repository_verification_checksum)
1685 -> 0.0011s
1686-- remove_column(:project_registry, :wiki_verification_checksum)
1687 -> 0.0007s
1688== 20180326171626 RemoveOldRepositoryVerificationChecksumFromGeoProjectRegistry: migrated (0.0018s)
1689== 20180327071612 AddPartialIndexToProjectRegistyChecksumShaColumns: migrating
1690-- transaction_open?()
1691 -> 0.0000s
1692-- view_exists?(:postgres_partitions)
1693 -> 0.0006s
1694-- 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})
1695 -> 0.0039s
1696-- 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})
1697 -> 0.0016s
1698-- transaction_open?()
1699 -> 0.0000s
1700-- view_exists?(:postgres_partitions)
1701 -> 0.0008s
1702-- 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})
1703 -> 0.0046s
1704-- 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})
1705 -> 0.0013s
1706== 20180327071612 AddPartialIndexToProjectRegistyChecksumShaColumns: migrated (0.0178s)
1707== 20180331055706 DeleteJobArtifactsFromFileRegistry: migrating ===============
1708-- execute("DELETE FROM file_registry WHERE file_type = 'job_artifact'")
1709 -> 0.0014s
1710-- execute("DROP TRIGGER IF EXISTS replicate_job_artifact_registry ON file_registry")
1711 -> 0.0007s
1712-- execute("DROP FUNCTION IF EXISTS replicate_job_artifact_registry()")
1713 -> 0.0006s
1714== 20180331055706 DeleteJobArtifactsFromFileRegistry: migrated (0.0030s) ======
1715== 20180402170913 AddMissingOnPrimaryToJobArtifactRegistry: migrating =========
1716-- add_column(:job_artifact_registry, :missing_on_primary, :boolean, {:default=>false, :limit=>nil, :null=>false})
1717 -> 0.0013s
1718== 20180402170913 AddMissingOnPrimaryToJobArtifactRegistry: migrated (0.0015s)
1719== 20180405074130 AddPartialIndexProjectRepositoryVerification: migrating =====
1720-- transaction_open?()
1721 -> 0.0000s
1722-- view_exists?(:postgres_partitions)
1723 -> 0.0009s
1724-- 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})
1725 -> 0.0053s
1726-- 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})
1727 -> 0.0014s
1728-- transaction_open?()
1729 -> 0.0000s
1730-- view_exists?(:postgres_partitions)
1731 -> 0.0006s
1732-- 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})
1733 -> 0.0052s
1734-- 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})
1735 -> 0.0014s
1736== 20180405074130 AddPartialIndexProjectRepositoryVerification: migrated (0.0198s)
1737== 20180412213305 AddIndexToArtifactIdOnJobArtifactRegistry: migrating ========
1738-- transaction_open?()
1739 -> 0.0000s
1740-- view_exists?(:postgres_partitions)
1741 -> 0.0006s
1742-- index_exists?(:job_artifact_registry, :artifact_id, {:algorithm=>:concurrently, :name=>"index_job_artifact_registry_on_artifact_id"})
1743 -> 0.0019s
1744-- add_index(:job_artifact_registry, :artifact_id, {:algorithm=>:concurrently})
1745 -> 0.0014s
1746== 20180412213305 AddIndexToArtifactIdOnJobArtifactRegistry: migrated (0.0069s)
1747== 20180419174834 AddChecksumMismatchFieldsToProjectRegistry: migrating =======
1748-- add_column(:project_registry, :repository_checksum_mismatch, :boolean, {:null=>false, :default=>false})
1749 -> 0.0018s
1750-- add_column(:project_registry, :wiki_checksum_mismatch, :boolean, {:null=>false, :default=>false})
1751 -> 0.0011s
1752== 20180419174834 AddChecksumMismatchFieldsToProjectRegistry: migrated (0.0032s)
1753== 20180419192603 AddIndexesToChecksumMismatchFieldsOnProjectRegistry: migrating
1754-- transaction_open?()
1755 -> 0.0000s
1756-- view_exists?(:postgres_partitions)
1757 -> 0.0007s
1758-- index_exists?(:project_registry, :project_id, {:name=>"idx_repository_checksum_mismatch", :where=>"repository_checksum_mismatch = true", :algorithm=>:concurrently})
1759 -> 0.0056s
1760-- add_index(:project_registry, :project_id, {:name=>"idx_repository_checksum_mismatch", :where=>"repository_checksum_mismatch = true", :algorithm=>:concurrently})
1761 -> 0.0013s
1762-- transaction_open?()
1763 -> 0.0000s
1764-- view_exists?(:postgres_partitions)
1765 -> 0.0005s
1766-- index_exists?(:project_registry, :project_id, {:name=>"idx_wiki_checksum_mismatch", :where=>"wiki_checksum_mismatch = true", :algorithm=>:concurrently})
1767 -> 0.0059s
1768-- add_index(:project_registry, :project_id, {:name=>"idx_wiki_checksum_mismatch", :where=>"wiki_checksum_mismatch = true", :algorithm=>:concurrently})
1769 -> 0.0013s
1770== 20180419192603 AddIndexesToChecksumMismatchFieldsOnProjectRegistry: migrated (0.0205s)
1771== 20180427114641 AddRepositoryCheckToGeoProjectRegistry: migrating ===========
1772-- add_column(:project_registry, :last_repository_check_failed, :boolean, {})
1773 -> 0.0012s
1774-- add_column(:project_registry, :last_repository_check_at, :datetime_with_timezone, {})
1775 -> 0.0007s
1776== 20180427114641 AddRepositoryCheckToGeoProjectRegistry: migrated (0.0022s) ==
1777== 20180510223634 SetResyncFlagForRetriedProjects: migrating ==================
1778-- 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")
1779 -> 0.0015s
1780== 20180510223634 SetResyncFlagForRetriedProjects: migrated (0.0015s) =========
1781== 20180613184349 AddResyncWasScheduledAtToProjectRegistry: migrating =========
1782-- add_column(:project_registry, :resync_repository_was_scheduled_at, :datetime_with_timezone, {})
1783 -> 0.0012s
1784-- add_column(:project_registry, :resync_wiki_was_scheduled_at, :datetime_with_timezone, {})
1785 -> 0.0007s
1786== 20180613184349 AddResyncWasScheduledAtToProjectRegistry: migrated (0.0020s)
1787== 20180727221937 AddMissingOnPrimaryToProjectRegistry: migrating =============
1788-- add_column(:project_registry, :repository_missing_on_primary, :boolean, {})
1789 -> 0.0012s
1790-- add_column(:project_registry, :wiki_missing_on_primary, :boolean, {})
1791 -> 0.0006s
1792== 20180727221937 AddMissingOnPrimaryToProjectRegistry: migrated (0.0020s) ====
1793== 20180802215313 AddRetryVerificationFieldsToProjectRegistry: migrating ======
1794-- add_column(:project_registry, :repository_verification_retry_count, :integer, {})
1795 -> 0.0012s
1796-- add_column(:project_registry, :wiki_verification_retry_count, :integer, {})
1797 -> 0.0006s
1798== 20180802215313 AddRetryVerificationFieldsToProjectRegistry: migrated (0.0020s)
1799== 20180803160048 AddSyncedRepositoriesPartialIndex: migrating ================
1800-- transaction_open?()
1801 -> 0.0000s
1802-- view_exists?(:postgres_partitions)
1803 -> 0.0010s
1804-- 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})
1805 -> 0.0061s
1806-- 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})
1807 -> 0.0013s
1808== 20180803160048 AddSyncedRepositoriesPartialIndex: migrated (0.0110s) =======
1809== 20180806011909 AddFailedSynchronizationsPartialIndex: migrating ============
1810-- transaction_open?()
1811 -> 0.0000s
1812-- view_exists?(:postgres_partitions)
1813 -> 0.0006s
1814-- 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})
1815 -> 0.0061s
1816-- 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})
1817 -> 0.0013s
1818== 20180806011909 AddFailedSynchronizationsPartialIndex: migrated (0.0101s) ===
1819== 20180806020615 AddPendingSynchronizationsPartialIndex: migrating ===========
1820-- transaction_open?()
1821 -> 0.0000s
1822-- view_exists?(:postgres_partitions)
1823 -> 0.0005s
1824-- 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})
1825 -> 0.0063s
1826-- 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})
1827 -> 0.0013s
1828== 20180806020615 AddPendingSynchronizationsPartialIndex: migrated (0.0103s) ==
1829== 20181213184140 AddLastVerificationColumnsToProjectRegistry: migrating ======
1830-- add_column(:project_registry, :last_repository_verification_ran_at, :datetime_with_timezone, {})
1831 -> 0.0013s
1832-- add_column(:project_registry, :last_wiki_verification_ran_at, :datetime_with_timezone, {})
1833 -> 0.0007s
1834== 20181213184140 AddLastVerificationColumnsToProjectRegistry: migrated (0.0022s)
1835== 20190314201959 AddChecksumMismatchedColumndsToProjectRegistry: migrating ===
1836-- add_column(:project_registry, :repository_verification_checksum_mismatched, :binary, {})
1837 -> 0.0011s
1838-- add_column(:project_registry, :wiki_verification_checksum_mismatched, :binary, {})
1839 -> 0.0006s
1840== 20190314201959 AddChecksumMismatchedColumndsToProjectRegistry: migrated (0.0019s)
1841== 20190612211021 AddContainerRepositoryRegistry: migrating ===================
1842-- create_table(:container_repository_registry, {:id=>:serial, :force=>:cascade})
1843 -> 0.0054s
1844== 20190612211021 AddContainerRepositoryRegistry: migrated (0.0055s) ==========
1845== 20190802200655 AddCreatedAtToEventLogStates: migrating =====================
1846-- add_column(:event_log_states, :created_at, :datetime, {:null=>true})
1847 -> 0.0011s
1848-- 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 )")
1849 -> 0.0010s
1850-- change_column_null(:event_log_states, :created_at, false)
1851 -> 0.0006s
1852== 20190802200655 AddCreatedAtToEventLogStates: migrated (0.0029s) ============
1853== 20190923111102 AddDesignRegistry: migrating ================================
1854-- create_table(:design_registry, {:id=>:serial, :force=>:cascade})
1855 -> 0.0050s
1856== 20190923111102 AddDesignRegistry: migrated (0.0051s) =======================
1857== 20191007122326 AddUniqueConstraintOnDesignRegistryProjectId: migrating =====
1858-- remove_index(:design_registry, {:column=>:project_id, :name=>"index_design_registry_on_project_id"})
1859 -> 0.0030s
1860-- add_index(:design_registry, :project_id, {:name=>"index_design_registry_on_project_id", :unique=>true})
1861 -> 0.0007s
1862== 20191007122326 AddUniqueConstraintOnDesignRegistryProjectId: migrated (0.0039s)
1863== 20191010203257 CreateLfsObjectRegistry: migrating ==========================
1864-- create_table(:lfs_object_registry, {:force=>:cascade})
1865 -> 0.0052s
1866== 20191010203257 CreateLfsObjectRegistry: migrated (0.0053s) =================
1867== 20191010204941 MigrateLfsObjectsToSeparateRegistry: migrating ==============
1868-- execute("LOCK TABLE file_registry IN EXCLUSIVE MODE")
1869 -> 0.0012s
1870-- 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")
1871 -> 0.0010s
1872-- 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")
1873 -> 0.0016s
1874-- 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")
1875 -> 0.0007s
1876== 20191010204941 MigrateLfsObjectsToSeparateRegistry: migrated (0.0080s) =====
1877== 20191025194337 DeleteLfsObjectsFromFileRegistry: migrating =================
1878-- execute("DELETE FROM file_registry WHERE file_type = 'lfs'")
1879 -> 0.0011s
1880-- execute("DROP TRIGGER IF EXISTS replicate_lfs_object_registry ON file_registry")
1881 -> 0.0006s
1882-- execute("DROP FUNCTION IF EXISTS replicate_lfs_object_registry()")
1883 -> 0.0005s
1884== 20191025194337 DeleteLfsObjectsFromFileRegistry: migrated (0.0024s) ========
1885== 20200121194300 CreatePackageFileRegistry: migrating ========================
1886-- create_table(:package_file_registry, {:id=>:serial, :force=>:cascade})
1887 -> 0.0053s
1888== 20200121194300 CreatePackageFileRegistry: migrated (0.0054s) ===============
1889== 20200407120740 AddVerificationFieldsToPackageFileOnSecondary: migrating ====
1890-- add_column(:package_file_registry, :verification_failure, :string, {:limit=>255})
1891 -> 0.0014s
1892-- add_column(:package_file_registry, :verification_checksum, :binary)
1893 -> 0.0008s
1894-- add_column(:package_file_registry, :checksum_mismatch, :boolean)
1895 -> 0.0006s
1896-- add_column(:package_file_registry, :verification_checksum_mismatched, :binary)
1897 -> 0.0007s
1898-- add_column(:package_file_registry, :verification_retry_count, :integer)
1899 -> 0.0006s
1900-- add_column(:package_file_registry, :verified_at, :datetime_with_timezone)
1901 -> 0.0006s
1902-- add_column(:package_file_registry, :verification_retry_at, :datetime_with_timezone)
1903 -> 0.0006s
1904== 20200407120740 AddVerificationFieldsToPackageFileOnSecondary: migrated (0.0057s)
1905== 20200707011052 AddVerifiedOnPrimaryColumnsToProjectRegistry: migrating =====
1906-- add_column(:project_registry, :primary_repository_checksummed, :boolean, {:default=>false, :null=>false})
1907 -> 0.0015s
1908-- add_column(:project_registry, :primary_wiki_checksummed, :boolean, {:default=>false, :null=>false})
1909 -> 0.0009s
1910== 20200707011052 AddVerifiedOnPrimaryColumnsToProjectRegistry: migrated (0.0026s)
1911== 20200707210300 CreateTerraformStateRegistry: migrating =====================
1912-- table_exists?(:terraform_state_registry)
1913 -> 0.0006s
1914-- create_table(:terraform_state_registry, {:id=>:bigserial, :force=>:cascade})
1915 -> 0.0054s
1916-- transaction_open?()
1917 -> 0.0000s
1918-- current_schema()
1919 -> 0.0004s
1920-- execute("ALTER TABLE terraform_state_registry\nADD CONSTRAINT check_70a3f43f16\nCHECK ( char_length(last_sync_failure) <= 255 )\nNOT VALID;\n")
1921 -> 0.0008s
1922-- current_schema()
1923 -> 0.0003s
1924-- execute("ALTER TABLE terraform_state_registry VALIDATE CONSTRAINT check_70a3f43f16;")
1925 -> 0.0006s
1926== 20200707210300 CreateTerraformStateRegistry: migrated (0.0181s) ============
1927== 20200710194046 CreateVulnerabilityExportRegistry: migrating ================
1928-- table_exists?(:vulnerability_export_registry)
1929 -> 0.0008s
1930-- create_table(:vulnerability_export_registry, {:id=>:bigserial, :force=>:cascade})
1931 -> 0.0057s
1932-- transaction_open?()
1933 -> 0.0000s
1934-- current_schema()
1935 -> 0.0003s
1936-- execute("ALTER TABLE vulnerability_export_registry\nADD CONSTRAINT check_6edacda197\nCHECK ( char_length(last_sync_failure) <= 255 )\nNOT VALID;\n")
1937 -> 0.0007s
1938-- current_schema()
1939 -> 0.0003s
1940-- execute("ALTER TABLE vulnerability_export_registry VALIDATE CONSTRAINT check_6edacda197;")
1941 -> 0.0005s
1942== 20200710194046 CreateVulnerabilityExportRegistry: migrated (0.0129s) =======
1943== 20200730133800 RemoveTableVulnerabilityExportRegistry: migrating ===========
1944-- table_exists?(:vulnerability_export_registry)
1945 -> 0.0010s
1946-- drop_table(:vulnerability_export_registry)
1947 -> 0.0012s
1948== 20200730133800 RemoveTableVulnerabilityExportRegistry: migrated (0.0023s) ==
1949== 20200811171011 CreateSnippetRepositoryRegistry: migrating ==================
1950-- create_table(:snippet_repository_registry, {:id=>:bigserial, :force=>:cascade})
1951 -> 0.0048s
1952-- transaction_open?()
1953 -> 0.0000s
1954-- current_schema()
1955 -> 0.0004s
1956-- execute("ALTER TABLE snippet_repository_registry\nADD CONSTRAINT check_5409cb1003\nCHECK ( char_length(last_sync_failure) <= 255 )\nNOT VALID;\n")
1957 -> 0.0006s
1958-- current_schema()
1959 -> 0.0003s
1960-- execute("ALTER TABLE snippet_repository_registry VALIDATE CONSTRAINT check_5409cb1003;")
1961 -> 0.0006s
1962== 20200811171011 CreateSnippetRepositoryRegistry: migrated (0.0110s) =========
1963== 20200827120552 CreateMergeRequestDiffRegistry: migrating ===================
1964-- table_exists?(:merge_request_diff_registry)
1965 -> 0.0005s
1966-- create_table(:merge_request_diff_registry, {})
1967 -> 0.0049s
1968-- transaction_open?()
1969 -> 0.0000s
1970-- current_schema()
1971 -> 0.0004s
1972-- execute("ALTER TABLE merge_request_diff_registry\nADD CONSTRAINT check_803d4b5fb5\nCHECK ( char_length(last_sync_failure) <= 255 )\nNOT VALID;\n")
1973 -> 0.0006s
1974-- current_schema()
1975 -> 0.0003s
1976-- execute("ALTER TABLE merge_request_diff_registry VALIDATE CONSTRAINT check_803d4b5fb5;")
1977 -> 0.0005s
1978== 20200827120552 CreateMergeRequestDiffRegistry: migrated (0.0121s) ==========
1979== 20200915152620 CreateTerraformStateVersionRegistry: migrating ==============
1980-- table_exists?(:terraform_state_version_registry)
1981 -> 0.0005s
1982-- create_table(:terraform_state_version_registry, {:id=>:bigserial, :force=>:cascade})
1983 -> 0.0053s
1984-- transaction_open?()
1985 -> 0.0000s
1986-- current_schema()
1987 -> 0.0004s
1988-- execute("ALTER TABLE terraform_state_version_registry\nADD CONSTRAINT check_7827f2d2cf\nCHECK ( char_length(last_sync_failure) <= 255 )\nNOT VALID;\n")
1989 -> 0.0008s
1990-- current_schema()
1991 -> 0.0003s
1992-- execute("ALTER TABLE terraform_state_version_registry VALIDATE CONSTRAINT check_7827f2d2cf;")
1993 -> 0.0005s
1994== 20200915152620 CreateTerraformStateVersionRegistry: migrated (0.0134s) =====
1995== 20200924184638 RemoveNonVersionedTerraformStateRegistry: migrating =========
1996-- drop_table(:terraform_state_registry)
1997 -> 0.0017s
1998== 20200924184638 RemoveNonVersionedTerraformStateRegistry: migrated (0.0017s)
1999== 20201208025254 AddVerificationFieldsToPackageFileRegistry: migrating =======
2000-- add_column(:package_file_registry, :verification_state, :integer, {:default=>0, :limit=>2, :null=>false})
2001 -> 0.0016s
2002-- add_column(:package_file_registry, :verification_started_at, :datetime_with_timezone)
2003 -> 0.0007s
2004== 20201208025254 AddVerificationFieldsToPackageFileRegistry: migrated (0.0024s)
2005== 20201208031224 AddVerificationIndexesToPackageFileRegistry: migrating ======
2006-- transaction_open?()
2007 -> 0.0000s
2008-- view_exists?(:postgres_partitions)
2009 -> 0.0006s
2010-- 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})
2011 -> 0.0026s
2012-- 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})
2013 -> 0.0014s
2014-- transaction_open?()
2015 -> 0.0000s
2016-- view_exists?(:postgres_partitions)
2017 -> 0.0006s
2018-- 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})
2019 -> 0.0024s
2020-- 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})
2021 -> 0.0011s
2022-- transaction_open?()
2023 -> 0.0000s
2024-- view_exists?(:postgres_partitions)
2025 -> 0.0005s
2026-- index_exists?(:package_file_registry, :verification_state, {:where=>"(state = 2 AND (verification_state IN (0, 3)))", :name=>"package_file_registry_needs_verification", :algorithm=>:concurrently})
2027 -> 0.0026s
2028-- add_index(:package_file_registry, :verification_state, {:where=>"(state = 2 AND (verification_state IN (0, 3)))", :name=>"package_file_registry_needs_verification", :algorithm=>:concurrently})
2029 -> 0.0011s
2030== 20201208031224 AddVerificationIndexesToPackageFileRegistry: migrated (0.0195s)
2031== 20210111911002 PrepareJobArtifactRegistryForSsf: migrating =================
2032-- change_column_default(:job_artifact_registry, :retry_count, {:from=>nil, :to=>0})
2033 -> 0.0024s
2034-- add_column(:job_artifact_registry, :last_synced_at, :datetime_with_timezone)
2035 -> 0.0007s
2036-- add_column(:job_artifact_registry, :verified_at, :datetime_with_timezone)
2037 -> 0.0013s
2038-- add_column(:job_artifact_registry, :verification_started_at, :datetime_with_timezone)
2039 -> 0.0009s
2040-- add_column(:job_artifact_registry, :verification_retry_at, :datetime_with_timezone)
2041 -> 0.0007s
2042-- add_column(:job_artifact_registry, :state, :integer, {:null=>false, :limit=>2, :default=>0})
2043 -> 0.0010s
2044-- add_column(:job_artifact_registry, :verification_state, :integer, {:default=>0, :null=>false, :limit=>2})
2045 -> 0.0010s
2046-- add_column(:job_artifact_registry, :verification_retry_count, :integer, {:default=>0, :limit=>2, :null=>false})
2047 -> 0.0009s
2048-- add_column(:job_artifact_registry, :verification_checksum, :binary)
2049 -> 0.0005s
2050-- add_column(:job_artifact_registry, :verification_checksum_mismatched, :binary)
2051 -> 0.0006s
2052-- add_column(:job_artifact_registry, :checksum_mismatch, :boolean, {:default=>false, :null=>false})
2053 -> 0.0009s
2054-- add_column(:job_artifact_registry, :verification_failure, :string, {:limit=>255})
2055 -> 0.0006s
2056-- add_column(:job_artifact_registry, :last_sync_failure, :string, {:limit=>255})
2057 -> 0.0006s
2058== 20210111911002 PrepareJobArtifactRegistryForSsf: migrated (0.0126s) ========
2059== 20210111912220 PrepareJobArtifactRegistryForSsfIndecies: migrating =========
2060-- transaction_open?()
2061 -> 0.0000s
2062-- view_exists?(:postgres_partitions)
2063 -> 0.0007s
2064-- 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})
2065 -> 0.0021s
2066-- 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})
2067 -> 0.0013s
2068-- transaction_open?()
2069 -> 0.0000s
2070-- view_exists?(:postgres_partitions)
2071 -> 0.0005s
2072-- 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})
2073 -> 0.0023s
2074-- 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})
2075 -> 0.0014s
2076-- transaction_open?()
2077 -> 0.0000s
2078-- view_exists?(:postgres_partitions)
2079 -> 0.0005s
2080-- 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})
2081 -> 0.0027s
2082-- 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})
2083 -> 0.0013s
2084== 20210111912220 PrepareJobArtifactRegistryForSsfIndecies: migrated (0.0192s)
2085== 20210120225014 MigrateLfsObjectRegistry: migrating =========================
2086-- change_column_default(:lfs_object_registry, :retry_count, {:from=>nil, :to=>0})
2087 -> 0.0024s
2088-- add_column(:lfs_object_registry, :state, :integer, {:null=>false, :limit=>2, :default=>0})
2089 -> 0.0010s
2090-- add_column(:lfs_object_registry, :last_synced_at, :datetime_with_timezone)
2091 -> 0.0007s
2092-- add_column(:lfs_object_registry, :last_sync_failure, :text)
2093 -> 0.0007s
2094== 20210120225014 MigrateLfsObjectRegistry: migrated (0.0049s) ================
2095== 20210125222907 AddLfsObjectStateIndex: migrating ===========================
2096-- transaction_open?()
2097 -> 0.0000s
2098-- view_exists?(:postgres_partitions)
2099 -> 0.0005s
2100-- index_exists?(:lfs_object_registry, :state, {:name=>"index_state_in_lfs_objects", :algorithm=>:concurrently})
2101 -> 0.0021s
2102-- add_index(:lfs_object_registry, :state, {:name=>"index_state_in_lfs_objects", :algorithm=>:concurrently})
2103 -> 0.0012s
2104== 20210125222907 AddLfsObjectStateIndex: migrated (0.0058s) ==================
2105== 20210208175408 CreateGeoSecondaryUsageData: migrating ======================
2106-- create_table(:secondary_usage_data, {})
2107 -> 0.0030s
2108== 20210208175408 CreateGeoSecondaryUsageData: migrated (0.0031s) =============
2109== 20210217020154 AddUniqueIndexOnContainerRepositoryRegistry: migrating ======
2110-- 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")
2111 -> 0.0010s
2112-- transaction_open?()
2113 -> 0.0000s
2114-- view_exists?(:postgres_partitions)
2115 -> 0.0006s
2116-- index_exists?(:container_repository_registry, :container_repository_id, {:unique=>true, :name=>"index_container_repository_registry_repository_id_unique", :algorithm=>:concurrently})
2117 -> 0.0021s
2118-- add_index(:container_repository_registry, :container_repository_id, {:unique=>true, :name=>"index_container_repository_registry_repository_id_unique", :algorithm=>:concurrently})
2119 -> 0.0011s
2120-- transaction_open?()
2121 -> 0.0000s
2122-- indexes(:container_repository_registry)
2123 -> 0.0023s
2124-- remove_index(:container_repository_registry, {:algorithm=>:concurrently, :name=>"index_container_repository_registry_on_repository_id"})
2125 -> 0.0010s
2126== 20210217020154 AddUniqueIndexOnContainerRepositoryRegistry: migrated (0.0119s)
2127== 20210217020156 AddUniqueIndexOnTerraformStateVersionRegistry: migrating ====
2128-- 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")
2129 -> 0.0011s
2130-- transaction_open?()
2131 -> 0.0000s
2132-- view_exists?(:postgres_partitions)
2133 -> 0.0005s
2134-- 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})
2135 -> 0.0021s
2136-- 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})
2137 -> 0.0012s
2138-- transaction_open?()
2139 -> 0.0000s
2140-- indexes(:terraform_state_version_registry)
2141 -> 0.0023s
2142-- remove_index(:terraform_state_version_registry, {:algorithm=>:concurrently, :name=>"index_tf_state_versions_registry_on_tf_state_versions_id"})
2143 -> 0.0010s
2144== 20210217020156 AddUniqueIndexOnTerraformStateVersionRegistry: migrated (0.0119s)
2145== 20210223111722 CreateGroupWikiRepositoryRegistry: migrating ================
2146-- create_table(:group_wiki_repository_registry, {:id=>:bigserial, :force=>:cascade})
2147 -> 0.0057s
2148-- transaction_open?()
2149 -> 0.0000s
2150-- current_schema()
2151 -> 0.0006s
2152-- execute("ALTER TABLE group_wiki_repository_registry\nADD CONSTRAINT check_983ee0d9c3\nCHECK ( char_length(last_sync_failure) <= 255 )\nNOT VALID;\n")
2153 -> 0.0007s
2154-- current_schema()
2155 -> 0.0003s
2156-- execute("ALTER TABLE group_wiki_repository_registry VALIDATE CONSTRAINT check_983ee0d9c3;")
2157 -> 0.0006s
2158== 20210223111722 CreateGroupWikiRepositoryRegistry: migrated (0.0128s) =======
2159== 20210225200858 AddTextLimitToLfsObjectRegistryLastSyncFailure: migrating ===
2160-- transaction_open?()
2161 -> 0.0000s
2162-- current_schema()
2163 -> 0.0004s
2164-- execute("ALTER TABLE lfs_object_registry\nADD CONSTRAINT check_c41d57c1dc\nCHECK ( char_length(last_sync_failure) <= 255 )\nNOT VALID;\n")
2165 -> 0.0008s
2166-- current_schema()
2167 -> 0.0003s
2168-- execute("ALTER TABLE lfs_object_registry VALIDATE CONSTRAINT check_c41d57c1dc;")
2169 -> 0.0007s
2170== 20210225200858 AddTextLimitToLfsObjectRegistryLastSyncFailure: migrated (0.0070s)
2171== 20210313050709 AddVerificationToSnippetRepositoryRegistry: migrating =======
2172-- add_column(:snippet_repository_registry, :verification_started_at, :datetime_with_timezone)
2173 -> 0.0012s
2174-- add_column(:snippet_repository_registry, :verified_at, :datetime_with_timezone)
2175 -> 0.0007s
2176-- add_column(:snippet_repository_registry, :verification_retry_at, :datetime_with_timezone)
2177 -> 0.0007s
2178-- add_column(:snippet_repository_registry, :verification_retry_count, :integer)
2179 -> 0.0007s
2180-- add_column(:snippet_repository_registry, :verification_state, :integer, {:limit=>2, :default=>0, :null=>false})
2181 -> 0.0010s
2182-- add_column(:snippet_repository_registry, :checksum_mismatch, :boolean)
2183 -> 0.0007s
2184-- add_column(:snippet_repository_registry, :verification_checksum, :binary)
2185 -> 0.0006s
2186-- add_column(:snippet_repository_registry, :verification_checksum_mismatched, :binary)
2187 -> 0.0006s
2188-- add_column(:snippet_repository_registry, :verification_failure, :string, {:limit=>255})
2189 -> 0.0007s
2190== 20210313050709 AddVerificationToSnippetRepositoryRegistry: migrated (0.0075s)
2191== 20210313051642 AddVerificationIndexesToSnippetRepositoryRegistry: migrating
2192-- transaction_open?()
2193 -> 0.0000s
2194-- view_exists?(:postgres_partitions)
2195 -> 0.0006s
2196-- 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})
2197 -> 0.0022s
2198-- 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})
2199 -> 0.0014s
2200-- transaction_open?()
2201 -> 0.0000s
2202-- view_exists?(:postgres_partitions)
2203 -> 0.0006s
2204-- 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})
2205 -> 0.0024s
2206-- 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})
2207 -> 0.0014s
2208-- transaction_open?()
2209 -> 0.0000s
2210-- view_exists?(:postgres_partitions)
2211 -> 0.0005s
2212-- index_exists?(:snippet_repository_registry, :verification_state, {:where=>"(state = 2 AND (verification_state IN (0, 3)))", :name=>"snippet_repository_registry_needs_verification", :algorithm=>:concurrently})
2213 -> 0.0033s
2214-- add_index(:snippet_repository_registry, :verification_state, {:where=>"(state = 2 AND (verification_state IN (0, 3)))", :name=>"snippet_repository_registry_needs_verification", :algorithm=>:concurrently})
2215 -> 0.0015s
2216== 20210313051642 AddVerificationIndexesToSnippetRepositoryRegistry: migrated (0.0211s)
2217== 20210325150435 CreatePipelineArtifactRegistry: migrating ===================
2218-- create_table(:pipeline_artifact_registry, {:id=>:bigserial, :force=>:cascade})
2219 -> 0.0089s
2220== 20210325150435 CreatePipelineArtifactRegistry: migrated (0.0090s) ==========
2221== 20210407140527 AddVerificationToTerraformStateVersionRegistry: migrating ===
2222-- add_column(:terraform_state_version_registry, :verification_started_at, :datetime_with_timezone)
2223 -> 0.0011s
2224-- add_column(:terraform_state_version_registry, :verified_at, :datetime_with_timezone)
2225 -> 0.0007s
2226-- add_column(:terraform_state_version_registry, :verification_retry_at, :datetime_with_timezone)
2227 -> 0.0006s
2228-- add_column(:terraform_state_version_registry, :verification_retry_count, :integer, {:default=>0})
2229 -> 0.0010s
2230-- add_column(:terraform_state_version_registry, :verification_state, :integer, {:limit=>2, :default=>0, :null=>false})
2231 -> 0.0010s
2232-- add_column(:terraform_state_version_registry, :checksum_mismatch, :boolean, {:default=>false, :null=>false})
2233 -> 0.0010s
2234-- add_column(:terraform_state_version_registry, :verification_checksum, :binary)
2235 -> 0.0006s
2236-- add_column(:terraform_state_version_registry, :verification_checksum_mismatched, :binary)
2237 -> 0.0007s
2238-- add_column(:terraform_state_version_registry, :verification_failure, :string, {:limit=>255})
2239 -> 0.0006s
2240== 20210407140527 AddVerificationToTerraformStateVersionRegistry: migrated (0.0075s)
2241== 20210420180119 AddIndexesToTerraformStateVersionRegistry: migrating ========
2242-- transaction_open?()
2243 -> 0.0000s
2244-- view_exists?(:postgres_partitions)
2245 -> 0.0006s
2246-- 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})
2247 -> 0.0021s
2248-- 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})
2249 -> 0.0011s
2250-- transaction_open?()
2251 -> 0.0000s
2252-- view_exists?(:postgres_partitions)
2253 -> 0.0005s
2254-- index_exists?(:terraform_state_version_registry, :retry_at, {:algorithm=>:concurrently})
2255 -> 0.0023s
2256-- index_name(:terraform_state_version_registry, :retry_at)
2257 -> 0.0000s
2258-- 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
2259-- transaction_open?()
2260 -> 0.0000s
2261-- view_exists?(:postgres_partitions)
2262 -> 0.0005s
2263-- index_exists?(:terraform_state_version_registry, :state, {:algorithm=>:concurrently})
2264 -> 0.0022s
2265-- index_name(:terraform_state_version_registry, :state)
2266 -> 0.0000s
2267-- 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
2268-- transaction_open?()
2269 -> 0.0000s
2270-- view_exists?(:postgres_partitions)
2271 -> 0.0005s
2272-- 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})
2273 -> 0.0024s
2274-- 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})
2275 -> 0.0011s
2276-- transaction_open?()
2277 -> 0.0000s
2278-- view_exists?(:postgres_partitions)
2279 -> 0.0004s
2280-- 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})
2281 -> 0.0026s
2282-- 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})
2283 -> 0.0011s
2284-- transaction_open?()
2285 -> 0.0000s
2286-- view_exists?(:postgres_partitions)
2287 -> 0.0004s
2288-- 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})
2289 -> 0.0028s
2290-- 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})
2291 -> 0.0011s
2292== 20210420180119 AddIndexesToTerraformStateVersionRegistry: migrated (0.0332s)
2293== 20210504143244 AddVerificationToMergeRequestDiffRegistry: migrating ========
2294-- column_exists?(:merge_request_diff_registry, :verification_started_at)
2295 -> 0.0017s
2296-- add_column(:merge_request_diff_registry, :verification_started_at, :datetime_with_timezone, {})
2297 -> 0.0007s
2298-- column_exists?(:merge_request_diff_registry, :verified_at)
2299 -> 0.0011s
2300-- add_column(:merge_request_diff_registry, :verified_at, :datetime_with_timezone, {})
2301 -> 0.0006s
2302-- column_exists?(:merge_request_diff_registry, :verification_retry_at)
2303 -> 0.0011s
2304-- add_column(:merge_request_diff_registry, :verification_retry_at, :datetime_with_timezone, {})
2305 -> 0.0008s
2306-- column_exists?(:merge_request_diff_registry, :verification_retry_count)
2307 -> 0.0012s
2308-- add_column(:merge_request_diff_registry, :verification_retry_count, :integer, {})
2309 -> 0.0007s
2310-- column_exists?(:merge_request_diff_registry, :verification_state)
2311 -> 0.0012s
2312-- add_column(:merge_request_diff_registry, :verification_state, :integer, {:limit=>2, :default=>0, :null=>false})
2313 -> 0.0010s
2314-- column_exists?(:merge_request_diff_registry, :checksum_mismatch)
2315 -> 0.0012s
2316-- add_column(:merge_request_diff_registry, :checksum_mismatch, :boolean, {})
2317 -> 0.0006s
2318-- column_exists?(:merge_request_diff_registry, :verification_checksum)
2319 -> 0.0012s
2320-- add_column(:merge_request_diff_registry, :verification_checksum, :binary, {})
2321 -> 0.0007s
2322-- column_exists?(:merge_request_diff_registry, :verification_checksum_mismatched)
2323 -> 0.0013s
2324-- add_column(:merge_request_diff_registry, :verification_checksum_mismatched, :binary, {})
2325 -> 0.0006s
2326-- column_exists?(:merge_request_diff_registry, :verification_failure)
2327 -> 0.0012s
2328-- add_column(:merge_request_diff_registry, :verification_failure, :string, {:limit=>255})
2329 -> 0.0006s
2330== 20210504143244 AddVerificationToMergeRequestDiffRegistry: migrated (0.0185s)
2331== 20210505170208 AddIndexesToMergeRequestDiffRegistryTable: migrating ========
2332-- transaction_open?()
2333 -> 0.0000s
2334-- indexes(:merge_request_diff_registry)
2335 -> 0.0019s
2336-- remove_index(:merge_request_diff_registry, {:algorithm=>:concurrently, :name=>"index_merge_request_diff_registry_on_mr_diff_id"})
2337 -> 0.0009s
2338-- transaction_open?()
2339 -> 0.0000s
2340-- view_exists?(:postgres_partitions)
2341 -> 0.0005s
2342-- index_exists?(:merge_request_diff_registry, :merge_request_diff_id, {:name=>"index_merge_request_diff_registry_on_mr_diff_id", :unique=>true, :algorithm=>:concurrently})
2343 -> 0.0016s
2344-- add_index(:merge_request_diff_registry, :merge_request_diff_id, {:name=>"index_merge_request_diff_registry_on_mr_diff_id", :unique=>true, :algorithm=>:concurrently})
2345 -> 0.0010s
2346-- transaction_open?()
2347 -> 0.0000s
2348-- view_exists?(:postgres_partitions)
2349 -> 0.0005s
2350-- 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})
2351 -> 0.0020s
2352-- 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})
2353 -> 0.0010s
2354-- transaction_open?()
2355 -> 0.0000s
2356-- view_exists?(:postgres_partitions)
2357 -> 0.0005s
2358-- 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})
2359 -> 0.0023s
2360-- 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})
2361 -> 0.0011s
2362-- transaction_open?()
2363 -> 0.0000s
2364-- view_exists?(:postgres_partitions)
2365 -> 0.0004s
2366-- 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})
2367 -> 0.0025s
2368-- 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})
2369 -> 0.0011s
2370== 20210505170208 AddIndexesToMergeRequestDiffRegistryTable: migrated (0.0264s)
2371== 20210624160455 FixStateColumnInLfsObjectRegistry: migrating ================
2372-- transaction_open?()
2373 -> 0.0001s
2374-- exec_query("SELECT COUNT(*) AS count FROM \"lfs_object_registry\" WHERE \"lfs_object_registry\".\"success\" = TRUE")
2375 -> 0.0008s
2376== 20210624160455 FixStateColumnInLfsObjectRegistry: migrated (0.0013s) =======
2377== 20210706120644 PrepareFileRegistryForSsf: migrating ========================
2378-- change_column_default(:file_registry, :retry_count, {:from=>nil, :to=>0})
2379 -> 0.0023s
2380-- add_column(:file_registry, :state, :integer, {:null=>false, :limit=>2, :default=>0})
2381 -> 0.0011s
2382-- add_column(:file_registry, :last_synced_at, :datetime_with_timezone)
2383 -> 0.0006s
2384-- add_column(:file_registry, :last_sync_failure, :string, {:limit=>255})
2385 -> 0.0006s
2386== 20210706120644 PrepareFileRegistryForSsf: migrated (0.0048s) ===============
2387== 20210818111211 FixStateColumnInFileRegistry: migrating =====================
2388-- transaction_open?()
2389 -> 0.0000s
2390-- exec_query("SELECT COUNT(*) AS count FROM \"file_registry\" WHERE \"file_registry\".\"success\" = TRUE")
2391 -> 0.0007s
2392== 20210818111211 FixStateColumnInFileRegistry: migrated (0.0012s) ============
2393== 20210820152707 CreatePagesDeploymentRegistry: migrating ====================
2394-- create_table(:pages_deployment_registry, {:id=>:bigserial, :force=>:cascade})
2395 -> 0.0048s
2396== 20210820152707 CreatePagesDeploymentRegistry: migrated (0.0049s) ===========
2397geo: == 20211021112221 RemoveUploadLegacyFields: migrating =========================
2398geo: -- remove_column(:file_registry, :file_type, :string, {:null=>false})
2399geo: -> 0.0011s
2400geo: -- remove_column(:file_registry, :success, :boolean, {:null=>false})
2401geo: -> 0.0008s
2402geo: -- remove_column(:file_registry, :bytes, :integer)
2403geo: -> 0.0006s
2404geo: -- remove_column(:file_registry, :sha256, :string)
2405geo: -> 0.0006s
2406geo: == 20211021112221 RemoveUploadLegacyFields: migrated (0.0032s) ================
2407geo: == 20211101113611 PrepareFileRegistryForVerification: migrating ===============
2408geo: -- add_column(:file_registry, :verified_at, :datetime_with_timezone)
2409geo: -> 0.0007s
2410geo: -- add_column(:file_registry, :verification_started_at, :datetime_with_timezone)
2411geo: -> 0.0007s
2412geo: -- add_column(:file_registry, :verification_retry_at, :datetime_with_timezone)
2413geo: -> 0.0006s
2414geo: -- add_column(:file_registry, :verification_state, :integer, {:default=>0, :null=>false, :limit=>2})
2415geo: -> 0.0012s
2416geo: -- add_column(:file_registry, :verification_retry_count, :integer, {:default=>0, :limit=>2, :null=>false})
2417geo: -> 0.0009s
2418geo: -- add_column(:file_registry, :verification_checksum, :binary)
2419geo: -> 0.0006s
2420geo: -- add_column(:file_registry, :verification_checksum_mismatched, :binary)
2421geo: -> 0.0006s
2422geo: -- add_column(:file_registry, :checksum_mismatch, :boolean, {:default=>false, :null=>false})
2423geo: -> 0.0009s
2424geo: -- add_column(:file_registry, :verification_failure, :text)
2425geo: -> 0.0006s
2426geo: == 20211101113611 PrepareFileRegistryForVerification: migrated (0.0075s) ======
2427geo: == 20211102121712 CreateFileRegistryVerificationIndexies: migrating ===========
2428geo: -- transaction_open?()
2429geo: -> 0.0000s
2430geo: -- view_exists?(:postgres_partitions)
2431geo: -> 0.0008s
2432geo: -- index_exists?(:file_registry, :verification_retry_at, {:name=>:file_registry_failed_verification, :order=>"NULLS FIRST", :where=>"((state = 2) AND (verification_state = 3))", :algorithm=>:concurrently})
2433geo: -> 0.0015s
2434geo: -- add_index(:file_registry, :verification_retry_at, {:name=>:file_registry_failed_verification, :order=>"NULLS FIRST", :where=>"((state = 2) AND (verification_state = 3))", :algorithm=>:concurrently})
2435geo: -> 0.0014s
2436geo: -- transaction_open?()
2437geo: -> 0.0000s
2438geo: -- view_exists?(:postgres_partitions)
2439geo: -> 0.0005s
2440geo: -- index_exists?(:file_registry, :verification_state, {:name=>:file_registry_needs_verification, :where=>"((state = 2) AND (verification_state = ANY (ARRAY[0, 3])))", :algorithm=>:concurrently})
2441geo: -> 0.0019s
2442geo: -- add_index(:file_registry, :verification_state, {:name=>:file_registry_needs_verification, :where=>"((state = 2) AND (verification_state = ANY (ARRAY[0, 3])))", :algorithm=>:concurrently})
2443geo: -> 0.0013s
2444geo: -- transaction_open?()
2445geo: -> 0.0000s
2446geo: -- view_exists?(:postgres_partitions)
2447geo: -> 0.0005s
2448geo: -- index_exists?(:file_registry, :verified_at, {:name=>:file_registry_pending_verification, :order=>"NULLS FIRST", :where=>"((state = 2) AND (verification_state = 0))", :algorithm=>:concurrently})
2449geo: -> 0.0021s
2450geo: -- add_index(:file_registry, :verified_at, {:name=>:file_registry_pending_verification, :order=>"NULLS FIRST", :where=>"((state = 2) AND (verification_state = 0))", :algorithm=>:concurrently})
2451geo: -> 0.0014s
2452geo: == 20211102121712 CreateFileRegistryVerificationIndexies: migrated (0.0183s) ==
2453geo: == 20211119152539 AddVerificationToPagesDeploymentRegistry: migrating =========
2454geo: -- add_column(:pages_deployment_registry, :verification_started_at, :datetime_with_timezone)
2455geo: -> 0.0008s
2456geo: -- add_column(:pages_deployment_registry, :verified_at, :datetime_with_timezone)
2457geo: -> 0.0006s
2458geo: -- add_column(:pages_deployment_registry, :verification_retry_at, :datetime_with_timezone)
2459geo: -> 0.0006s
2460geo: -- add_column(:pages_deployment_registry, :verification_retry_count, :integer, {:default=>0, :limit=>2, :null=>false})
2461geo: -> 0.0010s
2462geo: -- add_column(:pages_deployment_registry, :verification_state, :integer, {:limit=>2, :default=>0, :null=>false})
2463geo: -> 0.0010s
2464geo: -- add_column(:pages_deployment_registry, :checksum_mismatch, :boolean, {:default=>false, :null=>false})
2465geo: -> 0.0010s
2466geo: -- add_column(:pages_deployment_registry, :verification_checksum, :binary)
2467geo: -> 0.0011s
2468geo: -- add_column(:pages_deployment_registry, :verification_checksum_mismatched, :binary)
2469geo: -> 0.0008s
2470geo: -- add_column(:pages_deployment_registry, :verification_failure, :text)
2471geo: -> 0.0006s
2472geo: == 20211119152539 AddVerificationToPagesDeploymentRegistry: migrated (0.0081s)
2473geo: == 20211124000000 AddVerificationToLfsObjectRegistry: migrating ===============
2474geo: -- add_column(:lfs_object_registry, :verification_started_at, :datetime_with_timezone)
2475geo: -> 0.0007s
2476geo: -- add_column(:lfs_object_registry, :verified_at, :datetime_with_timezone)
2477geo: -> 0.0007s
2478geo: -- add_column(:lfs_object_registry, :verification_retry_at, :datetime_with_timezone)
2479geo: -> 0.0007s
2480geo: -- add_column(:lfs_object_registry, :verification_retry_count, :integer, {:default=>0})
2481geo: -> 0.0010s
2482geo: -- add_column(:lfs_object_registry, :verification_state, :integer, {:limit=>2, :default=>0, :null=>false})
2483geo: -> 0.0010s
2484geo: -- add_column(:lfs_object_registry, :checksum_mismatch, :boolean, {:default=>false, :null=>false})
2485geo: -> 0.0010s
2486geo: -- add_column(:lfs_object_registry, :verification_checksum, :binary)
2487geo: -> 0.0008s
2488geo: -- add_column(:lfs_object_registry, :verification_checksum_mismatched, :binary)
2489geo: -> 0.0006s
2490geo: -- add_column(:lfs_object_registry, :verification_failure, :text)
2491geo: -> 0.0006s
2492geo: == 20211124000000 AddVerificationToLfsObjectRegistry: migrated (0.0077s) ======
2493geo: == 20211124000001 AddTextLimitToLfsObjectRegistryVerificationFailure: migrating
2494geo: -- transaction_open?()
2495geo: -> 0.0000s
2496geo: -- current_schema()
2497geo: -> 0.0004s
2498geo: -- transaction_open?()
2499geo: -> 0.0000s
2500geo: -- execute("ALTER TABLE lfs_object_registry\nADD CONSTRAINT check_8bcaa12138\nCHECK ( char_length(verification_failure) <= 255 )\nNOT VALID;\n")
2501geo: -> 0.0007s
2502geo: -- current_schema()
2503geo: -> 0.0003s
2504geo: -- execute("ALTER TABLE lfs_object_registry VALIDATE CONSTRAINT check_8bcaa12138;")
2505geo: -> 0.0007s
2506geo: == 20211124000001 AddTextLimitToLfsObjectRegistryVerificationFailure: migrated (0.0071s)
2507geo: == 20211124000002 AddIndexesToLfsObjectRegistry: migrating ====================
2508geo: -- transaction_open?()
2509geo: -> 0.0000s
2510geo: -- view_exists?(:postgres_partitions)
2511geo: -> 0.0012s
2512geo: -- index_exists?(:lfs_object_registry, :lfs_object_id, {:name=>"index_lfs_object_registry_on_lfs_object_id", :unique=>true, :algorithm=>:concurrently})
2513geo: -> 0.0026s
2514geo: -- 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
2515geo: -- transaction_open?()
2516geo: -> 0.0000s
2517geo: -- view_exists?(:postgres_partitions)
2518geo: -> 0.0005s
2519geo: -- 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})
2520geo: -> 0.0023s
2521geo: -- 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})
2522geo: -> 0.0013s
2523geo: -- transaction_open?()
2524geo: -> 0.0000s
2525geo: -- view_exists?(:postgres_partitions)
2526geo: -> 0.0006s
2527geo: -- 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})
2528geo: -> 0.0026s
2529geo: -- 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})
2530geo: -> 0.0013s
2531geo: -- transaction_open?()
2532geo: -> 0.0000s
2533geo: -- view_exists?(:postgres_partitions)
2534geo: -> 0.0005s
2535geo: -- 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})
2536geo: -> 0.0032s
2537geo: -- 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})
2538geo: -> 0.0014s
2539geo: == 20211124000002 AddIndexesToLfsObjectRegistry: migrated (0.0286s) ===========
2540geo: == 20211126312431 AddTextLimitToFileRegistryVerificationFailure: migrating ====
2541geo: -- transaction_open?()
2542geo: -> 0.0000s
2543geo: -- current_schema()
2544geo: -> 0.0004s
2545geo: -- transaction_open?()
2546geo: -> 0.0000s
2547geo: -- execute("ALTER TABLE file_registry\nADD CONSTRAINT check_1886652634\nCHECK ( char_length(verification_failure) <= 256 )\nNOT VALID;\n")
2548geo: -> 0.0008s
2549geo: -- current_schema()
2550geo: -> 0.0003s
2551geo: -- execute("ALTER TABLE file_registry VALIDATE CONSTRAINT check_1886652634;")
2552geo: -> 0.0006s
2553geo: == 20211126312431 AddTextLimitToFileRegistryVerificationFailure: migrated (0.0068s)
2554geo: == 20211207162157 AddIndexesToPagesDeploymentRegistry: migrating ==============
2555geo: -- transaction_open?()
2556geo: -> 0.0000s
2557geo: -- view_exists?(:postgres_partitions)
2558geo: -> 0.0006s
2559geo: -- index_exists?(:pages_deployment_registry, :pages_deployment_id, {:name=>"index_pages_deployment_registry_on_pages_deployment_id", :unique=>true, :algorithm=>:concurrently})
2560geo: -> 0.0022s
2561geo: -- 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
2562geo: -- transaction_open?()
2563geo: -> 0.0000s
2564geo: -- view_exists?(:postgres_partitions)
2565geo: -> 0.0006s
2566geo: -- 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})
2567geo: -> 0.0021s
2568geo: -- 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})
2569geo: -> 0.0013s
2570geo: -- transaction_open?()
2571geo: -> 0.0000s
2572geo: -- view_exists?(:postgres_partitions)
2573geo: -> 0.0012s
2574geo: -- 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})
2575geo: -> 0.0027s
2576geo: -- 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})
2577geo: -> 0.0014s
2578geo: -- transaction_open?()
2579geo: -> 0.0000s
2580geo: -- view_exists?(:postgres_partitions)
2581geo: -> 0.0005s
2582geo: -- 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})
2583geo: -> 0.0025s
2584geo: -- 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})
2585geo: -> 0.0011s
2586geo: == 20211207162157 AddIndexesToPagesDeploymentRegistry: migrated (0.0250s) =====
2587geo: == 20211207175940 AddTextLimitToPagesDeploymentRegistryVerificationFailure: migrating
2588geo: -- transaction_open?()
2589geo: -> 0.0000s
2590geo: -- current_schema()
2591geo: -> 0.0003s
2592geo: -- transaction_open?()
2593geo: -> 0.0000s
2594geo: -- execute("ALTER TABLE pages_deployment_registry\nADD CONSTRAINT check_7eb0430eff\nCHECK ( char_length(verification_failure) <= 255 )\nNOT VALID;\n")
2595geo: -> 0.0007s
2596geo: -- current_schema()
2597geo: -> 0.0003s
2598geo: -- execute("ALTER TABLE pages_deployment_registry VALIDATE CONSTRAINT check_7eb0430eff;")
2599geo: -> 0.0007s
2600geo: == 20211207175940 AddTextLimitToPagesDeploymentRegistryVerificationFailure: migrated (0.0067s)
2601geo: == 20220202101354 MigrateJobArtifactRegistry: migrating =======================
2602geo: -- transaction_open?()
2603geo: -> 0.0000s
2604geo: -- Scheduled 0 MigrateJobArtifactRegistryToSsf jobs with a maximum of 5000 records per batch and an interval of 120 seconds.
2605The migration is expected to take at least 0 seconds. Expect all jobs to have completed after 2022-11-04 14:15:32 UTC."
2606geo: == 20220202101354 MigrateJobArtifactRegistry: migrated (0.0278s) ==============
2607geo: == 20220617125507 CreateCiSecureFileRegistry: migrating =======================
2608geo: -- create_table(:ci_secure_file_registry, {:id=>:bigserial, :force=>:cascade})
2609geo: -- quote_column_name(:verification_failure)
2610geo: -> 0.0000s
2611geo: -- quote_column_name(:last_sync_failure)
2612geo: -> 0.0000s
2613geo: -> 0.0118s
2614geo: == 20220617125507 CreateCiSecureFileRegistry: migrated (0.0129s) ==============
2615geo: == 20221017195204 CreateProjectWikiRepositoryRegistry: migrating ==============
2616geo: -- create_table(:project_wiki_repository_registry, {:id=>:bigserial, :force=>:cascade})
2617geo: -- quote_column_name(:verification_failure)
2618geo: -> 0.0000s
2619geo: -- quote_column_name(:last_sync_failure)
2620geo: -> 0.0000s
2621geo: -> 0.0132s
2622geo: == 20221017195204 CreateProjectWikiRepositoryRegistry: migrated (0.0135s) =====
2623 Saving cache for successful job 00:00
2624Not uploading cache ruby-gems-debian-bullseye-ruby-2.7-16 due to policy
2625Not uploading cache gitaly-ruby-gems-debian-bullseye-ruby-2.7-16 due to policy
2626 Cleaning up project directory and file based variables 00:01
2627Job succeeded