Page MenuHomePhabricator

Table/View imagelinks in commonswiki_p throws an error
Closed, ResolvedPublicBUG REPORT

Description

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

What happens?:
View 'commonswiki_p.imagelinks' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

Event Timeline

Marostegui triaged this task as High priority.
Marostegui subscribed.

This is due to T419635 and should be fixed with T422459

I've run the maintain-views --all-databases --replace --table imagelinks cleanup on the s4 an-redacted and clouddb hosts except clouddb1019 due to https://phabricator.wikimedia.org/T423151 , can you please let me know if it's fixed?

FCeratto-WMF moved this task from Triage to Done on the DBA board.

Ok, thanks