MariaDB [dewiki_p]> select * from page limit 10;
ERROR 1356 (HY000): View 'dewiki_p.page' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Same works fine in database enwiki_p
Description
Description
Related Objects
Related Objects
- Mentioned Here
- T86342: Dropping page.page_no_title_convert on wmf databases
Event Timeline
Comment Actions
@Wurgl: Hi, please read https://www.mediawiki.org/wiki/How_to_report_a_bug and provide clear steps to reproduce.
Where do you access dewiki_p? Is this about Quarry? Somewhere on Toolforge? Some local download of datasets? Something else?
Comment Actions
I accessed it from tools-bastion-02 with some script. Could be reproduces with command line
mysql --defaults-file=$HOME/replica.my.cnf --database=dewiki_p --host=dewiki.analytics.db.svc.eqiad.wmflabs
The error showed up at 09:07:28 UTC
Comment Actions
That was because of T86342 - removing a column means the view is broken until we recreate it without that column. I ran the re-creation of the view as soon as the change was replicated to all the hosts. That's why it didn't last long :-)
for i in labsdb1009 labsdb1010 labsdb1011; do echo $i; mysql.py -h$i dewiki_p -e "select * from page limit 1;";done labsdb1009 +---------+----------------+--------------+-------------------+------------------+-------------+--------------------+----------------+--------------------+-------------+----------+--------------------+-----------+ | page_id | page_namespace | page_title | page_restrictions | page_is_redirect | page_is_new | page_random | page_touched | page_links_updated | page_latest | page_len | page_content_model | page_lang | +---------+----------------+--------------+-------------------+------------------+-------------+--------------------+----------------+--------------------+-------------+----------+--------------------+-----------+ | 1 | 0 | Alan_Smithee | | 0 | 0 | 0.0864337124735431 | 20190129193643 | 20190129193830 | 183851697 | 7788 | wikitext | NULL | +---------+----------------+--------------+-------------------+------------------+-------------+--------------------+----------------+--------------------+-------------+----------+--------------------+-----------+ labsdb1010 +---------+----------------+--------------+-------------------+------------------+-------------+--------------------+----------------+--------------------+-------------+----------+--------------------+-----------+ | page_id | page_namespace | page_title | page_restrictions | page_is_redirect | page_is_new | page_random | page_touched | page_links_updated | page_latest | page_len | page_content_model | page_lang | +---------+----------------+--------------+-------------------+------------------+-------------+--------------------+----------------+--------------------+-------------+----------+--------------------+-----------+ | 1 | 0 | Alan_Smithee | | 0 | 0 | 0.0864337124735431 | 20190129193643 | 20190129193830 | 183851697 | 7788 | wikitext | NULL | +---------+----------------+--------------+-------------------+------------------+-------------+--------------------+----------------+--------------------+-------------+----------+--------------------+-----------+ labsdb1011 +---------+----------------+--------------+-------------------+------------------+-------------+--------------------+----------------+--------------------+-------------+----------+--------------------+-----------+ | page_id | page_namespace | page_title | page_restrictions | page_is_redirect | page_is_new | page_random | page_touched | page_links_updated | page_latest | page_len | page_content_model | page_lang | +---------+----------------+--------------+-------------------+------------------+-------------+--------------------+----------------+--------------------+-------------+----------+--------------------+-----------+ | 1 | 0 | Alan_Smithee | | 0 | 0 | 0.0864337124735431 | 20190129193643 | 20190129193830 | 183851697 | 7788 | wikitext | NULL | +---------+----------------+--------------+-------------------+------------------+-------------+--------------------+----------------+--------------------+-------------+----------+--------------------+-----------+