Bug #116231 Router reports: Ignoring unsupported instance <host:port>, type: 'group-member'
| Submitted: | 25 Sep 2024 15:01 | Modified: | 8 Jan 2025 16:39 |
|---|---|---|---|
| Reporter: | Daniel Thorell | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | Shell AdminAPI InnoDB Cluster / ReplicaSet | Severity: | S3 (Non-critical) |
| Version: | 8.4.1 | OS: | Red Hat (8.9) |
| Assigned to: | CPU Architecture: | x86 |
[25 Sep 2024 15:01]
Daniel Thorell
[17 Dec 2024 11:21]
Gary Broughton
I've seen exactly the same errors, though with 8.4.3 Router connecting to an 8.0.36 Replicaset. If I move our Replicaset itself up to 8.4.3, 8.4.3 Router still displays the same errors (but 8.0.36 Router WILL work with the 8.4.3 Replicaset). Metadata is at the latest 2.2.0, and reports itself as in a "consistent" state.
[17 Dec 2024 15:26]
Miguel Araujo
When upgrading the metadata schema (mysql_innodb_cluster_metadata) of a ReplicaSet to version 2.2.0, the
'instances' table is not populated correctly. This results in
MySQL Router failing to recognize the topology and rejecting connections.
Metadata model 2.2.0 introduces the 'instance_type' column in the
'instances' table with the enum values: 'group-member', 'async-member',
and 'read-replica'. During the upgrade via 'dba.upgrade_metadata()', the
command does not determine whether the topology is an InnoDB Cluster or
a ReplicaSet. Consequently, the 'instance_type' column is assigned its
default value ('group-member'), leading to incorrect metadata.
As a workaround (while the bug exists), please update the 'instances' table and set all ReplicaSet members to `async-member`.
[18 Dec 2024 11:00]
Gary Broughton
Thank you. I'd actually found an answer by removing and re-adding each instance, and that altered the instance-type to 'aysnc-member', allowing router to connect. Although manually altering the fields is of course much easier. :)
[8 Jan 2025 16:39]
Edward Gilmore
Posted by developer: Added the following note to the MySQL Shell 8.4.4 and 9.2.0 release notes: The ReplicaSet metadata schema table INSTANCES, was not populated properly when upgrading the metadata schema to version 2.2.0. As a result, MySQL Router did not recognise the topology and rejected connections to it.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.052 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.