Deadlock because of trigger

[franck-boullier]

The problem:

In order to fix unee-t/lambda2sqs#9 (comment), we had to disable the trigger which update the counter of all active units each time a new unit is inserted in the products table in the BZ database.

We need to find a way to:

• keep updating the counter of active unit each time a new unit is inserted
• prevent the deadlock issue when we create a lot of units via the MEFE Unit creation API.

The code to re-create the trigger:

# We need a trigger `update_the_log_of_enabled_units_when_unit_is_created` to call the procedure `update_log_count_enabled_units` each time a new unit/product is created.

    DROP TRIGGER IF EXISTS `update_the_log_of_enabled_units_when_unit_is_created`;

DELIMITER $$
CREATE TRIGGER `update_the_log_of_enabled_units_when_unit_is_created`
    AFTER INSERT ON `products`
    FOR EACH ROW
  BEGIN
    CALL `update_log_count_enabled_units`;
END;
$$
DELIMITER ;