• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 507
  • Last Modified:

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

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?

Thanks,

Bernd

0
BAJ05
Asked:
BAJ05
  • 3
  • 2
1 Solution
 
Aleksandar BradarićSoftware DeveloperCommented:
> 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...
0
 
BAJ05Author Commented:
how can I find out which specific file access operation is going bad on my Windows box?
0
 
Aleksandar BradarićSoftware DeveloperCommented:
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...
0
 
BAJ05Author Commented:
And what is the role of the external-locking directive ? Does this have anything to do with this?
0
 
Aleksandar BradarićSoftware DeveloperCommented:
I don't think so.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now