ERROR 11 (HY000): Can't unlock file (Errcode: 11)

Posted on 2007-07-22
Last Modified: 2008-01-09
Hi there,
Is it true that problems related to error 11 are most likely bugs in MySQL?

I have a query involving a union statement with a group and order by
statement around it. The total data that has to be handled by the union
statement is in the 100,000 or millions rows. I am using Windows XP with
mysql 5.0.37.

This problem doesn't occur when using less data. It has occurred numerous
times in past couple of months with different queries and also myisamchk and
I found some information on the web that made me believe this is related to
a bug in MySQL. Now I am getting to a point where I am getting annoyed by
this and trying to find workarounds.

So, my question: is there anything I can do? Has anybody else this problem?



Question by:BAJ05
    LVL 17

    Accepted Solution

    > Is it true that problems related to error 11 are most likely bugs in MySQL?

    I've not had such an impression. As far as I know, `error 11` is related to problems with file access in general. Whether a file was already in use when MySQL tried to access it or the file got too big - it was always file related. Maybe someone else had a different experience...

    Author Comment

    how can I find out which specific file access operation is going bad on my Windows box?
    LVL 17

    Expert Comment

    Not sure I know way - you'll have to watch and see. In your case, it could even be that you're having problem with temporary tables if the error happens _only_ when you retrieve large amount of data from the DB. You can try breaking up that query in two or more parts to get a better idea which data it is...

    Author Comment

    And what is the role of the external-locking directive ? Does this have anything to do with this?
    LVL 17

    Expert Comment

    I don't think so.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Loading csv or delimited data files to MySQL database is a very common task frequently questioned about and almost every time LOAD DATA INFILE comes to the rescue. Here we will try to understand some of the very common scenarios for loading data …
    Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now