also this one
https://commons.wikimedia.org/wiki/File:%E0%B8%A0%E0%B8%B2%E0%B8%9E%E0%B8%96%E0%B9%88%E0%B8%B2%E0%B8%A2%E0%B8%97%E0%B8%B2%E0%B8%87%E0%B8%AD%E0%B8%B2%E0%B8%81%E0%B8%B2%E0%B8%A8_%E0%B8%A1%E0%B8%A7%E0%B8%81%E0%B9%80%E0%B8%AB%E0%B8%A5%E0%B9%87%E0%B8%81.jpg

3 more
https://commons.wikimedia.org/wiki/File:Gas_natural_3.jpg
https://commons.wikimedia.org/wiki/File:Heather_Morris_z1.jpg
https://commons.wikimedia.org/wiki/File:Jabalpur.jpg

To clarify something - Given some file, does this error always appear when deleting, or is it more intermittent - If you try deleting it a couple times, it eventually succedes?

No, it appears every time.

5 more :((
https://commons.wikimedia.org/wiki/File:Ugglas.jpg
https://commons.wikimedia.org/wiki/File:Horse_ebooks%27_Twitter_Avatar.jpg
https://commons.wikimedia.org/wiki/File:0ad70f276469aaf65de8826322559079.jpeg
https://commons.wikimedia.org/wiki/File:BrobackaTunneln.jpg
https://commons.wikimedia.org/wiki/File:Blackberry_messenger_disponible_para_Androi_ios.jpg

I created a category to list all files, but I can't edit them. https://commons.wikimedia.org/wiki/Category:Files_which_cannot_be_deleted_due_to_bug_56487

and more files
https://commons.wikimedia.org/wiki/File:Tony%26Steve.jpg
https://commons.wikimedia.org/wiki/File:3-Aletta-Ocean-perfect-pornstar.jpg
https://commons.wikimedia.org/wiki/File:1-Gianna-Michaels-outdoor.jpg
https://commons.wikimedia.org/wiki/File:1053042_515010541886737_1301021685_o.jpg
https://commons.wikimedia.org/wiki/File:%D0%A1%D0%B5%D1%80%D0%B3%D1%96%D0%B9_%D0%9E%D0%BB%D0%B5%D0%BE%D0%BB%D0%B5%D0%BD%D0%BA%D0%BE.jpg

1 more: https://commons.wikimedia.org/wiki/File:4-Gianna-Michaels-giving-blowjob.jpg

The problem does happen when editing the page, not just deleting. This doesn't seems to be related to MediaStorage:

Function: Revision::insertOn
Error: 1205 Lock wait timeout exceeded; try restarting transaction (10.64.32.29)

But other file description pages seem to be editable without problem (as seen in Special:RecentChanges.

What's going on?

https://commons.wikimedia.org/wiki/File:%D0%9E%D0%BB%D1%8C%D0%B3%D0%B0_%D0%9A%D0%BE%D0%BF%D0%BE%D1%81%D0%BE%D0%B2%D0%B0.jpg
https://commons.wikimedia.org/wiki/File:%D0%9B%D0%B5%D0%BA%D1%86%D0%B8%D0%B8_%D0%BF%D0%BE_%D0%BE%D0%B1%D1%89%D0%B5%D0%B9_%D0%BF%D1%81%D0%B8%D1%85%D0%BE%D0%BB%D0%BE%D0%B3%D0%B8%D0%B8.jpeg

When I purge one of these files I get:

A database query error has occurred. This may indicate a bug in the software.

• Function: Title::invalidateCache
• Error: 1205 Lock wait timeout exceeded; try restarting transaction (10.64.32.29)

So basically no matter what operation you do to these pages, you get lock contention from some different method (although always the same method for any given operation).

Null edit, then delete works.

I think related to global usage.

I was previously unable to edit https://commons.wikimedia.org/wiki/File:Ugglas.jpg - I removed the file from its use at ukwikipedia. Waited a couple seconds for global usage section to disappear, after that I could edit the file. (Just one test, so could be some sort of coincidence, but something to follow up at least)

All files which are listed here were deleted by now

hmm, perhaps comment 11 and comment 12 are coincidences. According to https://icinga.wikimedia.org/cgi-bin/icinga/history.cgi?host=db1059&service=MySQL+Idle+Transactions there were alerts for the commons db from "2013-11-01 19:10:08" to about "2013-11-01 21:04:53". I don't really know enough about how mysql works to know what that means (My knowledge of the inner workings of mysql is pretty much nill), but I'd guess it means server had some sort of problem which server got over. The timeline corresponds with those reported in this bug.

(In reply to comment #14)
Thanks for the link.
Also lowering priority.

Also reported in https://en.wikipedia.org/w/index.php?title=Wikipedia:Village_pump_%28technical%29&oldid=580135511#Failed_action.3Dpurge