SnapCenter无法启动MySQL服务、并出现6.0.1升级访问错误
适用场景
SnapCenter 6.0.1
问题描述
升级6.0.1后重新启动SnapCenter服务器会导致MySQL服务不断崩溃。
应用程序事件日志显示(取决于.Net版本、该版本应为8.0.X、最低8.0.5版本)：
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
MySQL日志显示以下内容：
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)