Skip to content

Create new index for security ci builds with new features

Alan (Maciej) Paruszewski requested to merge 344264-create-index-for-security-builds into master

What does this MR do and why?

We have to recreate index for ci_builds to include apifuzzer_fuzz and apifuzzer_fuzz_dnd security jobs.

This is a second MR for this process according to https://docs.gitlab.com/ee/development/adding_database_indexes.html#create-indexes-asynchronously to create index synchronously as a follow up to !81586 (merged).

Migrations

⋊> env VERBOSE=true bundle exec rake db:migrate:up VERSION=20220302203410
== 20220302203410 CreateIndexSecurityCiBuildsOnNameAndIdParserWithNewFeatures: migrating 
-- transaction_open?()
   -> 0.0000s
-- index_exists?("ci_builds", [:name, :id], {:name=>"index_security_ci_builds_on_name_and_id_parser_features", :where=>"(name::text = ANY (ARRAY['container_scanning'::character varying::text,\n                                         'dast'::character varying::text,\n                                         'dependency_scanning'::character varying::text,\n                                         'license_management'::character varying::text,\n                                         'sast'::character varying::text,\n                                         'secret_detection'::character varying::text,\n                                         'coverage_fuzzing'::character varying::text,\n                                         'license_scanning'::character varying::text,\n                                         'apifuzzer_fuzz'::character varying::text,\n                                         'apifuzzer_fuzz_dnd'::character varying::text])\n                ) AND type::text = 'Ci::Build'::text", :algorithm=>:concurrently})
   -> 0.0115s
-- execute("SET statement_timeout TO 0")
   -> 0.0006s
-- add_index("ci_builds", [:name, :id], {:name=>"index_security_ci_builds_on_name_and_id_parser_features", :where=>"(name::text = ANY (ARRAY['container_scanning'::character varying::text,\n                                         'dast'::character varying::text,\n                                         'dependency_scanning'::character varying::text,\n                                         'license_management'::character varying::text,\n                                         'sast'::character varying::text,\n                                         'secret_detection'::character varying::text,\n                                         'coverage_fuzzing'::character varying::text,\n                                         'license_scanning'::character varying::text,\n                                         'apifuzzer_fuzz'::character varying::text,\n                                         'apifuzzer_fuzz_dnd'::character varying::text])\n                ) AND type::text = 'Ci::Build'::text", :algorithm=>:concurrently})
   -> 0.0718s
-- execute("RESET statement_timeout")
   -> 0.0011s
== 20220302203410 CreateIndexSecurityCiBuildsOnNameAndIdParserWithNewFeatures: migrated (0.0937s) 

⋊> env VERBOSE=true bundle exec rake db:migrate:down VERSION=20220302203410
== 20220302203410 CreateIndexSecurityCiBuildsOnNameAndIdParserWithNewFeatures: reverting 
-- transaction_open?()
   -> 0.0000s
-- index_exists?("ci_builds", [:name, :id], {:name=>"index_security_ci_builds_on_name_and_id_parser_features", :where=>"(name::text = ANY (ARRAY['container_scanning'::character varying::text,\n                                         'dast'::character varying::text,\n                                         'dependency_scanning'::character varying::text,\n                                         'license_management'::character varying::text,\n                                         'sast'::character varying::text,\n                                         'secret_detection'::character varying::text,\n                                         'coverage_fuzzing'::character varying::text,\n                                         'license_scanning'::character varying::text,\n                                         'apifuzzer_fuzz'::character varying::text,\n                                         'apifuzzer_fuzz_dnd'::character varying::text])\n                ) AND type::text = 'Ci::Build'::text", :algorithm=>:concurrently})
   -> 0.0111s
-- execute("SET statement_timeout TO 0")
   -> 0.0008s
-- remove_index("ci_builds", {:name=>"index_security_ci_builds_on_name_and_id_parser_features", :where=>"(name::text = ANY (ARRAY['container_scanning'::character varying::text,\n                                         'dast'::character varying::text,\n                                         'dependency_scanning'::character varying::text,\n                                         'license_management'::character varying::text,\n                                         'sast'::character varying::text,\n                                         'secret_detection'::character varying::text,\n                                         'coverage_fuzzing'::character varying::text,\n                                         'license_scanning'::character varying::text,\n                                         'apifuzzer_fuzz'::character varying::text,\n                                         'apifuzzer_fuzz_dnd'::character varying::text])\n                ) AND type::text = 'Ci::Build'::text", :algorithm=>:concurrently, :column=>[:name, :id]})
   -> 0.0128s
-- execute("RESET statement_timeout")
   -> 0.0007s
== 20220302203410 CreateIndexSecurityCiBuildsOnNameAndIdParserWithNewFeatures: reverted (0.0280s)

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

Related to #344264 (closed)

Merge request reports