Special:Nuke fails for uploaded files on commons with DBQueryTimeoutError
Closed, DuplicatePublic

Description

A few months ago, Special:Nuke started taking a very long time to open (as in, 20 seconds or so).

For some users it times out altogether. I just tried to hit https://commons.wikimedia.org/wiki/Special:Nuke/MathewMunro and it failed with the following text.

Perhaps someone incorrectly removed a database index?

MediaWiki internal error.

Original exception: [W1OcggpAICsAAL8xAnQAAACS] 2018-07-21 20:51:11: Fatal exception of type "Wikimedia\Rdbms\DBQueryTimeoutError"

Exception caught inside exception handler.

Set $wgShowExceptionDetails = true; and $wgShowDBErrorBacktrace = true; at the bottom of LocalSettings.php to show detailed debugging information.

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJul 21 2018, 8:57 PM
Framawiki renamed this task from Special:Nuke fails for uploaded files on commons to Special:Nuke fails for uploaded files on commons with DBQueryTimeoutError.
Framawiki added a subscriber: Framawiki.
Marostegui added a subscriber: Marostegui.

Let's follow up on T197940 as it looks pretty much the same thing