Last modified: 2013-09-02 18:37:22 UTC
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;
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).
*** Bug 52744 has been marked as a duplicate of this bug. ***
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.