预创建安装目录后， Active IQ Unified Manager 无法在 Linux 上安装

适用场景

• Active IQ 统一管理器(UM) 9.7及更高版本
• Red Hat Enterprise Linux
• CentOS

问题描述

• 在安装UM期间、尝试初始化MySQL时出现错误。

This package includes the MySQL server binary as well as related utilities
to run and administer a MySQL server.
Dec 14 16:11:45: Preinstall - mysql_installed_version=8.0.21
Dec 14 16:11:45: Preinstall - supported MySQL server version 8.0.21 is installed.
Redirecting to /bin/systemctl status mysqld.service
● mysqld.service - MySQL Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: failed (Result: exit-code) since Tue 2021-12-14 15:56:12 EST; 15min ago
     Docs: man:mysqld(8)
           http://dev.mysql.com/doc/refman/en/using-systemd.html
  Process: 22852 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS (code=exited, status=1/FAILURE)
  Process: 22628 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
 Main PID: 22852 (code=exited, status=1/FAILURE)
   Status: "Server startup in progress"
Dec 14 15:56:09 aiqum-server.netapp.com systemd[1]: Starting MySQL Server...
Dec 14 15:56:12 aiqum-server.netapp.com systemd[1]: mysqld.service: main process exited, code=exited, status=1/FAILURE
Dec 14 15:56:12 aiqum-server.netapp.com systemd[1]: Failed to start MySQL Server.
Dec 14 15:56:12 aiqum-server.netapp.com systemd[1]: Unit mysqld.service entered failed state.
Dec 14 15:56:12 aiqum-server.netapp.com systemd[1]: mysqld.service failed.
Dec 14 16:11:45: Preinstall - Starting mysql with --skip-grant-tables
Dec 14 16:11:46: Preinstall - waiting for mysql...
[...]
[...]
[...]
[...]
[...]
[...]
Dec 14 16:21:47: Preinstall - waiting for mysql...
Dec 14 16:21:48: Preinstall - FAILURE: Unable to init MySQL.

• MySQL错误日志：

2021-12-14T20:56:10.886992Z 0 [Warning] [MY-010086] [Server] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-12-14T20:56:10.887011Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2021-12-14T20:56:10.887091Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.21) initializing of server in progress as process 22824
2021-12-14T20:56:11.343752Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-12-14T20:56:11.346789Z 1 [ERROR] [MY-012576] [InnoDB] Unable to create temporary file; errno: 2
2021-12-14T20:56:11.346855Z 1 [ERROR] [MY-012929] [InnoDB] InnoDB Database creation was aborted with error Generic error. You may need to delete the ibdata1 file before trying to start up again.
2021-12-14T20:56:11.347175Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2021-12-14T20:56:11.347253Z 0 [ERROR] [MY-013455] [Server] The newly created data directory /opt/netapp/data/ by --initialize is unusable. You can remove it.
2021-12-14T20:56:11.347345Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-12-14T20:56:11.348012Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.21)  MySQL Community Server - GPL.
2021-12-14T20:56:11.783048Z 0 [Warning] [MY-010139] [Server] Changed limits: max_open_files: 10000 (requested 20510)
2021-12-14T20:56:11.783059Z 0 [Warning] [MY-010142] [Server] Changed limits: table_open_cache: 4745 (requested 10000)
2021-12-14T20:56:12.017940Z 0 [Warning] [MY-010086] [Server] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-12-14T20:56:12.017958Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2021-12-14T20:56:12.019758Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21) starting as process 22852
2021-12-14T20:56:12.028433Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2021-12-14T20:56:12.028598Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2021-12-14T20:56:12.028676Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-12-14T20:56:12.029436Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.21)  MySQL Community Server - GPL.