On Special:Nuke...
MediaWiki internal error. Original exception: [XCfJ4ApAADwAABLHhEYAAABN] 2018-12-29 19:25:16: Fatal exception of type "Wikimedia\Rdbms\DBQueryTimeoutError" Exception caught inside exception handler. Set $wgShowExceptionDetails = true; at the bottom of LocalSettings.php to show detailed debugging information.
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | PRODUCTION ERROR | None | T212690 DBQueryTimeoutError on Wikidata's Special:Nuke | ||
| Resolved | Ladsgroup | T188679 Nuke should batch the deletions |
It happens every time I leave the pattern field blank, even when the maximum number of pages is, for example, 5.
So this is the query:
SELECT rc_namespace,rc_title,rc_timestamp FROM `recentchanges` WHERE ((rc_new = 1) OR (rc_log_type = 'upload' AND rc_log_action = 'upload')) AND ((rc_user = '24')) AND rc_namespace = '0' GROUP BY rc_namespace, rc_title, rc_timestamp ORDER BY rc_timestamp DESC LIMIT 22
And this is the server that was failing was db1109
+------+-------------+---------------+------+-------------------------------------------------------------------------------------------------------------+----------------+---------+-------+----------+----------------------------------------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +------+-------------+---------------+------+-------------------------------------------------------------------------------------------------------------+----------------+---------+-------+----------+----------------------------------------------+ | 1 | SIMPLE | recentchanges | ref | new_name_timestamp,rc_ns_usertext,rc_name_type_patrolled_timestamp,rc_ns_actor,rc_namespace_title_timestamp | rc_ns_usertext | 4 | const | 10906882 | Using where; Using temporary; Using filesort | +------+-------------+---------------+------+-------------------------------------------------------------------------------------------------------------+----------------+---------+-------+----------+----------------------------------------------+ 1 row in set (0.00 sec)
Change 487641 had a related patch set uploaded (by Matěj Suchánek; owner: Matěj Suchánek):
[mediawiki/extensions/Nuke@master] Don't use GROUP BY in getNewPages
I am going to be bold and say that maybe the solution to timeouts (or at least part of the solution for timeouts) like this one reported on enwiki:
"PHP fatal error: entire web request took longer than 60 seconds and timed out"
would be T188679
Change 487641 had a related patch set uploaded (by Matěj Suchánek; owner: Matěj Suchánek):
[mediawiki/extensions/Nuke@master] Don't use GROUP BY in getNewPages
Change 715323 had a related patch set uploaded (by Ladsgroup; author: Amir Sarabadani):
[mediawiki/extensions/Nuke@master] Queue deletion job instead of trying to delete the pages
Change 715323 merged by jenkins-bot:
[mediawiki/extensions/Nuke@master] Queue deletion job instead of trying to delete the pages
Change 736284 had a related patch set uploaded (by Reedy; author: Amir Sarabadani):
[mediawiki/extensions/Nuke@REL1_37] Queue deletion job instead of trying to delete the pages
Change 736288 had a related patch set uploaded (by Reedy; author: Amir Sarabadani):
[mediawiki/extensions/Nuke@REL1_36] Queue deletion job instead of trying to delete the pages
Change 736291 had a related patch set uploaded (by Reedy; author: Amir Sarabadani):
[mediawiki/extensions/Nuke@REL1_35] Queue deletion job instead of trying to delete the pages
Change 736284 merged by jenkins-bot:
[mediawiki/extensions/Nuke@REL1_37] Queue deletion job instead of trying to delete the pages
Change 736291 merged by jenkins-bot:
[mediawiki/extensions/Nuke@REL1_35] Queue deletion job instead of trying to delete the pages
Change 736288 merged by jenkins-bot:
[mediawiki/extensions/Nuke@REL1_36] Queue deletion job instead of trying to delete the pages
Change 487641 merged by jenkins-bot:
[mediawiki/extensions/Nuke@master] Don't use GROUP BY in getNewPages