SnapCenter fails to start MySQL Service with access error after 6.0.1 upgrade
Applies to
SnapCenter Server 6.0.1
Issue
Rebooting the SnapCenter Server after the upgrade to 6.0.1 causes the MySQL Service to keep crashing.
The Application event log shows (depending on .net version, which should be an 8.0.X, minimally a 8.0.5 revision):
Application: w3wp.exe
CoreCLR Version: 8.0.1124.51707
.NET Version: 8.0.11
Description: The process was terminated due to an unhandled exception.
Exception Info: Microsoft.EntityFrameworkCore.Storage.RetryLimitExceededException: The maximum number of retries (3) was exceeded while executing database operations with 'MySqlRetryingExecutionStrategy'. See the inner exception for the most recent failure.
...
Category: Microsoft.Extensions.Hosting.Internal.Host
EventId: 11
Hosting failed to start
The MySQL log shows the following:
ERROR 3501 (HY000): The ACL operation failed due to the following error from SE: errcode 165 - Table is read only
mysql> SET PASSWORD FOR 'root'@'localhost' = 'SMSGr0up';
ERROR 3501 (HY000): The ACL operation failed due to the following error from SE: errcode 165 - Table is read only
mysql> SET PASSWORD FOR 'root'@'localhost' = 'SMSGr0up';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| read_only | OFF |
+---------------+-------+
1 row in set (0.01 sec)