Reputation: 15365

I got an error when starting mysql: Unable to lock ./ibdata1, error: 11

when removed the ibdata1 it worked, and I cant understand how it happened. I checked with ps and there was no mysql process. also permissions were ok. Is there a way to check the integrity of this file?

Upvotes: 0

Answers (4)

Pankaj Joshi

Reputation: 42

this is one of the issue using NFS for MySQL , one quick solution can be found on

http://onaxer.com/blog/blog/2010/06/01/innodb-unable-to-lock-ibdata1-error-37/

Upvotes: 1

oshai

Reputation: 15365

Found out that this is a known bug when using mysql on NFS.

Upvotes: 0

Itay Moav -Malimovka

Reputation: 53607

I guess some other process is talking to this resource/file you don't have the right permissions on that file.
You could restart the computer as an easy solution.
If that does not help, you need to find out out who else is using that file. But first, check permissions.

Upvotes: 0

Paul Tomblin

Reputation: 182822

Did you restart mysql with the wrong user at some point? What were the permissions on the file and the directory it was in?

Upvotes: 0

I got an error when starting mysql: Unable to lock ./ibdata1, error: 11

Answers (4)

Related Questions