Unable to start MySQL INnoDB Cluster version 5.7 : The Metadata is inaccessible
Hello ,
I have successfully installed MySQL InnoDB Cluster version 5.7 whith 3 nodes.
Node1 (Mysql1) was the Primary node , MySQL2+3 Nodes where the Sconderies nodes.
The cluster was up and running for a while.
After rebooting ALL the machines the cluister failed to start.
-- Connect to Originally Primary machine :
[mysql@MySql1 ~]$ mysqlsh
MySQL Shell 8.0.3-dmr
Copyright (c) 2016, 2017, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type '\help' or '\?' for help; '\quit' to exit.
MySQL JS > var i1='admin@mysql1:3306'
MySQL JS > var i2='admin@mysql2:3306'
MySQL JS > var i3='admin@mysql3:3306'
MySQL JS > shell.connect(i1)
Please provide the password for 'admin@mysql1:3306': *****
Creating a session to 'admin@mysql1:3306'
Your MySQL connection id is 39
No default schema selected; type \use <schema> to set one.
MySQL JS >
MySQL JS > dba.rebootClusterFromCompleteOutage('mycluster')
Reconfiguring the cluster 'mycluster' from complete outage...
The instance 'mysql2:3306' was part of the cluster configuration.
Would you like to rejoin it to the cluster? [y|N]: y
The instance 'mysql3:3306' was part of the cluster configuration.
Would you like to rejoin it to the cluster? [y|N]: y
Dba.rebootClusterFromCompleteOutage: Dba.rebootClusterFromCompleteOutage:
The active session instance isn't the most updated in comparison with the ONLINE instances of the Cluster's metadata.
Please use the most up to date instance: 'mysql3:3306'. (RuntimeError)
MySQL JS >
-- So , i tried to connect to Node 3 and run :
[mysql@MySql3 ~]$ mysqlsh
MySQL Shell 8.0.3-dmr
Copyright (c) 2016, 2017, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
MySQL JS > cluster.status();
ReferenceError: cluster is not defined
MySQL JS > var cluster = dba.rebootClusterFromCompleteOutage();
The Metadata is inaccessible, an active session is required (LogicError)
Also all the MySQL shows :
mysql> select * from performance_schema.replication_group_members;
+---------------------------+-----------+-------------+-------------+--------------+
| CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE |
+---------------------------+-----------+-------------+-------------+--------------+
| group_replication_applier | | | NULL | OFFLINE |
+---------------------------+-----------+-------------+-------------+--------------+
1 row in set (0.00 sec)
Please advise how to restart the cluster
Thanks
Subject
Views
Written By
Posted
Unable to start MySQL INnoDB Cluster version 5.7 : The Metadata is inaccessible
4518
January 06, 2018 11:39AM
1197
March 28, 2018 01:22AM
Sorry, you can't reply to this topic. It has been closed.
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.