MySQL Forums
Forum List  »  InnoDB clusters

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Dba.createCluster: ERROR: 1 table(s) do not have a Primary Key
755
May 23, 2017 03:15PM


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.