Skip to content

Update work_item_types FK to UPDATE CASCADE

Mario Celi requested to merge 499373-cascade-fks into master

What does this MR do and why?

We are going to update the PK work_item_types.id

For this to be successful, we need to change the FKs to cascade when the PK is updated

Migration output

UP 
main: == [advisory_lock_connection] object_id: 130220, pg_backend_pid: 35362
main: == 20241015201907 ReplaceFkOnWorkItemRelatedLinkRestrictions: migrating =======
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE work_item_related_link_restrictions ADD CONSTRAINT fk_work_item_related_link_restrictions_source_type_id FOREIGN KEY (source_type_id) REFERENCES work_item_types (id) ON UPDATE CASCADE ON DELETE CASCADE NOT VALID;")
main:    -> 0.0018s
main: -- execute("SET statement_timeout TO 0")
main:    -> 0.0003s
main: -- execute("ALTER TABLE work_item_related_link_restrictions VALIDATE CONSTRAINT fk_work_item_related_link_restrictions_source_type_id;")
main:    -> 0.0034s
main: -- execute("RESET statement_timeout")
main:    -> 0.0006s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE work_item_related_link_restrictions ADD CONSTRAINT fk_work_item_related_link_restrictions_target_type_id FOREIGN KEY (target_type_id) REFERENCES work_item_types (id) ON UPDATE CASCADE ON DELETE CASCADE NOT VALID;")
main:    -> 0.0007s
main: -- execute("ALTER TABLE work_item_related_link_restrictions VALIDATE CONSTRAINT fk_work_item_related_link_restrictions_target_type_id;")
main:    -> 0.0006s
main: == 20241015201907 ReplaceFkOnWorkItemRelatedLinkRestrictions: migrated (0.0663s) 

main: == [advisory_lock_connection] object_id: 130220, pg_backend_pid: 35362
ci: == [advisory_lock_connection] object_id: 130620, pg_backend_pid: 35364
ci: == 20241015201907 ReplaceFkOnWorkItemRelatedLinkRestrictions: migrating =======
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE work_item_related_link_restrictions ADD CONSTRAINT fk_work_item_related_link_restrictions_source_type_id FOREIGN KEY (source_type_id) REFERENCES work_item_types (id) ON UPDATE CASCADE ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0019s
ci: -- execute("SET statement_timeout TO 0")
ci:    -> 0.0003s
ci: -- execute("ALTER TABLE work_item_related_link_restrictions VALIDATE CONSTRAINT fk_work_item_related_link_restrictions_source_type_id;")
ci:    -> 0.0014s
ci: -- execute("RESET statement_timeout")
ci:    -> 0.0003s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE work_item_related_link_restrictions ADD CONSTRAINT fk_work_item_related_link_restrictions_target_type_id FOREIGN KEY (target_type_id) REFERENCES work_item_types (id) ON UPDATE CASCADE ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0005s
ci: -- execute("ALTER TABLE work_item_related_link_restrictions VALIDATE CONSTRAINT fk_work_item_related_link_restrictions_target_type_id;")
ci:    -> 0.0005s
ci: == 20241015201907 ReplaceFkOnWorkItemRelatedLinkRestrictions: migrated (0.0311s) 

ci: == [advisory_lock_connection] object_id: 130620, pg_backend_pid: 35364
main: == [advisory_lock_connection] object_id: 136500, pg_backend_pid: 35367
main: == 20241015204450 DropOldFkOnWorkItemRelatedLinkRestrictions: migrating =======
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- remove_foreign_key(:work_item_related_link_restrictions, {:column=>:source_type_id, :name=>"fk_rails_b013a0fa65"})
main:    -> 0.0025s
main: -- remove_foreign_key(:work_item_related_link_restrictions, {:column=>:target_type_id, :name=>"fk_rails_4513f0061c"})
main:    -> 0.0021s
main: == 20241015204450 DropOldFkOnWorkItemRelatedLinkRestrictions: migrated (0.0188s) 

main: == [advisory_lock_connection] object_id: 136500, pg_backend_pid: 35367
ci: == [advisory_lock_connection] object_id: 151580, pg_backend_pid: 35369
ci: == 20241015204450 DropOldFkOnWorkItemRelatedLinkRestrictions: migrating =======
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- remove_foreign_key(:work_item_related_link_restrictions, {:column=>:source_type_id, :name=>"fk_rails_b013a0fa65"})
ci:    -> 0.0023s
ci: -- remove_foreign_key(:work_item_related_link_restrictions, {:column=>:target_type_id, :name=>"fk_rails_4513f0061c"})
ci:    -> 0.0021s
ci: == 20241015204450 DropOldFkOnWorkItemRelatedLinkRestrictions: migrated (0.0226s) 

ci: == [advisory_lock_connection] object_id: 151580, pg_backend_pid: 35369
main: == [advisory_lock_connection] object_id: 160580, pg_backend_pid: 35372
main: == 20241015211516 ReplaceFkOnWorkItemWidgetDefinitions: migrating =============
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE work_item_widget_definitions ADD CONSTRAINT fk_work_item_widget_definitions_work_item_type_id FOREIGN KEY (work_item_type_id) REFERENCES work_item_types (id) ON UPDATE CASCADE ON DELETE CASCADE NOT VALID;")
main:    -> 0.0015s
main: -- execute("SET statement_timeout TO 0")
main:    -> 0.0003s
main: -- execute("ALTER TABLE work_item_widget_definitions VALIDATE CONSTRAINT fk_work_item_widget_definitions_work_item_type_id;")
main:    -> 0.0015s
main: -- execute("RESET statement_timeout")
main:    -> 0.0003s
main: == 20241015211516 ReplaceFkOnWorkItemWidgetDefinitions: migrated (0.0157s) ====

main: == [advisory_lock_connection] object_id: 160580, pg_backend_pid: 35372
ci: == [advisory_lock_connection] object_id: 180220, pg_backend_pid: 35374
ci: == 20241015211516 ReplaceFkOnWorkItemWidgetDefinitions: migrating =============
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE work_item_widget_definitions ADD CONSTRAINT fk_work_item_widget_definitions_work_item_type_id FOREIGN KEY (work_item_type_id) REFERENCES work_item_types (id) ON UPDATE CASCADE ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0008s
ci: -- execute("SET statement_timeout TO 0")
ci:    -> 0.0005s
ci: -- execute("ALTER TABLE work_item_widget_definitions VALIDATE CONSTRAINT fk_work_item_widget_definitions_work_item_type_id;")
ci:    -> 0.0012s
ci: -- execute("RESET statement_timeout")
ci:    -> 0.0003s
ci: == 20241015211516 ReplaceFkOnWorkItemWidgetDefinitions: migrated (0.0192s) ====

ci: == [advisory_lock_connection] object_id: 180220, pg_backend_pid: 35374
main: == [advisory_lock_connection] object_id: 186100, pg_backend_pid: 35377
main: == 20241015211946 DropOldFkOnWorkItemWidgetDefinitions: migrating =============
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- remove_foreign_key(:work_item_widget_definitions, {:column=>:work_item_type_id, :name=>"fk_61bfa96db5"})
main:    -> 0.0020s
main: == 20241015211946 DropOldFkOnWorkItemWidgetDefinitions: migrated (0.0122s) ====

main: == [advisory_lock_connection] object_id: 186100, pg_backend_pid: 35377
ci: == [advisory_lock_connection] object_id: 186380, pg_backend_pid: 35379
ci: == 20241015211946 DropOldFkOnWorkItemWidgetDefinitions: migrating =============
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- remove_foreign_key(:work_item_widget_definitions, {:column=>:work_item_type_id, :name=>"fk_61bfa96db5"})
ci:    -> 0.0034s
ci: == 20241015211946 DropOldFkOnWorkItemWidgetDefinitions: migrated (0.0283s) ====

ci: == [advisory_lock_connection] object_id: 186380, pg_backend_pid: 35379
main: == [advisory_lock_connection] object_id: 192220, pg_backend_pid: 35386
main: == 20241015213124 ReplaceFkOnWorkItemHierarchyRestrictions: migrating =========
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE work_item_hierarchy_restrictions ADD CONSTRAINT fk_work_item_hierarchy_restrictions_child_type_id FOREIGN KEY (child_type_id) REFERENCES work_item_types (id) ON UPDATE CASCADE ON DELETE CASCADE NOT VALID;")
main:    -> 0.0012s
main: -- execute("SET statement_timeout TO 0")
main:    -> 0.0003s
main: -- execute("ALTER TABLE work_item_hierarchy_restrictions VALIDATE CONSTRAINT fk_work_item_hierarchy_restrictions_child_type_id;")
main:    -> 0.0011s
main: -- execute("RESET statement_timeout")
main:    -> 0.0004s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE work_item_hierarchy_restrictions ADD CONSTRAINT fk_work_item_hierarchy_restrictions_parent_type_id FOREIGN KEY (parent_type_id) REFERENCES work_item_types (id) ON UPDATE CASCADE ON DELETE CASCADE NOT VALID;")
main:    -> 0.0006s
main: -- execute("ALTER TABLE work_item_hierarchy_restrictions VALIDATE CONSTRAINT fk_work_item_hierarchy_restrictions_parent_type_id;")
main:    -> 0.0006s
main: == 20241015213124 ReplaceFkOnWorkItemHierarchyRestrictions: migrated (0.0240s) 

main: == [advisory_lock_connection] object_id: 192220, pg_backend_pid: 35386
ci: == [advisory_lock_connection] object_id: 198780, pg_backend_pid: 35390
ci: == 20241015213124 ReplaceFkOnWorkItemHierarchyRestrictions: migrating =========
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE work_item_hierarchy_restrictions ADD CONSTRAINT fk_work_item_hierarchy_restrictions_child_type_id FOREIGN KEY (child_type_id) REFERENCES work_item_types (id) ON UPDATE CASCADE ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0009s
ci: -- execute("SET statement_timeout TO 0")
ci:    -> 0.0003s
ci: -- execute("ALTER TABLE work_item_hierarchy_restrictions VALIDATE CONSTRAINT fk_work_item_hierarchy_restrictions_child_type_id;")
ci:    -> 0.0009s
ci: -- execute("RESET statement_timeout")
ci:    -> 0.0004s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE work_item_hierarchy_restrictions ADD CONSTRAINT fk_work_item_hierarchy_restrictions_parent_type_id FOREIGN KEY (parent_type_id) REFERENCES work_item_types (id) ON UPDATE CASCADE ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0005s
ci: -- execute("ALTER TABLE work_item_hierarchy_restrictions VALIDATE CONSTRAINT fk_work_item_hierarchy_restrictions_parent_type_id;")
ci:    -> 0.0005s
ci: == 20241015213124 ReplaceFkOnWorkItemHierarchyRestrictions: migrated (0.0295s) 

ci: == [advisory_lock_connection] object_id: 198780, pg_backend_pid: 35390
main: == [advisory_lock_connection] object_id: 216360, pg_backend_pid: 35393
main: == 20241015213930 DropOldFkOnWorkItemHierarchyRestrictions: migrating =========
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- remove_foreign_key(:work_item_hierarchy_restrictions, {:column=>:child_type_id, :name=>"fk_rails_08cd7fef58"})
main:    -> 0.0026s
main: -- remove_foreign_key(:work_item_hierarchy_restrictions, {:column=>:parent_type_id, :name=>"fk_rails_27bb3a10ba"})
main:    -> 0.0019s
main: == 20241015213930 DropOldFkOnWorkItemHierarchyRestrictions: migrated (0.0270s) 

main: == [advisory_lock_connection] object_id: 216360, pg_backend_pid: 35393
ci: == [advisory_lock_connection] object_id: 216640, pg_backend_pid: 35395
ci: == 20241015213930 DropOldFkOnWorkItemHierarchyRestrictions: migrating =========
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- remove_foreign_key(:work_item_hierarchy_restrictions, {:column=>:child_type_id, :name=>"fk_rails_08cd7fef58"})
ci:    -> 0.0040s
ci: -- remove_foreign_key(:work_item_hierarchy_restrictions, {:column=>:parent_type_id, :name=>"fk_rails_27bb3a10ba"})
ci:    -> 0.0035s
ci: == 20241015213930 DropOldFkOnWorkItemHierarchyRestrictions: migrated (0.0401s) 

ci: == [advisory_lock_connection] object_id: 216640, pg_backend_pid: 35395
DOWN 
main: == [advisory_lock_connection] object_id: 129840, pg_backend_pid: 34514
main: == 20241015213930 DropOldFkOnWorkItemHierarchyRestrictions: reverting =========
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE work_item_hierarchy_restrictions ADD CONSTRAINT fk_rails_08cd7fef58 FOREIGN KEY (child_type_id) REFERENCES work_item_types (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0013s
main: -- execute("SET statement_timeout TO 0")
main:    -> 0.0003s
main: -- execute("ALTER TABLE work_item_hierarchy_restrictions VALIDATE CONSTRAINT fk_rails_08cd7fef58;")
main:    -> 0.0017s
main: -- execute("RESET statement_timeout")
main:    -> 0.0004s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE work_item_hierarchy_restrictions ADD CONSTRAINT fk_rails_27bb3a10ba FOREIGN KEY (parent_type_id) REFERENCES work_item_types (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0006s
main: -- execute("ALTER TABLE work_item_hierarchy_restrictions VALIDATE CONSTRAINT fk_rails_27bb3a10ba;")
main:    -> 0.0008s
main: == 20241015213930 DropOldFkOnWorkItemHierarchyRestrictions: reverted (0.0537s) 

main: == 20241015213124 ReplaceFkOnWorkItemHierarchyRestrictions: reverting =========
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- remove_foreign_key(:work_item_hierarchy_restrictions, {:column=>:child_type_id, :name=>"fk_work_item_hierarchy_restrictions_child_type_id"})
main:    -> 0.0023s
main: -- remove_foreign_key(:work_item_hierarchy_restrictions, {:column=>:parent_type_id, :name=>"fk_work_item_hierarchy_restrictions_parent_type_id"})
main:    -> 0.0022s
main: == 20241015213124 ReplaceFkOnWorkItemHierarchyRestrictions: reverted (0.0155s) 

main: == 20241015211946 DropOldFkOnWorkItemWidgetDefinitions: reverting =============
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE work_item_widget_definitions ADD CONSTRAINT fk_61bfa96db5 FOREIGN KEY (work_item_type_id) REFERENCES work_item_types (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0006s
main: -- execute("ALTER TABLE work_item_widget_definitions VALIDATE CONSTRAINT fk_61bfa96db5;")
main:    -> 0.0009s
main: == 20241015211946 DropOldFkOnWorkItemWidgetDefinitions: reverted (0.0149s) ====

main: == 20241015211516 ReplaceFkOnWorkItemWidgetDefinitions: reverting =============
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- remove_foreign_key(:work_item_widget_definitions, {:column=>:work_item_type_id, :name=>"fk_work_item_widget_definitions_work_item_type_id"})
main:    -> 0.0023s
main: == 20241015211516 ReplaceFkOnWorkItemWidgetDefinitions: reverted (0.0093s) ====

main: == 20241015204450 DropOldFkOnWorkItemRelatedLinkRestrictions: reverting =======
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE work_item_related_link_restrictions ADD CONSTRAINT fk_rails_b013a0fa65 FOREIGN KEY (source_type_id) REFERENCES work_item_types (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0006s
main: -- execute("ALTER TABLE work_item_related_link_restrictions VALIDATE CONSTRAINT fk_rails_b013a0fa65;")
main:    -> 0.0010s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE work_item_related_link_restrictions ADD CONSTRAINT fk_rails_4513f0061c FOREIGN KEY (target_type_id) REFERENCES work_item_types (id) ON DELETE CASCADE NOT VALID;")
main:    -> 0.0053s
main: -- execute("ALTER TABLE work_item_related_link_restrictions VALIDATE CONSTRAINT fk_rails_4513f0061c;")
main:    -> 0.0006s
main: == 20241015204450 DropOldFkOnWorkItemRelatedLinkRestrictions: reverted (0.0393s) 

main: == 20241015201907 ReplaceFkOnWorkItemRelatedLinkRestrictions: reverting =======
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- remove_foreign_key(:work_item_related_link_restrictions, {:column=>:source_type_id, :name=>"fk_work_item_related_link_restrictions_source_type_id"})
main:    -> 0.0021s
main: -- remove_foreign_key(:work_item_related_link_restrictions, {:column=>:target_type_id, :name=>"fk_work_item_related_link_restrictions_target_type_id"})
main:    -> 0.0019s
main: == 20241015201907 ReplaceFkOnWorkItemRelatedLinkRestrictions: reverted (0.0164s) 

main: == [advisory_lock_connection] object_id: 129840, pg_backend_pid: 34514
ci: == [advisory_lock_connection] object_id: 190740, pg_backend_pid: 34772
ci: == 20241015213930 DropOldFkOnWorkItemHierarchyRestrictions: reverting =========
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE work_item_hierarchy_restrictions ADD CONSTRAINT fk_rails_08cd7fef58 FOREIGN KEY (child_type_id) REFERENCES work_item_types (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0009s
ci: -- execute("SET statement_timeout TO 0")
ci:    -> 0.0003s
ci: -- execute("ALTER TABLE work_item_hierarchy_restrictions VALIDATE CONSTRAINT fk_rails_08cd7fef58;")
ci:    -> 0.0010s
ci: -- execute("RESET statement_timeout")
ci:    -> 0.0004s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE work_item_hierarchy_restrictions ADD CONSTRAINT fk_rails_27bb3a10ba FOREIGN KEY (parent_type_id) REFERENCES work_item_types (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0014s
ci: -- execute("ALTER TABLE work_item_hierarchy_restrictions VALIDATE CONSTRAINT fk_rails_27bb3a10ba;")
ci:    -> 0.0006s
ci: == 20241015213930 DropOldFkOnWorkItemHierarchyRestrictions: reverted (0.0336s) 

ci: == 20241015213124 ReplaceFkOnWorkItemHierarchyRestrictions: reverting =========
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- remove_foreign_key(:work_item_hierarchy_restrictions, {:column=>:child_type_id, :name=>"fk_work_item_hierarchy_restrictions_child_type_id"})
ci:    -> 0.0027s
ci: -- remove_foreign_key(:work_item_hierarchy_restrictions, {:column=>:parent_type_id, :name=>"fk_work_item_hierarchy_restrictions_parent_type_id"})
ci:    -> 0.0024s
ci: == 20241015213124 ReplaceFkOnWorkItemHierarchyRestrictions: reverted (0.0225s) 

ci: == 20241015211946 DropOldFkOnWorkItemWidgetDefinitions: reverting =============
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE work_item_widget_definitions ADD CONSTRAINT fk_61bfa96db5 FOREIGN KEY (work_item_type_id) REFERENCES work_item_types (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0006s
ci: -- execute("ALTER TABLE work_item_widget_definitions VALIDATE CONSTRAINT fk_61bfa96db5;")
ci:    -> 0.0007s
ci: == 20241015211946 DropOldFkOnWorkItemWidgetDefinitions: reverted (0.0177s) ====

ci: == 20241015211516 ReplaceFkOnWorkItemWidgetDefinitions: reverting =============
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- remove_foreign_key(:work_item_widget_definitions, {:column=>:work_item_type_id, :name=>"fk_work_item_widget_definitions_work_item_type_id"})
ci:    -> 0.0022s
ci: == 20241015211516 ReplaceFkOnWorkItemWidgetDefinitions: reverted (0.0143s) ====

ci: == 20241015204450 DropOldFkOnWorkItemRelatedLinkRestrictions: reverting =======
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE work_item_related_link_restrictions ADD CONSTRAINT fk_rails_b013a0fa65 FOREIGN KEY (source_type_id) REFERENCES work_item_types (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0006s
ci: -- execute("ALTER TABLE work_item_related_link_restrictions VALIDATE CONSTRAINT fk_rails_b013a0fa65;")
ci:    -> 0.0009s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("ALTER TABLE work_item_related_link_restrictions ADD CONSTRAINT fk_rails_4513f0061c FOREIGN KEY (target_type_id) REFERENCES work_item_types (id) ON DELETE CASCADE NOT VALID;")
ci:    -> 0.0005s
ci: -- execute("ALTER TABLE work_item_related_link_restrictions VALIDATE CONSTRAINT fk_rails_4513f0061c;")
ci:    -> 0.0008s
ci: == 20241015204450 DropOldFkOnWorkItemRelatedLinkRestrictions: reverted (0.0298s) 

ci: == 20241015201907 ReplaceFkOnWorkItemRelatedLinkRestrictions: reverting =======
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- remove_foreign_key(:work_item_related_link_restrictions, {:column=>:source_type_id, :name=>"fk_work_item_related_link_restrictions_source_type_id"})
ci:    -> 0.0025s
ci: -- remove_foreign_key(:work_item_related_link_restrictions, {:column=>:target_type_id, :name=>"fk_work_item_related_link_restrictions_target_type_id"})
ci:    -> 0.0018s
ci: == 20241015201907 ReplaceFkOnWorkItemRelatedLinkRestrictions: reverted (0.0210s) 

ci: == [advisory_lock_connection] object_id: 190740, pg_backend_pid: 34772

MR acceptance checklist

Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

Related to #499373

Edited by Mario Celi

Merge request reports