Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
12.0.0
-
None
-
Can result in unexpected behaviour
Description
CHANGE MASTER master_heartbeat_period TO greater than @@GLOBAL.slave_net_timeout gives a ER_SLAVE_HEARTBEAT_VALUE_OUT_OF_RANGE_MAX warning:
SET @@GLOBAL.slave_net_timeout = 20;
|
CHANGE MASTER TO master_heartbeat_period = 40.0;
|
Warnings:
|
Warning 1704 The requested value for the heartbeat period exceeds the value of `slave_net_timeout' seconds. A sensible value for the period should be less than the timeout
|
But not when the two configs are in the other order:
CHANGE MASTER TO master_heartbeat_period = 40.0;
|
SET @@GLOBAL.slave_net_timeout = 20;
|
A related phenomenon is that the default for master_heartbeat_period is computed from @@slave_net_timeout once the CHANGE MASTER entry is created.
Changing @@slave_net_timeout afterward does not update the defaulted config in existing CHANGE MASTER entries.
Attachments
Issue Links
- split from
-
MDEV-28302 Feature request: configurable defaults for MASTER_SSL_* settings for CHANGE MASTER
-
- Stalled
-
- split to
-
MDEV-37362 Save the set/unset state of CHANGE MASTER configurations
-
- Stalled
-