MySQL Forums
Forum List  »  InnoDB clusters

Re: We cannot remove a '(MISSING)' instance under Multi-Primary mode.
Posted by: Miguel Araujo
Date: January 14, 2020 11:44AM

Hi 佳晃 富田,

This is a known issue that has been fixed in Shell 8.0.19.

The root cause of the issue is that the InnoDB Cluster metadata contains tables with cascading foreign keys constraints that are not supported by multi-primary GR groups. Issuing a DELETE FROM mysql_innodb_cluster_metadata.instances ... causes the error you reported.

This has been fixed with the introduction of the new Metadata Schema version in 8.0.19.

Please upgrade your Shell version to 8.0.19 and upgrade the Metadata schema using the command:

dba.upgradeMetadata()

After a successful upgrade of your Metadata schema, you'll be able to remove the (MISSING) instances you desire to remove.

Cheers,
Miguel

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: We cannot remove a '(MISSING)' instance under Multi-Primary mode.
326
January 14, 2020 11:44AM


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.