Last modified: 2014-06-03 17:36:57 UTC
View 'dewiki_p.hashs' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them View 'dewiki_p.links' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Per bug 52927 "hashs" was dropped, and per bug 52928 "links" was dropped. They simply need to be removed from the labs environment
Per http://bots.wmflabs.org/~wm-bot/logs/%23wikimedia-labs/20140127.txt: | [23:39:39] <Coren> bawolff: Bad timing simply then, the page table isn't redacted so the column will appear next time I run a maintain-replicas (~ every 2 months, I don't do it too often because it locks ALL THE THINGS) | [23:40:27] <Coren> I'll try to squeeze it in before I fly out. So these views should disappear either shortly before FOSDEM or after :-).
metatron: Is this still a problem or can this ticket be closed nowadays?
(In reply to Andre Klapper from comment #3) > metatron: Is this still a problem or can this ticket be closed nowadays? Still around: | MariaDB [dewiki_p]> SELECT * FROM hashs; | ERROR 1356 (HY000): View 'dewiki_p.hashs' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them | MariaDB [dewiki_p]> SELECT * FROM links; | ERROR 1356 (HY000): View 'dewiki_p.links' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them | MariaDB [dewiki_p]>
Hm, maintain-replicas doesn't actually /remove/ views it no longer cares about. I'm whipping up a script to cleanup now.
Both tables have been cleaned up.