[ 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 01, 2018

Applies to:

Private Cloud Appliance - Version 1.0.1 and later
Linux 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]xists

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

Cause

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