Page MenuHomePhabricator

[1.31.0-wmf.1] RC page - Fatal exception of type "Wikimedia\Rdbms\DBQueryTimeoutError" for a saved filter
Closed, DuplicatePublic

Description

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"

https://en.wikipedia.org/wiki/Special:RecentChanges?limit=150&days=17&urlversion=2&hideWikibase=1&hidelog=1&damaging=verylikelybad&hidebots=1&namespace=1%3B2%3B3

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptSep 28 2017, 9:17 PM

Now is ok, but so slow loading.

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}
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}

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 150

The changes to watchlist to not use STRAIGHT_JOIN fixed this. Especially because the user in question only has 12 items on their watchlist.

mmodell changed the subtype of this task from "Task" to "Production Error".Aug 28 2019, 11:09 PM