Page MenuHomePhabricator

DBQueryTimeoutError on Wikidata's Special:Nuke
Open, NormalPublic

Description

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.

Event Timeline

abian created this task.Dec 29 2018, 7:27 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptDec 29 2018, 7:27 PM

Does it happen all the time or was it a punctual error?

abian added a comment.Dec 29 2018, 7:41 PM

It happens every time I leave the pattern field blank, even when the maximum number of pages is, for example, 5.

herron triaged this task as Normal priority.Jan 2 2019, 5:41 PM

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

https://gerrit.wikimedia.org/r/487641

Addshore moved this task from incoming to in progress on the Wikidata board.Feb 11 2019, 8:59 AM

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

mmodell changed the subtype of this task from "Task" to "Production Error".Aug 28 2019, 11:08 PM