Skip to main content

NetApp_Insight_2020.png 

NetApp Knowledgebase

Unified Manager upgrade fails due to MySQL service unable to start

Views:
220
Visibility:
Public
Votes:
0
Category:
oncommand-unified-manager
Specialty:
nfs
Last Updated:

Applies to

  • Unified Manager 7.2+
  • RHEL/CentOS 6 or 7

Issue

Attempt to upgrade from Unified Manager fails, and the MySQL error log reports the following error:
 

/var/log/mysql/error.log 

2019-05-03T10:16:37.578843Z 0 [ERROR] InnoDB: Operating system error number 116 in a file operation.
2019-05-03T10:16:37.578870Z 0 [ERROR] InnoDB: Error number 116 means 'Stale file handle'
2019-05-03T10:16:37.578876Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/...ror-codes.html
2019-05-03T10:16:37.578881Z 0 [ERROR] InnoDB: File .//ocum-backup: 'stat' returned OS error 216.
2019-05-03T10:16:37.578885Z 0 [ERROR] InnoDB: os_file_readdir_next_file() returned -1 in directory ./, crash recovery may have failed for some .ibd files!
2019-05-03T10:16:37.578920Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error


The file reported might be different depending on the environment.

The following errors are reported on the install.log:
 

May 03 10:57:00 server01.netapp.com systemd[1]: Failed to start MySQL Server.
May 03 10:57:00 server01.netapp.com systemd[1]: Unit mysqld.service entered failed state.
May 03 10:57:00 server01.netapp.com systemd[1]: mysqld.service failed.
May 03 10:57:00 server01.netapp.com systemd[1]: mysqld.service holdoff time over, scheduling restart.
May 03 10:57:00 server01.netapp.com systemd[1]: start request repeated too quickly for mysqld.service
May 03 10:57:00 server01.netapp.com systemd[1]: Failed to start MySQL Server.
May 03 10:57:00 server01.netapp.com systemd[1]: Unit mysqld.service entered failed state.
May 03 10:57:00 server01.netapp.com systemd[1]: mysqld.service failed.
Changing mysql configuration to small
May 03 11:07:17:  INFO: Starting MySQL database...
Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details.
May 03 11:07:28:  Granting privileges to jboss user for Unified Manager related databases...
mysql_upgrade: Got error: 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) while connecting to the MySQL server
Upgrade process encountered error and will not continue.
May 03 11:07:28:  Failed while granting privileges to jboss user for Unified Manager related databases
May 03 11:07:28:  preun_upgrade_ocum called

 

CUSTOMER EXCLUSIVE CONTENT

Registered NetApp customers get unlimited access to our dynamic Knowledge Base.

New authoritative content is published and updated each day by our team of experts.

Current Customer or Partner?

Sign In for unlimited access

New to NetApp?

Learn more about our award-winning Support