Please ping me (or anybody in the persistance team) when the wiki is created, and I can do the sanitzation

Mentioned in SAL (#wikimedia-operations) [2018-11-14T14:10:13Z] <Reedy> Wiki created T205714 T207584 T205713 T206916

Mentioned in SAL (#wikimedia-operations) [2018-11-15T10:07:42Z] <banyek> sanitizing db2094 ( T205714 T207584 T205713 T206916 )

Mentioned in SAL (#wikimedia-operations) [2018-11-15T10:15:31Z] <banyek> sanitizing db1124 ( T205714 T207584 T205713 T206916 )

@Banyek did GRANT this wiki into the labsdb user role grants? If not, the views will fail to be created

That and create the _p db. Silly bugs.

In T205713#4749900, @Marostegui wrote:

@Banyek did GRANT this wiki into the labsdb user role grants? If not, the views will fail to be created

No I did not. I'll look after

@Marostegui I found T178128 but it's still not clear how to GRANT this wiki (well new wikis) Could you show/tell me some more information?

So what @Bstorm refers to is to create first the views` DB (xxx_p) once that is done and due to: https://jira.mariadb.org/browse/MDEV-16466 we need to add the grants manually like this:
GRANT SELECT, SHOW VIEW ON `liwikinews\_p`.* TO 'labsdbuser';

root@labsdb1011.eqiad.wmnet[(none)]> set session sql_log_bin=0; create database liwikinews_p;
Query OK, 0 rows affected (0.00 sec)
root@labsdb1011.eqiad.wmnet[(none)]> set session sql_log_bin=0; GRANT SELECT, SHOW VIEW ON `liwikinews\_p`.* TO 'labsdbuser';
Query OK, 0 rows affected (0.00 sec)
root@labsdb1011.eqiad.wmnet[(none)]> pager grep liwikinews
PAGER set to 'grep liwikinews'
root@labsdb1011.eqiad.wmnet[(none)]> show grants for labsdbuser;
| GRANT SELECT, SHOW VIEW ON `liwikinews\_p`.* TO 'labsdbuser'             |
900 rows in set (0.00 sec)

@Bstorm I have done all that for this wiki, can you check creating the views now on all the hosts?

All set. Verified I can connect and select from cloud systems.