EC
1717
MySQLERRORCommonReplicationHIGH confidence

The SQL thread must be stopped before issuing this command

Production Risk

Medium — configuration change fails; replication continues unmodified.

What this means

Certain replication configuration commands require the SQL (applier) thread to be stopped first. Issuing the command while the thread is running raises this error.

Why it happens
  1. 1Executing CHANGE MASTER TO or modifying replication filters while the SQL thread is active.
How to reproduce
trigger — this will error
trigger — this will error
CHANGE MASTER TO MASTER_DELAY = 60;

expected output

ERROR 1717 (HY000): The SQL thread must be stopped.

Fix

Stop the SQL thread before reconfiguring replication

Stop the SQL thread before reconfiguring replication
STOP SLAVE SQL_THREAD;
CHANGE MASTER TO MASTER_DELAY = 60;
START SLAVE SQL_THREAD;

Why this works

Stopping the SQL thread ensures no relay log events are being applied during reconfiguration.

What not to do

✕

Sources
Official documentation ↗

MySQL 8.0 — 1717 ER_SLAVE_SQL_THREAD_MUST_STOP

Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev

← All MySQL errors