MySQL Forums
Forum List  »  InnoDB clusters

Advanced Search
New Topic

Re: Dba.createCluster: ERROR: 1 table(s) do not have a Primary Key
Posted by: Sivan Koren
Date: May 23, 2017 03:15PM

I discovered a table that had two unique indexes defined. As you might have guessed, they did not come up as results in either of the suggested queries.

Dropping this table allowed me to create the cluster.

It would be useful in such cases if future versions of mysql-shell report which table is problematic.

Thanks again for your help.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Dba.createCluster: ERROR: 1 table(s) do not have a Primary Key
2126
Sivan Koren
May 23, 2017 10:57AM
Re: Dba.createCluster: ERROR: 1 table(s) do not have a Primary Key
1002
Frederic Descamps
May 23, 2017 11:20AM
Re: Dba.createCluster: ERROR: 1 table(s) do not have a Primary Key
949
Sivan Koren
May 23, 2017 11:51AM
Re: Dba.createCluster: ERROR: 1 table(s) do not have a Primary Key
906
Sivan Koren
May 23, 2017 03:15PM
Re: Dba.createCluster: ERROR: 1 table(s) do not have a Primary Key
1368
Matt Lord
May 23, 2017 06:45PM


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.