Bug #100488 The Cluster could not be dissolved
Submitted: 10 Aug 2020 22:26 Modified: 13 Aug 2020 12:38
Reporter: Farzin Rezaeian Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL for Windows: Installer Severity:S3 (Non-critical)
Version:8.0.21 OS:Windows
Assigned to: CPU Architecture:x86
Tags: cluster, Disover, mysql installer, Remove cluster

[10 Aug 2020 22:26] Farzin Rezaeian
Description:
Coulnd not delete Cluster. Following Error was logged:

Beginning configuration step: Removing cluster leftovers

Preparing administrative tools for InnoDB Cluster.
Creating InnoDB cluster administrative tools temp folder...
Extracting the production InnoDB cluster administrative tools...
Production InnoDB cluster administrative tools were extracted successfully.
Production InnoDB cluster administrative tools prepared successfully.
Dissolving the production InnoDB cluster...
WARNING: Error dropping recovery account 'mysql_innodb_cluster_1'@'%' for instance '192.168.0.54:3306'
ERROR: The Cluster could not be dissolved. Message: Cluster.dissolve: Failed to execute query on Metadata server 192.168.0.54:3306: Error on observer while running replication hook 'before_commit'. at C:\Users\Farzin\AppData\Local\Temp\bd061bab-7b54-4388-9558-a72486255199\innodbclusteradmin\bin\ic.js:1531:6
in       throw ("ERROR: The Cluster could not be dissolved. Message: " + e.message);
         ^
Deleting the production InnoDB cluster administrative tools temporary directory...
Deleted the InnoDB cluster admin tools temporary directory successfully...
There was an error dissolving the existing InnoDB cluster.
Validate that the parameters used to connect to the seed instance are correct and that the host is reachable.
Ended configuration step: Removing cluster leftovers

How to repeat:
1. Install Mysql version 8.0.21.
2. Configure as Production Cluster (Primary Server)
3. Reconfigure Server Using MSI as Standalone Server.
4. Check Disover Cluster and Continure
5. Press Execute
6. Fails with red Cross on first step.
7. Log shows the error posted above
[13 Aug 2020 12:38] MySQL Verification Team
Hello Farzin Rezaeian,

Thank you for the bug report.
I tried to reproduce your issue on windows 10 with MySQL Server 8.0.21 but I am not seeing any issues at my end.

Regards,
Ashwini Patil
[13 Aug 2020 12:39] MySQL Verification Team
8.0.21 test results

Attachment: 100488_test_results.PNG (image/png, text), 218.27 KiB.