Last modified: 2014-02-28 21:20:25 UTC
Hello, I got an error message while deleting files: https://commons.wikimedia.org/w/index.php?title=File:Moraglia_serve_alla_mensa_dei_poveri_Ca_Letizia_24-03-2012.jpg&action=delete A database query error has occurred. This may indicate a bug in the software. Function: WikiPage::pageData Error: 1205 Lock wait timeout exceeded; try restarting transaction (10.64.32.29) Also for https://commons.wikimedia.org/wiki/File:Krystal_Jung.png https://commons.wikimedia.org/wiki/File:Demy_The_Sun.jpg https://commons.wikimedia.org/wiki/File:Yuri_boyka_brother..jpg https://commons.wikimedia.org/wiki/File:Sampaio_1972_campe%C3%A3o.png https://commons.wikimedia.org/wiki/File:Sampaio_1938.png It is a serious problem if we can't delete files.
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
