Skip to content

Schedule remove temp index on vulnerability_occurrences

Marcos Rocha requested to merge mc_rocha-remove-temp-index-vulnerability-occurrences-404408 into master

What does this MR do and why?

This MR schedules the removal of the temporary index introduced in !116522 (merged) to fix erroneously reused vulnerability identifier.

Migration up

main: == [advisory_lock_connection] object_id: 223840, pg_backend_pid: 42161
main: == 20230711182029 ScheduleRemoveTempIndexVulnerabilityOccurrences: migrating ==
main: -- index_exists?(:vulnerability_occurrences, :id, {:where=>"report_type IN (7, 99)", :name=>"tmp_idx_vulnerability_occurrences_on_id_where_report_type_7_99"})
main:    -> 0.1492s
main: -- quote_column_name("tmp_idx_vulnerability_occurrences_on_id_where_report_type_7_99")
main:    -> 0.0001s
main: == 20230711182029 ScheduleRemoveTempIndexVulnerabilityOccurrences: migrated (0.1753s)

Migration down

main: == [advisory_lock_connection] object_id: 223640, pg_backend_pid: 41381
main: == 20230711182029 ScheduleRemoveTempIndexVulnerabilityOccurrences: reverting ==
main: == 20230711182029 ScheduleRemoveTempIndexVulnerabilityOccurrences: reverted (0.1314s) 

main: == [advisory_lock_connection] object_id: 223640, pg_backend_pid: 41381

Related to #404408 (closed)

MR acceptance checklist

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

Edited by Marcos Rocha

Merge request reports