Differences

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

--- resolution_area:prometheus_resolutions:res-p1705 [2021/06/21 12:58] – external edit 127.0.0.1
+++ resolution_area:prometheus_resolutions:res-p1705 [2021/07/05 11:51] (current) – 10.91.120.28
@@ Line 1: / Line 1: @@
+===== MysqlSlaveSqlThreadNotRunning =====
+**Level:** __Critical__ FIXME
+**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:** 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:** Will clear when the seconds behind master field goes under the threshold

Internal Errigal Collaboration Wiki