MySQL Forums
Forum List  »  InnoDB clusters

Unable to start MySQL INnoDB Cluster version 5.7 : The Metadata is inaccessible
Posted by: Yoav Ben Moha
Date: January 06, 2018 11:39AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Unable to start MySQL INnoDB Cluster version 5.7 : The Metadata is inaccessible
4275
January 06, 2018 11:39AM


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.