[Wikidata-bugs] [Maniphest] [Commented On] T160887: Wikibase\Repo\Store\Sql\SqlEntitiesWithoutTermFinder::getEntitiesWithoutTerm can take 19 hours to execute and it is run by the web requests user

[jcrespo]

jcrespo added a comment.

This is ongoing right now, for example:

db1082	307726822	wikiuser	mw1248	wikidatawiki	4m
SELECT /* Wikibase\Repo\Store\Sql\SqlEntitiesWithoutTermFinder::getEntitiesWithoutTerm */ page_title AS `entity_id_serialization` FROM `page` LEFT JOIN `wb_terms` ON ((((term_entity_id = REPLACE(page_title, 'Q', '')) AND term_entity_type = 'item' AND page_namespace = '0') OR ((term_entity_id = REPLACE(page_title, 'P', '')) AND term_entity_type = 'property' AND page_namespace = '120')) AND term_type = 'label' AND term_language = 'en') WHERE (term_entity_type IS NULL) AND page_is_redirect = '0' AND page_namespace IN ('0','120') ORDER BY page_id DESC LIMIT 51

TASK DETAIL

https://phabricator.wikimedia.org/T160887

EMAIL PREFERENCES

https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: jcrespo
Cc: Lydia_Pintscher, thiemowmde, Marostegui, aude, hoo, daniel, Aklapper, jcrespo, QZanden, Minhnv-2809, D3r1ck01, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair

_______________________________________________
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs