If the “RotateFlowStatPartitionsEvent” is missing, we can use the following procedure to add it.
Look in the directory: NFA\REPORTER\SQL\install, and you will see an SQL script named: RotateFlowStatPartitionsEvent.sql. That is the script that is responsible for creating the event on the system. We can create the missing event by running the commands from this script from the MySQL Command line, i.e.:
- DROP EVENT IF EXISTS RotateFlowStatPartitionsEvent;
- CREATE EVENT RotateFlowStatPartitionsEvent ON SCHEDULE EVERY 1 DAY STARTS (TIMESTAMP(CURRENT_DATE) + INTERVAL 1 DAY + INTERVAL 23 HOUR) DO CALL RotateFlowStatPartitions();
- CALL RotateFlowStatPartitions();