[PCA 2.x] MySQL Fails to Start with "InnoDB: Unable to lock /u01/app/oracle/mysql/data/ibdata1, error: 11" (Doc ID 2416162.1)

Last updated on AUGUST 24, 2022

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.