Skip to main content
NetApp Knowledge Base

SnapCenter fails to start MySQL Service with access error after 6.0.1 upgrade

Views:
37
Visibility:
Public
Votes:
0
Category:
snapcenter
Specialty:
snapx
Last Updated:

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)

 

Sign in to view the entire content of this KB article.

New to NetApp?

Learn more about our award-winning Support

NetApp provides no representations or warranties regarding the accuracy or reliability or serviceability of any information or recommendations provided in this publication or with respect to any results that may be obtained by the use of the information or observance of any recommendations provided herein. The information in this document is distributed AS IS and the use of this information or the implementation of any recommendations or techniques herein is a customer's responsibility and depends on the customer's ability to evaluate and integrate them into the customer's operational environment. This document and the information contained herein may be used solely in connection with the NetApp products discussed in this document.