1653
MySQLERRORNotableReplicationHIGH confidence
Heartbeat frequency exceeds the maximum allowed value
Production Risk
Low — the command is rejected.
What this means
The heartbeat interval specified in CHANGE MASTER TO MASTER_HEARTBEAT_PERIOD exceeds the maximum allowed value.
Why it happens
- 1Setting MASTER_HEARTBEAT_PERIOD to a value greater than the allowed maximum (4294967 seconds).
How to reproduce
trigger — this will error
trigger — this will error
CHANGE MASTER TO MASTER_HEARTBEAT_PERIOD = 9999999999;
expected output
ERROR 1653 (HY000): The requested value for the heartbeat period exceeds the maximum allowed value.
Fix
Set a valid heartbeat period
Set a valid heartbeat period
CHANGE MASTER TO MASTER_HEARTBEAT_PERIOD = 60;
Why this works
Using a reasonable value within the allowed range prevents the error.
Version notes
Sources
Official documentation ↗
MySQL 8.0 — 1653 ER_SLAVE_HEARTBEAT_VALUE_OUT_OF_RANGE_MAX
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev