Dba.createCluster: ERROR: 1 table(s) do not have a Primary Key or Primary Key Equivalent (non-null unique key) on sys.sys_config
Why i'm getting this Error on sys.sys_config ?
here is the full message in verbose mode :
mysql-js> cluster = dba.createCluster('myCluster');
A new InnoDB cluster will be created on instance 'cl@x.x.x.x:3306'.
=========================== MySQL Provision Output ===========================
Enter the password for server (cl@x.x.x.x:3306):
Running check command.
Checking Group Replication prerequisites.
* Comparing options compatibility with Group Replication... PASS
Server configuration is compliant with the requirements.
* Checking server version... PASS
Server is 5.7.19
* Checking that server_id is unique... PASS
The server_id is valid.
* Checking compatibility of Multi-Threaded Slave settings... PASS
Multi-Threaded Slave settings are compatible with Group Replication.
* Checking compliance of existing tables... FAIL
ERROR: 1 table(s) do not have a Primary Key or Primary Key Equivalent (non-null unique key).
sys.sys_config
Group Replication requires tables to use InnoDB and have a PRIMARY KEY or PRIMARY KEY Equivalent (non-null unique key). Tables that do not follow these requirements will be readable but not updateable when used with Group Replication. If your applications make updates (INSERT, UPDATE or DELETE) to these tables, ensure they use the InnoDB storage engine and have a PRIMARY KEY or PRIMARY KEY Equivalent.
You can retry this command with the --allow-non-compatible-tables option if you'd like to enable Group Replication ignoring this warning.
ERROR: Error checking instance: The operation could not continue due to the following requirements not being met:
Non-compatible tables found in database.
==============================================================================
Warning: The instance configuration needs to be changed in order to
create an InnoDB cluster. To see which changes will be made, please
use the dba.checkInstanceConfiguration() function before confirming
to change the configuration.
Should the configuration be changed accordingly? [y|N]: n
Subject
Views
Written By
Posted
Dba.createCluster: ERROR: 1 table(s) do not have a Primary Key or Primary Key Equivalent (non-null unique key) on sys.sys_config
3628
August 04, 2017 01:48PM
1296
August 04, 2017 01:54PM
1376
August 06, 2017 11:56PM
2846
August 07, 2017 04:20AM
1314
August 09, 2017 10:37AM
1620
August 18, 2017 02:33AM
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.