I have a table that receives data all the time, almost every second. This table has a trigger that after insertion of a new row inserts this record into another table.
I need to include a new trigger in the same table and I have some questions:
1 - When I try to change the existing trigger or create a new trigger, everything stops (the table stops receiving records and consequently the trigger does not write to the other table), and it takes a long time for the trigger to be changed, type 5 minutes. Why that? Is there any way to do this more correctly, without crashing anything or taking a while to run?
2 - Is there any way to get the error log from the moment it crashes so I know what's going on?
NOTE: I have tried to insert a new trigger as well as add my code to the existing trigger, they both take a while to run and both lock the table.
I am willing to escalate the issue with more information, if necessary.