3093
MySQLERRORNotableReplicationHIGH confidence
Slave heartbeat period below minimum
Production Risk
Low — only the CHANGE MASTER TO statement fails.
What this means
The value specified for MASTER_HEARTBEAT_PERIOD in CHANGE MASTER TO is below the allowed minimum.
Why it happens
- 1Setting MASTER_HEARTBEAT_PERIOD to a value smaller than the minimum (0.001 seconds).
How to reproduce
trigger — this will error
trigger — this will error
CHANGE MASTER TO MASTER_HEARTBEAT_PERIOD = 0.0001;
expected output
ERROR 3093 (HY000): The requested value for the heartbeat period is below the minimum.
Fix
Use a heartbeat period at or above the minimum
Use a heartbeat period at or above the minimum
CHANGE MASTER TO MASTER_HEARTBEAT_PERIOD = 1; -- 1 second
Why this works
Ensures the heartbeat interval is within the valid range.
What not to do
✕
Sources
Official documentation ↗
MySQL 8.0 — 3093 ER_SLAVE_HEARTBEAT_VALUE_OUT_OF_RANGE_MIN2
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev