1652
MariaDBERRORNotableReplicationHIGH confidence
Heartbeat frequency is below the minimum allowed value
Production Risk
Low — the command is rejected or the period is clamped to zero.
What this means
The heartbeat interval specified in CHANGE MASTER TO MASTER_HEARTBEAT_PERIOD is smaller than the minimum allowed value.
Why it happens
- 1Setting MASTER_HEARTBEAT_PERIOD to a value less than the minimum threshold.
How to reproduce
trigger — this will error
trigger — this will error
CHANGE MASTER TO MASTER_HEARTBEAT_PERIOD = 0.001;
expected output
ERROR 1652 (HY000): The requested value for the heartbeat period is less than 1 millisecond.
Fix
Set a valid heartbeat period
Set a valid heartbeat period
CHANGE MASTER TO MASTER_HEARTBEAT_PERIOD = 30;
Why this works
A period of 30 seconds is a common production value that stays within bounds.
Version notes
Sources
Official documentation ↗
MySQL 8.0 — 1652 ER_SLAVE_HEARTBEAT_VALUE_OUT_OF_RANGE_MIN
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev