1274
MariaDBerrorreplicationhigh 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
  1. 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

← All MariaDB errors