Differences

This shows you the differences between two versions of the page.

--- resolution_area:watchdog_resolutions:res-w9229 [2021/06/29 17:04] – btobin
+++ resolution_area:watchdog_resolutions:res-w9229 [2021/07/06 12:14] (current) – 10.91.120.28
@@ Line 4: / Line 4: @@
-**Purpose:**
+**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:**
+**Scenario:** When this query returns 0 rows<WRAP center round box 60%>
+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(*)
+</WRAP>
-**Resolution:**
-**Manual Action Steps:**
+**Resolution:** In the past the resolution has been to disable the //--secure-file-priv// option in mysql
-**Auto Clear:**
+**Manual Action Steps:** Check the cron logs for this error
+<WRAP center round box 60%>
+//ERROR 1290 (HY000) at line 19: The MySQL server is running with the --secure-file-priv option so it cannot execute this statement//
+</WRAP>
+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

Internal Errigal Collaboration Wiki