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 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
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