Page MenuHomePhabricator

Prepare and check storage layer for blkwiki
Closed, ResolvedPublic

Description

The new wiki's visibility will be: Public.

Event Timeline

Marostegui moved this task from Triage to Blocked on the DBA board.
Marostegui added a subscriber: Marostegui.

Let us know when the wiki is created so we can sanitize it.

Zabe changed the edit policy from "Custom Policy" to "All Users".Jun 21 2022, 11:36 AM
Urbanecm added a subscriber: Urbanecm.

Let us know when the wiki is created so we can sanitize it.

This just happened. Other scheduled wikis won't be created today (because of T313302), so this task should be ready whenever the DBAs are.

I have sanitized eqiad and created the _p database as well as added grants to labsdbuser.
However, I need to wait for codfw, as there's a schema change happening there, which has replication stopped on the master and thus the database hasn't been created yet on codfw sanitarium.
It will hopefully be finished today or tomorrow.

Still waiting for the change to arrive to sanitarium codfw.

Marostegui moved this task from In progress to Done on the DBA board.

All done check_private_data reports all clean, this is ready for the views creation.

BTullis edited projects, added Data-Engineering; removed Data-Engineering-Planning.
BTullis moved this task from Incoming to Ops on the Data-Engineering board.

Change 878930 had a related patch set uploaded (by Btullis; author: Btullis):

[operations/cookbooks@master] Allow the wikireplicas.add-wiki cookbook to replace existing views

https://gerrit.wikimedia.org/r/878930

Change 878930 merged by Btullis:

[operations/cookbooks@master] Allow the wikireplicas.add-wiki cookbook to replace existing views

https://gerrit.wikimedia.org/r/878930

Mentioned in SAL (#wikimedia-operations) [2023-01-11T18:22:49Z] <btullis@cumin1001> Added views for new wiki: blkwiki T310872

I believe that this is complete now.

btullis@tools-sgebastion-10:~$ sql blkwiki "select * from page limit 2"
+---------+----------------+-----------------+------------------+-------------+----------------+----------------+--------------------+-------------+----------+--------------------+-----------+
| page_id | page_namespace | page_title      | page_is_redirect | page_is_new | page_random    | page_touched   | page_links_updated | page_latest | page_len | page_content_model | page_lang |
+---------+----------------+-----------------+------------------+-------------+----------------+----------------+--------------------+-------------+----------+--------------------+-----------+
|       2 |              8 | Sitesupport-url |                0 |           1 | 0.702117801822 | 20220719112245 | 20220719112245     |           2 |      109 | wikitext           | NULL      |
|       3 |              2 | Meno25          |                0 |           1 | 0.868882229591 | 20220719120504 | 20220719120454     |           3 |       78 | wikitext           | NULL      |
+---------+----------------+-----------------+------------------+-------------+----------------+----------------+--------------------+-------------+----------+--------------------+-----------+