MySQL Router failed: ERROR Failed fetching metadata from any of the metadata servers
(Doc ID 2695830.1)
Last updated on AUGUST 25, 2024
Applies to:
MySQL Server - Version 8.0 and laterInformation in this document applies to any platform.
Symptoms
Dropping cluster metadata using MySQL Shell, such as dba.dropMetadataSchema(), causes Router to drop all current connections and forbid new connections. This causes a full outage.
ERROR
-----------------------
2020-07-29 10:46:33 metadata_cache WARNING [xxxxxxxxxxxxx] Tried node on host <host_name>, port 3306 as a metadata server, it does not contain metadata for cluster xxxxxxxx-xxx-xxxx-xxxx-xxxxxxxxxxxx
2020-07-29 10:46:33 metadata_cache WARNING [xxxxxxxxxxxxx] No replicasets defined for cluster '<cluster_name>'
2020-07-29 10:46:33 metadata_cache WARNING [xxxxxxxxxxxxx] Tried node on host <host_name>, port 3306 as a metadata server, it does not contain metadata for cluster xxxxxxxx-xxx-xxxx-xxxx-xxxxxxxxxxxx
2020-07-29 10:46:33 metadata_cache ERROR [xxxxxxxxxxxxx] Failed fetching metadata from any of the 3 metadata servers.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |