Loading a saved filter on enwiki RC page produced the following error (and 1 min timeout)
[Wc1hmwpAMCYAAA2SOVgAAAAX] 2017-09-28 20:55:51: Fatal exception of type "Wikimedia\Rdbms\DBQueryTimeoutError"
Description
Description
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | • DannyH | T171977 Annual Plan 2017-2018, Audiences 5: Increase current editor retention and engagement | |||
| Resolved | • DannyH | T171981 Annual Plan 2017-2018, Audiences 5, Goal 2: Give better ways to monitor contributions | |||
| Resolved | • jmatazzoni | T157642 Graduate New Filters UX out of beta on Recent Changes on ALL wikis | |||
| Resolved | • jmatazzoni | T163757 ORES on en.wiki chokes on "V. likely good faith" + "Likely have problems" | |||
| Declined | None | T164796 Very long search times on RC Page for "Very likely good faith" + "Likely have problems" (on en.wiki only?) | |||
| Open | None | T168096 Special:RecentChanges with complex query (rc_namespace = 1 AND ct_tag = 'visualeditor') slow due to using wrong index | |||
| Duplicate | PRODUCTION ERROR | None | T177026 [1.31.0-wmf.1] RC page - Fatal exception of type "Wikimedia\Rdbms\DBQueryTimeoutError" for a saved filter |
Event Timeline
Comment Actions
2017-09-28T20:55:51
A database query timeout has occurred.
Error: 2062 Read timeout is reached (10.64.32.25)
#0 /srv/mediawiki/php-1.31.0-wmf.1/includes/libs/rdbms/database/Database.php(979): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
#1 /srv/mediawiki/php-1.31.0-wmf.1/includes/libs/rdbms/database/Database.php(1361): Wikimedia\Rdbms\Database->query(string, string)
#2 /srv/mediawiki/php-1.31.0-wmf.1/includes/specials/SpecialRecentchanges.php(358): Wikimedia\Rdbms\Database->select(array, array, array, string, array, array)
#3 /srv/mediawiki/php-1.31.0-wmf.1/includes/specialpage/ChangesListSpecialPage.php(746): SpecialRecentChanges->doMainQuery(array, array, array, array, array, FormOptions)
#4 /srv/mediawiki/php-1.31.0-wmf.1/includes/specialpage/ChangesListSpecialPage.php(543): ChangesListSpecialPage->getRows()
#5 /srv/mediawiki/php-1.31.0-wmf.1/includes/specials/SpecialRecentchanges.php(166): ChangesListSpecialPage->execute(NULL)
#6 /srv/mediawiki/php-1.31.0-wmf.1/includes/specialpage/SpecialPage.php(522): SpecialRecentChanges->execute(NULL)
#7 /srv/mediawiki/php-1.31.0-wmf.1/includes/specialpage/SpecialPageFactory.php(578): SpecialPage->run(NULL)
#8 /srv/mediawiki/php-1.31.0-wmf.1/includes/MediaWiki.php(287): SpecialPageFactory::executePath(Title, RequestContext)
#9 /srv/mediawiki/php-1.31.0-wmf.1/includes/MediaWiki.php(851): MediaWiki->performRequest()
#10 /srv/mediawiki/php-1.31.0-wmf.1/includes/MediaWiki.php(523): MediaWiki->main()
#11 /srv/mediawiki/php-1.31.0-wmf.1/index.php(43): MediaWiki->run()
#12 /srv/mediawiki/w/index.php(3): include(string)
#13 {main}Comment Actions
The query was:
SELECT /*! STRAIGHT_JOIN */ rc_id,rc_timestamp,rc_user,rc_user_text,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_comment AS `rc_comment_text`,NULL AS `rc_comment_data`,NULL AS `rc_comment_cid`,wl_user,wl_notificationtimestamp,page_latest,(SELECT GROUP_CONCAT(ct_tag SEPARATOR ',') FROM `change_tag` WHERE ct_rc_id=rc_id ) AS `ts_tags`,fp_stable,fp_pending_since,ores_damaging_cls.oresc_probability AS `ores_damaging_score`,ores_goodfaith_cls.oresc_probability AS `ores_goodfaith_score` FROM `recentchanges` LEFT JOIN `watchlist` ON (wl_user = '26209855' AND (wl_title=rc_title) AND (wl_namespace=rc_namespace)) LEFT JOIN `page` ON ((rc_cur_id=page_id)) LEFT JOIN `flaggedpages` ON ((fp_page_id = rc_cur_id)) LEFT JOIN `ores_model` `ores_damaging_mdl` ON (ores_damaging_mdl.oresm_is_current = '1' AND ores_damaging_mdl.oresm_name = 'damaging') LEFT JOIN `ores_classification` `ores_damaging_cls` ON ((ores_damaging_cls.oresc_model = ores_damaging_mdl.oresm_id) AND (rc_this_oldid = ores_damaging_cls.oresc_rev) AND ores_damaging_cls.oresc_class = '1') LEFT JOIN `ores_model` `ores_goodfaith_mdl` ON (ores_goodfaith_mdl.oresm_is_current = '1' AND ores_goodfaith_mdl.oresm_name = 'goodfaith') LEFT JOIN `ores_classification` `ores_goodfaith_cls` ON ((ores_goodfaith_cls.oresc_model = ores_goodfaith_mdl.oresm_id) AND (rc_this_oldid = ores_goodfaith_cls.oresc_rev) AND ores_goodfaith_cls.oresc_class = '1') WHERE (rc_bot = 0) AND (rc_type != '3') AND (rc_source != 'wb') AND ((ores_damaging_cls.oresc_probability BETWEEN 0.953 AND 1)) AND (rc_type NOT IN ('3','5')) AND (rc_namespace IN ('1','2','3')) AND (rc_timestamp >= '20170911205451') AND rc_new IN ('0','1') ORDER BY rc_timestamp DESC LIMIT 150The changes to watchlist to not use STRAIGHT_JOIN fixed this. Especially because the user in question only has 12 items on their watchlist.