The dewiki_p.watchlist table is missing at the labs DB. Toolserver had a sanitized view of the watchlist table, so please add the same view to labs.
*edit*
In the previous incarnation of maintain-views we had a customview defined for `watchlist`
https://gerrit.wikimedia.org/r/#/c/225218/3/maintain-replicas/maintain-replicas.pl
'watchlist_counts' => {
'source' => 'watchlist',
'view' => 'select count(*) as wl_count, wl_namespace, wl_title',
'group' => 'wl_namespace, wl_title having wl_count >= 30', },
@jcrespo created a proof of concept mechanism to curate the watchlist table at the sanitarium layer into a table called `watchlist_count` and a view was created for some wiki's (maybe only enwiki?) at that time:
https://phabricator.wikimedia.org/T138450#2401133
However, this isn't puppetized because the method wasn't reliable, and the regular update broke soon after (some tables may be there, but they are not being updated at all).
Because the `watchlist_count` table is already curated and "safe" we can add it to the fullviews array for maintain-views (then maintain-replicas) without fear. This makes the handling of this table consistent with current process. @krenair added it here to the json config for the then candidate maintain-replicas.pl replacement:
https://github.com/wikimedia/operations-software/commit/c886c32dcd94fb8937b016638036a1a6322ea95a
This has been carried over to the current iteration of maintain-views (sourced from krenairs rewrite) here https://github.com/wikimedia/operations-puppet/blob/production/modules/role/files/labsdb/maintain-views.py
The config can be seen here:
https://github.com/wikimedia/operations-puppet/blob/production/modules/role/templates/labsdb/maintain-views.yaml#L137
As it stands we need to run the current maintain-views across all labs wiki replica DBs to pickup the watchlist_count view where applicable