Skip to main content
NetApp Knowledge Base

Unable to start MYSQL service in AIQUM

  1. Last updated
  2. Save as PDF
Views:
372
Visibility:
Public
Votes:
0
Category:
active-iq-unified-manager
Specialty:
om
Last Updated:

Applies to

  • ActiveIQ Unified Manager 9.6P1
  • CentOS Linux

Issue

  • When attempting to start MySQL, the following error is seen:
mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details
 
  • MySQL error.logs shows below error continuously
2023-01-04T08:25:24.189232Z 0 [Note] InnoDB: Unable to open the first data file
2023-01-04T08:25:24.189267Z 0 [ERROR] InnoDB: Operating system error number 11 in a file operation.
2023-01-04T08:25:24.189314Z 0 [ERROR] InnoDB: Error number 11 means 'Resource temporarily unavailable'
2023-01-04T08:25:24.189320Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/...ror-codes.html
2023-01-04T08:25:24.189325Z 0 [ERROR] InnoDB: Cannot open datafile './ibdata1'
2023-01-04T08:25:24.189376Z 0 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
2023-01-04T08:25:24.189384Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Cannot open a file
2023-01-04T08:25:24.790079Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2023-01-04T08:25:24.790126Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2023-01-04T08:25:24.790132Z 0 [ERROR] Failed to initialize builtin plugins.
2023-01-04T08:25:24.790138Z 0 [ERROR] Aborting
2023-01-04T08:25:56.099410Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2023-01-04T08:25:56.099459Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.

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.