User Tools

Site Tools


resolution_area:prometheus_resolutions:res-p1705

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:

  1. Log into the replica
  2. SHOW SLAVE STATUS;
  3. check the mysql error and fix it if possible
  4. STOP SLAVE;
  5. SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; This skips the problem query
  6. START SLAVE

Auto Clear: Will clear when the seconds behind master field goes under the threshold

resolution_area/prometheus_resolutions/res-p1705.txt · Last modified: 2021/07/05 11:51 by 10.91.120.28