Currently when visiting https://meta.wikimedia.org/wiki/Special:RecentChanges it regularly times out with This search has timed out. You may wish to try different search parameters., this was reported by multiple users.
I found two errors in logstash, which look related.
- mwversion: 1.39.0-wmf.17
- reqId: c64b9c1e-7dee-44da-8cb7-4f363094440d
- Find reqId in Logstash
[{reqId}] {exception_url} Wikimedia\Rdbms\DBQueryTimeoutError: A database query timeout has occurred. Query: SET STATEMENT max_statement_time=30 FOR SELECT rc_id,rc_timestamp,rc_namespace,rc_title,rc_minor,rc_bot,rc_new,rc_cur_id,rc_this_oldid,rc_last
from /srv/mediawiki/php-1.39.0-wmf.17/includes/libs/rdbms/database/Database.php(1918) #0 /srv/mediawiki/php-1.39.0-wmf.17/includes/libs/rdbms/database/Database.php(1906): Wikimedia\Rdbms\Database->getQueryException(string, integer, string, string) #1 /srv/mediawiki/php-1.39.0-wmf.17/includes/libs/rdbms/database/Database.php(1880): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string) #2 /srv/mediawiki/php-1.39.0-wmf.17/includes/libs/rdbms/database/Database.php(1256): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean) #3 /srv/mediawiki/php-1.39.0-wmf.17/includes/libs/rdbms/database/Database.php(2012): Wikimedia\Rdbms\Database->query(string, string, integer) #4 /srv/mediawiki/php-1.39.0-wmf.17/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->select(array, array, array, string, array, array) #5 /srv/mediawiki/php-1.39.0-wmf.17/includes/libs/rdbms/database/DBConnRef.php(286): Wikimedia\Rdbms\DBConnRef->__call(string, array) #6 /srv/mediawiki/php-1.39.0-wmf.17/includes/specials/SpecialRecentChanges.php(431): Wikimedia\Rdbms\DBConnRef->select(array, array, array, string, array, array) #7 /srv/mediawiki/php-1.39.0-wmf.17/includes/specialpage/ChangesListSpecialPage.php(918): SpecialRecentChanges->doMainQuery(array, array, array, array, array, FormOptions) #8 /srv/mediawiki/php-1.39.0-wmf.17/includes/specialpage/ChangesListSpecialPage.php(614): ChangesListSpecialPage->getRows() #9 /srv/mediawiki/php-1.39.0-wmf.17/includes/specials/SpecialRecentChanges.php(206): ChangesListSpecialPage->execute(NULL) #10 /srv/mediawiki/php-1.39.0-wmf.17/includes/specialpage/SpecialPage.php(688): SpecialRecentChanges->execute(NULL) #11 /srv/mediawiki/php-1.39.0-wmf.17/includes/specialpage/SpecialPageFactory.php(1418): SpecialPage->run(NULL) #12 /srv/mediawiki/php-1.39.0-wmf.17/includes/MediaWiki.php(316): MediaWiki\SpecialPage\SpecialPageFactory->executePath(string, RequestContext) #13 /srv/mediawiki/php-1.39.0-wmf.17/includes/MediaWiki.php(916): MediaWiki->performRequest() #14 /srv/mediawiki/php-1.39.0-wmf.17/includes/MediaWiki.php(570): MediaWiki->main() #15 /srv/mediawiki/php-1.39.0-wmf.17/index.php(50): MediaWiki->run() #16 /srv/mediawiki/php-1.39.0-wmf.17/index.php(46): wfIndexMain() #17 /srv/mediawiki/w/index.php(3): require(string) #18 {main}
- mwversion: 1.39.0-wmf.17
- reqId: c2d0168d-3417-4abc-97e6-22b085bdb79e
- Find reqId in Logstash
[{reqId}] {exception_url} PHP Deprecated: Caller from MediaWiki\Extension\Translate\MessageGroupProcessing\RevTagStore::getLatestRevisionWithTag ignored an error originally raised from SpecialRecentChanges::doMainQuery: [1969] Query execution was interr
from /srv/mediawiki/php-1.39.0-wmf.17/includes/debug/MWDebug.php(381) #0 [internal function]: MWExceptionHandler::handleError(integer, string, string, integer, array) #1 /srv/mediawiki/php-1.39.0-wmf.17/includes/debug/MWDebug.php(381): trigger_error(string, integer) #2 /srv/mediawiki/php-1.39.0-wmf.17/includes/db/MWLBFactory.php(439): MWDebug::sendRawDeprecated(string, boolean, string) #3 [internal function]: MWLBFactory::logDeprecation(string) #4 /srv/mediawiki/php-1.39.0-wmf.17/includes/libs/rdbms/database/TransactionManager.php(216): call_user_func(array, string) #5 /srv/mediawiki/php-1.39.0-wmf.17/includes/libs/rdbms/database/Database.php(1697): Wikimedia\Rdbms\TransactionManager->assertTransactionStatus(Wikimedia\Rdbms\DatabaseMysqli, array, string) #6 /srv/mediawiki/php-1.39.0-wmf.17/includes/libs/rdbms/database/Database.php(1240): Wikimedia\Rdbms\Database->assertQueryIsCurrentlyAllowed(string, string) #7 /srv/mediawiki/php-1.39.0-wmf.17/includes/libs/rdbms/database/Database.php(2012): Wikimedia\Rdbms\Database->query(string, string, integer) #8 /srv/mediawiki/php-1.39.0-wmf.17/includes/libs/rdbms/database/Database.php(1965): Wikimedia\Rdbms\Database->select(string, string, array, string, array, array) #9 /srv/mediawiki/php-1.39.0-wmf.17/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->selectField(string, string, array, string, array) #10 /srv/mediawiki/php-1.39.0-wmf.17/includes/libs/rdbms/database/DBConnRef.php(273): Wikimedia\Rdbms\DBConnRef->__call(string, array) #11 /srv/mediawiki/php-1.39.0-wmf.17/extensions/Translate/src/MessageGroupProcessing/RevTagStore.php(70): Wikimedia\Rdbms\DBConnRef->selectField(string, string, array, string, array) #12 /srv/mediawiki/php-1.39.0-wmf.17/extensions/Translate/tag/TranslatablePage.php(322): MediaWiki\Extension\Translate\MessageGroupProcessing\RevTagStore->getLatestRevisionWithTag(Title, string) #13 /srv/mediawiki/php-1.39.0-wmf.17/extensions/Translate/tag/TranslatablePage.php(524): TranslatablePage->getMarkedTag() #14 /srv/mediawiki/php-1.39.0-wmf.17/extensions/Translate/tag/PageTranslationHooks.php(189): TranslatablePage::isTranslationPage(Title) #15 /srv/mediawiki/php-1.39.0-wmf.17/includes/HookContainer/HookContainer.php(338): PageTranslationHooks::fetchTranslatableTemplateAndTitle(Title, Title, boolean, NULL) #16 /srv/mediawiki/php-1.39.0-wmf.17/includes/HookContainer/HookContainer.php(137): MediaWiki\HookContainer\HookContainer->callLegacyHook(string, array, array, array) #17 /srv/mediawiki/php-1.39.0-wmf.17/includes/HookContainer/HookRunner.php(978): MediaWiki\HookContainer\HookContainer->run(string, array) #18 /srv/mediawiki/php-1.39.0-wmf.17/includes/parser/Parser.php(3684): MediaWiki\HookContainer\HookRunner->onBeforeParserFetchTemplateRevisionRecord(Title, Title, boolean, NULL) #19 /srv/mediawiki/php-1.39.0-wmf.17/includes/parser/Parser.php(3620): Parser->statelessFetchTemplate(Title, Parser) #20 /srv/mediawiki/php-1.39.0-wmf.17/includes/parser/Parser.php(3513): Parser->fetchTemplateAndTitle(Title) #21 /srv/mediawiki/php-1.39.0-wmf.17/includes/parser/Parser.php(3252): Parser->getTemplateDom(Title) #22 /srv/mediawiki/php-1.39.0-wmf.17/includes/parser/PPFrame_Hash.php(276): Parser->braceSubstitution(array, PPFrame_Hash) #23 /srv/mediawiki/php-1.39.0-wmf.17/includes/parser/Parser.php(2971): PPFrame_Hash->expand(PPNode_Hash_Tree, integer) #24 /srv/mediawiki/php-1.39.0-wmf.17/includes/parser/Parser.php(1607): Parser->replaceVariables(string) #25 /srv/mediawiki/php-1.39.0-wmf.17/includes/parser/Parser.php(723): Parser->internalParse(string) #26 /srv/mediawiki/php-1.39.0-wmf.17/includes/cache/MessageCache.php(1335): Parser->parse(string, Title, ParserOptions, boolean) #27 /srv/mediawiki/php-1.39.0-wmf.17/includes/specials/SpecialRecentChanges.php(736): MessageCache->parse(string, Title, boolean, boolean, LanguageEn) #28 /srv/mediawiki/php-1.39.0-wmf.17/includes/specials/SpecialRecentChanges.php(620): SpecialRecentChanges->setTopText(FormOptions) #29 /srv/mediawiki/php-1.39.0-wmf.17/includes/specialpage/ChangesListSpecialPage.php(1541): SpecialRecentChanges->doHeader(FormOptions, integer) #30 /srv/mediawiki/php-1.39.0-wmf.17/includes/specialpage/ChangesListSpecialPage.php(668): ChangesListSpecialPage->webOutputHeader(integer, FormOptions) #31 /srv/mediawiki/php-1.39.0-wmf.17/includes/specials/SpecialRecentChanges.php(206): ChangesListSpecialPage->execute(NULL) #32 /srv/mediawiki/php-1.39.0-wmf.17/includes/specialpage/SpecialPage.php(688): SpecialRecentChanges->execute(NULL) #33 /srv/mediawiki/php-1.39.0-wmf.17/includes/specialpage/SpecialPageFactory.php(1418): SpecialPage->run(NULL) #34 /srv/mediawiki/php-1.39.0-wmf.17/includes/MediaWiki.php(316): MediaWiki\SpecialPage\SpecialPageFactory->executePath(string, RequestContext) #35 /srv/mediawiki/php-1.39.0-wmf.17/includes/MediaWiki.php(916): MediaWiki->performRequest() #36 /srv/mediawiki/php-1.39.0-wmf.17/includes/MediaWiki.php(570): MediaWiki->main() #37 /srv/mediawiki/php-1.39.0-wmf.17/index.php(50): MediaWiki->run() #38 /srv/mediawiki/php-1.39.0-wmf.17/index.php(46): wfIndexMain() #39 /srv/mediawiki/w/index.php(3): require(string) #40 {main}
Example timing out SQL query:
SET STATEMENT max_statement_time=30 FOR SELECT rc_id,rc_timestamp,rc_namespace,rc_title,rc_minor,rc_bot,rc_new,rc_cur_id,rc_this_oldid,rc_last_oldid,rc_type,rc_source,rc_patrolled,rc_ip,rc_old_len,rc_new_len,rc_deleted,rc_logid,rc_log_type,rc_log_action,rc_params,rc_actor,recentchanges_actor.actor_user AS `rc_user`,recentchanges_actor.actor_name AS `rc_user_text`,comment_rc_comment.comment_text AS `rc_comment_text`,comment_rc_comment.comment_data AS `rc_comment_data`,comment_rc_comment.comment_id AS `rc_comment_cid`,rc_title,rc_namespace,wl_user,wl_notificationtimestamp,we_expiry,page_latest,(SELECT GROUP_CONCAT(ctd_name SEPARATOR ',') FROM `change_tag` JOIN `change_tag_def` ON ((ct_tag_id=ctd_id)) WHERE ct_rc_id=rc_id ) AS `ts_tags` FROM `recentchanges` JOIN `actor` `recentchanges_actor` ON ((actor_id=rc_actor)) JOIN `comment` `comment_rc_comment` ON ((comment_rc_comment.comment_id = rc_comment_id)) LEFT JOIN `watchlist` ON (wl_user = {redacted} AND (wl_title=rc_title) AND (wl_namespace=rc_namespace)) LEFT JOIN `watchlist_expiry` ON ((wl_id = we_item)) LEFT JOIN `page` ON ((rc_cur_id=page_id)) WHERE rc_bot = 0 AND (rc_type != 6) AND (rc_source != 'wb') AND (rc_namespace NOT IN (1198,1199,866,867)) AND (rc_timestamp >= '20220625123404') AND rc_new IN (0,1) ORDER BY rc_timestamp DESC LIMIT 50
And the EXPLAIN on that query:
+------+--------------------+---------------------+--------+-----------------------------------------------------------------------------------------------------------------------+--------------+---------+---------------------------------------------------------------------------+----------+------------------------------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +------+--------------------+---------------------+--------+-----------------------------------------------------------------------------------------------------------------------+--------------+---------+---------------------------------------------------------------------------+----------+------------------------------------+ | 1 | PRIMARY | recentchanges_actor | ALL | PRIMARY | NULL | NULL | NULL | 32355775 | Using temporary; Using filesort | | 1 | PRIMARY | recentchanges | ref | rc_timestamp,rc_name_type_patrolled_timestamp,rc_ns_actor,rc_actor,rc_namespace_title_timestamp,rc_new_name_timestamp | rc_actor | 8 | metawiki.recentchanges_actor.actor_id | 19 | Using index condition; Using where | | 1 | PRIMARY | comment_rc_comment | eq_ref | PRIMARY | PRIMARY | 8 | metawiki.recentchanges.rc_comment_id | 1 | | | 1 | PRIMARY | watchlist | eq_ref | wl_user,wl_user_notificationtimestamp,wl_namespace_title | wl_user | 265 | const,metawiki.recentchanges.rc_namespace,metawiki.recentchanges.rc_title | 1 | | | 1 | PRIMARY | watchlist_expiry | eq_ref | PRIMARY | PRIMARY | 4 | metawiki.watchlist.wl_id | 1 | Using where | | 1 | PRIMARY | page | eq_ref | PRIMARY | PRIMARY | 4 | metawiki.recentchanges.rc_cur_id | 1 | | | 3 | DEPENDENT SUBQUERY | change_tag | ref | ct_rc_tag_id,ct_tag_id_id | ct_rc_tag_id | 5 | metawiki.recentchanges.rc_id | 1 | Using index | | 3 | DEPENDENT SUBQUERY | change_tag_def | eq_ref | PRIMARY | PRIMARY | 4 | metawiki.change_tag.ct_tag_id | 1 | | +------+--------------------+---------------------+--------+-----------------------------------------------------------------------------------------------------------------------+--------------+---------+---------------------------------------------------------------------------+----------+------------------------------------+ 8 rows in set (0.002 sec)
List of steps to reproduce (step by step, including full links if applicable):
- Go to Special:RecentChanges on the metawiki
- https://meta.wikimedia.org/w/index.php?namespace=&tagfilter=&translations=filter&title=Special%3ARecentChanges
What happens?:
- No results are returned
- Error message: This search has timed out. You may wish to try different search parameters.
What should have happened instead?:
- The recent changes should be displayed
Software version (if not a Wikimedia wiki), browser information, screenshots, other information, etc.:
This is happening logged in or logged out, multiple browsers
Upstream MariaDB bug: MDEV-28984 - Optimizer picking the wrong table for order of join