Page MenuHomePhabricator

View 'altwiki_p.page' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Closed, ResolvedPublic

Description

It is not possible to query altwiki_p.page at the cloud replicas:

tools.martin-urbanec@tools-sgebastion-10 ~/public_html/growth-reports/community_configuration_usage
$ sql altwiki
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 142208663
Server version: 10.4.22-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [altwiki_p]> select * from page limit 1;
ERROR 1356 (HY000): View 'altwiki_p.page' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
MariaDB [altwiki_p]>

Can you fix this please?

Event Timeline

taavi subscribed.
MariaDB [altwiki_p]> select * from page limit 1;
+---------+----------------+---------------+------------------+-------------+----------------+----------------+--------------------+-------------+----------+--------------------+-----------+

Seems to have been resolved since. Sorry for the delay.