Bug #111717 MySQL InnoDB Cluster Requires Manual RebootClusterFromCompleteOutage

• Submitted: 11 Jul 2023 11:47
• Modified: 11 Jul 2023 22:27
• Reporter: Tuhinanshu Mr
• Status: Not a Bug
• Category: MySQL Server
• Severity: S1 (Critical)
• Version: 8.0.33
• OS: Windows
• Assigned to: MySQL Verification Team
• CPU Architecture: Other (x64)

[11 Jul 2023 11:47] Tuhinanshu Mr

Description:
I have 2 systems running on MySQL 8.0.33 version and I have setup innodbCluster on it running in SinglePrimaryMode. Problem I am facing is whenever we restart the servers at weekend, post server restart, we have to manually rebootClusterFromCompleteOutage in mySQL shell and run Super_read_only = off and Read_only = off on Primary Node.
Is there any alternative to this to automatically take care of this during server restart?

How to repeat:
Setup Innodb Cluster in Single Primary Mode on 2 servers and turn off both servers. Post server restart, cluster is not available

[11 Jul 2023 22:27] MySQL Verification Team

Hi,

> on 2 servers and turn off both servers

This is a full outage so RebootClusterFromCompleteOutage is proper way to boot it up. 

We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug. 

For details on getting support for MySQL products see http://www.mysql.com/support/
You can also check our forums (free) at http://forums.mysql.com/

Thank you for your interest in MySQL.