| jcrespo added a comment. |
It is clear to me that the direct cause for connection issues is pilups coming from queries such as:
Id: 6451784424
User: wikiuser
Host: 10.64.32.35:38688
db: wikidatawiki
Command: Query
Time: 18
State: Sending data
Info: SELECT /* Wikibase\Lib\Store\Sql\SqlEntityInfoBuilder::collectTermsForEntities */ term_entity_type,term_entity_id,term_type,term_language,term_text FROM `wb_terms` WHERE term_entity_type = 'property' AND term_entity_id IN ('373','374','248','143','17','131','582','580','625','813','31','646','577','1566','18','214','268','856','2046','94','281','242','47','1082','585') AND term_type IN ('label','description') AND term_language = 'en'
Progress: 0.000That take over the available connections, as they can take 10-30 seconds to run.
TASK DETAIL
EMAIL PREFERENCES
To: jcrespo
Cc: MZMcBride, TerraCodes, Luke081515, Jay8g, Aklapper, jcrespo, D3r1ck01, Izno, Wikidata-bugs, aude, Mbch331, Krenair
Cc: MZMcBride, TerraCodes, Luke081515, Jay8g, Aklapper, jcrespo, D3r1ck01, Izno, Wikidata-bugs, aude, Mbch331, Krenair
_______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
