Daimona added a comment.
name=message [XLxsMQpAADsAAImQla8AAACB] /w/index.php?title=Special:Contributions&offset=20190418104744&limit=1&target=KrBot WMFTimeoutException from line 39 of /srv/mediawiki/wmf-config/set-time-limit.php: the execution time limit of 60 seconds was exceeded name=trace #0 /srv/mediawiki/php-1.34.0-wmf.1/includes/exception/MWExceptionHandler.php(196): {closure}(integer) #1 [internal function]: MWExceptionHandler::handleError(integer, string, string, integer, array) #2 /srv/mediawiki/php-1.34.0-wmf.1/includes/libs/rdbms/database/DatabaseMysqli.php(46): mysqli->query(string) #3 /srv/mediawiki/php-1.34.0-wmf.1/includes/libs/rdbms/database/Database.php(1322): Wikimedia\Rdbms\DatabaseMysqli->doQuery(string) #4 /srv/mediawiki/php-1.34.0-wmf.1/includes/libs/rdbms/database/Database.php(1224): Wikimedia\Rdbms\Database->attemptQuery(string, string, boolean, string) #5 /srv/mediawiki/php-1.34.0-wmf.1/includes/libs/rdbms/database/Database.php(1784): Wikimedia\Rdbms\Database->query(string, string) #6 /srv/mediawiki/php-1.34.0-wmf.1/includes/specials/pagers/ContribsPager.php(205): Wikimedia\Rdbms\Database->select(array, array, array, string, array, array) #7 /srv/mediawiki/php-1.34.0-wmf.1/includes/pager/IndexPager.php(249): ContribsPager->reallyDoQuery(string, integer, boolean) #8 /srv/mediawiki/php-1.34.0-wmf.1/includes/pager/IndexPager.php(602): IndexPager->doQuery() #9 /srv/mediawiki/php-1.34.0-wmf.1/includes/specials/SpecialContributions.php(236): IndexPager->getNumRows() #10 /srv/mediawiki/php-1.34.0-wmf.1/includes/specialpage/SpecialPage.php(569): SpecialContributions->execute(NULL) #11 /srv/mediawiki/php-1.34.0-wmf.1/includes/specialpage/SpecialPageFactory.php(578): SpecialPage->run(NULL) #12 /srv/mediawiki/php-1.34.0-wmf.1/includes/MediaWiki.php(288): MediaWiki\Special\SpecialPageFactory->executePath(Title, RequestContext) #13 /srv/mediawiki/php-1.34.0-wmf.1/includes/MediaWiki.php(865): MediaWiki->performRequest() #14 /srv/mediawiki/php-1.34.0-wmf.1/includes/MediaWiki.php(515): MediaWiki->main() #15 /srv/mediawiki/php-1.34.0-wmf.1/index.php(42): MediaWiki->run() #16 /srv/mediawiki/w/index.php(3): require(string) #17 {main} And this doesn't tell much. OTOH, I could find the culprit query on tendril, at least the one for KrBot's contributions with offset = 20190418104744 and limit 1. Given that I couldn't find any private data in there, here is the paste: SELECT /* IndexPager::buildQueryInfo (contributions page unfiltered) */ rev_page, rev_minor_edit, rev_deleted, rev_len, rev_parent_id, rev_sha1, comment_rev_comment.comment_text AS `rev_comment_text`, comment_rev_comment.comment_data AS `rev_comment_data`, comment_rev_comment.comment_id AS `rev_comment_cid`, actor_rev_user.actor_user AS `rev_user`, actor_rev_user.actor_name AS `rev_user_text`, temp_rev_user.revactor_actor AS `rev_actor`, page_namespace, page_title, page_id, page_latest, page_is_redirect, page_len, user_name, page_is_new, revactor_timestamp AS `rev_timestamp`, revactor_rev AS `rev_id`, (SELECT GROUP_CONCAT(ctd_name SEPARATOR ', ') FROM `change_tag` JOIN `change_tag_def` ON ((ct_tag_id=ctd_id)) WHERE ct_rev_id=rev_id ) AS `ts_tags`, ores_damaging_cls.oresc_probability AS `ores_damaging_score`, 0.387 AS `ores_damaging_threshold` FROM `revision` JOIN `revision_comment_temp` `temp_rev_comment` ON ((temp_rev_comment.revcomment_rev = rev_id)) JOIN `comment` `comment_rev_comment` ON ((comment_rev_comment.comment_id = temp_rev_comment.revcomment_comment_id)) JOIN `revision_actor_temp` `temp_rev_user` FORCE INDEX (actor_timestamp) ON ((temp_rev_user.revactor_rev = rev_id)) JOIN `actor` `actor_rev_user` ON ((actor_rev_user.actor_id = temp_rev_user.revactor_actor)) JOIN `page` ON ((page_id = rev_page)) LEFT JOIN `user` ON ((actor_rev_user.actor_user != 0) AND (user_id = actor_rev_user.actor_user)) LEFT JOIN `ores_classification` `ores_damaging_cls` ON (ores_damaging_cls.oresc_model = '11' AND (ores_damaging_cls.oresc_rev=rev_id) AND ores_damaging_cls.oresc_class = '1') WHERE ((temp_rev_user.revactor_actor = '122')) AND ((rev_deleted & 12) != 12) AND (rev_timestamp>='20190418104744') ORDER BY rev_timestamp, rev_id LIMIT 1 I'd like to provide an EXPLAIN for it, but the revision_comment_temp table is not available on quarry, nor in the sql optimizer. TASK DETAIL https://phabricator.wikimedia.org/T221380 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Daimona Cc: Daimona, matej_suchanek, MisterSynergy, Framawiki, TerraCodes, Liuxinyu970226, Aklapper, Jc86035, alaa_wmde, DannyS712, Nandana, Lahi, Gq86, Lsherwinforone, GoranSMilovanovic, Jayprakash12345, QZanden, LawExplorer, Sethakill, _jensen, rosalieper, Wong128hk, Wikidata-bugs, aude, Mbch331
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs