Steps to replicate the issue (include links if applicable):
ssh USERNAME@login.toolforge.org sql fiwiki_p SELECT * FROM imagelinks LIMIT 10 ERROR 1356 (HY000): View 'fiwiki_p.imagelinks' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them MariaDB [fiwiki_p]> \q
What should have happened instead?:
ssh USERNAME@login.toolforge.org sql enwiki_p SELECT * FROM imagelinks LIMIT 10 MariaDB [enwiki_p]> select * from imagelinks limit 10; +---------+-------+-------------------+--------------+ | il_from | il_to | il_from_namespace | il_target_id | +---------+-------+-------------------+--------------+ | 12 | | 0 | 73482849 | | 39 | | 0 | 116863069 | | 303 | | 0 | 10599781 | | 303 | | 0 | 22897360 | | 303 | | 0 | 73482849 | | 308 | | 0 | 73482849 | | 324 | | 0 | 22152068 | | 324 | | 0 | 101365967 | | 324 | | 0 | 116851619 | | 324 | | 0 | 116852213 | +---------+-------+-------------------+--------------+ 10 rows in set (0.002 sec)
Other information
Least svwiki_p is also broken so i expect that there is more db:s. It could be related to T413525