[ 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 MAY 03, 2019
Applies to:Private Cloud Appliance - Version 1.0.1 and later
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]xists
Reviewing the following file :
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.
2018-06-27 12:10:05 3466281 [Note] InnoDB: Unable to open the first data file
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