Page MenuHomePhabricator

Loading RC on en.wikipedia with a specific set of filters throws out an exception
Open, Needs TriagePublicPRODUCTION ERROR

Description

When loading https://en.wikipedia.org/w/index.php?damaging=verylikelybad&goodfaith=likelybad%3Bverylikelybad&userExpLevel=unregistered%3Bnewcomer%3Blearner&hidemyself=1&hidepreviousrevisions=1&hideWikibase=1&hidelog=1&limit=1000&days=30&damaging__verylikelybad_color=c5&title=Special:RecentChanges&urlversion=2 I get an WMFTimeoutException instead of the normal recent changes page. This doesn't happen on any other page, or recent changes with other filters

[YESs-ymFrvi8w6994LcImgAAAAM] 2021-03-07 10:39:03: Fatal exception of type "WMFTimeoutException"
from /srv/mediawiki/wmf-config/set-time-limit.php(41)
#0 /srv/mediawiki/php-1.36.0-wmf.33/includes/exception/MWExceptionHandler.php(208): {closure}(integer)
#1 [internal function]: MWExceptionHandler::handleError(integer, string, string, integer, array)
#2 /srv/mediawiki/php-1.36.0-wmf.33/includes/libs/rdbms/database/DatabaseMysqli.php(46): mysqli->query(string)
#3 /srv/mediawiki/php-1.36.0-wmf.33/includes/libs/rdbms/database/Database.php(1380): Wikimedia\Rdbms\DatabaseMysqli->doQuery(string)
#4 /srv/mediawiki/php-1.36.0-wmf.33/includes/libs/rdbms/database/Database.php(1298): Wikimedia\Rdbms\Database->executeQueryAttempt(string, string, boolean, string, integer)
#5 /srv/mediawiki/php-1.36.0-wmf.33/includes/libs/rdbms/database/Database.php(1227): Wikimedia\Rdbms\Database->executeQuery(string, string, integer)

Details

Request ID
YESs-ymFrvi8w6994LcImgAAAAM

Event Timeline

Aklapper changed the subtype of this task from "Task" to "Production Error".
Aklapper set Request ID to YESs-ymFrvi8w6994LcImgAAAAM.Mar 7 2021, 11:31 AM
Aklapper edited Stack Trace. (Show Details)
Aklapper set Phatality ID to 36d06658889351388ef55f9d479e2b5996df8f252eeecfdb32d66e7ad9c23e45.

Smaller limits are working, but feeling slow to load

https://en.wikipedia.org/w/index.php?damaging=verylikelybad&goodfaith=likelybad%3Bverylikelybad&userExpLevel=unregistered%3Bnewcomer%3Blearner&hidemyself=1&hidepreviousrevisions=1&hideWikibase=1&hidelog=1&limit=10&days=3&damaging__verylikelybad_color=c5&title=Special:RecentChanges&urlversion=2

Needing the sql which is running here to get a EXPLAIN for index usage

There are also other timeouts for the recentchanges (T239192, T256937), but that could be related to installed extensions or filters and not a duplicate of this one.