Cant unlock file (Errcode: 11) on my new tables
My suspicion would be that you are either using external_locking or you have character set issues.

It might center around the following bugs


Error 11 - can't unlock file when using external_locking
Inconsistent use of column alias In ORDER BY clause that specified collation


I would suggest upgrading to MySQL 5.6 as this situation is consistent with MySQL 5.1.