Create new index for security ci builds with new features
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.
-
I have evaluated the MR acceptance checklist for this MR.
Related to #344264 (closed)