当 ActiveIQ Unified Manager 从较新版本恢复到较旧版本时, MySQL 无法启动
适用于
- RHEL/CentOS 上的 ActiveIQ Unified Manager (AIQ UM) 9.x
- RHEL/CentOS 上的 OnCommand Unified Manager ( UM ) 9.x
问题
当从 ActiveIQ Unified Manager 还原到 Unified Manager 的早期版本时、 MySQL 无法启动。此 MySQL 启动失败还会导致以前版本的 UM 的新安装失败。
- 运行时的错误
systemctl status mysqld
为:
mysqld.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: failed (Result: start-limit) since Tue 2020-05-05 16:38:36 -07; 7min ago
Docs: man:mysqld(8)
http://dev.mysql.com/doc/refman/en/using-systemd.html
May 05 16:38:36 <server_name> systemd[1]: Failed to start MySQL Server.
May 05 16:38:36 <server_name> systemd[1]: Unit mysqld.service entered failed state.
May 05 16:38:36 <server_name> systemd[1]: mysqld.service failed.
May 05 16:38:36 <server_name> systemd[1]: mysqld.service holdoff time over, scheduling restart.
May 05 16:38:36 <server_name> systemd[1]: start request repeated too quickly for mysqld.service
May 05 16:38:36 <server_name> systemd[1]: Failed to start MySQL Server.
May 05 16:38:36 <server_name> systemd[1]: Unit mysqld.service entered failed state.
May 05 16:38:36 <server_name> systemd[1]: mysqld.service failed.
- 在检查
/var/log/mysqld.log
以下各项时:
2020-05-05T00:21:13.687193Z 0 [ERROR] [FATAL] InnoDB: Table flags are 0 in the data dictionary but the flags in file ./ibdata1 are 0x4000!
2020-05-04 17:21:13 0x7f758b34e780 InnoDB: Assertion failure in thread 140142823401344 in file ut0ut.cc line 918
- 在 UM 安装过程中, CLI 上出现的错误是:
Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details.
ERROR: MySQL pid missing after 600s, unable to continue.
Warning: %post(netapp-platform-base-9.5.0-2019.04.J68.x86_64) scriptlet failed, exit status 1
Non-fatal POSTIN scriptlet failure in rpm package netapp-platform-base-9.5.0-2019.04.J68.x86_64
FAILURE: netapp-platform-base package is installed, but in in a corrupt state. Install netapp-platform-base package and try again.