Skip to content

Add temporary index for container scanning findings

Can Eldem requested to merge create-index-for-cs into master

What does this MR do?

Add index for upcoming migration. We need to update location_fingerprint for container scanning findings

UP

gdk-ee/gitlab [create-index-for-cs] » bundle exec rake db:migrate:up VERSION=20200820105408
== 20200820105408 AddIndexToContainerScanningFindings: migrating ==============
-- transaction_open?()
   -> 0.0000s
-- index_exists?(:vulnerability_occurrences, :id, {:where=>"report_type = 2", :name=>"idx_container_scanning_findings", :algorithm=>:concurrently})
   -> 0.0053s
== 20200820105408 AddIndexToContainerScanningFindings: migrated (0.0055s) =====

DOWN

== 20200820105408 AddIndexToContainerScanningFindings: reverting ==============
-- transaction_open?()
   -> 0.0000s
-- indexes(:project_registry)
   -> 0.0020s
== 20200820105408 AddIndexToContainerScanningFindings: reverted (0.0030s) =====

Databaselab

The query has been executed. Duration: 1.017 min (edited)

Related Issue

#229594 (closed)

Does this MR meet the acceptance criteria?

Conformity

Availability and Testing

Security

If this MR contains changes to processing or storing of credentials or tokens, authorization and authentication methods and other items described in the security review guidelines:

  • Label as security and @ mention @gitlab-com/gl-security/appsec
  • The MR includes necessary changes to maintain consistency between UI, API, email, or other methods
  • Security reports checked/validated by a reviewer from the AppSec team
Edited by Alexandru Croitor

Merge request reports