1274
MySQLerrorreplicationhigh confidence
Slave already has been stopped
Production Risk
Low — harmless; replication is already stopped.
What this means
STOP SLAVE (or STOP REPLICA) was issued but the replica threads were already stopped.
Why it happens
- 1Issuing STOP SLAVE on a replica that never started or was already stopped
How to reproduce
trigger — this will error
trigger — this will error
STOP SLAVE;
expected output
ERROR 1274 (HY000): Slave already has been stopped
Fix
Check replica status first
Check replica status first
SHOW SLAVE STATUS\G
Why this works
Inspect thread state before issuing STOP SLAVE.
What not to do
✕
Version notes
Sources
Official documentation ↗
MySQL 8.0 — 1274 ER_SLAVE_WAS_NOT_RUNNING
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev