List of steps to reproduce (step by step, including full links if applicable):
What happens?:
Error message "View 'commonswiki_p.wb_changes_dispatch' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them" can be seen
What should have happened instead?:
No such message ;^)
Remark: It seems that the table was removed, so the view should be removed too.
| Subject | Repo | Branch | Lines +/- | |
|---|---|---|---|---|
| wikireplicas: remove wb_changes_dispatch view for dropped table | operations/puppet | production | +0 -2 |
Change 773614 had a related patch set uploaded (by Razzi; author: Razzi):
[operations/puppet@production] wikireplicas: remove wb_changes_dispatch view for dropped table
Change 773614 merged by Razzi:
[operations/puppet@production] wikireplicas: remove wb_changes_dispatch view for dropped table
This is done. Since none of the views were changing but passing --replace-all was hanging since some views were currently in use, I told every "replace" prompt "no" with the following:
yes n | sudo maintain-views --databases commonswiki --clean
Which gave output like:
View already exists. Replace? [y/N] 2022-04-27 19:02:19,518 INFO [commonswiki_p.linter] View already exists. Replace? [y/N] ... ... 2022-04-27 19:02:19,846 INFO cleanup is enabled 2022-04-27 19:02:19,848 INFO cleaning 1 tables 2022-04-27 19:02:19,848 INFO Dropping view commonswiki_p.wb_changes_dispatch
I ran that on clouddb 1015, 1019, and 1021. It looks like wikis other than commonswiki didn't have this table to begin with.