3094
MariaDBERRORNotableReplicationHIGH confidence
Slave heartbeat period above maximum
Production Risk
Low — only the CHANGE MASTER TO statement fails.
What this means
The value specified for MASTER_HEARTBEAT_PERIOD in CHANGE MASTER TO exceeds the allowed maximum (4294967 seconds).
Why it happens
- 1Setting MASTER_HEARTBEAT_PERIOD to a value larger than the maximum allowed.
How to reproduce
trigger — this will error
trigger — this will error
CHANGE MASTER TO MASTER_HEARTBEAT_PERIOD = 9999999999;
expected output
ERROR 3094 (HY000): The requested value for the heartbeat period is above the maximum.
Fix
Use a heartbeat period within the valid range
Use a heartbeat period within the valid range
CHANGE MASTER TO MASTER_HEARTBEAT_PERIOD = 30; -- 30 seconds
Why this works
Keeps the heartbeat period within the supported bounds.
What not to do
✕
Sources
Official documentation ↗
MySQL 8.0 — 3094 ER_SLAVE_HEARTBEAT_VALUE_OUT_OF_RANGE_MAX2
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev