[ PCA ] MySQL is not Running and Fails to Start with "InnoDB: Unable to lock /u01/app/oracle/mysql/data/ibdata1, error: 11"
(Doc ID 2416162.1)
Last updated on JULY 17, 2020
Applies to:
Private Cloud Appliance - Version 1.0.1 and laterLinux x86-64
Symptoms
On Oracle Private Cloud Appliance, all supported releases.
When attempting to start the ovmm_mysql daemon :
# service ovmm_mysql start
The service immediately returns :
Starting OVMM MySQL [ OK ]
But when checking :
# service ovmm_mysql status
MySQL is not running, but lock file (/var/lock/subsys/ovmm_[FAILED]exists
Reviewing the following file :
/u01/app/oracle/mysql/mysqld.err
The following two lines are repeatedly being logged :
2018-06-27 12:10:05 3466281 [ERROR] InnoDB: Unable to lock /u01/app/oracle/mysql/data/ibdata1, error: 11
2018-06-27 12:10:05 3466281 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
Finally :
2018-06-27 12:10:05 3466281 [Note] InnoDB: Unable to open the first data file
Changes
n/a
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |