Author: metatron
Description:
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
Version: unspecified
Severity: normal
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 :-).
(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.