Skip to content
This repository was archived by the owner on Feb 18, 2025. It is now read-only.
This repository was archived by the owner on Feb 18, 2025. It is now read-only.

Orchestrator not detecting intermediate master failure with relay_log_space_limit. #999

@jfg956

Description

@jfg956

Because of MySQL Bug#97345 (1), Orchestrator might miss that an intermediate master has failed.

The scenario go like this:

  1. the IO Thread is in state "Waiting for the slave SQL thread to free enough relay log space"

  2. the intermediate master (IM) fails

  3. Orchestrator is not able to connect to the IM, but the slaves are not seeing the IM as failed because of Bug#97345, so Orchestrator does not failover.

Discussed with Sholmi, the solution would be to run "STOP SLAVE IO_THREAD; START SLAVE IO_THREAD" on the slaves, which would trigger the slave to detect the failure (it is shown in Bug#97345 that this trigger the slave to detect the failure).

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions