[Wikidata-bugs] [Maniphest] [Created] T172036: EntityUsageTable::getAffectedRowIds runs overly large queries

[hoo]

hoo created this task. hoo added projects: MediaWiki-extensions-WikibaseClient, Wikidata, Wikimedia-log-errors. Herald added subscribers: PokestarFan, Aklapper.

TASK DESCRIPTION

DBQuery ERROR: Wikibase\Client\Usage\Sql\EntityUsageTable::getAffectedRowIds   10.64.32.113    2013    Lost connection to MySQL server during query (10.64.32.113)     SELECT  eu_row_id  FROM `wbc_entity_usage`    WHERE eu_page_id = '22480131' AND ((eu_aspect = 'L.en' AND eu_entity_id = 'Q10004333') OR (eu_aspect = 'L.en' AND eu_entity_id = 'Q10005068') OR (eu_aspect = 'L.de' AND eu_entity_id = 'Q10005068') OR (eu_aspect = 'L.en' AND eu_entity_id = 'Q10005087') OR (eu_aspect = 'L.de' AND eu_entity_id = 'Q10005087') OR (eu_aspect = 'L.en' AND eu_entity_id = 'Q10005107') OR (eu_aspect = 'L.de' AND eu_entity_id = 'Q10005107') OR (eu_aspect = 'L.en' AND eu_entity_id = 'Q10005162') OR (eu_aspect = 'L.de' AND eu_entity_id = 'Q10005162') OR […]","fname":"Wikibase\\Client\\Usage\\Sql\\EntityUsageTable::getAffectedRowIds"}

(query truncated at […])

TASK DETAIL

https://phabricator.wikimedia.org/T172036

EMAIL PREFERENCES

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

To: hoo
Cc: Aklapper, PokestarFan, hoo, 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