Page MenuHomePhabricator

Special:EditWatchlist timed out: 504 Error
Closed, DuplicatePublicPRODUCTION ERROR

Description

Error details on Meta-wiki (watchlist contains 14k pages):

Request from 37.55.255.28 via cp3052.esams.wmnet, ATS/8.0.5
Error: 504, Connection Timed Out at 2020-02-07 13:29:50 GMT

Error details on Commons (watchlist contains 12k pages):

[Xj1qkgpAAD8AABAp32MAAABA] 2020-02-07 13:49:02: Fatal exception of type "WMFTimeoutException"

Special:EditWatchlist/raw is working. Editing of smaller watchlists (3k pages on ukwiki, 400 on wmuawiki, etc.) is working.

Did I hit a ceiling of max pages in a watchlist or is there any other issue?

Details

Request ID
Xj1qkgpAAD8AABAp32MAAABA
Stack Trace

#0 /srv/mediawiki/php-1.35.0-wmf.18/includes/libs/rdbms/database/DatabaseMysqli.php(46): {closure}(integer)
#1 /srv/mediawiki/php-1.35.0-wmf.18/includes/libs/rdbms/database/Database.php(1308): Wikimedia\Rdbms\DatabaseMysqli->doQuery(string)
#2 /srv/mediawiki/php-1.35.0-wmf.18/includes/libs/rdbms/database/Database.php(1226): Wikimedia\Rdbms\Database->executeQueryAttempt(string, string, boolean, string, integer)
#3 /srv/mediawiki/php-1.35.0-wmf.18/includes/libs/rdbms/database/Database.php(1162): Wikimedia\Rdbms\Database->executeQuery(string, string, integer)
#4 /srv/mediawiki/php-1.35.0-wmf.18/includes/libs/rdbms/database/Database.php(1828): Wikimedia\Rdbms\Database->query(string, string)
#5 /srv/mediawiki/php-1.35.0-wmf.18/includes/libs/rdbms/database/Database.php(1920): Wikimedia\Rdbms\Database->select(string, array, array, string, array, array)
#6 /srv/mediawiki/php-1.35.0-wmf.18/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->selectRow(string, array, array, string)
#7 /srv/mediawiki/php-1.35.0-wmf.18/includes/libs/rdbms/database/DBConnRef.php(336): Wikimedia\Rdbms\DBConnRef->__call(string, array)
#8 /srv/mediawiki/php-1.35.0-wmf.18/includes/cache/LinkCache.php(331): Wikimedia\Rdbms\DBConnRef->selectRow(string, array, array, string)
#9 /srv/mediawiki/php-1.35.0-wmf.18/includes/cache/LinkCache.php(280): LinkCache->fetchPageRow(Wikimedia\Rdbms\MaintainableDBConnRef, Title)
#10 /srv/mediawiki/php-1.35.0-wmf.18/includes/Title.php(3195): LinkCache->addLinkObj(Title)
#11 /srv/mediawiki/php-1.35.0-wmf.18/includes/Title.php(4150): Title->getArticleID(integer)
#12 /srv/mediawiki/php-1.35.0-wmf.18/includes/Title.php(4226): Title->exists()
#13 /srv/mediawiki/php-1.35.0-wmf.18/includes/linker/LinkRenderer.php(157): Title->isKnown()
#14 /srv/mediawiki/php-1.35.0-wmf.18/includes/specials/SpecialEditWatchlist.php(680): MediaWiki\Linker\LinkRenderer->makeLink(Title, string)
#15 /srv/mediawiki/php-1.35.0-wmf.18/includes/specials/SpecialEditWatchlist.php(614): SpecialEditWatchlist->buildRemoveLine(Title)
#16 /srv/mediawiki/php-1.35.0-wmf.18/includes/specials/SpecialEditWatchlist.php(156): SpecialEditWatchlist->getNormalForm()
#17 /srv/mediawiki/php-1.35.0-wmf.18/includes/specials/SpecialEditWatchlist.php(130): SpecialEditWatchlist->executeViewEditWatchlist()
#18 /srv/mediawiki/php-1.35.0-wmf.18/includes/specialpage/SpecialPage.php(575): SpecialEditWatchlist->execute(boolean)
#19 /srv/mediawiki/php-1.35.0-wmf.18/includes/specialpage/SpecialPageFactory.php(611): SpecialPage->run(NULL)
#20 /srv/mediawiki/php-1.35.0-wmf.18/includes/MediaWiki.php(298): MediaWiki\Special\SpecialPageFactory->executePath(Title, RequestContext)
#21 /srv/mediawiki/php-1.35.0-wmf.18/includes/MediaWiki.php(967): MediaWiki->performRequest()
#22 /srv/mediawiki/php-1.35.0-wmf.18/includes/MediaWiki.php(530): MediaWiki->main()
#23 /srv/mediawiki/php-1.35.0-wmf.18/index.php(46): MediaWiki->run()
#24 /srv/mediawiki/w/index.php(3): require(string)
#25 {main}

Event Timeline

Restricted Application added subscribers: Base, Aklapper. · View Herald Transcript
Aklapper renamed this task from Special:EditWatchlist timed out to Special:EditWatchlist timed out: 504 Error.Feb 7 2020, 2:29 PM
Aklapper changed the subtype of this task from "Task" to "Production Error".
Aklapper set Request ID to Xj1qkgpAAD8AABAp32MAAABA.
Aklapper edited Stack Trace. (Show Details)
Aklapper set Phatality ID to 5e7d2fda2aeafbd8fcca99321e8dbad17d36ba13157376ed7d08a18ac9bb6f75.

Also see T243449 (though that's a 500 and not a 504)

Daimona added a subscriber: Daimona.

Unfortunately, it is a known problem that editing large watchlists causes server timeouts. I can confirm that this is T41510 striking again, based on logstash logs for the given reqId.