Differences

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

--- resolution_area:prometheus_resolutions:res-p1705 [2021/06/25 10:09] – external edit 127.0.0.1
+++ resolution_area:prometheus_resolutions:res-p1705 [2021/07/05 11:51] (current) – 10.91.120.28
@@ Line 4: / Line 4: @@
-**Purpose:**
+**Purpose:** This alert will tell us that replication is not running on a replica DB
 **Scenario:** MySQL Slave SQL thread has not been running on <server> for 5m .
-**Resolution:**
+**Resolution:** Check the replica for errors with a query.
 **Manual Action Steps:**
+  - Log into the replica
+  - //SHOW SLAVE STATUS;//
+  - check the mysql error and fix it if possible
+  - //STOP SLAVE;//
+  - //SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;// This skips the problem query
+  - //START SLAVE//
-**Auto Clear:**
+**Auto Clear:** Will clear when the seconds behind master field goes under the threshold

Internal Errigal Collaboration Wiki