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
@2013-11-01 19:19:51 UTC

Attached:

(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.