由于 MySQL 服务无法启动, Unified Manager 升级失败
适用场景
- Unified Manager 7.2+
- RHEL/CentOS 6 或 7
问题描述
尝试从 Unified Manager 升级失败, MySQL 错误日志报告以下错误:
/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
报告的文件可能因环境而异。
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