Re: Cannot remove 'MISSING' instances by rescan()

[Miguel Araujo]

Hi,

Thank you for the information.

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