While accessing the replicated databases of WMF Tool Labs using a tool and via console, I noticed that the fawiki_p database is missing the "revision" table.
I followed these steps:
ssh pietrodn@tools-login.wmflabs.org
pietrodn@tools-login:~$ sql fawiki_p
MariaDB [fawiki_p]> SHOW TABLES;
Version: unspecified
Severity: normal
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | jcrespo | T50930 Database replication problems - production and labs (tracking) | |||
| Resolved | coren | T54370 Several replicated DB are missing tables and content |
Confirmed this bug:
MariaDB [fawiki_p]> show tables like 'rev%';
Empty set (0.03 sec)
Compare to:
MariaDB [enwiki_p]> show tables like 'rev%';
+---------------------------+
| Tables_in_enwiki_p (rev%) |
+---------------------------+
| revision |
| revision_userindex |
+---------------------------+
2 rows in set (0.04 sec)
It's true in other databases like ukwiki_p as well.
It would be good if a tools lab admin could run a script or something, to see which databases are missing tables.
The database fawiki_p seems to be working fine now (ukwiki_p still doesn't). I have the same issue with frwiktionary_p:
MariaDB [frwiktionary_p]> show tables like 'rev%';
Empty set (0.03 sec)
It is also impossible to get the content of the existing tables:
MariaDB [frwiktionary_p]> select * FROM page LIMIT 1;
ERROR 1356 (HY000): View 'frwiktionary_p.page' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
So it's not only a matter of lacking tables.
I used the meta_p.wiki table to get the list of tables on tools and I quickly checked each one with a simple query. I found 4 databases with the same error:
cawiki
frwiktionary
huwiki
viwiki
They are all are on the slice s7 (as is ukwiki).
There was a bug in the maintenance script that improperly tested for some table names that would only have affected databases which once existed on another slice but had since been moved to s7.
I've fixed and reran the script on s7, and all those databases should now properly have all the relevant views.