Geo replicates pages deployments with SSF [RUN ALL RSPEC] [RUN AS-IF-FOSS]
What does this MR do?
Adds Geo replication and verification using the Geo self-service framework.
Closes #331931 (closed)
Similar MRs for reference:
- Resolve "Migrate lfs_object_registry to use Geo::ReplicableRegistry"
- Add LFS object replication using SSF
- Add geo database changes for pipeline artifact replication
- Add pipeline artifact replication to geo
Screenshots or Screencasts (strongly suggested)
Checksum progress
Sync and verification progress
Does this MR meet the acceptance criteria?
Conformity
-
I have included changelog trailers, or none are needed. (Does this MR need a changelog?) -
I have added/updated documentation, or it's not needed. (Is documentation required?) -
I have properly separated EE content from FOSS, or this MR is FOSS only. (Where should EE code go?) -
I have added information for database reviewers in the MR description, or it's not needed. (Does this MR have database related changes?) -
I have self-reviewed this MR per code review guidelines. -
This MR does not harm performance, or I have asked a reviewer to help assess the performance impact. (Merge request performance guidelines) -
I have followed the style guides. -
This change is backwards compatible across updates, or this does not apply.
Availability and Testing
-
I have added/updated tests following the Testing Guide, or it's not needed. (Consider all test levels. See the Test Planning Process.) -
I have tested this MR in all supported browsers, or it's not needed. -
I have informed the Infrastructure department of a default or new setting change per definition of done, or it's not needed.
Manual Testing
-
Pages deployments are replicated -
Pages deployments checksummed on the primary -
Pages deployments are verified -
The correct pages deployments are replicated when selective sync enabled -
Pages deployments status shown on the Admin Dashboard -
When object storage is used and Geo object storage replication enabled -
When secondary uses object storage, can access pages deployments on a secondary
Database Review
`rake db:migrate`
== 20210709163840 AddVerificationStateToPagesDeployments: migrating ===========
-- change_table(:pages_deployments)
-> 0.0114s
== 20210709163840 AddVerificationStateToPagesDeployments: migrated (0.0115s) ==== 20210709164233 AddVerificationFailureLimitToPagesDeployments: migrating ====
-- transaction_open?()
-> 0.0000s
-- current_schema()
-> 0.0004s
-- execute("ALTER TABLE pages_deployments\nADD CONSTRAINT pages_deployments_verification_failure_text_limit\nCHECK ( char_length(verification_failure) <= 255 )\nNOT VALID;\n")
-> 0.0017s
-- current_schema()
-> 0.0004s
-- execute("SET statement_timeout TO 0")
-> 0.0008s
-- execute("ALTER TABLE pages_deployments VALIDATE CONSTRAINT pages_deployments_verification_failure_text_limit;")
-> 0.0016s
-- execute("RESET ALL")
-> 0.0009s
== 20210709164233 AddVerificationFailureLimitToPagesDeployments: migrated (0.0204s) up 20200910131217 Tmp index for fixing inconsistent vulnerability occurrences
up 20200910131218 Remove duplicated cs findings
up 20200910155617 Backfill jira tracker deployment type
up 20200910170908 Ensure filled external diff store on merge request diffs
up 20200910175553 Validate not null external diff store on merge request diffs
up 20200911120132 Create pages deployments
up 20200911121027 Add pages deployment project foreign key
up 20200911121048 Add pages deployment ci build foreign key
up 20200912152943 Rename admin notification email application setting
up 20200912153218 Cleanup admin notification email application setting rename
up 20200912193210 Add scheduling issues temp indexes
up 20200913115700 Add kroki application settings
up 20200914070140 Add expiration policy started at to container repositories
up 20200914091326 Change build pending state enums
up 20200914104642 Modify merge request api index
up 20200914105202 Remove old merge request api index
up 20200914155135 Add deduplicated flag into security findings table
up 20200914183227 Add index on deduplicated column of security findings
up 20200914184212 Remove index on security findings scan
up 20200915044225 Schedule migration to hashed storage
up 20200915134004 Add indices to approval project rules
up 20200915152641 Add verification state to terraform state version
up 20200915164448 Add verification failure limit to terraform state version
up 20200915164844 Add verification failure index to terraform state version
up 20200915185707 Ensure filled file store on package files
up 20200915191156 Validate not null file store on package files
up 20200916081749 Remove cycle analytics total stage data
up 20200916120837 Add index to members for unaccepted invitations
up 20200916135044 Add state id index to merge requests
up 20200916151442 Add result index to authentication events
up 20200916165232 Add debian max file size to plan limits
up 20200917121650 Add help page documentation url to application settings
up 20200917135802 Remove duplicated cs findings without vulnerability
up 20200917165525 Update index on namespaces for type and
up 20200919200318 Add default branch name to namespace settings
up 20200919204155 Add text limit to namespace settings default branch name
up 20200920130356 Add container expiration policy worker settings to application settings
up 20200921093826 Add index to user preferences
up 20200921113722 Add text limit to help page documentation url
up 20200921130028 Add pages deployment id to pages metadata
up 20200921131313 Add foreign key to pages deployment id in project pages metadata
up 20200921203231 Remove duplicate cluster agents index
up 20200922052316 Create issue email participants
up 20200922054642 Drop snowplow iglu registry url from application settings
up 20200922075244 Add compliance framework model
up 20200922093004 Add postgres index view
up 20200922095954 Remove instance statistics visibility private from application settings
up 20200922133949 Create bulk import
up 20200922170907 Change index on pipeline status
up 20200922231755 Remove created by user id from cluster providers aws
up 20200923071622 Add description to requirements
up 20200923071644 Add text limit to requirements description
up 20200923102312 Update programming language colors
up 20200923130057 Remove tmp container scanning index
up 20200923140404 Add postgres reindex actions table
up 20200924035825 Add options to dast scanner profile
up 20200925112104 Create bulk import configurations
up 20200925114522 Create bulk import entities
up 20200925125321 Add u2f id to webauthn registration
up 20200925153423 Add bulk import foreign key to bulk import entities
up 20200925193815 Add parent foreign key to bulk import entities
up 20200925193906 Add namespace foreign key to bulk import entities
up 20200925194006 Add project foreign key to bulk import entities
up 20200927224750 Add incident issue type index to issues
up 20200928095732 Add state to dast site validation
up 20200928100408 Add text limit to dast site validation state
up 20200928123510 Add expiration policy cleanup status to container repositories
up 20200928125258 Add foreign key to u2f reg id in webauthn regs
up 20200928131934 Create required code owners sections
up 20200928164807 Add index on vulnerabilities state case
up 20200928203531 Create alert management http integrations
up 20200928210524 Add http integrations project foreign key
up 20200928233632 Remove terraform state verification indexes
up 20200929032729 Add sla minutes to project incident management settings
up 20200929052138 Create initial versions for pre versioning terraform states
up 20200929063159 Add require admin approval after user signup to application settings
up 20200929113254 Remove type from audit events
up 20200929114107 Schedule migrate u2f webauthn
up 20200930094812 Update postgres indexes view
up 20200930131343 Add index on project id and sha to deployments
up 20200930132319 Add api fuzzing to plan limits
up 20200930144340 Set job waiter ttl
up 20201001022100 Validate designs filename text limit
up 20201001101136 Remove index on issues relative position
up 20201002012659 Add issuable sla table
up 20201002094617 Remove container scanning report type index
up 20201002175953 Add index for merged merge requests
up 20201004163918 Remove project id and id index from vulnerabilities table
up 20201005092703 Add namespace column to frameworks
up 20201005092709 Remove compliance frameworks group id fk
up 20201005092753 Add framework id to project framework settings
up 20201005094331 Migrate compliance framework enum to database framework record
up 20201005153955 Add not null constraint to compliance project settings
up 20201006014605 Add automatic purchased storage allocation to application settings
up 20201007033527 Add daily invites to plan limits
up 20201007033723 Insert daily invites plan limits
up 20201007115209 Add lock version to ci build trace chunk
up 20201008011523 Add ci jwt signing key to application settings
up 20201008011937 Add text limit to application settings encrypted ci jwt signing key iv
up 20201008013434 Generate ci jwt signing key
up 20201008075620 Add releases events to web hooks
up 20201008125643 Create csv issue imports
up 20201008144854 Set regex defaults on container expiration policies
up 20201008224441 Add position into security findings
up 20201009090954 Add index with project id to container expiration policies
up 20201011005400 Add text limit to application settings kroki url
up 20201012073022 Remove not null constraint on framework
up 20201012122428 Add container registry expiration policies worker capacity constraint
up 20201012134230 Create ci test cases
up 20201012135330 Create ci test case failures
up 20201012140110 Add projects fk to ci test cases
up 20201012140452 Add ci builds fk to ci test case failures
up 20201012194936 Create saml group links
up 20201014142521 Schedule sync blocking issues count
up 20201014163633 Specify primary key where missing
up 20201014205300 Drop backfill jira tracker deployment type jobs
up 20201015073808 Schedule blocked by links replacement
up 20201015121805 Add project foreign key to csv issue imports
up 20201015121825 Add user foreign key to csv issue imports
up 20201015154527 Add index on services for usage data
up 20201015194852 Add index on state for dast site validations
up 20201015231049 Add ci build id to terraform state versions
up 20201016074302 Add index project id and id to container repositories
up 20201019091307 Add unique index on scan id and position of security findings
up 20201019094741 Rename sitemap root namespaces
up 20201019101549 Add es custom analyzers settings
up 20201019111952 Add sha256 and filecount to pages deployments
up 20201019113009 Add new user signups cap to application settings
up 20201019130244 Remove license compliance temp index
up 20201019152046 Add default branch to daily build group report result
up 20201019161924 Add partitioned table view
up 20201019172704 Add partitions view
up 20201020102551 Remove index service for usage data
up 20201021085007 Create analytics devops adoption segments
up 20201021101956 Add index route on name trigram to route
up 20201021102554 Create analytics devops adoption segment selections
up 20201021105347 Add foreign key project id to segment selection
up 20201021105600 Add foreign key group id to segment selection
up 20201021105959 Add check constraint to segment selection
up 20201021142812 Add index to ci daily build group report results
up 20201021152210 Add secret detection token revocation application settings
up 20201021155606 Add analytics access level to project features
up 20201021190539 Add text limit to secret detection token revocation application settings
up 20201021220101 Add merge trains enabled
up 20201022080802 Add repository read only to snippets
up 20201022094845 Add historical data recorded at
up 20201022094846 Update historical data recorded at
up 20201022103304 Add availability to user statuses
up 20201022144501 Create snippet repository storage move
up 20201022191817 Add has vulnerabilities into project settings
up 20201022192254 Index project settings on project id partially
up 20201023114628 Create merge request cleanup schedules
up 20201026051643 Remove scanned resources count from security scans
up 20201026182253 Schedule populate vulnerability feedback pipeline
up 20201026185514 Ensure u2f registrations migrated
up 20201026200736 Seed merge trains enabled
up 20201027002551 Migrate services to http integrations
up 20201027101010 Create user follow users
up 20201027135651 Add auto rollback setting
up 20201027210127 Add index to oauth access grants resource owner
up 20201027211138 Increase default diff max patch bytes
up 20201028160831 Add temporary index to vulnerabilities table
up 20201028160832 Schedule populate missing dismissal information for vulnerabilities
up 20201028182809 Backfill jira tracker deployment type2
up 20201028184640 Add helm major version to clusters
up 20201028204306 Migrate default diff max patch bytes to minimum 200kb
up 20201029052241 Migrate geo blob verification primary worker sidekiq queue
up 20201029143650 Rename application settings to allow deny names
up 20201029144157 Cleanup application settings to allow deny rename
up 20201029144444 Create vulnerability finding links
up 20201029144524 Add index to releases
up 20201030092151 Add requirements access level to project features
up 20201030121314 Schedule update existing users that require two factor auth
up 20201030200115 Add iid to design management design
up 20201030200539 Add index on design management designs iid project
up 20201030203854 Backfill design iids
up 20201030223933 Add ci pipeline deployments to plan limits
up 20201102073808 Schedule blocked by links replacement second try
up 20201102112206 Rename sitemap namespace
up 20201102114018 Remove storage size limit from application settings
up 20201102152554 Add not null check on iid on design manangement designs
up 20201102152945 Truncate security findings table
up 20201102184743 Add index to incident issues on project and created at
up 20201103013242 Remove terraform state verification columns
up 20201103045515 Add issuable metric images
up 20201103095752 Add issues closed at index
up 20201103110018 Schedule merge request cleanup schedules backfill
up 20201103171537 Add index active billable users to user
up 20201103184333 Create packages package file build infos
up 20201103192526 Schedule populate has vulnerabilities
up 20201103202213 Update packages build infos index
up 20201104124300 Ensure namespace settings creation
up 20201104142036 Add index to merge request metrics target project
up 20201104204739 Create bulk import trackers
up 20201105021637 Add uploads size to project statistics
up 20201105024127 Add uploads size to namespace root storage statistics
up 20201105135051 Change default value of ci max artifact size lsif of plan limits from20 to100
up 20201105143211 Add vulnerabilities enabled and issuetype to jira tracker data
up 20201105143312 Add text limit to jira tracker data issuetype
up 20201106082723 Add merge request jira reference indexes
up 20201106134139 Add pipelines created index
up 20201106134950 Deduplicate epic iids
up 20201106135608 Remove redundant pipelines index
up 20201106193452 Add converted at to experiment users
up 20201107032257 Add default true require admin approval after user signup to application settings
up 20201108134919 Add finding fingerprint table
up 20201109080645 Create vulnerability remediations table
up 20201109080646 Create vulnerability findings remediations join table
up 20201109114603 Schedule remove inaccessible epic todos
up 20201109144634 Add region field to aws role
up 20201109180311 Add secret detection revocation token types application settings
up 20201109184023 Add text limit to secret detection revocation token types application settings
up 20201110035029 Created index for vulnerability occurrences on project fingerprint
up 20201110110454 Extend postgres indexes view
up 20201110133629 Change index mr metrics target project
up 20201110161542 Cleanup transfered projects shared runners
up 20201110221400 Create experiment subjects
up 20201111051655 Add foreign key to experiment subjects on user
up 20201111051847 Add foreign key to experiment subjects on group
up 20201111051904 Add foreign key to experiment subjects on project
up 20201111100136 Create analytics devops adoption snapshots
up 20201111110318 Add cloud license auth token to settings
up 20201111110918 Add cloud license auth token application settings text limit
up 20201111115414 Create incident management oncall schedules
up 20201111145317 Add relation to indexes view
up 20201111152859 Add missing expression indexes
up 20201112130710 Schedule remove duplicate vulnerabilities findings
up 20201112130715 Schedule recalculate uuid on vulnerabilities occurrences
up 20201112132808 Create bulk import failures
up 20201112145311 Add index on sha for initial deployments
up 20201112173532 Add verification state to package files
up 20201112173911 Add index on verification state on package files
up 20201112195322 Reseed merge trains enabled
up 20201112215028 Add partitioned audit event indexes
up 20201112215132 Swap partitioned audit events
up 20201113105000 Update index secure for api fuzzing telemetry
up 20201116090328 Add regulated to compliance frameworks
up 20201116211829 Create user permission export uploads
up 20201117054609 Add cloud license enabled to settings
up 20201117075742 Change webauthn xid length
up 20201117153333 Add index on package size and project id to project statistics
up 20201117184334 Add index to project repositories shard id project
up 20201117203224 Add iteration id to boards table
up 20201117213024 Add iteration id index to boards table
up 20201118093135 Create namespace onboarding actions
up 20201119031515 Add iteration id to lists
up 20201119053603 Add iteration lists foreign key
up 20201119092319 Schedule repopulate historical vulnerability statistics
up 20201119125730 Add web hooks service foreign key
up 20201119133534 Add personal access token prefix to application setting
up 20201119133604 Add text limit to application setting personal access token prefix
up 20201119162801 Change services inherit from id foreign key
up 20201119164605 Add checksum into vulnerability remediations
up 20201119213406 Change terraform versioning enabled default
up 20201120071303 Drop feature filter type from user preferences
up 20201120092000 Add kroki formats to application settings table
up 20201120125953 Replace unused labels index
up 20201120140210 Add runner id and id desc index to ci builds
up 20201120144823 Create tokens with iv
up 20201123081307 Add operations project feature to metrics
up 20201123161611 Add provisioned by group to user details
up 20201124030537 Create incident management on call rotations
up 20201124075951 Create vulnerability external links
up 20201124122817 Populate remaining missing dismissal information for vulnerabilities
up 20201124185639 Remove unused indexes
up 20201125030847 Create dependency proxy manifests
up 20201125233219 Add incident management on call participants
up 20201126165919 Add epic boards
up 20201126172030 Add feed token off to settings
up 20201126190039 Add epic board labels
up 20201127104228 Add index to security scans on created at and
up 20201127141433 Add other role to user details
up 20201127170848 Add index bloat estimate view
up 20201128210000 Add service desk reply to is not null index on issues fix
up 20201128210234 Schedule populate issue email participants
up 20201130103926 Schedule populate dismissed state for vulnerabilities
up 20201201033202 Add verification indexes for package files
up 20201201034258 Add index for non system noteables
up 20201201161655 Add primary key to elastic search indexed projects
up 20201201163227 Add finding uuid to vulnerability feedback
up 20201201175656 Add index vulnerabilities on project id and state and severity
up 20201201190002 Add other context to experiment user
up 20201201192112 Add primary key to elastic search indexed namespaces
up 20201202003042 Add epic board positions
up 20201202025644 Add column to security findings
up 20201202025937 Add index to security findings uuid
up 20201202133606 Add sorted to merge request diffs
up 20201202142751 Drop index vulnerabilities on project
up 20201202150001 Add details to vulnerability findings
up 20201202155913 Add primary key to merge request context commit diff files
up 20201202160105 Add group file name index to dependency proxy manifests
up 20201202161021 Remove redundant index on merge request context commit diff files
up 20201203123201 Remove orphan service hooks
up 20201203123524 Add domain enum to alerts
up 20201203144655 Add allow to edit commit to project settings
up 20201203171631 Add index to domain
up 20201204085522 Add project id into vulnerability remediations
up 20201204090855 Add compound index to vulnerability remediations table
up 20201204105300 Create packages debian file metadata
up 20201204110700 Create packages debian project distributions
up 20201204110800 Create packages debian group distributions
up 20201204111000 Create packages debian project architectures
up 20201204111100 Create packages debian group architectures
up 20201204111200 Create packages debian project components
up 20201204111300 Create packages debian group components
up 20201204111400 Create packages debian project component files
up 20201204111500 Create packages debian group component files
up 20201204111600 Create packages debian publications
up 20201204141038 Add trace bytesize to ci build pending states
up 20201204193952 Keep latest artifact project level
up 20201204205814 Add member events to web hooks
up 20201204215353 Add pull mirror interval to plan limits
up 20201207151651 Truncate security findings table 2
up 20201207165956 Remove duplicate services
up 20201208081429 Update internal ids last value for epics renamed
up 20201208143911 Add approvals created at index
up 20201208175117 Schedule backfilling artifact expiry migration
up 20201208181411 Remove temporary blocking issues index
up 20201208210209 Create incident management oncall shifts
up 20201209154746 Expand ci pipelines index on ci ref
up 20201209163113 Recreate index issue email participants on issue id and email
up 20201209163958 Add code challenge to oauth access grants
up 20201209193551 Add version sha cache to composer metadata
up 20201210101250 Add index projects on import type and creator
up 20201210175044 Add index to snippet on project
up 20201211042306 Add deployments finder by finished at index
up 20201211090634 Schedule populate finding uuid for vulnerability feedback
up 20201211145950 Add bloat estimate to reindex action
up 20201214000000 Change mr allow maintainer to push default
up 20201214032220 Add has external wiki trigger
up 20201214084105 Add expiration policy completed at to container repositories
up 20201214111858 Add container registry cleanup tags service max list size to application settings
up 20201214112752 Add app settings container reg cleanup tags service max list size constraint
up 20201214113729 Add custom mapping columns to http integrations
up 20201214184020 Add epic board list
up 20201215084652 Delete mock deployment service records
up 20201215132151 Change unique index on security findings
up 20201215205404 Create namespace package settings
up 20201216151616 Add squash commit sha index
up 20201216154457 Add devops adoption snapshot range end
up 20201216185336 Add devops adoption snapshot not null
up 20201217070530 Add group merge request approval settings
up 20201217111448 Change pages deployment size to bigint
up 20201217112249 Change pages deployment size to bigint cleanup
up 20201217132603 Create elastic reindexing subtasks
up 20201218194311 Create admin notes
up 20201221124036 Add devops snapshot index
up 20201221213415 Change clusters helm major version default to 3
up 20201221225303 Add service desk reply to is not null index on issues
up 20201222151823 Update trusted apps to confidential
up 20201223012231 Reindex ci pipelines on schedule id and
up 20201223114050 Add restrict user defined variables to project settings
up 20201224144948 Migrate coverage report worker
up 20201228110136 Create iterations cadence
up 20201228110238 Add iterations cadence to sprints
up 20201228184500 Add dismissal reason into vulnerability feedback table
up 20201229105948 Add invisible captcha enabled to settings
up 20201230161206 Add rate limiting response text to application settings
up 20201230180202 Create onboarding progress
up 20201231133921 Schedule set default iteration cadences
up 20210101110640 Set limit for rate limiting response text
up 20210102164121 Drop temporary index on ci builds
up 20210104163218 Add epic board position index
up 20210105030125 Cleanup projects with bad has external wiki data
up 20210105052034 Rename asset proxy whitelist on application settings
up 20210105052229 Clean up asset proxy whitelist rename on application settings
up 20210105103649 Delete column group id on compliance framework
up 20210105153342 Add entity columns to vulnerability occurrences
up 20210105154321 Add text limit to vulnerability occurrences entity columns
up 20210106061254 Add unique index for golang packages
up 20210106153021 Drop tmp index on emails
up 20210106155209 Add merge request diff commit trailers
up 20210106191305 Rename indexes on git lab com
up 20210106225424 Add keep latest artifacts to application settings
up 20210107105306 Add diff type to merge request diffs
up 20210107154615 Add merge request context commit trailers
up 20210107194543 Remove alerts service records
up 20210108161039 Update max import size default
up 20210111051045 Create dast profiles
up 20210111053308 Add project fk for dast profile
up 20210111075104 Add temporary index on security findings scan
up 20210111075105 Schedule uuid population for security findings
up 20210111075206 Schedule uuid population for security findings2
up 20210112084512 Drop tmp index on emails again
up 20210112143418 Remove duplicate services2
up 20210112202949 Create composer cache file
up 20210113224909 Add pipeline configuration full path to compliance pipeline
up 20210113231532 Add converted at to experiment subjects
up 20210113231546 Add context to experiment subjects
up 20210114033715 Remove group id title index
up 20210114142443 Add indexes to onboarding progresses
up 20210115090452 Create group repository storage move
up 20210115215854 Cancel artifact expiry backfill
up 20210115220610 Schedule artifact expiry backfill
up 20210117210226 Add has external issue tracker trigger
up 20210118111307 Add enforce ssh key expiration to application settings
up 20210119122354 Alter vsa issue first mentioned in commit value
up 20210119153801 Add proxy settings to jira tracker data
up 20210119162812 Add text limit to compliance pipeline configuration full path
up 20210120180956 Extend index on ci builds metadata
up 20210120221743 Delete oauth applications tmp index
up 20210121093618 Remove repository read only to groups
up 20210121100038 Add devops adoption group segment
up 20210121121102 Optional devops adoption segment name
up 20210122073805 Add repository read only to namespace settings
up 20210122153259 Add state to merge request reviewers
up 20210122155158 Add pipeline step to bulk imports failures
up 20210125105410 Add devops adoption segment namespace fk
up 20210126030249 Add security dashboard access level into project features
up 20210126091713 Add unique index services project id and type
up 20210126092102 Remove index services project id and type
up 20210126233608 Add rubygems max file size to plan limits
up 20210127052226 Add subgroup events to web hooks
up 20210127143025 Add oldest merge requests index
up 20210127152613 Add iterations cadence date range constraint
up 20210127202613 Remove iteration group date range constraint
up 20210128044930 Add git two factor session expiry to application settings
up 20210128101707 Add prevent merge without jira issue to project settings
up 20210128114526 Add auto delete at to environments
up 20210128140157 Add content type to dependency proxy manifests
up 20210128140232 Add text limit to dependency proxy manifests content type
up 20210128152830 Create ci namespace monthly usage
up 20210128172149 Create background migration tracking tables
up 20210129225244 Add index to oncall shfts on starts at and ends at
up 20210201034649 Add active periods to on call rotations
up 20210201140434 Add oldest merge requests index again
up 20210203002331 Drop backup label index
up 20210203092540 Remove has external wiki constraint
up 20210203092549 Restore has external wiki default value
up 20210203143131 Migrate existing devops segments to groups
up 20210203221631 Create packages rubygems metadata
up 20210203222620 Add expired index to composer cache files
up 20210203223551 Add orphan index to composer cache files
up 20210204152257 Add status to packages packages
up 20210204212850 Add group id to ci daily build group report results
up 20210205084357 Create ci project monthly usage
up 20210205104425 Add new post eoa plans
up 20210205134213 Add creator id to custom emoji
up 20210205143926 Remove namespace id foreign key on namespace onboarding actions
up 20210205144537 Remove namespace onboarding actions table
up 20210205174154 Remove bad dependency proxy manifests
up 20210205213915 Remove foreign keys from alerts service data
up 20210205213933 Drop alerts service data
up 20210205214003 Remove alerts service records again
up 20210208103243 Add issue created at to onboarding progress
up 20210208125050 Add status expires at to user statuses
up 20210208125248 Add index on user statuses status expires at
up 20210208144134 Add index group id to ci daily build group report results
up 20210208161207 Add notes create limit to application settings
up 20210208200914 Add ends at to oncall rotations
up 20210209110019 Create external approval rules
up 20210209160510 Create security orchestration policy configurations
up 20210209171525 Add status index to packages packages
up 20210209232508 Add markdown surround selection to user preferences
up 20210210093901 Backfill updated at after repository storage move
up 20210210210232 Add notes create limit allowlist to application settings
up 20210210221006 Cleanup projects with bad has external issue tracker data
up 20210211195543 Add created by user for cluster agent token
up 20210212153934 Make the geo oauth application trusted by default
up 20210212163231 Add merge when pipeline succeeds to notification settings
up 20210214201118 Add delayed project removal to namespace settings
up 20210214205155 Add index to namespaces delayed project removal
up 20210215095328 Migrate delayed project removal from namespaces to namespace settings
up 20210215144909 Migrate usage trends sidekiq queue
up 20210215172449 Remove artifact expiry temp index
up 20210216122140 Add in product marketing emails enabled setting
up 20210216135504 Add created by to cluster agent
up 20210216193620 Add description to cluster token
up 20210216223335 Remove index on issues where service desk reply to is not null
up 20210217100728 Move create release evidence queue out of cronjob namespace
up 20210217101901 Create epic list user preferences
up 20210218040814 Add environment scope to group variables
up 20210218105431 Remove deprecated ci builds columns
up 20210218110552 Remove deprecated ci runner column
up 20210218142626 Change finding fingerprint enum
up 20210218144056 Add sprints start date not null check constraint
up 20210218144656 Add sprints due date not null check constraint
up 20210219100137 Add creator foreign key to custom emoji
up 20210219102900 Reschedule set default iteration cadences
up 20210219111040 Add epic issue composite index
up 20210219211845 Add version usage data id to raw usage data
up 20210222030537 Add is removed to oncall participant
up 20210222042745 Add is removed index to oncall participant
up 20210222070356 Add storage size to namespace statistics
up 20210222070413 Add wiki size to namespace statistics
up 20210222085529 Add epic board user preference user fk
up 20210222085551 Add epic board user preference epic list fk
up 20210222105120 Add container registry access level
up 20210222185538 Remove backup labels foreign keys
up 20210222192144 Remove backup labels table
up 20210223053451 Add branch name to dast profile
up 20210223132934 Add foreign key to external approval rules
up 20210223133116 Add foreign key to external approval rules protected branches
up 20210223230600 Update rubygems metadata metadata
up 20210224132547 Add null constraint to terraform state name
up 20210224133337 Add name field to cluster agent token
up 20210224150506 Reschedule artifact expiry backfill
up 20210224161552 Add jira issue transition automatic to jira tracker data
up 20210225090801 Create dora daily metrics
up 20210225135533 Limit cluster token size
up 20210225153522 Add allow force push to protected branches
up 20210226120851 Move container registry enabled to project features
up 20210226141517 Dedup issue metrics
up 20210301150451 Add tier to environments
up 20210301193412 Add optional to ci build needs
up 20210301200601 Rename asset proxy allowlist on application settings
up 20210301200959 Clean up asset proxy allowlist rename on application settings
up 20210302025305 Add excluded urls and request headers to dast site profiles
up 20210302074524 Backfill namespace statistics with wiki size
up 20210302103851 Add deployed deployment id index to project pages metadata
up 20210302150310 Schedule migrate pages to zip storage
up 20210302155904 Remove index for security orchestration policy
up 20210302160544 Add index to security orchestration policy
up 20210302212623 Rename vuln fingerprints indexes
up 20210303053341 Add last edited at and last edited by id to notes
up 20210303064112 Add not null constraints to gitlab subscriptions namespace
up 20210303064142 Cleanup gitlab subscriptions with null namespace
up 20210303091651 Add index to environments tier
up 20210303121224 Update gitlab subscriptions start at post eoa
up 20210303165201 Add index for succeeded deployments
up 20210303165301 Add not null constraint to cluster token name
up 20210303165302 Cleanup cluster tokens with null name
up 20210303193544 Add concurrent fields to bulk imports trackers
up 20210303193605 Add text limits to bulk imports trackers jid and pipeline name
up 20210304133508 Schedule remove duplicate vulnerabilities findings2
up 20210305002016 Update terraform states locked by user id foreign key
up 20210305013509 Add text limit to group ci variables environment scope
up 20210305031822 Create dast site profile variables
up 20210305145622 Add terraform module max file size to plan limits
up 20210305180331 Create ci unit tests
up 20210305182740 Add projects fk to ci unit tests
up 20210305182855 Create ci unit test failures
up 20210305183904 Add ci builds fk to ci unit test failures
up 20210306121300 Partition web hook logs
up 20210306121310 Backfill partitioned web hook logs
up 20210308125742 Add info column into security scans table
up 20210308175224 Change namespace settings delayed project removal null
up 20210308175225 Add lock delayed project removal to namespace settings
up 20210308175226 Add delayed project removal to application settings
up 20210308175227 Add lock delayed project removal to application settings
up 20210308190413 Change batched background migrations batch class name default
up 20210309160106 Add admin mode to application setting
up 20210309181019 Add last used at to cluster agent token
up 20210310000627 Add idx vulnerability occurrences dedup
up 20210310111009 Add settings to group merge request approval settings
up 20210311022012 Add text limits to dast site profiles
up 20210311045138 Set traversal ids for gitlab org group staging
up 20210311045139 Set traversal ids for gitlab org group com
up 20210311093723 Add partial index on ci pipelines by cancelable status and users
up 20210311120152 Add metrics to batched background migration jobs
up 20210311120153 Initialize conversion of events id to bigint
up 20210311120154 Initialize conversion of push event payloads event id to bigint
up 20210311120155 Backfill events id for bigint conversion
up 20210311120156 Backfill push event payload event id for bigint conversion
up 20210312140029 Add owner and id index on active ci pipeline schedules
up 20210312174321 Add enforced git check to saml provider
up 20210312193532 Add resource access token creation allowed to namespace settings
up 20210313045617 Add verification state and started at to snippet repositories
up 20210313045845 Add verification indexes to snippet repositories
up 20210316094047 Add trial extension type to gitlab subscription histories
up 20210316094323 Add trial extension type to gitlab subscriptions
up 20210316152500 Add index ci stages on pipeline id and
up 20210316171009 Create packages helm file metadata
up 20210317035357 Create dast profiles pipelines
up 20210317100520 Create elastic index settings
up 20210317104032 Set iteration cadence automatic to false
up 20210317104301 Create in product marketing emails
up 20210317105904 Add user foreign key to in product marketing emails
up 20210317123054 Add throttle package registry columns
up 20210317155207 Validate not null constraint on cluster token name
up 20210317192943 Add expiry notification delivered to keys
up 20210317210338 Add valid runner registrars
up 20210318134427 Delete security findings without uuid
up 20210319071214 Add helm max file size to plan limits
up 20210322063407 Add dast profile id fk to dast profiles pipelines
up 20210322063450 Add ci pipeline id fk to dast profiles pipelines
up 20210322115438 Validate not null constraint on gitlab subscriptions namespace
up 20210322182751 Add index to keys on expires at and expiry notification undelivered
up 20210323064751 Add namespace traversal ids index
up 20210323125809 Create status check responses table
up 20210323130831 Add merge request foreign key to status check responses
up 20210323131543 Add external approval rule foreign key to status check responses
up 20210323155010 Populate dismissal information for vulnerabilities
up 20210323182846 Add project status date index to merge requests
up 20210324112439 Add index mirror data on retry next execution where status
up 20210324131727 Migrate elastic index settings
up 20210325092215 Add not valid foreign key to group hooks
up 20210325113129 Validate foreign key on service hooks
up 20210325150837 Add verification state to ci pipeline artifact
up 20210325151758 Add verification failure limit to ci pipeline artifact
up 20210325152011 Add verification indexes to ci pipeline artifacts
up 20210326035553 Add index for project deployments with environment id and updated at
up 20210326121537 Backfill cleanup for partitioned web hook logs
up 20210326190903 Create vulnerability finding evidences
up 20210328214434 Remove temporary index from vulnerabilities table
up 20210329095548 Add target project and source branch index to merge request
up 20210329102724 Add new trail plans
up 20210329191850 Add finding signature table
up 20210329192716 Add composite index to award emoji
up 20210330015805 Add cloud to licenses
up 20210330091751 Remove records without group from webhooks table
up 20210330130420 Drop finding fingerprint table
up 20210331000934 Add config to ci runners
up 20210331105335 Drop non partitioned audit events
up 20210331125111 Add default target project
up 20210331145548 Add index for last deployment
up 20210331180118 Remove deprecated index from award emoji
up 20210401131948 Move container registry enabled to project features2
up 20210401134157 Add index to pages deployments
up 20210401134455 Remove index mirror data on next execution and retry count
up 20210401175134 Add before expiry notification delivered to keys
up 20210401192808 Add index to keys on expires at and before expiry notification undelivered
up 20210402005225 Add source and level index on notification settings
up 20210403022952 Remove notes delete cascade timelogs
up 20210406063442 Create namespaces id parent id partial index
up 20210406140057 Add total tuple count to batched migrations
up 20210406144743 Backfill total tuple count for batched migrations
up 20210407002511 Add type to dast site profile
up 20210407111027 Add whats new application setting
up 20210407140539 Add verification state and started at to terraform state version table
up 20210407150240 Confirm support bot user
up 20210409084242 Create index on notes for cherry picked merge requests
up 20210409185501 Index members on user id source id source type
up 20210409185531 Remove members index on user
up 20210411212813 Add clusters integrations prometheus
up 20210412111213 Create security orchestration policy rule schedule
up 20210412132736 Add instance url to jira connect installations
up 20210412132824 Add text limit to jira connect installations instance url
up 20210412142223 Add user index on spam logs
up 20210412172030 Add configured at to security orchestration policy
up 20210413092922 Add index to packages maven metadata path
up 20210413121101 Add created at web hook id index to partitioned web hook log
up 20210413123832 Add index on web hook id to partitioned web hook log
up 20210413130011 Add partitioned web hook log fk
up 20210413132500 Reschedule artifact expiry backfill again
up 20210413155324 Add pause seconds to batched background migrations
up 20210414045322 Add pause seconds to batched background migration jobs
up 20210414095944 Add index services on project and type where inherit null
up 20210414100914 Add bulk import exports table
up 20210414130017 Add foreign key to bulk import exports on project
up 20210414130526 Add foreign key to bulk import exports on group
up 20210414131600 Add external pipeline validation to application setting
up 20210414131807 Add bulk import exports table indexes
up 20210414133310 Add bulk import export uploads table
up 20210415074645 Index members on user id access level requested at is null
up 20210415100159 Initialize conversion of ci build needs to bigint
up 20210415101228 Backfill ci build needs for bigint conversion
up 20210415142700 Add url limit to pipeline validation
up 20210415144538 Remove index epics on group id from epics
up 20210415155043 Move container registry enabled to project features3
up 20210415172516 Create vulnerability finding evidence requests
up 20210416172516 Create vulnerability finding evidence responses
up 20210419090412 Remove debian group architectures distribution id index
up 20210419090542 Remove debian project architectures distribution id index
up 20210419203017 Add remote import url to import export upload
up 20210419203018 Add remote text limit to import url in import export upload
up 20210419224834 Update issues iteration foreign key
up 20210420012444 Change web hook events default
up 20210420012909 Index cluster agent tokens on last used at
up 20210420103955 Remove hipchat service records
up 20210420120734 Initialize conversion of ci job artifacts to bigint
up 20210420121149 Backfill conversion of ci job artifacts
up 20210420173030 Add verification indexes to terraform state versions
up 20210420210642 Recreate index for project deployments with environment id and date at
up 20210420221106 Update merge requests iteration foreign key
up 20210421021510 Add deactivate dormant users to application settings
up 20210421022010 Add index for dormant users
up 20210421081724 Add codeowners devops adoption snapshot
up 20210421163509 Schedule update jira tracker data deployment type based on url
up 20210421190157 Remove elastic task null constraint from elastic reindexing subtasks
up 20210422022825 Initialize conversion of ci sources pipelines source job id to bigint
up 20210422023046 Backfill ci sources pipelines source job id for bigint conversion
up 20210422142647 Add project id next run at index to container expiration policies
up 20210422181809 Add project to timelogs
up 20210422195929 Create elastic reindexing slices
up 20210423054022 Create dast site profiles pipelines
up 20210423054537 Add dast site profile id fk to dast site profiles pipelines
up 20210423054846 Add ci pipeline id fk to dast site profiles pipelines
up 20210423124223 Remove proxy settings to jira tracker data
up 20210423155059 Add runner registration to plan limits
up 20210423160427 Schedule drop invalid vulnerabilities
up 20210423164702 Insert runner registration plan limits
up 20210423171304 Re order fk source project id in merge requests
up 20210424115725 Swap partitioned web hook logs
up 20210424163400 Add project id fk to timelogs
up 20210426094524 Initialize conversion of ci builds to bigint
up 20210426094549 Backfill ci builds for bigint conversion
up 20210426225417 Schedule recalculate uuid on vulnerabilities occurrences2
up 20210427045604 Initialize conversion of ci build trace chunks to bigint
up 20210427045711 Backfill ci build trace chunks for bigint conversion
up 20210427062807 Add index to batched migration jobs status
up 20210427084924 Initialize conversion of ci builds runner session to bigint
up 20210427085020 Backfill ci builds runner session for bigint conversion
up 20210427094931 Add execution order index to batched background migration jobs
up 20210427125400 Add spamcheck api key to application setting
up 20210427194958 Add description roll over to iterations cadences
up 20210427200840 Add text limit to iterations cadences description
up 20210427212034 Schedule update timelogs project
up 20210428151144 Update invalid web hooks
up 20210428151238 Validate foreign key on group hooks
up 20210429024843 Add escalation policies
up 20210429032320 Add escalation rules
up 20210429131525 Create user credit card validations
up 20210429143649 Add new issues index for relative position
up 20210429181325 Add failure tracking to web hooks
up 20210429192653 Add generic package duplicate settings to namespace package settings
up 20210429193106 Add text limit to namespace package settings generic duplicate exception regex
up 20210430034712 Add alert manager token to clusters integration prometheus
up 20210430100947 Add elasticsearch username password to application settings
up 20210430121522 Initialize conversion of ci build trace sections to bigint
up 20210430121542 Backfill ci build trace sections for bigint conversion
up 20210430122951 Add snapshot namespace
up 20210430124212 Add display namespace id to segments
up 20210430124630 Add devops adoption indexes
up 20210430130259 Remove obsolete segments field
up 20210430134202 Copy adoption snapshot namespace
up 20210430135954 Copy adoption segments namespace
up 20210430154631 Add slice multiplier and max slices to elastic reindexing task
up 20210503105022 Create project value streams
up 20210503105845 Add project value stream id to project stages
up 20210503131747 Add web hook calls to plan limits
up 20210504085144 Add index on web hook project id recent failures
up 20210504135823 Add floc application settings
up 20210504143128 Add verification state and started at to mr diff details table
up 20210504153354 Create clusters integration elasticstack
up 20210504164429 Create partial indexes for pending and running builds
up 20210505070612 Create packages debian group distribution keys
up 20210505070812 Create packages debian project distribution keys
up 20210505092746 Create partial covering index for pending builds
up 20210505124816 Add text limit to elasticsearch username
up 20210505170152 Add verification indexes to merge request diff details table
up 20210506064413 Create namespaces id parent id inverse partial index
up 20210506065000 Schedule backfill traversal ids
up 20210506150833 Create vulnerability finding evidence headers
up 20210507191949 Add remove on issue close to labels
up 20210510083845 Add sha to status check response
up 20210510191551 Add body to findings evidences request
up 20210510191552 Add limit to findings evidences request body
up 20210511095657 Add temporary index for project topics to taggings
up 20210511095658 Schedule migrate project taggings context from tags to topics
up 20210511104929 Add epic board recent visits table
up 20210511104930 Add index to epic board recent visits
up 20210511142748 Schedule drop invalid vulnerabilities2
up 20210511165250 Add foreign key to lfs objects projects
up 20210512120122 Add pending builds table
up 20210512183309 Add body to findings evidences response
up 20210512183310 Add limit to findings evidences response body
up 20210513093418 Add draft column to merge requests
up 20210513155447 Add temporary package index for nuget data migration
up 20210513155546 Backfill nuget temporary packages to processing status
up 20210513155635 Remove temporary package index for nuget data migration
up 20210513163904 Cleanup move container registry enabled to project feature
up 20210514063252 Schedule cleanup orphaned lfs objects projects
up 20210517075444 Remove temporary index for project topics to taggings
up 20210517130723 Make snapshot segment id optional
up 20210517144856 Require snapshot namespace
up 20210517221612 Add default value to merge requests author approval on projects
up 20210518001450 Backfill clusters integration elastic stack enabled
up 20210518074332 Schedule disable expiration policies linked to no container images
up 20210519104931 Backfill clusters integration prometheus enabled
up 20210519132109 Initialize conversion of ci builds metadata to bigint
up 20210519132129 Backfill ci builds metadata for bigint conversion
up 20210519154058 Schedule update users where two factor auth required from group
up 20210519220019 Backfill escalation policies for oncall schedules
up 20210520012430 Backfill pk conversion for self managed
up 20210520102039 Group protected environments add column
up 20210520133032 Initialize conversion of taggings to bigint
up 20210520133440 Backfill taggings for bigint conversion
up 20210521073920 Drop devops adoption namespace uniqueness
up 20210525075724 Clean up pending builds table
up 20210525085158 Initialize conversion of deployments to bigint
up 20210525085325 Backfill deployments for bigint conversion
up 20210525100539 Initialize conversion of geo job artifact deleted events to bigint
up 20210525100603 Backfill geo job artifact deleted events for bigint conversion
up 20210525184900 Add latest pipeline id into vulnerability statistics table
up 20210526135911 Create ci minutes additional packs
up 20210526155257 Rename sync security report approval rules sidekiq queue
up 20210526160133 Remove segment selections table
up 20210526181820 Add index to vulnerability statistics on latest pipeline
up 20210526181821 Add foreign key for latest pipeline id to ci pipelines
up 20210526190259 Add ci daily pipeline schedule triggers to plan limits
up 20210526190553 Insert ci daily pipeline schedule triggers plan limits
up 20210526222715 Backfill draft status on merge requests
up 20210527065005 Add index for cadence iterations automation
up 20210527130524 Rename experiment subjects group id to namespace
up 20210527131039 Clean up rename experiment subjects group id to namespace
up 20210527133919 Add diff max lines to application settings
up 20210527134019 Add diff max files to application settings
up 20210527185542 Add prevent sharing groups outside hierarchy to namespace settings
up 20210527194558 Create ci job token project scope links
up 20210529164247 Change iterations title uniqueness index
up 20210531053916 Rename instance statistics measurements
up 20210531054108 Finalize rename instance statistics measurements
up 20210531070452 Default enforce ssh key expiration
up 20210531071107 Enable enforce ssh key expiration
up 20210601073400 Fix total stage in vsa
up 20210601080039 Group protected environments add index and constraint
up 20210601123341 Add running builds table
up 20210601125410 Add runners created at index
up 20210601131742 Update web hook calls limit
up 20210601132134 Remove partial index for hashed storage migration
up 20210601133459 Replace runners contacted at index
up 20210602122213 Add upcoming reconciliations
up 20210602122233 Add runners description index
up 20210602155056 Add merge request diff commit users
up 20210602155110 Add merge request diff commit user columns
up 20210602164044 Schedule latest pipeline id population
up 20210603140302 Add pronouns to user details
up 20210603222333 Remove builds email service from services
up 20210604032738 Create dast site profiles builds
up 20210604034158 Add ci build id fk to dast site profiles builds
up 20210604034354 Add dast site profile id fk to dast site profiles builds
up 20210604051330 Create dast scanner profiles builds
up 20210604051742 Add ci build id fk to dast scanner profiles builds
up 20210604051917 Add dast scanner profile id fk to dast scanner profiles builds
up 20210604070207 Retry backfill traversal ids
up 20210604082145 Create external status checks table
up 20210604085600 Rename status check responses approval rule
up 20210604133651 Schedule merge request diff users background migration
up 20210606143426 Add index for container registry access level
up 20210607050531 Add text limit to user details pronouns
up 20210607080044 Remove temporary index on security findings scan
up 20210607154719 Add job token scope enabled to ci cd settings
up 20210608072312 Initialize conversion of ci stages to bigint
up 20210608072346 Backfill ci stages for bigint conversion
up 20210608103230 Add issue id to test report
up 20210608103235 Add issue index to test report
up 20210608110752 Change column null test report requirement
up 20210608110760 Add requirement test reports foreign key
up 20210609013512 Add unique index for batched background migrations
up 20210609090856 Add expiry id ssh key notification index
up 20210609125005 Drop non partitioned web hook logs
up 20210609192728 Add status check foreign key to external status check
up 20210609193101 Add status check foreign key to protected branch
up 20210609202501 Schedule backfill draft status on merge requests
up 20210610042700 Remove clusters applications fluentd table
up 20210610102410 Add protected attribute to pending builds
up 20210610102413 Migrate protected attribute to pending builds
up 20210610113229 Add index to protected pending builds
up 20210610141711 Disable expiration policies linked to no container images
up 20210610153556 Delete legacy operations feature flags
up 20210611080951 Fix missing traversal ids
up 20210611100359 Rebuild index for cadence iterations automation
up 20210611101034 Add devops adoption sast dast
up 20210614124111 Add devops adoption sast dast indexes
up 20210614131002 Add detection method to vulnerabilities finding
up 20210614142311 Add running container scanning max size to plan limits
up 20210614143954 Add unique index for helm packages
up 20210615064342 Add issue id to requirement
up 20210615234935 Fix batched migrations old format job arguments
up 20210616110748 Add issue index to requirement
up 20210616111311 Add issue requirement foreign key
up 20210616134905 Add timestamp to schema migration
up 20210616145254 Add partial index for ci builds token
up 20210616154808 Remove ci build protected index
up 20210616185947 Add mailgun settings to application setting
up 20210617022324 Create incident management pending alert escalations
up 20210617161348 Cascade delete freeze periods
up 20210617180131 Migrate usage ping sidekiq queue
up 20210621043337 Rename services to integrations
up 20210621044000 Rename services indexes to integrations
up 20210621084632 Add summary to timelogs
up 20210621090030 Add text limit to timelogs summary
up 20210621091830 Add devops adoption snapshot dependency scanning
up 20210621111747 Add ci artifacts devops adoption index
up 20210621155328 Replace project authorizations project id index
up 20210621164210 Drop remove on close from labels
up 20210621223000 Steal background jobs that reference services
up 20210621223242 Finalize rename services to integrations
up 20210622041846 Finalize push event payloads bigint conversion
up 20210622135221 Add foreign key for environment id to environments
up 20210622141148 Schedule delete orphaned deployments
up 20210623074226 Add usage ping features enabled to application settings
up 20210623123722 Add present on default branch to vulnerabilities
up 20210623133635 Create error tracking errors
up 20210623163342 Add index to compliance management frameworks pipeline configuration
up 20210624112821 Add devops adoption coverage fuzzing
up 20210624180613 Add last synced at to licenses
up 20210625094554 Create error tracking error events
up 20210627204936 Add plan limits max size cluster image scanning column
up 20210628124505 Reset job token scope enabled
up 20210629101712 Remove deprecated modsecurity columns
up 20210629104933 Drop index on ci builds for token
up 20210629153519 Add index to bulk import entities on bulk import id and status
up 20210630025020 Migrate push event payloads event id back to integer for gitlab com
up 20210630144339 Add invite email success to members
up 20210701111627 Add upvotes count to issues
up 20210701111909 Backfill issues upvotes count
up 20210702124842 Add ci job trace size to plan limits
up 20210705124128 Add project settings previous default branch
up 20210705130919 Create container repos on exp cleanup status project id start date index
up 20210705132928 Add new user signups cap to namespace settings
up 20210705142714 Initialize conversion of ci builds metadata id to bigint
up 20210705143150 Backfill ci builds metadata id for bigint conversion
up 20210705144657 Add instance runners enabled to ci pending build
up 20210706084713 Add devops adoption snapshots index
up 20210706115312 Add upvotes count index to issues
up 20210706120847 Remove framework column from compliance management frameworks
up 20210706142819 Re schedule latest pipeline id population
up 20210706152139 Add index type to postgres indexes view
up 20210706213537 Add premium and ultimate plan limits
up 20210707095545 Add status to merge request cleanup schedules
up 20210707151536 Create vulnerability finding evidence sources
up 20210707171536 Create vulnerability finding evidence assets
up 20210707171554 Create vulnerability flags
up 20210707173645 Add project settings previous default branch text limit
up 20210707181536 Create vulnerability finding evidence supporting messages
up 20210708063032 Add failed count to merge request cleanup schedules
up 20210708124229 Add security scans created at index
up 20210708130419 Reschedule merge request diff users background migration
up 20210708131048 Add error tracking counter cache
up 20210708134446 Remove not null constraint from terms
up 20210708202548 Add scanners column to approval project rules
up 20210709085759 Index batched migration jobs by max value
up 20210709132707 Change default job token scope enabled
down 20210709163840 Add verification state to pages deployments
down 20210709164233 Add verification failure limit to pages deployments
down 20210709164443 Add verification indexes to pages deployments
up 20210713070842 Update merge request cleanup schedules scheduled at index
up 20210713075117 Re schedule latest pipeline id population with logging
up 20210713123345 Create dast profile schedule
up 20210713135152 Add devops adoption vulnerability management used count
up 20210713144637 Add vulnerabilities created at index
up 20210713223941 Remove null constraint from security findings
up 20210714120600 Add detected at to vulnerabilities
up 20210715074359 Add foreign key to dast profile schedules on dast profile
up 20210715074933 Add foreign key to dast profile schedules on user
up 20210715075203 Add foreign key to dast profile schedules on project
up 20210716074555 Revert default job token scope
up 20210720083432 Change application setting terms not null
up 20210720130006 Create error tracking client keys
up 20210721125525 Add signed file to packages debian project distributions
up 20210721125545 Add signed file to packages debian group distributions
up 20210721125620 Add text limit to packages debian project distributions signed files
up 20210721125637 Add text limit to packages debian group distributions signed files
up 20210721125804 Remove signing keys from packages debian project distributions
up 20210721125820 Remove signing keys from packages debian group distributions
up 20210721211602 Add vulnerability amount column into approval project rules
up 20210722055217 Add updated at index on merge requests
up 20210722110515 Revert backfill ci build trace sections for bigint conversion
up 20210722132844 Devops adoption drop redundant indexes
up 20210722210041 Add overridden uuid to security findings
➜ gitlab git:(nhxnguyen-geo-pages-ssf) ✗ bin/rails db:migrate
== 20210709163840 AddVerificationStateToPagesDeployments: migrating ===========
-- change_table(:pages_deployments)
-> 0.0114s
== 20210709163840 AddVerificationStateToPagesDeployments: migrated (0.0115s) ==
== 20210709164233 AddVerificationFailureLimitToPagesDeployments: migrating ====
-- transaction_open?()
-> 0.0000s
-- current_schema()
-> 0.0004s
-- execute("ALTER TABLE pages_deployments\nADD CONSTRAINT pages_deployments_verification_failure_text_limit\nCHECK ( char_length(verification_failure) <= 255 )\nNOT VALID;\n")
-> 0.0017s
-- current_schema()
-> 0.0004s
-- execute("SET statement_timeout TO 0")
-> 0.0008s
-- execute("ALTER TABLE pages_deployments VALIDATE CONSTRAINT pages_deployments_verification_failure_text_limit;")
-> 0.0016s
-- execute("RESET ALL")
-> 0.0009s
== 20210709164233 AddVerificationFailureLimitToPagesDeployments: migrated (0.0204s)
== 20210709164443 AddVerificationIndexesToPagesDeployments: migrating =========
-- transaction_open?()
-> 0.0000s
-- index_exists?(:pages_deployments, :verification_state, {:name=>"index_pages_deployments_on_verification_state", :algorithm=>:concurrently})
-> 0.0064s
-- add_index(:pages_deployments, :verification_state, {:name=>"index_pages_deployments_on_verification_state", :algorithm=>:concurrently})
-> 0.0043s
-- transaction_open?()
-> 0.0000s
-- index_exists?(:pages_deployments, :verified_at, {:where=>"(verification_state = 0)", :order=>{:verified_at=>"ASC NULLS FIRST"}, :name=>"index_pages_deployments_pending_verification", :algorithm=>:concurrently})
-> 0.0031s
-- add_index(:pages_deployments, :verified_at, {:where=>"(verification_state = 0)", :order=>{:verified_at=>"ASC NULLS FIRST"}, :name=>"index_pages_deployments_pending_verification", :algorithm=>:concurrently})
-> 0.0031s
-- transaction_open?()
-> 0.0000s
-- index_exists?(:pages_deployments, :verification_retry_at, {:where=>"(verification_state = 3)", :order=>{:verification_retry_at=>"ASC NULLS FIRST"}, :name=>"index_pages_deployments_failed_verification", :algorithm=>:concurrently})
-> 0.0034s
-- add_index(:pages_deployments, :verification_retry_at, {:where=>"(verification_state = 3)", :order=>{:verification_retry_at=>"ASC NULLS FIRST"}, :name=>"index_pages_deployments_failed_verification", :algorithm=>:concurrently})
-> 0.0029s
-- transaction_open?()
-> 0.0000s
-- index_exists?(:pages_deployments, :verification_state, {:where=>"(verification_state = 0 OR verification_state = 3)", :name=>"index_pages_deployments_needs_verification", :algorithm=>:concurrently})
-> 0.0035s
-- add_index(:pages_deployments, :verification_state, {:where=>"(verification_state = 0 OR verification_state = 3)", :name=>"index_pages_deployments_needs_verification", :algorithm=>:concurrently})
-> 0.0030s
== 20210709164443 AddVerificationIndexesToPagesDeployments: migrated (0.0341s)`rake db:rollback`
== 20210709164443 AddVerificationIndexesToPagesDeployments: reverting =========
-- transaction_open?()
-> 0.0000s
-- indexes(:pages_deployments)
-> 0.0040s
-- execute("SET statement_timeout TO 0")
-> 0.0005s
-- remove_index(:pages_deployments, {:algorithm=>:concurrently, :name=>"index_pages_deployments_on_verification_state"})
-> 0.0030s
-- execute("RESET ALL")
-> 0.0005s
-- transaction_open?()
-> 0.0000s
-- indexes(:pages_deployments)
-> 0.0021s
-- remove_index(:pages_deployments, {:algorithm=>:concurrently, :name=>"index_pages_deployments_pending_verification"})
-> 0.0017s
-- transaction_open?()
-> 0.0000s
-- indexes(:pages_deployments)
-> 0.0021s
-- remove_index(:pages_deployments, {:algorithm=>:concurrently, :name=>"index_pages_deployments_failed_verification"})
-> 0.0016s
-- transaction_open?()
-> 0.0000s
-- indexes(:pages_deployments)
-> 0.0019s
-- remove_index(:pages_deployments, {:algorithm=>:concurrently, :name=>"index_pages_deployments_needs_verification"})
-> 0.0014s
== 20210709164443 AddVerificationIndexesToPagesDeployments: reverted (0.0217s)== 20210709164233 AddVerificationFailureLimitToPagesDeployments: reverting ====
-- execute("ALTER TABLE pages_deployments\nDROP CONSTRAINT IF EXISTS pages_deployments_verification_failure_text_limit\n")
-> 0.0013s
== 20210709164233 AddVerificationFailureLimitToPagesDeployments: reverted (0.0089s)== 20210709163840 AddVerificationStateToPagesDeployments: reverting ===========
-- remove_column(:pages_deployments, :verification_failure, :text, {})
-> 0.0023s
-- remove_column(:pages_deployments, :verification_checksum, :binary, {:using=>"verification_checksum::bytea"})
-> 0.0008s
-- remove_column(:pages_deployments, :verified_at, :datetime_with_timezone, {})
-> 0.0007s
-- remove_column(:pages_deployments, :verification_retry_at, :datetime_with_timezone, {})
-> 0.0007s
-- remove_column(:pages_deployments, :verification_retry_count, :integer, {:default=>0, :limit=>2, :null=>false})
-> 0.0008s
-- remove_column(:pages_deployments, :verification_started_at, :datetime_with_timezone, {})
-> 0.0011s
-- remove_column(:pages_deployments, :verification_state, :integer, {:default=>0, :limit=>2, :null=>false})
-> 0.0009s
== 20210709163840 AddVerificationStateToPagesDeployments: reverted (0.0097s) ==`rake geo:db:migrate`
```shell == 20210709162057 CreatePagesDeploymentRegistry: migrating ==================== -- table_exists?(:pages_deployment_registry) -> 0.0004s -- create_table(:pages_deployment_registry, {:id=>:bigserial, :force=>:cascade}) -> 0.0268s == 20210709162057 CreatePagesDeploymentRegistry: migrated (0.0284s) =========== ````rake geo:db:rollback`
```shell == 20210709162057 CreatePagesDeploymentRegistry: reverting ==================== -- drop_table(:pages_deployment_registry) -> 0.0181s == 20210709162057 CreatePagesDeploymentRegistry: reverted (0.0182s) =========== ````PagesDeployment.replicables_for_current_secondary`
Query:
SELECT
"pages_deployments".*
FROM
"pages_deployments"
WHERE
"pages_deployments"."id" BETWEEN 1 AND 1000
AND "pages_deployments"."file_store" = 1Plan:
Index Scan using index_pages_deployments_on_file_store_and_id on public.pages_deployments (cost=0.42..2.60 rows=1 width=133) (actual time=10.949..10.950 rows=0 loops=1)
Index Cond: ((pages_deployments.file_store = 1) AND (pages_deployments.id >= 1) AND (pages_deployments.id <= 1000))
Buffers: shared hit=6 read=3
I/O Timings: read=10.815 write=0.000`PagesDeploymentRegistryFinder`
Query:
SELECT
"pages_deployment_registry".*
FROM
"pages_deployment_registry"
ORDER BY
"pages_deployment_registry"."id" ASCPlan:
QUERY PLAN
----------------------------------------------------------------------------------
Sort (cost=1.05..1.06 rows=3 width=1170)
Sort Key: id
-> Seq Scan on pages_deployment_registry (cost=0.00..1.03 rows=3 width=1170)
(3 rows)Edited by Nick Nguyen