Page MenuHomePhabricator

WMFTimeoutException on commonswiki on Special:RecentChanges: the execution time limit of 60 seconds was exceeded
Closed, DeclinedPublicPRODUCTION ERROR

Description

When I access https://commons.wikimedia.org/w/index.php?title=Special:RecentChanges&hideliu=1&hideanons=0

I get error appear:

[8fafc103-922c-4da6-9ae7-1685823670e1] 2020-07-02 05:04:03: Kekecualian fatal tipe "WMFTimeoutException

Details

Request ID
8fafc103-922c-4da6-9ae7-1685823670e1
Request URL
https://commons.wikimedia.org/w/index.php?title=Special:RecentChanges&hideliu=1&hideanons=0
Stack Trace
	#0 /srv/mediawiki/php-1.35.0-wmf.39/includes/exception/MWExceptionHandler.php(208): {closure}(integer)
#1 [internal function]: MWExceptionHandler::handleError(integer, string, string, integer, array)
#2 /srv/mediawiki/php-1.35.0-wmf.39/includes/libs/rdbms/database/DatabaseMysqli.php(46): mysqli->query(string)
#3 /srv/mediawiki/php-1.35.0-wmf.39/includes/libs/rdbms/database/Database.php(1308): Wikimedia\Rdbms\DatabaseMysqli->doQuery(string)
#4 /srv/mediawiki/php-1.35.0-wmf.39/includes/libs/rdbms/database/Database.php(1226): Wikimedia\Rdbms\Database->executeQueryAttempt(string, string, boolean, string, integer)
#5 /srv/mediawiki/php-1.35.0-wmf.39/includes/libs/rdbms/database/Database.php(1159): Wikimedia\Rdbms\Database->executeQuery(string, string, integer)
#6 /srv/mediawiki/php-1.35.0-wmf.39/includes/libs/rdbms/database/Database.php(1829): Wikimedia\Rdbms\Database->query(string, string, integer)
#7 /srv/mediawiki/php-1.35.0-wmf.39/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->select(array, array, array, string, array, array)
#8 /srv/mediawiki/php-1.35.0-wmf.39/includes/libs/rdbms/database/DBConnRef.php(313): Wikimedia\Rdbms\DBConnRef->__call(string, array)
#9 /srv/mediawiki/php-1.35.0-wmf.39/includes/specials/SpecialRecentChanges.php(377): Wikimedia\Rdbms\DBConnRef->select(array, array, array, string, array, array)
#10 /srv/mediawiki/php-1.35.0-wmf.39/includes/specialpage/ChangesListSpecialPage.php(1025): SpecialRecentChanges->doMainQuery(array, array, array, array, array, FormOptions)
#11 /srv/mediawiki/php-1.35.0-wmf.39/includes/specialpage/ChangesListSpecialPage.php(630): ChangesListSpecialPage->getRows()
#12 /srv/mediawiki/php-1.35.0-wmf.39/includes/specials/SpecialRecentChanges.php(165): ChangesListSpecialPage->execute(NULL)
#13 /srv/mediawiki/php-1.35.0-wmf.39/includes/specialpage/SpecialPage.php(580): SpecialRecentChanges->execute(NULL)
#14 /srv/mediawiki/php-1.35.0-wmf.39/includes/specialpage/SpecialPageFactory.php(635): SpecialPage->run(NULL)
#15 /srv/mediawiki/php-1.35.0-wmf.39/includes/MediaWiki.php(307): MediaWiki\SpecialPage\SpecialPageFactory->executePath(Title, RequestContext)
#16 /srv/mediawiki/php-1.35.0-wmf.39/includes/MediaWiki.php(986): MediaWiki->performRequest()
#17 /srv/mediawiki/php-1.35.0-wmf.39/includes/MediaWiki.php(543): MediaWiki->main()
#18 /srv/mediawiki/php-1.35.0-wmf.39/index.php(53): MediaWiki->run()
#19 /srv/mediawiki/php-1.35.0-wmf.39/index.php(46): wfIndexMain()
#20 /srv/mediawiki/w/index.php(3): require(string)
#21 {main}

Event Timeline

Aklapper changed the subtype of this task from "Bug Report" to "Production Error".Jul 2 2020, 7:20 AM
Aklapper renamed this task from Internal problem in commonswiki to WMFTimeoutException on commonswiki on Special:RecentChanges: the execution time limit of 60 seconds was exceeded.Jul 2 2020, 8:38 AM
Aklapper set Request URL to https://commons.wikimedia.org/w/index.php?title=Special:RecentChanges&hideliu=1&hideanons=0.
Aklapper set Request ID to 8fafc103-922c-4da6-9ae7-1685823670e1.
Aklapper edited Stack Trace. (Show Details)
Aklapper set Phatality ID to 36d06658889351388ef55f9d479e2b5996df8f252eeecfdb32d66e7ad9c23e45.

The url is redirect due to use of structed rcfilters as default on commons. It is possible to disable it the user settings and getting the right page.

hideliu = 1 means: Hide edits by logged in users
hideanons = 0 means: Show edits by anonymous users [This could be omitted as it is default]

Maybe there are more user settings which are not shown by the url filters, but can have impact on the database query, like a high limit for recent changes

It is possible to list your selected options from https://commons.wikimedia.org/wiki/Special:Preferences#mw-prefsection-rc ?

Krinkle subscribed.

T276523 and T276699 have the same Phatality ID

All timeouts have the same "message" and thus the same ID, but are otherwise not related usually. Tasks tend to be by affected feature or root cause, e.g. the feature where the timeout happens.

Im closing this since I tried to load this both logged-in and logged-out and it works fine. Timeouts do happen from time to time, but if they're not persistent, and don't significnatly affect some users, wikis or features more than others, we generally can't do much about them unless we know of specific sub components that need to be better. e.g. this might not have anything to od with recent changes.