After trigger deletion check for events created by this trigger and schedule their deletion immediately with housekeeper

XMLWordPrintable

    • Type: New Feature Request
    • Resolution: Unresolved
    • Priority: Medium
    • None
    • Affects Version/s: 5.0.19, 5.4.8
    • Component/s: Frontend (F), Server (S)
    • None

      Dear developers! Please, consider adding a mechanism which upon a trigger deletion would immediately schedule all events which were created by this trigger to be deleted by the "housekeeper" without having to wait for the time period set in the 

      "Administration">"General">"Housekeeping">"Events and alerts">"Trigger data storage period"

      As these events are not visible in the GUI, but are still present in the DB.

      And usually when such "orphaned" event entries are found the suggested workaround from us is to:

      SET SESSION SQL_LOG_BIN=0;
      DELETE FROM events WHERE source = 0 AND object = 0 AND objectid NOT IN (SELECT triggerid FROM triggers);

       

            Assignee:
            Valdis Murzins
            Reporter:
            Antons Sincovs
            Votes:
            5 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated: