Pretty much everyone who's dealt with creating views for new wikis on the
labs hosts have experienced issues with "Access denied" sometimes.
This was usually due to the MariaDB grant role being missed. We tried to
workaround this by including the grant addition on the maintain-views
Unfortunately, we ran into very weird problems when doing so and this is an
After lots of back and forth we decided to create a bug to MariaDB (
https://jira.mariadb.org/browse/MDEV-16466) which was confirmed by MariaDB
yesterday and pointed to a similar issue (
The expected fix will come in 10.4 (we are in 10.1), so quite long ahead of
So, for now, the workaround before adding new views is to manually add the
GRANT on the DB and then run the script:
GRANT SELECT, SHOW VIEW ON `newiki\_p`.* to labsdbuser';
Hopefully with this email everyone is on the same page now.
Thanks everyone (specially Brooke for helping me out with the
Today the wikibugs bot sends patches to #wikimedia-cloud and bugs to
I would like to propose that we only have the wikibugs bot
broadcasting things on #wikimedia-cloud-feed.
This would have a few benefits, in my opinion:
* #wikimedia-cloud gets more space for undistracted conversations
* #wikimedia-cloud-feed becomes the sole source for updates (easier
mental processing for some people like me)
Does anyone have any concerns with this proposal?
Wikimedia Cloud Services
Brooke already started refactoring puppet code for toolforge-stretch,
and both Giovanni and me are following with other side of the code
(currently, service nodes T207591).
I'm starting with the refactor myself and I have some doubts on how to
better organize the code.
I think it's really important we agree on how to do this beforehand,
and also I may lack some knowledge on best practices etc, so I'm
sharing some ideas for you to comment on.
The following wikitech page contains 3 model options I think can be applied:
Brooke has probably some ideas on this, since she already started.
Please comment, and forgive my ignorance if the answer to my questions
PD: CC'ing Chase, because he did the massive CloudVPS refactor in the past.