Skip to main content
NetApp Stage KB

Active IQ Unified Manager fails to install on Linux when install directories are pre-created

Views:
Visibility:
Public
Votes:
0
Category:
active-iq-unified-manager
Specialty:
OM
Last Updated:

Applies to

  • Active IQ Unified Manger (UM) 9.7+
  • Red Hat Enterprise Linux
  • CentOS

Issue

  • During the install of UM an error is seen when attempting to initialize 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.

  • The MySQL error log:

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.

 

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.
ad59a902-02c2-4254-977b-0423bd9f4185