MySQL Forums
Forum List  »  InnoDB

Re: A bug with innodb on Linux? Can't be started a second time.
Posted by: Sarah Tisdale
Date: May 02, 2005 06:01PM

I routinely run into this problem every time the machine my mysql server is on goes down.

Since my database is on a remote NFS disk, I'm pretty sure the problem has to do with a bug in NFS advisory file locking. It appears that sometimes these locks don't get cleared properly and one can end up with files locked by non-existent processes.
Here are some links about that bug:
https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=111918
http://www.ussg.iu.edu/hypermail/linux/kernel/0312.0/1284.html
http://www.ussg.iu.edu/hypermail/linux/kernel/0312.1/0462.html

I wrote a small C program that uses "fcntl" system call to read and dump the information about who is locking the file. In every case, the lock owner is a process that doesn't exist.

Quick/dirty workaround: Simply make a new copy of the database with "gcp -a". The new copy starts up fine.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: A bug with innodb on Linux? Can't be started a second time.
10818
May 02, 2005 06:01PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.