I have a parent table and a child table, the child table foreign keys the parent table primary keys, cascading delete, and a trigger to delete the parent table data while deleting the child table data, but now there is an error. deadlock,my trigger simply deletes the associated parent table data
This trigger has two deletions, I only deactivate the second foreign key to delete, the foreign key also has an index, but there are many other foreign keys in production, it can be deleted before, recently exploded this error