| Krinkle added a comment. |
Logstash shows 4 entries for that request id (WVeQXQpAIDMAAEhLwjIAAAAL). All recorded with the same timestamp.
- DBQuery (WARNING)
Wikimedia\Rdbms\Database::query: lost connection to 10.64.16.15; reconnected:
#0 /srv/mediawiki/php-1.30.0-wmf.7/includes/libs/rdbms/database/Database.php(2903): Wikimedia\Rdbms\Database->query()
#1 /srv/mediawiki/php-1.30.0-wmf.7/includes/libs/rdbms/database/Database.php(2879): Wikimedia\Rdbms\Database->doCommit()
#2 /srv/mediawiki/php-1.30.0-wmf.7/includes/libs/rdbms/database/Database.php(756): Wikimedia\Rdbms\Database->commit()
#3 /srv/mediawiki/php-1.30.0-wmf.7/includes/libs/rdbms/loadbalancer/LoadBalancer.php(1084): Wikimedia\Rdbms\Database->close()
#4 (): Closure$Wikimedia\Rdbms\LoadBalancer::closeAll()
#5 /srv/mediawiki/php-1.30.0-wmf.7/includes/libs/rdbms/loadbalancer/LoadBalancer.php(1485): call_user_func_array()
#6 /srv/mediawiki/php-1.30.0-wmf.7/includes/libs/rdbms/loadbalancer/LoadBalancer.php(1085): Wikimedia\Rdbms\LoadBalancer->forEachOpenConnection()
#7 /srv/mediawiki/php-1.30.0-wmf.7/includes/libs/rdbms/loadbalancer/LoadBalancer.php(1076): Wikimedia\Rdbms\LoadBalancer->closeAll()
#8 /srv/mediawiki/php-1.30.0-wmf.7/includes/libs/rdbms/loadbalancer/LoadBalancer.php(1665): Wikimedia\Rdbms\LoadBalancer->disable()
#9 (): Wikimedia\Rdbms\LoadBalancer->__destruct()
#10 {main}
- exception (ERROR)
A database query error has occurred. Query: SELECT rev_id,rev_page,rev_text_id,rev_timestamp,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,rev_sha1,rev_content_format,rev_content_model,user_name,page_namespace,page_title,page_is_new,page_latest,page_is_redirect,page_len,(SELECT GROUP_CONCAT(ct_tag SEPARATOR ',') FROM `change_tag` WHERE ct_rev_id=rev_id ) AS `ts_tags`,ores_damaging_cls.oresc_probability AS `ores_damaging_score`,### AS `ores_damaging_threshold` FROM `revision` FORCE INDEX (user_timestamp) INNER JOIN `page` ON ((page_id = rev_page)) LEFT JOIN `user` ON ((rev_user != 0) AND (user_id = rev_user)) LEFT JOIN `ores_model` `ores_damaging_mdl` ON (ores_damaging_mdl.oresm_is_current = # 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 (rev_id = ores_damaging_cls.oresc_rev) AND ores_damaging_cls.oresc_class = #) WHERE rev_user = ### AND (page_namespace = #) AND ((rev_deleted & #) = 0) ORDER BY rev_timestamp DESC LIMIT 51 Function: IndexPager::buildQueryInfo (contributions page filtered for namespace or RevisionDeleted edits) Error: 2062 Read timeout is reached (10.64.16.15) #0 /srv/mediawiki/php-1.30.0-wmf.7/includes/libs/rdbms/database/Database.php(975): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean) #1 /srv/mediawiki/php-1.30.0-wmf.7/includes/libs/rdbms/database/Database.php(1339): Wikimedia\Rdbms\Database->query(string, string) #2 /srv/mediawiki/php-1.30.0-wmf.7/includes/specials/pagers/ContribsPager.php(141): Wikimedia\Rdbms\Database->select(array, array, array, string, array, array) #3 /srv/mediawiki/php-1.30.0-wmf.7/includes/pager/IndexPager.php(225): ContribsPager->reallyDoQuery(string, integer, boolean) #4 /srv/mediawiki/php-1.30.0-wmf.7/includes/pager/IndexPager.php(557): IndexPager->doQuery() #5 /srv/mediawiki/php-1.30.0-wmf.7/includes/specials/SpecialContributions.php(212): IndexPager->getNumRows() #6 /srv/mediawiki/php-1.30.0-wmf.7/includes/specialpage/SpecialPage.php(522): SpecialContributions->execute(NULL) #7 /srv/mediawiki/php-1.30.0-wmf.7/includes/specialpage/SpecialPageFactory.php(579): SpecialPage->run(NULL) #8 /srv/mediawiki/php-1.30.0-wmf.7/includes/MediaWiki.php(287): SpecialPageFactory::executePath(Title, RequestContext) #9 /srv/mediawiki/php-1.30.0-wmf.7/includes/MediaWiki.php(862): MediaWiki->performRequest() #10 /srv/mediawiki/php-1.30.0-wmf.7/includes/MediaWiki.php(523): MediaWiki->main() #11 /srv/mediawiki/php-1.30.0-wmf.7/index.php(43): MediaWiki->run() #12 /srv/mediawiki/w/index.php(3): include(string) #13 {main}
- DBQuery (ERROR)
UndexPager::buildQueryInfo (contributions page filtered for namespace or RevisionDeleted edits) 10.64.16.15 2062 Read timeout is reached (10.64.16.15) SELECT rev_id ...
- DBPerformance (INFO)
Expectation (readQueryTime <= 5) by MediaWiki::main not met (actual: 60.057598829269): query: SELECT rev_id,rev_page,rev_text_id,... [TRX#43776f] #0 /srv/mediawiki/php-1.30.0-wmf.7/includes/libs/rdbms/TransactionProfiler.php(222): Wikimedia\Rdbms\TransactionProfiler->reportExpectationViolated() #1 /srv/mediawiki/php-1.30.0-wmf.7/includes/libs/rdbms/database/Database.php(1033): Wikimedia\Rdbms\TransactionProfiler->recordQueryCompletion() #2 /srv/mediawiki/php-1.30.0-wmf.7/includes/libs/rdbms/database/Database.php(933): Wikimedia\Rdbms\Database->doProfiledQuery() #3 /srv/mediawiki/php-1.30.0-wmf.7/includes/libs/rdbms/database/Database.php(1339): Wikimedia\Rdbms\Database->query() #4 /srv/mediawiki/php-1.30.0-wmf.7/includes/specials/pagers/ContribsPager.php(141): Wikimedia\Rdbms\Database->select() #5 /srv/mediawiki/php-1.30.0-wmf.7/includes/pager/IndexPager.php(225): ContribsPager->reallyDoQuery() #6 /srv/mediawiki/php-1.30.0-wmf.7/includes/pager/IndexPager.php(557): IndexPager->doQuery() #7 /srv/mediawiki/php-1.30.0-wmf.7/includes/specials/SpecialContributions.php(212): IndexPager->getNumRows() #8 /srv/mediawiki/php-1.30.0-wmf.7/includes/specialpage/SpecialPage.php(522): SpecialContributions->execute() #9 /srv/mediawiki/php-1.30.0-wmf.7/includes/specialpage/SpecialPageFactory.php(579): SpecialPage->run() #10 /srv/mediawiki/php-1.30.0-wmf.7/includes/MediaWiki.php(287): SpecialPageFactory::executePath() #11 /srv/mediawiki/php-1.30.0-wmf.7/includes/MediaWiki.php(862): MediaWiki->performRequest() #12 /srv/mediawiki/php-1.30.0-wmf.7/includes/MediaWiki.php(523): MediaWiki->main() #13 /srv/mediawiki/php-1.30.0-wmf.7/index.php(43): MediaWiki->run() #14 /srv/mediawiki/w/index.php(3): include() #15 {main}
TASK DETAIL
EMAIL PREFERENCES
To: Krinkle
Cc: Krinkle, Aklapper, Josve05a, GoranSMilovanovic, QZanden, Izno, Wikidata-bugs, aude, Mbch331, Jay8g, Krenair
Cc: Krinkle, Aklapper, Josve05a, GoranSMilovanovic, QZanden, Izno, Wikidata-bugs, aude, Mbch331, Jay8g, Krenair
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
