I'm trying to access to view archive_userindex to read some stats for deleted revisions (as it's indicated in wikitech).
I'm tried to read the view and there is no rows returned, but in other replicas (such as enwiki_p or frwiki_p) returns rows.
Example:
use eswiki_p; select count(1) from archive_userindex;
Expected results
count(1) ~ 200000 rows
Actual results
count(1) = 0 rows
Regards
This works with the new replicas, please switch to use them (https://phabricator.wikimedia.org/phame/post/view/70/new_wiki_replica_servers_ready_for_use/)
mysql:root@localhost [eswiki_p]> use eswiki_p; select count(1) from archive_userindex; Database changed +----------+ | count(1) | +----------+ | 8063778 | +----------+ 1 row in set (7.07 sec) mysql:root@localhost [(none)]> select @@hostname; +------------+ | @@hostname | +------------+ | labsdb1009 | +------------+ 1 row in set (0.00 sec)