3655
MySQLERRORNotableReplicationHIGH confidence

Replica channel is not stopped

Production Risk

Medium — Configuration change fails; replication continues with old settings.

How to reproduce
trigger — this will error
trigger — this will error
CHANGE REPLICATION SOURCE TO SOURCE_HOST='new_host' FOR CHANNEL 'channel1'; -- channel still running

expected output

ERROR 3655 (HY000): Replication channel 'channel1' is not stopped.

Fix

Stop channel before reconfiguring

Stop channel before reconfiguring
STOP REPLICA FOR CHANNEL 'channel1';
CHANGE REPLICATION SOURCE TO SOURCE_HOST='new_host' FOR CHANNEL 'channel1';
START REPLICA FOR CHANNEL 'channel1';

Why this works

Stops the channel threads, applies the configuration change, then restarts.

What not to do

Version notes

Sources
Official documentation ↗

MySQL 8.0 — 3655 ER_REPLICA_CHANNEL_NOT_STOPPED

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

← All MySQL errors