User Tools
resolution_area:prometheus_resolutions:res-p1705
MysqlSlaveSqlThreadNotRunning
Level: Critical
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
resolution_area/prometheus_resolutions/res-p1705.txt · Last modified: 2021/07/05 11:51 by 10.91.120.28