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
