[Wikidata-bugs] [Maniphest] [Commented On] T173008: Create a maintenance script for pruning stale entity subscriptions and run periodically

[hoo]

hoo added a comment.

In T173008#3516026, @Esc3300 wrote:

Entities where client wikis think they are subscribed to, but Wikidata doesn't dispatch any change as the entry in its list is missing.

That is not a problem:

MariaDB [wikidatawiki_p]> SELECT COUNT(DISTINCT eu_entity_id) FROM ruwiki_p.wbc_entity_usage WHERE eu_entity_id NOT IN (SELECT cs_entity_id FROM wb_changes_subscription WHERE cs_subscriber_id = 'ruwiki');
+------------------------------+
| COUNT(DISTINCT eu_entity_id) |
+------------------------------+
|                            0 |
+------------------------------+
1 row in set (2 min 41.57 sec)

MariaDB [wikidatawiki_p]> SELECT COUNT(DISTINCT eu_entity_id) FROM cawiki_p.wbc_entity_usage WHERE eu_entity_id NOT IN (SELECT cs_entity_id FROM wb_changes_subscription WHERE cs_subscriber_id = 'cawiki');
+------------------------------+
| COUNT(DISTINCT eu_entity_id) |
+------------------------------+
|                            1 |
+------------------------------+
1 row in set (1 min 38.99 sec)

TASK DETAIL

https://phabricator.wikimedia.org/T173008

EMAIL PREFERENCES

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

To: hoo
Cc: Esc3300, Ladsgroup, daniel, aude, Aklapper, PokestarFan, hoo, GoranSMilovanovic, QZanden, Izno, Wikidata-bugs, Mbch331

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