When I run the statement 'SHOW TABLE STATUS' on Database dewiki_p I see two tables with problems:
Field "comment' shows
"View 'dewiki_p.global_block_whitelist' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them"
similar
"View 'dewiki_p.module_deps' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them"
| Subject | Author | Repo | Branch | Lines +/- | |
|---|---|---|---|---|---|
| P:wmcs: wikireplicas: Drop module_deps view | Majavah | operations/puppet | production | +0 -1 |
global_block_whitelist was recently adjusted (T387663/T378747), and WMCS needs the views updating, which is T387663: Update views on global_block_whitelist tables.
module_deps was recently deleted from production (T379661/T385997); I suppose this task can be for the WMCS drop?
Change #1128014 had a related patch set uploaded (by Majavah; author: Majavah):
[operations/puppet@production] P:wmcs: wikireplicas: Drop module_deps view
Change #1128014 merged by Ladsgroup:
[operations/puppet@production] P:wmcs: wikireplicas: Drop module_deps view
Cookbook cookbooks.sre.wikireplicas.update-views run by ladsgroup: Started updating wiki replica views
Cookbook cookbooks.sre.wikireplicas.update-views started by ladsgroup completed:
The views were not dropped, because the maintain-views script was run without the --clean option:
--clean Clean out views from _p db that are no longer specified.
We should probably make that option enabled by default.
I noticed because I'm now running the script with --clean in T390767: Remove the compatibility layer of block schema in wikireplicas, and it's also dropping the module_deps views.