statsNextTicketStatusTableNotPopulated

Level: Major :!:

Purpose: This alert checks whether there are entries in the reporting_stats.stats_next_ticket_status table within a time period and if there are no rows found we will be alerted

Scenario: When this query returns 0 rows

SELECT CASE WHEN DATE_FORMAT(NOW(), '%H:%i:%s') BETWEEN '00:00:00' AND '00:05:00' THEN 1 WHEN DATE_FORMAT(NOW(), '%H:%i:%s') NOT BETWEEN '00:00:00' AND '00:05:00' THEN COUNT(*) END as 'count(*)

Resolution: In the past the resolution has been to disable the –secure-file-priv option in mysql

Manual Action Steps: Check the cron logs for this error

ERROR 1290 (HY000) at line 19: The MySQL server is running with the –secure-file-priv option so it cannot execute this statement

edit the /etc/my.cnf and disable this option in the mysql startup setting

Auto Clear: Will clear when data is found for the query