When a trigger misfires, we add that trigger to the trigger history. However, we do not have the fire_instance_id and start_time when the trigger misfires. Those values are part of the primary key. Accordingly, when we logged misfires multiple times, we encounter duplicate primary key errors.
When a trigger misfires, we add that trigger to the trigger history. However, we do not have the fire_instance_id and start_time when the trigger misfires. Those values are part of the primary key. Accordingly, when we logged misfires multiple times, we encounter duplicate primary key errors.