Last modified: 2014-05-22 16:14:08 UTC
Purging this huge video file gives the 1205 error: https://commons.wikimedia.org/w/index.php?title=File%3AWikimania_2011_-_Workshops_V.ogv&action=purge
WikiFilePage calls $this->mFile->upgradeRow() in doPurge(), which is wildly inappropriate in this case. Maybe something like the 'forRefresh' flag for thumbnail purging can also be applied here. It could also use the job queue instead.
component -> file management. Really not a db problem (other then the db locks are held during purging, which probably shouldn't be)
(In reply to comment #1) > WikiFilePage calls $this->mFile->upgradeRow() in doPurge(), which is wildly > inappropriate in this case. Maybe something like the 'forRefresh' flag for > thumbnail purging can also be applied here. It could also use the job queue > instead. To be more specific this would only be for large files (and could work similar to the TimedMediaHandler extension).
Hello, I got the same 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.
Created attachment 13660 [details] @2013-11-01 19:19:51 UTC
(In reply to comment #4) > Hello, > > I got the same 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. House keeping reference - I advised Yannf to file bug 56487 for this, as it seems unlikely the deadlock surounding file metadata extraction is the same cause as a deadlock during deletion.
Unlicking this cookie. This would be a good bug for the current multimedia team to examine.
