[ PCA ] MySQL is not Running and Fails to Start with "InnoDB: Unable to lock /u01/app/oracle/mysql/data/ibdata1, error: 11"
Last updated on JULY 01, 2018
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms