[Wikidata-bugs] [Maniphest] [Commented On] T179060: Dispatchers occasionally seem to "freeze" for certain wikis

[hoo]

hoo added a comment.

There are actually a lot of changes related to zhwiki happening:

mysql:wikiadmin@db1070 [wikidatawiki]> SELECT COUNT(*) FROM (SELECT * FROM recentchanges WHERE rc_source = 'mw.edit' ORDER BY rc_timestamp DESC LIMIT 100000) AS innerQ INNER JOIN wb_changes_subscription ON rc_title = cs_entity_id AND rc_namespace = 0 AND cs_subscriber_id = 'zhwiki';
+----------+
| COUNT(*) |
+----------+
|    46145 |
+----------+
1 row in set (21.56 sec)

mysql:wikiadmin@db1070 [wikidatawiki]> SELECT COUNT(*) FROM (SELECT * FROM recentchanges WHERE rc_source = 'mw.edit' ORDER BY rc_timestamp DESC LIMIT 100000) AS innerQ INNER JOIN wb_changes_subscription ON rc_title = cs_entity_id AND rc_namespace = 0 AND cs_subscrib = 'enwiki';
+----------+
| COUNT(*) |
+----------+
|     9038 |
+----------+
1 row in set (1.75 sec)

Apparently there's a bot adding a lot of Welsh descriptions to Chinese villages and that seems to be causing these problems. See https://www.wikidata.org/wiki/Special:Contributions/Danielt998.

TASK DETAIL

https://phabricator.wikimedia.org/T179060

EMAIL PREFERENCES

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

To: hoo
Cc: gerritbot, Aklapper, hoo, Lahi, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Maathavan, Wikidata-bugs, aude, Mbch331

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